Research and Organize Information about Colleges in Google Sheets

Rating
1 Rating
196 Views Updated: Friday, January 17, 2020 - 10:31am
Share with a friend
Facebook
Twitter
Pinterest
LinkedIN
email
sharethis
Research and Organize Information about Colleges in Google Sheets

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:

Videos

  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

 

Lesson Plan Resources

Activity
Curriculum
Digital Tool
Flipped Classroom
Independent Practice
Lesson Plan
Presentation
Project Based Learning
Rubric
Team-Based Learning
Video Guide
Lesson tags: 
Good for Parents
This resource is a part of the following collections: 
Digital Literacy and Computer Science
27 Lessons and Resources, 1 Collection

Reviews

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.