Wednesday, October 29

 

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

How do you enter a formula using the keyboard/ How do you enter formulas using point mode? How do you copy formulas using the fill handle? How do you determine averages of numbers in a range? How do you determine the highest number in a range? How do you determine the lowest number in a range? How do you copy a range of cells across columns to an adjacent range using the fill handle? How do you verify a formula using range finder? How do you change the workbook theme? How do you change the background color and apply a box border to the worksheet title and subtitle? How do you format dates and center data in cells? how do you apply accounting number format and comma stlye format using the ribbon? How do you apply currency style format with a floating dollar sign using the format cell dialog box? How do you apply a percent style format and use the increase decimal button? How do you apply conditional formatting? How do you change the width of columns? How do you change the height of rows? How do you use Spell Check? How do you change the worksheet's margins, header, and orientation in page layout view? How do you print a section of the worksheet? How do you display formalus in the worksheet and fit the printout on one page?

Activating Strategy:
Begin working on assigments below
Instructional Strategies and Student Activity:
  • Continue Daily Journal
  • Students will complete the assignments below:

  • Excel Project 2 - pages 71-117 (The Mobile Masses Biweekly Payroll Report)
  • Put your name in cell A18
  • Before printing, call instructor over for screen check
  • Print following these instructions (your printed spreadsheet should be only ONE page)
  • Staple and turn in for grading
  • Due today at the end of class

  • Time permitting, begin the following assignment:
  • Apply your Knowledge - pages 122-124 (Apply 2-1 Village of Scott Police Department)
  • Put your name in cell A18
  • Before printing, call instructor over for screen check
  • Before printing, call instructor over for screen check
  • Print following these instructions (your printed spreadsheet should be only ONE page)
  • Staple and turn in for grading due today at the end of class

  • In the Lab 2-1 - page 126-129 **This assignment creates 2 files** (Lab 2-1 Part 1 Aficionado Guitar Parts Accounts Receivable Balance Report; Lab 2-1 Part 2 Aficionado Guitar Parts Accounts Receivable Balance Report)
  • Put your name in cell A16
  • Print following these instructions (your printed spreadsheet should be only ONE page)
  • Staple and turn in for grading

  • In the Lab 2-2 - pages 129-131 **This assignment creates 3 files** (Lab 2-2 Part 1 Electry Auto Start-Up Financing Needs; Lab 2-2 Part 2 Electry Auto Start-Up Financing Needs; Lab 2-2 Part 3 Electry Auto Start-Up Financing Needs)
  • Do not print; call instructor over for screen check

  • In the Lab 2-3 - page 132-33 (Lab 2-3 Sock-It Away Stock CLub Summary of Investments) **This assignment is extra credit**
  • Do not print; call instructor over for screen check

  • "In the Lab" assignments are due Thursday 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