Use this spreadsheet to calculate a whole number score between 0-10 on assignments/assessments/observations/rubrics with up to 20 questions.
Holds up to 23 students and 13 assignments.
Will only provide an average score with the data entered.
Scores are color coded from Red to Green based off of score.
A sample student is given.
1. Rename the assignment tab(s) with Task Name(s).
2. Enter your roster.
3. Save AS (rename with subject, period, class, topic, etc.) to ensure you can access the spreadsheet many times.
4. In the student row, you will see two boxes over a bigger box…enter the number of questions correct into the first box, and the total number of questions in the second box. The Tens score will auto populate beneath the two boxes.
5. The Average column will average the scores for an overall grade for Report Cards or for a bigger picture of students’ skills.