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. play_circle_filled 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 Assessment
  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 an Event navigate_next
  • Activity 4 navigate_next
  • Reflection
Activity Reflection for Create a Logo
Please sign in to take this survey.
This survey is for students. Your response will not be recorded.
You have already submitted this survey. Click the Next button to move on to the next activity.
Video 1
Video 2
Video 3
Video 4
Video 5
Reflection