MIS 3310 – 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. Here is a helpful site for pivot
tables: https://www.gcflearnfree.org/excel2016/intro-to-pivottables/1/
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
GRADING:
Use of required features – 60%
Formatting (are things easy to read, is the graph formatted correctly, etc.) – 20%
Inclusion of additional features/formulas (suggestions – lookup formula, borders, etc.) – 20%
