[Club100] Steem Curation Document for Data Analysis - Team #Sevengers

_{Source: Canva}

---

Namaste Steem Family,

I hope everybody is doing great and having fun on Steemit.

Currently, I'm a part of a curation team that has recently been selected by Steemitblog for the purpose of curating tags for the categories #Science, #Technology, and #Computing. Together with my team members, I am representing #Sevengers, which consists mostly of Engineers, Teachers, and Community Developers.

Yesterday, we began the trial version of curation process by reviewing relevant posts for our assigned theme tags and commencing the curation process. It has been decided that the team members will take turns curating the posts. So yesterday was my turn to curate posts under the Science, Technology, and Computing tag, along with @tarpan.

_{Source: Google Sheets}

For the purpose of making the curation process more enjoyable and easy, I have developed a google sheet where we can simultaneously track and analyze the data we gather by curating posts that fall into our theme tags. To explain how this sheet works and how it can be used as a curation tool, I presented it to my team members. However, there was some confusion regarding the sheet's functioning.

Thus, I have compiled a post that explains the workings and benefits of this spreadsheet and how to utilize it effectively.

This document contains four pages that assist us in forming our curation plan, and since all of them are dependent on one another, we shall examine them one by one.

---

Page No. 1 - Countries and Languages

---

The following page includes information about countries that have active Steemit users. Nevertheless, if users from other countries that are not on the list become active or join Steemit, we will be adding these countries to our list.

_{Source: Google Sheets}

Here is the list of countries we have added to our sheet for curation and analysis:

		Countries
Afghanistan	Argentina	Armenia	Australia	Austria
Azerbaijan	Bangladesh	Belarus	Brazil	Cambodia
Cameroon	Canada	Chile	Czechia	Denmark
Ethiopia	France	Germany	Ghana	India
Indonesia	Italy	Mexico	Nepal	Nigeria
Pakistan	Philippines	Russia	Spain	Sri Lanka
Turkey	Uganda	Ukraine	Venezuela

We have shown in the above table all of the countries we have included in our list, and we are open to any suggestions on adding any other countries that we might have overlooked. If you do not see your country on the list, please let us know by leaving a comment below.

Additionally, we have added a number of languages that have a large number of speakers throughout the world. We anticipate that we will receive submissions in these languages primarily for our theme. Below table shows the languages we have added to the list:

		Languages
Mandarin	Spanish	English	Hindi	Bengali
Portuguese	Russian	Japanese	Turkish	Korean
French	German	Vietnamese	Urdu	Javanese
Italian	Hausa	Indonesian	Polish	Igbo
Dutch	Nepali	Czech

It is possible that you or a user speak a language not included in this list, and we will add that language to our list if you inform us about it in the comments section. However, please make sure to double-check that the language that has been requested to be added has users posting on Steemit in that language.

Thus, to conclude, we have added this page solely for the purpose of giving data to other sheets. This should only be edited when the curator team wants to add a new language or country. The country and language data is going to be used on Page No. 2.

---

Page No. 2 - Curation Post List

---

We use this page in the spreadsheet to add details about posts we are currently investigating, so the details related to the post are added here. This page is only intended to be utilized to add information about the posts made in our theme tags and not to add any curation-related data. This is merely intended for the purpose of tracking posts that are being curated by the team members.

_{Source: Google Sheets}

Let us see each detail that we add to this page one by one.

1. Post Author: This is the column where the username of the post author is displayed. The third page will use this column.

2. Post Link: The link in this section will redirect us, or any other member of the curation team, to look deeper into the post, as well as analyze the post for every detail that needs to be scrutinized before passing it to the next stage. It is also used on the third page of the document.

3. Categories: We have been allotted three categories in our theme.

   • Science
   • Technology
   • Computing

   Therefore, this column contains a list of all of these categories from which a curator can choose. A similar column appears on the third page as well.

4. Word Count: The value shown here represents the number of words that the author has written in their post. It has been decided to limit our curation to only posts that have more than 300 words in them only. In order to remove authors from the curation list who are abusing the system, this is required.

5. Club Status: It has been decided that we will only curate posts whose authors follow at least #club5050. Consequently, this column allows you to choose from the options #club5050, #club75, and #club100.

6. Country: This information has been brought forward from Page No. 1. With the use of this column, we have added country information to associate each post with a specific country. We will use this information in our further analysis.

7. Language: The following information is also brought forward from page 2. This column is included in order to identify the language in which the post was written. Based on the information that this column provides, we will be able to further analyze the post.

8. Date Published: We need this information for curation since we want to curate all posts with the associated theme tags within a specific time period. In this way, adding the publishing date provides us with information that can be used to decide which post should be curated first.

Having filled in these fields will allow us to use them on the next page that we are going to discuss. It is now time for us to move on to the next page.

---

Page No. 3: Final Curation Details

---

We needed another page to track and analyze data about posts that are in the curation process as well as the details of our findings. Since the previous page was used for populating data related to posts made within our theme tags, we needed one more page to track data related to curation.

_{Source: Google Sheets}

The purpose of this page will be to provide information about who is curating the post whose data is populated from the previous page. Additionally, we ask ourselves some questions after reviewing the post, including: Is the post plagiarized, and if it is not plagiarized, will it be recommended for publication in the Sunday report?

_{Source: Google Sheets}

There was confusion among the curators of my team as to why the data from the previous page was being auto-populated. This is necessary because we need to cross-check the information related to the post and to additionally add verified information to the auto-populated data. In addition, there is another reason for doing this, namely in order to be able to cross-check data to ensure accuracy on the 3rd page of the curation process. Without this info that has been automatically populated, it would be difficult to get the correct information for the post.

