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