Improving Systems, Practices and Outcomes

Outcomes Measurement: Calculators & Graphing Templates

Recent Updates to this Page

COS Process Calculators

How Data from the Child Outcomes Summary Process Can Be Used to Address the OSEP Reporting Requirement

These documents explain how the information produced from the Child Outcomes Summary process can be used to classify a child into one of the 5 reporting categories that make up the Office of Special Education Programs (OSEP) reporting requirement on child outcomes.

COS Calculators: Getting from COS Ratings to the OSEP Reporting Categories

XLS: COS to OSEP Categories Tutor (revised April 2015)

This calculator was designed to show what OSEP reporting categories are generated from all possible combinations of COS ratings at entry and exit. Open the file and be sure you are in the worksheet labeled "Tutor." Follow the instructions to see how different combinations of COS ratings leads to one of the 5 OSEP reporting categories. The tutor allows you to experiment with various combinations of outcomes ratings and progress question answers to see what OSEP category each combination produces.

COS Calculator Model 2.0: Analytic Versions with Expanded Descriptive Output and Summary Statements

The Excel files below can be used (or adapted for use by someone who knows Excel) with large data sets of COS ratings. They will use summary form ratings data to generate OSEP progress category information on child outcomes (i.e., the data that must be submitted to OSEP every February), summary statement percentages, charts showing entry and exit COS ratings, descriptive information on "a" and "e" progress categories across all three outcomes, and some basic descriptive information about the data. Before using the COS calculator, please download and read the guidance document for information about warning messages when opening the file, and how to enter data and add data rows and columns to the file. The guidance document also describes changes between this version of the calculator (Model 2.0) and the previous version as well as instructions for using the calculator.

XLS: COS Calculator Model 1.0 for 150 Cases (revised January 2010)

This calculator file can be used to generate OSEP progress category information on child outcomes for up to 150 cases. To add additional rows to your data, press and hold the "Ctrl" and "R" keys. This version has been revised to allow users enter 2010 dates. For the most recent COS calculator, please use the "COS Calculator Model 2.0", above.

XLS: COS Calculator Model 1.0 for 4500 Cases (revised January 2010)

This calculator can be used to generate OSEP progress category information on child outcomes for up to 4500 cases. To add additional rows to your data, press and hold the "Ctrl" and "R" keys. This version has been revised to allow users to enter 2010 dates. For the most recent COS calculator, please use the "COS Calculator Model 2.0", above.

Notes on Calculators:
  • When downloading the calculator: begin download, choose "save" and save the file with a new name on your computer. Do NOT click on open and "save as" after the fact.
  • If you have trouble opening the file once the file is downloaded, remember you may need to select "enable macros" (see guidance document, above).
  • If the file opens, but you do not see contents when you first open the file, try going to "view" on the menu toolbar and select "full screen."
  • Please send comments or feedback to ectacenter@unc.edu.

PDF: Getting from COS Ratings to the OSEP Reporting Categories: COS to OSEP Summary Tables (August 9, 2007)

This document contains 3 tables. The first two tables show the OSEP reporting category generated from all possible combinations of COS ratings at entry and exit. The third table presents combinations of entrance and exit ratings that are impossible and provides explanations for why.

Other Calculators

XLS: Summary Statements Calculator (revised April 2011)

The ECO Center devised a summary statements calculator, which is a tool that allows states to take their OSEP progress category data for the three child outcomes and convert it to the summary statements which will be used for target setting. This calculator can be used by all states to generate percentages related to the summary statements, regardless of the child outcomes measurement approach. The summary statements for each of the three outcomes for Part C and 619 are the following:

  • Summary Statement 1: Of those children who entered the program below age expectations in each outcome, the percent who substantially increased their rate of growth by the time they exited the program.
  • Summary Statement 2: The percent of children who were functioning within age expectations in each outcome by the time they exited the program.
  • PDF: Summary Statement Definitions (revised April 2011): A one-page description to help staff and other stakeholders understand the summary statements.

Meaningful Differences Calculators

These Microsoft Excel templates allow states to look at the statistical significance of change in summary statements from year to year and compares local performance on each summary statement to the state’s performance to see if the difference is statistically significant. The calculators also compute the 90% confidence interval around the state and local summary statement values. These tools can be used to identify important differences between year to year performance in a state and to identify local programs that are performing statistically higher or lower than the state. Confidence intervals can be used to understand the precision of the summary statement values; however, summary statement values with very large confidence intervals (more than ±5%) should be interpreted with caution.

This Microsoft Excel template allows states to look at the statistical significance of change in summary statements from year to year for local programs on each summary statement. The calculator also computes the 90% confidence interval around the local summary statement values. This tool can be used to identify important increases or decreased in year to year performance in local programs.

XLS: Response Rate and Representativeness Calculator (revised December 2015)

This Excel-based calculator allows states to easily compute response rates for their family survey data and determine if the surveys they received are representative of the target population. The calculator uses a statistical formula to determine if two percentages (i.e., % of surveys received versus % of families in target population) should be considered different from each other. The user enters the values by subgroup and the calculator computes the statistical significance of the difference between the two percentages and highlights significant differences. Instructions about how to enter data into the calculator appear at the top of each tab.

Graphing Templates

XLS: Longitudinal Summary Statements Graphing Templates

These Microsoft Excel templates allow states to create longitudinal graphs of their state’s summary statements. After entering state summary statement data into the worksheet, users can copy and paste the graphs into other files such as presentations and reports. This longitudinal graphing template can also be used as part of a state’s initial broad data analysis efforts.

XLS: Family Indicator Local Program Graphing Template (December 2016)

This Excel template can be used to create graphs comparing your family indicator data by local program.

XLS: National-State Child Outcomes Data Graphing Template (revised August, 2016)

The ECO Center devised a Microsoft Excel template that allows states to take their OSEP summary statements for the three child outcomes and compare them to the national estimates. After entering state summary statement data into the worksheet, users can copy and paste the graphs into other files such as presentations and reports. It also includes an option for states to compare the national progress categories to their state data. National data in the calculator are for FFY 2013, submitted by states in February, 2015.

XLS: National-State Family Outcomes Data (Indicator C4) Graphing Template (December 2016)

This Microsoft Excel template allows states to compare their OSEP C4 family data to the national data in the three sub-indicator areas. States can also make comparisons to subgroups of states that use the same survey and scoring approach for the following: the FOS with recommended scoring, the FOS-Revised with recommended scoring, and the NCSEAM with Rasch scoring. States that use other scoring or surveys can graph their data using the comparison to national data. After entering your state's family data into the worksheet, the graphs can be copied and pasted into presentations, reports, and other files. National data in the calculator are for FFY 2013, submitted by states in February, 2015.

XLS: ITCA Eligibility Category Calculator (revised November 2016)

This workbook can be used to create graphs with your state child outcomes data compared to the unweighted average of the best states (who meet the national analysis quality criteria) in the same ITCA eligibility category from the national data.

Links on this site are verified monthly. This page content was last updated on 12/13/2016 CDW

Early Childhood Technical Assistance Center

  • CB 8040
  • Chapel Hill, NC 27599-8040
  • phone: 919.962.2001
  • fax: 919.966.7463
  • email: ectacenter@unc.edu

The ECTA Center is a program of the FPG Child Development Institute of the University of North Carolina at Chapel Hill, funded through cooperative agreement number H326P120002 from the Office of Special Education Programs, U.S. Department of Education. Opinions expressed herein do not necessarily represent the Department of Education's position or policy.

  • FPG Child Development Institute
  • OSEP's TA&D Network:IDEAs that Work