Lesson Plan : Formulas in Spreadsheet Software
Teacher Name: | Victor Sohier |
Grade: | College/University |
Subject: | Other |
Topic: | Spreadsheet Formulas |
Content: | -Formula bar -Cell -Cell referencing -Operators -Commands |
Goals: | |
Objectives: | -For a given mathematical formula, the student would be able to implement it in varying spreadsheet software. -If the student has no knowledge of a command, they would be able to research it. |
Materials: | https://www.techonthenet.com/excel/formulas/index.php https://support.office.com/en-us/article/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb |
Introduction: | -Basic operators (+-*/^) -Basics of commands |
Development: | -Cell referencing -Formula and cell copying -Expanding to larger formulas |
Practice: | Must do: -Multiplication table -Sum of first 20 of Fibonacci Sequence If time: -Finding the golden ratio using Fibonacci sequence -Show resources |
Accommodations: | |
Checking For Understanding: | |
Closure: | -Give examples for applications -Reminder for resources -2-3 questions |
Evaluation: | |
Teacher Reflections: |
| Create New Lesson Plan | Lesson Plan Center |