Excel Project
PROJECT PARAMETERS:
This project is very open ended to give you a chance to be creative and figure some things out for yourself. Open-ended projects also eliminate the temptation to cheat - your spreadsheets will not look anything like the other students' files. I've listed requirements and suggestions, but it is up to you to make your file attractive, easy-to-read, and mathematically correct. Please try to figure things out by yourself, but if you need help, try google, myitlab (if you still have access), youtube, Microsoft online tutorials, etc.
OUTPUT:
You will submit one Excel file with at least 8 sheets. All of the information will be made up, just try to make it a little realistic. You can look online for examples. Complete ALL of the following:
1. Budget for an individual or a company: a sheet for January - April, a sheet for May - August, a sheet for September - December, and a total sheet which pulls numbers from the first 3 sheets.
2. A GPA spreadsheet: list courses for two semesters (15 hours per semester), grades, etc. and a formula to determine GPA. This doesn't have to be real information. Use a 4.0 scale for the GPA.
3. Payroll sheet: Include at least 10 employees, you can determine what data will be needed, but make sure you include gross pay, taxes, health insurance, and net pay.
4. General Spreadsheet: This sheet can be anything you like - inventory list, contact list, etc. You might want to use it to include formulas and features that don't make sense in the other spreadsheets.
5. Create some data that you can use for a Pivot Table. Then create a pivot table and list 4 or 5 questions (and their answers) that your pivot table will answer.
REQUIRED:
You must use the following at least once:
|
Addition, subtraction, multiplication, division
|
Cell references (to pull a number from one sheet into another sheet)
|
List of features/formulas used (so that I don't miss something)
|
|
Lookup formula
|
PMT formula
|
Graph
|
|
Image (insert a pic)
|
IF formula
|
Absolute reference
|
Attachment:- Assignment Files.rar