Monday, January 7

 

Essential Question:
Why should you use MS Excel to create spreadsheets?
Key Questions:
How do you rotate text in a cell? What is an "Assumptions" table and how is it an effective tool in designing spreadsheets? What is the purpose of "Freeze Panes"? How do you use absolute vs relative cell referencing in a formula? What is an If function and what benefit is there to using it? How do you do advanced formatting such as, borders shading, fill, number styles, etc.? How do you put a chart on a separate sheet? How do you create better visual effects on a chart?
Activating Strategy:
Begin working on the assignments below. Q&A if needed.
Instructional Strategies and Student Activity:
  • Continue Daily Journal
  • Continue Daily Vocabulary; define terms 201-205
  • Complete Vocab Quiz 5
  • Finish yesterday's assignment if necessary. See yesterday's lesson plan for details and page numbers.
  • Complete
    • In the Lab 2 - page 215-218 (Casa Grande Resort & Spa)
    • In the Lab 3 - page 218-221 (Illiana Custom Homes - was created in Project 2. You will make changes)
  • Save files to your Z drive
  • The files will be graded from your Z drive - do not print
Summarizing Strategy:

TOD: What is the purpose of freezing columns or rows? What does the NOW function do?

Assessment:
Observation, TOD
Resources:
Excel, Textbook
GPS:
BCS-CA1-1,2,4,7,10

Previous Lesson | Next Lesson
Back to Computer Applications I Calendar | Back to Miss Rock's Homepage

 

 


Computer Applications 1 | Computer Applications 2 | Business Communication & Presentation

Computing in the Modern World | Fundamentals of Web Design | Advanced Web Design

Syllabi | Schedule | Georgia Performance Standards | FBLA | Contact

Updated August 2012

 

Computer Applications 1 Computer Applications 2 Business Communication & Presentation Computing in the Modern World Fundamentals of Web Design Advanced Web Design Animation & 3-D Design