Grade book

This assignment will use the grade book that you created in the Unit 4 Individual Project. Click here if you need the original template. Open the spreadsheet, and add a column bar chart showing your grades. To complete this, do the following steps:

  • Step 1: Open your Unit 4 LDA submitted document in your COMP102 subfolder (your last name_your first name)_U4_LDA.xlsx.
  • Step 2: Save this document back to your COMP102 subfolder as (your last name_your first name)_U5_LDA.xlsx.
  • Step 3: Using your cursor, highlight the course names and the data that are next to them.
  • Step 4: Click on Insert > Charts, and select “Column Chart.”
  • Step 5: Click on the chart, and select “Cut.”
  • Step 6: Go to the bottom of your spreadsheet, and select Sheet 2. Click on a cell within that sheet.
  • Step 7: On Sheet 2, paste the chart that you just cut.
  • Step 8: On the tabs at the bottom, label Sheet 1, as “Data” and Sheet 2 as “Grade Chart.”
  • Step 9: Add a title to the Grade Chart.
  • Step 10: Revise the chart as needed to make it look more presentable.
  • Step 11: Save your work as (your last name_your first name)_U5_StudentGradebook.xlsx (e.g., Doe_John_U5_StudentGradebook.xlsx).
  • Step 12: Submit this file to your Week 5 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:

  • Open specified document and save as directed with new file name
 

9%

Steps 3–4:

  • Create chart as directed with specified data range
 

12%

Steps 5–7:

  • Cut and move chart as directed into Sheet 2
 

36%

Steps 8–10:

  • Label Sheet 1 and Sheet 2 as directed
  • Add title to chart and revise chart formatting
 

36%

Steps 11–12:

  • Save document with the file name as directed
  • Submit the file
 

7%

There is no additional information to display at this time.