A small charter school was looking for a way to track student progress and share the outcomes with students and parents. The following criteria were important.

• Quick and easy for teachers to add data.
• Easy for students to see their progress
• Administrator needs a dashboard to see all aggregated data
• Use free GSuite tools to accomplish the outcomes

For this solution we used forms, sheets and drive.

Watch the video below to see how we did this. If you are interested you can make copies here:

• Make a copy of the form
• Make a copy of this student sheet

There is a bit of setup time to make copies for each teacher, or student, but once the setup is finished, the teacher simply fills out the form and the student and parent can check the report at any time.

1. In your Student Progress Monitoring google drive folder, create a folder named setup. In this folder create a folder named sheets.
2. Make a copy of this sheet and save it in this sheets folder
3. Follow the steps to create the new form for each teacher. Initially save all these new teacher forms in the folder you created named setup.
4. After you create the form and name it for the teacher, create the sheet attached to this form, rename 'Form Responses 1" to 'data'.
5. Move all these new sheets to the sheets folder when you are finished creating them all.
6. So all the Responses sheets will now be in the sheets folder. We are doing this because the script will copy the summary tab to all the sheets in this folder saving you some time in setup.
7. Once this is finished all the response sheets will have the correctly formatted summary tab.
8. You can now move all these sheets back into the setup folder.
9. Create a folder for each teacher, and move the form and response sheet to each teacher's folder. Share this folder with each teacher.
10. Add the first student template to each teacher folder and setup the correct URL for the import range function.
11. Teachers can then finish by creating a sheet for each student and sharing it appropriately.