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. Google SheetNeSA 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. Google SheetEfficiency Rates 1.1

Correlation:Instructions to find a correlation between a NRT and NeSA assessment.

Correlations of data Spreadsheet Enter your data into this spreadsheet, graphs and correlation coefficients for up to 3 different types of assessments.

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

box and whisker.doc How to create a box and whisker plot by folding a strip of paper. Also hints about using in your classroom.

All demographic groups, by grade level and shows each assessments taken at that grade level. (grade 5 shows math, LA, science)

DISTRICT REPORT OF SCHOOL PERFORMANCE

Compares (below, meeting exceeding) state achievement with school achievement by grade level for each assessment taken at that grade level. (grade 5 shows math, LA, science)

SCHOOL STUDENT ROSTER

Shows individual student scale score and percent correct by sub-scores.

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.

Graph TypesNeSA 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. Google Sheet NeSA growth version 1.1.xlsEfficiency 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.xlsEfficiency Rates 1.1--This spreadsheet has a few more columns so that subgroups can be compared. Google Sheet Efficiency Rates 1.1Correlation: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 PlotsLooking at NeSA Reports, the following reports are available- DISTRICT MATHEMATICS INDICATOR SUMMARY
- High and low three indicators by grade level one for math, one for LA
Math NeSA-M High Low Indicators v2.xlsx

Math NeSA-M High Low Indicators v2.xlsxReading NeSA-R high low Indicators v2.xlsx

Reading NeSA-R high low Indicators v2.xlsxScience NeSA-S High Low Indicators v2.xlsx

Science NeSA-S High Low Indicators v2.xlsxNDE 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 DataThe 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 ProtocolASCD 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.