{"id":1343,"date":"2017-05-10T09:42:21","date_gmt":"2017-05-10T01:42:21","guid":{"rendered":"https:\/\/emt.bjtu.edu.cn\/cn\/?p=1343"},"modified":"2022-07-03T17:38:40","modified_gmt":"2022-07-03T09:38:40","slug":"score_centum_to_penta_grade","status":"publish","type":"post","link":"https:\/\/emt.bjtu.edu.cn\/cn\/score_centum_to_penta_grade\/","title":{"rendered":"\u8003\u8bd5\u6210\u7ee9\u767e\u5206\u5236\u8f6c\u4e94\u7ea7\u5236Excel\u516c\u5f0f"},"content":{"rendered":"\n

\u5c06\u8003\u8bd5\u6210\u7ee9\u4ece\u767e\u5206\u5236\u8f6c\u6362\u5230\u4e94\u7ea7\u5236\u771f\u662f\u4e00\u4ef6\u5947\u4e8b\uff0c\u4e94\u7ea7\u5236\u6709\u4e94\u7ea7\u4e5d\u6bb5\u5236\u548c\u5341\u4e8c\u6bb5\u5236\uff0c\u6709\u7684\u6709A+\uff0c\u6709\u7684\u6ca1\u6709\uff0c\u767e\u5206\u5236\u5206\u6570\u4e0eABCDEF\u7684\u5bf9\u5e94\u4e5f\u5343\u5947\u767e\u602a\uff0c\u6bcf\u4e2a\u4eba\u90fd\u6709\u81ea\u5df1\u7684\u7406\u89e3\u3002\u611f\u89c9\u5c31\u50cf\uff1aThere are a thousand Hamlets in a thousand people’s eyes\u3002<\/p>\n\n\n\n

\u8d76\u7d27\u67e5MOE\uff08Ministry of Education\uff09\uff0c\u6ca1\u6709\u67e5\u5230\uff0c\u60f3\u67e5MOM\uff08The Ministry of Magic\uff09\uff0c\u62c5\u5fc3\u4e0d\u9002\u7528\u6211\u4eecMuggle\u3002<\/p>\n\n\n\n

\u8d76\u7d27\u767e\u5ea6\uff0c\u7248\u672c\u592a\u591a\uff0c\u6709\u4eba\u8d34\u51fa\u4e86C\u548cPython\u4ee3\u7801\uff0c\u4f46\u6807\u51c6\u4e0d\u5bf9\u3002\u8d76\u7d27Bing\uff0c\u7248\u672c\u66f4\u591a\uff0c\u6709\u4eba\u751a\u81f3\u5f00\u53d1\u4e86\u8ba1\u7b97\u7f51\u7ad9\uff0cLook\uff1a<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n
\"\"<\/a><\/figure>\n\n\n\n

————————————<\/p>\n\n\n\n

2020.6.23 \u53d1\u73b0<\/strong><\/p>\n\n\n\n

\u6211\u95ee\u4e86\u81ea\u5df1\u7684\u5b66\u751f\uff0c\u5b66\u751f\u627e\u51fa\u4e86\u300a\u5317\u4eac\u4ea4\u901a\u5927\u5b66\u672c\u79d1\u751f\u8bfe\u7a0b\u8003\u6838\u4e0e\u6210\u7ee9\u7ba1\u7406\u529e\u6cd5\u300b\u6587\u4ef6\uff0c\u6587\u4ef6\u4e2d\u89c4\u5b9a\u5982\u4e0b\uff1a<\/p>\n\n\n\n

\u767e\u5206\u5236\u6210\u7ee9<\/span><\/strong><\/td>\u4e94\u7ea7\u5236\u6210\u7ee9<\/span><\/strong><\/td>\u7ee9\u70b9<\/span><\/strong><\/td><\/tr>
100-90<\/td>A<\/td>4<\/td><\/tr>
89-85<\/td>A-<\/td>3.7<\/td><\/tr>
84-81<\/td>B+<\/td>3.3<\/td><\/tr>
80-78<\/td>B<\/td>3<\/td><\/tr>
77-75<\/td>B-<\/td>2.7<\/td><\/tr>
74-72<\/td>C+<\/td>2.3<\/td><\/tr>
71-68<\/td>C<\/td>2<\/td><\/tr>
67-65<\/td>C-<\/td>1.7<\/td><\/tr>
64-63<\/td>D+<\/td>1.3<\/td><\/tr>
62-60<\/td>D<\/td>1<\/td><\/tr>
60\u4ee5\u4e0b<\/td>F<\/td>0<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n

\u6309BJTU\u6807\u51c6\uff0c\u4e0d\u7528\u5199\u7a0b\u5e8f\uff0c\u5728Excel\u4e2d\u76f4\u63a5\u8ba1\u7b97\uff1a\uff08\u5176\u4ed6\u6807\u51c6\u53ef\u5bf9\u7167\u4e0b\u9762\u516c\u5f0f\u6539\u6539\uff0c\u6ce8\u610f\u6709\u62ec\u53f7\u4e2a\u6570\u3002\uff09<\/p>\n\n\n\n

=
if(Q2>=90,”A”,
if(Q2>=85,”A-“,
if(Q2>=81,”B+”,
if(Q2>=78,”B”,
if(Q2>=75,”B-“,
if(Q2>=72,”C+”,
if(Q2>=68,”C”,
if(Q2>=65,”C-“,
if(Q2>=63,”D+”,
if(Q2>=60,”D”,
“F”))))))))))<\/p>\n\n\n\n

\u53bb\u6389\u56de\u8f66\u7b26\u53f7\u5982\u4e0b\uff1a<\/p>\n\n\n\n

=if(C2>=90,”A”,if(C2>=85,”A-“,if(C2>=81,”B+”,if(C2>=78,”B”,if(C2>=75,”B-“,if(C2>=72,”C+”,if(C2>=68,”C”,if(C2>=65,”C-“,if(C2>=63,”D+”,if(C2>=60,”D”,”F”))))))))))<\/p>\n\n\n\n

\u5c06\u4e0a\u9762\u7684\u7eff\u8272\u8ba1\u7b97\u516c\u5f0f\u62f7\u8d1d\u5230\u4f60\u7684\u8bb0\u4e8b\u672c\uff08or Notepad++ etc.\uff09\uff0c\u66ff\u6362\u5176\u4e2d\u7684Q2\u4e3a\u4f60\u7684\u6210\u7ee9\u6240\u5728\u7684\u5217\u5355\u5143\u683c\uff0c\u7136\u540e\u62d6\u52a8Excel\u5355\u5143\u683c\u8ba1\u7b97\u5373\u53ef\u3002<\/p>\n\n\n\n

\u62f7\u8d1d\u4e0a\u9762\u7684\u516c\u5f0f\u6709\u53ef\u80fd\u7531\u4e8e\u5206\u53f7\u81ea\u52a8\u8f6c\u6362\u4e0d\u80fd\u4f7f\u7528\uff0c\u6700\u53ef\u9760\u7684\u505a\u6cd5\uff0c\u4e0b\u8f7d\u5982\u4e0bExcel\uff0c\u770b\u4f8b\u5b50\uff0c\u4ece\u4e2d\u62f7\u8d1d\u516c\u5f0f\uff1a<\/strong><\/span><\/p>\n\n\n\n

CalculationExample<\/a>\u4e0b\u8f7d<\/a><\/div>\n\n\n\n

<\/p>\n\n\n\n

2022.7.3 <\/h4>\n\n\n\n

\u6211\u4ece\u6211\u4eec\u4ea4\u5927\u672c\u79d1\u6bd5\u4e1a\u751f\u7684\u6210\u7ee9\u5355\u4e2d\u770b\u5230\u7684\uff0c\u8fd9\u4e2a\u622a\u56fe\u8d77\u7801\u5728\u4ea4\u5927\u6743\u5a01\u4e86\uff1a<\/p>\n\n\n\n

\"\"<\/a><\/figure>\n\n\n\n

END.<\/p>\n","protected":false},"excerpt":{"rendered":"

\u5c06\u8003\u8bd5\u6210\u7ee9\u4ece\u767e\u5206\u5236\u8f6c\u6362\u5230\u4e94\u7ea7\u5236\u771f\u662f\u4e00\u4ef6\u5947\u4e8b\uff0c\u4e94\u7ea7\u5236\u6709\u4e94\u7ea7\u4e5d\u6bb5\u5236\u548c\u5341\u4e8c\u6bb5\u5236\uff0c\u6709\u7684\u6709A+\uff0c\u6709\u7684\u6ca1\u6709\uff0c\u767e\u5206\u5236\u5206\u6570\u4e0eA… \u9605\u8bfb\u66f4\u591a »\u8003\u8bd5\u6210\u7ee9\u767e\u5206\u5236\u8f6c\u4e94\u7ea7\u5236Excel\u516c\u5f0f<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":3341,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"neve_meta_sidebar":"","neve_meta_container":"","neve_meta_enable_content_width":"","neve_meta_content_width":0,"neve_meta_title_alignment":"","neve_meta_author_avatar":"","neve_post_elements_order":"[\"title\",\"meta\",\"content\",\"tags\",\"comments\",\"post-navigation\"]","neve_meta_disable_header":"","neve_meta_disable_footer":"","neve_meta_disable_title":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-1343","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/posts\/1343","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/comments?post=1343"}],"version-history":[{"count":12,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/posts\/1343\/revisions"}],"predecessor-version":[{"id":3942,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/posts\/1343\/revisions\/3942"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/media\/3341"}],"wp:attachment":[{"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/media?parent=1343"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/categories?post=1343"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/emt.bjtu.edu.cn\/cn\/wp-json\/wp\/v2\/tags?post=1343"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}