Skip to content
navigate_before Back to Units
If-Then Adventure Stories
Lesson Plans

Students create an interactive, If/Then Adventure Story in Google Slides.

Activity 1: Introduction to Applied Digital Skills
  1. extension Google Apps Overview
  2. assessment Google Apps Pre-Survey
Activity 2: Brainstorm Story Ideas
  1. play_circle_filled If-Then Adventure Stories Introduction
  2. play_circle_filled Introduction to Group Decision Making
  3. play_circle_filled Brainstorm Story Elements
  4. play_circle_filled Select Story Elements
  5. assessment Wrap Up
Activity 3: Create an If/Then Adventure
  1. play_circle_filled Introduction to If/Then Adventure Stories
  2. play_circle_filled Set Up Your First Slides
  3. play_circle_filled Create Choices and Links
  4. play_circle_filled Connect and Create
  5. assessment Reflection
Activity 4: Wrap Up
  1. play_circle_filled Unit Wrap
  2. assessment If-Then Adventure Stories Reflection
  3. extension If-Then Adventure Stories Extensions
Research and Develop a Topic
Lesson Plans

Students conduct research while learning about source credibility.

Activity 1: Explore a Topic with Research and Collaboration
  1. play_circle_filled Unit Introduction
  2. play_circle_filled Log In and Create a Document
  3. play_circle_filled Choose a Topic to Explore
  4. play_circle_filled Find Information with Advanced Search
  5. play_circle_filled Share and Work Together
  6. play_circle_filled Data Is Everywhere
  7. assessment Reflection
Activity 2: Test for Credibility
  1. play_circle_filled Don’t Get Tricked by Online Content
  2. play_circle_filled Make a False Claim
  3. play_circle_filled Share a Fake Article
  4. play_circle_filled Assess a Source for Credibility
  5. play_circle_filled Trust and Deceit on the Internet
  6. assessment Reflection
Activity 3: Code Welcome Screen
  1. play_circle_filled Code a Pop-Up Window Using Events
  2. play_circle_filled Explore the Script Editor
  3. play_circle_filled Welcome to My Document
  4. play_circle_filled Add Visual Appeal to Your Popup
  5. play_circle_filled Show an HTML Formatted Message
  6. play_circle_filled Make the Pop-Up Open Automatically
  7. play_circle_filled Wrap Up
  8. assessment Reflection
Technology, Ethics, and Security
Lesson Plans

Activity 1: Technology, Ethics, and Security
  1. play_circle_filled Explore Create Communicate Introduction
  2. play_circle_filled Introduction to the Topics
  3. play_circle_filled Explore Technology, Ethics, and Security
  4. assessment Technology, Ethics, and Security Reflection
Plan an Event
Lesson Plans

Students choose, plan, and organize an event.

Activity 1: Select and Research an Event
  1. play_circle_filled Plan an Event: Unit Introduction
  2. play_circle_filled Select and Research an Event
  3. play_circle_filled Event Questions and Research
  4. play_circle_filled Give and Receive Feedback
  5. play_circle_filled Wrap Up Event Selection
  6. assessment Activity Reflection for Select and Research an Event
Activity 2: Plan Tasks for Your Event
  1. play_circle_filled Introduction to Spreadsheets
  2. play_circle_filled Understand Spreadsheet Vocabulary
  3. play_circle_filled Add Items to Your Spreadsheet
  4. play_circle_filled Add Columns for Task Owners
  5. play_circle_filled Complete Task List and Get Feedback
  6. play_circle_filled Wrap Up To Do List
  7. assessment Activity Reflection for Plan Tasks for you Event
Activity 3: Code an Email Message
  1. play_circle_filled Introduction to Email Script
  2. play_circle_filled Conditional Formatting in Google Sheets
  3. play_circle_filled Get the Display Value
  4. play_circle_filled Log Only If the Value is Empty
  5. play_circle_filled Fix the Bug with an Embedded "If"
  6. play_circle_filled Send the Email
  7. play_circle_filled Add a Trigger to Run the Code
  8. play_circle_filled Email Code Wrap Up
  9. assessment Activity Reflection for Code an Email Message
Activity 4: Create a Logo
  1. play_circle_filled Introduction to Logos
  2. play_circle_filled Add and Edit Images
  3. play_circle_filled Add and Format Text
  4. play_circle_filled Advanced Options in Google Drawings
  5. play_circle_filled Logo Wrap Up
  6. assessment Activity Reflection for Create a Logo
Activity 5: Build a Flyer to Advertise
  1. play_circle_filled Introduction to Flyers
  2. play_circle_filled Text and Page Setup
  3. play_circle_filled Download and Insert an Image
  4. play_circle_filled Publish and Share
  5. play_circle_filled Flyer Wrap Up
  6. assessment Activity Reflection for Build a Flyer to Advertise
