CAJ | 학술논문

针对高校课程考核方式的变化而带来成绩处理复杂化的问题，利用Excel相关函数可大大提高工作效率和数据处理的准确性。以青岛滨海学院期末总评成绩生成及统计分析为例，使用Excel中的相关函数对成绩表进行数据处理，并使用图表和自定义图表来创建成绩直方图，实践应用证明，该方法有效提高了工作效率。
침대고교과정고핵방식적변화이대래성적처리복잡화적문제，이용Excel상관함수가대대제고공작효솔화수거처리적준학성。이청도빈해학원기말총평성적생성급통계분석위례，사용Excel중적상관함수대성적표진행수거처리，병사용도표화자정의도표래창건성적직방도，실천응용증명，해방법유효제고료공작효솔。
To address the complexity of score processing that comes with the method changes of course assessment in post sec-ondary institutions, Excel relevant functions can help to improve the productivity and the accuracy of the data processing. In this article, the final examination assessment generation and statistics analysis of Qingdao Binhai University are taken as the example to use of the relevant Excel function of the score table for data processing, and the use of charts and custom chart to create achievement histogram. The conclusion proves that this method can effectively improve the work efficiency.