Web 2.0 tools such as Google Sheets, and Zoho can be used to tabulate, analyze, and share data. Mashable provides an additional list of 12 online spreadsheet programs. Personally, I like to use Google products because they work seamlessly with Microsoft Office and I am an Office girl. Google allows for documents to be shared via a link without a maximum number of collaborators, which provides seamless sharing options. Data can be shared between educators, with administrators, with parents/guardians and with the students themselves.
The data
tabulated in the Google Sheet below represents student data from a hypothetical classroom. Within the hypothetical scenario, an assessment was given to 12 students at a middle school to assess all students within a single grade level. Student responses were compared to correct responses for each individual assessed standard as well as for each individuals performance on the assessment. Incorrect answers are highlighted in yellow.
Student data was organized into groups that met the standards being assessed, students that did not meet the standards assessed as well as Groups for Advanced (limited supports), Proficient (moderate supports), Basic/Below Basic (intensive supports).
The results above do not represent the whole picture. In-class assessments, existing educational supports and observations should also factor into instructional decisions. (Alber, 2014) However, the resuls are the starting point to begin a re-teaching/re-learning process.Based on the results presented only one student, "Zucy", falls in the Advanced category with only one missed question. All but one student incorrectly answered Question #6. Additionally, those incorrect answers ranged across the board indicating overall misunderstanding of the standard. Standard 6 should be retaught as an entire class rather than in small groups.
Online spreadsheets can be used to tabulate classroom, grade and school data and assess areas of successes as well as areas that need to be retaught or limitations of understanding. Student data can be tracked over time to show areas of growth.
References
Alber, Rebecca (2014, January 15) 3 Ways Student Data Can Improve Your Teaching, Retrieved from Edutopia: http://www.edutopia.org/blog/using-student-data-inform-teaching-rebecca-alber
Stephanie, The analysis you share and the table you used is so clear for a teacher to use and the tools are easy to learn. When I looked at the data, I wanted to be more conscious of what students did well on and think about how those students could help to guide others along the path to understanding. What strengths and weaknesses did you find by using Google Sheets? How would you, or would you, encourage the teacher to share the data with students so they are accountable for their learning? Did your spreadsheet allow for the educator to see the answer students have so thinking processes could be addressed? I'm also wondering how you would show the educator how to add more data in the future. By using Google Sheets, I was able to find the add on "Super Quiz" which not only inputs data from a Google form but also analyses it in the same way Flubaroo or other add ons can. Great analysis! Thank you for sharing!
ReplyDeleteHI Hannah-
ReplyDeleteBased on the data provided, I did not find any weaknesses using Google Sheets. I played with Zoho a bit and found that Google allowed me to manipulate the data similar to an excel sheet so went with Google. Zoho did not allow me to create additional tables for summarizing. Google also allows you to create charts with the data. Based on the information we were provided, I wanted information on what the multiple choice questions were so I could analyze how they chose the response they did. I would share the information with the students individually, but not share the information with the entire class as a whole. Data can be added through importing from a form or standard data entry method.
thanks for your comments
Stephanie
Stephanie,
ReplyDeleteI really like how you included Below Basic, Basic, Proficient, and Advanced. Based upon the answer to the question, the teacher would be able to tell specifically what level a student is at and how to group them based upon that achievement. Do you think it would be beneficial for the teacher to do this for each question/standard or overall? Or perhaps both?
Nicely done!
Lauren