Case Study Practical Workout | 案例分析实战演练

📚 Case Study Practical Workout | 案例分析实战演练

In Edexcel GCSE Computer Science, case study questions test your ability to apply computational thinking to real-world problems. This article walks through a comprehensive practical workout based on a library book management system. You will learn how to decompose a problem, design algorithms, represent data, handle errors, test solutions, and evaluate your work.

在Edexcel GCSE计算机科学中，案例分析题考查你将计算思维应用于现实问题的能力。本文通过一个图书馆图书管理系统的综合实战演练，带你学习如何分解问题、设计算法、表示数据、处理错误、测试解决方案以及评估你的成果。

1. Understanding the Scenario | 理解场景

A secondary school wants to create a digital system for its library. The system should allow students to search for books by title or author, borrow books if they are available, return books, and automatically calculate late fines. The librarian needs to add new books and view current stock levels. The system must run on the school's local network and protect student data.

一所中学希望为其图书馆创建一个数字系统。该系统应允许学生通过书名或作者搜索书籍、在可借时借阅、归还图书，并自动计算逾期罚款。图书管理员需要添加新书并查看当前库存水平。系统必须在学校本地网络上运行，并保护学生数据。

2. Decomposition and Abstraction | 分解与抽象

Decomposition breaks the problem into manageable parts: user authentication, search functionality, borrowing process, return process, fine calculation, stock management, and reporting. Abstraction identifies the key data we need to model: books (ISBN, title, author, stock count), students (ID, name, form), and loans (student ID, ISBN, borrow date, due date). By focusing on these essentials, we ignore less relevant details like book cover colour or student hobbies.

分解将问题拆分为可管理的部分：用户身份验证、搜索功能、借阅流程、归还流程、罚款计算、库存管理和报告。抽象则识别出我们需要建模的关键数据：图书（ISBN、书名、作者、库存量）、学生（ID、姓名、班级）以及借阅记录（学生ID、ISBN、借阅日期、应还日期）。通过关注这些要点，我们忽略了诸如封面颜色或学生爱好等无关细节。

3. Algorithm Design with Pseudocode | 伪代码算法设计

Here is a pseudocode algorithm for searching books by title. It takes a search term and returns matching results.

以下是按书名搜索图书的伪代码算法。它接受一个搜索词并返回匹配结果。

BEGIN
   INPUT searchTerm
   results ← empty list
   FOR each book IN bookArray
      IF book.title CONTAINS searchTerm THEN
         Append book to results
      ENDIF
   NEXT book
   IF results IS empty THEN
      OUTPUT "No books found."
   ELSE
      FOR each book IN results
         OUTPUT book.title, book.author, book.stock
      NEXT book
   ENDIF
END

The algorithm initialises an empty list, iterates through all books, and checks if the title field contains the search term. If matches are found, they are displayed; otherwise, a message indicates no results. This linear search is simple and effective for a small library collection.

算法初始化一个空列表，遍历所有图书，检查书名字段是否包含搜索词。如果找到匹配项，则显示它们；否则显示未找到结果的消息。这种线性搜索对于小型图书馆收藏简单有效。

广告 / Sponsored

4. Flowchart Representation | 流程图表示

owchart. The main steps are: Start → Input student ID and book ISBN → Check student exists? If no, output error and stop. → If yes, check book available (stock > 0)? If no, output "Book not available" and stop. → If yes, reduce stock by 1, create a loan record with today's date and a due date 14 days later. → Output "Book borrowed successfully". → Stop. Below is a simple text-based flowchart for visualising the control flow.

我们可以用流程图表示借阅过程。主要步骤是：开始→输入学生ID和图书ISBN→检查学生是否存在？如果否，输出错误并停止。→如果是，检查图书是否可借（库存>0）？如果否，输出“图书不可借”并停止。→如果是，库存减1，创建借阅记录，记录今天日期和14天后的应还日期。→输出“借阅成功”。→停止。下面是一个简单的文本流程图，用于可视化控制流。

   +-------+
   | Start |
   +---+---+
       |
       v
+------+------+
| Input ID,   |
| ISBN        |
+------+------+
       |
       v
    +--+--+  No   +--------------+
    | Stu |----->| Error: unknown|
    |dent?|      | student       |
    +--+--+      +--------------+
       | Yes
       v
  +----+----+  No   +------------------+
  | Stock >0|----->| "Not available"   |
  +----+----+      +------------------+
       | Yes
       v
+------+------+
| Reduce stock|
| Create loan |
+------+------+
       |
       v
+------+------+
| Output      |
| success msg |
+------+------+
       |
       v
    +--+--+
    | Stop|
    +-----+

This flowchart uses standard symbols: rectangles for processes, diamonds for decisions, and arrows for flow. Tracing it helps identify any logic errors before coding.

此流程图使用标准符号：矩形表示处理，菱形表示决策，箭头表示流向。在编码前追踪它有助于发现任何逻辑错误。

5. Data Types and Structures | 数据类型与结构

We need to define appropriate data types and structures. The book record can be a dictionary or a class with fields: ISBN (string), title (string), author (string), stock (integer). The student record: studentID (integer), name (string), formGroup (string). A loan record: loanID (integer), studentID (integer), ISBN (string), dateBorrowed (date), dueDate (date), returned (boolean). The collection of books is stored in an array (list) for efficient indexing and searching. Choosing the correct types ensures data consistency and correct operations.

我们需要定义合适的数据类型和结构。图书记录可以是一个字典或类，包含字段：ISBN（字符串）、书名（字符串）、作者（字符串）、库存（整数）。学生记录：studentID（整数）、姓名（字符串）、班级（字符串）。借阅记录：loanID（整数）、studentID（整数）、ISBN（字符串）、借阅日期（日期）、应还日期（日期）、是否归还（布尔值）。图书集合存储在数组（列表）中，以便高效索引和搜索。选择正确的类型可确保数据一致性和操作正确性。

Field	字段	Data Type	数据类型	Example	示例
ISBN	ISBN	String	字符串	"978-0-123-45678-9"	"978-0-123-45678-9"
Title	书名	Published by TutorHao | Year 11 Computer Science Revision Series | aleveler.com 广告 / Sponsored Pearson Revise Edexcel GCSE Business Model Answer Workbook … 商科 备考教辅 · 正版现货 · 与本文内容相关 查看详情 / View on Taobao参考价 ¥57.4 更多咨询请联系16621398022（同微信） 备考资讯每日更新，关注不错过 考纲变化 · 科目分析 · 学习方法 在微信里长按二维码识别关注 或截图后用「扫一扫 → 相册」选择本图 公众号：tutorhao