Activity 6: Share Your Event Digitally
  1. play_circle_filled Introduction to Google Sites
  2. play_circle_filled Add and Resize Logo
  3. play_circle_filled Add Text, Change the Theme, and Preview your Site
  4. play_circle_filled Add a Page with a Map
  5. play_circle_filled Try Something New!
  6. play_circle_filled Publish Your Site and Get Feedback
  7. play_circle_filled Website Wrap Up
  8. assessment Activity Reflection for Share Your Event Digitally
Activity 7: Unit Wrap Up
  1. play_circle_filled Plan an Event Wrap Up
  2. assessment Plan an Event Reflection
  3. extension Plan an Event Extensions
Guide to an Area
Lesson Plans

Students use structured data to create an interactive guide to an area in a spreadsheet.

Activity 1: Create an Area Guide
  1. assessment Organize Data to Create an Area Guide
  2. play_circle_filled Why Structured Data?
  3. play_circle_filled Choose an Area
  4. play_circle_filled Add Column Headings
  5. play_circle_filled Add Three Places to Visit
  6. play_circle_filled Include More Places to Explore
  7. play_circle_filled Reusing Data in Multiple Ways
  8. assessment Activity Reflection for Why Structured Data
Activity 2: Add Filters and Custom Rating Scales
  1. play_circle_filled Introduction to Sortable Data
  2. play_circle_filled Make a Rating Scale
  3. play_circle_filled Rate Locations with Data Validation
  4. play_circle_filled Sort and Filter Your Data
  5. play_circle_filled The Power of Sortable Data
  6. assessment Activity Reflection for Sortable Data
Activity 4: Make a Custom Map
  1. play_circle_filled Reuse Your Work to Make a Map
  2. play_circle_filled Create Your Map
  3. play_circle_filled Customization Options in My Maps
  4. play_circle_filled Same Data, Different Users
  5. assessment Activity Reflection on Reuse Your Work
Technology's Role in Current Events

Activity 1: Technology's Role in Current Events
  1. play_circle_filled Explore Create Communicate Introduction
  2. play_circle_filled Introduction to the Topics
  3. play_circle_filled Explore Technology's Role in Current Events
  4. assessment Technology's Role in Current Events Reflection
Plan and Budget
Lesson Plans

Research and collect data about a long-term, contractual purchase, like a cell phone and data plan.

Activity 1: Make a Long-Term Spending Decision
  1. play_circle_filled Budget to Make Good Financial Decisions
  2. play_circle_filled Long-Term Spending Decisions
  3. play_circle_filled Research and Collect Data
  4. play_circle_filled Research Costs
  5. play_circle_filled Add Rows and Duplicate Formulas
  6. play_circle_filled Use Data to Inform a Decision
  7. play_circle_filled Using Formulas to Inform Decisions
  8. assessment 5.1 Activity Reflection
Activity 6: Unit Wrap Up
  1. play_circle_filled Budgets: Life Has Many Financial Decisions
  2. assessment Plan and Budget Reflection
Create an Editing Tool with Programming

Students create an "Auto Editor" tool that finds and highlights overused words in a piece of writing using Google Docs.

Activity 1: Identify Programming Concepts in Everyday Life
  1. play_circle_filled Using Programming to Automate Tasks
  2. play_circle_filled Six Programming Concepts
  3. play_circle_filled Brainstorm Two Lists of Items
  4. play_circle_filled Apply Programming Concepts to Items
  5. play_circle_filled Share Presentations
  6. play_circle_filled Programming in the World Around You
  7. assessment Identify Programming Concepts Activity Reflection
Activity 2: Use a Loop to Find a Word
  1. play_circle_filled Introduction to Auto Editor
  2. play_circle_filled Find One Error
  3. play_circle_filled Highlight Overused Word in Color
  4. play_circle_filled Find All Occurrences of One Word
  5. play_circle_filled Make a Function to Find More Words
  6. play_circle_filled Apps Script is Javascript
  7. assessment Use a Loop Activity Reflection
Activity 3: Search for Multiple Words
  1. play_circle_filled Automate Tedious Tasks with Code
  2. play_circle_filled Make an Array
  3. play_circle_filled Use a "For Each" Loop
  4. play_circle_filled Customize Your Auto Editor
  5. play_circle_filled The Language of Programming
  6. assessment Search for Multiple Words Activity Reflection
Activity 4: Find and Reuse Code for Your Program
  1. play_circle_filled The Coding Community
  2. play_circle_filled Create Different Highlight Colors
  3. play_circle_filled Precision in Programming
  4. play_circle_filled Coding Alone and Together
Technology at Work

Activity 1: Technology at Work
  1. play_circle_filled Explore Create Communicate Introduction
  2. play_circle_filled Introduction to the Topics
  3. play_circle_filled Explore Technology at Work
  4. assessment Technology at Work Reflection
