MOTAS-EL Scoring Tracker Google Sheets

✨ MOTAS-EL Scoring Tracker & Graphing Dashboard – Excel & Google Sheets ✨

Stop juggling paper scoring sheets or manually calculating totals. This MOTAS-EL scoring and analytics system brings scoring, tracking, and visual insights together in one fully automated Excel/Google Sheets workbook—so you can focus on assessment and reporting, not spreadsheets.

Designed for BCBAs, early intervention clinicians, and educators working with early learners, this tool is intuitive even for spreadsheet beginners, with built-in safeguards to prevent scoring errors and instantly generate meaningful dashboards.

⚠️ Important: You must have access to a paid copy of the official MOTAS-EL assessment to use this tool.
This product is not the assessment itself and does not include official assessment content. It is a scoring and analytics tracker only, designed to help you organize and interpret your MOTAS-EL scores more efficiently.

📂 What’s Included (4 Tabs)

⚙️ 1. Set Up Tab

Customize the system to fit your practice:

• Edit domain names (Early Learner domains)

• Adjust score labels and thresholds (e.g., Not Applicable, Emerging, Prompted, Independent, etc.)

• Customize reporting terminology

• Dashboards and graphs update automatically based on your settings

📝 2. Assessment Tab (Domains & Skill IDs)

Your primary scoring workspace.

• Structured to align with MOTAS-EL domain organization

• Skill names are not included — add your own using the official MOTAS-EL manual

• Log up to 25 assessment dates horizontally

• Enter scores using drop-downs (0–5) with automatic limits per skill

• Built-in filters to view only selected domains on a given date

• Clean layout with step-by-step PDF instruction guide included

Designed specifically for early learner milestone tracking, foundational communication skills, play skills, early social engagement, and beginning independence targets.

📊 Analytics & Dashboards

📈 3. One-Time Assessment Dashboard

Filter to a single assessment date and instantly view:

• % mastery by domain (for domains assessed that day)

• Total score vs maximum possible score

• Average score by domain

• Skill distribution by domain:

  • Not Applicable

  • Emerging

  • Prompted

  • Independent

  • Generalized

  • Maintained

• Number of skills assessed per domain

Includes:

• Domain-level summary table

• Skill-level breakdown for deeper review

Perfect for evaluation summaries and caregiver meetings.

📉 4. Multiple Assessments Dashboard (Progress Over Time)

Designed for progress monitoring and reporting.

Section 1: Domain Focus

Filter a specific domain to see:

• % mastery over time

• Average score over time

• Skill distribution trends

• Progress of specific skills across assessment dates

Section 2: Domain Comparison

• Compare average score across multiple domains over time

• Automatically color-coded summary table for quick interpretation

Section 3: Assessment Volume

• Number of skills assessed per domain

• Total skill assessments completed over time

• Summary table showing skills assessed per domain across assessment dates

💡 Why You’ll Love It

• All-in-one MOTAS-EL scoring grid, tracking sheets, and dashboards

• No more manual scoring or calculations ✋

• Automated % mastery, totals, averages, and distributions

• Built-in score restrictions to prevent data entry errors

• Clear, visual dashboards for reporting to caregivers, teams, and stakeholders

• Works seamlessly in Excel & Google Sheets

• Designed specifically for early intervention professionals and spreadsheet beginners