班主任管理系统之使用
一、分配权限
![](https://wkrtcs.bdimg.com/rtcs/image?w=435.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"435.00","h":"260.00","dataType":"png","c":"word/media/image1.png","imgOriW":302,"imgOriH":180})
二、操作流程
1、按各校分派的班主任帐号与密码进入班主任管理系统
![](https://wkrtcs.bdimg.com/rtcs/image?w=408.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"408.00","h":"227.00","dataType":"png","c":"word/media/image2.png","imgOriW":673,"imgOriH":375})
2、进入后就能看到该班主任所在班的学生的基本信息
![](https://wkrtcs.bdimg.com/rtcs/image?w=642.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"642.00","h":"194.00","dataType":"png","c":"word/media/image3.png","imgOriW":1055,"imgOriH":263})
可以“列表方式浏览”或“照片方式浏览”，查看“家长信息”、“履历信息”、“奖励信息”、“处分信息”，特别建议不要去动“批量修改学生基础信息”。
3、将学生信息按![](https://wkrtcs.bdimg.com/rtcs/image?w=89.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"89.00","h":"31.00","dataType":"png","c":"word/media/image4.png","imgOriW":89,"imgOriH":31})
导出，保存，备用。
![](https://wkrtcs.bdimg.com/rtcs/image?w=419.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"419.00","h":"261.00","dataType":"png","c":"word/media/image5.png","imgOriW":459,"imgOriH":344})
4、点击![](https://wkrtcs.bdimg.com/rtcs/image?w=90.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"90.00","h":"44.00","dataType":"png","c":"word/media/image6.png","imgOriW":90,"imgOriH":44})
，选择打开，就能看到已经在“学籍管理系统”里做好的该年级的课程表，有课程编码、课程名称及相应学分。
![](https://wkrtcs.bdimg.com/rtcs/image?w=642.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"642.00","h":"152.00","dataType":"png","c":"word/media/image8.png","imgOriW":991,"imgOriH":235})
点击![](https://wkrtcs.bdimg.com/rtcs/image?w=51.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"51.00","h":"35.00","dataType":"png","c":"word/media/image9.png","imgOriW":51,"imgOriH":35})
，保存，备用。
5、点击![](https://wkrtcs.bdimg.com/rtcs/image?w=129.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"129.00","h":"50.00","dataType":"png","c":"word/media/image10.png","imgOriW":129,"imgOriH":50})
，就能看到
![](https://wkrtcs.bdimg.com/rtcs/image?w=642.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"642.00","h":"134.00","dataType":"png","c":"word/media/image11.png","imgOriW":742,"imgOriH":155})
在这里，对个别学生进行“单个录入学分”，对全班学生进行“批量导入学分”。还可按![](https://wkrtcs.bdimg.com/rtcs/image?w=149.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"149.00","h":"97.00","dataType":"png","c":"word/media/image12.png","imgOriW":149,"imgOriH":97})
查询每个学生的学分汇总情况。
下面以“批量导入学分”来说说操作流程：
1）点击![](https://wkrtcs.bdimg.com/rtcs/image?w=95.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"95.00","h":"31.00","dataType":"png","c":"word/media/image13.png","imgOriW":95,"imgOriH":31})
![](https://wkrtcs.bdimg.com/rtcs/image?w=642.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"642.00","h":"140.00","dataType":"png","c":"word/media/image14.png","imgOriW":978,"imgOriH":174})
点击![](https://wkrtcs.bdimg.com/rtcs/image?w=96.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"96.00","h":"30.00","dataType":"png","c":"word/media/image15.png","imgOriW":96,"imgOriH":30})
，保存
2）打开已下载的“学生信息”， 将表里的该班全部学生的姓名、学籍号“复制”再“粘贴”到该表A3、B3单元格；
![](https://wkrtcs.bdimg.com/rtcs/image?w=642.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"642.00","h":"212.00","dataType":"png","c":"word/media/image17.png","imgOriW":757,"imgOriH":247})
再打开已下载的“年级课程表”，将该年级某个学年该学的所有课程“复制”：先复制编码、名称两列； ![](https://wkrtcs.bdimg.com/rtcs/image?w=347.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"347.00","h":"128.00","dataType":"png","c":"word/media/image18.png","imgOriW":270,"imgOriH":99})
再在C1单元格中点鼠标右键，在快捷菜单中选择“选择性粘贴”
![](https://wkrtcs.bdimg.com/rtcs/image?w=245.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"245.00","h":"203.00","dataType":"png","c":"word/media/image19.png","imgOriW":392,"imgOriH":379})
再选择“转置”
即可把课程表里纵向的数据转置为横向数据
再“复制”学分列数据
![](https://wkrtcs.bdimg.com/rtcs/image?w=86.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"86.00","h":"106.00","dataType":"png","c":"word/media/image21.png","imgOriW":86,"imgOriH":106})
按上一步骤操作转置为横向数据
![](https://wkrtcs.bdimg.com/rtcs/image?w=621.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"621.00","h":"162.00","dataType":"png","c":"word/media/image22.png","imgOriW":595,"imgOriH":193})
注意：同一张Excel表可以同时填写若干科目及相应学分，只是高中文理分科后就得注意，理科生不导“文工方向”课程学分，文科生不导“理工方向”课程学分。
至此，《学分批量导入》模版已做完。“保存”
3）点击![](https://wkrtcs.bdimg.com/rtcs/image?w=64.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"64.00","h":"30.00","dataType":"png","c":"word/media/image23.png","imgOriW":64,"imgOriH":30})
，导入做好的《学分批量导入》文件，“浏览”、“读取”
![](https://wkrtcs.bdimg.com/rtcs/image?w=323.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"323.00","h":"313.00","dataType":"png","c":"word/media/image24.png","imgOriW":609,"imgOriH":588})
就在学籍系统界面里看到导入的数据了。如果出现如下情况，系统会提示你什么错误；
![](https://wkrtcs.bdimg.com/rtcs/image?w=642.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"642.00","h":"128.00","dataType":"png","c":"word/media/image25.png","imgOriW":856,"imgOriH":171})
如果全部正确，数据界面就不会有
此时，可以先把全部正确的数据![](https://wkrtcs.bdimg.com/rtcs/image?w=144.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"144.00","h":"36.00","dataType":"png","c":"word/media/image27.png","imgOriW":144,"imgOriH":36})
，再修改后再次读取导入，再。数据全部上传后，该界面就呈“空白”状态。
至此，《学分批量导入》数据全部进入学籍系统。
4）学分导入后，就能在![](https://wkrtcs.bdimg.com/rtcs/image?w=173.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"173.00","h":"153.00","dataType":"png","c":"word/media/image29.png","imgOriW":173,"imgOriH":153})
里按“课程类型”、“科目”、“年级段”进行查看与查询了。
5）![](https://wkrtcs.bdimg.com/rtcs/image?w=109.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"109.00","h":"33.00","dataType":"png","c":"word/media/image30.png","imgOriW":109,"imgOriH":33})
也按此流程操作。
![](https://wkrtcs.bdimg.com/rtcs/image?w=549.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"549.00","h":"164.00","dataType":"png","c":"word/media/image31.png","imgOriW":549,"imgOriH":164})
6）![](https://wkrtcs.bdimg.com/rtcs/image?w=97.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_4","w":"97.00","h":"35.00","dataType":"png","c":"word/media/image32.png","imgOriW":97,"imgOriH":35})
也按此流程操作。
![](https://wkrtcs.bdimg.com/rtcs/image?w=584.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_1","w":"584.00","h":"164.00","dataType":"png","c":"word/media/image33.png","imgOriW":584,"imgOriH":164})
7）![](https://wkrtcs.bdimg.com/rtcs/image?w=105.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_1","w":"105.00","h":"38.00","dataType":"png","c":"word/media/image34.png","imgOriW":105,"imgOriH":38})
只供班主任查询与导出，不作其他操作。
![](https://wkrtcs.bdimg.com/rtcs/image?w=642.00&md5sum=8e6ec7b0a1b8034c8e123acf342ea627&sign=dbf0aa62d5&rtcs_flag=1&rtcs_ver=4&l=webapp&bucketNum=595&ipr={"t":"img","r":"r_1","w":"642.00","h":"137.00","dataType":"png","c":"word/media/image35.png","imgOriW":986,"imgOriH":210})
6、要使用好系统里的“查询”功能，及时查漏补缺，做好数据的完整性。
三、建议
1、学校学籍管理员对全体班主任进行培训，此工作非学籍管理员一人能完成的，需要学校各职能部门及全体班主任大力协作。
2、年级组要统一进度，分块逐步完成，并将完成情况通报学籍管理员。
3、相互交流与学习，提高电子管理水平。
本文来源：https://www.2haoxitong.net/k/doc/590d85c0b5daa58da0116c175f0e7cd18525184f.html
文档为doc格式