Pick the Next Box Office Hit

Students analyze movie data to formulate a hypothesis based on trends to pick the next box office hit.

Activity 1: Review Movie Ideas
  1. play_circle_filled Pick the Next Box Office Hit Intro
  2. play_circle_filled Review Movie Ideas
  3. play_circle_filled Form Hypotheses about Box Office Hits
  4. play_circle_filled Narrow Down your Ideas List
  5. play_circle_filled Wrap Up
  6. assessment Activity Reflection
Activity 2: Explore and Visualize Movie Data
  1. play_circle_filled Visualize the Data
  2. play_circle_filled Explore the Data for Recent Movies
  3. play_circle_filled Visualize Movie Budget
  4. play_circle_filled Visualize Box Office Revenues
  5. play_circle_filled Visualize Data Relationships
  6. play_circle_filled Wrap Up
  7. assessment Activity Reflection
Activity 4: Select a Movie to Produce
  1. play_circle_filled Make a Data-based Decision
  2. play_circle_filled Select One Movie to Greenlight
  3. play_circle_filled Identify Data Patterns with a VLOOKUP Formula
  4. play_circle_filled Support Your Hypotheses with Data
  5. play_circle_filled Wrap Up
  6. assessment Activity Reflection
Activity 5: Market your Movie
  1. play_circle_filled Use Data to Design
  2. play_circle_filled Design a Movie Poster
  3. play_circle_filled Give Feedback about Each Poster
  4. play_circle_filled Wrap Up
  5. assessment Activity Reflection
Activity 6: Build a Website to A|B Test Your Posters
  1. play_circle_filled Build a Website for A|B Testing
  2. play_circle_filled Build the Render Function - Part 1
  3. play_circle_filled Build the Render Function - Part 2
  4. play_circle_filled Build the Config Function
  5. play_circle_filled Build the Vote Function
  6. play_circle_filled Publish your Website
  7. play_circle_filled Analyze the Results of your A|B Test
  8. play_circle_filled Wrap Up
  9. assessment Activity Reflection
Activity 7: Pitch your Movie
  1. play_circle_filled Examine the Data
  2. play_circle_filled Polish Your Pitch Proposal
  3. play_circle_filled Wrap Up
  4. assessment Activity Reflection
Activity 8: Unit Wrap Up
  1. play_circle_filled Unit Wrap Up
  2. assessment Pick the Next Box Office Hit Reflection
  3. play_circle_filled Unit Extensions
Equal Access to Technology

Activity 1: Equal Access to Technology
  1. play_circle_filled Explore Create Communicate Introduction
  2. play_circle_filled Introduction to the Topics
  3. play_circle_filled Explore Equal Access to Technology
  4. assessment Equal Access to Technology Reflection
Plan an Event – College and Continuing Education
Lesson Plans

Activity 1: Course Introduction
  1. assessment Course Introduction
  2. play_circle_filled Using Course Materials
Activity 2: Select and Research an Event
  1. play_circle_filled Choose an Event
  2. play_circle_filled Research Your Event
  3. play_circle_filled Give and Receive Feedback
  4. play_circle_filled Organize Your Event Plan
  5. assessment Wrap Up Event Selection
Activity 3: Plan with a Spreadsheet
  1. play_circle_filled Plan with a Spreadsheet
  2. play_circle_filled Understand Spreadsheet Terms
  3. play_circle_filled Add Items to Your Spreadsheet
  4. play_circle_filled Add Columns for Task Owners
  5. play_circle_filled Complete To-Do List and Get Feedback
  6. assessment Wrap Up To-Do List
Activity 4: Communicate with Gmail and Calendar
  1. play_circle_filled Introduction to Event Communication
  2. play_circle_filled Create a Shared Calendar
  3. play_circle_filled Schedule Meetings and Events
  4. play_circle_filled Add an Event Email Signature
  5. play_circle_filled Email Your Team
  6. assessment Wrap Up Event Communication
Activity 5: Create a Logo
  1. play_circle_filled Introduction to Logos
  2. play_circle_filled Add and Edit Images
  3. play_circle_filled Add and Format Text
  4. play_circle_filled Use Advanced Options in Google Drawings
  5. assessment Logo Wrap Up
Activity 6: Create a Flyer to Advertise
  1. play_circle_filled Introduction to Flyers
  2. play_circle_filled Text and Page Setup
  3. play_circle_filled Download and Insert an Image
  4. play_circle_filled Exchange Feedback about Your Flyer
  5. play_circle_filled Publish and Share
  6. assessment Flyer Wrap Up
Activity 7: Create a Website
  1. play_circle_filled Introduction to Google Sites
  2. play_circle_filled Add and Resize Logo
  3. play_circle_filled Add Text, Change the Theme, and Preview Your Site
  4. play_circle_filled Add a Page with a Map
  5. play_circle_filled Publish Your Site and Get Feedback
  6. assessment Plan an Event Wrap Up
