STAY AWAY AGREEMENTS
Sites/Software you'll need:
Google Forms
Google Sheets
Google Docs
AutoCrat Add-On
- Create your Google Form
Add any pertinent information you need to document
2. Create your response document
This document can be edited or tailored to whatever your campus or district policy supports
In order for AutoCrat (mail merge extension) to work successfully, you need to prepare a document where the responses will go with corresponding data
You can set it up any way you see fit but in order for the answers to populate the document you must have <<>> on either side of the form answers (SEE EXAMPLE HERE)
Save the document as STAY AWAY template - you will need to remember this document name for the next step
3. Prepare your google sheet
As you're creating your GoogleForm, you will notice 3 tabs at the top of your form document - click on the Responses tab.
On the Responses tab there will be a link at the top right of the page that says "Link to Sheets" - this will be where your responses will be populated
On the Google Sheet that you've just created, go to Extensions - then Add-Ons
From the Add-Ons menu - click AutoCrat and install the extension
Once installed, Launch the AutoCrat extension and click "New Job"
4. Load your autocrat merge
Once you click "New Job" from the Autocrat extension, you will be prompted to name your job. STAY AWAY AGREEMENT is an easy one.
The next screen will prompt you to select a template document - this is where you will select your "STAY AWAY" document you prepared earlier
You will then be tasked to map the source data with the <<>> tags
Once all of your tags are matched, it will ask you to name each of the documents
To easily organize your documents, use this for the file names: <<Last Name>> STAY AWAY - this will save all the documents as the student's last name so they're easily identifiable
On the next screen, you will be asked where you want to save your documents. Creating a "Stay Away" folder in your drive would be an ideal place to save your forms in one place.
When you get to the "Share Docs & Send Emails" page, click no
Click Next through the next prompt until you get to the Form Triggers page. Where it asks if you want the form to run on form triggers, click yes. This is what automatically runs the system and sends the documents to your designated folder
TRUANCY REFERRAL
Sites/Software you'll need:
Google Forms
Google Sheets
Google Docs
AutoCrat Add-On
- Create your google form
Add any pertinent information you need to document
2. CREATE YOUR RESPONSE DOCUMENT
This document can be edited or tailored to whatever your campus or district policy supports
In order for AutoCrat (mail merge extension) to work successfully, you need to prepare a document where the responses will go with corresponding data
You can set it up any way you see fit but in order for the answers to populate the document you must have <<>> on either side of the form answers (SEE EXAMPLE HERE)
Save the document as TRUANCY COURT template - you will need to remember this document name for the next step
3. prepare your google sheet
As you're creating your GoogleForm, you will notice 3 tabs at the top of your form document - click on the Responses tab.
On the Responses tab there will be a link at the top right of the page that says "Link to Sheets" - this will be where your responses will be populated
On the Google Sheet that you've just created, go to Extensions - then Add-Ons
From the Add-Ons menu - click AutoCrat and install the extension
Once installed, Launch the AutoCrat extension and click "New Job"
4. Load your autocrat merge
Once you click "New Job" from the Autocrat extension, you will be prompted to name your job. TRUANCY COURT REFERRAL is an easy one.
The next screen will prompt you to select a template document - this is where you will select your "TRUANCY COURT" document you prepared earlier
You will then be tasked to map the source data with the <<>> tags
Once all of your tags are matched, it will ask you to name each of the documents
To easily organize your documents, use this for the file names: <<Student Name>> TRUANCY COURT - this will save all the documents as the student's last name so they're easily identifiable
On the next screen, you will be asked where you want to save your documents. Creating a "Truancy Court" folder in your drive would be an ideal place to save your forms in one place.
When you get to the "Share Docs & Send Emails" page, click no
Click Next through the next prompt until you get to the Form Triggers page. Where it asks if you want the form to run on form triggers, click yes. This is what automatically runs the system and sends the documents to your designated folder
Truancy/DAEP Plan
Sites/Software you'll need:
Google Sheets
Google Docs
AutoCrat Add-On
- Create your Google SHEET
Add any pertinent information you need to document
2. Create your response document
This document can be edited or tailored to whatever your campus or district policy supports
In order for AutoCrat (mail merge extension) to work successfully, you need to prepare a document where the responses will go with corresponding data
You can set it up any way you see fit but in order for the answers to populate the document you must have <<>> on either side of the form answers (SEE EXAMPLE HERE)
Save the document as DAEP Intervention template - you will need to remember this document name for the next step
3. Load your autocrat merge
On the Google Sheet that you created, go to Extensions - then Add-Ons
From the Add-Ons menu - click AutoCrat and install the extension
Once installed, Launch the AutoCrat extension and click "New Job"
Once you click "New Job" from the Autocrat extension, you will be prompted to name your job. DAEP Intervention Plan is an easy one.
The next screen will prompt you to select a template document - this is where you will select your "DAEP Intervention" document you prepared earlier
You will then be tasked to map the source data with the <<>> tags
Once all of your tags are matched, it will ask you to name each of the documents
To easily organize your documents, use this for the file names: <<Last Name>>DAEP Intervention Plan - this will save all the documents as the student's last name so they're easily identifiable
On the next screen, you will be asked where you want to save your documents. Creating a "DAEP Invention" folder in your drive would be an ideal place to save your forms in one place.
When you get to the "Share Docs & Send Emails" page, click no
Click Next through the next prompt until you get to the Form Triggers page. Where it asks if you want the form to run on form triggers, click yes. This is what automatically runs the system and sends the documents to your designated folder