This spreadsheet makes it easy to analyze data. Download includes a link to a Google Drive template of the file for easy sharing across grade levels as well as with administrators and other school support staff.
The student averages are formatted to color code red for below 60%, orange for 60% - 69%, yellow for 70% - 79%, green for 80% - 89%, and blue for 90% and above. Formatting can easily be modified.
Points Possible cells auto-populate with value put in the first cell. Student averages auto-calculate when both Points Received and Points Possible are entered. Class Average auto-calculates when Points Received and Points Possible are entered.
Fields can be sorted by student names, averages, or scores by selecting all student rows and selecting sort data in the tool bar.
Thanks for visiting Ms Andi's Room.