Plan and Budget – College and Continuing Education

Activity 1: Make a Long-Term Spending Decision
  1. play_circle_filled Budget to Make Good Financial Decisions
  2. play_circle_filled Long-Term Spending Decisions
  3. play_circle_filled Review Spreadsheet Terms
  4. play_circle_filled Research and Collect Data
  5. play_circle_filled Research Costs
  6. play_circle_filled Add Rows and Duplicate Formulas
  7. play_circle_filled Use Data to Inform a Decision
  8. play_circle_filled Using Formulas to Inform Decisions
  9. assessment CCE Plan and Budget Activity 1 Reflection
Activity 5: Plan for a Vacation
  1. play_circle_filled Plan a Vacation
  2. play_circle_filled Set Up Your Spreadsheet and Start Your Research
  3. extension Research Your Vacation
  4. play_circle_filled Vacation Wrap Up
  5. assessment CCE Plan and Budget Activity 5 Reflection
Activity 6: CCE Plan and Budget Unit Wrap Up
  1. play_circle_filled Budgets
  2. assessment CCE Plan and Budget Unit Reflection

Extension Library

Choose an Extension
play_circle_filled
Add a YouTube video to your Document
Embed a YouTube video of your choice into your document!
arrow_forward
play_circle_filled
Transitions Add Visual Interest
Add transitions to your presentation to create visual interest in your presentation.
arrow_forward
play_circle_filled
Exploring Google Apps and Chrome Extensions
Apps and Extensions enhance the things you do online. You can find and install free games, utilities, and educational tools.
arrow_forward
play_circle_filled
Transportation
Watch this video for tips on transportation options for your Spring Break trip.
arrow_forward
play_circle_filled
Androidify Yourself
Add some more personality to your Google account, text messages, and chats by using the “Androidify” app to create your own android character!
arrow_forward
play_circle_filled
Annotating Images with Google Drawings
Use the Google Draw app to annotate images you use.
arrow_forward
play_circle_filled
Wrapping Text Around Images
Format your documents with images and text intermingled.
arrow_forward
play_circle_filled
Lodging/Accommodations
Watch this video for tips on finding a place to stay on your Spring Break trip.
arrow_forward
play_circle_filled
Translate with Google Sheets
Automatically translate a list of words using the Google Translate formula in Sheets.
arrow_forward
play_circle_filled
Make an Image “Clickable”
Turn the images in your presentation into clickable buttons!
arrow_forward
play_circle_filled
Lodging / Accommodations
Watch this video for tips on finding a place to stay on your vacation.
arrow_forward
play_circle_filled
Using a Master Slide
Use a "master slide" to add interesting effects to your entire presentation.
arrow_forward
play_circle_filled
Design a Custom Form
Build a form to gather information from others by adding unique questions and answers.
arrow_forward
play_circle_filled
Food
Watch this video for tips on finding places to eat on your vacation.
arrow_forward
play_circle_filled
Animate a Title Slide
Animate titles and other content in your presentation.
arrow_forward
play_circle_filled
Attractions and Souvenirs
Use this video to help budget for things to do and souvenirs to buy on your vacation.
arrow_forward
play_circle_filled
Share a Form through Social Media
Crowd source your ideas to get feedback using Google Forms.
arrow_forward
play_circle_filled
Add images to a spreadsheet
Create a column of images in your spreadsheet using only the image URL and a few simple parameters.
arrow_forward
play_circle_filled
Use Your Voice to Type
Use your voice to type in Gmail or Docs. Or, Voice Search on a phone, tablet, or watch; it speaks the answer back.
arrow_forward
play_circle_filled
Review of Formulas and Visuals
Watch this video to review how to use formulas and add visuals to your budget spreadsheet.
arrow_forward
play_circle_filled
Add More Fonts
Find new fonts and add them to your doc to give it more pizazz.
arrow_forward
play_circle_filled
Utilize Spelling Preferences and Personal Dictionary
Explore features to fix commonly misspelled words, and get Docs to recognize specific names and places.
arrow_forward
play_circle_filled
Preparing for Your Presentation
Explore features in Slides like Speaker Notes and Presenter mode as well as how to prepare and deliver your material.
arrow_forward
play_circle_filled
Organize Images in a table
Add lines, set background color, change alignment and add space to cells using table properties.
arrow_forward
play_circle_filled
Interland Game
Play your way to Internet Awesome with Interland, a new online game. Interland is a magical place brimming with both awesome and blahsome surprises. In these 4 lands, you'll embark on a quest to deny hackers, sink phishers, one-up cyberbullies, outsmart oversharers and become a fearless explorer of the online world.
arrow_forward