Excel or Paper II Project

CS 102

60 points, due Nov. 19, 2001

You have your choice of writing a second paper, following the same guidelines as for the first paper, or completing the following two Excel/Word exercises. The completed project should be mailed to Send mail to kelliher AT DOMAIN goucher.edu before class on the 19th. Excel and Word must be used.

1. A friend of yours is in the process of buying a home and has asked you to compare the payments and total interest on a 15- and 30-year loan. You want to do as professional a job as possible and have decided to analyze the loans in Excel, then incorporate the results into a short memo written in Word. As of now, the principal is $150,000, but it is very likely that your friend will change her mind several times, and so you want to design your spreadsheet so that you can easily change your assumptions. This project requires that you create two files: the spreadsheet and the memo document. Turn in both files.

2. Your work study job next semester has placed you in the Provost's office, where you are to create a presentation for the Board of Trustees. The Provost is expected to make recommendations to the Board regarding the expansion of some programs and the reduction of others. You are expected to help the Provost by developing a series of charts to illustrate enrollment trends. The Provost has provide you with an Excel spreadsheet ( enrolmnt.xls on \\ phoenix\cs102 in the Excel spreadsheets folder) with summary data over the last several years. Put each chart on its own page of the spreadsheet. For each chart, explain why you included it and why you chose the particular chart type. The explanations should be typed on the original sheet of the spreadsheet.