STEEMSTEM || PROMOTING SCIENCE, TECHNOLOGY, ENGINEERING AND MATHEMATICS ON STEEMIT

Source: www.pixabay.com

Repository

https://github.com/steemit/steem

Introduction

What is @SteemStem?

@SteemSTEM is a community on Steemit that supports & focuses on topics related to Science, Technology, Engineering or Mathematics. Currently it supports contributions in five languages namely English, German, French, Spanish and Italian.

When you make a contribution, it is evaluated by a team of curators and if you pass all necessary checks like plagiarism, citation and refecrence, and the cotribution adds value to the community, you are upvoted

So far, steemstem has grown and there are six sub-communities of steemstem namely:

Community	Account	Tag
German	https://steemit.com/@de-stem	#de-stem
Spanish	https://steemit.com/@stem-espanol	#stem-espanol
Nigerian	https://steemit.com/@stemng	#stemng
Italian	https://steemit.com/@itastem	#itastem
French	https://steemit.com/@francostem	#francostem
Authors from Former Yugoslavia	https://steemit.com/@yu-stem	#yu-stem

If you are caught violating the rules, your steemstem career will be over because you will be blacklisted and possibly receive a visit from @steemcleaners

Outline

• Scope
• Results
• Findings
• Conclusion
• Tools and Scripts
• Relevant Links and Resources

Scope

Date of the analysis: 29th July 2018
Time frame of the analyzed data: January 2018 to June 2018
Components of the analysis: The steemstem community and how it is contributing to the advancement of Science, Technology, Engineering and Mathematics on the steem block chain

Results

RESTEEMS

Just like we have share on Facebook or retweet on Twitter, on Steemit we have resteem which can help create more awareness about an article. Resteems creates more exposure and awareness about an articles based on the number of users.

Account	Date Created	Number of Followers	Number of Resteemed posts
@steemstem	Sep-16	6,288	180
@stemng	Dec-17	422	2
@de-stem	Feb-18	410	28
@stem-espanol	Jun-18	358	11
@francostem	Jan-18	84	0
@yu-stem	Jan-18	263	55
@itastem	Mar-18	231	0

HISTORY OF VESTING SHARE DELEGATION

One of the ways to support anybody or community is to delegate vesting shares to them to help them and this year steemstem has seen a consistent increase in the amount of delegated vests to them

STEEMSTEM VOTES

• Steempower 11,648 STEEM, Delegated 90,596 STEEM

• From January to June, steemstem has supported 6781 post and 1056 unique authors with average voting weight of 24.4%

With soaring contributions in the early part of the year, the voting percentage had to be reduced to accommodate all. With revision of rules, contributions reduced and the average voting power was increased

STEMNG VOTES

• Steempower 612 STEEM , Delegated Steempower 675 STEEM

• From January to June, stemng has supported 419 post and 135 unique authors with average voting weight of 58.07%

• @henrychidiebere received the highest number of upvotes with 13

• Authors received an average 3 upvotes per author

YU-STEM VOTES

• Steempower = 143

• From January to June, yu-stem has supported 1443 post and 137 unique authors with average voting weight of 99.44%

• @dejan.vuckovic received the highest number of votes with 149

• Authors received an average of 10 upvotes each

de-STEM VOTES

• Steempower = 415 STEEM, Delegated Steempower = 926 STEEM

• From January to June, de-stem has supported 4223 post and 818 unique authors with average voting weight of 27.6%

• @procrastilearner received the highest number of votes with 83

• Authors received an average of 5 upvotes each

ITASTEM VOTES

• Steempower = 259 STEEM

• From January to June, itastem has supported 644 post and 128 unique authors with average voting weight of 98.82%

• @davinci.times received the highest number of votes with 90

• Authors received an average of 5 upvotes each

FRANCOSTEM VOTES

• Steempower = 150.8 STEEM

• From January to June, francostem has supported 57 post and 26 unique authors with average voting weight of 94.6%

• @francostem received the highest number of votes with 10

• Authors received an average of 2 upvotes each

STEM-ESPANOL VOTES

• Steempower = 366 STEEM

• From January to June, stem-espanol has supported 83 post and 63 unique authors with average voting weight of 100%

• @abdulmath received the highest number of votes with 5

• Authors received an average of 1 upvote each

UTOPIAN-IO SUPPORT

The steemstem community has also received support from @utopian-io in the form of upvotes.

• Utopian-io has supported 467 authors from January to June 2018

STEEMCLEANERS

Yes, steemcleaners is also working in the steemstem community, weeding out the bad eggs and upholding the quality of the platform

So far steemcleaners is doing a great downvoting posts from erring users, and with a delegation of more than 1 million steempower even a downvote of 1% will have a big impact

Findings

• 13,650 posts have been supported by steemstem

• 2,363 Authors have been supported by steemstem

• The support of other languages and tags has helped to expand the community.

• The mission of steemstem is so far being accomplished

Conclusion

Due to the support stemstem community is receiving, there has been output in quality contributions in areas like biology, physics,chemistry among others and i have personally learnt a lot from the write ups and soon enough steemit will be a reference point for scientific materials.

Tools and Scripts

Microsoft SQL Server Management Studio 17 was used to access the data from STEEMSQL ( a publicly managed database by @arcange )

Microsoft Excel was used to plot graphs and Charts.

SCRIPTS

SELECT
    TxDelegateVestingShares.*,
    Convert(time, TxDelegateVestingShares.timestamp) as [Time]    
FROM
    TxDelegateVestingShares (NOLOCK)
WHERE
    TxDelegateVestingShares.delegatee = 'steemstem' 

Was used to get data about the delegation to Steemstem

SELECT * 
FROM Reblogs
WHERE account = 'yu-stem'
AND
Convert(date, Reblogs.timestamp) >= '2018-01-01'  and
Convert(date, Reblogs.timestamp) <= '2018-07-01'

Was used to get data about the number of resteemed post from each account and the account was changed to represent each account

SELECT 
voter,
comments.permlink,
weight / 100.0 AS Weight,
comments.author,
category,
txvotes.timestamp
FROM Txvotes
INNER JOIN COMMENTS (NOLOCK) ON [txvotes].[author] = [comments].[author]
WHERE voter = 'steemcleaners' and
category in ('steemstem' , 'stemng' , 'de-stem' , 'stem-espanol' , 'itastem' , 'yu-stem' , 'francostem' )
AND
timestamp >= CONVERT(DATE,'2018-01-01')  and timestamp<= CONVERT(DATE,'2018-07-01')
AND depth = 0

Was used to get voting data utopian-io and steemcleaners under the different categories

SELECT
voter,
author,
permlink,
weight / 100.0 AS WEIGHT,
timestamp
FROM TXVOTES
WHERE voter = 'steemstem'
AND
Convert(date, TxVotes.timestamp) >= '2018-01-01'  and
Convert(date, TxVotes.timestamp) <= '2018-07-01'

Voter details for each steemstem and sub community account

Relevant Links and Resources

https://steemit.com/steemstem/@katerinaramm/frequently-asked-questions-regarding-steemstem

Proof of Authorship

https://github.com/jingis07