For this assignment, you will need to download the Student Grade Book template by clicking here.

After you download the template to your desktop, open the grade book and complete the following steps:

• Step 1: In Cell E4, change “Student name” to your name. Use the Merge Cell command to spread your name over two or three cells.
• Step 2: In cell D1, Enter the heading “My Grades at AIU.” Format this title in bold, Calibri, 16-point font.
• Step 3: In the areas where you see zeroes is the data entry area, enter the grades for both of the courses. You can enter your actual grades or make them up.
• Step 4: In column M11, Sum all of your grades. Copy this formula to M12.
• Step 5: In column N11, compute the percentage. Use a formula or a calculation.
• Step 6: In field D16, compute the total of both of your classes.
• Step 7: In the Date column, enter the date that you took the course. This can be real or fictional.
• Step 8: Bold all of the headings.
• Step 9: Put a border around the data-entry area.
• Step 10: Do any other modifications that you would like to make the data more presentable.
• Step 11: Save the document as (your last name_your first name)_U4_StudentGradebook.xlsx in your COMP102 subfolder (e.g., Doe_John_U4_StudentGradebook.xlsx).
• Step 12: Submit this file to your Week 4 Individual Project area.

Please submit your assignment.

For assistance with your assignment, please use your text, Web resources, and all course materials.

Grading

Steps 1–2: Enter Name as directed reformatting cell using Merge Cell Enter specified heading using font and style as directed	17%
Steps 3–4: Enter grade data as directed Create and utilization sum formula as directed	29%
Steps 5–6: Compute percentage as direction using formula or calculation Compute the total for both classes	18%
Steps 7–10: Enter date as directed Reformat the headings, border, and data as directed	29%
Steps 11–12: Save the document with the file name as directed Submit the file	7%