XLS《第六周》

第六周 "14中药1班计算机基础MOOC实践平时成绩测评表" "第七周测评人: 肖海鹏 日期:2014年10 月27 日――2014年11 月3日" "账号","姓名","观看 视频总数","观看 视频总分","视频 最高反刍比","视频综合评分","小节测试得分","互评作业得分","网络讨论","本周 综合成绩" "2013A410335 ","刘泽文",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310101 ","张杰",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310102 ","宋娟",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310103 ","殷旺",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310104 ","宁坤钰",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310105 ","罗美平",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310106 ","邹伊玲",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310107 ","郑迪",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310108 ","喻妮姿",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310109 ","龚洁",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310110 ","陈佳英",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310111 ","唐乐菲",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310112 ","贺刘洋",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310113 ","曾诗涵",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310114 ","贺钰婷",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310115 ","彭琴",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310116 ","廖婷",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310117 ","钱思宇",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310118 ","吴玉萍",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310119 ","阳泽军",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310120 ","胡云",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310121 ","阳凤",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310122 ","兰宁玲",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310123 ","吴娟",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310124 ","张雪冰",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310125 ","王旭",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310126 ","向清清",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310127 ","侯妮",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310128 ","蒋建丛",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310129 ","李双",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310130 ","姜巧",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310131 ","苑丹丹",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310132 ","李星枚",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310133 ","盛智凌",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310134 ","仇明珠",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310135 ","郭金枝",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310136 ","谢宇鹏",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310137 ","吴赛琴",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310138 ","马江南",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310139 ","张凯",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310140 ","曾宇丹",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310141 ","石观雄",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310142 ","吕祥施",,

0,,

#DIV/0!,,

,,

#DIV/0! "2014A310143 ","王洁",,

0,,

#DIV/0!,,

,,

#DIV/0! "教学视频总数:",,

6,,

,,

,,

, "评分标准:

1、视频总分=(已观看视频数量/视频总数)*100

2、视频综合评分=视频总分/最高反刍比

3、小节测验得分=小节测验实际分

4、网络讨论得分=参与1次得100分

5、互评作业得分=实际得分

6、综合成绩=视频综合得分*15%+小节测验得分*50%+互评作业得分*30%+网络讨论得分*5%