By Matt Harrington, BCBA · Behaviorist Book Club · Clinical decision guide

Manual vs. Template-Based Graphing Workflows in ABA Practice

In This Guide

Side-by-Side Comparison
Clinical Decision Framework
Key Takeaways

One of the most consequential decisions a behavior analyst makes is not just what intervention to use, but how to approach the clinical question in the first place. For networking session: don't spend all your time graphing: excel and graphing tips, the difference between an evidence-based, individualized approach and a traditional, protocol-driven one can significantly impact outcomes.

This guide lays out the key factors side by side to support your clinical decision-making.

Side-by-Side Comparison

Factor	Evidence-Based Approach	Traditional Approach
Setup Time vs. Ongoing Efficiency	Manual: Low initial setup (open Excel, start entering data); high ongoing time cost as each graph requires repeated formatting decisions	Template-Based: Higher initial setup investment to build and refine templates; dramatically lower ongoing time cost as formatting is pre-configured
Consistency Across Clients	Manual: High variability in graph appearance across clients and over time; axis scales, label formats, and phase change line styles may differ without systematic reason	Template-Based: Consistent appearance across all clients and sessions; standardized formatting supports faster visual interpretation and professional documentation
Error Risk	Manual: Higher risk of data entry errors, axis scaling errors, and phase change line misplacement due to repeated manual operations on each graph	Template-Based: Lower ongoing error risk when formulas handle calculations and formatting is locked; initial template errors must be caught during setup and testing
Adaptability to Unusual Data	Manual: Highly flexible; can be adapted ad hoc for unusual data types, non-standard timeframes, or complex multi-behavior displays without template constraints	Template-Based: Requires deliberate template design to accommodate data variability; practitioners need a toolkit of templates for different graph types rather than a single universal template
Team Standardization	Manual: Each team member develops idiosyncratic graphing habits; supervisors spend more time reviewing graphs for errors and inconsistencies	Template-Based: Shared templates create organizational graphing standards; supervisors can review data faster across the team and focus on clinical analysis
Learning Curve	Manual: Requires only basic Excel knowledge; accessible to new practitioners with minimal training; efficient only for practitioners who are very fast at manual formatting	Template-Based: Requires investment in learning Excel charting features, formulas, and template management; returns increase with Excel fluency

FREE CEUs

Get CEUs on This Topic — Free

The ABA Clubhouse has 60+ on-demand CEUs including ethics, supervision, and clinical topics like this one. Plus a new live CEU every Wednesday.

✓ 60+ on-demand CEUs (ethics, supervision, general)

✓ New live CEU every Wednesday

✓ Community of 500+ BCBAs

✓ 100% free to join

Join The ABA Clubhouse — Free →

Clinical Decision Framework

Use this framework when approaching networking session: don't spend all your time graphing: excel and graphing tips in your practice:

Step 1: Is intervention warranted?

Does the data support a need for intervention? Is there a meaningful impact on the individual's quality of life, safety, or access to reinforcement?

YES → Proceed to assessment NO → Document reasoning, monitor

Step 2: Have you conducted an individualized assessment?

A functional assessment should guide intervention selection. Avoid defaulting to standard protocols without individual analysis. Consider environmental variables, setting events, and private events.

YES → Select evidence-based approach matched to function NO → Complete assessment first

Step 3: Is the individual/caregiver involved in decision-making?

Goals should be co-developed. Assent and informed consent are ethical requirements. The individual's preferences and values matter in selecting both goals and methods.

YES → Proceed with collaborative plan NO → Engage in shared decision-making

Step 4: Verify your approach

✓ Is your intervention matched to the assessed function?
✓ Are you using the least restrictive effective approach?
✓ Is assent being monitored throughout?
✓ Do you have a data collection plan?
✓ Is there a plan for generalization and maintenance?

Key Takeaways

Individualization is non-negotiable. The best approach for one individual may not be appropriate for another, even with the same topography.
Assessment drives intervention. Function-based approaches consistently outperform topography-based ones in the literature.
Ethics are active, not passive. Ethical practice requires ongoing analysis, not just initial compliance.
Document everything. Both the decision to intervene and the decision not to intervene require documentation and justification.
Stay current. The evidence base in this area is evolving. What was standard practice five years ago may not reflect current best practices.

Go Deeper With This CEU

This course covers the clinical and ethical dimensions in detail with structured learning objectives and CEU credit.

Networking Session: Don't Spend All Your Time Graphing: Excel and Graphing Tips — James Hawkins · 1 BACB General CEUs · $0

Take This Course →

📚 Browse All 60+ Free CEUs — ethics, supervision & clinical topics in The ABA Clubhouse →

Clinical Disclaimer

All behavior-analytic intervention is individualized. The information on this page is for educational purposes and does not constitute clinical advice. Treatment decisions should be informed by the best available published research, individualized assessment, and obtained with the informed consent of the client or their legal guardian. Behavior analysts are responsible for practicing within the boundaries of their competence and adhering to the BACB Ethics Code for Behavior Analysts.