How to Use Spreadsheets
Quick View
HW: Finish More Exercises (on Google Classroom).
CW: Completed Spreadsheet Practice (on Google Classroom).
EQ: How do you create a table and chart with a trendline?
Resources
Lesson Outline
5min Practice using Autofill.
5min< Practice finding sums and averages.
5min Practiceentering formulas..
5min< Practice creating charts and adding trendlines.
5min Students start on More Exercises assignment (via Google Classroom).
5min Put away Chromebooks. Clean up. Wrap up.
AIM: Students will practice using spreadsheets and become familiar with basic skills including creating tables and charts.
How to Use Spreadsheets
Quick View
-
HW: Finish More Exercises (on Google Classroom).
-
CW: Completed Spreadsheet Practice (on Google Classroom).
-
DN: Join the science Google Classroom (see instructor for code).
-
EQ: How do you create a table and chart with a trendline?
Resources
[youtube=://www.youtube.com/watch?v=iW_VkG4pNhU&w=854&h=480]
Lesson Outline
5min Students join Google Classroom and open Spreadsheet Practice.
5min Practice using Autofill.
5min< Practice finding sums and averages.
5min Practiceentering formulas..
5min< Practice creating charts and adding trendlines.
5min Students start on More Exercises assignment (via Google Classroom).
5min Put away Chromebooks. Clean up. Wrap up.
AIM: Students will practice using spreadsheets and become familiar with basic skills including creating tables and charts.
More Practice Spreadsheets
Quick View
-
HW: Work on Video Project (see previous post).
-
CW: Complete More Practice Spreadsheet (Turn in via Google Classroom).
-
DN: Clear tables.
-
EQ: How do you create a table and chart with a trendline?
Resources
[youtube=://www.youtube.com/watch?v=iW_VkG4pNhU&w=854&h=480][youtube=://www.youtube.com/watch?v=5_tjFeFBmBk&w=854&h=480]
Lesson Outline
5min Teacher outlines how to fill out the bubble sheet. Students fill out bubble sheet in preparation for their quiz.
10min Students complete quiz.
5min Students take their assigned Chromebook and log on to Google Classroom.
10-15min Students make a copy of the More Practice Spreadsheet and follow the instructional videos to complete the assignment. Teacher addresses technical questions.
5min All assignments are turned in via Google Classroom.
5min Put away Chromebooks. Clean up. Wrap up.
AIM: Students will practice using spreadsheets and become familiar with basic skills including creating tables and charts.
Working with Spreadsheets
Quick View
-
HW: [1] Work on Video Project (see previous post). [2] Study for quiz.
-
CW: Completed practice exercises (not collected).
-
DN: Take your assigned Chromebook and log into your account.
-
EQ: How do you create a table and chart with a trendline?
Resources
[youtube=://www.youtube.com/watch?v=iW_VkG4pNhU&w=854&h=480]
Lesson Outline
5min Students complete the Do Now and log into their assigned Chromebook.
5min> Students join Google Classroom and open Google Sheets.
5min Practice using Autofill.
5min< Practice finding sums and averages.
5min Practice formatting tables.
5min< Practice creating charts and adding trendlines.
5min< Practice entering formulas.
5min Put away Chromebooks. Clean up. Wrap up.
AIM: Students will practice using spreadsheets and become familiar with basic skills including creating tables and charts.