Intro to Google Sheets: Let's Make a Gradebook
In this class I will introduce spreadsheets by having learners create a gradebook for themselves. We will also use the spreadsheet to create a graph so we can talk about interpreting data
What's included
1 pre-recorded lesson
1 week
of teacher support1 year access
to the contentClass Experience
US Grade 4 - 7
Beginner Level
In this lesson we will be learning about Google Sheets. This lesson will cover the basics of Google Sheets. What spreadsheets are, how we set them up, basic terminology when discussing Google Sheets, how to set up conditional formatting, and How to create graphs from the data in our spreadsheet. This first lesson will be set up as a tutorial video style lesson. I will be showing learners everything they will need to do, and they can follow along with the step by step instructions. In this first lesson I will not be live teaching, but if learners have questions they can ask and I will respond as soon as I am able to. In the future I plan on putting together a class including this lesson along with some other lessons all focused on Google Sheets.
Learning Goals
Understand what Spreadsheets are and how we use themTo learn how to input data into a spreadsheet and organize it accordingly
Syllabus
1 Lesson
over 1 WeekLesson 1:
Getting to Know Google Sheets
Google Sheet basics, How to create a basic gradebook to keep track of test scores, How to use a basic formula, How to use conditional formatting to make our data stand out, and how to create graphs from the data in a spreadsheet 45 mins of video lessons
Other Details
Learning Needs
Through the use of video tutorials students can pause, and rewatch sections. Students can work at their own pace through the lesson
Parental Guidance
Google Account required and access to Google Sheets
Pre-Requisites
None
Joined October, 2024
Teacher expertise and credentials
21 years of teaching experience in Math and Science at the 4th and 5th grade level. Technology Coach for 15 years. STEM education teacher for the last 5 years. Google Level 1 and 2 certified teacher.Reviews
Self-Paced Class
$10
for all content1 pre-recorded lesson
1 week of teacher support
Choose your start date
1 year of access to the content
Choose your start date
Ages: 10-15
