The structured setup of forms makes it easy for teachers to log information into a shared database that everyone can search and access. Forms can be filled out anywhere - embedded on a website, viewed in an email or published URL, or even on a mobile device - allowing teachers the convenience to log this information immediately.For example, you could create a form and response spreadsheet for school-wide student behavioural logs. Teachers could access a single form and file a structured log that is added to the spreadsheet database. Each Google Spreadsheet can store up to 200,000 cells of information. For a row with ten pieces of information (such as first name, last name, ID, year, teacher name, subject, period, type of log, log report, and notes), a single spreadsheet could store 20,000 students logs. Teachers could then open the log and search or filter for a specific student to have relevant information from all the other teachers on hand for evaluations or parent teacher conferences. School administrators would then also be able to easily analyze the log reports and track patterns.Here’s one way you can use forms to create a student log database:
- Create a new peer review 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.
Make the form available to teachers:
- Include questions for items that would make it easy to find information in a database such as student contact information, ID numbers or usernames, teacher and class information.
- Include drop-downs for the type of log reports - useful for sorting in the spreadsheet.
- Include a text type question for reporting the log, as well as a paragraph type for adding additional notes.
Organize feedback by student, subject, period, teacher, log type, or date.
- Email the form to the list of faculty (i.e. firstname.lastname@example.org) that they can star and search for in their Apps mail account.
- Embed the form on your faculty intranet site that is only accessible to teachers that are signed into Apps. On a Google Site, click the Insert menu and select Form. Pick your student log form from the list.
- Include the direct link to the form in a faculty handbook document that is shared with all faculty. 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 - useful if evaluating the activities of a single student
- View the response spreadsheet and select and sort columns to view feedback for the same student/class/etc.
- Create a separate tab that is used for teachers to filter information from the primary database, such as “Filter for a single student.”
- The easiest way to identify students would be by an ID or a username
- For example, if your log information was entered in columns C:L, where the student ID or username is in column C and you want to filter to show just the responses corresponding to student123, you could use this formula:
=FILTER(C:L,ARRAYFORMULA(C:C="student123"))or if you wanted to compare for First and last name
- 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 student123. By specifying the entire columns, even if there are new form responses, the formula will still capture the data.