ECCD Checklist Computation Using MS Excel with SF5 for Kindergarten

Free Excel tool that computes kindergarten learners’ ECCD Checklist age, scaled scores, standard score, and interpretation, and reflects them in SF5.

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:

  1. To give ECCD Checklist results in the easiest way possible.
  2. 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:

CodeInterpretation
HAHighly Advanced
SASlightly Advanced
AAverage
SDSlightly Delay
DDelay

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.

  1. 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.
  2. 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.
  3. 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.
  4. Check the computed results. After you enter raw scores for all 7 domains, the total scaled score, standard score, and interpretation are computed automatically.
  5. 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.
  6. 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

Your email address will not be published. Required fields are marked *

For students and teachers

Looking for a school?

Look up the enrollment, teachers, classrooms and facilities of more than 60,000 schools across the Philippines, from DepEd’s public data. Free to use.

Philippine Schools Directory by TeacherPH · every region, province, division and district