Rationale :Grade Book Spreadsheet with Two Charts

Context

In FDN 3100, I used Microsoft Excel to create a grade book spreadsheet for my “imaginary” students.  In the spreadsheet I included the number of absences, test grades, test grade average, project grades, science fair grades, and final grade averages.  For each of these columns I inserted grades for each student and then used formulas to find the class average for each assignment as well as the final grade average for each student. 

Using the data in the spreadsheet, I created two student charts showing that students, grades.  I also used part of the spreadsheet to create a letter to the principal showing him my class’s 9 week grades for that term.

Impact

When I teach I can use a spreadsheet to keep record of each students grades.  I can also keep track of how many absences each student has so that I can see what student needs help and why. 

The spreadsheet will also be a valuable resource for me during parent-teacher conferences and the charts will give a visual of the progress or lack of progress a student is making.

Alignment

I have met NETS Competency IID because I am using technology (Excel) to manage my grades for my future 4^th Grade classroom.

I have met NETS Competency IIE by using a spreadsheet to keep up with the progress of my student’s learning.  I can also keep track of how their absences, tardies, and other information that will affect their success in my class.

I have met NETS Competency IVB because I displayed my students’ grades in the form of 2 charts, then I communicated this information by copying and pasting part of the spreadsheet in a letter to the principal.