Monday, October 27

 

Essential Question:
Why should you be able to use Excel to create a worksheet for budgeting and other financial purposes?
Key Questions:

What are worksheet titles? What are column titles? What are row titles? How do you enter numbers? How do you sum a column of numbers? How do you copy a cel to adjacent cells in a row? How do you determine mulitple totals at the same time? How do you save a workbook? How do you change a cell style? How do you change the font, font size, or font color? How do you bold a cell? How do you center and merge cell contents? How do you format numbers? How do you adjust the column width? How do you use the name box to select a cell? How do you add a chart to a worksheet? How do you change the name of the worksheet? How do you change document properties? How do you save with the same file name; different file name? How do you preview and print? How do you determine the maximum, minimum, or average? How do you use the fill handle?

Activating Strategy:
Begin working on assigments below
Instructional Strategies and Student Activity:
  • Continue Daily Journal
  • Students will complete the assignments below:
  • Apply Your Knowledge - pages 54-55 (Apply 1-1 Clothed for Campus Third Quarter Expenses)
  • Lab 1-1 - pages 58-59 (Lab 1-1 A Healthy Body Shop Annual Revenue Analysis)
  • Lab 1-2 - pages 59-61 *Starts at the bottom of page 59* (Lab 1-2 Play 'em Again Semiannual Revenue)
  • Lab 1-3 - pages 61-63 *This assignment creates 3 files - you must have all 3 files to get credit* (Part 1 College Resources and Expenses; Part 2 College Resources and Expenses; Part 3 College Resources and Expenses)

  • Do not print.
  • When you are finished, call instructor over for screen check/grading
  • Due today at the end of class
Summarizing Strategy:

Answer Key questions above

Assessment:
Observation, TOD
Resources:
Textbook
GPS:
BMA-IBT-1,2,8

Previous Lesson | Next Lesson
Back to Intro. to Business & Technology Calendar | Back to Miss Rock's Homepage

 

Introduction to Business & Technology | Business Communications

Computer Applications 1 | Computer Applications 2

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

Syllabi | Schedule | Georgia Performance Standards | FBLA | Contact

 

Updated August 2014

 

Disclaimer: This site provides external links as a convenience to my users. The appearance of external hyperlinks on this website does not constitute endorsement by me of the linked websites, or the information, products or services contained therein. I do not exercise any editorial control over the information you may find at these locations.

Introduction to Business & Technology Computer Applications 2 Business Communications Computing in the Modern World Fundamentals of Web Design Advanced Web Design Animation & 3-D Design