University:
California State University, Northridge
Course:
ACCT 412L | Excel Specialist Certification
Academic year:

2011
Views:

46

Pages:

31
Author:

Reynaldo Wong

CREATING Changing Criterion and Parametric Analysis SINGLE-‐SUBJECT DESIGN GRAPHS IN MICROSOFT EXCEL FOR MAC 2008 1 Step 1: Set up the Variables (X & Y-Axes) Changing Criterion design Use the second row of cells to Label the variables that will be displayed on both the X and Y-‐Axes of the graph 2 Step 1: Set up the Variables (X-Axis) Changing Criterion design Enter X-axis label in this cell For example: • If you are graphing data for each day enter, “Date” in this cell • If you are graphing data for each trial, enter “Trial” in this cell • If you are graphing data for each session, enter “sessions” 3 Step 1: Set up the Variables (X-Axis) Changing Criterion design 4 Step 1: Enter the data (X-Axis) Changing Criterion design Enter the dates, or trial or session numbers in the column below the “X-Axis” label 5 Step 1: Set up the Variables (Y-Axis) Changing Criterion design Intervention 6 Step 1: Set up the Variables (Y-Axis) Changing Criterion design 7 Step 1: Set up the Variables (Y-Axis) Changing Criterion design 8 Step 1: Set up the Variables (Y-Axis) Changing Criterion design 9 Step 1: Set up the Variables (Y-Axis) Changing Criterion design 10 Step 1: Set up the Variables (Y-Axis) Changing Criterion design 11 Creating the line Graph 12 Step 3: Create the Line Graph 13 Step 3: Create the Line Graph 14 Step 3: Create the Line Graph 15 Step 4: Formatting Line Graph 16 Step 4: Formatting Line Graph 17 Step 4: Formatting Line Graph 18 Step 4: Formatting Line Graph 19 Step 4: Formatting Line Graph 20 Step 4: Formatting Line Graph 21 Step 4: Formatting Line Graph 22 Step 4: Formatting Line Graph 23 Step 5: Adjusting the X-Axis None Outside 24 Step 6: Adjusting the Y-Axis 25 Step 6: Adjusting the Y-Axis 26 Step 7: Drawing Phase Change Lines 27 Step 7: Drawing Phase Change Lines 28 Step 8: Label the phases • • • • • • Click on insert Click on draw text box Enter the name of the phase Using the Formating Palette on the right .. Click on Fill (no color) and Line (no color) Repeat for other phases 29 Step 9: Remove graph border 30 Step 10: Drawing Lines to Show Criteria Was Met 31

Changing Criterion and Parametric Analysis

Changing Criterion and Parametric Analysis - Page 3

Changing Criterion and Parametric Analysis - Page 4

Changing Criterion and Parametric Analysis - Page 5

Changing Criterion and Parametric Analysis - Page 6

Changing Criterion and Parametric Analysis - Page 7

Changing Criterion and Parametric Analysis - Page 8

Changing Criterion and Parametric Analysis - Page 9

Changing Criterion and Parametric Analysis - Page 10

Changing Criterion and Parametric Analysis - Page 11

Changing Criterion and Parametric Analysis - Page 12

Changing Criterion and Parametric Analysis - Page 13

Changing Criterion and Parametric Analysis - Page 14

Changing Criterion and Parametric Analysis - Page 15

Changing Criterion and Parametric Analysis - Page 16

Changing Criterion and Parametric Analysis - Page 17

Changing Criterion and Parametric Analysis - Page 18

Changing Criterion and Parametric Analysis - Page 19

Changing Criterion and Parametric Analysis - Page 20

Changing Criterion and Parametric Analysis - Page 21

Changing Criterion and Parametric Analysis - Page 22

Changing Criterion and Parametric Analysis - Page 23

Changing Criterion and Parametric Analysis - Page 24

Changing Criterion and Parametric Analysis - Page 25

Changing Criterion and Parametric Analysis - Page 26

Changing Criterion and Parametric Analysis - Page 27

Changing Criterion and Parametric Analysis - Page 28

Changing Criterion and Parametric Analysis - Page 29

Changing Criterion and Parametric Analysis - Page 30

Changing Criterion and Parametric Analysis - Page 31

of 31

Description

Free up your schedule!

Take 5 seconds to unlock