Data Validation

EQ - How is data validation applied?

1. Work with a partner to complete the advanced organizer. The information to complete the organizer is found here --> DATA VALIDATION LEARNING MODULE
2. Use the data validation process on their last saved Excel Workbook “Salary Table”.
3. Save as Salary Table.
   
   

Data Validation

EQ - How is data validation applied?

1. Q&A
2. VLookup Quiz
3. Community Reading/Lunch
4. Activator: Error Messages
5. Advanced Organizer
6. Data Validation Learning Module
7. Budget Activity

VLookup

EQ - How is the VLookup Function important and how is it used?

1. Activator: VLookup Video
2. Advanced Organizer
3. Demo - VLookup Example
4. ABC Investment Company (Using Lookup Tables)
5. Excel Challenge - XYZ Company

Summarize Data Using Subtotals

EQ - How can I summarize data using subtotals?

1. Learning Module Review
2. Complete the Module
3. Lunch/Community Reading
4. Introduction to Data Subtotals
5. Demonstration
6. Practice

Applying The Payment Function

EQ - How can the Payment Function be used to complete financial analysis?

1. Hotseat Review
2. Payment Quiz
3. Learning Module

Financial Functions

EQ – How do I use Financial Functions in Excel?

1. Activator:  Find a Used Car
1. Description
2. Features
3. Cost
4. Advantages
5. Disadvantages
2. How much is it going to Cost Us?
1. Rate
2. Nper
3. PV
4. FV
5. Type
3. Calculate?
4. Intro to Payment Function - Click Here 
5. Examples In Action (Mortgage, Credit Card Debt)
6. Try It Out

More If Statement Fun

EQ - How are nested if statements used and why are they necessary?

1. If Statement Hot Seat
2. Quick Refresher
3. Lunch/Community Reading
4. Intro to Nested If Statements Assistance
5. Try it out

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

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.

Class 8: M & M's

EQ - How can simple functions of Excel be used to analyze data?

1. Mini-lesson: The formula for functions and formulas
2. Knowledge Check
3. Lunch/Community Reading
4. Activator: M & M Predictions
5. Plan the Worksheet
6. Design the Worksheet
7. Count Your M & M's
8. Share and input data
9. Sum & Average Functions
10. Min & Max Functions
11. TOD - How close were your predictions to the actual M & M statistics

Class 7: We're Going Bowling

EQ - How can we calculate statistical information using MS Excel?

1. Activator: Let's Go Bowling
2. Planning Our Worksheet
• Title, Subheadings
• Content for Columns and Rows
• Calculate
• Save Location
• Formatting Outline
3. Lunch/Community Reading
4. Create Worksheet "Bowling"
5. Introduce Excel Functions
• Min
• Max
• Average
6. Finalize Worksheet
7. TOD
• 3 - List 3 functions learned in class today
• 2 - Explain 2 scenarios when you'd use these functions
• 1 -  Pose 1 test-worthy question regarding today's learning

Class 6: Creating A Worksheet Assessment

EQ - How can I use my understanding of Excel to create a professional looking worksheet?

1. Excel Practice Review
2. Community Reading/Lunch
3. Assessment - Vocabulary, Creating a Worksheet, Formatting a Worksheet
4. If Time Permits - Preview Basic Excel Functions

Class 5: Formatting a Worksheet

EQ - How and why do we format an Excel Worksheet?

1. Mini Lesson - Review of the Fill Handle and AutoSum
2. Fill handle challenge
3. Community Reading/Lunch
4. Formatting Rationale
5. Quick Vocab Review
6. AO - Excel Vocab 2 & Formatting Checklist
7. Work Together (EX35-46)
8. Summarizer - Before and After

Class 4: The Fill Handle & AutoSum

EQ - How can we use the tools of MS Excel to easily create a worksheet?

1. Q & A - Prepare for Assessment
2. Assessment - Intro to Excel
3. Community Reading/Lunch
4. Activator: Fill Handle Demonstration
5. Intro - AutoSum
6. Creating a Worksheet (EX17)
7. Together - AutoSum
8. EX 24-29
9. Saving a Worksheet
10. TOD - What 2 tools of Excel did you learn today?  Describe the purpose of each tool.

Class 3: Parts of Excel Worksheet

EQ - What parts of Excel will I regularly use when creating worksheets?

1. Activator - Excel Challenge 1: 
• Open the hyperlink and complete the Worksheet using the handout provided.
• Complete the Cell References Questionnaire
2. Community Reading
3. Preassessment - Parts of Excel
4. Ribbon Review/Label
5. Parts of the Excel Worksheet
6. Focusing on the Home Tab
• Font
• Alignment
7. Enhance your Excel Challenge 1 Worksheet using the Font and Alignment Groups
8. Save your worksheet: Excel Challenge 1

* Please prepare for a quiz next class period that covers Parts of the Excel Screen, Cell Reference Information, and Parts of the Ribbon *

Class 2: You Sunk My Battleship

EQ - How can the game Battleship help us understand the layout of a MS Excel Worksheet?

1. Activator:  Battleship
2. Excel Worksheet Coordinates & Cell References
• Columns, Rows, Cells
• Active Cell
• A1, B15, L451
3. Create a new Battleship Layout in Excel (A1:J11)
4. Saving a Worksheet - "Battleship" 
5.  Navigating through Excel - The Ribbon
6. TOD: 1/2 sheet questionnaire - Answer the EQ

* Be prepared for an Excel Challenge next class period *

Class 1: Welcome to MS Excel

EQ - What are the classroom expectations for Excel?

1. Activator: Getting to Know You - License Plate
2. Syllabus Review
3. Class Procedures
• Folders
• Blog
• Sign-Out Policy
• Fire Drill Procedures
4. Hot Seat - Individual Student Survey
5. Ticket Out The Door (TOD): 3-2-1
• 3 - List 3 Classroom Expectations
• 2 - Write the 2 Classroom Rules
• 1 - List 1 Reason for taking this class