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 *