Spreadsheet 2: Grades 2

For the Grades 2 Assignment, I used the Excel Spreadsheet to understand and use the numerous function tools available in MS Excel. I created final grades using functions that involved the specific assignments, tests, and projects, as well as, the specific weight or amount each item was worth, such as assignments, 25% of the grade, project, 25% of the grade, and tests, 50% of the student's grade. I then had to develop a formula to calculate the student percentages. I once again used the cell handle to drag and copy the formula from student 1 to the remaining students in the class. After the percentages for each student were calculated, I used the IF function to calculate letter grades to match the percentages. The assignment also required that I learn to use the average, max, min, and range functions to calculate each of these areas. The letter grades were then counted and placed beside the corresponding grade, such as 3 A's. The last part of the assignment allowed me to use the formatting, or fun part of Excel to add color to the background of the worksheet, as well as, border each of the cell's located in the worksheet.

I uploaded my final copy of the Grades 2 Excel Worksheet into my Google Docs. Check it out!

The Spreadsheet 2: Grades 2 Assignment closely relates to the ISTE.NETS STANDARDS:

1. Facilitate and Inspire Student Learning and Creativity
2. Design and Develop Digital-Age Learning Experiences and Assessments
3. Model Digital-Age Work and Learning