Application of Excel VBA in Score Analysis for Specialty Accreditation

Abstract:

In the standard target system of specialty accreditation, assessed results of teaching process are required to reflect students level of mastering related knowledge. Examination score is the most direct and important reflection. In this paper, VBA programming was applied to generate score sheet of main curriculums in recent years which is required in self-assessment report for specialty accreditation. Firstly, original data were obtained from information management system of teaching affairs. They are teaching task files and class score sheet, which are all Excel files. Secondly, original data were handled by VBA according to requirement. Compulsory courses for civil engineering class and scores for first exams were selected. Thirdly, average scores and first passing rates were calculated. At last, a summary score sheet was produced which is helpful to analyze students learning effect and to find out reasons. Therefore, the efficiency of analyzing teaching results for specialty accreditation is greatly improved.

• Periodical: Applied Mechanics and Materials (Volumes 536-537)
• Pages: 574-577
• DOI: https://doi.org/10.4028/www.scientific.net/AMM.536-537.574
• Online since: April 2014
• Authors: De Ling Wang*, Jiang Hai Shen
• Keywords: Compulsory Course, Score Analysis, Score Sheet, Specialty Accreditation

References

[1] Jiaju Bi. Higher Education Development and Evaluation (in Chinese), Vol. 21(1) (2005), p.40.

[2] Jiaju Bi. Journal of High Architectural Education (in Chinese), Vol. 31(3) (1999), p.69.

[3] Bill Jelen and Tracy Syrstad: VBA and Macros for Microsoft Excel (Electrical Industry Press, Beijing, 2005).

[4] Huazhong Wei, Renlai Zhou and Jiansheng Ma: Education Statistics and Measurement (Liaoning Normal Press, Dalian, 1999).