This is a free Microsoft Excel tool for computing ECCD Checklist results of kindergarten learners and showing them in School Form 5 (SF5). You enter each learner’s birthday, testing date, and raw scores. The workbook then works out the learner’s age, scaled scores, standard score, and interpretation, so teachers spend less time on manual computation.
The tool was developed by Jagilen M. Dela Cruz.
On this page 5 sections
What the tool is for
The developer gives two objectives:
- To give ECCD Checklist results in the easiest way possible.
- To lighten teachers’ workload so they have more time for other forms.
What the workbook computes for you
Once you enter the basic data, these are filled in automatically:
- The learner’s age, computed from the birthday and the testing date
- The scaled score for each domain, based on the raw score and the learner’s age
- The total scaled score across the 7 domains
- The standard score and the interpretation
- The learner’s LRN, name, standard score, interpretation, and level of progress and development in SF5
The scaled score depends on the learner’s age. The workbook uses a different scaled score table for each age group: 3.1 to 4.0, 4.1 to 5.0, and 5.1 to 5.9.
Interpretation categories
The results are grouped into five interpretations:
| Code | Interpretation |
|---|---|
| HA | Highly Advanced |
| SA | Slightly Advanced |
| A | Average |
| SD | Slightly Delay |
| D | Delay |
How to use the ECCD Checklist computation tool
Important: Do not type anything in the SF5 sheet. The LRN, name of learner, standard score, interpretation, and level of progress and development appear there on their own.
- Enter learner data. Type each learner’s LRN, name, and birthday in the INPUT DATA sheet, or copy them from SF1 and paste them there. These details automatically appear in the other sheets.
- Enter the testing date. On the input sheet, type the testing date in MM/DD/YYYY format. The workbook uses it to compute the learner’s age.
- Enter the raw scores. Type the raw score for each domain. The scaled score appears automatically, using the table for the learner’s age group.
- Check the computed results. After you enter raw scores for all 7 domains, the total scaled score, standard score, and interpretation are computed automatically.
- Count the results. Count how many learners got Highly Advanced, Slightly Advanced, Average, Slightly Delay, and Delay, and type the numbers in the lower portion of the sheet. These numbers are reflected in the consolidation report.
- Review SF5. Each learner’s total scaled score and interpretation are reflected in SF5, the new form for kindergarten.
Download the ECCD computation tool
You can view the workbook below or download it as an Excel file:
Frequently asked questions
Who is this ECCD computation tool for?
It is for kindergarten teachers who need to compute ECCD Checklist results and reflect them in SF5. It covers learners aged 3.1 to 5.9.
Do I need to type anything in the SF5 sheet?
No. The LRN, name, standard score, interpretation, and level of progress and development appear in SF5 automatically once you fill in the input sheet.
What data do I need to enter?
You enter each learner’s LRN, name, birthday, and testing date, plus the raw score for each of the 7 domains. You can copy the LRN, names, and birthdays from SF1.
Why does the learner’s age matter?
The scaled score depends on age. The workbook uses separate scaled score tables for ages 3.1 to 4.0, 4.1 to 5.0, and 5.1 to 5.9, so the testing date must be entered correctly in MM/DD/YYYY format.
Is the consolidation report filled in automatically?
Partly. You count how many learners fall under each interpretation (HA, SA, A, SD, D) and type the numbers in the lower portion of the sheet, and the results then appear in the consolidation report.
Leave a Reply