📊 Motivation Assessment Scale II (MAS-II) Scoring Tracker & Graph Dashboard | Excel & Google Sheets

Simplify Motivation Assessment Scale (MAS-II) scoring with this automated digital tracker and dashboard. Enter MAS-II ratings once and instantly generate Motivation Assessment Scale graphs, function summaries, score calculations, and professional visual reports.

Designed for BCBAs, behavior analysts, ABA clinics, consultants, and behavior professionals, this MAS-II spreadsheet makes it easy to complete assessments, calculate scores, identify hypothesized functions of behavior, and visualize results over time.

✨ What's Included (4 Interactive Tabs)

1️⃣ Set Up & Customization

Customize the template to match your clinical workflow.

✔ Adjust function names if needed
✔ Customize frequency descriptions
✔ Edit rating scale descriptions
✔ Flexible setup options for different assessment preferences

2️⃣ MAS-II Assessment Scoring Tracker

Complete Motivation Assessment Scale II scoring digitally without manual calculations.

✔ Preloaded with all 51 MAS-II assessment questions
✔ Score each item from 0–6 using dropdown menus
✔ Automatic color-coded scoring system
✔ Track up to 25 MAS-II assessments for one client and one target behavior
✔ Enter client name, rater, assessment date, target behavior, behavioral description, setting description, and frequency description
✔ Automatically calculates total scores and mean scores
✔ Keeps a complete history of MAS-II scoring results

Perfect for replacing paper MAS-II forms with an organized digital scoring system.

3️⃣ MAS-II Scoring Dashboard & Graphs

Turn MAS-II assessment scores into clear, professional visuals instantly.

Automatically generate:

✔ Primary hypothesized function and mean score
✔ Secondary hypothesized function and mean score
✔ Total MAS-II score
✔ Overall mean score
✔ Total score by function
✔ Mean score by function
✔ Functional profile graph
✔ Score distribution by function
✔ Mean score percentage by function
✔ Function ranking table
✔ Detailed MAS-II scoring summaries

Create Motivation Assessment Scale graphs that make results easier to interpret for clinical teams, supervision, caregiver meetings, and documentation.

4️⃣ MAS-II Progress Dashboard

Track changes in MAS-II scores across repeated assessments and visualize progress over time.

📈 Assessment Summary

✔ Client and target behavior summary
✔ Initial vs. most recent MAS-II assessment comparison
✔ Changes in primary and secondary hypothesized functions
✔ Changes in total score and mean score

📊 MAS-II Score Trends Over Time

✔ Total MAS-II score changes across assessment dates
✔ Mean score trends over time
✔ Visual comparison of repeated assessments

📉 Functional Profile Over Time

✔ Track mean scores for each function across assessments
✔ View changes in hypothesized maintaining variables
✔ Identify primary and secondary functions at each assessment point

🏆 Function Ranking Changes

✔ View ranking of all five functions across assessments
✔ Track shifts in function scores over time
✔ Compare score distributions between assessments

🔎 Function-Specific Analysis

Select a function from a dropdown menu to view:

✔ Total score over time
✔ Mean score over time

📝 Individual Question Tracking

Select any MAS-II question to visualize:

✔ Individual item scores across assessment dates
✔ Changes in specific assessment responses over time

📚 Complete Assessment History

✔ Detailed table of all MAS-II scores entered
✔ Organized assessment record for easy review

📈 Assessment Progress Comparison

Compare first vs. most recent MAS-II assessments:

✔ Total score changes
✔ Mean score changes
✔ Function-specific score changes
✔ Overall assessment progress summary

💡 Why You'll Love It

✔ Available in Excel and Google Sheets
✔ Automated MAS-II scoring calculations
✔ Built-in Motivation Assessment Scale graphs
✔ No manual formulas or graphing required
✔ Color-coded MAS-II ratings for quick interpretation
✔ Track repeated assessments over time
✔ Instantly identify primary and secondary hypothesized functions
✔ Create professional visuals for reports and meetings
✔ Keep all MAS-II scoring data organized in one place

👩‍🏫 Perfect For

BCBAs • BCaBAs • ABA Clinics • Behavior Analysts • Consultants • School Teams • Behavior Specialists • Clinical Supervisors

🔎 Keywords

Motivation Assessment Scale, Motivation Assessment Scale II, MAS-II, MAS 2, Motivation Assessment Scale scoring, Motivation Assessment Scale graph, MAS-II scoring sheet, MAS-II scoring template, MAS-II spreadsheet, MAS-II dashboard, Functional Behavior Assessment, Functional Assessment Tool, Behavior Function Assessment, ABA Assessment Tracker, BCBA Spreadsheet, ABA Progress Monitoring, Google Sheets Dashboard, Excel Dashboard