Microsoft Excel is a great tool for teachers to use in the classroom. It is a fast and easy way to keep a grade book. I've used Excel and its formulas before, but I didn't know just how much you could do with it. During this activity, I learned how to use brackets to weight different parts of a score. I also learned how to use the IF function to assign a letter grade to a numerical grade. And I learned that you can use the COUNTIF function to count how many of each letter grades you have. I think this tool will be very useful to me as a teacher. I will be able to just set up the formulas and plug in the grades, and it will calculate the averages and letter grades for me. This will really save on time.
Here is a link to my published spreadsheet.
I believe the ISTE NETS standard for this activity is: 3. Model Digital-Age Work and Learning, because it involves using a digital tool to analyze and evaluate information.
No comments:
Post a Comment