8th+Reality+of+LIFE!

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

toc 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. § //
 * -Purpose: **

__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

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


 * Slide 4** -Yearly salary, Gross salary, net salary, monthly salary

**Find your Net Income (what you actually get)** **Find your monthly income**
 * **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)
 * 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** - [[image:slide_5_tor.png width="244" height="159"]]

-Choose a College or Vocational School Slide 6: College

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

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

-On Your Own - Housing Slide 7: Home || **I. Finding a place of your own** > would like to live. > can choose an apartment to rent. **II. What to include on your slide:**
 * < Site Location: http://www.realtor.com
 * After college you need to move into your own place. On this site you will choose the area in which you
 * Choose a house up to **$200,000 tops** (A starting salary won't be able to afford anything higher). Or you
 * Go house/apartment hunting!
 * 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** -

-Choose Your Car Slide 8: Car

Site Location: @http://www.kbb.com/ 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

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


 * SAMPLE -**

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

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 media type="file" key="8th touch of reality sample.mov" width="300" height="300"
 * 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 ||