digthedata

Q7 Just Function (Fx)

13. Dig the Data

Introduction

Spreadsheets allow you to organize your data. This Quest will help you create and use data in the form of a spreadsheet to make wise decisions. Pay close attention to using functions and graphs so that you can analyze your data effectively. For this Quest, you will need to check in with your teacher to establish which activity you will complete.

Cell Phone Use is an activity where you will use data provided on cell phone usage (or your own): minutes, text messages, and data. You will enter the data in a spreadsheet, do totals and averages, and graph the data. Then after analyzing the data you will look at different cell phone plans and find one to recommend that you feel is the best choice for your location. 

Hungry Mungry is an activity where you examine the eating habits of a boy named Mungry by entering data into a spreadsheet, creating totals and illustrating the data in bar graphs and pie charts. Then you will compare his eating habits to the healthy dietary guidelines and provide recommendations for change.


I Can Statements

  • analyze data and create different visual representations of it
  • can use spreadsheets, charts and visual representations are tools to help organize, evaluate, and present data
  • create, organize, analyze and share representations of data in a spreadsheet, chart, graph, and data plot formats with my teacher and classmates

Key Vocabulary

Analyze: To analyze is to help us to learn what our data might mean in a spreadsheet. 

Functions: Functions are redefined formulas and are already available in modern-day spreadsheets like Microsoft Excel or Google Sheets. 


Play the interactive Quizlet Game: Direct Link

Steps

1. Preview the activities and select one and discuss your choice with your teacher.


Completing this Quest

Your directions for completing this Quest are listed in the directions for each of the activities linked above.  Be sure that you have submitted your work to your File Space.  


Check off one or both from your 21t4s roadmap 

I have completed this Quest and am ready for Quest 8 Whiskers

MITECS Michigan Integrated Technology Competencies for Students, and

ISTE Standards for Students

1. Empowered Learner
d. Understand the fundamental concepts of technology operations, demonstrate the ability to choose, use and troubleshoot current technologies and are able to transfer their knowledge to explore emerging technologies

5. Computational Thinker
a. Formulate problem definitions suited for technology assisted methods such as data analysis, abstract models and algorithmic thinking in exploring and finding solutions
b. Collect data or identify relevant data sets, use digital tools to analyze them, and represent data in various ways to facilitate problem-solving and decision-making
c. Break problems into component parts, extract key information, and develop descriptive models to understand complex systems or facilitate problem-solving

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

21t4s Videos

21t4s Websites

21t4s Documents & Quizzes