Improving Systems, Practices and Outcomes

Outcomes Measurement: Calculators & Graphing Templates

Recent Updates to this Page:

  • Updated graphing templates and calculators including the National-State Family Outcomes Data (C-4) Graphing Template, Eligibility Calcualtor, and Longitudinal Summary Graphing Templates have been posted. (September-October 2017)
  • A new COS Process Calculator has been posted: It allows up to 12,000 cases in a data set. (March 2017)

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 February 2017)

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.

XLS: COS Calculator (March 2017)

This Excel file can be used (or adapted for use by someone who knows Excel) with large data sets of COS ratings (up to 12,000 rows). The calculator will use summary form ratings data to:

  1. Generate OSEP progress category information and charts on child outcomes
  2. Generate OSEP summary statement percentages and charts on
  3. Generate entry and exit COS ratings and charts for all three child outcomes
  4. Generate description information on “a” and “e” progress categories across all three outcomes
  5. Summarize data issues (e.g., missing data, valid data)
Notes on the Revised Calculator:

Six months between entry date and exit date is now calculated as 182 days. In previous versions of the calculator it was calculated as of 181 days. An option to turn off the programming that excludes children with less than six months between entry date and exit date has been added to this version (available on the first worksheet). The file size of the document has been reduced and we not have only one version on the website.

Be sure to read the ‘Contents and Tips’ page of the file for additional information.

PDF: Getting from COS Ratings to the OSEP Reporting Categories: COS to OSEP Summary Tables (August 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 September 2017)

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 (October 2017)

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 2015, submitted by states in February, 2017.

XLS: ITCA Eligibility Category Calculator (revised September 2017)

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.

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
  • IDEAs that Work