Task 04 Videos

Panopto Video: A) Data: Download and Open (1:04)

• Download and Open files

Panopto Video: B) Data grade sheet and overview for first session (2:47)

• File save as Standard file naming convention
• Grade Sheet quick look
• Skip over the page setup tasks; will do it in last Data session
• Talk about leveraging other videos

Panopto Video: C) 01-Format (first worksheet) demonstration (10:29)

• 01-Format: Row 1 Green Fill
• 01-Format: Set US Census Data 16 pt white
• 01-Format: Format as Table
• 01-Format: Format your home county with Orange fill color
• 01-Format: Freeze Panes
• 01-Format: Validate the data is in next video
• 01-Format: Will skip page Layout and formatting
• 01-Format: Conditional formatting is in next video
• 01-Format: Hide column and row here and in next video

Panopto Video: D) Data Intro Spring 2023 (34:09)

• Validate Data less that equal to 9
• Skip over Page setup; will do it in last class
• 02 Conditional Formatting
• 03 Hide B and F
• 04 Hide row 81! not 63!
• 05 Create new worksheet 05-Summary
• Be Aware... There is a quick reference to an item not in this project
• 05 Insert Total number of Counties
• 05 Number of Navy Programs in North Carolina
• 05 Last Formula; not function
• 05 Percentages to 2 decimal places
• 05 Pull down Values
• 06 & 07 VLOOKUP

Panopto Video: E) 05-Summary: Total counties in us (3:02)

In the opening of this video you will see the correct placement for the first three functions.

Only the Total Counties will be demonstrated; the other are demonstrated in D) Data Intro Spring