Data Analyzer Spreadsheet
How to use "Data Analyzer" This video shows graphs that are created with "Data Analyzer" and how to place scores into the spreadsheet.

Data Analyzer Documents

Data Analyzer 2 inst.docx This document provides an overview of Data Analyzer as well as instructions on how to get started.

Data Analyzer 2.3.xlsx
Data Analyzer 2.3 Excel 2004.xls This version, Excel 2004 may not have all of the highlighting features of xlsx

Data Analyzer 2.1 test color code.pdf Sample pdf to show the color coding
Data Analyzer 2.1 test demo by test.pdf sample charts and graphs for demographic by test
Data Analyzer 2.1 test trend by demo.pdf Sample charts and graphs for test trends by demographics.

Purpose of Spreadsheet This spreadsheet is designed to compile data from a variety of student assessments and present the data in chart and graph form. Up to 10 different assessments can be analyzed. Analyzing this data will help determine strengths or weakness of students’ performance on these assessments. Data on identified subgroups of students can also be disaggregated. Up to four levels that can be created and named. Students will be placed into one of the levels by their assessment score. Total number and percent of students and at each level is calculated.

  • The front page is used to record scores from up to 10 test, cut scores, and standard demographics plus 2 extra columns.
    • Extra columns can be used to identify groups such as students new to the district, students opting in, students absent more than 8 days, students involved in extra curricular activities, taking specific courses or 3 years of math, coming from different schools in district or different teachers, reading below grade level, received a specific intervention, number of days absent.
  • One very nice feature is that because of new format that I learned the size of spreadsheet is very small and will easily be able to be emailed.
  • One nice addition is what is called "color coding". After the scores and cut scores are entered the students on the color coding sheet are filled in by the level of the assessment. This quickly allows the teacher to determine how the student is doing on assessments.
  • Two sets of graphs are completed.
    • Demographic by test shows a graph of how each subgroup preform on each assessment.
    • Trend by demographic can be used to show trend data or shows each demographic area did on all assessments.

Data Analyzer Ideas

  • Set up a Data Analyzer to look at several different data sources for a grade or school. For example look at NeSA-R, NeSA-M, sub scores, NRT, Dibbels,
  • Set up a Data Analyzer to look at program data. Take one or two main sources, NeSA-M, NeSA-M, and begin to look at trend data for that grade level.
  • Set up a Data Analyzer to look at cohort data. Take one or two main sources, NeSA-M, NeSA-M, and begin to look at trend data for that group of students.
  • Teacher may like to use Data Analyzer to look at just their students to see how they are doing.