Parsing Banner Downloaded Data into a Flat-File Format for Analysis

Garnett Lee Henley (Howard University, USA), Gerunda B. Hughes (Howard University, USA), Tawanda Feimster (Howard University, USA), and Leo E. Rouse (Howard University, USA)
Copyright: © 2012 |Pages: 65
EISBN13: 9781466609877|DOI: 10.4018/978-1-60960-857-6.ch004
OnDemand PDF Download:
OnDemand PDF Download
Download link provided immediately after order completion


Many institutions do not perform statistical modeling of student academic outcomes because they lack the ability to translate Banner® relational files to a flat-file database format. Accredited programs within institutions have terminal, high stakes examinations known as certifying boards that measure competencies and subject knowledge gained during the educational experience. Institutions need to know if there is a relationship between what is being taught throughout the curriculum and how well that knowledge prepares students to think critically as reflected by performance on boards. While it is easy to download Banner data in Microsoft Excel® spreadsheet format, programmers are needed to parse the file for use in statistical packages such as IBM SPSS® and SAS®. This case study details a methodology, including programming language, that will help anyone with intermediate Excel knowledge develop a relational database from Banner files.
InfoSci-OnDemand Powered Search