Online interactive tutorials for creating graphs with excel 2007 or 2010

Comparing instructor-led, video-model, and no-instruction control tutorials for creating single-subject graphs in Microsoft Excel: A systematic replication and extension

Visual inspection of single-subject data is the primary method for behavior analysts to interpret the effect of an independent variable on a dependent variable; however, there is no consensus on the most suitable method for teaching graph construction for single-subject designs. We systematically replicated and extended Tyner and Fienup (2015) using a repeated-measures between-subjects design to compare the effects of instructor-led, video-model, and no-instruction control tutorials on the graphing performance of 81 master's students with some reported Microsoft Excel experience. Our mixed-design analysis revealed a statistically significant main effect of pretest, tutorial, and posttest submissions for each tutorial group and a nonsignificant main effect of tutorial group. Tutorial group significantly interacted with submissions, suggesting that both instructor-led and video-model tutorials may be superior to providing graduate students with a written list of graphing conventions (i.e., control condition). Finally, training influenced performance on an untrained graph type (multielement) for all tutorial groups.

Beyond traditional medications: exploring novel and potential inhibitors of trypanothione reductase (LmTr) of Leishmania parasites

The trypanothione reductase enzyme, which neutralizes the reactive oxygen species produced inside the macrophages to kill the parasites, is one of the evasion strategies Leishmania uses to survive inside the cells. The vitality of the parasite depends on Leishmania major trypanothione reductase (LmTr), a NADPH-dependent flavoprotein oxidoreductase essential for thiol metabolism. Since this enzyme is distinct and lacking in humans, we focused on it in our study to screen for new inhibitors to combat leishmaniasis. Using the I-TASSER server, a three-dimensional model of LmTr was generated. The Autodock vina program was used in high-throughput virtual screening of the ZINC database. The top seven molecules were ranked according to their binding affinity. The compounds with the highest binding affinities and the right number of hydrogen bonds were chosen. These compounds may be effective at inhibiting the target enzyme's (LmTr) activity, making them new leishmaniasis treatments. These compounds may serve as a useful starting point for a hit-to-lead approach in the quest for new anti-Leishmania drugs that are more efficient and less cytotoxic. The average node degree is 5.09, the average local clustering coefficient is 0.868, and the PPI enrichment p-value is 8.9e-06, indicating that it is sufficiently connected to regulate the network. TRYR (LmTr protein) also interacts physically with ten additional proteins in the pathogenesis network. The findings of the study indicated that successfully suppressing the LmTr protein in vitro and in vivo may finally result in regulating the L. major pathogenesis.Communicated by Ramaswamy H. Sarma.

Creating Single-Subject Research Design Graphs with Google Applications

The visual analysis of graphically displayed data is an essential skill for behavior analysts across a range of settings. Although there are several computer-based applications that facilitate the production of simple, consistent, and visually coherent graphs, these applications have several limitations, including cost. An alternative to using these applications is using free and widely available Google Sheets and Google Slides to produce high-quality clinical and research graphs. We provide a step-by-step pictorially supported task analysis for a system for creating graphs for a variety of single-subject research designs and clinical applications using Sheets and Slides. We also discuss the advantages and limitations of using Google applications to create graphs for use in the practice of applied behavior analysis.

Remote teaching of publication-quality, single-case graphs in Microsoft Excel

Microsoft Excel is ubiquitous, cost-effective, and can be used to create publication-quality single-case design graphs. We systematically replicated the GraphPad Prism video tutorial by Mitteer et al. (2018) to teach 24 master's students to create multiple-baseline graphs using Excel 2016. Students' mean accuracy on the multiple-baseline graph was 25% in pretraining, 86% with the video tutorial, and 96% with the review checklist. Next, students used the same video tutorial to create multielement and reversal graphs. Students' mean accuracy on the multielement graph was 93% with video tutorial and 94% with review checklist, and accuracy on the reversal graph was 82% with video tutorial and 94% with review checklist. Students reported moderate to high satisfaction with both training components. The results support scientist-practitioners using the video tutorial and review checklists to create three common graphs using Excel 2016, Excel 2019, and Excel Office 365.

Further Evaluation of Teaching Behavior Technicians to Input Data and Graph Using GraphPad Prism

We replicated and extended Mitteer, Greer, Fisher, and Cohrs (2018) by examining the effects of a video model on inputting data into GraphPad Prism, which is a necessary skill for graph construction. We used a concurrent multiple-probe-across-behavior design with two behavior technicians to assess data-input and graphing skills separately prior to and during access to relevant video models. We evaluated the generality of the training procedures by assessing both skills during data-input-plus-graphing sessions without access to the video models. The video models resulted in mastery of data-input and graphing skills when assessed individually. We observed training effects generalize to data-input-plus-graphing sessions once behavior technicians experienced all relevant video models. These results suggest that individuals should view both data-input and graphing video models prior to depicting single-case design data in Prism but that these skills can maintain at high levels of accuracy without continued access to the training materials.

Creating Functional Analysis Graphs Using Microsoft Excel® 2016 for PCs

Practitioners in the field of applied behavior analysis rely on graphing software to display the data they collect during assessments. However, the graphing process can be cumbersome and procedures change as new versions of software programs are released. The current tutorial provides step-by-step instructions for graphing functional analysis data using Microsoft Excel 2016 for PCs. Instructions for creating functional analysis data depicted in reversal, latency, mulitielment, and trial-based functional analysis are provided.

