Lesson Plan

• Describe the characteristics of CSV and TXT source files and the role of delimiters and header rows.
• Explain how to prepare a text file for import, including encoding, field consistency, and quoting.
• Apply the import‑wizard steps to map fields, define data types, and set primary keys in a database.
• Troubleshoot common import issues such as delimiter mismatches, text truncation, date formats, and duplicate keys.

• Computer lab with each student’s PC.
• Database software (Access, LibreOffice Base, or MySQL Workbench).
• Sample .csv and .txt files (e.g., student scores).
• Projector and screen for demonstration.
• Plain‑text editor (Notepad) and spreadsheet program (Excel/LibreOffice Calc).
• Printed handout of the import checklist.

Begin by asking students how data from spreadsheets can be moved into a database. Recall the purpose of delimiters and header rows from previous lessons. Explain that today they will learn to import CSV and TXT files and will be able to create a functional table by the end of class.

1. Do‑now (5'): Students examine a sample CSV file and identify the delimiter and whether a header row is present.
2. Mini‑lecture (10'): Teacher reviews source file types, preparation steps, and naming conventions for fields.
3. Guided demo (15'): Using the projector, walk through the Import Wizard, setting delimiter, field names, data types, and primary key.
4. Pair activity (15'): Learners import a provided TXT file, create field names, and define data types while the teacher circulates.
5. Troubleshooting challenge (10'): Groups receive a faulty import file and must diagnose and fix issues using the checklist.
6. Exit ticket (5'): Students write one key step they will remember when importing data and any remaining question.

Summarize the import workflow from file preparation to final table creation. Collect the exit tickets to gauge understanding of the most important step. For homework, students will locate a real‑world CSV file and prepare an import plan using the checklist.