场景 092 · Codex Use Case

跟踪课程参与情况

合并获准 LMS、成绩、出勤和作业数据,展示参与、完成和评估模式及质量警告。

DataIntegrations
Track course engagementDataIntegrations

原文核对:2026-10-13 · 中文正文 · 英文提示词与演示

场景定位

合并获准 LMS、成绩、出勤和作业数据,展示参与、完成和评估模式及质量警告。

难度
高级
时间跨度
1 小时

适合用于

  • 审阅课程参与和完成模式的教师。
  • 需统一定义与质量检查的课程导出。
  • 支持人工审阅、不给学生作诊断的仪表盘。

相关工具

Spreadsheets

对齐导出、计算已审阅指标并建可编辑仪表盘。

Google Drive

收集获准 LMS、出勤、成绩和作业文件。

起步提示词

英文原文 · 可复制后按实际材料修改

Build a course engagement and performance dashboard from the de-identified LMS activity, gradebook, attendance, assignment metadata, course calendar, and metric definitions I provide.

Show:
- engagement trends
- completion gaps
- assessment patterns
- missing or inconsistent data
- questions for faculty review

Create a faculty review queue. Do not diagnose students or automate outreach, grading, placement, or support decisions.

合并前定义仪表盘

只提供获准、去标识化导出,附指标定义、时间窗口、校历和关联所需标识符。

绘图前说明数据关联方法,先解决重复、缺少标识符和定义冲突。

建立审阅视图

包括:

  • 时间趋势。
  • 作业完成和评估模式。
  • 符合课程结构的筛选。
  • 缺失数据与质量警告。
  • 供教师审阅的问题队列。

观察与解释分开;活动变化只是待检查信号,不是诊断。

验证并谨慎使用

对照源总数并抽查去标识化记录,确认窗口、班级筛选和评估分组。

用于指导教师提问,不自动评分、外联、分班或作高风险标签。

展开英文原文对照

Use ChatGPT with LMS activity, gradebook, attendance, assignment metadata, and metric definitions to build a dashboard of engagement patterns, completion gaps, assessment trends, and data-quality warnings.

Define the dashboard before combining data

Provide only approved, de-identified exports. Include the metric definitions, reporting window, course calendar, and identifiers needed to align the files.

Before building charts, ask ChatGPT to show how the LMS, attendance, gradebook, and assignment data will be joined. Resolve duplicate records, missing identifiers, and conflicting definitions first.

Build a review view

Use the starter prompt to create a dashboard with:

  • trends over time
  • assignment completion and assessment patterns
  • filters that match the course structure
  • missing-data and quality warnings
  • a queue of questions for faculty review

Keep observed patterns separate from explanations. A change in activity is a signal to inspect, not a diagnosis.

Validate and use responsibly

Check calculations against source totals and spot-check individual de-identified records. Confirm that date windows, section filters, and assessment groupings are correct.

Use the dashboard to guide faculty questions. Do not use it to automate grading, outreach, placement, or high-stakes labels.