# 13. Dig the Data

## 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 One-Five 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.

## 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 Six-Ten 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.

## 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.
Go to the graduation page for this Thing.

## Websites and Applications

Websites and Apps

Box and Whisker Plots

Coffee Shop

GA Spinner

Interactive Spinner

Math Warehouse

My Rate Plan Site

Microsoft Office GCFL LearnFree Excel 2016

Numbers

Probability Tutorial

Sort it Out

Spinner App