Session 1 activities
ACTIVITIES · 36 MINFictional data only
You can do every activity here. Sign in to save your responses and add your vote to the class tally.
Load it or not?
Sort each dataset: can it go into the approved AI analysis feature in class?
- The fictional Bayside scrap log provided by the instructor
- Cape Harbor Inn's real guest list with card numbers
- A de-identified, fictional dental scheduling file from the course folder
- Pioneer Valley Mutual's real renewal list with policyholder names and dates of birth
- Public U.S. Census population tables for Worcester County
- Your employer's unreleased quarterly financials
Scrap log cleanup
Branching. Source: Bayside Precision Parts scrap log excerpt (fictional): date | machine | part | qty_scrapped | unit_cost | reason 2026-07-02 | VF-4 | BP-2207 | 6 | 18.40 | tool break 07/02/2026 | VF4 | BP-2207 | 6 | 18.40 | tool break 2026-07-03 | vf 4 | BP-1150 | 2 | 42.00 | dimension 2026-07-03 | Lathe-2 | BP-3300 | | 9.75 | finish 2026-07-05 | Lathe-2 | BP-3300 | 3 | 9.75 | Finish 2026-07-06 | VF-4 | BP-2207 | 60 | 18.40 | dimension
Copilot flags rows 1 and 2 as duplicates. What do you do?
Ask for steps, not a file
Rebuild the weak cleanup prompt.
Weak prompt
Clean this data.
Hints (5)
- Name the columns and the problems to look for.
- Ask for formulas or Power Query steps.
- Ask it to list rows it would change and why.
- Tell it not to fill blanks or delete outliers.
- Ask for a log entry per step.
What did AI catch?
Poll after Lab 1.
Which problem did the AI find that you would most likely have missed?