Information and Communication Technology 試験対策

よくあるミス

1. 1high影響する配点: 2Data Manipulation and Analysis

   Omitting absolute reference symbols ($) in spreadsheet formulas during replication questions.

   回避方法: Always check if the reference range (especially lookup tables like A2:B5) should remain fixed when copied down. Write them as $A$2:$B$5.
2. 2medium影響する配点: 2Data Representation

   Confusing transmission bitrate (e.g. video streaming requirements) with static file size properties.

   回避方法: Verify if the question asks for a transmission constraint (bps, kbps, Mbps) or a static file storage capacity (Bytes, KB, MB) and apply the correct conversion factor (8 bits = 1 Byte).
3. 3medium影響する配点: 1Data Organisation and Data Control

   Performing simplified division for bin-packing storage calculations without respecting individual file integrity.

   回避方法: Realize that individual files (e.g., a 300GB video file) cannot be split across separate physical hard disks. Allocate files sequentially to each disk instead of dividing total GBs directly.
4. 4high影響する配点: 3SQL (Databases)

   Omitting the GROUP BY clause in SQL when SELECT lists both raw columns and aggregate functions.

   回避方法: Whenever aggregate functions like SUM, COUNT, or AVG are paired with a raw non-aggregate field, you must append GROUP BY with that exact raw field.
5. 5medium影響する配点: 1Algorithm Design

   Using parentheses instead of standard bracket notation for array indexing in pseudo-code writing.

   回避方法: Strictly use standard square brackets A[i] for array elements in any algorithmic and pseudo-code responses to avoid syntax point deduction.
6. 6medium影響する配点: 1Threats and Security on the Internet

   Misunderstanding the primary function of CAPTCHA as encrypting passwords or security data.

   回避方法: Clearly state that the purpose of CAPTCHA is identity verification to distinguish automated computer programs (bots) from human users.
7. 7high影響する配点: 2Networking and Internet Basics

   Assuming a 5GHz Wi-Fi signal has higher physical wall penetration power than a 2.4GHz signal due to its frequency.

   回避方法: Understand that higher frequency signals (5GHz) have shorter wavelengths and scatter more, leading to lower penetration power than 2.4GHz.
8. 8medium影響する配点: 2Relational Databases Concepts

   Confusing the DROP TABLE command with DELETE FROM in relational databases.

   回避方法: Remember that DROP TABLE deletes the entire table schema and structure from the database, while DELETE FROM only removes records within the table, keeping the schema structure intact.