Teacher Toolbox: Classroom management Spreadsheet (50 Points)

Select the link to submit your work. This assignment is due by the end of this module.

The purpose of this assignment is to allow you to practice basic mathematic functions and formula to manage student progress and performance. A working file will be given. You will re-design and apply appropriate functions to the grade book spreadsheet. 

This assignment is part of your Teacher Toolbox and worth 50 points toward your final grade. Please follow the instructions below:

1. Download the attached Excel file, Student_gradex.xlsx

2. Use basic mathematic fuctions to complete those yellow cells (e.g. =SUM( ), AutoSum, etc.)

3. Use IF condition to convert the total point to a letter grade. See the formula below.

• =IF(L2>179,"A",IF(L2>159,"B",IF(L2>139,"C",IF(L2>119,"D","F"))))

4. Complete the Summary section by filling out the yellow cells using basic functions, such as MAX( ), MIN( ), and AVG( ), etc.

5. Format the style, color, font, column width, row height to make it look more profesional. Be creative!

6. Save the file and add your last name to the file name

7. Upload the file through the submission link in Blackboard (above link)