UNIT 4 IP ITCL

 

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 B2, enter the current date in Month, Day, Year format. Example: November 15, 2011
• Step 2: In Cell E4, change “Student name” to your name. Use the Merge Cell command to spread your name over two to three cells.
• Step 3: In cell D4, Enter the heading “My Grades at AIU.” Format this title in bold, Calibri, 16-point font.
• Step 4: In the areas where you see zeros is the data entry area, enter the grades for both of the courses. You can enter your actual grades or make them up.
• Step 5: In column M11, Sum all of your grades. Copy this formula to M12
• Step 6: In column N11, compute the percentage. Use a formula or a calculation.
• Step 7: In field D16, compute the total of both of your classes.
• Step 8: In the Date column, enter the date you took the course. This can be real or fictional.
• Step 9: Bold all of the headings.
• Step 10: Put a border around the data-entry area.
• Step 11: Do any other modifications you like to make the data more presentable.
• Step 12: Save the document as “First Name_Last Name_StudentGradebook.xls