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

Get perfect grades by consistently using www.college-experts.com. Place your order and get a quality paper today. Take advantage of our current 20% discount by using the coupon code GET20


Order a Similar Paper Order a Different Paper


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
Writerbay.net

Do you need help with this or a different assignment? We offer CONFIDENTIAL, ORIGINAL (Turnitin/LopesWrite/SafeAssign checks), and PRIVATE services using latest (within 5 years) peer-reviewed articles. Kindly click on ORDER NOW to receive an A++ paper from our masters- and PhD writers.

Get a 15% discount on your order using the following coupon code SAVE15


Order a Similar Paper Order a Different Paper