Collecting and Organizing Data

Learning Resource Type

Learning Activity

Subject Area

Digital Literacy and Computer Science

Grade(s)

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.

Phase

During/Explore/Explain

Digital Literacy and Computer Science (2018) Grade(s): KG

DLCS18.K.10
Collect data and organize it in a chart or graph collaboratively.

Vocabulary

graph
spreadsheet
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.

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

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.

Data Collection Nearpod

https://share.nearpod.com/hIpE9dVDpX

Approved Date

2019-06-11

Owner (Author)

alliflowers

Design by Adaptive Theme