USER MANUAL, SCCFB - Stuart Harder Charting Templates
Contents
1. 1 40572111 2 15642769 1 74334627 average or moving median in which a fixed number of data fssanasnonn points are averaged and plotted a 2 0 5 0 3 0 1 84201575 0 2 41372346 4 0 4 6 0 1 3103707 1 84201575 2 0 2 08008352 5 2 41372346 1 0 3 30192725 f 2 72560089 1 0 1 58740105 3 1 72554029 0 8 1 16039771 3 1 52805015 pointer is moved ahead one step and a new set of points same number of points are averaged in the same way This is what happens with the mAMR Chart The user specifies the number of terms days to include in the calculation of the absolute mean ratio and the program uses that number in calculating repeated AMRs for as many sets of data points as it can The number of terms in the moving window is entered in the yellow box in column E row 2 Generally windows in the range of 3 to 5 work bests as larger windows while smoothing the data quite nicely cause the loss of data at the beginning of the series To clear the mAMR Chart of its data click the red CLEAR AMR DATA button on the Moving AMR page Sample Charts The Moving Absolute Mean Ratio Chart Daily Celeration Line Labels cel value lota absolut t Count per SUCCESSIVE CALENDAR otal bounce absolute mean ratio Minute S S oe or J 9 E c E o o a o c S gt E E C jn e 14 21 28 35 42 49 656 63 70 77 84 91 98 3105 112 119 12. Start Date 9 3 2007 the dialog box 1s described below End Date 9 10 2007 Proiect To 9 17 2007 Celeration Dates 1 Start Date defines the first date in a Bh Bed d E Acceleration Movement i MANO i i M Deceleration Movement series of consecutive dates over which the ed eid E Accuracy tato series celeration line is drawn 2 End Date defines the last date in the series of consecutive dates over which the Median Slope O White 2005 fe Linear Regression vi Add Labels to Celeration Lines vi Add Bounce Lines to Chart Chose Confidence Interval 5096 Bounce 75 Bounce 80 Bounce O 90 Bounce f 95 Bounce C Min Max 3 celeration line is drawn Project To defines the date out to which the celeration line is drawn This line is shown as a dashed line extension of the solid blue celeration line Apply Celeration Lines To 1 Acceleration Movement when checked causes a celeration line to be drawn through the selected acceleration movement data Deceleration Movement when checked causes a celeration line to be drawn through the selected deceleration movement data Accuracy Ratio Series when checked causes a celeration line to be drawn through the selected accuracy ratio data points Chose Celeration Method 1 Median Slope O White 2005 follows the rational and methods provided by Owen White Ph D to draw a celeration line through the medi
3. Movement Celeration Line with Forecast dashed and Upper Lower Bounce Lines Incorrect Movement Celeration Line with Forecast dashed and Upper Lower Bounce Lines COUNT PER MINUTE Celeration Lines with Projection Bounce Text Labels The right hand panel adds text to label the celeration line and its component elements Added text includes Count per SUCCESSIVE Minute e 1 Celeration value cel this value dh ow P oS describes the rate of growth in the selected frequencies When the X Correct Movement Celeration Line with Forecast dashed symbol precedes the celeration value it i Upper Lower Bounce Lines indicates position growth When a pr rita division sign precedes the celeration value it indicates deceleration in the r 1 20 Incorrect Movement i Celeration Line with Forecast dashed Upper Lower Bounce Lines and Statistics frequencies 2 Total bounce bnc Total bounce refers to the distance from the lower bounce line called down bounce to the JUNT PER MINUTE upper bounce line called up bounce 3 Absolute Mean Ratio amr the absolute mean ratio is a measure of bounce based on average of the absolute log distances between all pairs of observations An individual AMR value is not easy to interpret but gives meaningful information about the relative changes in bounce variation from one condition to the next These relative changes are calculated and disp
4. Weekends is set to Yes the next available date will jump over a weekend and enter the next available Monday from the previous Friday Note when entering dates use the format m d yyyy For example enter September 5 2007 as 9 4 2007 Should the user wish to skip consecutive dates each click on the Get Next Date button will advance one day at a time Otherwise the user may enter any date between the Synchronization Date and End Date 140 days later Once the Date Record Floor Correct and Error counts and Comments are entered click Save Scores Next Date will save the data and advance to the next available date If the user wishes to end data entry after entering new data click Save and Exit otherwise click Exit Don t Save When entering Record Floors enter an integer for hours minutes and seconds For example Record Floor in the right hand panel shows a counting time of 20 seconds After each new entry is saved using Save Scores Next Date the Record Floor from the previous entry is brought forward to minimize the amount of data entry In this way the user need only change the Record Floor should the have been a change The Celeration Finder Dialog Box The Celeration Finder dialog box is shown Celeration Dates in the panel to the right Each element of Next Avail Date 9 13 07 Skip Weekends Yes Enter Record Floor Hours Minutes Seconds Benchmark Celeration Finder Chose Celeration Method
5. 26 133 140 SUCCESSIVE CALENDAR DAYS Supervisor Patricia Camden Manager Jacob Lehmann Adviser Mary Anderson Performer Sarah Nash Grade Age 4th 10 yrs Organization ISD 1102 Agency Lincoln Elementary Mov ing Absolute Mean Ratio Corrects circles Counter Sam H Timer Sam H Charter Sam H Errors X s Accuracy Ratio Triangles SUMMARY STATISTICAL TABLES Whenever the user generates a celeration either for the acceleration or deceleration movement cycle a range of statistical data are transferred to the Summary Tables page The following is a brief description of the elements in the table They are intended to provide researchers with a number of tools needed to evaluate various statistical propositions and may not be of use in daily practice The left hand columns are reserved for corrects the right hand columns are reserved for errors 1 Start End Proj To Dates these are dates defining the end points of the celeration line in question 2 N Indicates the actual number of data points frequencies included in the calculation of the celeration line This may not be the same as the number of days over which the celeration line was calculated as there may have been no opportunity days in the mix N represents actual data days 3 Begin Pt End Pt and Proj Pt these are the values that define the beginning and end frequencies used to generate the celeration line as well as the value to which the celeration line was pr
6. Celeralion Line Labels ce Value Daily olai Dounce absolute mean ratio Count per SUCCESSIVE CALENDAR WEEKS FOR NOG eI REEN SUUS Minute P dA S S E a o ed ce x S S e e vo 09 NN Y LU e 1000 500 Acceleration AIMStar Acceleration Movement Correct PHASE wi A A PHASE II ke k A 100 o z 50 5 2d cry X COUNT PER MINUTE Supervisor Patricia Camden ISD 1102 Agency Lincoln Elementary Charter Sam H Organization Counter Sam H Timer Sam H Redord Floor or Counting Time Manager eceleration Movemen 40 Plotted a fraction below the Record Floor usingape Jacob Lehmann See aed MA 0 St Croix River Education District bs 49 56 63 70 T B4 91 98 105 3112 3119 326 333 14 SUCCESSIVE CALENDAR DAYS ar Gg Performer Sarah Nash Grade Age 4th 10 yrs Acceleration Movement circles See Say Word From din t S rrect Deceleration Movement X s Ses Adviser Mary Anderson Say Word Inco INTRODUCTION This instruction manual describes for users of the Excel Standard Celeration Template s the features of each page or worksheet in the template allowing the user to set up and generate charts that conform reasonably closely to those created by Ogden Lindsley The following sections describe the various functions built into the template workbook Set Up page Progress Record page Notes amp Phase Lines page AIMStars
7. Finder dialog box Down Bounce this value indicates how far below the celeration line the data points bounce down to the limit of the confidence interval The user sets these limits in the Celeration Finder dialog box Total Bounce this value represents the total distance or total variation of data points on either side of the celeration line Conf Interval This is the value chosen by the user when setting up calculations for the celeration line This was set in the Celeration Finder dialog box 14 Relative AMR Change this value indicates what percentage change was observed in the AMR values from the previous condition to the present condition 15 Relative AMR Variation this value compares the AMR values for corrects and errors over the same time period CELERATION LINES The Ceeration Lines page records all information needed to draw celeration and bounce lines on the chart There are two buttons at the top right of this page used to clear celeration lines from the chart The Clear All Lines button does exactly that it removes all celeration lines from the charts The Clear Selected Line button is used to remove individual celeration lines To use this feature the user must know the exact date on which the celeration line began This page contains tables for Correct and Error celeration lines Each line is defined by a Start and End Date along with a Day Number relative to the beginning of the Chart used to identify the co
8. ans of frequencies and days using a routine called double back method This method is conservative and robust and is the recommended choice for determining celeration The Summary Statistics Table page records the method used to calculate the celeration line Linear Regression Method this method is a traditional method for generating a regression line using the least squares linear regression method see Hays W L 1973 Statistics for the Social Sciences Add Labels to Celeration Lines 1 When checked this option imposes text on each chart describing the celeration value bounce value and absolute mean ratio for the line segment designated by the user Add Bounce Lines to Chart 1 When checked this option causes upper and lower bounce lines the equivalent of confidence interval bands to be imposed one either side of the celeration line If checked the user must specify the width of the bounce interval by selecting one of the radio buttons in the area below the check box The options define bounce intervals in a manner similar to that used to calculate the interquartile range The options range from a b e di C f 50 Bounce 25 to 75 ile 75 Bounce 12 5 to 87 5 ile 80 Bounce 10 to 90 ile 90 Bounce 5 to 95 ile 95 Bounce 2 5 to 97 5 ile Minimum Maximum Bounce Full Range 2 The program calculates Total Bounce as the product of the Down Bounce and the Up Bounce Og Lindsley refe
9. ce aims called AimStars 5 Vertical lines with text used to mark changes in instructional conditions Celeration Lines Wo Minute The panel to the right illustrates the presentation of celeration lines imposed on a selection of frequencies both acceleration and deceleration movements The lines are e Celeration Line limited in extent to the start and end dates set by the uU user in the Celeration Finder dialog box found on the Incorrect Movement Celeration Line Progress Record page COUNT PER MINUTE Celeration Lines with Projections Count per The panel to the right present celeration lines solid lines along Minute with lines that project the celeration lines into the future a number of days specified by the user Generally it is not recommended to Correct Movement forecast more than 10 to 14 days because our general interest is in headed Forecast dashed making near term forecasts that inform our decisions about the need l ge MP vnc Incorrect Movement 5 Celeration Line with X Forecast dashed NX x x ki ot T x to maintain or change instruction JNT PER MINUTE Celeration Lines with Projection and Bounce Lines The panel to the bottom right shows data sets with imposed celeration lines a forecast line and upper and lower bounce lines Please refer to the Progress Record page where the Celeration Finder dialog box for a description of the options Correct
10. e Below the regression statistics 1s a table show all start and stop dates for the celeration line associated line values and text labels needed to identify the line NOTES amp PHASE CHANGE LINES PAGE The Notes amp Phase Change Lines page records the date on which an important change in the learner s program took place The critical parts of the phase line placement are 1 The panel to the right illustrates various lines to be placed on the charts Description enter a short 1 3 word description of the Change Date this is the date on which an intervention change or other important event happened Line From Low enter a value corresponding to some value along the Y axis to designate where to begin drawing the phase change line For convenience set this value to that of the Record Floor on that date Line To High enter a value corresponding to some value along the Y axis to designate where to stop drawing the phase change line Choose a value high enough on the Y axis to keep the line out of the way of the data From Line change This text will be attached to the top of the Low To High Description ru f phase change line saal af moBexmak S sia 3 mo Freque ey Bui y Arc emp gp 3 Eb This panel corresponds to the tables values shown above and illustrates how the values from the table are translated 2c SUCCESSIVE into the drawing of
11. e chart without gridlines Celeration Line Labels cel value Daily Count per SUCCESSIVE CALENDAR WEEKS total bounce absolute mean ratio Minute A A A A S S ES A o AS s 8 QD gR dR dR Se Y SF Po 34 a6 OF SF SH SF og SF SH x o s of S e C N Su t d NS a Aid d d C N FM ru v C J S 1000 500 uo ul 100 i as z 2 o S uH 10 5s 5 10 s z 20 s 30s E 1 1m 0 5 2m 2 e 5m 0 1 10 m 0 05 30 m 1h 0 01 P 0 005 4h Bh 0 001 4Gh 0 7 14 21 28 35 42 49 56 63 70 77 84 9 98 3105 112 119 126 133 140 SUCCESSIVE CALENDAR DAYS Supervisor Patricia Camden Manager Jacob Lehmann Adviser Mary Anderson Performer Sarah Nash Grade Age 4th 10 yrs Organization ISD 1102 Agency Lincoln Elementary Acceleration Movement circles See Say Word From List Counter Sam H Timer Sam H Charter Sam H Deceleration Movement X s See Say Word Incorrect ACCURACY RATIO CHART The Accuracy Ratio Chart show the ratio of Correct movements to Error movements and these translate into percent correct using the percentage scale on the right hand side of the Chart Accuracy ratio values greater than 1 0 show corrects greater than errors error rates higher than correct rates have accuracy ratios less than 1 0 One expects to observe rising accuracy ratios as corrects grow while errors fall and stabilize near the Record Floor When the frequency of a movement is recorded as zero 0 the accuracy ratio formula
12. e convert the zero count to one 1 placing the point on the Record Floor An Accuracy Ratio of 10 1 is the equivalent of 90 9 Correct while an Accuracy Ratio of 50 1 is equivalent to 98 Correct The percentage scale is designed without a 100 ceiling though beyond 99 further percentage correct gains are negligible even as frequency gains continue to be realized SUCCESSIVE CALENDAR S hae y oe of oe lt gt Oo O SF eK A oW o v4 3 E Ll O a EI mm o d E o O o d E L o a et O o is 3 o 9 z x 7 14 21 28 35 42 49 56 63 70 77 84 91 98 105 112 119 126 133 140 SUCCESSIVE CALENDAR DAYS Supervisor Patricia Camden Manager Jacob Lehmann Adviser Mary Anderson Performer Sarah Nash Grade Age 4th 10 yrs Organization ISD 1102 Agency Lincoln Elementary Accuracy Ratio Corrects Errors circles Counter Sam H Timer Sam H Charter Sam H Record Floor light blue dash MOVING ABSOLUTE MEAN RATIO CHART AND PAGE The Moving AMR tab opens a D worksheet used to store the results Ea WORKAREA of calculations for the Absolute Enter day count pairs 2 Sot amay on COUNT in ascending order 3 Select populated amy Son amay on DAY in ascending omer 5 Name populated COUNT selection Mean Ratio deanCount The design of the Moving AMR chart 1s similar to a moving 7 Sot entire amay 3 Move mAMR anay to approprate chan colur Cait ub whe oO
13. ee DEERE EERE EERE EEE EEE EERE EE EEE EERE EEE EEEEEEEEEEEEES Sevens A gt 8 Mon gt ee ono A M PILLS peo gt Data Entry The user may enter performance data into AY Record Floor the record fields manually The Record h imm ss Accel Count Decel Count Floor field records counting times the amount of time during which pinpointed movements are counted Record Floor entries are formatted using the h mm ss For example a counting time of 2 hours 33 minutes 45 seconds is entered in the Record Floor field as 2 33 45 Formulae convert the record floor entry into an appropriate decimal time fraction as shown in the table below Conversion of Record Floor Time Entries To Decimal Time Fractions Short Form Long Form RecFloor Result 0 1 0 01 00 0 2 0 02 00 0 0 10 0 00 10 The Accel Count column record the frequency of Correct movements the Decel Count field records the frequency of Misses movements targeted for reduction The Total Poss field records frequency limits imposed on the learner s performance either due to the physical arrangement of the task or limits on the number of opportunities to respond freely Finally the Comments column not shown in the graphic but located to the right of the DcRate column may be used to record any pertinent notes about the learner s perfor
14. layed on the Summary Statistics Table page Moving Text Labels on the Chart Text labels can be moved out of the way of the learner s performance data following the five steps below going from upper left to lower right The upper right panel shows a boarder invoked by one click only To move the text click and drag on the boarder of the text box to its final location lower right panel cel X1 32 Borc X22 Sample Charts The Blueline Chart This Chart is a close approximation to the original blue line SCC but is missing the 7 partial cycle at the bottom from 00067 to 001 which extends the Chart to 24 hours Daily Celeration Line Labels ce value tota ce lut ti Count per SUCCESSIVE CALENDAR WEEKS otal bounce absolute mean ratio Minute A A Qo RQ AN N p c e D F e ce 1109 bnc 63 amr 4 20 COUNTING TIMES z z m z T 56 63 70 77 84 391 98 105 112 119 126 133 140 SUCCESSIVE CALENDAR DAYS Supervisor Patricia Camden Manager Jacob Lehmann Adviser Mary Anderson Performer Sarah Nash Grade Age 4th 10 yrs Organization ISD 1102 Agency Lincoln Elementary Acceleration Movement circles See Say Word From List Counter Sam H Timer Sam H Charter Sam H Deceleration Movement X s See Say Word Incorrect Sample Charts The Linefree Chart This 1s the same chart as the blue lin
15. mance for a particular day 8 Control Buttons on the Progress Record Page The two panels below show the various control buttons needs to invoke the various functions built into this template The three 3 red buttons on the left are used to clear data from individual pages i e Phase Change Lines Celeration Lines amp Raw Data The two yellow buttons invoke the Data Entry and Celeration Finder dialog boxes The blue button finds the last data entry record the purple button updates the moving absolute mean ratio chart the last two red buttons clear the summary tables and aimstars and the green button clears the entire workbook Each button used to clear a page in the template workbook gives a warning to the user allowing the options to halt the process rather than proceed WAY Record Floor i h 9 mmess Accel Count Stu s Pretty Good Data Entry Screen The panel to the right shows a data entry screen used to facilitate rapid entry of record floors frequency counts and comments Access the screen by clicking the yellow button at the NentAvallDate p Comes Eros 9 11 07 188 4 Skip Weekends Yes top of the workbook labeled DATA ENTRY Lus LC tege ro Daly Comment SCREEN mm Seconds 0 Use the Next Avail Date edit box to enter the Save and Exit Get Next Date d Exit Don t Save starting date or let the program find the next available date for you If Skip
16. ogram will advance tom F day to Monday Otherwise the date will advance from Faday to Int T Chart Synchronization Date E SCCFB d v7 2b xl The example to the right illustrates a ped ead ee META Type name of behaver hem This name appear on the progress Sarah Nash mood and on the standard chan 4th 10 yrs completed set of learner information On Row 15 Column C the date 09 02 07 1s recorded This date is the Chart Synchronization Date and corresponds to vu o 9 i 7 Patricia C amden Jacob Lehmann Mary Anderson sir a 8 i the first Sunday of the week in which school starts This date is 9 2 2007 here owe in Minnesota for the 2007 2008 academic o mh OO me ae 7 ero count Multiple este fel NEN TI The zero count multiple is a fractional SSE EEN STS TR IETSTnI to some afbitrarty point below the record floor chose 0 80 of the S record floor because it nad a masonadle aesthetic appeal but any multiplier that determines where to place ToU EE eed eet ax E Ne UE imquences as far below the floor as the next non zero value is above the floor others preter 0 9999 or some other very small decrement frequency count marks when the Mie meson mes manendi eva ew Roe Sip Weekends mfes to the DATA ENTRY dialog box on the Progress performer had zero corrects or zero e ve EES eae es ote Otherwise the date will advance from Fiday to errors The zero count multiplier
17. ojected 4 Cel Val This is the slope or celeration value of the celeration line X means the line is rising divide sign means the line is falling SCCFB dcpm v7 2b xls K L M N ACCELERATION MOVEMENT 9 10 11 12 N BeginPt EndPt Proj Pt jin Method R 2 piFivi v2 AMR UpBounce Dwn Bounce 362 36 5 37 0 0 66670 UnReg 0 00500 PIFIO 02 3 1 0 90623 1 037 1 060 1 044 448 GOB 1040 0 16670 linReg 0 95200 _PIFIS9 05 3 11 0 00458 1 107 1 028 1 040 11 L2 13 Fisher s Exact this 1s a nonparametric test of the hypothesis that the celeration line has a slope of x1 0 meaning the celeration is flat or horizontal Method this describe how the celeration line was generated using either the median slope or linear regression methods RA2 this is the coefficient of determination and indicates what percentage of the bounce or variation in the daily frequencies can be account for by celeration line pLF v1 v2 this column gives the F statistic and degrees of freedom used in the test of the hypothesis that the celeration line is horizontal or flat This test is similar to that described for Fisher s Exact but approaches question with different mathematics AMR this is the absolute mean ratio described earlier 10 Up Bounce this value indicates how far above the celeration line the data points bounce up to the limit of the confidence interval The user sets these limits in the Celeration
18. pages Blueline Linefree Accuracy Ratio amp Moving Absolute Mean Ratio Charts Summary Statistics page Celeration Lines page Supporting Worksheet page Versions page SET UP PAGE The Set Up page contains all the 606 SCCFB dcpm v7 2b xls B C D E F G H E E M LM 7 cdedl food and on the standard chart Renny aa Pet Se SR ww e movements targeted for change staff members supporting the change effort the appropriate affiliations and Spr persons responsible for gathering Manager ff critical counts Record information ee en pertinent to each field may be enter Www p up eoe into the cells 1n Column C just to the right of the field name For example to enter the Performer s name move the mouse to cell C2 column C row 2 and type the learner s name x to some afbitrary point below the record floor chose 0 80 of the record floor because it had a reasonable aesthetic appeal but any other number might be justified For le eter 0 50 Proceed down Column C entering MEE ware ey ey ed meta frequences as far below the floor as the next non zero value is above e floor other preter 0 9999 other decem the appropriate information ot tek e Ke ues aliii bin Dd la Ma i still aibitratly close to the record floor Sip Weekends fens to the DATA ENTRY dalog box on the Progress Racord page If set to YES then whenever the user choses Skip Weekends YES NO SAVE NEXT DATE or NEXT DATE the pr
19. phase change lines with text descriptors attached to each Notice how the start and stop values EO ORE Acquisition move the phase change lines out of the way of the Haou performer s data yet keep each line anchored to the appropriate Record Floor Erasing or Clearing the Phase Lines Table The user may erase all phase change lines by clicking the Clear All Phase Lines button On doing so a warning dialog box see below appears to give the user an opportunity to bil T 2 c Lil o H z 2 o o not proceed Click OK if you wish to continue with the erasure If the user wishes to erase a single line click and drag from the date to description cell then go to Edit Clear Contents You are about to ERASE all phase change C Q lines Do you wish to continue Cancel OK AIMSTAR Setting Performance Targets AimStars set learner performance aims or targets on the Chart using up and down pointing solid colored triangles In other words the triangle points Day Se Minute in the direction of the desired frequency change The first of the three panels on the left below show the table used to set AimStars and may be accessed by clicking the AimStar tab at the bottom of the workbook The middle panel shows how to set an acceleration aim by entering a date and a frequency Enter the frequency in the Aim Star Freg Accel column on the same row as the date The date does not have to rep
20. places Organization the appropriate frequency symbol below the Record Floor on the Chart at a distance equal to the zero count multiplier times the record floor For example if the zero count multiplier is 0 8 and the record floor is 1 minute then zero counts are plotted at 0 8 1 0 0 8 counts per minute using the vertical axis scale Skip Weekends YES NO The user has the option to skip weekend dates when entering data using the Data Entry dialog box see the Progress Record section This is helpful for those persons who work in the public schools or other settings where weekend data are usually not gathered By typing YES in this box the program will automatically advance to the next Monday jumping over the weekend dates Housekeeping Buttons Use the Clear Set up Fields button to erase all record information through Row 14 This action is not reversible using UNDO so a dialogue box will provide A warning before Pedomer Gads Age Accelertion Movement omes Decelemtion Movement X s Supervisor Manager Adviser Organization Agency Counter Timer Charter acting on the erase command The Update Operating System Version determines the current operating system and version and sets various program parameters used by Windows and Mac operating systems Do this only once on opening the template Save the changes immediately Note If you are using Microsoft Office 2007 having a ve
21. resent a target acquisition date as it can specify any point on the SCC that makes it easy COUNT PER MINUTE for the Chart reader to visualize the performance aim and assess how the learner is progressing Enter deceleration aims in the same SUCCESSIVE way with a date a frequency target ae ow a SK a9 SK gy and a zero count Record Floor should the user specify a zero count aim ER MINUTE THE STANDARD CELERATION CHART S pleration Line Labels cel value Daily em Count per SUCCESSIVE CALENDAR WEEKS SIAUDENTMNL RAP CR A Minute S SS P d d WU G 4 E y er ss 1000 500 n m H 100 9 50 z 2 o o Wd 10 Ss 5 5 10 20 s 30s E E 1 im 5 0 5 2 m e 5m 0 1 10 m 0 05 30 m th 0 01 3x 0 005 Bh 0 001 16 h 0 7 14 105 112 119 133 140 SUCCESSIVE CALENDAR DAYS Supervisor Patricia Camden Manager Jacob Lehmann Adviser Mary Anderson Performer Sarah Nash Grade Age 4th 10 yrs Organization ISD 1102 Agency Lincoln Elementary Acceleration Movement circles See Say Word From List Counter Sam H Timer Sam H Charter Sam H Deceleration Movement X s See Say Word Incorrect Charting Practices 1 Circles used to mark the acceleration movement correct targets 2 X s used to mark the deceleration movement incorrect or error targets 3 Dashes used to mark the Record Floor 4 Up amp Down Pointing Triangles used to mark performan
22. rrect celeration line Any confusion regarding which line to select for removal may be resolved by switching to either the Blueline or Linefree charts There visually identify the line to be erased Move the cursor over the solid body of the celeration line to the left end point of the line Do this slowly and do not click the mouse button At the end point of the line a text box will appear giving an identifier for the line this may be cryptic and two numbers in parenthesis T he first number gives the Day on which this celeration line begins the second number records the frequency relative to the y axis vertical axis Use Day to locate the corresponding line on the Ce eration lines page found in Column D Click the cell containing this number and then click the Clear Selected Line button to erase the celeration line
23. rred to Total Bounce as the Bounce Unit and compared frequencies outside of the upper and lower bounce limits by the number of bounce units away from the upper or lower bounce limit These distances give the probability that a particular data point might fall at that distance from the upper or lower bounce limit by chance This method is an alternative to Statistical Quality Control methods that use traditional statistical methods Work Areas on the Progress Record Page The area to the right of the record and comment fields labeled Celeration and Bounce Analysis Area 1s the area into which data get transferred prior to i Day Ye Num FCount Log FCount I 34 1 531 calculation of the celeration line see panel to the right Only the last line calculated is shown in this area but the user can see the original values used the log transformations predicted values and bounce values for each data point relative to the celeration line The author locked this area to prevent accidental erasure of formula Statistics Area The area beginning with column AF row 4 contains the various statistical values used to establish the slope and intercept of the least squares linear regression line This table is the standard tabled values for regression and residual sum of squares coefficient of determination F statistics and degrees of freedom The Absolute Mean Ratio is e er shown 1n the purple box to the right of the tabl
24. rsion number greater than 11 3 this program may not work Microsoft dropped Macintosh support for the Excel 4 Macro language used in the coding of routines for these templates and dropped support for Visual Basic for Macintosh as well Navigation Panel A shows the navigational arrows 2 left 2 right that expose the tabs at the bottom of the workbook Click the left bracket arrow to expose the first tab worksheet in the workbook and click the right bracket arrow to expose the rightmost tab of the workbook The central left and right arrows move the tabs in either direction one tab at a time Panels B through D show the various worksheets contained in the template s workbook i P gt i HA p E IP Ready PROGRESS RECORD PAGE Use the Progress Record page to record the daily learner performance counts This section of the workbook allows the user to enter data in only five columns the remaining cells are locked Protected cells prevent inadvertent data entry as most regions on this page contain formula whose functions are dependent on preserving critical relationships synchronization Date The synchronization date comes from the Set up page to cell C4 by way of a formula It determines every other date needed to set up the database and charts To change the dates listed on the Progress Record page change the synchronization date on the Set Up page gt gt gt gt gt LILLIIIIIIII PPP PPP Poe S
Download Pdf Manuals
Related Search