Please read direction carefully, and look at the videos "THIS IS A EXCEL DATA ENTRY CLASS"

Objectives:

• Apply professional formatting and worksheet design guidelines
• Create functions
• Combine data from different workbooks
• Delete Rows/Columns
• Enter and edit data on multiple worksheets at the same time
• Compare data using charts created in Excel
• Identify the correct chart type based on message and comparison
• Analyze and interpret data—determine the message to be communicated and create a point of view

Instructions:

Step 1: Select the Data

Review classmates’ submissions for Assignment 1Choose two classmates’ workbooks that you find interestingCopy each of the worksheets from the original students’ documents into a new workbook (sample below):

Example of how initial data will look in A2 when copied over

Step 2: Create the charts

Decide on a message you would like to communicate with the data table provided.  Remove any extraneous columns/rows/data not relevant to chart message.

Create a chart for each set of data including: 

• A directed point of view message as chart title
• Chart type that accurately communicates the message chosen (reminder: No 3-D charts)
• Data Labels
• Axis Titles
• No series errors
• Legend (if appropriate)

Move each chart to its own worksheet (as a Chart Sheet)

Format chart to be legible and professional looking (should be able to read all data)

Step 3: Create 4 new functions

Using any of the Built-in functions from Excel you will create 2 new functions on each worksheet (for a total of 4 new and unique functions)

Several functions can be found in Chapter 6 from Week2 Detailed Readings (Meeting Excel's Built-in Functions)

• Make sure the functions are relevant to the data set
• The functions should provide some sort of analysis
• Include labels in the cells near the functions to let the audience know what the number represents

Note: If original student already had a function on the worksheet, choose a new/different function to enhance the data.

Strive for the labels on the left giving the audience a report format

VIDEO LINK: https://www.youtube.com/watch?v=cBp_KOxF71M

Professionally format all worksheets.

Ensure Data Labels clearly designate analysis for the audience.

Step 4: Apply Worksheet Design Guidelines     

Special Note on Worksheet Design Guidelines:Design Guidelines were likely created by the original student.  If you used the Copy Worksheet procedure, the comments, etc may have copied with it.

Add and/or adjust all worksheet design guidelines to reflect your own information.  You will not be able to add comments to the chart sheets.  This is expected.  Add your comments to each of the data worksheets.

Reminder: “Grouping” the worksheets will save time on many of the design guidelines (Week1 Detailed Readings, Chapter 3)

If you need a refresher on how to complete the Worksheet Design Guidelines, the video is below.  If not, proceed to Step 5.

VIDEO LINK: https://www.youtube.com/watch?v=zH6HZdYC_d4

Step 5: Print to PDF & Submission

Print all four worksheets into one PDF document

https://www.youtube.com/watch?time_continue=3&v=ilzvqUAxy5k: VIDEO LINK

A total of 2 documents will be submitted in the assignment upload area:

1. One Excel workbook with 4 worksheets (2 data sheets, 2 chart sheets)
2. One PDF that includes a print version of all 4 worksheets.  The PDF will be used to upload to your Portfolio in a later class