Assignment:
Guidelines for Final Project
You are to prepare a final project which will apply what your learned from this class into problem solving venture. This project should incorporate all that you have learned and summarizes what the project is all about. The project is to challenge you to extend the skills learned in class and to experiment with new skills. The project should include two parts (the application itself and its documentation).
A. Focus of the project
Project Development
You should select a business related topic (i.e. a decision on purchase or lease a car, a decision on rent or purchase a house, manage a business with multiple divisions (annual sales, expenses and profit, a professor's gradebook, Decision on the choices of colleges, managing a student club and running a business using database to manage all the record (i.e. project, customer and suppliers), and managing a scholarship fund, and so on. The type of project topic should be clearly defined.
B. Skills applied and expanded for your final project
The following outline is the suggested criteria to be addressed within the project. They are guidelines only, and may be modified as appropriate, following student consultation with the instructor.
1. Creating a worksheet and Chart
2. Use of formula, functions and formatting
3. Working with large sheets
4. Using SUM, AVERAGE, MIN, MAX, Round, and PMT functions
5. Working with What If analysis and Vlookup and/or PMT functions
6. Working with multiple worksheets
7. Using database functions in excel (creating, sorting and query a table and create a report)