Introduction

The word Dig can be a metaphor for thinking through a problem or issue or figuring something out so that you can make a decision based on your findings. In this Thing you will dig through the Quests to collect, organize and analyze data.

This Thing contains ten Quests. You will learn to create spreadsheets and charts, use formulas, and make decisions based on data. Dig In!


Learning Objectives

When you have completed this Thing you will:

  1. know how to analyze data and create different visual representations [Computational Thinker, Creative Communicator]

  2. understand how spreadsheets, charts and visual representations can help organize, evaluate, and present data [Knowledge Constructor]

  3. know different ways of organizing and sharing abstract representations of data [Creative Communicator]


Quests: 1-5 - Party Planner

Quests 1-5 will begin with the basics of creating a spreadsheet to plan a party.  You will then move on to advanced skills including charting and formulas.

Party Planner Quests 1-5

Quest 1: The Party Planning Begins! 

Learn how to name a document and enter data, and learn the difference between a cell, row, and column.


Quest 2: Format, Insert & Merge

Learn how to insert a row or column, and how to merge cells


Quest 3: Formulas

Learn to make the spreadsheet calculate numbers for you!


Quest 4: Make it Visual

Learn how to create a great looking chart from your information.


Quest 5: Share It

Learn how to share your spreadsheet with a friend, your teacher, invitees.

Quests 6-10 : Data Review & Analysis 

Quests 6-10 involve collecting and analyzing data as you: interact with a spinner; use graphs and functions (in either Car Cruising, Cell Phone Use, or Hungry Mungry); compare cell phone plans with whiskers; investigate a business (Lemonade Stand or Coffee Stand); and sort and filter a music collection. 

Data Review & Analysis Quests 6-10

Quest 6: Spin Out

You will be using an interactive spinner to collect color data and creating a visual to represent your findings.
I am ready for Quest 6


Quest 7: Just Function (Fx)

You will be using a spreadsheet to graph or chart information in either of the car cruising or cell phone use activities.

I am ready for Quest 7


Quest 8: Whiskers

You will be analyzing data on cell phone plans for voice and text messaging using a Box and Whiskers plot, and making a creative advertisement to convince others that your analysis of national data represents the best phone plan.

I am ready for Quest 8  


Quest 9: Changes over time

You will be collecting data about a business. You will help to control losses and gains in the company. The results will be shown in a line graph to sum up how the business is progressing.
I am ready for Quest 9


Quest 10: Sort It Out

You are going to manage the music for the DJ before the party begins. Your job is to sort the music in several ways and create a playlist. 

I am ready for Quest 10


Dig the Data for Gold

Additional Quest activities will be linked here. Currently there are no optional activities featured.


I have completed the Quests as assigned by my teacher. awardicon
Go to the graduation page for this Thing.

Teacher Guide


Learning Objectives Slide
 

Websites and Apps

Box and Whisker Plots www

Car Cruising Spreadsheet www

Coffee Shop www

Coffee Shop Spreadsheet www

GA Spinner iPad app

Google Chart Help www

Google Formula Help www

Google Sharing a Spreadsheet  www

Google Spreadsheet www iPad app Android

Google Spreadsheets Help www

Interactive Spinner www

Lemonade Stand www iPad appAndroid

Lucrative Lemonade Spreadsheet www

Math Warehouse www

My Rate Plan Site www

Numbers  iPad app

Probability Tutorial www

Sort it Out www

Spinner App Android

Whisker Data Spreadsheet www