Learning Resource Type

Learning Activity

Collecting and Organizing Data

Subject Area

Digital Literacy and Computer Science




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.

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


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

    Unpacked Content



    • graph
    • spreadsheet
    • data


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


    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.


    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

    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 and Preparation

    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.

    Digital Tools / Resources