Dig the Data

Introduction

In Dig the Data you will learn about a variety of resources and techniques to analyze data by using spreadsheets and graphs. Expanding your skills in using spreadsheets can improve your teaching productivity.

A spreadsheet is like a table on steroids, where the cells are the intersection of the rows and columns, and have cell addresses like A1 (Column A, Row 1).

In addition to creating spreadsheets, you can use these programs to create charts and graphs (pie, bar, X-Y, scatterplot, etc.). The use of spreadsheets can be integrated into your classroom by asking students to evaluate or analyze data. It can also be used to look for trends in student performance, for progress monitoring, or used with student information or data warehousing systems.

We have found that spreadsheet skills in teachers are very disparate. One goal of this thing is to help everyone have basic vocabulary, graphing, charting, filtering, sorting, and formula skills with spreadsheets.

Spreadsheets in Education

What is a spreadsheet, and how can you use it in the classroom?

Educators use spreadsheets for data collection, lists, calculations, sorting, explore what-if questions, problem-solving, and for creating graphics to show trends and analysis. Please visit and explore the following resources that describe using spreadsheets in education. Your task is to identify at least two or three ideas where you can use a spreadsheet in your own practice.

Working with Spreadsheets

The three resources above should help you understand the power of spreadsheets. Now it's time to utilize that knowledge.  Start thinking about a spreadsheet application that you will use in your classroom.  Popular spreadsheet applications include Microsoft Excel now part of the free Office 365 suite,  Google Sheets (FREE in Google Drive),  Open Office spreadsheets (FREE), and many others. Check with your district if you are not sure which application is available.

Building your skills

There are numerous tutorials available online for any application you will select to use for this assignment. We have provided links to a few below.

  1. Select a spreadsheet application
  2. Review some of the videos to learn about spreadsheet basics
  3. Move through the tutorials based on your skill level
  4. Make sure you understand basic spreadsheet techniques: how to format data, sort data, create a chart or graph, generate a count, filter data, and enter and use a formula.

Formulas which are commonly applied in education will involve totaling columns of data, calculating an average, and finding maximum and minimum scores.

Your assignment will require the use of these techniques.

Excel ImageMicrosoft Office Excel Tutorials: Video/Tutorials from GCFLearnFree on Excel. Note you will have to select the version you are using (e.g. 2003 , 2007 , 2010 , 2013, 2016. Office 365 Learning Center tutorials for Excel

Google Spreadsheets: Video/Tutorials from GCFLearnFree on Google Spreadsheets


Practice Your Skills and Manipulate Data - Part 1


This is an opportunity to practice your skills with a spreadsheet if you are not fluent with spreadsheets. Your task in Part 1 is to sort the data file provided, then to sort the data to identify how many students are in the categories of Met or Exceeded in this ACT College Readiness Trend Report for Mathematics.

  1. Download the ACT College Readiness trend data file provided here (actcollegereadinesstrend.csv)
  2. Open the file in a spreadsheet program
  3. Highlight the contents of the entire spreadsheet Met or Exceeded
  4. Sort the data by smallest to largest

Below is a short (7.5 minute) video tutorial for Part 1, showing step-by-step directions. You can pause/play and enlarge it to full screen (click the bottom-right X symbol with the double headed arrow) for easier viewing. Save your work as you go because each part builds on the previous.

Direct link to the video.

Formatting and Applying Formulas - Part 2

In this part you will continue to work with the spreadsheet from Part 1. You will add titles, labels, and apply formulas to calculate the some totals and percentages. Both Excel and Google Spreadsheet actions are shown. Direct link to the video.

Graphs and Charts - Part 3

In this last part you will create a chart to look at the trend in data for those that Met and Exceeded, or Did not Meet the required score on the ACT College Readiness for Math. Direct link to the video.

This is the end of the practice section.


Data Collection


In Evaluation & Assessment, you learned about polling and survey resources to collect data. In Collaboration, you learned about sharing documents in Google Drive/Docs. Let's build on this knowledge with the use of Google forms, a powerful online survey resource that provides data in a spreadsheet format that can be shared. 

  1. Review the video/tutorials on how to use Google forms or Office365 for Business and Education.
  2. Complete the practice activity that will teach you to create a Google Form survey, use formulas to assess data, and create charts to analyze data.
  3. Download this Google Forms Practice Activity

Google FormOffice Survey