The Proceedings of the Information Systems Education Conference 2000: §504
| Paper (refereed) Leading Edge and Emerging Technologies
|Recommended Citation: Sullivan, D and M G McLuckie. Inventing the Treebook: A Workbook with Pages Linked in a Tree. In The Proceedings of the Information Systems Education Conference 2000, v 17 (Philadelphia): §504.
Inventing the Treebook: A Workbook with Pages Linked in a Tree
A spreadsheet program is an ideal tool for recording scores and calculating grades-tasks every instructor needs to do. But anyone who has built a multipage workbook soon learns how difficult it can be to maintain formulas and entries among all pages. To help instructors sidestep these difficulties, we invented a "Treebook"; that is, an intelligent workbook whose pages are linked in a hierarchical tree. This article describes how we used Visual Basic to create two generations of Excel-based gradebooks that culminated in inventing the Treebook. We expect Treebooks will eventually be used in many application areas because they make building large spreadsheet models easier and more reliable.
Keywords: spreadsheet models, gradebook, Visual Basic, Treebook
Read this refereed paper in Adobe Portable Document (PDF) format. (332 K bytes)
Preview this refereed paper in Plain Text (TXT) format. (21 K bytes)
Comments and corrections to