The Proceedings of the Information Systems Education Conference 2007: §1545 Home Papers/Indices prev (§1544) Next (§1712)

Thu, Nov 1, 2:30 - 2:55, Haselton 1 Paper (refereed)

Recommended Citation: Steinberg, G. Teaching Relational Database Concepts to Computer Literacy Students: The Spreadsheet Metaphor. In The Proceedings of the Information Systems Education Conference 2007, v 24 (Pittsburgh): §1545. ISSN: 1542-7382. (A later version appears in Information Systems Education Journal 7(53). ISSN: 1545-679X.)

Teaching Relational Database Concepts to Computer Literacy Students: The Spreadsheet Metaphor

Refereed

11 pages

Geoffrey Steinberg    [a1] [a2]
College of Business
Kent State University    [u1] [u2]
Kent, Ohio, USA    [c1] [c2]

A challenge facing computer literacy classes is the proper course content level. The challenge is to take the students to a higher level academically but without driving them away because they feel an “easy” course has become “hard.” Accepting this challenge, we have moved the database portion of the computer literacy class beyond keystrokes (rote learning) to data modeling using the spreadsheet as a metaphor for a relational database. Although not found in the current literature, this metaphor facilitates the understanding of the foundations of relational theory and enables computer literacy students to design normalized multi-entity databases within several class sessions. Students combine relational theory and keystroke knowledge of Microsoft Access to implement finished applications. The resultant applications are free of data redundancy problems that often plague non-normalized databases.

Keywords: Database, Computer Literacy, Pedagogy, Teaching, Normalization, Data Modeling, Spreadsheet, End User

Read this refereed paper in Adobe Portable Document (PDF) format. (11 pages, 459 K bytes)
Preview this refereed paper in Plain Text (TXT) format. (37 K bytes)

CDpic
Comments and corrections to
webmaster@isedj.org