Suen还能办选修课吗？

[TealParticle]

有很多老师会关心这个等级吗？以及这评分哪来的？我们数学老师非常受欢迎，但我发现他上学期只获得了C。刚刚去问他，他都不知道自己获得了C。

[suen]

大多會關心，尤其有評優需求的。
評分是學生打完，學校處理完，發教師希悅，忽略通知的可能看不到。

[WindWhisper]

笑死，老师自己都不知道得了C，这评分系统怕不是个摆设

[RuletheWaves]

但不是相对评分吗，总有40%的C。。。

[WindWhisper]

相对评分就更魔幻了，合着老师还得互相卷是吧

[TealParticle]

我随便看了几个，没看到有a的，不是b就是c。c居多。而且和我预想的完全不一样，很受欢迎的老师好多是c。奇妙。

[colas]

难道是mygo拉踩的工具

[suen]

佛印禪師與蘇東坡兩人是好朋友，有一次，兩人正在打坐時，蘇東坡忽然問佛印說：「佛印、佛印，你覺得我看起來像什麼？」佛印禪師隨即回答說：「我看施主像一尊佛。」接著，蘇東坡又問佛印禪師說：「那麼，你知道我看你像什麼嗎？」佛印禪師回答說不知道。蘇東坡很高興地說：「哈！哈！我看你像一堆牛糞。」蘇東坡心裡很得意，以為他這一回總算贏了佛印禪師。因此，他回家之後立刻把這件事情的經過告訴蘇小妹。有智慧的蘇小妹聽了之後卻語重心長地告訴蘇東坡：「其實，真正輸的人是你啊！佛印禪師心中有佛，所以看你就像是一尊佛；而你心中只有牛糞，才會看佛印禪師像一堆牛糞啊！ 」

[TealParticle]

其实可以考虑从企微或者什么地方，把所有老师名字弄出来，然后全部去下载那个链接，能汇总出所有老师的评教情况。但我发现有的老师不存在，不知道为什么。

[WindWhisper]

好家伙，这是要搞个评教大数据分析啊（doge）

[TealParticle]

A

张志豪, 宋姝莹, 强艳, 张冀翔, 高恺, 孙亚梅, 李茜, 郭莉, 邱天培, 李丹阳, 李瀚海, 李晓蓉, 郑田, 顾双双, 王耀杨, 朱倩, 熊保林, 韩忆楠, 张玉洁, 郭剑宇, 范梦翔, 蔡斯雨, 李亦辰, 陈淑珍, 魏丽, 梁好, 王昊, 王笑然, 黄永芳, 高嘉敏, 都晓梅, 吴涵, 熊晨珺, 姜丽娟, 刘丹, 李蒙, 杜洪见, 韩悦, 茹菲, 左小龙, 吴照洋

B

陈燕惠, 张景山, 沈莹, 徐柔, 贾文博, 辛已漫, 钟孔鹭, 李广丽, 易梦雅, 王㼆, 张利国, 李耕, 乔静, 王毅男, 王学凯, 李娟, 庞博, 徐雪婕, 付碧雯, 邢硕, 余骁扬, 罗山杉, 常青, 涂梦纯, 张雪皓, 李杰, 马葛, 赵雅萍, 汪歆之, 韩金阳, 魏运高丽, 刘铭玉, 薛楠, 罗易卓, 杜非凡, 陈娜, 单治超, 王欢, 魏胜昆

C

付孝谌, 楚尔轩, 王传伟, 徐昕婷, 柳迎春, 马宁, 方舟, 柏叶, 陈静, 贾鸿飞, 张妍妍, 陈亮, 李想, 韩校, 王楠, 尹丽媛, 张佳伟, 胡可隶, 卢卓成, 孙玉磊, 马浩成, 何志, 薄艺, 马芊, 张滨, 李宁, 韩玥, 王若晗, 赵艳, 陈绍楠, 祁越, 王悦, 张凯, 冀静, 于韬, 陈奕霖

无法获取xlsx

