EQ - How do I use a Web Query?

1. Activator: Stock Market Talk
2. Laying the Foundation (EX82-EX126)
3. Lunch
4. Conditional Formatting
5. Intro to Web Queries
6. Applying to our Project
7. Stock Market Project

Job 121 - Custom Sort

EQ - What is the process for customizing the sort feature of MS Excel?

1. Recap of Substitute Lessons
2. A closer look at Job 121
3. Demo - Custom Sort
4. Together - Job 121

EQ - How do I use a Web Query?

1. Activator: Stock Market Talk
2. Laying the Foundation (EX82-EX126)

Refreshing the Sort Function (Tuesday)

EQ - How do I analyze a worksheet using the sort function?

1. Complete the following tasks
1. Handout 1 - Use Functions; Sort
2. Job 114 - Create and Sort a Database
3. Corresponding Questionnaire - Sorting and Filtering a Worksheet
4. European Vacation Budget

**Please remember to complete community reading immediately following lunch**
(One student may pick up the Wall Street Journal newspapers from the office)

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