Monday, March 3

 

Essential Question: How do I use Excel to create industry appropriate spreadsheets?
Key Questions: How do I create and use a template? How do I use the ROUND function? How do I utilize custom format codes? How do I define, apply, and remove a style? How do I use the Research task pane to find a synonym? How do I add a worksheet to a workbook? How do I create formulas that use 3-D cell references? How do I draw a 3-D Cylinder chart? How do I use WordArt to create a title and create and modify lines and ojbects? How do I assign comments to cells? How do use the Research task pane to research a topic? How do I add a header or footer, change margins, and insert a page break? How do I use the Find and Replace commands? How do I search for files and create and use a workspace file? How do I consolidate data by linking workbooks?
Activating Strategy: What is a synonym? What is rounding?
Instructional Strategies and Student Activity:
  • Continue Daily Journal
  • Continue Daily Vocabulary; define terms 296-300
  • Students will complete Excel Project 6 (NextDVR Profit Potential Template; NextDVR Profit Potential)
  • Students will complete Lab 1 Starts in the middle of page 68 (Save template as Lab 6-1 Part 1 Rings and Things Annual Sales Analysis; Save workbook as Lab 6-1 Part 2 Rings and Things Annual Sales Analysis; Follow directions for specific steps on how to save)
  • Do not print. Call instructor over for screen check when you are finished.
Summarizing Strategy:

TOD: Answer Key Questions above. Turn it in when you're done.

Assessment: Observation, TOD, grade completed assignments
Resources: MS Excel, Office handout
GPS: BCS-CA2-1,3,6,8

Previous Lesson | Next Lesson
Back to Computer Applications II 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