IFS 104

Term Project

Due: Friday, June 3rd at 10:00 am

Description

Your project assignment is to create a cool "uber" homework assignment:

• The focus of the homework you are designing must include a worksheet list/database, ala Chapter 5.
• It should be a word problem similar to the Cases & Places problems in our text.
• The numbers in the list must come from a "real" source: web site, almanac, encyclopedia, etc. The database must include at least 25 data points.
• Your homework must include:
  • Plenty of database filtering, functions, vlookup, and other shenanigans
  • One or more charts
  • Demonstration of at least one "advanced" concept like: goal seeking, the if() function, financial functions, etc.

Deliverables

Please complete these three steps:

1. Write a short (one page-ish) description of your homework problem. You can use Word or any other common text format.
2. Complete a workbook with the raw database data and a description of where you got the data. This should be similar to the files in the "data disk" of the text.
3. Complete a workbook with your solution to the homework assignment... displaying all of your wonderful new spreadsheet powers, of course.

Put everything in your k: drive folder "project". Please print out your problem description and hand it in.

Square pegs

If you have an interest in one particular area of Excel that we have not covered, then individual projects can also be tailored. See me and we'll work it out.

thanks... yow, bill