Objectives:
Create an Excel workbook with external resources
Design a basic report table
Apply professional formatting to a data table
Prepare an Excel document for printing
Enter and format date data
Construct basic formulas
Step 1: Gather the data
Research and locate any data you are interested in for the entertainment industry, or alternatively, research demographics information you feel are related to the industry.
Your data must be different from other classmates. Review post summaries completed before yours to ensure there is no duplication.
The data should be a minimum of 1 column x 5 rows (or 5 columns by 1 row) and should include numbers/currency that can be calculated with a formula.
Step 2: Start the workbook and create formulas
Copy the data from the original source in your research.
In a new Excel workbook, paste the data with the data collected using the Paste Special option in the Edit Menu item.
Choose Paste "Values" or Paste "Unicode Text" (Option of Values / Unicode Text will vary depending on data collected). Note: If data does not copy/paste easily into the document, it may need to be hand-typed.
Using the data collected: Create at least 2 unique formulas or functions to analyze the data.
Below is a tutorial discussing how to bring the data into Excel.
Below is a video discussing the creation of the formulas.
Step 3: Format the data set
Formatting should include:
Change at least one font color
Change at least one font size
Change at least one type of font
Apply a background fill to your labels for the categories
Addition of borders
Professional alignment of text and/or numbers
Formatting of currency if appropriate. For any number over 1,000 that is not currency, there should be commas with no decimals
Resizing of columns or rows if necessary to ensure all data and categories can be viewed easily
Insert at least two symbols with the Excel symbol browser to help emphasize areas of interest in your data
Step 4: Worksheet Design Guidelines
File saved with assignment number and first name, last initial. For example: A1AprilW.xlsx
Headers contain name of Assignment (unless otherwise instructed) on each worksheet.
Footers contain creation date, last opened date, and student's name on each worksheet. Creation date is hand-typed. Opened date will change every time assignment is opened.
Excess sheets removed (no unused extra tabs)
Each tab contains short worksheet name (renamed, should not be: Sheet1 or Chart1, etc)
Cell formatting appropriate: text and number formatting correctly used and appropriate to the scenario. Financial figures should have currency or accounting format. Figures over 100havenodecimals.Figuresunder 100 will show two decimals.
No cells contain errors (all green triangle cells resolved)
At least one cell comment on each worksheet to document notes from class OR to emphasize outcomes (explain why you chose a certain formula, certain data or explain the outcome of data analysis)
Designed for both Normal and Page Layout views but delivered in Page Layout view with the correct perspective chosen (either portrait or landscape) - ensure that neither data nor charts cross page breaks (one page wide).
Here is a refresher on the worksheet design guidelines.
Note: this is the same video from the month-long tutorials area if you already viewed it.
Step 5: Submission
In the discussion board area:
Provide a brief explanation to other students of the data you selected. Include details such as time frame pulled, subject area, basic content of the data.
In at least one paragraph, describe how you feel the data you selected relates to your field of interest.
Include a citation/reference for the data source.