注册 登录  
 加关注
   显示下一条  |  关闭
温馨提示!由于新浪微博认证机制调整,您的新浪微博帐号绑定已过期,请重新绑定!立即重新绑定新浪微博》  |  关闭

守望成长 静待花开

静下心来读书 潜下心来育人

 
 
 

日志

 
 

0951班语文成绩  

2010-06-23 22:25:40|  分类: 教法学法 |  标签: |举报 |字号 订阅

  下载LOFTER 我的照片书  |

        0951班2010年上期语文成绩统计表
学号 姓名 平时 期中 期末 总评 等第
1 郭子晔 85 88 87 86.7 =80,"优秀",IF(C3*0.3+D3*0.3+E3*0.4>=70,"良好",IF(C3*0.3+D3*0.3+E3*0.4>=60,"合格","待合格")))'>优秀
2 邹懿萱 95 74 90 86.7 =80,"优秀",IF(C4*0.3+D4*0.3+E4*0.4>=70,"良好",IF(C4*0.3+D4*0.3+E4*0.4>=60,"合格","待合格")))'>优秀
3 邹诗敏 75 63 69 69 =80,"优秀",IF(C5*0.3+D5*0.3+E5*0.4>=70,"良好",IF(C5*0.3+D5*0.3+E5*0.4>=60,"合格","待合格")))'>合格
4 巢怡 85 80 90 85.5 =80,"优秀",IF(C6*0.3+D6*0.3+E6*0.4>=70,"良好",IF(C6*0.3+D6*0.3+E6*0.4>=60,"合格","待合格")))'>优秀
5 李云煜 90 87 90 89.1 =80,"优秀",IF(C7*0.3+D7*0.3+E7*0.4>=70,"良好",IF(C7*0.3+D7*0.3+E7*0.4>=60,"合格","待合格")))'>优秀
6 黄鑫玉 80 75 79 78.1 =80,"优秀",IF(C8*0.3+D8*0.3+E8*0.4>=70,"良好",IF(C8*0.3+D8*0.3+E8*0.4>=60,"合格","待合格")))'>良好
7 陈雪斐 85 72 85 81.1 =80,"优秀",IF(C9*0.3+D9*0.3+E9*0.4>=70,"良好",IF(C9*0.3+D9*0.3+E9*0.4>=60,"合格","待合格")))'>优秀
8 毛静怡 85 75 83 81.2 =80,"优秀",IF(C10*0.3+D10*0.3+E10*0.4>=70,"良好",IF(C10*0.3+D10*0.3+E10*0.4>=60,"合格","待合格")))'>优秀
9 王琴熙梓 95 88 91 91.3 =80,"优秀",IF(C11*0.3+D11*0.3+E11*0.4>=70,"良好",IF(C11*0.3+D11*0.3+E11*0.4>=60,"合格","待合格")))'>优秀
10 周嘉郡 95 92 86 90.5 =80,"优秀",IF(C12*0.3+D12*0.3+E12*0.4>=70,"良好",IF(C12*0.3+D12*0.3+E12*0.4>=60,"合格","待合格")))'>优秀
11 陈泓涵 95 80 94 90.1 =80,"优秀",IF(C13*0.3+D13*0.3+E13*0.4>=70,"良好",IF(C13*0.3+D13*0.3+E13*0.4>=60,"合格","待合格")))'>优秀
12 刘晓静 65 55 62 60.8 =80,"优秀",IF(C14*0.3+D14*0.3+E14*0.4>=70,"良好",IF(C14*0.3+D14*0.3+E14*0.4>=60,"合格","待合格")))'>合格
13 袁心怡 80 57 83.5 74.5 =80,"优秀",IF(C15*0.3+D15*0.3+E15*0.4>=70,"良好",IF(C15*0.3+D15*0.3+E15*0.4>=60,"合格","待合格")))'>良好
14 秦焯敏 90 73 89 84.5 =80,"优秀",IF(C16*0.3+D16*0.3+E16*0.4>=70,"良好",IF(C16*0.3+D16*0.3+E16*0.4>=60,"合格","待合格")))'>优秀
15 杨晓璇 95 87 93 91.8 =80,"优秀",IF(C17*0.3+D17*0.3+E17*0.4>=70,"良好",IF(C17*0.3+D17*0.3+E17*0.4>=60,"合格","待合格")))'>优秀
16            
17 易齐贤 95 89 91 91.6 =80,"优秀",IF(C19*0.3+D19*0.3+E19*0.4>=70,"良好",IF(C19*0.3+D19*0.3+E19*0.4>=60,"合格","待合格")))'>优秀
18 张任驰 95 89 95 93.2 =80,"优秀",IF(C20*0.3+D20*0.3+E20*0.4>=70,"良好",IF(C20*0.3+D20*0.3+E20*0.4>=60,"合格","待合格")))'>优秀
19 刘小宝 75 56 75 69.3 =80,"优秀",IF(C21*0.3+D21*0.3+E21*0.4>=70,"良好",IF(C21*0.3+D21*0.3+E21*0.4>=60,"合格","待合格")))'>合格
20 李冠球 95 95 97 95.8 =80,"优秀",IF(C22*0.3+D22*0.3+E22*0.4>=70,"良好",IF(C22*0.3+D22*0.3+E22*0.4>=60,"合格","待合格")))'>优秀
21 吴昭辉 80 68 80 76.4 =80,"优秀",IF(C23*0.3+D23*0.3+E23*0.4>=70,"良好",IF(C23*0.3+D23*0.3+E23*0.4>=60,"合格","待合格")))'>良好
22 熊志高 85 78 75 78.9 =80,"优秀",IF(C24*0.3+D24*0.3+E24*0.4>=70,"良好",IF(C24*0.3+D24*0.3+E24*0.4>=60,"合格","待合格")))'>良好
23 胡子建 85 64 80 76.7 =80,"优秀",IF(C25*0.3+D25*0.3+E25*0.4>=70,"良好",IF(C25*0.3+D25*0.3+E25*0.4>=60,"合格","待合格")))'>良好
24 李庭轩 90 72 86 83 =80,"优秀",IF(C26*0.3+D26*0.3+E26*0.4>=70,"良好",IF(C26*0.3+D26*0.3+E26*0.4>=60,"合格","待合格")))'>优秀
25 肖沐野 80 67 83 77.3 =80,"优秀",IF(C27*0.3+D27*0.3+E27*0.4>=70,"良好",IF(C27*0.3+D27*0.3+E27*0.4>=60,"合格","待合格")))'>良好
26 庞鹏 90 79 89 86.3 =80,"优秀",IF(C28*0.3+D28*0.3+E28*0.4>=70,"良好",IF(C28*0.3+D28*0.3+E28*0.4>=60,"合格","待合格")))'>优秀
27 赵和成 85 80 86 83.9 =80,"优秀",IF(C29*0.3+D29*0.3+E29*0.4>=70,"良好",IF(C29*0.3+D29*0.3+E29*0.4>=60,"合格","待合格")))'>优秀
28 谭智宇 80 63 86 77.3 =80,"优秀",IF(C30*0.3+D30*0.3+E30*0.4>=70,"良好",IF(C30*0.3+D30*0.3+E30*0.4>=60,"合格","待合格")))'>良好
29 章行健 85 74 85 81.7 =80,"优秀",IF(C31*0.3+D31*0.3+E31*0.4>=70,"良好",IF(C31*0.3+D31*0.3+E31*0.4>=60,"合格","待合格")))'>优秀
30 黄国钰 85 74 95 85.7 =80,"优秀",IF(C32*0.3+D32*0.3+E32*0.4>=70,"良好",IF(C32*0.3+D32*0.3+E32*0.4>=60,"合格","待合格")))'>优秀
31 周政武 70 61 63 64.5 =80,"优秀",IF(C33*0.3+D33*0.3+E33*0.4>=70,"良好",IF(C33*0.3+D33*0.3+E33*0.4>=60,"合格","待合格")))'>合格
32 黄靖怡 90 66 83 80 =80,"优秀",IF(C34*0.3+D34*0.3+E34*0.4>=70,"良好",IF(C34*0.3+D34*0.3+E34*0.4>=60,"合格","待合格")))'>优秀
33 顾文琦 90 79 79 82.3 =80,"优秀",IF(C35*0.3+D35*0.3+E35*0.4>=70,"良好",IF(C35*0.3+D35*0.3+E35*0.4>=60,"合格","待合格")))'>优秀
总分2699.5   

      人 平:         84

  评论这张
 
阅读(367)| 评论(0)
推荐 转载

历史上的今天

在LOFTER的更多文章

评论

<#--最新日志,群博日志--> <#--推荐日志--> <#--引用记录--> <#--博主推荐--> <#--随机阅读--> <#--首页推荐--> <#--历史上的今天--> <#--被推荐日志--> <#--上一篇,下一篇--> <#-- 热度 --> <#-- 网易新闻广告 --> <#--右边模块结构--> <#--评论模块结构--> <#--引用模块结构--> <#--博主发起的投票-->
 
 
 
 
 
 
 
 
 
 
 
 
 
 

页脚

网易公司版权所有 ©1997-2017