Excel spreadsheet #2

Today we used Excel to find Average scores for the students different scores, we also found the max, the min, and many other things. We also found the weight of the assignment, the test, and the project. In order to find the students averages for the after finding the weight of each assignment we used the Help Menu to find this function. We uploaded our spreadsheet to google docs so we will be able to access it whenever we need to. One very useful tool we used today in excel was the handle which allowed us to copy a fomula from one cell to many different cells. We used the "IF" function to determine what letter grade the student would get after their percentage was calculated. Here is a link to my Excel spreadsheet #2.

Todays assignment applies to Teaching Standard 3a.demonstrate fluency in technology systems and the transfer of current knowledge to new technologies and situations. For my major, being a math teacher, I can teach the students the functions I learned today and they can then apply them to their work in and out of the classroom.