ISTE Nets Met by this assignment: Technology Operations and Concepts: 6A, 6B, 6D; Creativivity and Innovation: 1a, 1c, 1d; Communication and Collaboration 2a, 2b, 2d; Research and Information Fluency: 3a, 3b, 3d; Critical Thinking, Problem Solving and Decision Making, 4a, 4b, 4c.
Common Core Standards: College and Career Readiness Anchor Standards for Speaking and Listening. Presentation of Knowledge and ideas 4 and 5.
BSCSD Goals: Effective communicators, Academically skilled, Productive and versatile thinkers, Skilled information managers.
Essential Question: How do you organize, format, graph and compute information using a spreadsheet program such as Google Sheets?
Student Objectives: Using Google Sheets, students will complete skill exercises to learn how to:
- Adding Data
- Format data (general, currency, increase/decrease decimals)
- Adjust cell width
- Understand the importance of column and row labeling
- Basic Formulas, SUM, AVERAGE
- Creating a Charts
- Adding Chart titles, Horizontal and Vertical Axis Labels
- Understanding types of charts and when to use them
- Print previewing and printing
- Learn how to use Google Sheetsl to organize data and guide inquiries
Getting Started with Google Sheets
Go to the GFC Website page, Getting Started with Google Sheets and read each of the page to familiarize yourself with Google Sheets. Complete the Activity worksheet. To learn more about formula work, go to Working with Simple Formulas and read the page.
Activity #1: Google Sheets Partner Check- We will do this together.
Labs to complete on your own- Print this worksheet out to guide you through the labs you need to do. A scorecard is included to help you check the lab before you share it or print it.
Activity #2: My Digital Media Use in a 24 Hour Period
Activity #3: My Birthday Weather
Activity #4: My Careers
Activity #5: Shopping List
Challenge Activity #6: How to Calculate Your Final Average
Done Early??? Try a challenge spreadsheet lab!
Task #1- Roller Coaster Heights
Task #2 -How Old are you on Neptune?
Task #3 Judy's Allowance
Task #4 Birthday Budget
Task #5- Bake Sale
Task #9- Deserts
Task #10- Price Comparison between decades
Task #11- Winter Olympics Question
How do I study for the Google Sheets Test?? Start by playing this review game! Then click on the PowerPoint review in the related link area. Use this like a flash card review. If you don't have PowerPoint. Open the PDF version of the file.