Pittsburgh, Pennsylvania
June 22, 2008
June 22, 2008
June 25, 2008
2153-5965
Two Year College Division
10
13.350.1 - 13.350.10
10.18260/1-2--3489
https://peer.asee.org/3489
363
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.
1
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