Research and Organize Information about Colleges in Google Sheets

Google's Applied Digital Skills

1 Rating
113 Views Updated: Friday, February 1, 2019 - 3:59pm
Share with a friend
Students in a classroom

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
Digital Tool
Flipped Classroom
Independent Practice
Lesson Plan
Project Based Learning
Team-Based Learning
Video Guide
Lesson tags: 
Good for Parents
This resource is a part of the following collections: 
Digital Literacy and Computer Science
20 Lessons and Resources, 1 Collection


October 2018
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.
April 2019
Thank you for the feedback! We fixed the link.