Thursday, April 23


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
  • If needed, complete yesterday's assignments

  • The complete the following:
  • 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
  • Due today at the end of class

  • 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
Summarizing Strategy:

Answer key questions above

Observation, TOD

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

6th grade BCS 7th grade BCS 8th grade BCS


6th grade BCS | 7th grade BCS | 8th grade BCS

Syllabi | Schedule | Georgia Performance Standards | FBLA | Contact

High School Courses: Introduction to Business & Technology | Business & Technology | Business Communications

Old High School Courses: Computer Applications 1 | Computer Applications 2

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

Updated August 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.