The Proceedings of the Information Systems Education Conference 2000: §504    Home    Papers/Indices    prev (§503)    Next (§505)
    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.
CDpic

Inventing the Treebook: A Workbook with Pages Linked in a Tree

thumb
Refereed
 		David Sullivan    [a1] [a2]
College of Business
Oregon State University    [u1] [u2]
Corvallis, Oregon, USA    [c1] [c2]

Matthew Garth McLuckie    [a1] [a2]
Portland, Oregon, USA    [c1] [c2]

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)

photo/graphicjpg28 K bytesDavid Sullivan

CDpic
Comments and corrections to
webmaster@isedj.org