Thursday, December 13

 

Essential Question: How do I use Excel to create industry appropriate spreadsheets?
Key Questions: How do I create and manipulate a list? How do I delete sheets in a workbook? How do I validate data? How do I add computational fields to a list? How do I use the VLOOKUP function to look up a value in a table? How do I use the Toggle Total Row in a list? How do I print a list? How do I use a data form to display, add, and delete records and change field values in a list? How do I sort a list on one field or multiple fields? How do I display automatic subtotals? How do I use Group and Outline features to hide and unhide data? How do I query a list? How do I apply database functions, use the SUMIF function, and the COUNTIF function to generate information from a list? How do I save a workbook in different file formats?
Activating Strategy: Read over Key Questions above. What terms look familiar to you? Where have you seen them before? (hint - think about Access) Jot down some notes about similarities you see in the Key Questions.
Instructional Strategies and Student Activity:
  • Continue Daily Journal
  • Continue Daily Vocabulary; define terms 191-195
  • Students will begin Excel Project 5 - page 310-365 (Creates two files --- Soccer Gear Sales Rep List and Soccer Gear Sales Rep List CSV)
  • Ignore printing instructions!
  • Call instructor for a screen check when you complete the steps on page 361
  • Call instructor for a screen check when you complete the steps on page 364
Summarizing Strategy:

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

Assessment: Observation, TOD, grade completed assignments
Resources: MS Excel, Office Textbook
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