Creating Databases with Airtable

AdultComputer Science28 min

Learning Objective

I can create a basic database in Airtable.

Lesson Flow

Watch Video

11 min

Getting Started with Airtable

Gareth Pronovost | Build Without Code

Guided Notes

6 min

Key concepts students will learn:

  • β€’

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

  • β€’

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

  • β€’

    Airtable allows you to link tables using relationships and view your data in different ways, such as a calendar view.

Practice

10 min

3 questions β€’ Multiple choice & Short answer

Exit Ticket

5 min

β€œ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).”

Teacher Guide

Get the complete package:

  • Answer keys for all questions
  • Differentiation strategies
  • Extension activities
  • Printable student handouts