Wednesday, April 22

 

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)
  • Due tomorrow 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)
  • Turn in for 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.