Monday, April 27

 

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 rotate text? How do you use the fill handle to create a series of month names? How do you increase column widths? how do you enter row titles? How do you copy a range of cells to a nonadjacent destination area? How do you insert a row? How do you enter number with format symbols? How do you freeze and unfreeze column and row titles? What is an absolute cell reference? How do you enter a formula with an absolute cell reference? What is an IF function? How do you enter an IF function? How do you copy formulas with absolute cell references using the fill handle? How do you add a sparkline chart to the worksheet? How do you format and copy the spark line chart? How do you assign formats to nonadjacent ranges? How do you work the worksheet titles? How do you copy a cell's format using the format painter button? How do you draw a 3D pie chart on a separate sheet? How do you insert a chart title and data labels? How do you rotate the 3D pie chart? How to you apply a 3D pie chart and change the color of a slice? How do you reorder the sheet tabs? How do you check spelling in multiple sheets? How do you shrink and magnify the view of the chart? How do you split a window into panes? How do you analyze data in a worksheet by changing values? How do you goal seek?

Activating Strategy:
Begin working on assignments below.
Instructional Strategies and Student Activity:
  • Continue Daily Journal
  • Apply Your Knowledge Part 3 - page 204-205 (Apply 3-1 Absolute Cell Reference Complete)
  • Print normal and formula view; staple and turn in for grading

  • In the Lab 1 - pages 209-213 (Lab 3-1 Med Supply Online Warehouse Six Year Financial Projection)
  • Print the spreadsheet (normal and formula view) and the chart; staple the 3 pages together and turn in for grading

  • In the Lab 2 - pages 214-217 (Lab 3-2 ReachPut Neighbors Analysis of Indirect Expenses)
  • Print the spreadsheet (normal and formula view) and the chart; staple the 3 pages together and turn in for grading

  • The 3 assignments above are 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 & 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.