Microsoft Excel Project



College Spreadsheet Project

Your next assessment for the Excel unit will require you to conduct research and create a spreadsheet of your researched results. Convince me that your choice was the best choice for you.

Your spreadsheets should be well planned and should look attractive. You should add graphics to enhance the appearance. Use shading, colors, font changes, and any other formatting changes that might add to the appearance of your spreadsheet. Remember to make your spreadsheets and charts easy to understand and attractive to look at.

COLLEGES:

You can use the Internet to find information about colleges and universities that you could possibly and realistically attend. Many college sites consist of hundreds of pages containing information about courses, prerequisites, professors, student groups, costs, and even dormitory accommodations. Some pages even allow you to register online.

1. Determine where you would like to attend college and the type of program that interests you

2. Take notes on your research including: tuition, fees, room and board, and number of students that attend each college.

3. Design a rough draft of your information gathered and what your spreadsheet will look like

4. Next, set up a table in Excel that lists the information in the categories displayed below

5. You will research six (6) colleges/universities of your choice, using the internet, Post-high school center, catalogs or view books, gathering financial information (costs) regarding each of the schools and then create your own spreadsheet with the information researched.

|Requirements: |Points: |

|6 Colleges including: | |

|Tuition per semester | |

|Books per semester | |

|Room and board per semester | |

|Fees per semester | |

|Miscellaneous costs per semester (?) | |

|Total undergraduate enrollment (number of students that attend) | |

|Arrangement | |

|(HINT: arrange your spreadsheet so that the college titles are the row headings and the costs are the column headings) | |

| |60 points |

|Formulas to calculate: | |

|Total cost, per semester, and per year--per college | |

|Average cost of books of the colleges you chose | |

|Maximum cost of tuition of the colleges you chose | |

|Use an IF function to determine if the colleges are affordable for you to consider. ie: the total cost of 4 years is greater than | |

|$45,000, then no, if not yes. | |

|Chart: | |

|Create a column chart to compare the total costs of each school. | |

|Label the chart to help the reader understand your chart |60 points |

|Rough Draft & Notes: | |

|Submit the notes you took on all of the colleges and universities that you researched. | |

|Submit your rough draft. |30 points |

|Print & Email: | |

|1 copy with your data (landscape or portrait?) Fits on one page? | |

|1 copy showing your formulas (landscape or portrait?) Fits on one page? | |

|Print the chart with appropriate labels, titles, and legend. |Total points 150 |

|E-mail Mr. Philip your Excel spreadsheet. | |

Hint:

Read all of the instructions and your rubric before you begin. Be detailed in your information and demonstrate your knowledge of Excel through this project. [pic]

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download