(2016) PowerPoint-ICT
(2016) PowerPoint-ICT
(2016) PowerPoint-ICT
1
Programme
Introduction
Paper 1A, Paper 1B, Paper 2D,
Paper 2C
Break
Paper 2A, Paper 2B
Q&A
2
Breakdown of elective (no. of sat)
2016 2015 %
4
Results of ICT (All candidates)
Level % (2014) % (2015) % (2016)
5** 0.7 0.7 0.8
5*+ 2.9 3.0 3.1
5+ 7.1 7.5 7.8
4+ 23.8 25.3 26.5
3+ 48.8 50.1 51.8
2+ 77.8 77.8 80.6
1+ 93.6 94.0 94.3
Note: L5** Top 10% of L5
L5*+ Top 40% of L5 (L5* = next 30%)
5
Performance – Compulsory Part
Average no. of MC items correct = 26
High correlation with Paper 2s and SBA
6
Performance – Elective Part
Equating – performance of candidates
(Elective Part) can be reflected on the
same scale (Equipercentile method )
Performance (Paper 1) of students in
2D > 2A > 2C > 2B
Refer to Grading Procedures & standards-referenced
Reporting in the HKDSE Exam (HKEAA)
7
Grading Procedures
Sample script selection
Standardisation
Post-marking exercise
Panel of judges grading meeting
Internal meeting
Public Exam Board meeting
Refer to Grading Procedures & standards-referenced
Reporting in the HKDSE Exam (HKEAA)
8
2016 ICT Exemplars
Paper 1B: 2 exemplars (1 with annotated
note) @ Level @ language
Paper 2 – selected levels available
Uploaded to www.hkeaa.edu.hk
9
Paper 1A
10
MC Statistics
Best five: Q.9, 27, 29, 34, 40
Poor five: Q.1, 2, 8, 12, 19
Discrimination power:
High five: Q.9, 30, 32, 37, 40
Low five: Q.1, 12, 17, 19, 35
11
Q.1
In Question 1, less than half of the candidates demonstrated
basic knowledge of cell format in spreadsheet and its
application.
*A. -1 (39%)
B. 0 (10%)
C. 1 (27%)
D. 255 (24%)
14
Q.12
In Question 12, the majority of the candidates understood the use of ‘set columns’ and ‘insert a table’. Only
about a third of the candidates were familiar with ‘tab stops’.
Q.12 Peter uses a word processor to produce the rundown of a music performance, as shown below:
15
Q.31
Just below half of the candidates were able to apply basic analytical skills
to trace the algorithm while the others overlooked the last output statement
and its output value ‘15’.
A. 12345 (44%)
*B. 1234515 (47%)
C. 5432115 (6%)
D. 5432121 (3%) 16
Marking (1)
Quality control: standardisation,
checkmarking, control scripts, etc.
Marking
accept common abbreviations (e.g. terms in
C&A guide and glossary)
answers not written in the language medium
entered would not be marked
17
Marking (2)
Marking schemes
Marking guidelines agreed after standardisation
may not exhaust all possible answers
professional discretion and judgment in
accepting alternative answers (correct and well-
reasoned)
18
Paper 1B
Q1
naming of files
folder structure
Q1
2
Q2
LOTTERY, HELLO
They are one correct string and one incorrect string to
validate the algorithms.
RAM, CPU
Q3
consistent user interface -> increase the efficiency
colour mix, font size, contrast -> display images/text in a
comfortable manner
timer, a pop up message to show time duration or friendly
reminder -> display to remind user
Higher in cost
More time is needed to prepare for the implementation of
the solution.
Q4
Database
=IF(B3>=$B$1, 1,0)
Flash memory
light in weight / anti-shock / portable / low
power consumption
weight
battery life
Q5
not unique
PDATE / CUSTNO+PDATE
Q5
44 1-2-2016 10:10
48 21-11-2015 12:20
1
0
Paper 2A
Q1
Q1
Candidate Performance :
(a) Good. (b) Fair. (c) Fair (d) Poor
Generally, not as good as last year.
Q1(b)
Q1(c)
Q1(d)
Q1
Candidate Performance :
(e) Poor. Don’t understand the execution sequence of subquery
Q1(e)(ii)
Q1
Candidate Performance :
(f) Good.
Q2
Q2
Candidate Performance :
(a) Fair. (b)(i) Good.
Q2(a)
Q2
Candidate Performance :
(b)(ii) Fair. Without using the view created in part (b)(i)
(b)(iii) Poor.
Q2(b)(ii)
Q2(b)(iii)
Q2
Candidate Performance :
(c)(i) Very Poor. (c)(ii) Very Poor.
Q2(c)(ii)
Q2
Candidate Performance :
(d) Very poor
(e) Very good
Q2(d)
Q3
Q3
Candidate Performance :
(a)(i) Fair. Only know one disadvantage of “derived attribute”
(a)(ii) Fair.
(b) Fair. Ony have limited knowledge of functional dependency
Q3(a)(i)
Q3(a)(ii)
Q3(b)(ii)
Q3
Candidate Performance :
(c) Satisfactory.
Q3
Candidate Performance :
(d) Satisfactory. The majority of the candidates identified the primary key and foreign
key but did not justify the normal form correctly.
Q3d(ii)
Q3
Candidate Performance :
(e) Satisfactory. Few use “pull-down menu”, “check boxes” and “radio buttons”
Q3 (e)
0 Mark
0 Mark
2 Marks
3 Marks
Q4
Candidate Performance :
(a) Good.
1 Mark
Q4
Candidate Performance :
(b)(i) Very Good.
Q4
Candidate Performance :
(b) (ii) Very Good.
Candidate Performance :
(c) Good.
Q4
Candidate Performance :
(d) Very Good
Q4(d)
0 Mark
4 Marks
4 Marks
Q4
Candidate Performance :
(e) Fair
Q4(e)
Candidate Performance :
(e) Fair
*Many students can only interpret data mining in terms of frequency, minimum and
maximum.
Know Enhance
candidate teaching
performance strategies
2B Qu 1
Mr Li works in the management office of
an airport. He is going to set up a Wi-Fi
network for travellers to access the
Internet through a number of access
points
2B Qu 1a – Network Standards
(a) Mr Li sets up some access points.
They support the following wireless
network standards :
802.11ac, 802.11n and 802.11g
Give two major differences between the
above network standards
2B Qu 1a – Network Standards
suggested
answer
Know the
flexibility
marking
Know the
• max bandwidth / data Not accept
transmission rate
• distance
• frequency support
• number of users
• number of Channels,
MIMO
Know candidate
Satisfactory
performance
Good performance
strategies
(facts memory)
Enhance
teaching
Cannot lost mark here
2B Qu 1b (i) – SSID function
(b) Mr Li configures the SSIDs of the
access points
(i) Explain the function of an SSID in a
wireless network.
2B Qu 1b (i) – SSID function
suggested
answer
Know the
flexibility
marking
Know the
• Identify a Acceptable
network from description
others
Know candidate
Good
performance
Good performance
strategies
• some wrote (facts memory)
Enhance
teaching
unrelated info Cannot lost mark here
2B Qu 1b (ii) – SSID function
(ii) Mr Li should not use the default name
for SSID when setting up the access
points. Why not?
2B Qu 1b (ii) – SSID function
suggested
answer
Know the
flexibility
marking
Know the
• Avoid Acceptable
Confusion from description
others
Know candidate
Good
performance
Good performance
strategies
• some wrote (facts memory)
Enhance
teaching
unrelated info Cannot lost mark here
2B Qu 1b (iii) – SSID Roaming
(iii) Mr Li should use a single SSID for all
access points. Why?
2B Qu 1b (iii) – SSID Roaming
suggested
answer
Know the
flexibility
marking
Know the
• enable roaming Acceptable description
like “shift the
connection from one
AP to another
seamlessly”
Know candidate
Poor
performance
Understand as less
roaming exp for
strategies
• Most cannot
Enhance
teaching
student in wireless env.,
mention roaming but can mentioned their
mobile network exp.
2B Qu 1c (i) – WiFi security
Mr Li sets up two Wi-Fi networks with different
SSIDs, as shown below :
flexibility
marking
Know the
• simpler operation for Not acceptable
airport
• faster transmission
• ease of use for users
• faster connection
Know candidate
Satisfactory
performance
When @ elective,
consideration also have
strategies
Enhance
teaching
practicability (not only
technical point of view)
2B Qu 1c (ii) – WiFi security
(ii) Briefly explain why Mr Li uses WPA2
instead of WEP in Network 2
2B Qu 1c (ii) – WiFi security
suggested
answer
Know the
flexibility
marking
Know the
• WEP has lower
security
Know candidate
Excellent
performance
strategies
Don’t lost mark here
Enhance
teaching
2B Qu 1c (iii) – WiFi security
(iii) What is the difference between
transmitting data in Network 1 and
Network 2
2B Qu 1c (iii) – WiFi security
suggested
answer
Know the
flexibility
marking
Know the
• Data in Network 2 are
encrypted Not acceptable
• different protocol • faster transmission
• overall transmission more • faster connection
simple / faster
Know candidate
Satisfactory
performance
Encryption has no
strategies
effect to transmission
Enhance
teaching
speed
2B Qu 1d (i) – Network
tranmission
(d) (i) Explain why CSMA / CD is not
suitable for wireless network
2B Qu 1d (i) – Network
tranmission
suggested
answer
Know the
flexibility
marking
Know the
• Signal strength Not acceptable
cannot be detected
• should use CSMA / CA
in wireless
environment
Know candidate
Fair
performance
strategies
elaboration about CD /
Enhance
teaching
CA differences
2B Qu 1d (ii) – CD / CA
mechanism
(ii) Suppose that a user is downloading a
file while another user is sending an
email in Network 2. How can CSMA /
CA help avoid collision?
2B Qu 1d (ii) – CD / CA
mechanism
• make sure network is
suggested
answer
Know the
flexibility
marking
Know the
free, and do send out Reasonable
when free description
• re-transmit after a
random period of time
if collided
Know candidate
Fair
performance
strategies
elaboration about CD /
Enhance
teaching
mention collision detection
/ avoidance CA differences
• but not re-transmission
2B Qu 1e – WiFi Set-up
(e) Some shops in the airport provide Wi-
Fi networks for customers. Give two
pieces of advice to these shops on
setting up their Wi-Fi networks
2B Qu 1e – WiFi Set-up
suggested
answer
Know the
flexibility
marking
Know the
• Meaningful SSID
Reasonable
• Good encryption
description
• Pre-shared key for
access
• channel
Know candidate
Fair
performance
• some students
Try give experience to
strategies
student in setting up
Enhance
teaching
mentioned location of AP,
AP on/off time etc AP
Q2
flexibility
marking
Know the
• 210.0.205.237
Know candidate
Excellent
performance
Basic understanding /
strategies
fact
Enhance
teaching
Don’t lost mark here
2B Qu 3a (ii) – IP addresses
(ii) What is the use of the other IP address?
2B Qu 3a (ii) – IP addresses
suggested
answer
Know the
flexibility
marking
Know the
•Connect the
internal network
Know candidate
Excellent
performance
Basic understanding /
strategies
fact
Enhance
teaching
Don’t lost mark here
2B Qu 3b – Network
Implementation
2B Qu 3b (i) – AP loading
flexibility
marking
Know the
• 1 router = 1G / 15M
= 66 student
• 2 routers = 66 * 2 = 132
Know candidate
Poor
performance
strategies
Enhance
teaching
involved the decimal point Reference for internal
value of @ AP assessment
2B Qu 3b (i)
2B Qu 3b (ii) – Overhead of
packet
(ii) The school should set the number of
available network connections to a
smaller number than the maximum
number of students in (b) (i). Why?
2B Qu 3b (ii) – Overhead of
packet
suggested
answer
Know the
flexibility
marking
Know the
• because there has
overhead
• student may have >1
device
Know candidate
performance
Overhead making
Good
strategies
theory capacity < >
Enhance
teaching
practical acceptability
2B Qu 3b (iii) – Redundancy
flexibility
marking
Know the
• Coverage
• redundancy
• load-balancing
Know candidate
performance
strategies
coverage and
Enhance
teaching
redundancy but not
load-balancing
2B Qu 3c – AP setting
2B Qu 3c (i) – DHCP adv
flexibility
marking
Know the
• more simple setup Not acceptable
• less human error •Server assign IP
Know candidate
Fair
performance
strategies
Enhance
teaching
student simply mention question ask for
“what is DHCP” instead of
“DHCP adv”
2B Qu 3c (ii) – Network info
flexibility
marking
Know the
(1)Different
(2)Same
(3)Same
(4)Same
Know candidate
Good
performance
Basic
strategies
Enhance
understanding / fact
teaching
Don’t lost mark here
2B Qu 3c (iii) – Gateway definition
flexibility
marking
Know the
• device connecting to Not acceptable
external network
• Change IP
• select best route
Know candidate
Good
performance
strategies
Enhance
teaching
up Gateway with router vs modem
Router
2B Qu 3d (i) – AUP (ethical)
flexibility
marking
Know the
• language (netiquette)
Reasonable
• websites (gambling / answers
pron.)
• copyright
Know candidate
Good
performance
strategies
Enhance
teaching
well understand by answer
student
2B Qu 3d (ii) – AUP (non-ethical)
flexibility
marking
Know the
• disclaimer
Reasonable
• device security answers
• etc
Know candidate
Fair
performance
strategies
Enhance
teaching
any T&C other than
ethical one
Q4
Agree. PING can be used to access web servers.
Hackers could control infected computers to issue a
tremendous number of accesses to a web server by
using PING, leading to a denial-of-service (DoS)
attack.
Summary of teaching strategies
Practical experience is important
Care about question scenario
Need to know the main concern and
answers’ priority
Give two examples ==> two distinct
examples
More practical scenario link up to theory
during practice
Paper 2C
Q.1(a)
芝芝打算建構一個用作網上學習的網站。她使
用 HTML 編寫網頁。
(i) 試舉出支持使用HTML 最新版本的一個理
由。
More useful features (functions) are
supported (improved), e.g. built-in canvas. /
More bugs are fixed (corrected)./
Some new standards can be followed.
easier
plug-in may not be required
Q.1(a)
(ii) 試舉出反對使用HTML 最新版本的一個理
由。 Old browsers do not support it
(compatible).
training is required.
Hardware / OS not supported
Q.1(b)
芝芝將會上載一些視像至網站。她可使用
MP4 或 WMV 作為視像格式。
(i) 試舉出支持使用 MP4 的一個理由。
The compression ratio is larger. (smaller file
size) /
No extra plugin is required. (support)/
分為 3 個文本欄位
Q.2(b)
用戶需要在「入住」、「退房」和「入住日數」文本
框鍵入資料。然而, 只需這三個文本框內其中
兩項資料便足以搜尋酒店。
(i) 試舉出支持同時使用這三個文本框的一個
理由。
It helps users verify / 校驗 their input data.
如果只是寫確保資料正確、無誤
Q.2(b)
(ii) 試建議及描述一個有效性檢驗的檢查來改
善此網頁設計,以便更準確及更有效率地收集
這些資料。
non-positive integers are not allowed in the ‘Length of
Stay’.
入住日期 >= 今天日期
退房日期 > 入住日期
存在檢查:輸入目的地、成人、小童 (入住、入住日數、退房)
類型檢查(整數、非負數):入住日數、成人、小童
格式檢查(日期 / 月份 / 年份):入住、退房
入住日數不應該 < 1 天
Q.2(c)
(c) 很多用戶批評用來比較酒店的網頁的設計
, 如下展示:
旅行社打算加入以下項目, 幫助用戶列出理
想的酒店。試描述這些項目如何能幫助用戶。
Q.2(c)
(i)複選框
Select a few requirements such as bed
size and room size.
同時滿足多項選擇
可選擇多間酒店作比較
Q.2(c)
(ii) 範圍搜尋
Reduce number of hotels by a price
range. / star range
Q.2(c)
(iii) 單選按鈕
Select only one item (smoking or non-
smoking)
( 二者選其一 )
Q.2(c)
(iv) 多級排序
Sort the number of Stars and then the
Price.
Q.2 (d)
網站提供酒店的網上地圖。例如, 當用戶點擊
BB 酒店的地圖按鈕, BB 酒店的地圖便會出
現, 如下展示:
Q.2 (d)
(i) 試建議可幫助用戶找出酒店位置的三個附
加地圖功能。
• Zoom in/out,
• navigation,
• 3D map, aerial map(實景圖), hybrid map
(實景地圖), street view (街景), 酒店圖片
• Show present user position, GPS 功能
• route plan
• Show nearby transport, 地鐵站,地標
• Print map
• 酒店地址,坐標,方向
Q.2 (d)
(ii) 旅行社發現自己建立和維護網上地圖是很
昂貴和複雜的。試為旅行社建議一個能提供網
上地圖的替代方法。
只有很少數考生提及到流動裝置的小屏幕上
長寬比
輸入數據的問題。
能力稍高的考生能夠清楚地描述應該以
網頁設計技巧
特點來考慮有關因素。
1× 3
row span (橫列延展), alignment (對齊),
padding (墊充/墊塞),
border width (邊界/邊框寬度)/border (邊
界/邊框/框線), background color/colour,
(valign (垂直對齊) and align (水平對齊)
are considered 2 different attributes)
Accept: Attribute name (e.g. rowspan,
bgcolor) (包括中文應考學生)
Not accepted
merge cell, colspan, table width, width,
height, column header(<th>)
表格顏色, 表格粗度, 顏色, 放於中間/Put
in at the center, Table line,
頁框, 框架, 粗框, 外框, 表格框, 外框, 表
格邊, 表格線
置中, 置左, center
欠佳
考生用字籠統,沒有給予在網頁設計方面
的答案。
1× 3 AcQ (single user)
Matching game
Game with options
(e.g. Drag-n-drop, Draw line, Menu/List, MC (limited options) or other
reasonable answer)
Not accept:
Fill in the blanks
* Marking criteria
Illustrate a comprehensive and
logical answer
Illustrate a relevant answer, eg.
different browsers
1× 2
The character set of the web page
keywords of the web page for search
engines
description of the web page / keywords /
title / author / copyright / creation date,
modification date, date of last-update /
character encoding / refresh web page /
re-direction
欠佳
大多數考生了解到在網頁瀏覽中錯誤超
鏈結和遺漏檔案的情況。
只有少數考生能夠列舉出網頁中使用元
數據的內容。
1× 3
ALL 4 scripts are needed (onClick;
when .. clicked; if … clicked)
manipulating N, ie NN+1, NN-1
assignment of variable is shown
toggle images / swap images / hide
and show / change object / replace /
(3) Requirements
(2) Design
(2) Design
****
(4) Implementation
***
It requires user involvement during implementation. /
or It has low program re-usability. /
*
Q1
-1
-1
****
3
-1
Q2
Q2
Queue 隊列 ***
****
5 3
next
(next + 1) mod n
***
start
(start+n-1) mod n
next - start
**
next + n - start 2
Q2
• Initialize total to 0
total 0 • If S[i]=2 then
i start • increase total
while i <> next do • Display total
• All correct ***
if S[i] = 2
then total total + 1
i remainder of (i+1)/n)
display total
Q3
1, 3, 4, 11, 20 2 *****
*****
****
- 4 cells are grouped into an island
- each island can rotate in 4 positions
Q3
*****
Q3
No 3 'B's in an island
all correct ****
***
- 4 cells are grouped into an island
- each island can rotate in 4 positions
Q4
Q4
Ensure that column col still has space for an additional disc.
/ ****
or Check if the column is full or not.
col
col i
****
4
Q4