Reflecting with Google Forms and Sheets

During the winter months, I start reflecting on the current year and the needs for the upcoming school year for the library. I notice patterns in requests from students, analyze the subject areas in the library and the types of collaborative activities.  I also note the teachers and students I do not see in the library.

How do I show this information?

Enter Google Forms and Google Sheets.

With Google Forms, create a form of your collaboration, lessons, and activities that will go into a Google Sheet, a spreadsheet. Create the form at any time during the year and start adding your activities. Once you are ready to reflect, take a look at the spreadsheet.

  • What is the most common subject or grade level that utilizes the library?
  • Are certain grade levels or subject areas missing?
  • Are students utilizing technology tools to demonstrate learning?
  • Are information literacy skills embedded into these lessons? Where are the gaps?

These findings can help enhance collaboration with classroom teachers. Draw from the list to show what students are doing in other classes and how to build on those information literacy skills.

Share findings with your administrator. Ask your administrator to help encourage other subject or grade-level areas to utilize your expertise. I had a former administrator share the reports each month with the department chairs. He was not fearful of asking questions about why a certain class wasn’t utilizing the library.

How do I begin?

Access Google Forms. Many districts have a Google Apps for Education account, so you may not need to set up an account.

Set up your form. *See resources listed below.

Things to possibly include in the form:

  • Class/Subject
  • Grade
  • Teacher
  • Collaboration (Yes or No) or Note the Level of Collaboration
  • Information Literacy Skills Covered
  • Content Skills
  • Technology Tool

Once the form is complete, keep the form link accessible on your phone and other devices to easily add information. The form connects to a spreadsheet that you can view at any time.


Sample Form – Make a copy to edit and use
Getting Started with Google Forms
Google Forms Guide

How do you share information and reflect on library usage and student learning? Comment below.

Author: Becca Munson

Becca Munson, Librarian, is a National Board Certified Teacher with over 24 years of experience in education. Becca is the Coordinator for Library Systems in the Blue Valley School District. Previously, she was school librarian at Blue Valley West High School. She opened two buildings in Blue Valley and spent some time as an Ed Tech Specialist before returning to libraries. Becca supports over 45 librarians and support staff as they work to fulfill the mission of flexible scheduling, collaboration, and literacy.

Categories: Blog Topics, Technology

Tags: , ,

2 replies

  1. What a great use of forms! I send the teachers I work with a short feedback survey that has some of the basic info (grade, subject area, topic) that you mentioned. I like how you include information literacy skills and technology use– those are very valuable pieces of data. Thanks for sharing this.

  2. Great idea! A feedback form for teachers – I love this idea for increasing collaboration and reflection.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.