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