# ALEX Classroom Resources

ALEX Classroom Resources
Subject: Digital Literacy and Computer Science (4 - 12)
Title: Dig the Data
URL: https://www.remc.org/21Things4Students/21/13-dig-the-data/
Description:

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 activity 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 activity 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]

Subject: Digital Literacy and Computer Science (9 - 12)
Title: Computer Science Principles Unit Post AP Chapter 1 Lesson 3: Making Data Visualizations
URL: https://curriculum.code.org/csp-18/post-ap/3/
Description:

Now that students have had the chance to see and evaluate various data visualizations, they will learn to make visualizations of their own. This lesson teaches students how to build visualizations from provided datasets. The levels in Code Studio provide a detailed walkthrough of how to use Google Sheets to create several different kinds of charts. While this lesson focuses on the Google Sheets tool, other tools may be substituted at the teacher’s discretion, and MS Excel support is coming soon to the lesson.

The main activity teaches students to build different chart types (scatter, line, and bar charts) from a single data set. It should be emphasized to students that the purpose of this lesson is to explore and experiment with creating different types of visualizations, not to build the perfect chart. Students will have a chance to create and customize their own charts. At the end of class, students compare their custom visualizations with those of their classmates.

Students will be able to:
- select the appropriate type of data visualization to discover trends and patterns within a dataset.
- create a bar, line, and scatter chart from a dataset using a computational tool.
- use the settings of a data visualization tool to manipulate and refine the features of a data visualization.

Note: You will need to create a free account on code.org before you can view this resource.

Subject: Digital Literacy and Computer Science (9 - 12)
Title: Computer Science Principles Unit Post AP Chapter 1 Lesson 7: Practice PT - Tell a Data Story
URL: https://curriculum.code.org/csp-18/post-ap/7/
Description:

For this Practice PT students will analyze the data that they have been collecting as a class in order to demonstrate their ability to discover, visualize, and present a trend or pattern they find in the data. Leading up to this lesson, students will have been working in pairs to clean and summarize their data. Students should complete this project individually but can get feedback on their ideas from their data-cleaning partner.

Note: This is NOT the official AP® Performance Task that will be submitted as part of the Advanced Placement exam; it is a practice activity intended to prepare students for some portions of their individual performance at a later time.

Students will be able to:
- create summaries of a dataset using a pivot table.
- manipulate and clean data in order to prepare it for analysis.
- explain the process used to create a visualization.
- design a visualization that clearly presents a trend, pattern, or relationship within a dataset.
- create visualizations of a dataset in order to discover trends and patterns.
- draw conclusions from the contents of a data visualization.

Note: You will need to create a free account on code.org before you can view this resource.

ALEX Classroom Resources: 3