If Statements

EQ - What are If Statements and how are they used?

1. Activator: The If Game
2. Community Reading/Lunch
3. Intro to If Statements *Handout*
4. Using If Statements for March Madness

A Deeper Look At Cell References

EQ - What is the difference between  relative and absolute cell references and how does each impact a formula used in Excel?

1. Finalize Fast Food Frenzy
2. Activator: Race to find the Nutritional Values
3. Lunch/Community Reading
4. Calculator Check - Percentage of Total (Dun Dun Dunnnnnn)
5. Trying it in Excel (Use the Fill Handle)
6. The Problem?
7. Relative and Absolute Cell References
8. Together - Practice Exercise
9. TOD - Answer the EQ

Formula and Functions Refresher

EQ - How can nutritional information be analyzed using excel?

1. Mini-Lesson - Basic Functions Review
2. PEMDAS
3. Practice Problems
4. Lunch/Community Reading
5. Analyzing a Fast Food Diet
• Link - Click Here
• Directions for project
6. Complete your project in Excel

Links to Help You Study

Check out these Study Aids from your textbook.

1. Flashcards
2. Who Wants to be a Computer Genius
3. Wheel of Terms
4. Crossword Puzzle
5. Practice Test

Class 11 - Time to Show Off

EQ - What areas of Chapter 1 must I improve upon prior to the exam?

1. Finding the same page
2. AutoCalculate
3. Community Reading/Lunch
4. In The Lab
• Lab 1 - Annual Cost of Goods (74-75)
• Lab 2 - Annual Sales Analysis (75-77)
• Lab 3 - College Cost and Financial Support (77-79)
5. Cases and Places
• Design & Create a Workbook to Analyze Yearly Sales (79)
• Design & Create a Workbook and Chart to Analyze a Budget (79)