Numbers 1.2

This exercise was assigning letter grades to students' numerical scores.

The instructions and Excel help were very confusing.

Finally figured it out on my own by using the logical formula tab. It is neat to see it work after you enter the formula in just one cell.

However, I did notice that the grade given was not quite accurate because I did not round off on their numerical scores. One of the students had a score of 82.33. If I had rounded off, the numerical grade would have been 82 and the student would have received a C. Since I had not rounded off the grades, the formula gave the student a B in the class.

So I went back and rounded off their scores. I will try to upload the Spreadsheet on my blog. We'll see if I can do it!

If you click on the link for Numbers 1.1, you will go to my Google Drive. Click on the PhyllisMcBrideGrades2.xls to  see the assignment.