• The first 3 form responses should include:

  • Teacher email (Text response)

  • Teacher name (Text response)

  • Content Area (Either Text Response or Multiple Choice by Content Area)

• Add any specific area you are wanting to observe

• Responses can be either Yes/No, Multiple Choice, or Text Response

• The last 2 form responses should be:

  • An email listing of the evaluators/appraisers/administrators who will be giving walkthroughs on your campus.

  • An "admin password" that only your appraisers know (this will prevent students from randomly trying to submit walkthrough forms)

• CLICK HERE FOR SAMPLE FORM

• 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 your walkthrough template - you will need to remember this document name for the next step

• 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"

• Once you click "New Job" from the Autocrat extension, you will be prompted to name your job.   Teacher Walkthrough is an easy one.

• The next screen will prompt you to select a template document - this is where you will select your "Teacher Walkthrough" 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>> Walkthrough - this will save all the documents as the teacher'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 "Walkthroughs" 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, this where you will create the email that will send once you hit submit on your walkthrough form.

  • On the To: line - type <<Email>>

  • On the CC: line - type <<Admin>> (this will be appraiser's email)

  • Fill in the Subject and Message you want sent with each walkthrough

• 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 information to your teachers.

• Click HERE to see what the email will look like

• This is where you can take your liberty in Canva - create a QR template where you can change out the QR codes, depending on which teacher you're creating the codes for

• Once you have your basic template, go to the editable version of your walkthrough template

• Click the 3 dots at the top right of the document and click "Get Pre-Filled Link" - This is where you will ONLY pre-fill your teacher information on the first 3 response questions

• Scroll to the bottom of your form and click the "Get Link" tab

• You will copy that specific link and go back to your Canva template

• In Canva, click the "Apps" tab on the left - go to QR codes

• Paste the copied link from your pre-filled form into the space provided and it will then create the teacher-specific QR code that you will add to their specific sticker (see above)

CLICK HERE FOR SAMPLE FORM

• 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 your walkthrough template - you will need to remember this document name for the next step

• 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"

• Once you click "New Job" from the Autocrat extension, you will be prompted to name your job.   Sub Info is an easy one.

• The next screen will prompt you to select a template document - this is where you will select your "Sub Info" 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>> Sub Info - this will save all the documents as the teacher'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 "Sub Info" folder in your drive would be an ideal place to save your forms in one place.

• 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 populates the documents.