RMA Automated Scoresheet Template Excel Free Download

RMA Automated Scoresheet Template Excel Free Download: The Complete 2026 Guide

If you’re a Filipino teacher frantically searching for the RMA automated scoresheet template Excel free download at 10 PM before a submission deadline — first, take a breath. You’re in exactly the right place.

This guide covers everything: what the RMA automated scoresheet actually is, why it matters more than just ticking a DepEd compliance box, how to use it step by step, and — most importantly — where to download the file for free right now. We’ve also packed in practical tips that most guides skip entirely, like how to avoid the most common data-entry errors that corrupt your class summary.

Let’s get into it.

1. What Is the RMA Automated Scoresheet?

The Rapid Mathematics Assessment (RMA) is a DepEd diagnostic and benchmark tool developed through a collaboration between:

Department of Education (DepEd)
USAID ABC+
National Institute for Science and Mathematics Education Development (NISMED)

Its purpose is straightforward: give teachers a fast, structured way to diagnose where their students stand in foundational numeracy — without spending weeks on full-scale testing.

“The RMA isn’t just an assessment. It’s an early warning system. The data it generates should directly shape your lesson plans for the following weeks.” — DepEd Bureau of Education Assessment

The automated scoresheet is the Excel-based component of the RMA toolkit. Once you enter your students’ scores from the paper scoresheet, the Excel file automatically:

Computes total scores and percentages per task
Classifies each learner into a proficiency level
Generates color-coded class summaries
Produces charts that visualize class performance distribution

In short: you enter the raw scores, the spreadsheet does the heavy analytical lifting.

2. Free Download: RMA Automated Scoresheet Excel Template (All Grades)

✅ You can download the RMA Automated Scoresheet Excel template for FREE.

The official RMA automated scoresheets are provided at no cost through DepEd’s collaborative partners. The files are distributed as a ZIP archive containing individual Excel files for:

Key Stage 1 – Automated Score Sheet and Toolkits

Key Stage 2 – Automated Score Sheet and Toolkits

Key Stage 3 – Automated Score Sheet and Toolkits

3. Why the Automated Excel Template Changes Everything

Before the automated scoresheet existed, teachers had to manually calculate every student’s totals, percentages, and performance levels — a process that could take hours for a class of 40+. Errors were common. Comparisons across classes were difficult. And the data rarely made it beyond a notebook.

The RMA Automated Scoresheet Excel Template solves all of that. Here’s a quick comparison:

Feature	Manual Scoresheet	RMA Automated Excel Template
Score calculation	Manual, error-prone	Automatic, formula-driven
Learner leveling	Done by teacher manually	Auto-generated per student
Class summary	Compiled by hand	Instantly generated
Visual charts	Not available	Built-in bar and pie charts
School consolidation	Tedious copy-paste	Structured tab system
Submission-ready format	Requires reformatting	Upload directly to DepEd portal

The bottom line: the automated template saves teachers 2–4 hours per assessment cycle and dramatically reduces data errors that would otherwise invalidate your school’s submission.

4. RMA Scoresheet Breakdown by Key Stage

The RMA covers Key Stages 1, 2, and 3, with distinct score sheets tailored to grade-level competencies.

Key Stage 1 (Grades 1–3): Building Foundational Numeracy

This is where the RMA does its most critical work. Early numeracy gaps that go undetected in Grades 1–3 compound significantly in higher grades.

Grade 1 Task Breakdown:

Task	Competency Area	Max Points
Task A	Number Identification & Discrimination	8
Task B	Fractions	2
Task C	Addition	8
Task D	Subtraction	7
Task E	Geometric Representation	4
Task F	Missing Shape in Patterns	1
Task G	Time Measurement	3
Task H	Linear Measurement	3
Total		36

Grade 2 and Grade 3 scoresheets follow a similar structure but introduce more complex operations, multi-digit number work, and expanded geometry tasks.

Key Stage 2 (Grades 4–6): Expanding Mathematical Thinking

KS2 scoresheets assess:

Multiplication and division fluency
Fractions, decimals, and percentages
Problem-solving with operations
Measurement, area, and perimeter
Data reading and interpretation

Key Stage 3 (Grades 7–10): Algebraic and Critical Reasoning

KS3 goes deeper into:

Algebraic expressions and simple equations
Ratio and proportion
Statistical analysis and probability
Advanced geometry
Real-world mathematical applications

Share to your friends!

5. Step-by-Step Guide to Using the RMA Excel Template

Opening the file for the first time can feel overwhelming — there are multiple tabs, dropdown menus, and color-coded cells. Here’s your guided walkthrough.

Step 1: Enable Macros and Content

When you open the file, Excel will likely show a security warning at the top. Click “Enable Content” or “Enable Macros.” The automated calculations will not work without this step.

