Cleveland Heights - University Heights City School District
Assessment Resources

Assessment Resources

Grading Spreadsheet for Grades 3-5

Spreadsheets can help you organize student assessment information and calculate totals automatically.

This spreadsheet is an example of how it can be done. It has been organized with a separate worksheet for each subject area and worksheets to display final grades in all areas together.

  1. Right click here and choose "Save Target As..." to save spreadsheet to your computer.
  2. Open the spreadsheet you just saved. (Opens with Microsoft Office, Open Office or Star Office.)
  3. To keep the original file as is, choose "Save As.." from the file menu and save a new copy for each quarter.
  4. Enter or Copy students names and ID onto the first worksheet. The order of the names should not be changed once you start entering grades for the quarter.

PDF file with more instructions

Workshops are scheduled for each elementary school beginning September 19.

For more help or suggestions contact

Spreadsheet idea originated with Canterbury teacher Terry Gilliam.