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.

Car Cruising is an activity where you will collect data on the cars in your parking lot (or alternate lot identified by your teacher). You will collect data about the car color, model, and license plate month. You will learn how to use different sheets in a spreadsheet, have the spreadsheet calculate totals, percents (%), and create different graphics (bar chart, pie chart, and one of your choice). -or-

Cell Phone Use is an activity where you will use data provided on cell phone useage: minutes and text messages. 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 recommend the one you think would be best. -or-

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.

Steps:

1. Discuss which activity (or activities) you will complete.

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

ISTE and Common Core Standards

ISTE Standards•S

1. Empowered Learner
a.articulate and set personal learning goals, develop strategies leveraging technology to achieve them, and reflect on the learning process itself to improve learning outcomes
b. Build networks and customize their learning environments in ways that support the learning process
d. Understand the fundamental concepts of technology operations, demonstrate the ability to choose, use and troubleshoot current technologies, are able to transfer their knowledge to explore emerging technologies

2. Digital Citizen
b. Engage in positive, safe, legal and ethical behavior when using technology, including social interactions online or when using networked devices

Common Core Standards

CCSS.ELA-Literacy.CCRA.L.1 Demonstrate command of the conventions of standard English grammar and usage when writing or speaking.
CCSS.ELA-Literacy.CCRA.L.2 Demonstrate command of the conventions of standard English capitalization, punctuation, and spelling when writing.
CCSS.ELA-Literacy.CCRA.W.4 Produce clear and coherent writing in which the development, organization, and style are appropriate to task, purpose, and audience.

CCSS.M.6.SP.4
Summarize and describe distributions.

CCSS.M.6.SP.5a
Summarize numerical data sets

CCSS MP4. MOdel with Mathematics.

CCSS MP5. Use appropriate tools strategically