*Note: To begin using the graphing template, go to the File menu (above) and then select "Make a copy" - Enter the new name for your graph

(i.e. the student's name and the school year for which data will be entered) and then click on "OK" - the new graph is now saved in your Google Drive and editable.

General Notes:

1. Double click on any cell in which dates are to be entered in order to select the date using the pop up calendar, or simply key in the date

2. You must begin on the Parameters tab; this tab's data is used to set up the data sheet and the graphs

3. Follow the directions below and everything should work! (If you experience problems or think that something on the graph needs to be fixed,

please contact Kevin Kuhn at Kevin.M.Kuhn@gmail.com

Begin on the Parameters Tab:

1. Enter identifying information - student and case manager name

2. Enter start and end dates

**Note: The template is intended to be used over the period of one school year, however can accommodate the length of one calendar year;

If using one calendar year, enter the start and end dates accordingly, rather than beginning and end of school year (Eg. 3/4/2015 and 3/3/2016)

**Note: The horizontal axis of the graphs uses linear numerical data representing days of instruction; the Green Section addressed here is used to remove

non-instructional days from the graph so that the data accurately reflects growth per days of instruction

1. In column E, enter holidays that are to be removed from the instructional calendar

2. In column F, enter teacher in-service days

3. (Optional) In column G, enter snow days as they occur - if using this column, these MUST be entered before entering the data following the snow days;

otherwise the data may not match up with the correct date

4. In column H, enter summer days (if graphing a calendar year rather than a school year), or optionally any other days of non-instruction (field trips, absences, etc.);

again, note that these dates must be entered BEFORE entering the data following those dates, otherwise dates will not line up correctly with the data

1. Dates are automatically populated in column A based on data entered in the Parameters tab;

if the end date needs to be extended (up to one year), change the date on the Parameters tab, not on the Data tab

2. Column C automatically populates according to data entered on the Parameters tab

3. Column D is to be used infrequently to enter intervention, phase, or condition changes;

whatever text is entered in this column will appear on the graph with a vertical "phase change" line at the corresponding day of instruction

4. Columns E, G, and I are used to enter Mand rate or frequency data according to their headings

***Note: To calculate rate within the sheet, simply use the following equation in the cell, without quotes: "=Count/Time" (Minutes or Hours)

1. The Graph tabs are labeled according to the data that are graphed

2. On the graph, click on the text "Click here to insert chart title"; a pop-up window will open - enter the title and strike the Enter key

3. Although the graph will automatically update as data is entered and editing the graph should not be necessary, if changes need to be made to the graph,

either try clicking on a section of the graph and editing or click on the "Advanced edit" button at the top right to open the editing pop-up window

4. To print your graphs or enter them into other documents, click on "Save Image", or use your computer's Snipping Tool or other screen capture feature to create an image of the graph,

then insert the graph into the appropriate document and print