Install our Add-on from  Google Workspace Marketplace. Once installed, create a new spreadsheet. 

• Make sure you give your spreadsheet a meaningful name.

• Do not enter any data into the new spreadsheet.

Run the Set up process.

•  Extensions > Student Data System > Setup System

During Setup, you will be asked for the current school year and if you want to gather classroom data by class periods. Class periods can consist of any type of time intervals, including hours, periods or time slots.  

The system will then create three sheets, "Student Info", "System Info", and "Responses". 

• If you selected "Yes" to "Gather Data by Class Periods," the system will default those class periods to 1-7.  You can change those names or add/remove class periods in the second column of the "System Info" sheet (i.e. "Math", "Reading", "Social Studies", "09:00am - 09:30am"). 

  • If you no longer want to enter data by class period, delete all of the values in column B of the "System Info" spreadsheet, leaving the column header of "Class Periods."

• The system will also default values in the "System Info" sheet for expectations, skills, reinforcers and target behaviors.  You can add/remove from any of the values from these lists.

  • Note:  Expectations, Skills and Target Behaviors must be unique for each student and can not be duplicated!  If need be, you can add additional options to each category. For example, if you want to use two types of Relationships Skills, you could add Relationships skills 1 and Relationships skills 2.

Once Setup has finished, you will need to add your student roster to the "Student Info" sheet along with their expectations, skills and target behaviors.  

• The Case Manager/Teacher column (Column A) can be used to enter if multiple staff members use the same roster. Not all students need to have a case manager/teacher assigned.  If you will not be using this column, you can hide it. Please DO NOT remove the column! 

Once you have set up your students and their expectations, skills and targets, you can start adding student behavior data.

• Extensions > Student Data System > Add Student Data

  • All answers are required for the expectation, skill and target behavior questions.

    • If "Yes" is selected for a specific Skill, there will be an additional question asked for the Skill Reinforcer.  This question is not required.

Editing or Deleting responses

• The "Responses" sheet will hold all data entered for the students on your roster and can be edited there. 

  • The Date, Class Period, Reinforcer, Answer and Notes column can be changed, but if the other columns need to be changed it is best to delete the rows and enter the data again through the Extensions > Student Data System > Add Student Data  menu.

    • Answers should be '0' for No and '1' for Yes.

    • To delete entries made for one student/date/class period combination, you will need to delete multiple rows.  There will be one row for each expectation, one for each skill and one for each target behavior. 

    • Any question answered with "No Opportunity" for skills will not be into the Responses sheet.

      • If you entered "Yes" or "No" but meant to select "No Opportunity", delete the row.  

      • If you entered "No Opportunity" but meant to select "Yes" or "No", a new row with the information needed can be manually entered. It is best to copy from a another row with the needed student/date/class period combination and change the category, type, and answer.

You can create your report by using our template, located here.

From our template, make a copy of the report by selecting the action menu at the top right hand side of the report and then "Make a copy."

On the "Copy this report" dialog, select "Create data source" from the "New data source" list.

• The original Data Source will show as (Unknown).

Select "Google Sheets" from the list of Google Connectors. If this is the first time you have used Looker Studio with Google Sheets you will need to give authorization.

From the list of Spreadsheets, find the spreadsheet that has your student roster and data responses. 

• Select that spreadsheet.

• Then select the "Responses" Worksheet.  It will default to "Student Info", so make sure you change this!

• Leave the Options as they are defaulted.

• Select the "Connect" button in the top right.

From the next page, leave all dimensions and metrics as they are.

• Select the "Add to Report" button in the top right.

Your spreadsheet should now show up as the "New Data Source."

• Select the "Copy Report" button.

Your report is now ready!  As more responses are added to your spreadsheet, that data will show up automatically.

You will need to do one quick fix so the graphs show the percentages instead of numbers.  Complete the following for all tables and graphs.

• Make sure you are editing the report by selecting the "Edit" button in the top right.  If that button says "View" you are in the edit mode.

• Click on your graph and look for either the "Percent" Metric or the "Answer" Metric column in the right Setup section. Click AVG.

• Change the Data Type from Numeric > Number to Numeric > Percent.