Excel Spreadsheet 2

For this Excel Spreadsheet, we received a copy of data that showed students grades on two homework assignments, two projects, and two tests. We learned that the homework and projects were worth a combined total of 50% of the students letter grade, while the other 50% were made up from the test scores. We calculated the averages for each category and each student, as well as the min, the max, and the range. Once we finished this, we were able to convert the averages into letter grades by using the "IF" function. Afterwards we were able to format them into more aesthetically pleasing spreadsheets.

The finished grading chart, as seen in GoogleDocs

This project was good practice for when we as teachers have to keep an electronic grade book. Some schools don't have the luxury of online grading systems that do the formatting for them.

After we completed the assignment, our projects were uploaded to GoogleDocs. This assignment used NETS standard 5, substandard d, which states that teachers: "contribute to the effectiveness, vitality, and self-renewal of the teaching profession and of their school and community."