College,Tuition and Fees,Food and Housing,Books and Supplies,Personal Expenses,Transportation,Loan Fees,Cost of Attendance,URL,
Carnegie Mellon University,Carnegie Mellon University,"$62,622","$17,344","$2,400","$1,700","$1,222","$84,066","$85,388",Link
Massachusetts Institute of Technology ,Massachusetts Institute of Technology (MIT),"$61,990","$13,060",$910,"$2,374","$1,254","$78,334","$85,960",Link
"University of California, Berkeley","University of California, Berkeley","$18,770","$23,354","$1,132","$2,728","$1,072","$45,984","$46,772",Link
Georgia Institute of Technology,Georgia Institute of Technology,"$30,626","$13,264",$800,"$3,200","$1,200","$47,890","$49,165",Link
Stanford University,Stanford University,"$63,825","$19,625","$1,305","$3,366","$1,352","$88,121","$91,761",Link
,,,,,,,,,
1. Find this data at the school's website,,,,,,,,,
2. Select A1:H3,,,,,,,,,
3. Insert Chart,,,,,,,,,
4. Select either a stacked column chart,,,,,,,,,
5. Make sure chart title is appropriate,,,,,,,,,
6. Make sure axis titles are approppriate,,,,,,,,,

College,Students Receiving Federal Loans (%),Median Total Student Loan Debt After Graduation,Typical Monthly Payment for Student Loans,Default Rate on Student Loans,Parent Borrowing Rate,Median Total Parent Plus Loans Debt After Graduation,Typical Monthly Loan Payments for Parent Plus Loans
Carnegie Mellon University,47%,"$26,250",$271,0.10%,10%,"$35,000",$350
Massachusetts Institute of Technology,71%,"$17,316",$179,0.05%,15%,"$30,000",$300
"University of California, Berkeley",22%,"$14,200",$146,2.00%,12%,"$25,000",$250
Georgia Institute of Technology,71%,"$24,000",$248,0.50%,18%,"$32,000",$320
Stanford University,83%,"$18,512",$158,0.35%,8%,"$40,000",$400
1. Find financial aid & debt information at https://collegescorecard.ed.gov/,,,,,,,
2. Insert a column chart showing median total student loan debt after graduation,,,,,,,
3. Insert a column chart showing typical monthly payment for student loans,,,,,,,
4. Insert a column chart shwoing default rates on student loans,,,,,,,
5. Insert a column chart showing median total parent plus loans debt after graduation,,,,,,,
6. Insert a column chart showing a typical montly payment for parent plus loans,,,,,,,

College,Sticker Price (Cost of Attendance),Net Price,Anticipated grants and scholarships received,Average Annual Cost
Carnegie Mellon University,"$84,066","27,201","$56,865","$33,499"
Massachusetts Institute of Technology ,"$78,334","14,368","$63,966","$12,938"
"University of California, Berkeley","$45,984","24,142","$21,842","$19,329"
Georgia Institute of Technology,"$47,890","17,762","$30,128","$17,410"
Stanford University,"$88,121","8,113","$80,008","$8,113"
1. Copy your sticker price from previous sheet,,,,
2. Find net price for your familiy's bracket at tuitiontracker.org,,,,
3. Calculate the anticipated grants and scholarships by subtracting net price from sticker proce,,,,
3. Find data for average annual cost at College Scorecard,,,,
"5. Please note the average annual cost is:  the price a student who receives federal financial aid pays to cover expenses (e.g., tuition, living expenses) to attend a school. ",,,,
6. Insert a column chart in which the colleges are on the horizontal axis,,,,
7. Make sure the chart title is appropriate,,,,
8. Make sure the axis titles are appropriate,,,,

Please create a t-chart with Direct Costs and Indirect Expenses as the column headings.

    Calculate the direct costs (tuition+food+housing) for each of your schools. Direct costs are paid to the institution.
    Write the name of the school and its total direct cost in the left-hand column.
    Calculate the indirect expenses (textbooks, transportation, and other personal expenses) for each of your schools.
    Write the name of the school and its total indirect expenses in the right-hand column.
    Rank them from 1 (most expensive) to 3 (least expensive) in each category. Write the number next to the name of each school.
    Below the T-Chart, please complete the following statements: At this point in my analysis, my least expensive option appears to be.... (Make sure to reference its total sticker price compared to the other two, its total direct costs compared to the other two, and its total indirect expenses compared to the other two.

Please create t-chart with Net Price (Tuition Tracker) and Average Annual Cost (College Scorecard) as the column headings.

    Tuition Tracker offers a projection of the net price a student in a certain income bracket will pay in direct costs (plus books) for the academic year. It does not include loans.
    List the schools in order from lowest net price to highest net price according to Tuition Tracker. 
    College Scorecard's average annual cost is the average net price for students who receive federal financial aid (e.g., Pell grants, federal loans) for one academic year of study. It does not include loans. It reflects in-state students
    List the schools in order from lowest net price to highest net price according to College Scorecard.
    Please complete the following paragraph frame beneath your t-chart: Given this data, the net price that is likely to be more accurate for me comes from.... It is probably more accurate because_________. Therefore, my least expensive option appears to be......