Step 2: Select Assessment Type and Region

On the main scoresheet tab, locate the dropdown at the top of the file:

Select your Assessment Type (e.g., Beginning of Year, Mid-Year, End of Year)
Select your Region from the dropdown list

This step automatically populates region-specific fields in the summary tabs.

Step 3: Enter School and Classroom Information

Fill in the following fields (these are clearly labeled in yellow or light blue):

School Name
School ID (from DepEd MIS)
District
Division
Language of Instruction (LOI) / Mother Tongue
Section Name
Grade Level
School Year

Step 4: Enter Enrollment Data

Input the number of enrolled male and enrolled female learners. The sheet automatically updates the total enrollment counter.

Step 5: Enter Learner Information

For each student, input:

LRN (Learner Reference Number) — 12-digit DepEd-assigned number
Last Name, First Name, Middle Initial
Date of Birth — Age is auto-computed
Mother Tongue / Language
Sex (M or F)

💡 Pro Tip: Arrange your students alphabetically before entering data. It makes cross-referencing with the paper scoresheet significantly faster and reduces skipping errors.

Step 6: Enter Individual Task Scores

For each learner, enter their raw score for each RMA task (A through H for Grade 1, adjusted for other grades).

Color-coding you’ll see:

🔴 Red cells = Score is below the passing threshold for that task
⚪ White/no fill = Score meets or exceeds the threshold

The total score and task percentage columns fill in automatically — do not type in those cells.

Step 7: Add Notes and Remarks (Optional)

There is a column for teacher remarks per learner. Use this for attendance notes, absent during assessment, or any contextual information relevant to a student’s score.

Step 8: Review the Class Summary Tab

After entering all student data, click on the “Class Summary” tab. You’ll find:

Total number of learners assessed
Score distribution by level
Percentage of proficient learners per task
Auto-generated bar charts and pie charts

No additional input needed here — it’s fully automated.

6. Understanding the Auto-Generated Class Summary

The Class Summary tab is arguably the most powerful feature of the RMA automated scoresheet. Here’s what you’ll find and how to read it:

Section A: Summary Results Table

This table shows the count and percentage of learners in each performance level:

Level	Description	Score Range (Typical)
Below Expectation	Non-proficient, needs intensive support	Below 60%
Approaching Expectation	Developing, needs additional support	60–74%
Meeting Expectation	On track, meets grade-level standards	75–84%
Exceeding Expectation	Above grade level	85–100%

Note: Exact percentage cutoffs may vary by grade level and version of the RMA.

Section B: Leveling by Sex

The summary disaggregates performance data by male and female — an important feature for gender-responsive teaching practices. If there’s a consistent gap between male and female performance on specific tasks, that’s actionable data.

Section C: Proficiency by Task

This section shows the percentage of learners who answered each task correctly. This is where you identify your Least Mastered Competencies (LMCs) — the tasks with the lowest proficiency percentages across your class.

Example: If only 43% of your Grade 1 class passed Task D (Subtraction), that’s a clear signal to prioritize subtraction strategies in the next instructional weeks.

Section D: Visual Charts

The automated charts include:

Bar chart: Learner count per performance level
Pie chart: Percentage distribution across levels
Task proficiency bar chart: Visual comparison of class mastery across all tasks

These charts are automatically print-ready for inclusion in SIP (School Improvement Plan) documentation or instructional supervision reports.

Disclaimer:

Some educational materials may be inspired by or aligned with DepEd curriculum standards.
However:

All materials uploaded or created are intended to support teachers and students.
If any copyrighted content is unintentionally shared, please contact us here depedlibre@gmail.com immediately for removal or proper attribution.

We respect intellectual property rights and respond promptly to valid copyright concerns.

7. School Summary: Consolidating Classroom Results

The School Summary template is a separate Excel file used by the School ICT Coordinator or Designated Personnel to consolidate data from all classrooms.

How to Consolidate

Open the School Summary Excel file
Navigate to the tab for each grade level (G1 Class Summary, G2 Class Summary, G3 Class Summary)
Copy the Class Summary data from each teacher’s individual scoresheet
Paste it into the corresponding tab in the School Summary file
Enter the School Name and School ID at the top of the file

The School Summary dashboard will then automatically generate:

School-wide performance by grade level
Consolidated charts for admin reporting
Data formatted for the online submission form

⚠️ Note on Pasting: Always use “Paste Special → Values Only” when copying data between files. Pasting with formulas can break the automated calculations in the School Summary.

8. Leveling Learners: What the Categories Actually Mean

The RMA doesn’t just produce scores — it categorizes each learner into a performance level that suggests the type of instructional support they need. Here’s a practical breakdown:

Below Expectation (Non-Proficient)

What it means: This learner has significant gaps in foundational numeracy. They are not yet meeting minimum grade-level standards.

