Grade Books In Google Spreadsheet

Here is a grade book I did in Google spreadsheets. I did use one of the templates as a starting place, and then modified it for this grade book.

https://docs.google.com/spreadsheet/ccc?key=0AmgfiCUYrsGfdGNqRnRQWlQ3UUNpeVBBTHg3WDU1UGc#gid=0

I have used Excel in the past for lists, like VBS registration and employee testing, but this is the first time I had to figure out formulas in a spreadsheet. I had issues with the final grades and ended up calculating by hand. I tried to use atomiclearning.com to help with some of the more complex formulas, but couldn't get the videos to play. I tried using the Google help, but I couldn't figure it out. This is something I will just have to practice with more, but I can see the benefits to doing a grade book in a spreadsheet.

The article we read just continued on the benefits of technology in the classroom. I can see how spreadsheets can be used to help students understand certain complex equations (as long as they know the equation) and how this program can be used by students to conduct scientific research. This is an important part of the Common Core Standards. Spreadsheets are used in many professions and it is important that students understand and know how to use spreadsheets. The more we can do as teachers to prepare our students for the future/the world the better off the student will be and in the long run the benefit for our country.