Microsoft Excel is a great tool for calculations and analytics. There are many functions in the tool set that make it easy to manipulate large amounts of data and reassign values. Over the course of a semester or year, a teacher can work with anywhere from 30 to 80 students depending upon the grade level. Managing a grade book over a school year can become an arduous task and it's vital that a teacher do it correctly. Excel can help maintain a correct grade book and convert numeric scores into letter grade equivalents.
This image capture shows a sampling of numeric grades converted into letter grade equivalents. The tool bar at the top shows the use of IF statements to evaluate the number grade and populate a corresponding letter in the Grades column. Using functions in Excel can help teachers automate their grade book and make the overall process more efficient.
Here readers can see the grade book and the letter grade conversions.
No comments:
Post a Comment