🔍 リサーチ Reddit

学生がCoworkで包括的な学業監査:Classroom+成績簿+Gmail連携

病欠後の成績混乱を解消するため、学生がCoworkに5つのAP/Honorsコース全体をGoogle Classroom・成績簿・Gmail横断で自動監査させた。20分で11ページの復旧レポートを生成し、見逃されていた50点の再提出機会を発見

★★☆ 中級 15-25 min 2026年4月13日
M
MassiveDoohickey @u/MassiveDoohickey

Student sharing a Cowork-driven academic recovery workflow

ソース
📋

シナリオ

学生が医療事情で3週間欠席。復帰後、5つのAP/Honorsコースで多数の0点が蓄積:承認済み欠席(AE)、真の未提出(NS)、再提出機会に変換されていないもの等。学校はGoogle Classroomと別の成績簿を併用し、統合ビューがない。

💬

プロンプト

Audit everything about my academic status:
1. Open Google Classroom, go into the Classwork tab of each of my 5 AP/Honors courses, and build the full assignment archive for each class.
2. Cross-reference with the school gradebook portal. For every entry, record point value and status code (AE = Absent Excused, NS = Not Submitted, etc.).
3. Search Gmail for anything about my absence — teacher emails with makeup dates, the Updates tab in Classroom, and my tutor's recovery plan email from yesterday.
4. Produce a PDF report with: current standing, gradebook↔Classroom discrepancies, a zero-tolerance list sorted by point impact, a 21-day upcoming-work matrix, grade recovery projections, a 7-day action plan, and draft emails to teachers.

期待される結果

Cowork は20分で監査を自律完了し、11ページのPDFレポートを生成: 1. 5コースの現在の成績概況 2. 成績簿と Classroom の全不一致 3. チューターの復旧計画を教師メールと期日と照合 4. 点数影響順のゼロ点リスト 5. 21日間の課題マトリクス(30件超を日付+優先度で整理) 6. 当日未読の教師メールからの情報抽出 7. ゼロ点解消ありとなしの GPA 予測 8. 今後7日間の日別アクション計画 9. 3人の教師向けに送信可能なメール草稿 **最大の発見:** 承認済み欠席が再提出機会に変換されていなかったため0点のまま放置されていた50点課題 — F評価の主因。Cowork が検出・フラグ・メール草稿化を実施。手作業なら3〜4時間のところ20分で完了。

📝

元の投稿

· 2026-04-13

So I've been dealing with a rough few weeks (medical stuff, was out for about 3 weeks) and my grades have been slipping in ways I couldn't fully see or track. A bunch of zeros were piling up across different platforms; my school uses both Google Classroom and a separate gradebook portal. I decided to use an AI assistant (Claude via Cowork) and basically gave it one instruction: audit everything. Here's what it actually did, autonomously, without me lifting a finger: - Logged into Google Classroom, went into the Classwork tab of every single one of my 5 AP/Honors courses, created the full assignment archive for each class - Cross-referenced that with my school's official gradebook, checking every individual grade entry with its point value and status code (AE = Absent Excused calculating as 0, NS = Not Submitted/Missing) - Searched Gmail for emails about my absence, found teacher correspondence with specific makeup dates, and checked the Updates tab for new Classroom posts - Incorporated a recovery plan my tutor had emailed me the day before Then it produced an 11-page PDF report with: current standing, critical discrepancies between gradebook and Classroom, a zero-tolerance list sorted by point impact, a 21-day upcoming-work matrix, grade recovery projections, a 7-day action plan, and draft emails to three teachers ready to send. Biggest finding: a 50-point grade sitting at 0 because of an excused absence nobody had converted to a makeup opportunity — the primary reason for an F in that class. The AI caught it, flagged it, and wrote the teacher email. Would have taken me 3–4 hours manually. Took the AI about 20 minutes.