Unit 5 Lab 3: Comparing Electric Bikes

Unit 5 Lab 3: Comparing Electric Bikes
Importing and Accessing Data

In this project, you will use a small table about electric bikes. You will build simple selector blocks that help you pull out headings, bike records, single values, and whole columns.

Start a New Project called U5L3-ElectricBikes

1. This starter project already has a sample electric bike table.
2. Look at the table watcher on the stage. The first row contains the column headings.
3. Try item () of list with different numbers to inspect rows in the table.
4. Talk with your partner: How is item (1) different from the other items?
5. Try all but first of list. What part of the table does it remove?
6. Build these selector blocks:
   - headings of bike table () reports only the headings.
   - bikes in table () reports only the bike data, not the headings.

Records, Fields, and Columns

A record is one row of data about one bike. A field is one value inside a record. A column is one kind of value for every bike.

7. Build bike () from table () and field () from bike () blocks.
8. Build bike column () from bikes () to report one column from the data.
9. Use one column to answer a simple question, such as: Which bike has the longest range? What is the average price? Which bike is the lightest?

Cleaning Data

Data can be messy. One bike might list range in miles while another lists range in kilometers. A brand name might be spelled two different ways. A price might be missing.

Cleaning data means making the data consistent without changing what it means.

Write Out Your Thoughts

If your class collected data about electric bikes, what are two problems that could make the data hard to compare?