Whoops! Something went wrong.

Click here to refresh the page

Data Analysis Spreadsheet

Data Analysis Spreadsheet
Product Description
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.
Total Pages
1 page
Answer Key
Teaching Duration
Report this Resource
  • Comments & Ratings
  • Product Q & A
Digital Download
Digital Download
Teachers Pay Teachers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

Learn More

Keep in Touch!

Sign up