Assignment Instructions

Assignment Details

Assignment Instructions
The scenario:
Gerry Henry surfing, one of the owners of Southside Surf Shop, wants to commission an artist to create new board logos for the company. Mr. Henry has created an Excel workbook that lists the artists and their commission prices. He has also narrowed the field down to four logos and placed them in a PowerPoint presentation. He has asked you to complete both files.
For this assignment, you will need the following files:
    Board_Logos
  Logos_Presentation
You will save your files as:
    Lastname_Firstname_Board_Logos
    Lastname_Firstname_Logos_Presentation

Open the file Board Logos.
Save as Lastname_Firstname_Logos_Board_Logos
Adjust the column widths so that all data displays and apply a cell style to the title.
Create a chart to display the Last Name and Commission on a new sheet with an applicable name.
Format the chart using a chart layout and a chart style.
Insert at least two comments on the Artists worksheet.
Rename the data sheet with a descriptive name.
Insert the your name in the footer of all worksheets.
Save the file as Lastname_Firstname_Board_Logos
Open the file Logos_Presentation.
Save the presentation as Lastname_Firstname_Logos_Presentation.
Insert the file name in the handouts footer.
In the presentation, apply a design theme.
Add titles containing the names of artists to the slides; select any names from the Excel workbook.
For each logo, adjust the size or add an effect.
Insert a new slide at the end of the presentation, and then Paste link the Excel chart, and resize it as necessary.
Insert the your name in the footer.

         Upload the completed  assignment files in the Assignment area.  

Special Instructions: Use the Supporting Materials below to complete the project.
Grading: Please review the rubrics for particulars.

Grading Rubrics
Performance Level
Exemplary
Accomplished
Developing
Beginning
Points
Performance Element
You consistently applied the relevant skills.
You mostly applied the relevant skills.
You sometimes, but not always, applied the relevant skills.
You rarely or never applied the relevant skills.
10/10
Create and format chart in Board_Logos worksheet
Chart is created, moved to its own sheet, and formatted accurately
Chart is created, but there are two or fewer errors in placement or formatting
Chart is created, but there are more than two errors in placement or formatting
Chart is not created, or it is not moved and formatted
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
Insert two comments in Board_Logos_worksheet
Two comments are inserted and placed accurately in the worksheet
Two comments are inserted and placed with two or fewer errors
Two comments are inserted and placed with more than two errors
Comments are not inserted in the worksheet
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
Format Logos_ Presentation
Formatting is applied to the presentation: Design theme, titles added, images resized or formatted accurately
Table is exported and modifications are made, but there are two or fewer errors
Table is exported and modifications are made, but there are more than two errors
Table is not exported and/or  modifications are not made
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
Insert a new slide in Logos_Presentation with link to Excel chart
New slide inserted, and Excel chart is linked to the presentation accurately
New slide inserted, and Excel chart is placed with two or fewer errors
New slide inserted, and Excel chart is placed with more than  two errors
New slide is not inserted
Exemplary 10
Accomplished 7-9
Developing 4-6
Beginning 0-3
Points:
Supporting Materials  below