Unit 1: Introduction to Formulas
Navigation Links:
Unit 1:Introduction to Formulas
Performance Objectives
By the end of this unit students will be able to:
- Navigate Google Sheets platform
- Execute basic functions for custom formulas (SUM, COUNT, LOOKUP, Shortcuts, text search functions)
- Create custom spreadsheet for classroom use
Directions
- Please navigate through the mini lesson
- Setting up your Sheet
- Simple Formulas
- Formatting your Sheet
- Examples for Classroom Use
- Complete (2) learning activities
- Excel Exercises
- Create Behavior Chart
Mini-Lesson
1. Setting up your Sheet
Setting up your Google Sheet is the first step to starting! Please watch the video below for a refresher:
- Activity: Watch
This video has lessons broken down by category. Please watch the following categories:
- Interface [2:10]
- Entering and Editing Data [8:37]
- Performing Simple Calculations [17:03]
Other tips to remember:
- Row vs. Column
2. Simple Formulas
Please review this lesson. Click here.
Key elements from lesson:
- All formulas must start with an (=) sign!!
- Standard operators are used for mathematical formulas (+, -, /, *)
- Cell references can be used for automatic formulas
- Standard operators can be used with cell references too! (A2/B3)
- Creating formulas by hand or point and click method
- Remember to Double Check your formulas! Google Sheets will not always tell you
3. Formatting your Sheet
- Part 1: Basic Formatting
- Part 2: Please feel free to skim through this video, but pay close attention at 5 minutes to watch the conditional formatting lesson. This will be helpful for the next unit.
4. Examples for Classroom Use
- Behavior Chart
- Randomized partners
- Gradebook
Review page 13-15 for more ideas! Click here.
- Looking for automatic rubric templates?
- Follow this link to watch the video.
- Click here to download the templates.
Learning Activities
1. Complete Excel Exercises
- https://excelexercises.com/lessons.html
- Follow the link above to start practice
- Complete as many lessons as time permits, important lessons are SUM, COUNT, Logical, Lookup, and Statistical functions
2. Create a behavior chart utilizing at least (3) of the highlighted functions from this unit.
- Share the link to your document in this Sheet: Google Sheet
Next Unit 2: Unit 2
Extended Resources
Become the Excel Master of Your Office. Excel Exercises Practice. (n.d.). https://excelexercises.com/lessons.html.
Cut Your Grading Time in Half with Automated Rubrics. (2020). YouTube. https://youtu.be/EyYktDQ7BNE.
Google Sheets Beginner Tutorial. (2020). YouTube. https://youtu.be/_UWPaPer1MY.
Google Sheets: Creating Simple Formulas. GCFGlobal.org. (n.d.). https://edu.gcfglobal.org/en/googlespreadsheets/creating-simple-formulas/1/.
Google Sheets: Getting Started. (2018). YouTube. https://youtu.be/HLp6nbp8VIc.
How to Use the Formatting Tools in Google Sheets: A Teacher's Guide #1: Interactive Tutorial. (2019). YouTube. https://youtu.be/KHALEdkN6lM.
More Essential Tips & Tools for Google Sheets | A Teacher's Guide #2 | INTERACTIVE TUTORIAL. (2019). YouTube. https://youtu.be/7_PgxrR6vk4.