Data Manipulation

Media	Link
Slides:	Data Manipulation Google Slides
Class Recording:	This Class as a Panopto Recording*

^*In Spring 2022, when this recording was made, we missed the next session, Relational Databases (VLOOKUP and SQL), due to an official UNC holiday. Therefore, I started the recorded session with the VLOOKUP demonstration, but I had not made slides yet, so the VLOOKUP slides are near the end of the slides right before the page setup slides. The order of how you complete each worksheet does not matter, but do wait and do the page setup last.

VLOOKUP

The instructions in the grade sheet are a bit cryptic... Glance over them, then just do the project by looking at the slides and/or following the video. Then read the instructions again. Then it will make more sense. We will go over this in more depth tomorrow in the Database/SQL Session.

Media	Link
Slides:	VLOOKUP slides
Recording:	VLOOKUP Recording Segment

13-Sort: single level

1. Sort the data rows on the 13-sort NC ZIP codes worksheet by ZIP Code.
2. Have the sort display from smallest to the largest.

   Media	Link
   Slides:	View 13-sort NC ZIP codes Slides
   Recording:	View 13-sort NC ZIP codes on Panopto Recording

14-Sort: multi-level

1. Sort the data rows on the 14-SORT STATE, THEN YEAR worksheet

2. first by State alphabetically (from A to Z)

3. and then by Year completed from SMALLEST to largest.

   Media	Link
   Slides:	View 14-SORT STATE, THEN YEAR Slides
   Recording:	View 14-SORT STATE, THEN YEAR on Panopto Recording

15-Filter: single level

1. Filter the data on the15-Filter Disabled Workers worksheet to find the bottom three Congressional Districts in terms of Disabled Workers

2. Do not sort the results. Simply show the results of filtering out all but the bottom three districts.

   Media	Link
   Slides:	View 15-Filter Disabled Workers Slides
   Recording:	View 15-Filter Disabled Workers on Panopto Recording

16-Filter: multi-level (1 of 2)

1. Use a multilevel filter on the 16-Language Preferences worksheet to find out which of the languages whose names start with the letter A only

2. had Receipt Count (excluding 53rd week) between 1000 and 4000

   Media	Link
   Slides:	View 16- Language Preferences Slides
   Recording:	View 16- Language Preferences on Panopto Recording

17-Filter: multi-level (2 of 2)

Filters are powerful. Do another one:

1. Use a multilevel filter on the 17-Year & ResidentialCustomer worksheet to find out which of the Month of PeriodEndDate only in March

2. had an above average ResidentialCustomerCount

   Media	Link
   Slides:	View 17-Year & Residential Customer Filters Slides
   Recording:	View 17-Year & Residential Customer Filters on Panopto Recording

Pivot Table

Media	Link
Directions:	Click here for Pivot Table Steps
Slides:	Pivot table Slides
Recording:	View Pivot Table on Panopto Recording

Page Setup

Media	Link
Slides:	Page Set Up slides
Recording:	Page Set Up Recording Segment