I WILL MARK BRAINLIEST TO CORRECT ANSWER. Assignment Summary In this assignment, you will research the cost of the first year at a two- or four-year college, depending on the needs of your career choice. Using reference materials and Internet sites, you will collect information about the college fees, housing, food, books, and about optional ways to pay for that year of college. In addition, you will need to set up a savings plan. You will use a spreadsheet program to show your costs for the first year of college and the monthly progress of your savings for the time until you go to college. Useful references for gathering this information are at the end of this document. You will then present your findings in a word document.
Assignment Instructions
Step 1: Gather materials and necessary information.
a) You will collect information about the cost of one year of college.
• Determine your career and college choice and find information about each.
• Research job outlooks and the cities where your chosen job is located.
• Research options for colleges offering programs for your career choice and narrow it down to one college.
• Find the fees at that college.
Tuition
Other student fees
Books and supplies
Room and board
Other expenses (such as clothing, laundry, recreation, transportation)
• Find as many options as possible to help pay for your chosen college, such as financial aid, scholarships, and places to work while in college.
b) Be sure to keep a list of your references so you can cite them later.
c) Ask your teacher where you should save your presentation as you work on it. Your teacher
may also have specific guidelines about the file name you should use.
Step 2: Create a spreadsheet for the cost of your first year of college
a) Plan all your costs in a spreadsheet.
• List your on- and off-campus expenses.
• At the end of each spreadsheet, multiply your total by 2 or 4, depending on the type of college you plan to attend. Here is an example.
On campus
Off campus
Tuition
23,990 5,940 800
0 30,640 61,280 122,560
23,990 8,940 800 3,880 34,520 69,040 138,080
b) Insert an image of the spreadsheet into your report.
c) Be sure to keep a list of your references so you can cite them later.
d) Remember to save your work as you go.
Step 3: Create a spreadsheet for your savings plan. Search online for a "savings growth projector."
a) Plan a reasonable amount to save monthly for the time before you go to college.
b) Use a monthly interest rate of 4%.
• Find the best interest rate and use that in your spreadsheet. An example would be having no prior savings and saving $100.00 a month at 4% APR; after 4 years, you would have savings of $5,213.28.
c) Discuss in your report your savings plan and the amount you will have when you go to college.
d) Be sure to keep a list of your references so you can cite them later.

Room/Board
Books/Lab
Transportation
1-year total
2-year total
4-year total

Step 4: Create your report.
a) Introduce your career and college choice.
• Discuss the cost of living and the job outlook in the city where your choices are located.
• Decide whether to live on or off campus.
• Show a picture of your spreadsheet in this part of your report.
• Discuss the type of job you will obtain while in college.
• Decide whether you will use a car or public transportation.
• Discuss your approach to paying for utilities.
b) Discuss your savings plan and the results of your spreadsheet.
c) Discuss additional options to help pay for college, such as grants, scholarships, work-study, parental help, and loans.
d) Conclude your report. Talk about how you feel about paying for your first year of college and your choices. Add any advice you think may help others with their choices.
e) Remember to save your work as you go.