Jump to content

Unit 3: Collecting and Analyzing Student Data

From KNILT

Navigation Links:

Unit 3: Collecting and Analyzing Data

Performance Objectives

Upon completion of Unit 3, students will understand and be able to execute the analytical capabilities of Google Sheets.

By the end of this unit students will be able to:

  1. Identify points for data collection
  2. Execute functions to organize data
  3. Demonstrate ability to analyze data
  4. Explain results of analysis

Directions

  • Please navigate through the mini-lesson
    • Collecting Data
    • Analyzing Data
    • Examples for Classroom Use
  • Complete Learning Activity
    • NYS Math Test Data

Mini-Lesson

1. Collecting Data

Types of data to be collected:

  • Formative Data
  • Observational Data
  • Summative Data
  • Student Files
  • Student Reported Data

Read this article for descriptions on each: Collecting Data in the Classroom: A Teacher’s Guide

Why is Data Important? Read this article: 6 Ways to Promote Data Driven Instruction in K-12 Schools

2. Analyzing Data

  • Organizing Data
Load video
YouTube
  • Test Data Over Time
Load video
YouTube
  • Using Charts to Analyze Data
Load video
YouTube

3. Examples for Classroom Use

Please read the case studies in Using Data to Guide Instruction and Improve Student Learning Examples for data analysis in school:

  • Demographic data: student population, participation, attendance, and least restrictive environment for students with disabilities
  • Student learning data: State Assessment of Knowledge and Skills in reading/ELA (English language arts) and mathematics, adequate yearly progress (AYP) in reading/ELA and mathematics, and beginning- and end-of-year data from the STAR Reading assessment and the State Proficiency Reading Inventory
  • Disciplinary: office disciplinary referrals, suspensions, and disciplinary alternative education program

Learning Activities

1. Case study of 2006 - 2011 NYS Math Test Results By Grade - School Level

  • Use this data: NYC Data
  • Create charts analyzing the data by grade and year
  • Share the link to your document in this Sheet: Google Sheet

Closing Statement

Congratulations on completing the Introduction to Google Sheets course! Please continue to use this site as a resource when implementing Google Suites in your classroom. The Google Sheet will continue to fill with unique projects as students complete the course, so check back for ideas!

Best wishes!

Extended Resources

Calgary, O. (n.d.). 2006 - 2011 NYS Math Test Results By Grade - School Level - All Students. NYC Open Data. https://data.cityofnewyork.us/Education/2006-2011-NYS-Math-Test-Results-By-Grade-School-Le/jufi-gzgp/data.

Collecting Data in the Classroom: A Teacher's Guide: Resilient Educator. ResilientEducator.com. (2021, April 14). https://resilienteducator.com/classroom-resources/collecting-data-in-the-classroom-a-teachers-guide/.

Creating Charts from Google Sheets. (2017). YouTube. https://youtu.be/UOoH0Lb4dc4.

Google Sheets- Sort and Filters. (2014). YouTube. https://youtu.be/3OcDd55JJXQ.

Lange, J. (2014, July 3). 6 Ways to Promote Data-Driven Instruction in K-12 Schools. Getting Smart. https://www.gettingsmart.com/2014/07/6-ways-promote-data-driven-instruction-k-12-schools/.

Lewis, D., Madison-Harris, R., Muoneke, A., & Times, C. (n.d.). Using Data to Guide Instruction and Improve Student Learning. Using Data to Guide Instruction and Improve Student Learning - SEDL Letter, Linking Research and Practice, Volume XXII, Number 2. https://sedl.org/pubs/sedl-letter/v22n02/using-data.html.

Track Student Progress with Google Sheets. (2016). YouTube. https://youtu.be/GjjTCYl8YQc.

Retrieved from "https://knilt.arcc.albany.edu/index.php?title=Unit_3:_Collecting_and_Analyzing_Student_Data&oldid=180755"