赵晓冬, 杜成孝, 郑灿, 蒋馨雨, 陈朋, 卢仁武, 吴蔚, 王廷赫, 刘苏杰, 马丽清, 徐小斌, 王斐, 赵春, 冯蕾, 沈阳, 周世杰, 万明灯, 陈怡然, 陈怡帆, 郭妍如, 马冰睿, 喻运星, 段海滨, 夏昀帆, 谭乔匀, 袁琦, 姚岚, 徐岩, 赵倚晴, 徐涯松, 翟海燕, 马晶, 李韧, 余时英, 赵瑞琪, 单超, 景志国, 刘银福, 刘扬, 李莹萌, 宇露, 陈艺平, 丁磊磊, 陈新月, 潘小双, 谭蓉, 戚光宇, 文浩博, 吴丹丹, 樊守慧, 李晓璐, 刘雪娇, 金文力, 盖跃, 肖然, 刘程程, 徐雪梅, 董芷卉, 周丽, 孙荏苒, 李子谦, 白成, 张亚慧, 陈舒昕, 杨慧珺, 马干卉, 王凌寒, 邓亦敏, 王刚, 王云鹏, 宾奕颉, 李勇成, 刘伊超, 邵壮, 刘晓洁, 陈亮（物理）, 王楚, 赵虹华, 李怡琳, 廖智捷, 马占江, 陈任翔, 陈文琪, 徐铭茁, 李慧玲, 顾春晖, 刘莹, 马少凯, 林以同, 周菲菲, 孙才奇, 王国华, 李小芹, 陈宣桦, 吴欣桐, 周添, 李形, 张书嘉, 杨晨波, 刘晶, 黄潇潇, 马慨, 费秀丽, 刘海涛, 白钰, 杜昊, 张长灏, 吴攀, 林怡昕, 刘尚林, 沈静, 霍梦真, 李杭媛, 戴颖, 孙永斌, 柯霁阳, 赵文世, 杨瑗瑄, 李琳琳, 冯海君, 邢前, 秦蕾, 于璇, 柳帅, 高燕, 何圣, 刘靖婧, 刘阳, 桑胜景, 高成, 陈秀子, 李长红, 杜晓宁, 石岳, 马冀豪, 王禹, 宋士红, 杨白洁, 张墨红, 姚延惠, 刘骥, 何琳, 李天艺, 魏燕, 陈新宇, 杨柳, 阮端祥, 陈雨栋, 李静, 杨博雅, 张晓琳, 刘思铭, 吴跃文, 杨兵, 杨晋焱, 郭菁, 石小秀, 孙玉秋, 周心涵

代码

import openpyxl
import requests
import os
from collections import defaultdict
from urllib.parse import quote

def download_file(url, local_path):
    """下载文件到本地"""
    try:
        response = requests.get(url, timeout=10)
        response.raise_for_status()
        with open(local_path, 'wb') as f:
            f.write(response.content)
        return True
    except Exception as e:
        print(f"下载失败 {e}")
        return False

def get_evaluation_from_xlsx(url):
    """从xlsx中获取评价等级"""
    local_path = "temp.xlsx"
    if not download_file(url, local_path):
        return None
    
    try:
        workbook = openpyxl.load_workbook(local_path)
        sheet = workbook.active
        
        for row in sheet.iter_rows():
            for cell in row:
                if cell.value == "教学评价等级":
                    below_cell = sheet.cell(row=cell.row + 1, column=cell.column)
                    if below_cell.value in ['A', 'B', 'C']:
                        return below_cell.value
                    else:
                        print(f"教学评价等级无效: {below_cell.value}")
        return None
    except Exception as e:
        print(f"处理Excel出错: {e}")
        return None
    finally:
        if os.path.exists(local_path):
            os.remove(local_path)

def classify_names(base_url, name_list):
    """分类人名"""
    unique_names = list(set(name_list))
    classification = defaultdict(list)
    classification['无法获取xlsx'] = []
    
    for name in unique_names:
        url = f"{base_url}/{quote(name)}.xlsx"
        evaluation = get_evaluation_from_xlsx(url)
        
        if evaluation:
            classification[evaluation].append(name)
        else:
            classification['无法获取xlsx'].append(name)
    
    return classification

