Imagine you have created a series of awesome Google Forms, or you are getting a bunch of spreadsheets from a recently Galileo assessment you’ve given. You get all this data on your students’ progress in multiple sheets, and you just aren’t’ sure where where to get started. You have all their grades, and you import them to your SIS. Some students you may have a quick conversation with, but for the most part, the assessment is done and you move on.
In an ideal world, you’d spend some time drilling down the data, looking for trends, and adjusting your teaching to compensate. A very worth action, but difficult to do regularly with the various other responsibilities you have. What can you do?
Conditional Formatting can help by color coding cells according to value. This can help highlight score ranges so you know what stuck and what didn’t. Here’s a quick guide to getting started.
Conditional Formatting Step by Step
- Correct answer is green
- Incorrect answer 1 is yellow
- Incorrect answer 2 is orange
- Incorrect answer 3 is red
- In this sheet, go to the “Format” menu and select “Conditional Formatting”.
- In the sidebar that opens on the right, you’ll see that you have a few options.
- Under “Apply to range, select the sells where the data appears. Click on the grid, and select all the cells you want to include. Then click “OK”.
- Under “Format cells if…”, select “Text contains”. In the box under that, type in the correct answer exactly as it appears in the sheet.
- Under “Formatting style”, choose the color fill icon and select “green”
- You should now see all your correct answers (for question 1) highlighted in green.
- Repeat the above process, but substitute the correct answer for each of the three incorrect ones, and select the appropriate colors.