故事背景#

主题： 泰坦 complément号上的时空裂痕 你的角色： 你们是一队时间旅行者。在一次时空跳跃中，时间机器发生故障，将你们紧急弹射到了 1912 年 4 月 14 日的泰坦尼克号上。 你的目标： 你们必须在船沉没前，在船上找到 4 个丢失的“时空坐标碎片”。集齐这 4 个坐标才能重新定位你们的时间机器并安全离开。 密室文档： 你们生成的 HTML 文档就是给“游戏运营者 (GM)”的指南，GM 将引导玩家（时间旅行者）完成这一系列挑战。

挑战 1 (成员 A)：“事务长办公室” (找出异常数据)#

• 故事： 你们刚登船就被当作偷渡者抓住了。你们被锁在事务长的办公室里，必须证明自己的智慧才能逃脱。在办公桌上有一叠乘客登记卡，你们必须找出其中那张“伪造的”卡片。
• [cite_start]挑战： 向玩家展示 5-6 张“乘客卡片”（即 5-6 个数据行）。其中 5 张是从数据集中随机抽取的真实乘客数据，而有 1 张是你们的程序生成的“伪造数据” [cite: 51, 52]。
• 如何生成 (第 5 阶段)： 这个伪造数据在统计上是不可能的。例如：一个 3 等舱乘客 (Pclass=3) 却支付了 500 英镑的票价 (Fare)（远高于 1 等舱的票价）。
• [cite_start]玩家任务： 必须找出哪张乘客卡是“伪造的” [cite: 51]。
• [cite_start]线索 (Hints)： 提供一些真实的数据可视化图表作为“船务手册”，例如“各舱位平均票价分布”的箱形图 [cite: 53]。
• 获得： 藏在伪造卡片下的 时空坐标碎片 1。

挑战 2 (成员 B)：“马可尼无线电室” (填字/词汇游戏)#

• 故事： 第一个碎片指引你们前往马可尼（无线电）室。门被一个键盘锁锁住了。墙上贴着一张无线电操作员（为打发时间）没做完的填字游戏，你们意识到，这个游戏的答案就是开门密码。
• [cite_start]挑战： 一个填字游戏 [cite: 45]。
• [cite_start]如何生成 (第 5 阶段)： 答案全部来自数据集的“字段名”(Column Names) 或与泰坦尼克号相关的“概念” [cite: 45]。
  • 示例线索 (Answers)：
    • “乘客的父母或子女数量” (答案: PARCH)
    • “乘客支付的票价” (答案: FARE)
    • “登船的港口 (C、Q 或 S)” (答案: EMBARKED)
    • “乘客的兄弟姐妹或配偶数量” (答案: SIBSP)
• 玩家任务： 完成填字游戏，获得密码。
• [cite_start]线索 (Hints)： 可以提供一两个答案的字母作为提示 [cite: 46]。
• 获得： 你们打开了门，在电报机上找到了 时空坐标碎片 2。

挑战 3 (成员 C)：“破译救生艇代码” (分类谜题)#

• 故事： 第二个碎片指引你们前往甲板。你们在一个救生艇站旁发现了一个上锁的补给箱。锁是一个 4 位数的键盘锁。附近一张军官的笔记上，写着 4 名特定乘客的资料。你们意识到，这个 4 位数密码一定是对他们命运的预测。
• 挑战：
  1. [cite_start]程序生成一个可视化图表（例如，一张展示生还率的图表）[cite: 49]。
  2. 程序接着展示 4 名乘客的资料（例如，“乘客 1：女性，1 等舱，30 岁”，“乘客 2：男性，3 等舱，25 岁”等）。
  3. 玩家必须使用图表来预测每位乘客是“生还”（代码=1）还是“未生还”（代码=0）。