Let us see each curation data in detail.

1. Post Author: The data is automatically populated from the previous page. To make the curators' lives easier, the auto-population is done so that they can keep track of the data easily.

2. Post Link: Once again, the previous page's data is auto-populated. Auto-population is done with the intention of simplifying the curator's task. Additionally, since this data relates to links, it would be redundant to copy-paste every time.

3. Category: The data was automatically populated from the previous page. This auto-population is intended to facilitate the curation process for the curators. Instead of requiring curators to choose categories each time, I wanted them to choose the categories on the 2nd page only.

4. Curated by: This field will be used by curators to add their own usernames. As a result, other curators will have access to information about who curates what and which posts they should leave to other curators.

5. Plagiarism Status: When a curator discovers an instance of plagiarism, he or she can mark it as plagiarized. There are six options available in this field, from which curators may select one.

   • None: If there is no evidence of plagiarism. The curator can mark posts with this option and proceed with cross-checking other parameters afterward.
   • Complete: The act of submitting work that belongs to someone else, submitting it without any changes, and then claiming that it is original.
   • Source: Reference to the right source where the post received its inspiration from is very important, but if the source is not mentioned or if the wrong source is cited this option will be used against the post.
   • Self: The act of using one's own post from another website or reposting an old Steemit post is called self-plagiarism.
   • Paraphrasing: By using word spinning software to replace the main words of a post with their synonyms, an author is paraphrasing. It is a type of plagiarism that we find to be unacceptable in our theme tags, although it may make our work difficult.
   • Accidental: If the copying of a portion of text occurs accidentally and a user has forgotten to provide a source or to cite the source, then it is referred to as accidental plagiarism, but it is still frowned upon.

   Thus, these are some of the types of plagiarism that we will be examining in the posts within our theme tags. While plagiarism of any kind is not permitted, some users may be given a warning and placed on a watchlist, where their accounts can be continually monitored for further violations. In the event that a user repeats their mistake, they will be placed on a blacklist and their posts will never be curated again.

6. Comment Link: This link leads to a comment made by one of our team curators. It helps us keep track of the posts we have already curated, and we can also use this link to make sure that our curators have read this post and to see what kind of comment they have left.

7. Curation Date: This is a date format that informs us of when a post was curated and how long it took to curate a post.

8. Vote Percent: An author's vote percentage is a measure of the amount of support they have received. A 35 percent vote will be awarded to #club5050 users, a 40 percent vote to #club75 users, and a 45 percent vote will be awarded to #club100 users for their constant powering up and not taking any Steem off of the platform.

9. Recommended: The data in this column represents the posts that are recommended by our team's curators. After the following week concludes, the recommended posts for the following week are reviewed, and the top 7 authors are chosen.

10. Remarks: The goal of this column is to allow our team's curators to add a comment to every post which shows other curators why the post was flagged as plagiarism or recommended. In the event that the post was flagged, what kind of plagiarism was used can also be included in this column.

11. Plagiarism Source: As its name implies, this column will include a link to the original source from which the text has been copied.

---

Page No. 4: Main Analytics Dashboard

---

This is the most important page of the sheet since it provides the actual analytics of how the curation process is going. This page provides statistics regarding the number of posts that are curated daily, as well as the number of posts that have been found to be plagiarized.

_{Source: Google Sheets}

1. Curated Posts Statistics: The following table displays the number of posts that have been curated and the number of posts curated in each tag.

2. Club Status Statistics for Science Tag: The following table shows the number of posts that were curated in the science tag. It also displays the number of posts that are made by authors who have different club statuses, such as #Club5050, #Club75, and #Club100 in the science tag.

3. Club Status Statistics for Technology Tag: Similar to the science club status table, this table displays the number of posts written by authors who are following different clubs, for example, #Club5050, #Club75, and #Club100 in the technology tag.

4. Club Status Statistics for Computing Tag: This table displays the number of posts curated in the computing tag, similar to the other two discussed above, this table also shows the number of posts that were made in the computing tag by authors following different club statuses, such as #Club5050, #Club75, and #Club100.

5. Plagiarized Posts Statistics: Here is a table displaying the total number of posts that were found to be plagiarized as well as how many plagiarized posts were found in the science, technology, and computing tags.

6. Recommended Posts Statistics: The following table shows the number of posts that were recommended for further consideration in the weekly top posts list. First, we recommend posts, and if there are more than seven recommendations, we choose the top seven posts from that list.

7. Curator Statistics in Technology: Data in this table shows the number of posts curated by each curation member in the technology tag.

8. Curator Statistics in Science: The following table shows how many posts each curator has curated under the science tag.

9. Curator Statistics in Computing: The following table displays the number of posts curated by each curation member in the computing tag.

The following was our Google Spreadsheet, which will aid us in the curation process. Although this was designed for our team's curation process, anyone who would like to use this google spreadsheet can access the link provided below and can customize it according to their curation needs.

The download link will be included in the comment section in a short while. Please feel free to download this document and customize it to suit your needs. If you would like me to customize it for you, please ask me in the comments section and I will make those changes for you.

Thank you for reading this post.

---

P.S.: Despite the fact that this post and document took a considerable amount of time to make, the whole process was gratifying and I am excited to start curating content based on these themes. Hopefully, Steemitblog and Steemitcurator01 will soon provide us with the curation accounts.

Regards,
Team #Sevengers

---

CC: @daytona475, @reminiscence01, @tucsond, @tarpan, @zmoreno, @jimah1k