Skip to content

3. Research and Collect Data

Playback Speed:
Transcript

In this video, you will use a spreadsheet to help you organize information about one product.

In the next video, you will add information about more products.

This example spreadsheet will compare cell phones with data plans, but you can research and compare any type of product and contract.

You might want to compare cable TV or internet providers, gym memberships, or digital media subscriptions, for example.

You can use these same skills to evaluate a one-time purchase, too.

But for this activity, think of a product that has recurring payments with published fees and rates.

Here is an example of the spreadsheet you will create.

Each row contains one product, like a phone with a service plan.

Each column contains a category, like costs or features.

Name the first column “Product.”

Add the name of a phone you like to this column.

Next, add labels for columns to track other features.

You might consider screen size, camera quality, storage capacity, or battery life.

Focus on different features for now; you will learn more about evaluating costs soon.

Spreadsheets like this one evolve as you do more research, so you don’t need to include every feature right now.

You will add more columns as you work.

As you add rows and columns, it may be hard to see your labels.

To make sure you can see your labels, freeze the top row and the first column of the spreadsheet.

Select “View” and “Freeze.”

The frozen column remains visible even when you scroll down to another area of the spreadsheet.

Now that you’ve started setting up your spreadsheet, research some of these features.

In a separate tab or window, search the internet for a particular product or service provider.

It’s a good idea to keep track of the websites you visit so you can easily get back to them.

Create a column for “Website” and copy the URL into the correct row.

As you find information about a product, enter data using this example as a guide.

Your columns don’t have to match the ones in this example.

Just make sure to label each column clearly.

Add more columns as you find additional elements.

For example, you could add a column to indicate whether each phone is available in a particular color.

Continue adding different options about one product until you’ve recorded everything that’s important to you.

Create at least five columns in your spreadsheet.

Then, move on to the next video to gather information about costs.

Now, it’s your turn: Type “Product” in cell A1.

Freeze the top row and first column to make it easier to work with your spreadsheet.

Search the internet and add data to your spreadsheet.

Add column headings to your spreadsheet to group the information you find, until you have at least five columns.

Then, move on to the next video to research costs.

Next
Instructions
  1. Type "Product" in cell A1 and other phones to research in column A.
  2. Add additional columns to track features that are important to you.
  3. Freeze the top row and first two columns to make it easier to work with your spreadsheet.
  4. Research the first phone.
  5. Add data to your spreadsheet until you have at least five columns.
Attributions
  • "Republic Wireless Samsung Galaxy S7 Page" by Republic Wireless (https://republicwireless.com/phones/samsung-galaxy-s7/)