成绩册与学期结算
Gradebook & term closeout
Set weights, enter and curve grades, and close a term correctly.
20 条本项目编写的提案 · 分类 v1.1 · 新增基准运行 0 次。下方验证方式与部分得分规则是设计,不是执行结果。
历史小类地址:R10.05.01.02 · 提案 ID 保留原值。
- 典型应用
- Canvas Gradebook · Moodle Grader · PowerSchool
- 小类 GUI 需求标签
HY· 混合
任务提案 · 20
展开查看完整原文与建议检查方式;两种界面均保留提案英文原文。
R10.05.01.02-T01 Set weighted gradebook categories with a dropped lowest homework
原始指令
Moodle 4.x sandbox, course BIO101-F26, Gradebook setup. Create categories Homework (weight 40%, drop the lowest 1) and Exams (60%), move the 8 homework assignments and 2 exams into them, and set the course total aggregation to Weighted mean of grades. Do not change any existing grades.
- 平台
web· 任意系统(网页)- 应用
- Moodle Grader
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
click· 指向与点击drag· 拖放type· 文字与表单- 工作产物
WP08· 应用 / 系统状态- 条件
- 未声明
- 提案难度
- 2 / 5
建议验证方式
grade_categories: aggregation, droplow=1 on Homework; grade_items aggregationcoef weights 40/60; item parents correct; grade_grades finalgrade for items unchanged (raw). Web services are disabled for the role and the agent has no server shell; only web-origin log events are accepted.
建议部分得分
30% categories; 30% weights and aggregation; 20% drop lowest; 20% items placed, grades untouched.
R10.05.01.02-T02 Override, lock and hide grade items in the Moodle grader report
原始指令
Moodle sandbox, course PSYC200-F26 grader report. Override the course final grade for the 2 students with approved medical excusals in input/excusals.pdf to the values stated there with feedback 'Medical excusal - see Dean memo', lock the Midterm grade item, and hide Quiz 3 from students until 2026-12-20.
- 平台
web· 任意系统(网页)- 应用
- Moodle Grader
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
click· 指向与点击type· 文字与表单nav· 平移 / 缩放 / 滚动- 工作产物
WP08· 应用 / 系统状态- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
grade_grades: 2 course-total rows overridden with values and feedback exact; Midterm grade_item locked; Quiz 3 hidden until the timestamp. No other overrides. Web services are disabled for the role and the agent has no server shell; web-origin logs required (grade override events).
建议部分得分
45% overrides with feedback; 25% lock; 30% hide-until.
R10.05.01.02-T03 Apply a ten-percent-per-day late penalty to four submissions
原始指令
Canvas LMS sandbox, course 'HIST 210 (sandbox)'. Per input/late_policy.pdf (10% of possible points per calendar day late, capped at 50%, deadline extensions in input/extensions.csv honored), adjust the scores of the late submissions on 'Research Paper' in SpeedGrader or the gradebook and leave a comment stating days late and penalty.
- 平台
web· 任意系统(网页)- 应用
- Canvas Gradebook
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
type· 文字与表单click· 指向与点击- 工作产物
WP08· 应用 / 系统状态- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Submission scores equal gold (4 penalized; 1 late submission covered by an extension stays unpenalized); comments contain days late and penalty; no other scores changed. Agent has no API token.
建议部分得分
60% penalized scores; 20% extension honored; 20% comments.
R10.05.01.02-T04 Curve an exam in Excel and import the curved scores
原始指令
Export the Canvas gradebook for 'CHEM 120 (sandbox)', compute a linear curve for 'Exam 2' in Excel so the class mean becomes 75 with no score above 100 (scores already at or above 100 stay), then import the curved scores via the gradebook CSV import, reviewing the import preview so only Exam 2 changes.
- 平台
web· 任意系统(网页)mac· macOSwin· Windows- 应用
- Canvas Gradebook · Excel
- 交互表面
brow· 浏览器desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
click· 指向与点击code· 代码与命令multi· 跨应用- 工作产物
WP08· 应用 / 系统状态- 条件
multiapp· 多应用- 提案难度
- 4 / 5
建议验证方式
Exam 2 scores equal gold curve (within 0.01); all other columns unchanged; curved mean 75 +/- 0.05 computed over non-excused students only (2 excused seeded).
建议部分得分
45% curve math; 15% excused handling; 40% clean import affecting only Exam 2.
R10.05.01.02-T05 Set assignment-group weights and excuse items in Canvas
原始指令
Canvas sandbox, course 'MATH 105 (sandbox)'. Turn on weighted assignment groups (Homework 30, Quizzes 20, Exams 50), set Homework to drop lowest 2, mark the excused assignments in input/excused.csv as Excused (not zero), and record the resulting current grade for students s201, s214 and s233 in output/check.json.
- 平台
web· 任意系统(网页)- 应用
- Canvas Gradebook
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
click· 指向与点击type· 文字与表单- 工作产物
WP08· 应用 / 系统状态- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Course apply_assignment_group_weights true with exact weights; drop rule; 7 submissions with excused=true; check.json grades equal Canvas-computed values after changes (grader recomputes from export). Personal access token creation is disabled for the agent's role, so Canvas API calls are blocked and changes must be made in the Gradebook UI.
建议部分得分
35% weights; 15% drop rule; 30% excused; 20% check values.
R10.05.01.02-T06 Repair a broken Moodle backup and rebuild registrar and OneRoster exports
原始指令
input/course_backup.mbz (Moodle) fails to restore: grade_items references are inconsistent and two category weights do not sum. Repair the backup offline, recompute every student's final grade per input/grading_policy.pdf, and produce output/registrar.csv (student id, final %, letter) and OneRoster 1.2 results.csv and lineItems.csv for the SIS.
- 平台
lin· Linux- 应用
- Python · Moodle backup tools
- 交互表面
term· 终端- GUI 需求 · 任务设定
CL· CLI 足够- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令- 工作产物
WP02· 记录 / 表格- 条件
long· 长流程- 提案难度
- 5 / 5
建议验证方式
Repaired .mbz restores on a clean Moodle (grader CLI restore succeeds); registrar.csv finals within 0.01 and letters exact vs hidden reconciliation; OneRoster files schema-valid with sourcedId cross-references consistent.
建议部分得分
30% backup restores; 40% final grades and letters; 30% OneRoster exports valid and consistent.
R10.05.01.02-T07 Enter twenty-five scores with quick grading in a Moodle assignment
原始指令
Moodle sandbox, course BIO101-F26, assignment 'Lab Report 2'. Using the grading table with quick grading enabled, enter the 25 scores and short feedback comments from input/lab2_scores.pdf (a photographed paper sheet) and save.
- 平台
web· 任意系统(网页)- 应用
- Moodle Grader
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
type· 文字与表单vis· 视觉判断- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 2 / 5
建议验证方式
assign_grades rows for 25 students equal gold; feedback comments exact; handwriting on 3 seeded scores; no other assignment touched. Web services are disabled for the role and the agent has no server shell; only web-origin log events are accepted.
建议部分得分
70% scores; 30% feedback comments.
R10.05.01.02-T08 Enter scores with missing, late and exempt flags in PowerTeacher Pro
原始指令
PowerSchool PowerTeacher Pro (sandbox district), section 'Algebra I - P2'. For assignment 'Unit 4 Test' enter the 28 scores from input/unit4.xlsx, set flags Missing, Late, Exempt and Incomplete as the sheet indicates (Missing scores as 0, Exempt excluded), and override one student's quarter grade per input/override_note.pdf with the required comment.
- 平台
web· 任意系统(网页)- 应用
- PowerSchool PowerTeacher Pro · Excel
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G3· 仅 GUI- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
type· 文字与表单click· 指向与点击multi· 跨应用- 工作产物
WP08· 应用 / 系统状态- 条件
licensed· 授权专业软件multiapp· 多应用- 提案难度
- 3 / 5
建议验证方式
Sandbox DB: 28 scores exact; flag set per student exact; Exempt not counted; quarter override value and comment exact. Teacher role has no API; audit trail shows web entries.
建议部分得分
50% scores; 30% flags; 20% override with comment.
R10.05.01.02-T09 Score standards and compute final standards grades by district method
原始指令
PowerTeacher Pro sandbox, section 'Grade 5 Science'. Enter standards scores (1-4) for 3 assessments from input/standards_scores.xlsx, set the standards calculation method to the district's 'Most Recent 3 Weighted' rule in input/district_sbg.pdf, and verify the computed final standard grades for 5 listed students against your own calculation; record any discrepancy in output/sbg_check.csv.
- 平台
web· 任意系统(网页)- 应用
- PowerSchool PowerTeacher Pro · Excel
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G3· 仅 GUI- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
type· 文字与表单click· 指向与点击multi· 跨应用- 工作产物
WP08· 应用 / 系统状态- 条件
licensed· 授权专业软件multiapp· 多应用- 提案难度
- 4 / 5
建议验证方式
Standards scores exact (84 entries); calculation method setting exact; sbg_check.csv values equal the rule applied to the data (gold) and flags exactly the seeded student where PowerSchool's displayed value differs due to an exempt score. PowerSchool plugin/API credentials are withheld from the teacher account, so scores must be entered in PowerTeacher Pro (change log checked).
建议部分得分
45% scores; 20% method setting; 35% verification file.
R10.05.01.02-T10 Post midterm grades for two sections and keep the others hidden
原始指令
Canvas sandbox, cross-listed course 'BIO 200 (sandbox)' with sections A, B, C. Set the 'Midterm' grade posting policy to manual, then post grades only for sections A and B after confirming every submission in those sections is graded; section C must stay hidden.
- 平台
web· 任意系统(网页)- 应用
- Canvas Gradebook
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
click· 指向与点击nav· 平移 / 缩放 / 滚动- 工作产物
WP08· 应用 / 系统状态- 条件
risk· 高风险 / 不可逆- 提案难度
- 3 / 5
建议验证方式
Assignment post_manually true; submissions posted_at set for all A and B students and null for C; no ungraded submissions in A/B at post time (2 seeded ungraded must be graded from input/remaining_scores.csv first). Personal access token creation is disabled for the agent's role, so Canvas API calls are blocked and posting must be done in the Gradebook UI.
建议部分得分
20% manual policy; 30% remaining grades entered; 40% A/B posted; 10% C hidden.
R10.05.01.02-T11 Close out a Canvas term: zero missing work, export SIS grades, conclude
原始指令
Canvas sandbox, course 'ECON 200 (sandbox)', term ended. Per input/closeout_checklist.pdf: confirm every assignment is graded or excused, apply the missing-is-zero policy to past-due missing submissions, check final letter grades with the course grading scheme, export final grades in the registrar format of input/sis_template.csv, then conclude the course.
- 平台
web· 任意系统(网页)- 应用
- Canvas Gradebook · Excel
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
click· 指向与点击nav· 平移 / 缩放 / 滚动multi· 跨应用- 工作产物
WP02· 记录 / 表格- 条件
risk· 高风险 / 不可逆multiapp· 多应用hidden· 隐藏 / 过期状态- 提案难度
- 4 / 5
建议验证方式
Missing submissions scored 0 (gold set; excused untouched); export file rows equal Canvas final grades in template format; course workflow_state concluded only after export (timestamp order).
建议部分得分
30% missing policy; 15% all graded/excused; 35% SIS export; 20% concluded after export.
R10.05.01.02-T12 Process six regrade requests and recompute borderline letter grades
原始指令
Moodle sandbox, course CHEM110-F26. input/regrades/ has 6 regrade requests with the original exam pages and rubric. Decide each per the rubric, update the item scores with feedback, check how each change moves the student's course total across the letter boundaries (Moodle rounding settings apply), and log decisions and letter changes in output/regrade_log.xlsx.
- 平台
web· 任意系统(网页)mac· macOSwin· Windows- 应用
- Moodle Grader · Excel
- 交互表面
brow· 浏览器desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
vis· 视觉判断type· 文字与表单multi· 跨应用- 工作产物
WP08· 应用 / 系统状态- 条件
multiapp· 多应用hidden· 隐藏 / 过期状态- 提案难度
- 5 / 5
建议验证方式
Regrade decisions equal gold (4 granted with exact points, 2 denied); grades and feedback updated; log letter changes equal Moodle-computed letters after updates (one seeded case flips only because of the course's decimal rounding setting).
建议部分得分
45% regrade decisions; 20% gradebook updates; 35% letter-change log.
R10.05.01.02-T13 Compute final grades in Excel from a gradebook export and flag cutoff cases
原始指令
input/gradebook_export.csv is a Canvas export (60 students, 22 assignments). In Excel compute each student's final percentage using the weights and drop rules in input/syllabus_grading.pdf, map to letters with the given scheme, and flag students within 0.5 points below a letter cutoff. Save output/finals.xlsx with formulas intact.
- 平台
mac· macOSwin· Windows- 应用
- Excel
- 交互表面
desk· 桌面 GUI- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
CL· CLI 足够- 交互原语
code· 代码与命令type· 文字与表单- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Final percentages within 0.01 of gold; letters exact; flagged set exact; cells contain formulas (not pasted values) referencing the data sheet.
建议部分得分
50% finals; 20% letters; 20% flags; 10% formulas retained.
R10.05.01.02-T14 Set weighted grade categories and return graded work in Google Classroom
原始指令
Google Classroom sandbox class 'Grade 8 Science - P3'. Turn on weighted grading with categories Labs 40, Quizzes 30, Projects 30, assign the existing 9 assignments to categories per input/categories.csv, and return the 10 graded 'Lab 3' submissions to students.
- 平台
web· 任意系统(网页)- 应用
- Google Classroom
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
click· 指向与点击- 工作产物
WP08· 应用 / 系统状态- 条件
- 未声明
- 提案难度
- 2 / 5
建议验证方式
Grader API read: gradebook settings with 3 categories and weights; coursework gradeCategory assignments exact; 10 Lab 3 submissions in state RETURNED with grades unchanged. Classroom API OAuth credentials are withheld from the agent (no Cloud project), so settings and returns must come from the Classroom web UI.
建议部分得分
40% categories and weights; 30% assignments categorized; 30% returned.
R10.05.01.02-T15 Customize Moodle grade letters and rounding and check boundary students
原始指令
Moodle sandbox, course PSYC200-F26. Set course grade letters to the department scheme in input/letters.pdf (A >= 93, A- >= 90, ... F < 60), course total display 'Real (Letter)', overall decimal points 1, then list in output/boundary.json the final letter for the 4 students whose totals sit within 0.05 of a boundary as Moodle displays them.
- 平台
web· 任意系统(网页)- 应用
- Moodle Grader
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
click· 指向与点击type· 文字与表单vis· 视觉判断- 工作产物
WP08· 应用 / 系统状态- 条件
- 未声明
- 提案难度
- 4 / 5
建议验证方式
grade_letters rows exact for the course context; gradedisplaytype and decimalpoints settings exact; boundary.json letters equal Moodle's rendered user report for those 4 students. Web services are disabled for the role and the agent has no server shell; settings changes must log origin 'web'.
建议部分得分
40% letter scheme; 20% display settings; 40% boundary letters.
R10.05.01.02-T16 Post term grades and comment codes to report cards in Infinite Campus
原始指令
Infinite Campus sandbox, teacher view, section 'English 9 - P4'. Post the Semester 1 grading task grades from the gradebook to the report card for all 27 students, add the comment codes in input/comments.csv (max 2 per student), and correct the one student whose posted grade must be an 'I' (incomplete) per input/incomplete_note.pdf.
- 平台
web· 任意系统(网页)- 应用
- Infinite Campus
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G3· 仅 GUI- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
click· 指向与点击type· 文字与表单- 工作产物
WP08· 应用 / 系统状态- 条件
licensed· 授权专业软件- 提案难度
- 3 / 5
建议验证方式
Sandbox posted grades equal gradebook values for 26 students and 'I' for the noted student; comment codes exact; post timestamp present. No API for teacher role.
建议部分得分
50% grades posted; 30% comment codes; 20% incomplete handled.
R10.05.01.02-T17 Reconcile LMS and SIS final grades for three sections and resync
原始指令
Final grades for 'CS 101' sections 01-03 (120 students) exist in Canvas and were synced to PowerSchool (sandbox). input/discrepancy_report.csv from the registrar lists suspected mismatches but is incomplete. Compare every student, determine the correct value per input/grade_policy.pdf (Canvas is source of truth unless a grade-change form in input/forms/ applies), fix the wrong side, and log every fix in output/reconciliation.xlsx.
- 平台
web· 任意系统(网页)- 应用
- Canvas Gradebook · PowerSchool · Excel
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
HY· 混合- GUI 需求 · 普通权限
HY· 混合- 交互原语
multi· 跨应用click· 指向与点击code· 代码与命令nav· 平移 / 缩放 / 滚动- 工作产物
WP02· 记录 / 表格- 条件
multiapp· 多应用long· 长流程licensed· 授权专业软件- 提案难度
- 5 / 5
建议验证方式
After fixes both systems agree for 120 students and equal gold; the 9 seeded mismatches (3 not in the registrar report) fixed on the correct side; log rows equal the gold fix list.
建议部分得分
45% mismatches found; 30% fixed on correct side; 25% log.
R10.05.01.02-T18 Record incomplete grades with contracts and expiry dates
原始指令
Canvas sandbox and PowerSchool sandbox, course 'NURS 210'. Two students have signed incomplete contracts (input/contracts/). In Canvas, extend their due dates on the listed assignments via assignment overrides; in PowerSchool record final grade 'I' with the contract's lapse date and default grade. Do not post 'I' for any other student.
- 平台
web· 任意系统(网页)- 应用
- Canvas Gradebook · PowerSchool
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
click· 指向与点击type· 文字与表单multi· 跨应用- 工作产物
WP08· 应用 / 系统状态- 条件
multiapp· 多应用risk· 高风险 / 不可逆licensed· 授权专业软件- 提案难度
- 4 / 5
建议验证方式
Canvas: overrides for exactly those students and assignments with contract dates; PowerSchool: 2 'I' grades with lapse date and default grade exact; no other students changed. Canvas personal access tokens are disabled for the agent's role and PowerSchool API credentials are withheld, so both changes must be made in the web UIs.
建议部分得分
40% Canvas overrides; 45% SIS incompletes; 15% no collateral changes.
R10.05.01.02-T19 Save the same twenty-five assignment grades via Moodle web services (control)
原始指令
Control pair of T07. With a web-service token in env MOODLE_TOKEN, call mod_assign_save_grades to store the 25 scores and feedback from input/lab2_scores.csv for 'Lab Report 2' in course BIO101-F26.
- 平台
lin· Linux- 应用
- Moodle web services · Python
- 交互表面
api· API / SDKterm· 终端- GUI 需求 · 任务设定
AP· API 足够- GUI 需求 · 普通权限
AP· API 足够- 交互原语
code· 代码与命令- 工作产物
WP02· 记录 / 表格- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Same assign_grades checks as T07; log origin 'ws' expected. Measures GUI-vs-API gap (the CSV removes the handwriting step).
建议部分得分
70% scores; 30% feedback.
R10.05.01.02-T20 Apply a custom letter grading scheme and hide totals until closeout
原始指令
Canvas sandbox, course 'BIOL 150 (sandbox)'. Create grading scheme 'BIOL Plus/Minus' from input/scheme.csv, enable it for the course so final grades display as letters, and hide totals in the student grade summary until the term ends; confirm in Student View that a test student sees no total.
- 平台
web· 任意系统(网页)- 应用
- Canvas Gradebook
- 交互表面
brow· 浏览器- GUI 需求 · 任务设定
G2· GUI 必要- GUI 需求 · 普通权限
G2· GUI 必要- 交互原语
click· 指向与点击type· 文字与表单- 工作产物
WP08· 应用 / 系统状态- 条件
- 未声明
- 提案难度
- 3 / 5
建议验证方式
Grading standard rows exact; course grading_standard_id set; hide_final_grades true; Student View rendered summary shows no total (grader screenshot check). Personal access token creation is disabled for the agent's role, so Canvas API calls are blocked and settings must be made in the web UI.
建议部分得分
45% scheme; 25% applied; 30% totals hidden.
已有研究映射
以下沿用研究目录中的基准与小类映射,不是逐题标注、执行记录或产品背书。