Spreadsheet Use to Determine Trends in the Classroom.

The use of spreadsheets to document the progress of individual students as well as group trends is a valuable tool for teachers.  The below spreadsheet is a mock of how this tool can be use in the classroom.  In the chart I have prepared, one can see that the test provided a fairly consistent set of  scores reflecting the abilities of the student quite well.  The scores with students Queen and Walter show a lack of improvement over time.  The use of a chart like this to spot issues with students can be useful in identifying students who might need some extra help.  In the case of Katherine, the scores might show an incident at home or a sickness that has led to a temporary setback.

Another important use of Google Spreadsheets is to keep data on the students progress on one place where easy calculations can be made at important moments throughout the year.  By using this product to help the teacher, the old calculator and grade book can be done away with reducing the time needed in reporting.