Lab 1: Understanding Excel Limitations
Audit duplicates, inconsistent formats, missing values, and cross-file mismatches in the three departmental spreadsheets.
BEFORE THE LAB
1. Prepare for Lab 1
Bring the three spreadsheet files and read the Lab 1 handout. There is no separate SQL pre-lab.
DURING THE LAB
2. Use the official questions and data
The handout contains the complete questions, required column names, findings, and report instructions. Keep its question numbers in your report.
Spreadsheets: follow the handout in the assigned tool using the Canvas files above.
Keep your SQL as text, your result evidence, and your explanation together. Complete the handout’s client task and personal reflections where assigned.
AFTER THE LAB
3. Submit your own lab report
You may work with others as the handout permits, but each person submits their own report. Use the official report template and check the assignment for the current deadline and requirements.
Submit Lab 1 in Canvas ↗Running SQL or downloading a draft here does not submit anything to Canvas.