Assignment instructions | Information Systems homework help

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

1. Open the file Board Logos.
2. Save as Lastname_Firstname_Logos_Board_Logos
3. Adjust the column widths so that all data displays and apply a cell style to the title.
4. Create a chart to display the Last Name and Commission on a new sheet with an applicable name.
5. Format the chart using a chart layout and a chart style.
6. Insert at least two comments on the Artists worksheet.
7. Rename the data sheet with a descriptive name.
8. Insert the your name in the footer of all worksheets.
9. Save the file as Lastname_Firstname_Board_Logos
10. Open the file Logos_Presentation.
11. Save the presentation as Lastname_Firstname_Logos_Presentation.
12. Insert the file name in the handouts footer.
13. In the presentation, apply a design theme.
14. Add titles containing the names of artists to the slides; select any names from the Excel workbook.
15. For each logo, adjust the size or add an effect.
16. Insert a new slide at the end of the presentation, and then Paste link the Excel chart, and resize it as necessary.
17. 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