Influence & Persuasion: Crash Course Media Literacy #6

This video explores the difference between advertising, public relations, and propaganda.

image

Format

  • Video

Skills

  • IS.3 Evaluate Online Information

Resource (Relation)

Resource

Crash Course

Publisher

Crash Course

License Type

  • Copyright
BRIDGES > Workplace and Productivity > Workplace and Productivity Skills > WO.8 Create Spreadsheets

WO.8 Create Spreadsheets

Use online or PC-based spreadsheet software to manipulate or analyze data

In My Life

I can create a budget and track spending using a spreadsheet.

In My Work

I can create a chart or a visual display of the data in a spreadsheet.

In My Education

I can use a spreadsheet to monitor my progress toward both short and long term goals.

As a Teacher/Trainer

I can use a spreadsheet to collect and analyze student responses to surveys and forms.

Explore Learning Activities

image

Google Sheets: How to Use the Sum Function

Senior Planet

Learn to use the Sum formula for quickly adding quantities in a spreadsheet.

  • Video
  • WO.4 Choose the Appropriate Tools
  • WO.8 Create Spreadsheets
https://www.youtube.com/watch?v=O2rj8DCfYds
https://www.youtube.com/watch?v=O2rj8DCfYds
AARP
Copyright
image

Google Sheets: How to Use the Multiply Formula

Senior Planet

Learn to use the Multiply formula for working with spreadsheets in Google Sheets or Excel.

  • Video
  • WO.4 Choose the Appropriate Tools
  • WO.8 Create Spreadsheets
https://www.youtube.com/watch?v=qhVfJTwjpyE
https://www.youtube.com/watch?v=qhVfJTwjpyE
AARP
Copyright
image

Google Sheets: How to Use the CountA Function

Senior Planet

Learn to use the CountA formula for working with spreadsheets in Google Sheets or Excel.

  • Video
  • WO.4 Choose the Appropriate Tools
  • WO.8 Create Spreadsheets
https://www.youtube.com/watch?v=_y8bFRyw_90
https://www.youtube.com/watch?v=_y8bFRyw_90
AARP
Copyright
image

Creating Charts with Google Sheets (High Intermediate/Advanced)

Digital Literacy Skills Curriculum

From World Relief, a digital skills lesson designed for learners at high intermediate / advanced literacy levels.

  • Lesson Plan/Activity Guide
  • WO.8 Create Spreadsheets
  • CR.2 Understand and Use Data
https://www.skillblox.org/skillblox/O13IAO
World Relief
Copyright
image

Making a Monthly Budget (Low Intermediate)

Digital Literacy Skills Curriculum

From World Relief, a digital skills lesson designed for learners at low intermediate literacy levels.

  • Lesson Plan/Activity Guide
  • WO.8 Create Spreadsheets
https://www.skillblox.org/skillblox/DAXXB4
World Relief
Copyright
image

Calculate Percentages in Google Sheets

Applied Digital Skills

Track the cost of items needed for an activity by calculating percentages in Google Sheets.

  • Project
  • CR.2 Understand and Use Data
  • WO.8 Create Spreadsheets
https://edu.exceedlms.com/student/activity/1605965-calculate-percentages-in-google-sheets?sid=f5d49d4c-192b-43b9-a977-e86c154c63d5&sid_i=10
Google for Education
CC-BY-SA
image

Find the Mean, Median, or Mode of a Data Set

Applied Digital Skills

In "Find the Mean, Median, or Mode of a Data Set", students demonstrate statistical concepts using Google Sheets.

  • Project
  • CR.2 Understand and Use Data
  • WO.8 Create Spreadsheets
https://edu.exceedlms.com/student/activity/1605964-find-the-mean-median-or-mode-of-a-data-set?sid=462f9bd6-4331-4e8d-b112-8db53181ae72&sid_i=15
Google for Education
CC-BY-SA
image

Calculate Probability with Google Sheets

Applied Digital Skills

Calculate probability using formulas and functions in a spreadsheet.

  • Project
  • CR.2 Understand and Use Data
  • WO.8 Create Spreadsheets
https://edu.exceedlms.com/student/activity/1606777-calculate-probability-with-google-sheets?sid=f5d49d4c-192b-43b9-a977-e86c154c63d5&sid_i=11
Google for Education
CC-BY-SA
image

Understand Your Digital Footprint

Applied Digital Skills

Think about the actions you take online and create a visual picture of your digital footprint in Google Sheets.

  • Project
  • CR.2 Understand and Use Data
  • WO.8 Create Spreadsheets
  • EF.2 Search the Internet
https://edu.exceedlms.com/student/activity/1606924-understand-your-digital-footprint?sid=8f44c69d-bd00-462d-989c-2e1e4a4b51f3&sid_i=22
Google for Education
CC-BY-SA
image

Plan and Promote an Event

Applied Digital Skills

Learn how to create to-do lists and assigning tasks to others while promoting an event.

  • Project
  • CR.4 Design Digital Content
  • EF.9 Send and Receive Email
  • CO.1 Communicate Effectively
  • CR.8 Build a Website
  • WO.7 Create Documents
  • WO.8 Create Spreadsheets
  • WO.3 Manage Projects Online
https://edu.exceedlms.com/student/activity/1607169-plan-and-promote-an-event?sid=8f44c69d-bd00-462d-989c-2e1e4a4b51f3&sid_i=3
Google for Education
CC-BY-SA
image

Make Art with Google Sheets

Applied Digital Skills

Create a pixel art project using conditional formatting in a spreadsheet.

  • Project
  • CR.4 Design Digital Content
  • WO.8 Create Spreadsheets
https://edu.exceedlms.com/student/path/1606922-make-art-with-google-sheets?sid=8ed26ee6-9daf-4205-8ff4-9ff1da412d41&sid_i=0
Google for Education
CC-BY-SA
image

Create a Budget in Google Sheets

Applied Digital Skills

Learn to make good financial decisions by researching and comparing costs and spending in a spreadsheet.

  • Project
  • OL.7 Manage Money Online
  • WO.8 Create Spreadsheets
https://edu.exceedlms.com/student/activity/1607066-create-a-budget-in-google-sheets?sid=f5d49d4c-192b-43b9-a977-e86c154c63d5&sid_i=14
Google for Education
CC-BY-SA