Introduction

The word Dig can be an analogy 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 10 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 of it
     
  2. understand that spreadsheets, charts and visual representations are tools to help organize, evaluate, and present data
     
  3. meet international technology standards for Empowered Learner, Digital Citizen,  Computational Thinker, Creative Communicator and Global Collaborator
     
  4. create, organize, analyze and share representations of data in spreadsheet, chart, graph, and data plot formats with your teacher and classmates

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.

I am ready to plan the party in Quest 1


Quest 2: Format, Insert & Merge

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

I am ready for Quest 2


Quest 3: Formulas

Learn to make the spreadsheet calculate numbers for you!

Quick, I really need Quest 3 formulas


Quest 4: Make it Visual

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

Take me to Quest 4 


Quest 5: Share It

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

I'm ready for Quest 5  

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 Wordle 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

Complete Student Checklist

 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