Journal of Information Systems Education (JISE)

Volume 22

Volume 22 Number 2, Pages 111-116

Summer 2011


Teaching Case
Jay's Collectibles


James J. Cappel
Central Michigan University
Mt. Pleasant, MI 48859, USA

Jason R. Gillman, Jr.
Liquid Web, Inc.
Lansing, MI 48917, USA

Abstract: There is growing interest in collectibles of many types, as indicated by the popularity of television programs such as the History Channel’s Pawn Stars and American Pickers and the Public Broadcasting Service’s Antiques Road Show. The availability of online auction sites such as eBay has enabled many people to collect items of interest as a hobby and to sell parts of their collection as a business or for extra income. As a collection grows, it becomes increasingly difficult to track through manual methods, and it is often useful to develop a computer-based system for this purpose. This case raises the possibility of developing an information system to manage a collection of sports autographs. This case may be used in a systems analysis and design, database, or systems development course to address a number of important topics such as: systems scope identification, problem and opportunity analysis, requirements analysis, data modeling, and application development. The case is designed to provoke interest and raise a sufficient level of complexity to challenge students to apply a range of systems development and database concepts. While the case addresses sports collectibles, its concepts may be applicable other types of systems, especially those involving other types of collections or “one of a kind” items. Since many students are likely to have at least some experience using online auction sites, following professional sports, seeing television programs about collectibles, or attending flea markets where collectibles are sold, the case builds in some way on their life experience. This teaching case enables students to discover how systems development and database concepts are applicable to a practical problem solving scenario.

Keywords: Case study, Systems analysis & design, Data modeling, Team projects

Download this article: JISE - Volume 22 Number 2, Page 111.pdf


Recommended Citation: Cappel, J. J. & Gillman, J. R., Jr. (2011). Teaching Case: Jay's Collectibles. Journal of Information Systems Education, 22(2), 111-116.