Please pardon our progress while we refine the look and functionality of our new ALEX site! You can still access the old ALEX site at alex.asc.edu. If you would like to share feedback or have a question for the ALEX Team, you can use the contact form here, or email us directly at administrator@alex.state.al.us.

### Overview

Students will work collaboratively to collect data in a spreadsheet and create graphs or charts using Nearpod.

This activity results from the ALEX Resource Development Summit.

## UP:DLCS18.K.10

• graph
• data

### Knowledge

Students know:
• data can be collected in various ways.
• results of data can be depicted in various ways.

### Skills

Students are able to:
• collect data using simple methods such as tally sheets, paper squares, voting.
• as a group build simple graphs on paper.
• as a group enter simple data into a spreadsheet.

### Understanding

Students understand that:
• data can be collected in various ways.
• results of data can be shared in various ways such as graphs, picture charts.

### Phase

During/Explore/Explain
Learning Objectives

### Learning Objectives

Students will use a spreadsheet to collaboratively collect data and organize it in a chart or graph.

### Activity Details

The teacher will launch Nearpod and give students a code to begin.

Working as a teacher-paced lesson, follow the instructions in the Nearpod.

The students will create a spreadsheet and collect data from their classmates to create a graph and chart using the data they have collected.

Data recommended in the lesson should include shoe size, birth month, favorite movie, favorite subject, and whether or not classmates have a pet.

The more data with numbers that are used, the more graphs and charts the students can create.

The teacher will use the graph(s) and chart(s) in order to assess the students' work.

Assessment Strategies

### Assessment Strategies

A grading rubric such as the following could be used to assess each student's spreadsheet:

Did student collect all required data. Complete? 30 pts

Does spreadsheet include graph? 35 pts

Does spreadsheet include chart? 35 pts

### Background / Preparation

The teacher will need a Nearpod account to launch the lesson.

This lesson is recommended as a teacher-paced lesson.

Students will need to know how to create a spreadsheet in either Sheets or Excel.

Instructions on creating the graph and chart from the data are included in the Nearpod lesson.