First, split practitioners into three groups based on the setting in which they work, family child care, center-based or license-exempt. Use the data element, Type of Setting, and assign a code (“1”) for practitioners working in settings that are indicated with a “Yes” for the category “Family Child Care”, another code (“2”) to practitioners at settings that are “Center-based (including a school setting)”, and a third code (“3”) for practitioners in “License-exempt” settings. For each of these groups, complete the calculations described below.
To ascertain the number of practitioners that have been awarded a CDA or State/Territory credential, total the number of practitioners (Practitioner ID) with a “Yes” for the data element Early Childhood Credential for each of the categories (Child Development Associate, State-Administration/Director Credential, State-Infant/toddler Credential, State-Preschool Credential, State-School-age Credential, State-Teacher Certification/Licensure, State-Special Education Credential) that has a Date Professional Credential/License Issued within the last federal fiscal year. Add all of the credentials awarded in the past year for the total number of State/Territory credentials. Next, use the data element Degree or Certificate Type and sum the number of practitioners with a “Yes” response for the categories Associate’s Degree, Bachelor’s Degree, and Graduate/Advanced Degree that have a Degree or Certificate Conferring Date within the past year. Perform this calculation for each of the setting types.