As educators, we collect substantial amounts of data from our students. While this information is useful, it can be daunting for teachers to know how to manage and coordinate it in a meaningful way. This unit discusses how to analyze the collected input and how to interpret the results.

What Will You Learn?

In this unit, you’ll learn:

  • How to use conditional formatting to efficiently display results.
  • How to analyze large data sets with pivot tables
  • How to interpret trends in data sets
  • How to customize your data view using filters

If you already know this material, feel free to skip to the Unit Review at the end.

What Products Will We Cover?

Throughout this unit, we’ll be using these products. You don’t have to master them, but if you’ve never used them before, take a moment to get familiar with them. For help, click the icons below.

What Skills Will You Need?

Throughout this unit, we’ll ask you to do tasks that require the following skills. Don’t worry; we’ll show you where to learn each skill here AND again in each lesson.

Use the SORT Function to sort data

Use the SUM function to add data

Use the UNIQUE function to visualize data more effectively

Create Visualizations of the Data to Analyze and Share.

Filter the Data into Manageable Summaries.

Choose a Form Response Destination

Import Data Sets and Spreadsheets