Google Forms for the PASS Program

The PASS Program Template V4.2 Google Spreadsheet/Form is used in various schools for collecting and charting data. Data is collected through a form and then displayed in the associated spreadsheet. 

Teachers are able to make some basic adjustments to dates  (located in the yellow cells) in the Data Summary page to generate the associated charts, as shown in the images below.

To get started, watch the tutorial video below.

After watching the entire video above, click here to request access to the PASS Program Template V4.2 Google Spreadsheet/Form. 

Follow the directions below -- they are very specific, but will work for you if you adhere to them. 

If you need assistance, please call Lynn at x3430.

To add a new student to the PASS Template

These instructions are for getting a student’s data sheet onto an iPad or apple mobile device. Thanks to Shelley Nurre for her step-by-step directions!

On your Computer

These steps are for creating a data sheet/form for each of your student based on your template.

• 1. Go to Google Drive, locate the Pass 4.2 Folder for your school and add it to your drive. Locate and open the PASS Program Template V4.2 Google Spreadsheet. 

  2. Select File: Make copy

  3. Rename the file (e.g., type student initials)

  4. Select Form: Edit Form — if you do not see this menu option, please call x3430.

  5. Rename the form (e.g., type student initials)

  6. Change STUDENT NAME to student’s initials

  7. Add homeroom teacher name, grade, and homeroom number as desired

  8. Click the View Live Form button

  9. Copy entire URL of the live form (you will use this to add a hyperlink later)

  10. Close the live form, the form you were editing, and the new spreadsheet.

  11. Open your email on your computer (not the iPad or mobile device)

  12. Compose new message to self

  13. Paste the previously copied URL into your email

  14. Repeat steps 1-13 until you have a form for each student

  15. Send yourself the email.

On your iPad/Mobile Device

These steps are for adding an icon to your iPad/mobile device to quickly access each of your students Google forms.

• 1. Log into your email

  2. Open the message you sent to yourself

  3. Click on hyperlink

  4. When it opens the form in Safari, click the Add to button and add it to your homescreen

  5. Repeat steps 3-4 until you have an icon for each student

Bonus: To add a Student to the Daily Summary Template

The Daily Summary Template allows you to quickly view student data for Check Out at the end of the day. It requires that you enter some information so that your current student data shows up.Thanks to Shelley Nurre for her step-by-step directions!

On your Computer

• 1. Sign in to Google Drive; click here to open the Daily PASS Summary Template or, if you already have your own copy of this document, open your own copy (if you have your own copy, skip to step 4).

  2. Select File: Make copy if you do not already have a copy of this document

  3. Rename the file as appropriate (e.g., MTV Daily PASS Summary)

  4. Add student initials to Column A

  5. Click in the cell in Column B next to an existing student; notice the formula in the formula bar

  6.  Example: =ImportRange("0Ah3FSQP1ELfEdE5CdFNlNDltRkF0OHhTaEllV25Wd0E&hl","Data Summary!$C$11:$G$11")

  7. — you will need to edit this slightly for each student.

  8. Open a student's data sheet: look at the URL and copy the portion from key=0……..to……..# 

  9. Go back to Daily PASS Summary and paste copied portion of URL into the formula in Column B for the specific student. NOTE: You will only be replacing the portion of the formula you originally copied — 0…..to…..#

  10. If you see the red triangle in the top right corner of a cell (as shown in the image below), hover over it and the click Allow Access. Once you have done the copy/paste and allowed access, the #REF! will go away and daily summary data will appear.

• 1. Check to see that the data in the Student Weekly Data Sheet is the same as the data on the Daily PASS Summary Sheet. If so, you are successful! Repeat steps 4-7.