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
—Marc Benioff
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.
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:
Achieve the following objectives:
- Edit and organize a spreadsheet to track sales data for a community fundraiser.
- How can I edit raw data to be more readable and useful to me?
- How do I use a spreadsheet to track data?
- 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
This work is licensed under a Creative Commons Attribution-NonCommercial-NoDerivatives 4.0 International License.