Creating Databases with Airtable
Free to teach as-is โ the teacher guide, student handout, and slides are included.
Free โ we'll email you an access link. Google Docs format.
Objective
I can create a basic database in Airtable.
Part 1 of 4
Warm-up video
Gareth Pronovost | Build Without Code ยท 10:08
We don't generate video โ this one is by Gareth Pronovost | Build Without Code on YouTube. The practice questions and exit ticket below were drafted by AI for this objective, and every question is editable in the teacher guide.
Part 2 of 4
Key concepts
3 concepts
- 1
In Airtable, a collection of databases is called a workspace, and individual databases are called bases.
- 2
Instead of columns and rows, Airtable uses fields and records to organize data.
- 3
Airtable allows you to link tables using relationships and view your data in different ways, such as a calendar view.
Part 3 of 4
Practice
3 questions
In Airtable, what is the term used for columns, similar to Excel?
Describe the main difference between a 'workspace' and a 'base' in Airtable.
Part 4 of 4
Exit ticket
Quick comprehension check
โCreate a new base in Airtable. Name the base "Freelancer Payments". Add a table called "Freelancers". Add three fields to the table: "Full Name" (text), "Hourly Rate" (currency), and "Hours Worked" (number).โ
Sample answer included in the free materials
Get the materials
Teacher guide, student handout, and slides โ free, in Google Docs format
Teacher Guide
Complete lesson plan with answer keys and alternate activities
Student Handout
Printable worksheet
Slides
Ready to present
We'll ask for your email to send your access link โ nothing else.
Teaching a group at a different level?
Where are your students right now? We'll rebuild this lesson to match โ including the teacher guide, student handout, and slides, saved to your Google Drive.
Adapt This Lesson

