Skip to main content
Toolathlon-Verified · Website task ID 149 · Canonical task academic-warning View the task source at d57361c0

​
Required Tools

MCP Servers
google-cloud
excel
filesystem
Local Tools
claim_done
handle_overlong_tool_outputs
manage_context
history

​
Instruction

The academic affairs system requires an automated academic warning mechanism. The latest unit test scores are recorded in the latest_quiz_scores.csv file. Please read this file and combine it with all the student scores stored in multiple test score tables (such as 2501, 2502, 2503, 2504, 2505, 2506, and 2507) in the academic_warning dataset of BigQuery to identify those students whose test scores have dropped by more than 25% compared to their average scores in the past. Write the list to the bad_student.csv. For those students whose test scores have dropped by more than 45%, please immediately write a critical level warning log to the existing log bucket whose name is prefixed with exam_log for each of them with his/her name and student ID so that the system can automatically notify their counselor. During the entire process, there is no need to consider any log entries in the log bucket that existed before the task was executed.

​
Initial State

​
Local Workspace

workspace/ └── latest_quiz_scores.csv

​
Runtime Setup

This task initializes application or service state during preprocessing. Review the pinned setup source.

​
Legacy Trajectories

These replays were produced on the original Toolathlon release. They are retained for historical inspection and are not Toolathlon-Verified results.