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