March 3, 2011: Using Spreadsheets, Part 2

In the beginning of class, we all logged on to Diigo and joined a group.  The groups that I joined were Math Links, Cool Tools for Educators, and Classroom 2.0.  All of these groups share resources to use in the classroom.
Today we used Microsoft Excel to do our second spreadsheet practice.  In this spreadsheet we used formulas and functions to solve for the average grade, turn the numeric grade into a letter grade, find the number of each letter grade, and find the min, max, range, and average grade of each individual assignment.  We started out by using the MIN, MAX, and AVERAGE function to determine the lowest grade, highest grade, and the average percentage of each assignment.  We then subtracted the minimum value from the maximum value to determine the range of the scores.  After that, we used a weighted equation to determine the average grade for each student.  We learned how to use the IF function to come up with a formula to convert the percentage grades into letter grades.  After we found all grades pertaining to the assignment, we calculated the number of each letter grade by using the COUNTIF function.  Finally, we highlighted the area on the spreadsheet that was used and changed the background color then used the border tool to create a border around each cell used.  After the assignment was completed, I uploaded my document to Google Docs and published it to the web.  I have included my link below.
Spreadsheet Assignment # 2