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)

Clustered Column Charts

EQ – How do I insert a Clustered Column Chart into a worksheet?

1. Please open Walk and Rock Music from the H drive 
2. Open to page EX 49 in the textbook
3. Complete EX 49 – EX 59
4. Create a clustered column chart for each worksheet you developed last class

Thank you for your patience during the last two class periods.  I really appreciate your efforts during my absence.  Keep up the good work. 

Class 9: Practicing Excel

EQ – How do I effectively design spreadsheets in MS Excel?

1. Students will complete a series of Spreadsheets at the link provided 
•   http://www.abacustraining.biz/Exercises/Excel/BasicSSConcepts.htm
2. Place each activity on a separate sheet tab.  Label accordingly.
3. Save your work to your Excel folding with an appropriate title
4. Please find something productive to do if extra time exists.