AdultEdTech

Spreadsheet Lesson Framework

The whole concept of data science is that the software becomes the expert, and you, as the average user, are able to understand what's going on.

—Marc Benioff
  • Home
  • About
  • COVA
  • Digital Learning & Leading
    • Learning Manifesto
    • Creating Significant Learning Environments >
      • Learning Philosophy
    • Instructional Design in Online Learning >
      • Course Planning
      • Course Structure
      • Leadership Perspective
    • Digital Learning in Local & Global Contexts >
      • Lessons Learned
      • Research
      • A Bigger Strategy
    • Assessing Digital Learning & Instruction >
      • Action Research Outline
      • Literature Review
      • Action Research Plan
    • Digital Resources >
      • Media Pitch
    • Digital Citizenship >
      • Nine Elements
      • Resource Library
  • Educational Technology
    • AECT Standards
    • Emerging Trends >
      • Blended Learning >
        • Background & Theory
        • Practice
        • Resources
    • Integrating Technology >
      • Integrating Technology TOC
      • Mission & Vision
      • Relative Advantage
      • Instructional Software Lesson Plan
      • Software Support Tools
      • Interactive Presentation
      • Spreadsheet Lesson Framework
      • Shared Google Doc Lesson Framework
      • Video Integration >
        • Video Library
        • Video Enhanced Lesson Plan
      • Internet-Enriched Lesson
      • Social Networking and Community Building Assignment
      • Technology in the Content Areas >
        • English Language Development
        • Math/Science
        • Social Studies
      • Adaptive & Assistive Technology
      • Resources
    • Project-Based Learning >
      • PBL Checklist
      • Sample Project: Making The Grade >
        • Welcome
        • Project Overview
        • Project Map
        • Instructor Resources
    • WebQuest >
      • Introduction
      • Task
      • Process
      • Evaluation
      • Conclusion
      • Teacher Page
  • Learning Resources
    • #EdTech Tools
    • Tutorials >
      • Flipgrid
      • Google Classroom
      • Padlet
      • Pear Deck >
        • Download & Install
  • Professional Projects
    • Archie: The New Riverdale
    • Attack on Titan
    • Black Panther: Soul of a Machine
    • Clive Barker's Next Testament
    • Grimm's >
      • Briar Rose
      • Rapunzel
      • Snow White
    • Hellboy: In Hell
    • Injustice: gods among us
    • Overwatch
    • Planet of the Apes
    • Starcraft
    • The Last Ship
    • Transformers
    • Unity
    • World of warcraft
  • Contact

Lesson Topic

Digital literacy is a foundational concept that is incorporated across curricula so that we can better prepare our learners for the competitive 21st century world of work. Lessons start at the very lowest level—similar to how traditional zero-level literacy curriculum might—so that learners who may have never even touched a computer can get familiar with the parts and vocabulary. As learners progress through the curriculum, they are able to take assessments along the way to demonstrate their understanding and skills—plus they earn digital badges and certificates! For more advanced learners, we use project-based opportunities to facilitate deeper understanding of core tools such as word processing, spreadsheets, and website building.

​This lesson will focus on the basics of Google Sheets in order to build, organize, and format a spreadsheet of sales data. This exercise is not only representative of an authentic, real-life workplace situation, it also works to prepare for the G Suite Certification exam. 

Goals for Lesson

By the end of this lesson, students should be able to:
Achieve the following objectives: 
  • Edit and organize a spreadsheet to track sales data for a community fundraiser. 
Answer the following essential questions:
  • How can I edit raw data to be more readable and useful to me?
  • How do I use a spreadsheet to track data?
Internalize the following enduring understandings:
  • A spreadsheet helps you collect, organize, and store data.
  • Raw data can be better organized with formatting, sorting, and data validation.

Data

Raw data will be provided in a spreadsheet which each student will copy. During the course of the lesson each student will insert new rows, columns, and cell data. See below for a detailed example.

Sample Worksheet


Creative Commons License
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.
Site powered by Weebly. Managed by MacHighway
  • Home
  • About
  • COVA
  • Digital Learning & Leading
    • Learning Manifesto
    • Creating Significant Learning Environments >
      • Learning Philosophy
    • Instructional Design in Online Learning >
      • Course Planning
      • Course Structure
      • Leadership Perspective
    • Digital Learning in Local & Global Contexts >
      • Lessons Learned
      • Research
      • A Bigger Strategy
    • Assessing Digital Learning & Instruction >
      • Action Research Outline
      • Literature Review
      • Action Research Plan
    • Digital Resources >
      • Media Pitch
    • Digital Citizenship >
      • Nine Elements
      • Resource Library
  • Educational Technology
    • AECT Standards
    • Emerging Trends >
      • Blended Learning >
        • Background & Theory
        • Practice
        • Resources
    • Integrating Technology >
      • Integrating Technology TOC
      • Mission & Vision
      • Relative Advantage
      • Instructional Software Lesson Plan
      • Software Support Tools
      • Interactive Presentation
      • Spreadsheet Lesson Framework
      • Shared Google Doc Lesson Framework
      • Video Integration >
        • Video Library
        • Video Enhanced Lesson Plan
      • Internet-Enriched Lesson
      • Social Networking and Community Building Assignment
      • Technology in the Content Areas >
        • English Language Development
        • Math/Science
        • Social Studies
      • Adaptive & Assistive Technology
      • Resources
    • Project-Based Learning >
      • PBL Checklist
      • Sample Project: Making The Grade >
        • Welcome
        • Project Overview
        • Project Map
        • Instructor Resources
    • WebQuest >
      • Introduction
      • Task
      • Process
      • Evaluation
      • Conclusion
      • Teacher Page
  • Learning Resources
    • #EdTech Tools
    • Tutorials >
      • Flipgrid
      • Google Classroom
      • Padlet
      • Pear Deck >
        • Download & Install
  • Professional Projects
    • Archie: The New Riverdale
    • Attack on Titan
    • Black Panther: Soul of a Machine
    • Clive Barker's Next Testament
    • Grimm's >
      • Briar Rose
      • Rapunzel
      • Snow White
    • Hellboy: In Hell
    • Injustice: gods among us
    • Overwatch
    • Planet of the Apes
    • Starcraft
    • The Last Ship
    • Transformers
    • Unity
    • World of warcraft
  • Contact