![](/__local/9/9A/51/4F1A3E4CB8561D371DFD47727F9_58B4DB85_177EF.png)
进入服务大厅
![](/__local/2/CA/22/A5AB55B83E00FDCD494D4C73C6C_D7010584_EED2.png)
登录
![](/__local/A/F5/81/B90ACE0EEFBF1004A73B095A6FA_064EE453_4C7CB.png)
工号,密码
![](/__local/A/8E/C1/6E07E2FBFC1060DC7C1EDE1E0EB_30B7D727_6CAC.png)
点击左上角教务系统
![](/__local/4/87/1C/D24834B65D4DE143F844BEABE43_ED3E7C06_D6C5.png)
用户名(工号)和密码(初始密码是工号)
点击登陆后,系统提示修改初始密码
![](/__local/2/2C/32/04F880F6FD3C37C5A99045D9E71_2DBD83A6_6441.png)
登录成功后,点击右上角员工成绩录入
![](/__local/D/F9/2F/15CC32B80244FA172089A249957_80138658_2610.png)
选择点击右上角进入
![](/__local/4/A9/CA/89E8788D92206616C21C1872212_04DB2F12_4825.png)
设置平时成绩和期末成绩比重,填完数据后,点击设置
![](/__local/2/DC/A7/6DF5F796F4C1AA58C20700145DB_87C400D1_43D2.png)
点击确定
![](/__local/8/48/C6/334AC75F248998030A0FB912A46_7EAD0E23_48F2.png)
点击左上角导入成绩
![](/__local/6/65/A2/5DD89234E9A15038A472397C0BB_8FE586D3_3B4B.png)
点击模板下载:成绩录入数据导入模板
![](/__local/3/74/58/F9389C7DD2CD732AC9DB425A04D_057DC5E6_3911.png)
按照课序号重新命名(避免混乱)
![](/__local/C/6D/3F/A5B290AD7696500828FE1D36C6F_BCAF3805_7F31.png)
录入平成绩:如果大多数都是一个分数,可以拖动数字后面的小加号(有的word版本直接拖动即可,有些word版本需要按住Ctrl键拖动),调整较好或较差员工的平时成绩
![](/__local/1/2F/7C/AC1E8D45B29CBB2CD349BD17159_876B7D8E_455.png)
![](/__local/B/1C/2B/6870688B7C7503A479222B43F72_76E8690C_209.png)
![](/__local/2/D1/64/A52AC2CE8AFF22C8D3D6CC97268_2C53FD7E_5378.png)
打开课序号01班的期末成绩表
![](/__local/B/1B/CE/C5A4F9A9EEB5F1E246794F30645_2E9AAF49_288B.png)
删除表头的前三行,选中前三行,右键单击,删除,整行
![](/__local/3/8E/D8/B192A3811AFE20E2FDD44E770E5_BDF55F60_75C4.png)
![](/__local/3/25/7F/682BA88F364D284BF29A33C2FF6_8DF9B6F1_2F90.png)
删除后如上图
![](/__local/9/61/23/A7EA717FF648C9C4E67BAFFCFAB_1CD1D821_39C9.png)
选中学号栏C列,升序排序
![](/__local/B/49/A6/9A7F996F0365804FC346BE30AF6_3EA6DE69_422F.png)
升序排序
![](/__local/E/0E/C1/F045EB39C4C049B797D199C32FC_622376B0_5FF9.png)
点击排序
![](/__local/7/05/8D/469FBCFB4A8F544AEB82648511C_22A3E145_1DF0.png)
选中复制期末成绩列,粘贴至导出数据表格
![](/__local/A/5C/00/F6D24A115700C10E5099C7A003A_20A25216_63C8.png)
为避免缺考员工,请自行查阅最后一个同学数据是否对应,点击无误后保存
![](/__local/8/6D/3B/8123D45A70D14D17A83A8660F57_8DCCDFE2_3E69.png)
点击录入成绩
![](/__local/0/C8/4F/B9334CAD863DB7F564F270D710B_5C6C4B3A_7CF9.png)
导入成绩
![](/__local/8/75/95/E0171733D0A22D1908B424864EF_C1138E9C_5307.png)
选择文件,点击覆盖(自己)录入的成绩
![](/__local/7/50/B8/4AC2595E497871B3423A532A475_5C1F90A1_1C82B.png)
点击“导入数据”
![](/__local/2/97/EB/AE6CC14D9E53854D17085BC7468_228472EF_319E.png)
点击确定
![](/__local/6/20/83/D4DF1083F3AE0C59C4C5E9B55F5_C4F6DAD5_F589.png)
成绩录入成功,再认真查阅,点击保存
![](/__local/3/6E/F1/2C4C4E8F8452FC7859F4AF7574F_5F6FD501_9463.png)
准确无误后,点击“送审”(等同于原来的提交,就不能修改了)