Lesson Plan : Conditional Formatting
Teacher Name: | Oleg Vovnenko |
Grade: | College/University |
Subject: | Science |
Topic: | Conditional Formatting and Using Format Painter in MS Excel |
Content: | Conditional Formatting; Format Painter; Excel; Visualization; Readability; Data Presentation |
Goals: | To teach the students how to make easier to read and understand data by using Conditional Formatting and the Format Painter tool in MS Excel |
Objectives: | The student will be able to visualize given Excel data by using Conditional Formatting The student will be able to manage Conditional Formatting rules The student will be able to copy formatting of the range of cells and apply the formatting to another range of cells |
Materials: | Fall Semester Grades.xlsx CBT video Classroom Projector |
Introduction: | Why data formatting such important? |
Development: | Describe the main purpose of conditional formatting and its application; Demonstrate the difference formatted and non-formatted data |
Practice: | Using real excel data file Fall Semester Grades.xlsx and various scenarios (rules) create new formatting Applying the formatting to non-formatted cell ranges by format painter using |
Accommodations: | Check the understanding of material by testing 2-3 students from audience |
Checking For Understanding: | Test the students how they are able to create their own conditional formatting rules |
Closure: | Explaining the importance of using conditional formatting on real life examples |
Evaluation: | TEST |
Teacher Reflections: | A survey of students on the assimilation of the submitted material |
| Create New Lesson Plan | Lesson Plan Center |