help

· Step 1: Open your Unit 4 Individual Project assignment (grade book).

· Step 2: Using your cursor, highlight the course names and the data that is next to them.

· Step 3: Click on Insert > Charts, and select "Column Chart."

· Step 4: Click on the chart, and select "Cut."

· Step 5: Go to the bottom of your spreadsheet, and select Sheet 2. Click on a cell within that sheet.

· Step 6: On Sheet 2, paste the chart you just copied.

· Step 7: On the tabs at the bottom, label Sheet 1, as "Data" and Sheet 2 as "Grade Chart."

· Step 8: Add a title to the Grade Chart.

· Step 9: Revise the chart as needed to make it look more presentable.

· Step 10. Save your work as "First Name_Last Name_StudentGradebookIP5."

· Step 11: Turn in the assignment to your instructor for grading.

Chapter 5: Productivity Software: Spreadsheets; Appendix D: Excel Essentials: Excel Shortcuts

Due Date:

8/24/2014 11:59:59 PM (7 Days)

Total Pts:

140

Points Earned:

n/a

Instructor Comments:

The chart range on your IP5 should be A11:A12 and C11:L12 to include the course names and the grades to be charted.

Total and Percentage column should not be included in your charts since there is no correlation to the individual grades data.

Deliverable Length:

Template; See assignment description