Data analysis of the 10 test questions shows that half of the class scored 60% or lower, with two students scoring 30%, while the other half of the students scored in the 70-80% and one at 90%. It is possible that the lowest tier are students with disabilities. The weakest area for the class as a whole (based on one question) is in computing fractions and decimals, although the student who scored 90% also got this one wrong, so it might have been a badly worded question. The other 2 lowest scoring questions are in computing area and perimeter of polygons and identifying patterns.
The Google spreadsheet does allow for highlighting areas based on certain parameters, using the conditional formatting. I had used Excel quite a bit in the past and never noticed that this feature exists. I did have a learning curve on using Google spreadsheets as I had not used it before. I had to try entering formulas in Excel and then translate them into Google at first, but then got the hang of Google spreadsheets after a bit, but it is quite different. I used -1 to delineate incorrect answers, as I knew that Excel would display negative numbers as red, when formatted, but Google left the negatives in, which is okay. I did think the charting function was easier to use in Google, as it doesn't have all of the options Excel has so it is more straightforward.
I wanted to try Zoho, but didn't have time to learn how to use it (hmm...) and figure out how to compute the data, but would like to go back and try it later.
I have used Excel to compute grades and credit hours and could also use Google spreadsheets. I have used it with students to create graphs.