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. 1

    In Airtable, a collection of databases is called a workspace, and individual databases are called bases.

  2. 2

    Instead of columns and rows, Airtable uses fields and records to organize data.

  3. 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

1

In Airtable, what is the term used for columns, similar to Excel?

2

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