Skip to main content

Research and Organize Information about Colleges in Google Sheets


Share On Facebook
Share On Twitter
Share On Pinterest
Share On LinkedIn

About This Lesson

In this Google Sheets lesson, students build a list of colleges and important criteria in Google Sheets. Then, they conduct research and use what they find to compare schools.

Getting started is easy. Go to the Applied Digital Skills website and sign up to set up your first class. Check out this guide with step-by-step instructions or go directly to the lesson through this link.

This lesson uses videos to teach critical life and technology skills:


  1. Introduction to Research and Organize Information about Colleges in Google Sheets
  2. Build Your Spreadsheet
  3. Research your Colleges
  4. Research and Organize College Information Wrap-Up

Life Skills

  • Create artifacts, or computational projects with practical, personal, and /or social intent.
  • Demonstrate confidence and self-direction by making independent choices in the selection of resources and information.
  • Employ research strategies to locate all possible sources.

Technology Skills

  • Demonstrate an understanding of the spreadsheet as a tool to record, organize, and graph information.
  • Enter/edit data in spreadsheets.
  • Identify and explain terms and concepts related to spreadsheets (cell, column, row, values, labels, chart/graph
  • Extension 1: Research and Sort Important College Deadlines
  • Extension 2: Add a New Sheet for Application Requirements
  • Extension 3: Create a Filter by Degree Type
  • Extension 4: Clarify Information by Splitting Text to Columns
  • Extension 5. Keep Track of College Applications with Data Validation
  • Extension 6: Share Your College Spreadsheet with Other

Enjoy this Google Sheets lesson?

Check out more free lesson plans and resources on Share My Lesson in the Digital Literacy and Computer Science Collection

2 Reviews
Thank you for the feedback! We fixed the link.
Applied Digital Skills
April 28, 2019
This lesson is very good, but two of the links do not work. The lesson is good for juniors and seniors who are exploring college options.
October 25, 2018