What to do:

Enroll in remediation/intervention groups
Refer to the school’s Learning Recovery Program
Document in the learner’s individual education notes
Inform parents with specific next steps (not just “your child is struggling”)

Approaching Expectation (Developing)

What it means: This learner has partial understanding but has not yet consolidated grade-level competencies.

What to do:

Group with targeted small-group instruction
Use differentiated activities that bridge gaps
Monitor with the next RMA cycle

Meeting Expectation (Proficient)

What it means: This learner is on track. They demonstrate competence in grade-level mathematics.

What to do:

Continue regular instruction
Use peer-tutoring opportunities to reinforce their understanding
Enrich with extension tasks

Exceeding Expectation (Advanced)

What it means: This learner performs above grade-level expectations.

What to do:

Provide enrichment activities
Consider them as class facilitators or math buddies for struggling learners
Document for SPED gifted education referral if consistently advanced

9. Submitting RMA Results Online

Once your School Summary is complete, it must be submitted to the official DepEd online portal. Here is the current process:

Submission Steps

Complete and review the School Summary Excel file
Visit the official submission portal: https://bit.ly/RMASchoolSubmission
Upload the School Summary Excel file directly (no more manual encoding required as of the 2024 update)
The system will automatically extract your data upon upload

Tracking Your Submission

After uploading, you can monitor your school’s submission status at: 🔗 https://bit.ly/RMASchoolSubmissionTracker

Your submission will appear in the tracker within approximately 15 minutes of uploading.

Submission Deadlines

Deadlines vary by division and school year. Always check your SDO’s memorandum for the current cycle’s deadline. Missing the deadline can affect your school’s compliance rating in the RPMS system.

10. Using RMA Data for Real Classroom Improvement

Here’s the truth most guides don’t say: the RMA is only as useful as what you do with the data. Completing the scoresheet for compliance and filing it away is a missed opportunity.

Strategy 1: The “3 Task” Focus Method

After reviewing your class summary, identify the 3 tasks with the lowest class proficiency rates. These are your Least Mastered Competencies. Build your next two weeks of math instruction around these three areas specifically, using varied strategies (games, manipulatives, peer work).

Strategy 2: Flexible Grouping by Performance Level

Use the leveling results to form temporary, fluid learning groups — not permanent tracking. Rotate students between groups as their mastery grows. This approach is supported by DepEd’s differentiated instruction framework.

Group	Level	Instruction Type
Group A	Below Expectation	Intensive remediation, hands-on materials
Group B	Approaching Expectation	Guided practice, targeted drills
Group C	Meeting Expectation	Regular instruction + extension
Group D	Exceeding Expectation	Enrichment, peer facilitation

Strategy 3: Parent Communication Using RMA Data

The RMA gives you specific, task-level data you can share with parents — something far more actionable than “your child needs improvement in math.”

Instead of: “Maria is struggling with mathematics.” Say: “Maria scored well in number identification but needs extra practice in subtraction — specifically when borrowing across tens. Here are three activities you can do at home.”

Strategy 4: Pre- and Post-Cycle Comparison

Administer the RMA at the beginning, middle, and end of the school year. Compare class summaries across cycles to measure actual learning growth. Export the charts from each cycle into a single document for your SIP monitoring or COT portfolio.

Frequently Asked Questions

Q: Is the RMA automated scoresheet template really free? Yes. The RMA automated scoresheet Excel template is completely free. It is an official DepEd tool distributed through government education channels at no cost to teachers or schools.

Q: What version should I use — RMA1 or RMA2? Always use RMA2 (or the latest version available). RMA2 includes updated task structures, improved automation, and compatibility with the current online submission system.

Q: Can I use the RMA scoresheet on Google Sheets? The template is designed for Microsoft Excel and relies on Excel-specific macro functions. While you can open the file in Google Sheets, the automated calculations and macros will not work correctly. Use Excel for intended functionality.

Q: What if my class has more than the default number of rows? Each scoresheet has a fixed number of learner rows. If your class exceeds this (unusual but possible), contact your School ICT Coordinator — do not insert rows manually as this can break formulas.

Q: When is RMA administered? The RMA is typically administered at the beginning of the school year as a diagnostic tool, with possible mid-year and end-of-year administrations depending on your division’s directives. Check your SDO memoranda for exact schedules.

Q: Who is responsible for the School Summary submission? The School ICT Coordinator or designated school personnel consolidates individual classroom summaries into the School Summary file and submits it online.

Q: What if I make a mistake after submitting? Contact your Division ICT Coordinator immediately. Resubmission procedures vary by division, but most SDOs have a correction window before the regional data consolidation deadline.

Don’t forget to Follow our Facebook page for more free learning materials!

Latest News!

Download more files below!

RMA Automated Scoresheet Template Excel Free Download