Home
Introduction
Tasks
Process
Resources
Evaluation
Conclusion

Evaluation

You will be evaluated on each step in the process of purchasing a vehicle.
 

Finding a Job

Locate a job and neatly place into Word document.
5 Points
 

Determine Income

Accurately calculate net pay in Excel spreadsheet.
5 Points
Print spreadsheet with and without formulas.
 

Locate Three Vehicles to Purchase

Find three vehicles under $10,000.
5 Points
Neatly placed information into Word or Printed
 

Research

Locate base and retail pricing.
5 Points
Place information in Word Document, your choice of format i.e. table, paragraph, pictures, etc.

Top of Page

Narrow Options

Determine Pro's and Con's and place in a new Word document.
5 Points
Eliminate two vehicles and state your reasoning in a Word Document, completely and concisely.
 

Calculate Monthly Cost

Create Excel spreadsheet with appropriate formulas.
10 Points
Determine license fees.
Determine monthly payment using function or loan calculator.
Find insurance cost and calculate monthly figure.
Print two spreadsheets, one with formulas one with values only.
 

Make a Decision

Evaluate your data and select one vehcile. Explain reasons in a Word document clearly and concisely.
5 Points
 

Maintenance and Running Cost

Create Excel spreadsheet with appropriate formulas.
10 Points
Locate prices for oil change, air filter and gasoline.
Calculate monthly oil, air filter, and fuel cost.
Top of Page

Monthly Budget

Create Excel spreadsheet with appropriate formulas.
10 Points
Determine income.
Determine expenses for vehicle.
Add other expenses including investments/savings.
Calculate discretionary Income.
 

Concluding Report

In short report format explain your journey, what you learned in each step of the process. Conclude with your final decision and appropriate reasoning.
5 Points

 

Professional, Neat and Accurate

Format
10 Points
Accuracy
10 Points
 

TOTAL POINTS

85

Top of Page

Timing/Due Date

This project will take approximately 2 weeks to complete. Due date is 10 class days from today!
Day 1 Find a job and determine income, place in documents.
Day 2 Locate vehicles to purchase and place in Word.
Day 3 Research vehicles and narrow your options.
Day 4 Locate and calculate monthly cost.
Day 5 Decide on vehicle and determine maintenance and running cost
Day 6 Create your budget. Outline concluding report.
Day 7 Finish concluding report.
Day 8 All documentation due end of class period.
TBD Class Presentation
 

Deductions

Points will be deducted based on the information below.
Late work.
20 Points Per Day
 
 

Bonus Point Opportunity

Those with Excel experience who offer help to classmates with less experience can earn bonus points. Please talk to instructor to be set up with a partner and discuss expectations prior to working with someone.
Top of Page
Last Updated: May 21, 2010 9:06 AM
Questions or Comments Welcome! Please contact Leah Lencowski
   
Introduction  Tasks Process Resource Evaluation Conclusion