Improving Systems, Practices and Outcomes

Child Outcomes Calculators & Graphing Templates

Calculators

XLS: Summary Statements Calculator

Convert your state’s OSEP progress category data for the three child outcomes to the summary statements. The calculator can be used by all states to generate percentages related to the summary statements, regardless of the child outcomes measurement approach. (updated April 2011)

  • 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: A one-page description to help staff and other stakeholders understand the summary statements. (updated April 2011)

Meaningful Differences Calculators

These calculators compute the 90% confidence interval around state and local summary statement values. Confidence intervals can be used to understand the precision of summary statement values; however, summary statement values with very large confidence intervals (more than ±5%) should be interpreted with caution.

Calculating the Number and Percentage of Infants and Toddlers Who Did Not Receive Early Intervention Services for at Least Six Months

In an effort to better evaluate the extent to which States are providing complete Part C child outcomes data, OSEP revised the Part C Indicator 3 APR reporting requirement for FFY17 to include two additional counts of infants and toddlers who exited Part C:

  1. the number of infants and toddlers who exited the Part C program during the reporting period, as reported in the State’s Part C exiting data under Section 618 of the IDEA; and
  2. the number of those infants and toddlers who did not receive early intervention services for at least six months before exiting the Part C program.

Use this guidance document and calculator to learn more about the requirement and perform the computation:

XLS: 619 Child Outcomes Data Completeness Calculator

Complete data are higher quality and more useful for decision making. For the child outcomes Preschool Special Education Reporting (Indicator 7), data are complete when there is a child outcome entry and exit record for all children exiting the program during the year. The 619 Child Outcomes Data Completeness Calculator is an Excel-based analytic tool that can be used to determines the percent of children exiting the program with complete child outcomes data as a proportion of the 3-5 child count. The calculator uses the 3-5 child count as a proxy for the number of children exiting the preschool program. The calculator is designed to support state staff in monitoring child outcomes data completeness across programs. The tool includes expected ranges for the percent of the 3-5 child count with complete child outcomes data. The expected ranges were developed based off of review of state data over a 5-year period and serve as an informed starting place for review of the data. Note: If the state has a count of children exiting the preschool program during the outcomes reporting window that would be a better estimate of completeness and should be used. This tool was co-developed with DaSy. (updated August 13, 2019)

Graphing Templates

After entering data into these worksheets, graphs can be copied and pasted into other files, such as presentations and reports.

XLS: Longitudinal Child Outcomes Summary Statements Graphing Template

Create longitudinal graphs of your state’s summary statement data. (updated May 2018)

XLS: National-State Child Outcomes Data Graphing Template

Create graphs that compare your state’s summary statement data to the national estimates. The worksheet includes an option to compare the national OSEP progress categories to state data. National data in the calculator are for FFY 2016, submitted by states in February 2018. (updated May 2018)

XLS: ITCA Eligibility Category Calculator

Create graphs that compare child outcomes data to the unweighted average of the states who meet the national analysis quality criteria in the same ITCA eligibility category. (updated September 2017)

  • IDEAs that Work: Office of Special Education Programs, U.S. Department of Education

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 H326P170001 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.

Project Officer: Julia Martin Eile     © 2012-2019 ECTA Center

  • UNC Frank Porter Graham Child Development Institute