PBIS / School Improvement

A client needed a Behavior Referral system that allowed for the following:

  • Teachers needed to be able to fill out the referral form

  • The form needed to be automatically sent to the administrator

  • The administrator needed to be able to edit the referral document, add the follow up information and consequence, and share it to the teacher

  • We wanted all the data to be in the form spreadsheet.

  • So we built a system where all this happens with the form, so that all data is on the sheet.

Here is what we built:

  • A google form with the behavior referral information

    • The google form branches at the end with a question (Are you an administrator? If no, continue on and submit form. The section that comes after a Yes answer is used by the administrator to add the follow up data.)

  • Form Publisher creates a document from the template

  • A script to add the Form Edit URL to the form response sheet, so the admin can go back into the form, change the 'Are you an administrator question' to yes, and continue on to answer the followup questions which will then be both on the google doc as well as the spreadsheet.

  • Form Publisher then automatically republishes the document with the updated information.

  • Then we build a data studio project to share the document URL so staff can see what they have submitted, and what the Administrator has done in the followup.