 |
Info. Tech Apps. IIWeek 2October 30-November 3 |
MONDAY
- Bell Ringer: Open "Bowling" Review Lesson 4 Notes
- Review Excel Lesson 4 Notes
- Understanding and Displaying Formulas 92
Understanding Order of Operations 93
Building Basic Formulas 94
Creating a Formula that Performs Addition 95
Creating a Formula that Performs Subtraction 95
Creating a Formula that Performs Multiplication 96
Creating a Formula that Performs Division 96
- Understanding and Displaying Formulas 92
- Con't Lesson 4 Notes
- Using Cell References in Formulas 97
Using Relative Cell References in a Formula 97
Using Absolute Cell References in a Formula 98 - Naming a Cell Range/Using in Formulas 104
- Keeping Track of Named Ranges 108
- Complete Lesson 4 Project 4-1, 4-2, 4-3
- Using Cell References in Formulas 97
TUESDAY
- Bell Ringer: Project Check Lesson 4
- Review Excel Lesson 4 Notes
- Complete Lesson 4 Projects 4-4 to 4-6
ASSIGNMENT: Lesson 4 Projects 4-4 to 4-6
WEDNESDAY-
- Bell Ringer: Project Check Lesson 4
- Review Excel Lesson 4 Notes
- Intro to Lesson 5 " FUNCTIONS (Using Insert Function Icon) Discuss other ways to insert functions as well.
- Exploring Functions 117
Displaying Dates and Times with Functions 119
Exploring Dates 119
Using TODAY 120
Using NOW 120 - Using the SUM Function 122
Using the COUNT Function 123
Using the COUNTA Function 123
Using the AVERAGE Function 124
Using the MIN Function 125
Using the MAX Function 125- COMPLETE LESSON 5 STEP-BY-STEPS 117-126
- Exploring Functions 117
THURSDAY-
- Bell Ringer: L5 Step-by-Step Check
- Review Excel Lesson 5 Notes
- Con't Lesson 5 "Functions"
- Using a Financial Function 126
Using Formulas to Create Subtotals 127
Selecting and Creating Ranges for Subtotaling 127
Building Formulas for Subtotaling 128
Modifying Ranges for Subtotaling 129
Uncovering Formula Errors 130
Reviewing Error Messages 131
Tracing and Removing Trace Arrows 132
Displaying and Printing Formulas 133- COMPLETE LESSON 5 STEP-BY-STEPS 127-134
- Using a Financial Function 126
FRIDAY-