Full-Text Search:
Home|Journal Papers|About CNKI|User Service|FAQ|Contact Us|中文
《Journal of Anhui Institute of Architecture & Industry(Natural Science)》 2008-05
Add to Favorite Get Latest Update

The using of software Excel in counting the marks of students and analysing of test paper

YU Neng-fu(Department of Mathematics & Physics,Anhui University of Architecture,Hefei,230601)  
This paper introduces the way to make grade assess table of students and test paper analysis module by using Excel,and the steps of using this module is also presented.Hence,the fast and exact statistical software to analyze the study status of students and teaching effect is proposed,and the effectiveness of this statistical software is shown by the example.Finally,the improvement advice is given according to the principle of education measurement.
【Fund】: 安徽建筑工业学院教学研究项目(2007JX26)
【CateGory Index】: TP311.52
Download(CAJ format) Download(PDF format)
CAJViewer7.0 supports all the CNKI file formats; AdobeReader only supports the PDF format.
【References】
Chinese Journal Full-text Database 3 Hits
1 LI Cui-mei(Computer Information Management College of Inner Mongolia Financial College,Hohhot 010051,China);Realizing Students' Score Statistics and Examination Paper Analysis Procedure By Use of Excel[J];Computer and Information Technology;2011-02
2 Liu Guangfu(College of Information and Controlling Engineering,China University of Petroleum(East China),Dongying 257061,China);The Experience of Grading Examination Paper of Electronics & Electrical Engineering Course[J];Value Engineering;2010-19
3 Liu Guangfu1,Yin Aizhen2(1.College of Information and Controlling Engineering; China University of Petroleum(East China), Dongying 257061, China;2.College of Economics and Management; China University of Petroleum(East China), Dongying 257061, China);Processing the Student Result Effectively with Excel[J];Microcomputer Applications;2010-10
【Co-citations】
Chinese Journal Full-text Database 10 Hits
1 LIU Ling,HE Shi-chao(College of Foreign Languages,Anhui Science and Technology University,Fengyang 233100,China);Investigation about the Current Situation and Reform of Scholastic Achievement Evaluation of English Majors[J];Journal of Anhui Science and Technology University;2009-06
2 YE Ren-yu (1 Mathematics and Computing Science School, Anhui University, Hefei 230039 , 2 Mathematics Dept. of Anqing Teachers College, Anqing 246011 , China);Application of Normal Testing in Teaching Quality Supervision[J];Journal of Anqing Teachers College(Natural Science Edition);2005-03
3 WU Xun(College of Mathematics and Computer Science,Anhui Normal University,Wuhu 241003,China);Using Factor Analysis to Evaluate Teaching Quality[J];Journal of Anqing Teachers College(Natural Science Edition);2011-01
4 XU Zhi-yong1,DING Shu-liang2,YANG Qing-hong2(1.Tianjin Municipal Educational Admission and Examinations Authority,Tianjin 300387,China;2.College of Computer Information Engineering,Jiangxi Normal University,Nanchang Jiangxi 330022,China);The Improved for S-P Chart Method and Application[J];Journal of Jiangxi Normal University(Natural Science Edition);2011-05
5 HAO Nai-lan1,WANG Shuang-wei2(1.Changchun Medical Higher Training School,Changchun 130031,China;2.Institute of Intelligent Calculation,Institute of Physics Education,Physics College,North-east Normal Univ.,Changchun 130024,China);Applications of Mode Rough Set Theory in the Motive Factor on Medical Physics Learning and on Analysis of Effect Relativity[J];Journal of Changchun Normal University;2007-12
6 HAO Nai-lan1,ZAHGN Li-ying2,WANG Sha-wei3,JIN Xing1(1.Medicine Department,Changchun Medicine College,Changchun 130031,China;2.Electronic Information and Engineering College,Changchun University,Changchun 130022,China;3.China-Japan Union Hospital,Changchun 130021,China);Mode rough set and its application in the analysis of motive and effect of physical experiment learning[J];Journal of Changchun University;2008-02
7 ZHANG Yi (A dministrative Science Department of Chongqing Electric Power College, Chongqing 400053);The Principal Component Analysis Model for the Students' Evaluation of the Teaching Quality[J];Journal of Chongqing Electric Power College;2005-04
8 Huang Xin-sheng:Pinghu Campus Jiaxin University;Appropriate Evaluation on the School Achievement of Students[J];Time Education;2012-13
9 Yin Xiaoling (Department of Mathematics and Computer Science,Chizhou College,Chizhou,Anhui 247000);An Analysis of Online Grading system[J];Journal of Chizhou College;2008-03
10 ZOU Li-hua(Study Quality Monitoring Center,Dalian Education University,Dalian 116021,China);Global Analysis of Physics Test Papers of Dalian High School Entrance Examination in Recent Years[J];Journal of Dalian Education University;2012-02
【Co-references】
Chinese Journal Full-text Database 8 Hits
1 GU Zhao-sheng,et al.(Faculty of Sciencl,ChangChun Institute of Technology,Changchun 130012,China);Analysis of test scores and relevant program design[J];Journal of Changchun Institute of Technology(Natural Sciences Edition);2007-01
2 ZHAI Li (Shanxi Finance and Tax College,Taiyuan 030024,China);Application of Statistical Method in Test Paper Analysis[J];Journal of Shanxi Finance and Tax College;2007-04
3 YANG Wang-li, WU Ya-juan, WANG Li-xia ( Computer Science and Engineering College, Daqing Petroleum Institute, Anda, Heilongjiang 151400, China );Design of grade analyzing and test paper quality evaluating system and its realization[J];Journal of Daqing Petroleum Institute;2002-02
4 SHEN Zhen,XIE Zhen-wan(Department of Physical Education,Jiangyin Polytechnic College,Jiangyin,Jiangsu,China 214433);Education Statistics in the Evaluation of college teaching in the Applied Research[J];Journal of Hubei Adult Education Institute;2009-06
5 ZHANG Ze-jiang;On the application skills of Excel in the quantity calculation[J];Shanxi Architecture;2009-10
6 ZHANG Hong,TANG Qing-lin,YIN Ke-lin,TANG Chun-mei(School of Horticultural and landscape,Southwest University,Chongqing 400716,China);PROGRAMMABLE COMPREHENSIVE EVALUATION OF STUDENTS' PERFORMANCE WITH EXCEL[J];Journal of Southwest Agricultural University(Social Science Edition);2007-03
7 XIONG De-zhi,LIU Wei-kai,NING Xiao-qing(School of Science,Wuhan Institute of Technology,Wuhan 430074,China);Analysis method on the quality of examination paper based on statistics[J];Journal of Wuhan Institute of Technology;2007-01
8 Yu Aibing (School of Mechanical Engineering, Tianjin University Tianjin 300072);Microsoft EXCEL Applied in Experimental Data Processing[J];Microcomputth Applications;2001-04
【Secondary References】
Chinese Journal Full-text Database 2 Hits
1 NIU Yongjie1 ZHANG Cheng2(1.Computing Center,Yan'an University,Yan'an 716000)(2.Network Center,Yan'an University,Yan'an 716000);Application Research of Ant Colony Algorithm in Testpaper Analysis[J];Computer & Digital Engineering;2012-04
2 LI Hua,ZHANG Wei-na(Computer and Network Center,Communication University of China,Beijing 100024,China);Design of Automatic Grading System for Standardized Examination Papers by Excel[J];Computer and Modernization;2012-01
©2006 Tsinghua Tongfang Knowledge Network Technology Co., Ltd.(Beijing)(TTKN) All rights reserved