With Google sheets you can track student progress and easily visualise how students are progressing.
The most common ways for teachers to visually represent student progress is through graphing the data. However with conditional formatting in Google sheets, teachers have another option for graphically representing student progress.
Here’s how to conditionally format your Google Sheet:
Step 1: Open up a Google sheet
Step 2: Enter your student details and assessment tasks results
Step 3: Set up conditional formatting in your Google Sheet (this isn’t hard)
You just need to select the test scores and then click on format and then conditional formatting
From here you click on “format the cells if” button and set up your condition. If you were working with percentages and you wanted any student who achieved at less than 50% highlighted red, you would choose is less than and type in 50. Note, you may want to select is less than or equal to to capture the number as well.
You can add other rules by clicking the add another rule link.
Here is an example where students who scored 5 or less were highlighted red, between 5 – 6 were highlighted yellow and if they scored 7 they were highlighted green.
Step 4: Once finished adding all your rules, click done
Here is an example of a student progress sheet that has been conditionally formatted.
Note: If you copy and paste a cell that has been conditionally formatted, the formatting will be pasted into the new cell and is maintained.
You may also like to explore the grade book template in the sheets app.
In the grade book template for Google sheets you get an:
- Overview sheet with students progress graphed
- A marks page linked to a-f grades
- A student summary graph
All of these sheets in the Google Spreadsheet are customisable. You can check out the teacher grade book demo here.