Docstoc

Mileage Log Spreadsheet - DOC

Document Sample
Mileage Log Spreadsheet - DOC Powered By Docstoc
					Submitted by: Cindy Barnes
Email: schs_business@yahoo.com
Date: 10/15/07 – 11/2/07
Subject: Advance Business I
Total Points - 250
Grade Level(s): 10, 11 or 12
Description
This is designed to help students prepare for expert certification in Microsoft Office
Excel and involves various useful features to manipulate and enhance spreadsheets and to
create and modify charts based on the spreadsheets you create.
Objectives (Design):                                     Arizona Content Standards
     Describe tasks a spreadsheet would be used         7.0 Apply Technology Tools to
        for.                                             Business Management and
     Identify different parts of Excel spreadsheet      Administrative Services Support
        window.                                          Functions. 7.3
     Enter and edit data in a worksheet
     Use formulas to perform calculations (SUM,
        AVERAGE, MA, MIN & ROUND.
     Create hyperlinks to a Web page and to an
        email address
     Apply cell formatting
     Use “What if” questions.
     Utilize amortization table using the PMT
        function.
     Use multiple sheets in a workbook.
     Create charts and graphs for visual
        appearance.
     Apply chart formatting.
     Identify various other types of charts that can
        be created.

Materials and Resources (Development)
Computers with Microsoft Office installed and the textbook Microsoft Office 2003.

Procedures (Development & Implementation):
Class work
Follow coursework and assignments from syllabus on
http://teach2.eac.edu/barnes/CMP%20101.doc as attached.
Evaluation
Mock Microsoft Office Excel Exam 23-30 Multi-task questions 45 minutes long
Scenario- based
Many of the questions in this Microsoft Office Specialist exam require students to
complete a series of tasks for storing and analyzing data. Emailing a worksheet, creating
graphs and charts, converting to HTML and templates.
Chapter      Practice/                Assignment                Pts
                                                    Pages
Number       Exercise                   Name                  Possible
Ch 7      Practice       Grades Parts 1-5           210-232      10
Ch 7      Practice       Examples                     218        10
Ch 7      Practice       Widget Invoice Parts 1-2   229-235      10
Ch 7      Practice       Widget Order Form            236        10
Ch 7      Exercise 2     Balance Sheet                246        10
Ch 7      Exercise 8     Income Statement             252        10
Ch 7      Exercise 10    Budget                       253        10
          Chapter 7
Ch 7                     Quiz                        Quiz        20
          Quiz
Ch 8      Practice       Mileage Log                  262        10
Ch 8      Practice       MILEAGE SUMMARY            265-266      10
                         HOTEL OCCUPANCY
Ch 8      Practice                                  267-274      10
                         Parts 1-3
Ch 8      Practice       PAYROLL                    271-273      10
Ch 8      Practice       LOAN                       275-277      10
Ch 8      Practice       CAR SALES                  279-281      10
Ch 8      Exercise 1     Dive Log                     287        10
Ch 8      Exercise 4     Car Loan                   289-290      10
          Chapter 8
Ch 8                     Quiz                        Quiz        20
          Quiz
Ch 9      Practice       CONTINENTS                 303-308      10
Ch 9      Practice       TEMP/TRAV                  311-325      10
Ch 9      Exercise 3     Population                   331        10
Ch 9      Exercise 4     Country Statistics           332        10
          Chapter 9
Ch 9                     Quiz                        Quiz        20
          Quiz
uiz

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:179
posted:11/14/2010
language:English
pages:2
Description: Mileage Log Spreadsheet document sample