Lesson Plan

• Describe what a field (column) represents in a single‑table database.
• Explain what a record (row) represents and how it relates to fields.
• Distinguish between fields and records in given examples.
• Identify an appropriate primary‑key field based on uniqueness.
• Assign correct data types to each field.

• Projector and screen
• Printed worksheet with sample student table
• Laptops/computers with spreadsheet software
• Handout of field and record definitions
• Whiteboard and markers

Start with the question, “Where do we keep student information in school?” Connect this to students’ prior experience with spreadsheets. Explain that today they will learn how to identify fields and records in a single‑table database. Success criteria: students will be able to name fields and records, choose a primary key, and assign appropriate data types.

1. Do‑now (5') – Students examine a printed table and note what each column and row represent.
2. Mini‑lecture (10') – Define field and record, show a diagram of a rectangular grid, discuss data types.
3. Guided practice (10') – Teacher labels fields and records in the student information table and selects the primary key.
4. Pair activity (12') – Students work on a new table, list its fields and records, decide on a primary key, and assign data types; teacher circulates for support.
5. Check for understanding (8') – Quick quiz (e.g., Kahoot) with three questions from the practice set.
6. Summary & reflection (5') – Review key points and answer any remaining questions.

Recap that fields are columns holding a single data type and records are rows containing a complete set of values. For the exit ticket, each student writes the primary key for today’s example and one data‑type assignment. Homework: create a simple single‑table database on a topic of their choice, list its fields and records, and designate a primary key.