DSE ICT 試題解答

又靚又實用，ICT Compulsory 成個 Unit B，14 幅 Infographics 半小時搞好！AI 年代嘅 productivity 係 exponential 咁上升。

DSE ICT Compulsory Unit B - Computer System Fundamentals Enjoy the videos and music you love, upload original content, and share it all with friends, family, and the world on YouTube.

https://youtu.be/uq94r-K_eFE

XLOOKUP 唔使煩 [Cantonese] [Hong Kong Dialect](Intro - 激昂的電結他前奏，配合鼓點)(喊聲：Check it out! Excel Master! Let’s Go!)(Verse 1)做 Excel 做到我好想喊Data 太多 睇到眼都花(VLOOKUP? 唔好同我講喇)要 Count ...

https://youtu.be/zfB_BN134q8
最近不停試用 suno.com 作曲，佢嘅廣東話唱得越來越正，我整左一首鼓勵 DSE ICT 考生嘅歌曲 (雖然今年我會有教中六)，歡迎 share 給大家嘅應考同學集收聽 。

Bit 與 Byte 的約定 - 為 DSE ICT 考生打氣 [Cantonese] [Hong Kong Dialect][Light and Airy Acoustic Pop][Intro](Gentle acoustic guitar strumming with a soft piano melody)[Verse 1]窗邊的燈光 照亮過期嘅 Notes讀到 Bi...

我用 AI 分析了 2023年DSE 1A 試卷的官方多項選擇題統計數據：

多項選擇題正確率 (%) 數量
0-39 4
40-49 1
50-59 9
60-69 8
70-79 10
80-89 5
90-100 3

以及同年考生達到特定水平的百分比：

水平 百分比
U 6.4
1+ 93.6
2+ 81.6
3+ 55.5
4+ 32.7
5+ 12.2
5*+ 4.9
5** 1.3

AI 就估算了 2023年 1A 試卷的以達標分數：

透過 AI 分析過往 10年 Paper 2A (Database) past paper，效率遠超自己做， 實在驚嘆 AI 的威力！

Here are the top 10 most popular topics with details on the specific areas covered under each:

SQL (66 instances)

Writing SELECT queries with WHERE, ORDER BY, GROUP BY, HAVING clauses
Applying joins (INNER, OUTER, SELF), subqueries, correlated subqueries
Using aggregate functions like COUNT, SUM, AVG, MAX, MIN
Performing set operations like UNION, INTERSECT, MINUS/EXCEPT
Data manipulation commands - INSERT, UPDATE, DELETE
Using date/time functions and clauses
Creating/altering tables, defining constraints using DDL commands
Understanding query purpose, results, and performance

Normalization (22 instances)

Identifying functional dependencies
Normalizing databases up to 3rd Normal Form (3NF)
Checking normal forms of given table designs
Understanding benefits and drawbacks of normalization
Removing redundancies, anomalies through normalization
Redesigning tables after normalization

ER Diagram (13 instances)

Drawing ER diagrams from given requirements
Mapping entities, attributes, relationships
Representing cardinality constraints, participation constraints
Suggesting table attributes based on ER models

Keys (13 instances)

Identifying primary keys, foreign keys, candidate keys
Assigning keys after normalization
Understanding purpose and properties of keys
Defining alternate candidate keys

Integrity (12 instances)

Entity integrity and use of primary keys
Referential integrity and foreign key constraints
Domain integrity and valid value ranges
Identifying integrity constraint violations
Defining integrity constraints using SQL

Index (11 instances)

Creating indexes using SQL
Evaluating performance impact of indexes
Deciding fields to index based on access frequency
Benefits and drawbacks of indexing
Dropping indexes using SQL

Views (5 instances)

Creating views using SQL
Querying with views, utilizing views
Understanding benefits of using views
Explaining purpose of view usage

Database Design (4 instances)

General database design principles
Data redundancy considerations
Usage of derived attributes
Merging/integrating database designs

Data Types (3 instances)

Suggesting appropriate data types
Defining data type constraints
Understanding numeric, character, date/time types

Set Operations (2 instances)

Using UNION and UNION ALL
Differentiating UNION from UNION ALL

The questions spanned conceptual understanding, query writing skills on various SQL aspects, modeling data using ER diagrams and normalization techniques, managing keys and enforcing integrity constraints, indexing for performance, utilizing views, and some general database design considerations.

DSE 2024 ICT MC (Q21 to 40) - explained by GPT-4

DSE 2024 ICT MC (Q21 to 40) - explained by GPT-4

DSE 2024 ICT MC (Q1 to 20) - explained by GPT-4

DSE 2024 ICT MC (Q1 to 20) - explained by GPT-4

DSE 2024 ICT MC Answers - 實測 GPT-4 答啱 9 成 💪🏻

DSE 2024 ICT MC Answers - 實測 GPT-4 答啱 9 成 💪🏻 Answers by GPT-41-5: BADCA6-10: DBCCD11-15: CBAAD16-20: AACCC21-25: BABDD26-30: BBDBC31-35: DDACB36-40: ABCDB

今日同一些中六同學，重溫 ICT Elective D 課程大綱，即係 official 嗰個 C&A Guide，其實這個 guide line 真的有效把整個課程 summarise，當然只得重點。但影片內我有介紹如何用 Poe 及 YouTube 找 keyword 相關資料，相信有參考價值。

影片未有時間剪輯，請按需要 skip 嚟睇：

2024.3.4 S6 ICT Elective D Revision Session

這一題是要小心 output statement 出現的位置。

DSE 2023 ICT MC 31 (41%) - Tracing algorithm