# Mileage Log Spreadsheet - DOC

Document Sample

```					Submitted by: Cindy Barnes
Date: 10/15/07 – 11/2/07
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
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
 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