Google Sheets - The Basics includes 6 lessons to teach students the basic operations of Google Sheets and creating a chart. Each printable lesson includes step-by-by step directions. By the end of 6 lessons students will be able to add, subtract, multiply, divide, and create a chart. Each lesson is approximately 30 minutes for the lesson and a 5 – 10-minute introduction/demonstration. Lessons include answer keys.
Lesson 1 – Students learn to add, merge cells, copy a formula and use spellcheck.
Lesson 2 – Students will create a spreadsheet using the Sum Function.
Lesson 3 – Students edit and add data to the spreadsheet created in Lesson 2. Topics include multiplying, merging cells, using the fill handle to copy a calculation, currency formatting, applying fill color and increasing decimals.
Lesson 4 – Students will learn to subtract and sort data in a spreadsheet.
Lesson 5 – Students will learn to subtract and divide. Students will also sort, decrease decimals, and analyze data by answering a question.
Lesson 6 – Creating a Basic Chart – Students will learn how to create a basic chart, which includes a chart title, data labels, and moving the chart to its own sheet.