This comparison draws in part from “Networking Session: Don't Spend All Your Time Graphing: Excel and Graphing Tips” by James Hawkins (BehaviorLive), and extends it with peer-reviewed research from our library of 27,900+ ABA research articles. The decision framework, BACB ethics code references, and cross-links below are synthesized by Behaviorist Book Club.
View the original presentation →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.
| 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 |
The ABA Clubhouse has 60+ on-demand CEUs including ethics, supervision, and clinical topics like this one. Plus a new live CEU every Wednesday.
Use this framework when approaching networking session: don't spend all your time graphing: excel and graphing tips in your practice:
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
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
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
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 →We extended this decision guide with research from our library — dig into the peer-reviewed studies behind each approach, in plain-English summaries written for BCBAs.
280 research articles with practitioner takeaways
279 research articles with practitioner takeaways
258 research articles with practitioner takeaways
1 BACB General CEUs · $0 · BehaviorLive
Research-backed educational guide
Research-backed answers for behavior analysts
You earn CEUs from a dozen different places. Upload any certificate — from here, your employer, conferences, wherever — and always know exactly where you stand. Learning, Ethics, Supervision, all handled.
No credit card required. Cancel anytime.
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.