In this video, you will sort the data you’ve collected to balance your priorities and evaluate the data to make a decision about which product to 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, prioritize 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 A to Z, that is, from lowest to highest.
A pop-up message appears because this is part of the range of protected cells.
Accept the changes.
Sorting the column reorders the rows by cost.
Next, think about other factors that matter to you.
Does the most inexpensive phone meet your needs?
You might want to sort your spreadsheet by a different column, like storage capacity and from the highest capacity to the lowest capacity.
Take a few minutes to make sure you’ve captured the factors that are important to you on your spreadsheet.
Make additions as necessary.
Evaluate the data.
Then, make a decision about which product is best for you!
There is no objective, “best” choice in situations like these.
Make the decision that is right 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.
After completing this activity, you might determine that none of the choices suit you.
That is okay, too.
Once you’ve decided on a product, highlight it in your spreadsheet.
Select the row, and change the fill color.
Then, partner up 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.
1. Budget to Make Good Financial Decisions
2. Long-Term Spending Decisions
3. Review Spreadsheet Terms
4. Research and Collect Data
5. Research Costs
6. Add Rows and Duplicate Formulas
7. Use Data to Inform a Decision
8. Using Formulas to Inform Decisions
9. CCE Plan and Budget Activity 1 Reflection