- 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
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
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:
- One Excel workbook with 4 worksheets (2 data sheets, 2 chart sheets)
- 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