Lesson Plan

• Describe the components of a field (name, length, data type, coding) and their purpose.
• Explain how to calculate a record’s storage size from its field lengths and data types.
• Apply best‑practice rules to design an efficient field structure for a sample student record.
• Interpret common coding schemes (e.g., M/F for gender) and select appropriate codes for new fields.

• Projector and screen
• Whiteboard and markers
• Printed handout of the student record table
• Worksheet with design and calculation tasks
• Laptops with spreadsheet or simple DB software
• Exit‑ticket slips

Begin with a quick question: “Where does the school keep all the information about you?” Use the responses to link prior knowledge of records to today’s focus on field structures. Explain that by the end of the lesson students will be able to identify each field component, calculate record size, and design clear, efficient fields.

1. Do‑now (5'): Mini‑quiz on field components; collect answers.
2. Mini‑lecture (10'): Present field name, length, data type, coding with the student record example.
3. Guided practice (10'): Calculate the record size together using the example table.
4. Group activity (15'): Design a field structure for a new “Library Book” record, decide appropriate lengths, data types, and any coding schemes.
5. Class share (5'): Groups present their designs; teacher highlights best practices.
6. Exit ticket (5'): Each student writes one best‑practice rule they will apply in future designs.

Recap the four field components and the steps for estimating record size. Collect the exit tickets to check understanding, and assign homework: students must create a field list for their personal contact information, including appropriate coding where needed.