Q5 Case Cracking Formulas: Completing this Quest
Completing this Quest
In this Quest, you learned how to use formulas and functions in a spreadsheet to perform accurate calculations and uncover patterns hidden in your data. By selecting the correct cells and checking for errors, you used tools like AutoSum, SUM, AVERAGE, MIN, and MAX to turn numbers into reliable clues that helped move the investigation forward. You have completed this Quest when you have:
- Determined what a formula and cell reference are based on the video you played.
- Created your formulas in the Lego Minifig and Sports Cards spreadsheet, specifically equals and sigma for adding, subtracting, and auto summing values.
- Recorded your answers and reflections in your 13. Data Detective Notebook on slides 9, 10, & 11.
Check off this Quest on the 21T4S roadmap if it is used in class.
I am ready to go on to Quest 6.
Competencies & Standards
MITECS Michigan Integrated Technology Competencies for Students, and
5. Computational Thinker
b. collect data or identify relevant data sets
6. Creative Communicator
c. communicate complex ideas clearly and effectively by creating or using a variety of digital objects such as visualizations, models or simulations
d. publish or present content that customizes the message and medium for a variety of audiences
Websites and Documents
No Websites or Documents on this Page