Example Demo Spreadsheets for the "Excel in Life" Problem for IS 312 Project

Dr. Yue "Jeff" Zhang, CSU-Northridge, Spring 2014

In this page, I provided the links to six spreadsheets/workbooks that are mostly the design of my previous students, from fairly simple to fairly complex. I used "S" for "small", meaning small and easy spreadsheets that largely met my requirements of "Excel in Life" problem design, and "Big" for two truly full-fledge, real-world class design that were by two good students. I also provided one that is "medium" in size and complexity, which was my own design, taken from a real company in SoCal which is a cross-country household appliances manufacturer.

I hope these examples give you some idea of what kind of problem I am looking for, and what some of yoour previous smesters' peers could come up. You can also learn from their solving the problems using the taught skills.

1. Small: Auto service

2. Small: Retail commission

3. Small: Vacation and bonus records

4. Medium: Commissions depending on product line and market newness (my design)

5. Big: Inventory management

6. Big: Billable hours