Touch of Reality Webquest
Thank you Ms. Adair (original creator)

Table of Contents

-Purpose:
In this Webquest, Philadelphia students will discover what lies ahead of them after elementary/middle school. Students will choose a high school, college, career, house and car. They will discover what it's like to be an adult. They will have to do a monthly budget in Excel which will be inserted into Powerpoint. A Powerpoint presentation will be the end product.
§ The links in the side bar will take you on your journey through this webquest. §

For Students:
As a student, you will learn the responsibilities of an adult that is now living on his/her own. As children, we sometimes take our parents/guardians for granted. This webquest is to help you understand the responsibilities that lie ahead of you. See these SAMPLES.

Slide 1: Title, your name and room number


-Choosing A Career
Slide 2-4: Career (choose a realistic career - no sports)
Site Location: http://www.bls.gov/k12/content/students/careers/career-exploration.htm
Picture_1.png


Directions:
Slide 2 - Name of career, Job responsibilities, Skills needed & Education needed
slide_2_tor.png
Slide 3 -Why you choose this career, Picture of this career
slide_3_tor.png

Slide 4 -Yearly salary, Gross salary, net salary, monthly salary
slide_4_tor.png

Find your Net Income (what you actually get)
  • Yearly salary (gross income - total amount made BEFORE taxes taken out)
  • Net Salary - Take your yearly salary and deduct 25% (this goes to taxes)
  • how to get NET -> yearly salary x .75 = Net ( $100,000 x. 75=$75,000 - net income)
Find your monthly income
  • Divide the net income by 12 to find your monthly income.





-Choosing a High School
Slide 5: High School
Site Location: http://www.phila.k12.pa.us
I. Click on schools - View the list of Philadelphia high schools and then explore that schools website by clicking on the name of the school. Think about the career you just chose.

II. High School Information
Write down:
  • Name of the high school you chose
  • The school's address
  • The school's phone number
  • Explain why you chose this high school
  • Include a picture of the school
  • Include the school's website

SAMPLE -slide_5_tor.png


-Choose a College or Vocational School
Slide 6: College

Choose a College - Site Location: http://www.college.com ,
http://www.collegeview.com/index.jsp or do a google search

I. Find a college that offers courses and a degree in your future career
Write down:
  • What college you chose
  • Where it's located
  • How many years to get your degree
  • Explain what you will have a degree in (ex: bachelor's degree of science in education)
  • A picture of your college

Choose a Vocation or Trade - Site Location: college surfing

I. Find a trade for you future career.
Write down:
  • What trade school you chose
  • Where it's located
  • How many years until you graduate
  • Explain what your certificate will be in (ie: plumbing, electrical, etc.)
  • A picture of your trade school
SAMPLE -
slide_6_tor.png



-On Your Own - Housing
Slide 7: Home
Site Location: http://www.realtor.com
Picture_5.png
I. Finding a place of your own
  • After college you need to move into your own place. On this site you will choose the area in which you
    would like to live.
  • Choose a house up to $200,000 tops (A starting salary won't be able to afford anything higher). Or you
    can choose an apartment to rent.
  • Go house/apartment hunting!
II. What to include on your slide:
  • How many bedrooms and bathrooms does it have? How much was the total cost of the house?
  • How much is your mortgage per month? Or how much is your rent per month?
  • What city and state is your house / apt. located?
  • A picture of your house / apartment
III. How to find your mortgage: http://www.mortgagecalculator.org/


SAMPLE -
slide_7_tor.png


-Choose Your Car
Slide 8: Car

Site Location: http://www.kbb.com/
Picture_6.png
Sometimes taking the bus can be a hassle. You're on your own now, so you need to have your own car.
I. On this site, choose either new car pricing or used car (retail).
  • Find a car you'd want to buy. Be careful, going for a fancy car might put you in debt. Start off practical!

II. Save the information about the car you chose or write the information down.
  • Make, model and year of car (ie: a 2005 Dodge Grand Caravan)
  • The price of the car
  • Your monthly payment
  • A picture of your car

III. If your monthly payment isn't given: here is a calculator or ...
for new cars: total price divided by 60 = monthly payment
for used cars: total payment divided by 36 = monthly payment

SAMPLE -
slide_8_tor.png


-Monthly Expenses in Excel
Slide 9: Chart How to add an excel spreadsheet into a PowerPoint - it's simple - follow these easy steps
-retype this chart into an excel document - put in the info that is needed to have a complete chart.
- inserting the chart in PP(have you chart made in Excel and Saved) - how to...
  1. go to the slide you want the chart on
  2. go INSERT on menu bar. Go down to OBJECT...
  3. when Object box opens, choose on left, "Create from file"
  4. Choose the file you just made and saved in excel - click "Insert"
  5. Then choose OK
  6. resize as needed
*How to add an excel spreadsheet into a PowerPoint - it's simple - follow these easy steps

slide_9_tor.png
There are certain bills that you must pay each month:
  • Your mortgage
  • Car payment
  • Car insurance - $50
  • Gas for car - $100
  • Electric - $100
  • Water - $25
  • cellphone - $75
  • home phone/internet/cable - $100
  • food - $125
  • miscellaneous - $150


1). You should have a title called “Monthly Expenses”. This line should be merged in row 1. It should also be centered.

2). You should have line 2 that tells your gross income and net income (SEE ABOVE FOR WHAT THIS MEANS) . This line is also merged. It should say “Gross Income” with the amount and "Net Income" (income minus the 25% for taxes) with the amount.

