Computer with internet access (per student)
Headphones (per student)
A Google account (create an account at accounts.google.com/signup)
Analyze spending, research costs, and plan for purchases using a spreadsheet.
course by Lilli /CC BY 4.0 Deed | Attribution 4.0 International
By the end of these lessons, students will be able to:
Utilize a database, such as a spreadsheet, to collect, organize, graph, and analyze data to facilitate problem-solving and decision-making
Curate information from digital sources using a variety of tools and methods to create collections of artifacts that demonstrate meaningful connections or conclusions
Apply basic formulas (add, subtract) and advanced formulas (example: using =SUMIF to calculate costs)
Differentiate between formulas with absolute and relative cell references
Each lesson’s plan is composed of four parts:
The Learning Objectives indicate what a student should be able to do at the end of that lesson.
The Teacher Notes and Instruction is an overview of each portion of the class. There is an introduction which includes opening questions, video-watching time (where students watch instructional videos and work through their projects), and a wrap-up / discussion that closes each lesson.
The Check / Outcomes section outlines what students should be working on during the allotted class time. When walking around the classroom, these are components that you should monitor to ensure that students are successful.
The Example Outcome shows images with highlighted text that indicates what each student should have completed by the end of the lesson.
By the end of this lesson, students will be able to: Research and compare products in Sheets Compare costs of different items using formulas Format columns in Sheets Sort data
Digital skills have fast become essential everyday skills. Time and time again, we have seen them enabling people to unlock new potential and be more resilient. That's why Google is committed to helping people grow their digital skills, careers, or businesses using technology.
Since 2015, Google has helped train 800,000 people across the UK, working with governments and industry experts to develop tools and training tailored to the needs of local communities. We believe that by working together we can help our communities prepare for the future, adapt to changing landscapes and build stronger digital economies.
Plan and Budget
No Review found