• 玩家任务： 输入正确的 4 位二进制代码（例如 1011）来打开箱子。
• 如何生成 (第 5 阶段)： 程序从数据集中随机选择 4 名乘客，并展示他们的特征。正确的“答案”就是他们（在数据集中）的实际 Survived 值（1 或 0）。
• [cite_start]线索 (Hints)： 如果玩家输错代码，可以揭示一个额外的、未在图表上显示的数据作为提示。“提示：乘客 2 支付的票价为 7 英镑” [cite: 49, 50]。
• 获得： 箱子打开，里面是 时空坐标碎片 3。

挑战 4 (成员 D)：“平衡救生艇载重” (数据聚合/计算)#

• 故事： 警报大作，船体正在倾斜！你们奔向最后的集合点，那里只剩下一艘救生艇。一名工程师正对着一份乘客名单和一台计算器大喊：“不行，这艘船会翻！我必须知道一个精确的数字来配平重量！”
• 他交给你们一张纸条： “快！我必须知道这份名单上，所有1 等舱 (Pclass=1) 中，年龄在 30 岁以上 (Age > 30) 的女性 (Sex='female')，她们所支付的平均票价 (Fare 的 MEAN) 是多少？把这个数字输入配平系统！”
• 挑战： 这是一个数据聚合任务。玩家不能再依赖“直觉”，而必须使用“乘客名单”（数据集）进行精确计算。
• 玩家任务：
  1. 筛选 Pclass == 1
  2. 再筛选 Sex == ‘female’
  3. 再筛选 Age > 30
  4. 计算所有符合上述条件的乘客的 Fare (票价) 的平均值 (MEAN)。
• 如何生成 (第 5 阶段)：
  • 你们的程序将随机组合一个聚合任务。例如：
  • 随机选择 2-3 个筛选条件（例如 Pclass=2, Embarked='Q'）。
  • 随机选择一个聚合函数（例如 SUM 总和, MEAN 平均值, COUNT 计数）。
  • 随机选择一个要计算的数字列（例如 Fare 票价, Age 年龄）。
  • （这个挑战是你们自己设计的，基于对数据集进行计算的原则）。
• [cite_start]线索 (Hints)： “提示：确保你用的是平均值，而不是总和！” [cite: 42]
• 获得： 你们算出了正确的数字（例如 “87.5”）并输入系统。救生艇的配重调整完毕，成功释放。在救生艇的座位下，你们找到了 时空坐标碎片 4。

English version:

Story Background#

Theme: The Titanic Time-Rift Your Role: You are a group of time-travelers. During a routine jump, your temporal engines malfunctioned, causing an emergency ejection. You’ve landed on the RMS Titanic on April 14, 1912, just hours before it sinks. Your Goal: Your time machine is “phased,” and to bring it back into your timeline, you must find 4 “Temporal Coordinate Fragments” that were scattered across the ship during your crash-landing. You must collect all 4 and get to the rendezvous point before the ship sinks. The Document: The HTML document you generate is the “Game Master’s Guide,” which provides all the instructions, challenges, hints, and answers for someone running the escape room.

Challenge 1 (Member A): “The Purser’s Office” (Spot the Rogue Data Item)#

• Story: You are immediately apprehended by a ship’s officer. Your names are not on the official passenger manifest. He suspects you are stowaways and locks you in the Purser’s office. On the desk is a stack of passenger registration cards, one of which the Purser has marked as “suspicious.”
• The Challenge: The players are presented with 5-6 “Passenger Cards” (data rows). Five are real passengers randomly selected from the dataset; one is a “rogue item” generated by your program.
• How to Generate (Stage 5): The rogue item must be a statistical outlier. For example: A Pclass=3 (Third Class) passenger who paid a Fare of £500 (far higher than any First Class ticket).
• Player’s Task: Identify which passenger card is the “forgery.”
• Hints: The officer’s “manual” is left on the desk, which includes visualizations of the whole dataset. For example, a box plot of Fare by Pclass.
• Reward: Hidden beneath the forged card is the Temporal Coordinate Fragment 1.

