In this video, you will sort the data you collected
to help you make a decision about which product you would purchase.
Then, you will discuss your decisions with a partner.
By now, you have entered lots of information into your spreadsheet.
To make your decision easier, organize the data so you can see which products best fit
your personal preferences.
Find a column with information that is very important for your decision -- cost, for example.
Select the column “Total Plan Cost.”
Then, sort the column from lowest to highest.
Next, think about other factors that matter to you.
Perhaps storage capacity is really important.
Sort the sheet using the “Storage Capacity” column.
Now, the spreadsheet is organized by storage capacity first, then by cost.
Take a few minutes to make sure you’ve captured the factors that are important to you
on your spreadsheet.
Make additions as necessary.
Then, evaluate the data.
Make a decision about which product would be best for you!
Spreadsheets make it possible to view and compare data in one place
and synthesize costs into one total.
Then, it is easier to make an informed decision.
There is usually no “best” choice in situations like these.
Make the decision that is right for you.
Your classmates may make different decisions, and that is okay.
Once you’ve decided on a product, highlight it in your spreadsheet.
Select the row, and change the fill color.
Then, partner with a neighbor.
Compare your spreadsheets.
Show each other the products you found and discuss how you made your decisions.
Ask your partner which products they found and which data was most important to them.
How did they make their decision?
Discuss all these questions with your partner.
Does anything they said make you change your mind about your decision?
If so, why?
Now, it’s your turn:
Sort the data you collected according to your priorities.
Then, review the data you collected and calculations you made.
Decide on the best choice for you and highlight your decision on the spreadsheet.
Then, partner up with a neighbor to discuss your decisions.