Download - Content Section b2 New
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 1/20
SEMINAR KECEMERLANGAN MATA PELAJARAN ICT(3765/1)
2012
BAHAGIAN B(20 MARKAH)
NAMA SEKOLAH
NAMA
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 2/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
LEARNING AREA 1: ICT AND SOCIETY
1. The following is a statement on information privacy.
Based on the statement, list four ways of making personal data more private.
[4 marks]
i) _____________________________________________________
ii) _____________________________________________________
iii) _____________________________________________________
iv) _____________________________________________________
SPM2007
2. Electronic mail is one of the most popular services on the internet. It makes businessmanagers and administrators more productive by allowing them to share information, ideasand opinions easily.
In relation to electronic mail, state two examples in each case which can beconsidered as:
a) Ethical
i) _______________________
ii) _____________________
b) Law breaking
i) ______________________
ii) _________________________________________________
[4 marks]
SPM2008
Bahagian B 2
“Information privacy refers to the right of individualsand organisations to deny or restrict the collection and
use the information about them”
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 3/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
3. Figure1 shows a pop-up message to computer users.
Figure 1
(a) State two ways that causes the pop-up message to appear on the computer screen.[2 marks]
i. _____________________________________________________
ii. _____________________________________________________
(b) State two kinds of serious damages if a user ignore the message. [2 marks]
i. _______________________________________________________
ii. _______________________________________________________
SPM2011
LEARNING AREA 2: COMPUTER SYSTEMS
4. Figure 2(a) and 2(b) show different types of software.
State four differences between the software listed in Figured 2(a) and Figure 2(b). [4 marks]
SPM2007
Bahagian B 3
2(a) 2(b)
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 4/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
5. Table 1 shows two types of software and information that will be used by the softwareengineer to develop a system within a limited period of time.
Type of software Information
Open source Source code is free and available to user
Proprietary Source code is copyrighted and not availlable to user
Table 1
a. What type of software should he choose? [1 mark]
b. Give three reasons to your answer. [3 marks]
i. ______________________________________________________
ii. ______________________________________________________
iii. ______________________________________________________
SPM2009
6. Figure 3 is a pie chart showing how students of SMK Taman Gembira communicate with
their friends.
SPM
2010
Bahagian B 4
SMS
Letters
Figure 2(a) Figure 2(b)
i)
ii)
iii)
iv)
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 5/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
Figure 3
a. State one reason why the students choose email to letters.
__________________________________________________________
b. State three reason why email is better than Short Messaging System usinghandphone
i. _____________________________________________________
ii. _____________________________________________________
iii. _____________________________________________________
7. Read the following situation.
(a) (i) Suggest a type of software to be used by the Club Secretary.
_______________________________________________________
(ii) Give one reason why you choose the software. [2 marks]
_______________________________________________________
b) (i) Suggest a type of software to be used by the Club Treasurer.
______________________________________________________
(ii) Give one reason why you choose the software. [2 marks] _______________________________________________________
SPM2011
LEARNING AREA 3: COMPUTER NETWORKS AND COMMUNICATIONS
Bahagian B 5
Your school computer club is having its annual general meeting next month. The Club
Secretary is to prepare the report on the activities of the year, and the Club Treasurer
is to prepare the annual accounts.
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 6/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
8. Figure 4 shows a computer network at Bank Sufi. Two networks, Network A and Network Bare part of the bank’s wide area network. Currently the bank implements two networkcommunications technology. Apart from Internet, the bank also has its own intranet tofacilitate their internal communications.
State two differences between Network A and Network B for the bank. [4 marks]
SPM2007
9. Figure 5 shows two different network topologies SPM2008
Bahagian B 6
Network A Network B
i)
ii)
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 7/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
Figure 5
a) State the difference on how data being transmitted in Topology A and Topology B
_________________________________________________________
_________________________________________________________
_________________________________________________________
b) State two advantages of Topology B.
__________________________________________________________
__________________________________________________________
10. The following is a text on network communication technology for a company.
Based on the text:
a) State the type of network communications technology used in X and give reason.
______________________________________________________
b) Give one differences between Y and the internet.
______________________________________________________
SPM2008
11. Read the following situation:
a) (i) State the name of the type of network architecture used
___________________________________________
(ii) Give one feature of this type of network. [2 marks]
___________________________________________
SPM2009
Bahagian B 7
Sam has two personel computers at home. He wants both computers toshare data, files and applications using a crossed cable.
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 8/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012(b) Sketch the network architecture. [2 marks]
12. Figure 6 shows the location of the headquarters and branches of Company X. Company Z is
a customer of Branch R.
SPM2010
Bahagian B 8
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 9/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
Figure 6
Based on Figure 6
(a) Explain the type of network for Company X to connect its headquarters with all its branches.
_____________________________________________________________
_____________________________________________________________
_____________________________________________________________
(b) (i) Suggest the type of private network communication technology to
be used between Branch R and Company Z
______________________________________________________
(ii) Justify your answer
______________________________________________________
______________________________________________________
13. Figure 7 shows a network of computers. SPM2011
Bahagian B 9
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 10/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
Based on Figure 7, explain the structure of the network. [4 marks]
_______________________________________________________________
_______________________________________________________________
_______________________________________________________________
LEARNING AREA 4: MULTIMEDIA
14. Table 2 shows two methods how Malisa and David get the informations from anencylopedia.
Users Methods
Malisa Uses encyclopedia stored on CD
David Reads from the encylopedia
Table 2
State four advantages of using an encyclopedia stored on CD.
i)
ii)
Spm2007
Bahagian B 10
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 11/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012iii)
iv)
15. Figure 8 shows two editing interfaces X and Y for a web-designing workshop. More studentsregisterd to use Y and X.
Figure 8Based of Figure 8,
(a) Identify the type of web editor shown[2 marks]
i. X: ________________________
ii. Y : ________________________
(b) Give two reasons why interface Y has attracted more students than interface X. [2 marks]
i. ____________________________________________________ ii.
iii. ____________________________________________________
SPM2009
16. Figure 9 shows a web page in a web editor
Spm2010
Bahagian B 11
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 12/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
Figure 9
Based on Figure 9:
(a) State two advantages of using this type of web editor.
___________________________________________________________
___________________________________________________________
___________________________________________________________
___________________________________________________________
(b) Based on user interface principles, give two modifications which wouldimprove the design
___________________________________________________________
___________________________________________________________
___________________________________________________________
___________________________________________________________
___________________________________________________________
___________________________________________________________
17. Figure 10 shows a digital catalogue. SPM2011
Bahagian B 12
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 13/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012Figure 10
Based on Figure 10:
(a) What is the medium of delivery used by Top Apparel?
________________________________________________________
Justify your answer. [2 marks]
________________________________________________________
(b) Give two advantages of using the medium of delivery in (a). [2 marks]
i. _____________________________________________________
ii. _____________________________________________________
LEARNING AREA 5: PROGRAMMING
18. Figure 11 shows the flow chart for a program that converts US Dollar (USD) to
Ringgit Malaysia (RM).
SPM2008
Bahagian B 13
Start
Enter the amount in
USD
Enter the amount in USD Amount_in_USD*exchange_rate
Enter the amount inUSD
End
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 14/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
Figure 11
Based on Figure 11:
a) Which element in the program can be defined as a constant?
________________________________________________________
Give one reason for your answer.
________________________________________________________
________________________________________________________
b) What control structure is used?
________________________________________________________
Give one reason for your answer.
________________________________________________________
________________________________________________________
19. Figure 12(a) shows the input interface and Figure 12(b) shows the output interface of aprogram
Based on Figure 12(a) and Figure 12(b)
(a) (i) State the data type that should be used for both interface.
SPM2009
Bahagian B 14
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 15/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
_______________________________________________________
(ii) Give a reason for your answer. [2 marks]
______________________________________________________
(b) (i) Should the Numerator declared as a constant?
_______________________________________________________
(ii) Give a reason for your answer. [2 marks]
_______________________________________________________
20. Figure 13 shows a user interface of a program used in Holborn Restaurant to calculate the
yearly bonus for their employees. The employees who have been working for at least threeyears will be given a bonus of RM1 000.
Figure 13
Based on Figure 13 :
(a) State an appropriate data type for the variable „Identity Card No.‟
_____________________________________________________________
State one reason for your answer
_____________________________________________________________
SPM
2010
Bahagian B 15
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 16/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
(b) Identify the control structure used in the program
_____________________________________________________________
Justify your answer
_____________________________________________________________
LEARNING AREA 6: INFORMATION SYSTEMS
21. You keep a data base of your friends’ names, addresses and dates of birth. The database is kept in the school server and can be retrieve by other user.
a) State two uses of the information from the data base to be utilized.
__________________________________________________________
__________________________________________________________
b) State two problems that may arised by having shared data base. [4marks]
__________________________________________________________
__________________________________________________________
SPM2007
22. Figure 14 (a) shows two tables created in the school co-curriculum system atSekolah Menengah Batu Tiga.
Figure 14 (a)
Figure 14 (b) shows a Simple Query Wizard.
SPM2008
Bahagian B 16
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 17/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012Figure 14 (c) shows a query design to retrieve information based on a certain criterion.
Figure 14(b)
a) Based on Figure 14 (a) and Figure 14 (b), state one more field that should be moved to thelist X in Figure 14 (b), to view the grades of co-curricular activities for each student.
________________________________________________________________
Figure 14 (c)
b) Based on the query design in Figure 14 (c), complete the query results below to show theinformation obtained.
Bahagian B 17
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 18/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
23. The following are attributes for a library database12
(a) (i) Group the attributes into two related tables
(ii) Draw a line to show the relationship between the two tables. [3 marks]
(b) State the type of relationship : ______________________ [1 mark]
SPM2009
24. Figure 15 shows the interrelation of five main components of an online ticketing system for acinema.
Figure 15
SPM2010
Bahagian B 18
Class Stu_ID Name Postion CoCu
P4A
P4C
S5A
7/30/2019 Content Section b2 New
http://slidepdf.com/reader/full/content-section-b2-new 19/20
Seminar Kecemerlangan Mata Pelajaran ICT Tahun 2012
Based on Figure 15 :
(a) State one example of component:
(i) B : ______________________ (ii) C : _______________________
(b) Describe the interrelation between Component A and Component E.
______________________________________________________
_____________________________________________________________
_____________________________________________________________
_____________________________________________________________
25. Table 3 shows two coufse packages offered by a fitness centre and the information of thepackages.
Table 3
Based on Table 3 and the information of the packages, identify:
(a) Three attributes for MEMBER table. [3 marks]
__________________________________________
__________________________________________
__________________________________________
(b) One attribute for PACKAGE table. [1 mark]
SPM2011
Bahagian B 19
Package A
RM 1 000
Package B
RM 1 800
Each member will only register for either one of the packages.
The fitness centre wants to create a database to stole personal details of its member.
The database should be designed such that the centre can view the member's
information for each package.
The primary key for each table has been given:
- MEMBER table: member-ID
- PACKAGE table: Package-ID