# 使用
BASE_URL = f"https://seiue-chalkng.oss-cn-qingdao.aliyuncs.com/custom-uploaded/北大附中高中部/2024-25学年第二学期期末教学评价结果/教师评价总表"
names = ["戴颖","李琳琳","刘晶","马晶","马慨","秦蕾","吴跃文","杨兵","于璇","何志","陈亮（物理）","陈文琪","董芷卉","杜晓宁","郭菁","郭妍如","金文力","刘阳","李小芹","卢仁武","马冰睿","马干卉","石岳","王刚","万明灯","赵晓冬","朱倩","陈亮","吴欣桐","张志豪","常青","陈静","陈娜","陈朋","陈绍楠","陈秀子","陈燕惠","陈奕霖","陈艺平","陈怡然","楚尔轩","都晓梅","杜非凡","方舟","樊守慧","冯蕾","付碧雯","郭剑宇","郭莉","韩校","韩忆楠","韩玥","韩悦","何琳","黄潇潇","黄永芳","姜丽娟","景志国","柯霁阳","李丹阳","李广丽","李杰","林以同","李茜","李韧","刘骥","刘靖婧","柳帅","刘晓洁","刘扬","刘伊超","刘银福","李想","李怡琳","李莹萌","李长红","罗易卓","马葛","马浩成","马丽清","庞博","邱天培","祁越","石小秀","孙亚梅","孙玉磊","孙玉秋","谭蓉","王欢","王廷赫","王笑然","王悦","王云鹏","魏燕","文浩博","吴攀","吴照洋","夏昀帆","邢前","辛已漫","徐铭茁","徐涯松","杨瑗瑄","余骁扬","张滨","张凯","张墨红","张亚慧","赵瑞琪","赵文世","郑田","周丽","周添","李静","白成","宾奕颉","薄艺","陈任翔","陈淑珍","陈宣桦","陈怡帆","邓亦敏","段海滨","杜昊","付孝谌","盖跃","高嘉敏","顾春晖","胡可隶","霍梦真","贾鸿飞","贾文博","冀静","景志国","梁好","廖智捷","李杭媛","李慧玲","刘铭玉","李晓璐","马冀豪","马宁","乔静","阮端祥","茹菲","沈阳","孙永斌","谭乔匀","涂梦纯","王楚","王斐","王凌寒","王楠","汪歆之","王耀杨","王毅男","王禹","魏运高丽","吴丹丹","吴蔚","肖然","熊保林","徐小斌","徐雪婕","徐岩","杨白洁","杨晋焱","易梦雅","余时英","翟海燕","张佳伟","张冀翔","张利国","张书嘉","张玉洁","赵虹华","赵艳","周世杰","周心涵","马占江","白钰","柏叶","陈舒昕","高燕","顾双双","何圣","蒋馨雨","李耕","李娟","李宁","李天艺","刘雪娇","戚光宇","王㼆","王传伟","王若晗","王学凯","吴涵","辛已漫","薛楠","徐昕婷","姚岚","尹丽媛","袁琦","宇露","喻运星","张景山","张妍妍","张长灏","孙才奇","蔡斯雨","陈新宇","陈新月","陈雨栋","丁磊磊","杜成孝","杜洪见","范梦翔","费秀丽","冯海君","高成","高恺","顾春晖","韩金阳","李瀚海","李琳琳","李蒙","林怡昕","李形","刘程程","刘丹","刘海涛","刘尚林","刘思铭","刘苏杰","刘莹","柳迎春","李晓蓉","李亦辰","李勇成","李子谦","罗山杉","卢卓成","马晶","马芊","马少凯","潘小双","强艳","秦蕾","桑胜景","单超","单治超","邵壮","沈静","沈莹","宋士红","宋姝莹","孙荏苒","王国华","王昊","魏丽","魏胜昆","吴跃文","邢硕","熊晨珺","徐柔","徐雪梅","杨兵","杨博雅","杨晨波","杨慧珺","杨柳","姚延惠","于韬","张晓琳","张雪皓","赵春","赵雅萍","赵倚晴","郑灿","钟孔鹭","周菲菲","左小龙"]
result = classify_names(BASE_URL, names)

for category, name_list in sorted(result.items()):
    print(f"[details=\"{category}\"]\n{', '.join(name_list)}\n[/details]\n")

[TealParticle]

从企微拿了学科长、行知、元培、未名、预科的老师名单，尝试拿到xlsx并解析等级。为什么有这么多老师找不到的呢？不是很懂。

另外从名单来看，我怀疑学生的打分并不起很大作用？貌似有被学生骂厉害的老师拿到A，学生喜欢的老师拿到C。感觉更像是学校领导给老师们打的分

[dyyyy]

方舟马是不是打错了

[RuletheWaves]

可能和部门有关？

[TealParticle]

我看一下，很有可能有错，我直接从企微OCR的（（（

[TealParticle]

哦你说对，他名字后面在企微上有个那个电脑的标识，给识别成「马」了

[WindWhisper]

这么多老师找不到，怕不是系统在摸鱼（doge）

[gggggg]

芊咋可能。少男咋可能。

但是张凯活该。

[TealParticle]

ok修正了错误。

[TealParticle]

让我觉得「咋可能」的有不少（