Welcome to Lenny's Wiki!Home Site http://lvermaas.wikispaces.com/email address lennyvermaas@gmail.com

DRS Data Reporting System is back with current data that is ready to use. Advanced Inquiry lets you drill down into your data.

Graph Types
  • NeSA Growth Version 1.1--This spreadsheet creates charts and a graph to look at the progress of students from year to year on the NeSA assessments. An overview and instruction are on the first sheet of the spreadsheet. NeSA growth version 1.1.xls
  • Efficiency Rates 1.0--This spreadsheet can be used to check for growth from grade to grade. The percent proficient at each grade level is compared to the proficiency rate at the grade below. Efficiency Rate 1.0.xlsx The Excel 2004 may not have all features. Efficiency Rate 1.0 Excel 2004.xls
  • Efficiency Rates 1.1--This spreadsheet has a few more columns so that subgroups can be compared. Efficiency Rates 1.1
  • Correlation:Instructions to find a correlation between a NRT and NeSA assessment.
  • Data Analyzer-use the tab at the left to find description, sample reports and spreadsheets. This spreadsheet creates a 4 level color coding of student level for up to 10 different assessments. Several other graphs are also created.
  • Box Plots

Looking at NeSA Reports, the following reports are available

NDE Assessment Home page with 2013 technical reports
Math Table of Specs, practice test, reference sheets, Webs depth of knowledge, technical reports and other information
Reading Table of Specs, practice test, reference sheets, Webs depth of knowledge, technical reports and other information
Science Table of Specs, practice test, reference sheets, Webs depth of knowledge, technical reports and other information
Writing Table of Specs, practice test, reference sheets, Webs depth of knowledge, technical reports and other information
Other ideas for Looking at Your Data
The documents below provide examples of graphs, when the graphs should be used, hints about creating graphs, and different graphs created from the same data.
Formats to Present Data PDF.pdf This document demonstrates several different types of graphs to analyze data. List of types of graphs is shown below.
Formats to Present Data XLSX.xlsx This is the spreadsheet that was used to create the graphs found in the document. Note is is an xlsx file. I have had much better luck with creating graphs using the Windows Excel rather than the Mac. Once the graphs are created they can be viewed and updated in either format.
  • Growth model Thanks to Carla Noerrlinger, Director of Research Division, Omaha Public Schools, Omaha for these ideas to display data
  • Gap analysis
  • Trend Data, Student Achievement by Sub Test
  • Compare two groups with levels on several assessments
  • Compare sub-groups on One assessment
  • Compare Grade level scores with State scores on NeSA
  • Changes in levels from year to year (2 different formats)
Graph Types.pdf This document has the graph types listed below with information about how they best show the data.
graph tpes Excel 2007.xlsx This is the spreadsheet that was used to create the graphs found in the document graph types.
  • Line graph
  • Bar graph
  • Stacked bar graph
  • Circle graph
  • Paired Scatter Chart
  • Misc graphs
  • Cohort vs Program data
  • Chart to graphs
  • Trend data with different assessments
  • Trend Data with groups or ability levels for one standard or NRT sub-score
  • Compare two groups, with levels on several assessments
Pareto & Radar create.pdf What is a Pareto Chart or Radar Graph and how do you create them?
box and whisker.pdf What is a Box and Whisker Plot? Note this is one of the most underutilized graphs that very easily compared two sets of data.
Creating Histograms.pdf How to Create a Histogram using Excel.

steps.xls Ladder for Intersecting Data Types Data Analysis for Continuous School Improvement by Victoria Bernhardt identifies four types of data, school program or process, perceptions, student learning and demographic. The ten levels of the ladder depend on the number of intersections of the data types.

Data Driven Dialogue or Protocol

The protocol below leads a team to begin by thinking of questions about student achievement. Participants begin with the statements: I assume…., I predict …., I wonder …., There is also a very good article from ASCD, “Answering Questions That Count” December 2008/January 2009, pages 18-24.

ASCD article http://www.ascd.org/publications/educational_leadership/dec08/vol66/num04/Answering_the_Questions_That_Count.aspx
Answering the Questions That Count.pdf Summary of main points from article.

Data Driven Protocol from National School Reform Faculty
http://www.nsrfharmony.org/protocol/reflective_dialogue.html select "Data Driven Protocol"
Or go to http://www.nsrfharmony.org/protocol/learning_texts.html and search for data.