All data we entered had to not only be divided evenly among the team, but it also needed to be checked to make sure that the information is correct and who had last saved the data. We agreed to use an author naming convention by using our initials. In the Microsoft Excel spreadsheets, we designated four additional columns for this purpose, and two more columns were added to communicate on the spreadsheet itself. Columns D,E, R, S, T, and U were used for the following: D was \u2018Entered by CQ\/MP\/AB\/EH\u2019, E was \u2018Date Entered\u2019, R was \u2018Comments\u2019, S was \u2018Checked by CQ\/MP\/AB\/EH\u2019, T was \u2018Date Checked\u2019, and U was \u2018Additional Notes\u2019. \u00a0The \u2018Comments\u2019 column was used to communicate changes to data. Say I had entered a name wrong as \u2018McThomas\u2019, but Michelle caught the mistake, and would write in that row under column R \u2018MP-AB fixed last name to MacThomas\u2019. This tells us that Michelle is writing to Anastasia (me) that she fixed the error in the last name I made. If we had a question or were not sure of a data entry or part of one, we would write in column R as well. For example, if Ellie had a question about\u00a0 a missing name, she could write in the \u2018Comments\u2019 column \u2018Which participant is this?\u2019 or simply state \u2018No name given\u2019.<\/p>\n
The initial convention was used not only to show who input and checked the data, but also who had last saved the data. To give an example, if I was the first to put in data, I would label the newly saved excel sheet \u2018AB Raw Data Set 1\u2019.\u00a0 If Ellie was the next to input her data and check mine, the new excel sheet would be titled and saved as \u2018AB-EH Raw Data Set 1\u2019. Then, if Michelle were to do the same, the file would be saved as \u2018AB-EH-MP Raw Data Set 1\u2019. This naming method would continue until all data is input and checked.<\/p>\n
Overall, this system of using our initials to know who last saved, checked, and input data worked very well. It was a simple, clear way to know among the team who had last saved the most recent data and who was communicating with who within the spreadsheet, especially between meetings.<\/p>\n","protected":false},"excerpt":{"rendered":"
All data we entered had to not only be divided evenly among the team, but it also needed to be checked to make sure that the information is correct and who had last saved the data. We agreed to use<\/p>\n","protected":false},"author":1597,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[3,10,27,16],"tags":[31,8,33,23,11,32],"class_list":["post-103","post","type-post","status-publish","format-standard","hentry","category-coding","category-data","category-google-drive","category-microsoft-excel","tag-checked-raw-data","tag-data","tag-google-drive","tag-microsoft-excel","tag-note-cards","tag-unchecked-raw-data"],"_links":{"self":[{"href":"https:\/\/blogs.shu.edu\/lmlc\/wp-json\/wp\/v2\/posts\/103","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blogs.shu.edu\/lmlc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blogs.shu.edu\/lmlc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blogs.shu.edu\/lmlc\/wp-json\/wp\/v2\/users\/1597"}],"replies":[{"embeddable":true,"href":"https:\/\/blogs.shu.edu\/lmlc\/wp-json\/wp\/v2\/comments?post=103"}],"version-history":[{"count":3,"href":"https:\/\/blogs.shu.edu\/lmlc\/wp-json\/wp\/v2\/posts\/103\/revisions"}],"predecessor-version":[{"id":133,"href":"https:\/\/blogs.shu.edu\/lmlc\/wp-json\/wp\/v2\/posts\/103\/revisions\/133"}],"wp:attachment":[{"href":"https:\/\/blogs.shu.edu\/lmlc\/wp-json\/wp\/v2\/media?parent=103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blogs.shu.edu\/lmlc\/wp-json\/wp\/v2\/categories?post=103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blogs.shu.edu\/lmlc\/wp-json\/wp\/v2\/tags?post=103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}