Asee peer logo

Data Management For Outcomes And Assessment

Download Paper |


2008 Annual Conference & Exposition


Pittsburgh, Pennsylvania

Publication Date

June 22, 2008

Start Date

June 22, 2008

End Date

June 25, 2008



Conference Session

Two Year College Tech Session I

Tagged Division

Two Year College Division

Page Count


Page Numbers

13.350.1 - 13.350.10



Permanent URL

Download Count


Request a correction

Paper Authors

author page

Bertram Pariser Technical Career Institute, Inc.

author page

Cyrus Meherji Technical Career Institute, Inc.

Download Paper |

NOTE: The first page of text has been automatically extracted and included below in lieu of an abstract

Data Management for Outcomes and Assessment

Abstract Our college faculty has been inundated with requests for data concerning Outcomes and Assessments. Often the question on most of the faculty minds is what is the purpose of keeping all this data? Will it improve the quality of education that we provide? This question is academic because Middle States and Tac Abet are very concerned and required analyses of Outcomes and Assessments.

To comply with the tide that is sweeping higher education I have selected Microsoft Access as a starting point. In each class on the first day I set up an Assess data base for the semester. The class data is stored in a table in the Data Base which is constructed with four fields: First Name, Last Name, Telephone, and email address. As the students enter the class room on the first day they are required to enter their information into the table.

The data in the table is then transferred to a Microsoft Excel work sheet. The Excel file has different worksheets. The CLASS work sheet has the basic data. The CLASS work sheet serves to record attendance. The TEST work sheet is used to recorded test results and detail tabulations of each test question are recorded. The HOMEWORK work sheet is used to record homework. By using the Assess Data base as a starting point the complex task of recording and compiling data for Outcomes and Assessments is made more manageable.

TCI The College of Technology is located in New York City Diagonally across from Penn Station. The college is a two year college and the students receive an AS and AOS degrees. The college is accredited by Middle States Accreditation, New York State Accreditation and the EET department is accredited by TAC/ABET. The student population is 3000 and is composed of inner city students and foreign students TCI has over 100 different languages spoken and makes it second in the world in diversity second only to the United Nations.

Middle States Commission on Higher Education and the Technology Accreditation Commission of the Accreditation Board of Engineering and Technology (TAC/ABET) are very concerned and require Outcomes and Assessments at the course level as well as at the program level.

We are trying to approach Outcomes and Assessments from building a basic shell. This shell will be a database, a repository of information on the students that take a particular class. The database will contain the student’s personal information. The other part of the shell will be a spreadsheet created in EXCEL that will contain basic student data imported from ACCESS, test scores, attendance and homework. Each of the above categories will be a separate sheet in the EXCEL spreadsheet.

Primarily, we are going to build this shell and have the students populate the database with their personal information. Therefore, we will be concentrating on data collection in this paper. Data that will be collected and organized in this shell environment.


Pariser, B., & Meherji, C. (2008, June), Data Management For Outcomes And Assessment Paper presented at 2008 Annual Conference & Exposition, Pittsburgh, Pennsylvania. 10.18260/1-2--3489

ASEE holds the copyright on this document. It may be read by the public free of charge. Authors may archive their work on personal websites or in institutional repositories with the following citation: © 2008 American Society for Engineering Education. Other scholars may excerpt or quote from these materials with the same citation. When excerpting or quoting from Conference Proceedings, authors should, in addition to noting the ASEE copyright, list all the original authors and their institutions and name the host city of the conference. - Last updated April 1, 2015