Challenge 2 (Member B): “The Marconi Room” (Crossword/Vocabulary Puzzle)#

• Story: The first fragment contains a cryptic clue: “The next answer travels on the airwaves.” This leads you to the Marconi radio room. The door is locked with a simple keypad. A note on the wall from the radio operator has a crossword puzzle he was working on. The solution to the crossword is the keypad code.
• The Challenge: A crossword puzzle.
• How to Generate (Stage 5): The answers are all terms taken from the dataset’s “field names” (column names) or related concepts from a paper.
  • Example Clues (Answers):
    • “Passenger’s parents or children aboard” (Answer: PARCH)
    • “Price paid for the ticket” (Answer: FARE)
    • “Port of embarkation (C, Q, or S)” (Answer: EMBARKED)
    • “Number of siblings or spouses aboard” (Answer: SIBSP)
• Player’s Task: Complete the puzzle to find the code.
• Hints: One or two of the answers can be provided as a hint.
• Reward: You unlock the door and find Temporal Coordinate Fragment 2 attached to the transmitter.

Challenge 3 (Member C): “Decoding the Lifeboat Code” (Classification Puzzle)#

• Story: The second fragment points to the boat deck. You find a locked supply chest next to a lifeboat station. The lock is a 4-digit keypad. A nearby note from an officer contains the profiles of 4 specific passengers. You realize the 4-digit code must be a prediction of their fate.
• The Challenge:
  1. The program generates a visualization (e.g., a chart showing survival rates).
  2. The program then presents the profiles of 4 specific passengers (e.g., “Passenger 1: Female, Pclass=1, Age=30”, “Passenger 2: Male, Pclass=3, Age=25”, etc.).
  3. The players must use the visualization to predict if each passenger Survived (code = 1) or Did Not Survive (code = 0).
• Player’s Task: Enter the correct 4-digit binary code (e.g., 1011) to unlock the chest.
• How to Generate (Stage 5): The program randomly selects 4 passengers from the dataset and presents their features. The “answer” is simply their actual Survived value (1 or 0) from the dataset.
• Hints: If the players get the code wrong, you can reveal an additional, non-visualized piece of data as a hint. “Hint: Passenger 2 paid a fare of £7.”
• Reward: The chest opens, revealing Temporal Coordinate Fragment 3.

Challenge 4 (Member D): “Balancing the Lifeboat” (Data Aggregation/Calculation)#

• Story: Alarms are blaring as the ship tilts! You race to the final rendezvous point, where a single lifeboat remains. An engineer is frantically yelling at a manifest and a calculator: “It’s no good, the boat will capsize! I need a precise number to balance the load!”
• He hands you a note: “Quick! I must know the MEAN average fare (Fare) paid by all female (Sex='female') passengers in First Class (Pclass=1) who were over 30 years old (Age > 30). Enter that number into the ballast system!”
• The Challenge: This is a data aggregation task. Players can no longer use “intuition”; they must perform a precise calculation based on the dataset.
• Player’s Task:
  1. Filter for Pclass == 1
  2. Filter for Sex == ‘female’
  3. Filter for Age > 30
  4. Calculate the MEAN of the Fare for all passengers who meet these criteria.
• How to Generate (Stage 5):
  • Your program will randomly combine an aggregation task. For example:
  • Randomly select 2-3 filter conditions (e.g., Pclass=2, Embarked='Q').
  • Randomly select an aggregation function (e.g., SUM, MEAN, COUNT).
  • Randomly select a numeric column to calculate (e.g., Fare, Age).
  • (This challenge is based on your own design, following the principle of calculating from the dataset).
• Hints: “Hint: Make sure you are calculating the average, not the total!”
• Reward: You calculate the correct number (e.g., “87.5”) and enter it. The lifeboat’s ballast is balanced, and it successfully launches. Tucked under a seat, you find the Temporal Coordinate Fragment 4.