Google has a whole host of online document creation tools that are browser based and free to use.  You may already be familiar with Google docs for word processing, and if so, you probably know that it can be a powerful tool for collaboration and cloud-based document creation. This post is going to look at a less well known, but equally powerful set of Google tools – Google forms and spreadsheets let you setup powerful tools for collecting, organizing and visualizing data.

These tools are accessible as mobile apps for android and iOS, but this post will focus on the browser-based computer versions.

If you don’t already have a Google account, you’ll need to create one and sign-in.  One nice thing about the Google ecosystem is that one login allows you access to all the Google tools, from Gmail to Youtube. It’s also important to realize that Google derives profits by gathering and tracking information about how you use all these different services and allowing different companies to target you with tailored advertisements. I’m not saying this is necessarily a good or bad thing, but it is something that I believe is important to be aware of.

Once you’re logged into your google account, you’ll want to head over to and follow along with the video below!

Using Google Forms and Spreadsheets 22 December,2015Gabriel Peters-Lazaro


Gabriel Peters-Lazaro

Gabriel Peters-Lazaro researches, designs and produces digital media for innovative learning. He is the media design lead and an instructor in the Media Arts + Practice Division of the School of Cinematic Arts at the University of Southern California. He is a member of the MacArthur Foundation’s Media Activism and Participatory Politics (MAPP) project and is currently working to develop participatory media resources and curricula to support new forms of civic education and engagement for young people. In 2009, he helped create The Junior AV Club, an ongoing project that explores mindful media making and sharing as powerful practices of early childhood learning. As instructor of IML 500 – Digital Media Tools and Tactics, he helps graduate students from across the University harness the powers of video and new media as research tools to support their scholarly pursuits. He received his B.A. in Film Studies from UC Berkeley, completed his M.F.A in Film Directing and Production at UCLA and is a Ph.D. candidate in Media Arts + Practice. He is also an avid surfer.

Sponsored by

Become a KQED sponsor