3). You should have line 3 that has your net monthly income (net income divided by 12). This line should be merged also. It should say "Net Monthly Income" and give the amount.

4). You should have a list of what your expenses are for the month. One column will be the list of your expenses and another list will be the amount you are spending. You must have a heading for the column. Skip a row before you add the headings.

5). You need to have one cell that has the total spending for the month. This amount cannot exceed your net monthly income. It should be off to the side. Create a formula that will tally the amount for you.

Take into account any miscellaneous spending:
- movies
- ordering out for food
- going out for dinner
- buying clothes, games, shoes, etc.

Sample -



You should have 5 pictures to represent the topic of the slide (career, high school, college, home & car). For example, the slide with you house information should have a picture of your house.


-scoring guide
CATEGORY
4 - 100-90
3 - 89-80
2 - 79- 70
1 - 69 less
Background
Background does not detract from text or other graphics. Choice of background is consistent from card to card and is appropriate for the topic.
Background does not detract from text or other graphics. Choice of background is consistent from card to card.
Background does not detract from text or other graphics.
Background makes it difficult to see text or competes with other graphics on the page.
Text - Font Choice & Formatting
Font formats (e.g., color, bold, italic) have been carefully planned to enhance readability and content.
Font formats have been carefully planned to enhance readability.
Font formatting has been carefully planned to complement the content. It may be a little hard to read.
Font formatting makes it very difficult to read the material.
Content - Accuracy
All content throughout the presentation is accurate. There are no factual errors.
Most of the content is accurate but there is one piece of information that might be inaccurate.
The content is generally accurate, but one piece of information is clearly flawed or inaccurate.
Content is typically confusing or contains more than one factual error.
Spelling and Grammar
Presentation has no misspellings or grammatical errors.
Presentation has 1-2 misspellings, but no grammatical errors.
Presentation has 1-2 grammatical errors but no misspellings.
Presentation has more than 2 grammatical and/or spelling errors.
Use of Graphics
All graphics are attractive (size and colors) and support the theme/content of the presentation.
A few graphics are not attractive, yet blurry but all support the theme/content of the presentation.
All graphics are attractive, yet blurry but a few do not seem to support the theme/content of the presentation.
Several graphics are unattractive, blurry AND detract from the content of the presentation.
Transitions
Transitions are used at a good speed
Most (99-90%) transitions are used at a good speed
Many (89-75%) transitions are used at a good speed
Fewer than 75% transitions are used at a good speed.
Originality
Presentation shows considerable originality and inventiveness. The content and ideas are presented in a unique and interesting way.
Presentation shows some originality and inventiveness. The content and ideas are presented in an interesting way.
Presentation shows an attempt at originality and inventiveness on 1-2 cards.
Presentation is a rehash of other people's ideas and/or graphics and shows very little attempt at original thought.
Slides/ Facts
All slides are present with all facts asked for are complete
All slides are present with all facts asked for are complete (80% accuracy)
Slides are missing, but more than 75% of work is present and actuate
Slides are missing, but less than 75% of work is present and actuate
excel slide
very neat, legible, presents nicely, followed directions for inserting excel
neat, legible, presents nicely, followed directions for inserting excel
not so neat, legible, , followed directions for inserting excel
did not follow directions, sloppy,
excel chart information
content accurate
content 80% accurate
content 70% accurate
content less than 69% accurate