For entering the data for Assignment 5-2: Organizing Data, I chose to use Google Sheets. I chose this tool because I am familiar with most of the features available and the ease of access in using the tool. There are very few weaknesses that I have found in using Google Sheets, however, I did get a bit frustrated with the the text prediction as I typed. I am sure there is a way to disable this feature but I was unable to find out how.
As I was organizing the data, I chose to use block coloring to represent correct/incorrect answers. Using the color made it easy to see trends among particular students and particular questions (standards). I also chose to highlight students who fell below 50% and questions that were answered incorrectly by less than 50% of the students.
Tools such as this can be used to guide teachers, curriculum leaders, support teachers and administration in making important academic decisions. The fact that the information may be transferred among staff in a secure manner also allows for easy access as well. I know Google Tools offer many ways to share information, for instance having documents be password protected. These tools can also be used to demonstrate learning trends throughout the school. Whether it be school-wide or individual classes. One feature that I find to be useful is creating charts/tables into graphs. For some people, seeing data in a visual manner such as a graph is easier to interpret.
Brittany, I also used Google Sheets for my data assessment and found it to be very useful. I agree that coloring each cell makes it easier to look at the results and analyze the data. I tried to use as many formulas as I could so fewer manual steps were needed. This is especially helpful when re-using the spreadsheet. Not only can this teacher re-use it to enter additional assessment data throughout the school year, but it can also be shared with other teachers.
ReplyDeleteCheck out my Google Sheet (https://docs.google.com/spreadsheets/d/11s_9trF4owQqLpg30XxE3z5QTsqVtxTGnP4XJXKorjM/edit?usp=sharing) and take a look at my blog post. I explained how I created the formulas to calculate percentage of answers correct as well as the conditional formatting for coloring the cells. I entered the answers in one row as the "answer key", then created formulas based on these answers to color the cells red or green and calculate percentage correct. Hopefully this can help you out in the future!
-Christine