A Primer on Single-Case Research Designs: Contemporary Use and Analysis

The overarching purpose of this article is to provide an introduction to the use of rigorous single-case research designs (SCRDs) in special education and related fields. Authors first discuss basic design types and research questions that can be answered with SCRDs, examine threats to internal validity and potential ways to control for and detect common threats, and provide guidelines for selection of specific designs. Following, contemporary standards regarding rigor, measurement, description, and outcomes are presented. Then, authors discuss data analytic techniques, differentiating rigor, positive outcomes, functional relations, and magnitude of effects.

Comparing self-directed methods for training staff to create graphs using Graphpad Prism

An important skill for behavior analysts is creating graphs that clearly convey outcomes and conform to publication conventions. GraphPad Prism is software designed for creating scientific graphs, but no prior research has empirically evaluated training graphing skills using Prism. Two effective training methods are enhanced written instructions (EWI) and video modeling with voiceover instructions (VMVO), but no single-subject studies have compared the effects of these methods. In this study, we compared the efficacy and social validity of EWI and VMVO for training staff to create graphs using Prism. A single-subject design was employed to compare the effects of the methods on the individual performance of 11 graduate students. EWI and VMVO were both found to be effective, and more participants chose to use EWI.

Teaching behavior technicians to create publication-quality, single-case design graphs in graphpad prism 7

In this investigation, we (a) define the desirable features of publication-quality, single-case design graphs based on recommendations in the scholarly literature, (b) suggest GraphPad Prism as a suitable graphing program for creating graphs with those features, and (c) develop and validate a video-modeling tutorial designed to train behavior technicians to create such graphs. Our review identified nine commonly recommended features, and Prism facilitated the creation of graphs with those features. We evaluated the effects of a video-modeling tutorial on graphing performance in Prism using a multiple-baseline design. All four technicians showed mastery-level graphing accuracy with accompanying increases in efficiency following training, which maintained at follow-up without direct feedback from an expert behavior analyst. Social-validity measures found the posttraining graphs to be significantly better than publication quality. We discuss these findings relative to challenges of developing efficient and effective staff-training tutorials.

Integrating Phase Change Lines and Labels into Graphs in Microsoft Excel®

Creating phase change lines and their corresponding labels in Microsoft Excel® remains a difficulty for many behavior analysts who want these display features to be integrated into the graph itself. Previous methods designed to address this issue have had limited utility across the types of data sets commonly analyzed by behavior analysts. The purpose of this article is to provide a fully functional method for integrating phase change lines and labels into Microsoft Excel® line graphs. This method is a combination of previous recommendations and allows for easy integration of new data and exportation of graphical displays to other software programs (e.g., Microsoft Word® and PowerPoint®).

Systematic Use of Visual Analysis for Assessing Outcomes in Single Case Design Studies

Single case designs (SCDs) allow researchers to objectively evaluate the impact of an intervention by repeatedly measuring a dependent variable across baseline and intervention conditions. Rooted in baseline logic, SCDs evaluate change over time, with each participant serving as his or her own control during the course of a study. Formative and summative evaluation of data is critical to determining causal relations. Visual analysis involves evaluation of level, trend, variability, consistency, overlap, and immediacy of effects within (baseline and intervention) and between conditions (baseline to intervention). The purpose of this paper is to highlight the process for visually analysing data collected in the context of a SCD and to provide structures and procedures for evaluating the six data characteristics of interest. A checklist with dichotomous responses (i.e., yes/no) is presented to facilitate implementation and reporting of systematic visual analysis.

Automating Phase Change Lines and Their Labels Using Microsoft Excel(R)

Many researchers have rallied against drawn in graphical elements and offered ways to avoid them, especially regarding the insertion of phase change lines (Deochand, Costello, & Fuqua, 2015; Dubuque, 2015; Vanselow & Bourret, 2012). However, few have offered a solution to automating the phase labels, which are often utilized in behavior analytic graphical displays (Deochand et al., 2015). Despite the fact that Microsoft Excel® is extensively utilized by behavior analysts, solutions to resolve issues in our graphing practices are not always apparent or user-friendly. Considering the insertion of phase change lines and their labels constitute a repetitious and laborious endeavor, any minimization in the steps to accomplish these graphical elements could offer substantial time-savings to the field. The purpose of this report is to provide an updated way (and templates in the supplemental materials) to add phase change lines with their respective labels, which stay embedded to the graph when they are moved or updated.

Recording an Excel(®) Macro to Specify Date Ranges for Clinical Data

The individuals served by behavior analysts are often funded by Medicaid, insurance companies, or private pay. The first two options usually require progress notes detailing graphically and quantitatively the behavioral outcomes. These progress notes usually come in the form of a written account of milestones achieved or barriers faced, graphical displays of behavioral data, and summary tables. The graphical displays are monthly, quarterly, and annual reports for the individuals that they serve. Microsoft Excel® is one of the most accessible tools by which to accomplish this task; however, presenting the required date ranges can be a time-consuming task. A task analysis is outlined to automate this process and reduce the time taken to accomplish indirect service hours to the clients served.

Inserting Phase Change Lines into Microsoft Excel® Graphs

Microsoft Excel® is a popular graphing tool used by behavior analysts to visually display data. However, this program is not always friendly to the graphing conventions used by behavior analysts. For example, adding phase change lines has typically been a cumbersome process involving the insertion of line objects that do not move when new data is added to a graph. The purpose of this article is to describe a novel way to add phase change lines that move when new data is added and when graphs are resized.