📚 Year 7 OCR Computer Science: Case Study Practical Drill | 7年级OCR计算机：案例分析实战演练
In this article, we will walk through a detailed case study centred on a fictional school called Greenfield Academy. The school is planning a major IT system upgrade. By analysing their requirements, we can apply the key concepts from the Year 7 OCR Computer Science curriculum, including networks, hardware, data representation, cybersecurity, algorithms, and programming.
本文将围绕一所虚构的格林菲尔德学院展开详细的案例分析。该校正计划进行重大IT系统升级。通过分析他们的需求，我们可以应用7年级OCR计算机科学课程中的关键概念，包括网络、硬件、数据表示、网络安全、算法和编程。
1. Case Overview: Greenfield Academy’s IT Upgrade | 案例概览：格林菲尔德学院的IT升级
Greenfield Academy currently has a small computer lab with ten standalone desktop computers. The school leadership wants to expand the lab to thirty machines, create a reliable network, introduce a library management system, and improve online safety. As a junior IT consultant, your task is to propose solutions that are cost-effective, secure, and easy to maintain. Let’s examine each area step by step.
格林菲尔德学院目前有一个小型计算机实验室，配备十台独立台式电脑。学校领导希望将实验室扩展到三十台机器，创建一个可靠的网络，引入图书馆管理系统，并提高在线安全性。作为一名初级IT顾问，你的任务是提出成本效益高、安全且易于维护的解决方案。让我们一步步来审视每个方面。
2. Understanding the School’s Network | 理解学校网络
A network allows computers to share files, printers, and an internet connection. For Greenfield Academy, all thirty computers need to access a shared printer and a central file server that stores students’ work. Without a network, each machine would need its own printer and storage, which is expensive and inefficient.
网络允许计算机共享文件、打印机和互联网连接。对于格林菲尔德学院来说，所有三十台计算机都需要访问一台共享打印机和一台存储学生作业的中央文件服务器。如果没有网络，每台机器都需要自己的打印机和存储设备，这既昂贵又低效。
The school can choose between a wired network using Ethernet cables or a wireless network using Wi-Fi. Wired connections are faster and more secure, but they require cables and switch ports. Wireless is more flexible but can suffer from interference and slower speeds.
学校可以在使用以太网电缆的有线网络和使用Wi-Fi的无线网络之间进行选择。有线连接更快、更安全，但需要电缆和交换机端口。无线更灵活，但可能受到干扰且速度较慢。
- Ethernet cables use RJ45 connectors. | 以太网电缆使用RJ45连接器。
- Wi-Fi uses radio waves to transmit data. | Wi-Fi使用无线电波传输数据。
3. Choosing the Right Network Topology | 选择合适的网络拓扑
Network topology refers to how computers are arranged and connected. Two common topologies are the star topology and the bus topology. In a star network, every computer connects to a central switch. If one cable fails, only that computer is affected, making it very reliable. In a bus topology, all computers share a single main cable, which is cheaper but if the main cable breaks, the whole network goes down.
网络拓扑是指计算机的排列和连接方式。两种常见拓扑是星型拓扑和总线拓扑。在星型网络中，每台计算机都连接到中央交换机。如果一根电缆出现故障，只有那台计算机受影响，因此非常可靠。在总线拓扑中，所有计算机共享一根主电缆，这更便宜，但如果主电缆断开，整个网络就会瘫痪。
Greenfield Academy should use a star topology for its computer lab. A 32-port switch (30 computers + 1 server + 1 extra) will connect all devices. This setup ensures high reliability and easy troubleshooting.
格林菲尔德学院应该为其计算机实验室使用星型拓扑。一台32口交换机（30台计算机 + 1台服务器 + 1个备用）将连接所有设备。这种设置确保了高可靠性和易于故障排查。
| Topology 拓扑 | Reliability 可靠性 | Cost 成本 | Ease of Setup 安装便利性 |
|---|---|---|---|
| Star 星型 | High 高 | Medium 中 | Easy 简单 |
| Bus 总线 | Low 低 | Low 低 | Very Easy 非常简单 |
4. Hardware Requirements for the Lab | 实验室硬件需求
Each workstation needs essential input and output devices. Input devices like a keyboard and mouse allow users to enter data; output devices like a monitor and speakers present information. The school also needs a powerful file server with large storage capacity and a reliable printer. Let’s specify the hardware.
每台工作站都需要基本的输入和输出设备。键盘和鼠标等输入设备允许用户输入数据；显示器和扬声器等输出设备呈现信息。学校还需要一台具有大存储容量的强大文件服务器和一台可靠的打印机。让我们来指定硬件。
For the server, we recommend a machine with a multi-core processor, at least 8 GB of RAM, and a RAID (Redundant Array of Independent Disks) setup to protect data. The server will store all student files and host the library database software.
对于服务器，我们建议配备多核处理器、至少8 GB内存以及用于保护数据的RAID（独立磁盘冗余阵列）设置的机器。服务器将存储所有学生文件并托管图书馆数据库软件。
- Input: keyboard, mouse, barcode scanner for library. | 输入：键盘、鼠标、图书馆用的条形码扫描器。
- Output: LCD monitors, network printer, speakers. | 输出：液晶显示器、网络打印机、扬声器。
- Storage: server with 2 TB HDD in RAID 1 configuration. | 存储：采用RAID 1配置的2 TB HDD服务器。
5. Data Storage and Backup Solutions | 数据存储和备份解决方案
Data can be stored on hard disk drives (HDDs) or solid-state drives (SSDs). HDDs are cheaper per gigabyte and suitable for large file servers, but they are slower and more fragile. SSDs are faster, quieter, and more durable but cost more. For a school server, a hybrid approach may work: HDDs for bulk storage and a small SSD for the operating system.
数据可以存储在硬盘驱动器（HDD）或固态驱动器（SSD）上。HDD每GB更便宜，适合大型文件服务器，但速度较慢且更脆弱。SSD更快、更安静、更耐用，但成本更高。对于学校服务器，混合方案可能有效：HDD用于大容量存储，小型SSD用于操作系统。
Backup is critical to prevent data loss. Greenfield Academy should employ the 3-2-1 backup rule: keep three copies of data, on two different media, with one copy stored off-site. The school could use an external HDD for daily backups and cloud storage for weekly off-site backups.
备份对于防止数据丢失至关重要。格林菲尔德学院应采用3-2-1备份规则：保留三份数据副本，在两种不同介质上，其中一份异地存储。学校可以使用外部HDD进行每日备份，并使用云存储进行每周异地备份。
| Storage Type 存储类型 | Speed 速度 | Durability 耐用性 | Cost per GB 每GB成本 |
|---|---|---|---|
| HDD 硬盘驱动器 | Slow 慢 | Fragile 易碎 | Low 低 |
| SSD 固态硬盘 | Fast 快 | Durable 耐用 | High 高 |
6. Simple Binary and Data Representation | 简单二进制与数据表示
Computers store all data as binary digits (bits), which are 0s and 1s. A group of 8 bits is called a byte. Greenfield Academy needs to understand file sizes. Suppose a single document created by a student is 50 KB (kilobytes). How many such documents can fit on the server’s 2 TB drive? First, convert 2 TB to bytes: 2 TB = 2 × 10¹² bytes. 50 KB = 50 × 10³ bytes. So, roughly 40 million documents can be stored.
计算机将所有数据存储为二进制数字（比特），即0和1。一组8比特称为一个字节。格林菲尔德学院需要了解文件大小。假设一个学生创建的单个文档为50 KB（千字节）。服务器的2 TB驱动器能容纳多少个这样的文档？首先，将2 TB转换为字节：2 TB = 2 × 10¹² 字节。50 KB = 50 × 10³ 字节。因此，大约可以存储4000万个文档。
Students also need to learn binary arithmetic. For example, the decimal number 13 is 1101 in binary. Understanding how characters are represented using ASCII or Unicode is also part of the curriculum. The school’s library system will use unique binary codes for each book barcode.
学生还需要学习二进制算术。例如，十进制数13在二进制中是1101。理解字符如何使用ASCII或Unicode表示也是课程的一部分。学校的图书馆系统将为每个图书条形码使用唯一的二进制代码。
- 1 byte = 8 bits. | 1字节 = 8比特。
- Kilobyte (KB) ≈ 1000 bytes; Megabyte (MB) ≈ 1000 KB; Gigabyte (GB) ≈ 1000 MB; Terabyte (TB) ≈ 1000 GB. | 千字节（KB）≈ 1000字节；兆字节（MB）≈ 1000 KB；吉字节（GB）≈ 1000 MB；太字节（TB）≈ 1000 GB。
7. Cybersecurity Threats and Defenses | 网络安全威胁与防护
With the school network connected to the internet, cybersecurity becomes essential. Common threats include malware (viruses, worms, trojans), phishing emails that trick users into revealing passwords, and brute-force attacks that try to guess passwords. The school must implement defenses such as a firewall, antivirus software, and strong password policies.
随着学校网络连接到互联网，网络安全变得至关重要。常见威胁包括恶意软件（病毒、蠕虫、木马）、诱骗用户泄露密码的网络钓鱼电子邮件，以及试图猜测密码的暴力破解攻击。学校必须实施防火墙、防病毒软件和强密码策略等防御措施。
A firewall monitors incoming and outgoing network traffic and blocks suspicious activity. Antivirus software scans for and removes malicious programs. Additionally, all users should be trained to recognise phishing attempts and to create strong passwords containing a mix of uppercase, lowercase, numbers, and symbols.
防火墙监控传入和传出的网络流量并阻止可疑活动。防病毒软件扫描并移除恶意程序。此外，所有用户都应接受培训，以识别网络钓鱼企图并创建包含大写字母、小写字母、数字和符号混合的强密码。
Greenfield Academy should set up a demilitarised zone (DMZ) that separates the school’s internal network from the public internet. The library server can be placed in the DMZ for safe external access by parents checking book availability.
格林菲尔德学院应设置一个非军事区（DMZ），将学校内部网络与公共互联网分开。图书馆服务器可以放置在非军事区中，以便家长安全地从外部查看图书可用性。
8. Designing a Simple Algorithm with Flowcharts | 用流程图设计简单算法
An algorithm is a step-by-step procedure to solve a problem. For instance, the library needs an algorithm for borrowing a book. The steps might be: scan the book barcode, scan the student ID, check if the book is available, update the database to mark the book as borrowed, and print a receipt. Failure to complete any step should trigger an error message.
算法是解决问题的逐步过程。例如，图书馆需要一个借书流程的算法。步骤可能是：扫描图书条形码，扫描学生ID，检查图书是否可借，更新数据库将图书标记为已借出，并打印收据。任何步骤失败都应触发错误消息。
We can represent this algorithm as a flowchart. A flowchart uses symbols: an oval for start/end, a rectangle for a process, a diamond for a decision. Start → Scan barcode → Scan student ID → Decision: Is book available? If yes → Update database → Print receipt → End. If no → Display error message → End.
我们可以将此算法表示为流程图。流程图使用一些符号：椭圆形表示开始/结束，矩形表示处理步骤，菱形表示决策。开始 → 扫描条形码 → 扫描学生ID → 决策：书是否可借？如果是 → 更新数据库 → 打印收据 → 结束。如果否 → 显示错误消息 → 结束。
Start → [Scan book] → [Scan ID] → {Book available?} → [Update DB] → [Print receipt] → End
如果 unavailable → [Error message] → End
9. Scratch Programming: Automating Library Management | Scratch编程：自动化图书馆管理
Year 7 students often use Scratch to learn programming basics. We can simulate a simple library system in Scratch. The program will ask the user to enter a book ID and a student ID, then check a list of borrowed books and display whether the loan is successful.
7年级学生经常使用Scratch学习编程基础。我们可以在Scratch中模拟一个简单的图书馆系统。程序将要求用户输入图书ID和学生ID，然后检查已借出图书列表，并显示借阅是否成功。
In Scratch, we can use variables to store the book ID and student ID. Lists (arrays) can hold the IDs of books already on loan. The if...then...else block will decide the flow. For example: if book ID is not in the ‘borrowed’ list, then add the book ID to the list and say ‘Loan successful’; else say ‘Book already borrowed’.
在Scratch中，我们可以使用变量存储图书ID和学生ID。列表（数组）可以保存已借出图书的ID。if...then...else积木块将决定流程。例如：如果 图书ID不在‘已借出’列表中，则将图书ID添加到列表并说‘借阅成功’；否则说‘图书已借出’。
Additionally, Scratch can use broadcasts to coordinate multiple sprites. A librarian sprite might ask for input, while a database sprite manages the list. This modular approach introduces basic computational thinking.
此外，Scratch可以使用广播来协调多个角色。图书管理员角色可以请求输入，而数据库角色管理者列表。这种模块化方法引入了基本的计算思维。
10. Testing and Debugging the System | 系统测试与调试
No system works perfectly the first time. Testing involves running the program with various inputs to ensure correct behaviour. For the Scratch library system, testing should include: entering a valid book ID that is not borrowed (expected: success), entering an already borrowed book ID (expected: rejection), and entering an invalid ID format (expected: error message).
没有系统第一次就能完美运行。测试涉及使用各种输入运行程序以确保行为正确。对于Scratch图书馆系统，测试应包括：输入一个未借出的有效图书ID（预期：成功），输入一个已借出的图书ID（预期：拒绝），输入无效的ID格式（预期：错误消息）。
Debugging is the process of finding and fixing errors (bugs). Common bugs in Scratch include using the wrong variable, missing a loop, or forgetting to clear lists before reuse. Students should use Scratch’s debugging tools like the single-step execution to trace the program flow.
调试是查找和修复错误（bug）的过程。Scratch中常见的错误包括使用错误的变量、缺少循环或在重复使用前忘记清空列表。学生应使用Scratch的调试工具，如单步执行来追踪程序流程。
Greenfield Academy’s IT team will thoroughly test the network and server configuration before going live. This includes stress-testing the server to ensure it can handle thirty simultaneous logins and file saves.
格林菲尔德学院的IT团队将在上线前全面测试网络和服务器配置。这包括对服务器进行压力测试，以确保它能处理三十个同时登录和文件保存。
11. The Role of Logic Gates in Access Control | 逻辑门在访问控制中的作用
Logic gates are the building blocks of digital circuits. They take binary inputs and produce a binary output based on a logical rule. In Greenfield Academy, the server room door access system can use an AND gate: the door unlocks only when a valid keycard is swiped AND the correct PIN is entered. If either is wrong, the door remains locked.
逻辑门是数字电路的构建模块。它们接受二进制输入并根据逻辑规则产生二进制输出。在格林菲尔德学院，服务器室门禁系统可以使用与门（AND）：只有当刷了有效门卡并输入正确PIN码时，门才会解锁。如果任一项错误，门保持锁定。
The truth table for an AND gate (Input A: keycard valid? Input B: PIN correct? Output: unlock signal) shows that output is 1 only when both inputs are 1. Similarly, an OR gate could be used for a fire alarm: alarm sounds if either a smoke detector OR a heat sensor is triggered.
与门的真值表（输入A：门卡有效？输入B：PIN正确？输出：解锁信号）显示，只有当两个输入都为1时，输出才为1。类似地，或门（OR）可用于火警：如果烟雾探测器或热传感器被触发，警报就响起。
| A | B | Output (AND) 输出（与） |
|---|---|---|
| 0 | 0 | 0 |
| 0 | 1 | 0 |
| 1 | 0 | 0 |
| 1 | 1 | 1 |
Understanding logic gates helps students appreciate how hardware processes decisions, a vital link between physical components and the software they run.
理解逻辑门有助于学生领会硬件如何处理决策，这是物理组件与其运行的软件之间的重要纽带。
12. Reflecting on the Case Study | 案例反思
Greenfield Academy’s IT upgrade exercise demonstrates how interconnected the topics in computer science are. From choosing a star topology to programming a Scratch library system, every decision affects the whole system. The case study reinforces the importance of planning, testing, and considering security from the beginning.
格林菲尔德学院的IT升级练习展示了计算机科学中各个主题是如何相互关联的。从选择星型拓扑到编写Scratch图书馆系统，每个决策都影响整个系统。该案例研究强调了从一开始就进行规划、测试和考虑安全的重要性。
Students should now feel confident in applying these concepts to real-world scenarios. Try designing your own case study for a small business or a home network. Think about the hardware, software, and security measures you would recommend.
学生现在应该有信心将这些概念应用于现实世界场景。尝试为小型企业或家庭网络设计自己的案例研究。想想你会推荐的硬件、软件和安全措施。
Remember, computational thinking—decomposition, pattern recognition, abstraction, and algorithm design—is the core skill you continue to develop. Every problem broken down into smaller parts becomes manageable.
请记住，计算思维——分解、模式识别、抽象和算法设计——是你不断发展的核心技能。每个被分解成更小部分的问题都会变得易于管理。
Published by TutorHao | Computer Science Revision Series | aleveler.com
更多咨询请联系16621398022（同微信）
屏轩国际教育cambridge primary/secondary checkpoint, cat4, ukiset,ukcat,igcse,alevel,PAT,STEP,MAT, ibdp,ap,ssat,sat,sat2课程辅导，国外大学本科硕士研究生博士课程论文辅导