CTE21.BMA.DT.6
Create a database file.
Create a database file.
Overview
This activity allows students to create a database on paper. They will use a teacher-created table template that matches a database report template. Working in teams, students will use the student parking lot to find information about vehicles (such as the make of vehicle, model, number of doors, etc.) The team will fill in the template to create the information for a database to be created later. This helps show a connection from raw data collection to database creation.
This activity results from the ALEX Resource Development Summit.
Phase
Before/Engage
CTE21.BMA.DT.6
Learning Objectives
Students will collect raw data that will be used in the creation of a simple database.
Activity Details
- Students will be divided into groups of 3 - 5.
- Each group will pick up a clipboard, pencil, and table template.
- Explain that students are beginning a unit on database creation and usage.
- Students will preview the table template to see what type of information they will be gathering.
- Students will go out to the student parking lot (accompanied by the teacher).
- Students will find ten vehicles of their choice and fill out the appropriate data on the template for each vehicle.
- The data the students collect will be used as a source of raw data to later create a database in database software.
Assessment Strategies
As each group finishes, the template is brought to the teacher to check that all data has been correctly recorded.
Later, as each group creates a database, the teacher will check their database on the group's computer to see that the data is entered correctly.
Variation Tips
If the school does not have a student parking lot, you might use the teacher parking lot. You may also use an internet search for vehicles. If you choose the internet search, you would want to change your table labels accordingly to match internet search results.
Background / Preparation
- Collect clipboards and pencils for each group.
- Create a table on a Word document or Google Docs.
- A link to a sample Doc is provided in the digital resources.
- Have enough rows in the table so that students will be able to check out several vehicles. Ten is an adequate number.
- Put appropriate titles as labels on the top row of the table (Make, Model, # of Doors, # of tires, Car Truck SUV, Basic Color, Specialty tag yes or no, 4 Wheel Drive yes or no, or anything else appropriate for your group).
- Print enough copies for your class groups.
- Tell students ahead of time to wear comfortable footwear and attire for outdoor activity.
Total Duration
16 to 30 Minutes
URL (web address)
Student Parking Lot Table Template
