Monday, April 20

 

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
  • Instructor will introduce Excel and go over features while students follow
  • Students will begin the assigment below:
  • Excel Project 1 - pages EX 6-53 (Save Sable River Foundation)
    • Do not print. Read over the instructions on page 46 for printing, but do not print.
    • When you are finished, call instructor over for screen check/grading
  • Due today at the end of class

  • Time permitting:
  • 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)

  • Do not print.
  • When you are finished, call instructor over for screen check/grading
  • Due tomorrow 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 & Technology Business Communications Foundations of Manufacturing & Materials Science

Introduction to Business & Technology | Business & Technology | Business Communications

Syllabi | Schedule | Georgia Performance Standards | FBLA | Contact


Old Courses: Computer Applications 1 | Computer Applications 2

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

Updated January 2015

 

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.