Forms can bring transparency and organization to administrative processes in a school. For example, instead of filling out paper requests that could potentially be lost en route to the correct department (IT, library, central office), a teacher could submit an online form that feeds directly into a spreadsheet. Administrators can then update the spreadsheet with the status of the requests and share it with all the faculty so they can track the progress as well. Here’s one way you can use forms to track and receive school-wide requests:
- Create a new request form
Add and arrange questions by clicking the Add item button at the top of the editing page.
- From your Docs list, click the Create new button, then select Form.
- From a spreadsheet, click the Form menu and select Create a form.
- From any other doc, click the File menu and select New then Form.
Add section headers to organize your exam by clicking the Add item button at the top of the editing page and selecting Section header. Enter the section header and a description.
- Include questions to identify the requestor - name from a drop down, class/building/school.
- If the form is for multiple types of requests, create a drop down or multiple choice question to select the request type.
- Include additional information to evaluate the urgency of the request - date needed by, severity of issue, etc.
- Add “help text” to the questions to provide more context or examples of the types of answers you’re looking for.
Make the form available to students:
- You could include headers like “Request type,” “Contact information.”
Organize feedback by student, subject, class, or date.
- Email the form to your class list or individuals by selecting the Email this form button and entering in email addresses. Or select the Send form option from the Form menu in your response spreadsheet.
- Embed the form on your class site in a common “Peer review” section where students can always access. From the form, go to the More actions button and selecting Embed. Copy and paste the code into your site. From the response spreadshet, go to the Form menu and select Embed form in a webpage....
- Embed the form in a Google Site by going to your site, clicking the Insert menu and selecting Form. Pick your form from the list.
- Share the direct link to the form (you can then create a shortlink using a URL shortner to bookmark) Find the URL in your response spreadsheet by clicking the Form menu and selecting Go to live form. Copy the URL of the new window. To get to your spreadsheet from the edit form page, click the View responses button and select Spreadsheet.
Compile a list of feedback for each student
- View the response spreadsheet and select and sort columns to view feedback for the same student/class/etc.
Share feedback with student
- You can quickly filter the results for a single student if the name has been consistently entered for all the form data (one reason why you might want to consider a drop down menu for student names, so that the name is always consistent), using a combination of the filter function and the arrayformula function
- For example, if your form questions use the columns C:L and you want to filter to show just the responses corresponding to Stephanie, you could use this formula:
- Or if you were using this filter on a separate sheet, you would need to add the sheet reference:
- This formula will only return the results in the sheet that belong to Stephanie. By specifying the entire columns, even if there are new form responses, the formula will still capture the data.
- After you have filtered the feedback for the student, you can copy and paste the list of relevant feedback into a separate spreadsheet. You might consider having one spreadsheet for each student that tracks the feedback for all assignments. You could also paste the feedback into a document and share it with the student.