Guidelines for Final Project You are to prepare a final project which will apply

GET A PROFESSIONAL PAPER DONE BY AN EXPERT

Guidelines for Final ProjectYou are to prepare a final project which will apply what your learned from this class into problem solvingventure. This project should incorporate all that you have learned and summarizes what the project is allabout. The project is to challenge you to extend the skills learned in thisclass and to experiment with new skills. The project should include two parts (theapplication itself 80% and its documentation 20%).A. Focus of the projectProject DevelopmentYou should select a business related topic (i.e. a decision on purchase or lease a car, a decision onrent or purchase a house, manage a business with multiple divisions (annual sales, expenses andprofit), a professor’s gradebook, Decision on the choices of colleges, managing a student club andrunning a business using database to manage all the record (i.e. project, customers and suppliers),and managing a scholarship fund, managing your or your clients stock portfolio and so on. Thetype of project topic should be clearly defined. Why do you think your program is makeable?What are the input and output of your program? What is its benefits? Who are the potentialcustomers?B. Skills applied and expanded for your final projectThe following outline is the suggested criteria to be addressed within the project. They areguidelines only, and may be modified as appropriate, following student consultation with theinstructor.1. Creating a worksheet and a Chart2. Use formatting and styles for your worksheet3. Use of formula and functions such as SUM, AVERAGE, MIN, MAX, Round4. Use formatting per data types5. Use conditional Formatting6. Use of 3 D reference formulas7. Working with What If analysis and Vlookup functions8. Working with multiple worksheets and workbook9. Using database functions in excel (creating a table and/ or tables)10. Using Criteria and Extract Ranges criterion range, sorting and query the data per specialcondition)C. Evaluation of the project and presentation1. The completeness and meaningfulness of your project2. The soundness of your project and justifications3. The effectiveness of your presentation (SS and Doc)Below are the samples for both writing and excel. (Both of them are required)