Grade Spreadsheet 2

The grade spreadsheet was a good way for me to brush up on my excel formulas. I had forgotten how to weight grades using excel. When I first started teaching, a lot of the older teachers would come in my room and want to know how I was averaging grades so quickly. I had set up my own excel spreadsheets to use at that time. Since then, the software program Grade Quick has become really popular. The school where I am currently working is requiring all of its teachers to use Grade Quick for this second semester.

Grade Sheet

Spreadsheet 1

I probably should not admit that I had an excel course at FSU a few years ago. I only had problems when I was trying to sort. At first I copied each terms averages into the semester 1 sheet and averaged the three columns. However, I could not sort the information the way I needed it to be sorted. I kept getting value errors. I looked at the discussion board and realized that I could just put all the terms averages and divide by three in one column and then sort. That worked for this assignment.

Grades