Hour 1-2: Basic Data Manipulation
Part 1: Introduction to data manipulation in Airtable
Explanation of the importance of data manipulation in organizing, analyzing, and presenting information Overview of the various ways to manipulate data in Airtable, including sorting, filtering, and searching Part 2: Sorting, filtering, and searching data
Click the "Sort" button at the top-right corner of the Airtable interface or right-click a column header and choose "Sort". Select the field to sort by and choose the sorting order (ascending or descending). Add additional sorting criteria if necessary. Click the "Filter" button at the top-right corner of the Airtable interface or right-click a column header and choose "Filter". Set the filter criteria by selecting a field, a condition, and a value. Add additional filters if necessary, choosing whether they should be combined using "AND" or "OR" logic. Use the search bar at the top-right corner of the Airtable interface to quickly search for specific keywords or phrases within the table. Use the "Advanced Search" feature to perform more complex searches based on multiple criteria and conditions. Part 3: Hands-on exercise: Manipulating data in a table
Students will work with a sample Airtable base provided by the instructor. Practice sorting the data by different fields and in different orders. Apply filters to display only specific records based on certain criteria. Use the search functionality to find records containing specific keywords or phrases. In this hour, students will learn about the basic data manipulation techniques in Airtable, including sorting, filtering, and searching. They will practice these techniques using a sample base provided by the instructor, helping them gain a better understanding of how to effectively organize and analyze data in Airtable.
Here's the sample data in a table format:
To create this base in Airtable:
Sign in to Airtable and click the "Add a base" button. Choose "Start from scratch" and name the base (e.g., "Team Tasks"). In the new base, you'll see a default table called "Table 1". Rename it to "Tasks". Customize the fields in the "Tasks" table: Keep the first field as "Task ID" and set its field type to "Number". Change the second field to "Task Name" and set its field type to "Single line text". Change the third field to "Assigned To" and set its field type to "Single select". Add options for the team members (e.g., Alice, Bob, Carol, David). Change the fourth field to "Priority" and set its field type to "Single select". Add options for priority levels (e.g., High, Medium, Low). Change the fifth field to "Status" and set its field type to "Single select". Add options for status (e.g., Not started, In progress, Completed). Change the sixth field to "Due Date" and set its field type to "Date". Enter the sample data provided above into the "Tasks" table.
Now you have a simple Airtable base for managing tasks, with fields for task ID, task name, assigned team member, priority, status, and due date.
Day 3 - Hours 1-2