Manual ICT 2022

Download as pdf or txt
Download as pdf or txt
You are on page 1of 75

RESTRICTED

MAJLIS PEPERIKSAAN MALAYSIA


(MALAYSIAN EXAMINATIONS COUNCIL)

PEPERIKSAAN
SIJIL TINGGI PERSEKOLAHAN MALAYSIA (STPM)
(MALAYSIA HIGHER SCHOOL CERTIFICATE EXAMINATION)

Manual for
Information and Communications
Technology (ICT) Coursework
Paper 4 (958/4)

STPM 2022

REMINDER:
This manual is specifically for the use of teachers or examiners only and should not be given to
unauthorised persons.
___________________________________________________________________________

This manual consists of 75 printed pages.


 Majlis Peperiksaan Malaysia 2021

RESTRICTED
RESTRICTED

Contents

Page

Part 1: Teacher’s Manual for Information and Communications Technology


(ICT) Coursework
1.1 Introduction 1
1.2 Aims 1
1.3 Coursework 1
1.4 Implementation 1−2
1.5 Assignment Report 3
1.6 Assessment 3
1.7 Moderation 3
1.8 Assignment Record 3–4
1.9 Coursework Summary Table 4
1.10 Marking Schemes for Assignments 4 − 16

Part 2: Examples for Information and Communications Technology (ICT)


Coursework
2.1 Example for Assignment A: Multimedia Development 20 − 28
2.2 Example for Assignment B: Programming 29 − 35
2.3 Example for Assignment C: Information Systems Development 36 − 51

Part 3: Student’s Manual for Information and Communications Technology


(ICT) Coursework
3.1 Introduction 2
3.2 Coursework 2 – 22

RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Part 1: Teacher’s Manual for Information and Communications Technology


(ICT) Coursework

1.1 Introduction

The manual consists of the administration of ICT Coursework the guidelines on the
implementation and assessment of coursework which needs to be implemented by the schools.

1.2 Aims

The aims of the Information and Communications Technology (ICT) Coursework are to
develop students knowledge and skills in multimedia development, programming and
information systems development.

1.3 Coursework

1.3.1 The coursework comprises three assignments: Assignment A: Multimedia


Development, Assignment B: Programming and Assignment C: Information Systems
Development.

1.3.2 The assignments need to be completed by students in the respective semesters.

1.3.3 The coursework comprises practical assignments which are to be solved by candidates
in computer laboratories during practical periods under supervision and monitoring of
the teacher or after school hours within the duration given.

1.3.4 The assignment should be submitted to the teacher in the respective semesters to be
assessed according to the regulations contained in this manual.

1.4 Implementation

1.4.1 This coursework requires the following hardware:


(a) Multimedia personal computers which can support the software as stated in
section 1.4 below. The ratio of computers to the number of students should be at
most 1:4
(b) A scanner
(c) A printer
(d) A digital camera/digital video camera
(e) A CD/DVD writer

1 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

1.4.2 The school must provide at least one software for each category as proposed in the table
below.

Assignment Category Software

A Browser Internet Explorer


Netscape Navigator
Multimedia Development
Mozilla
Safari

Multimedia Macromedia
Software Authorware
Macromedia Director
Action script
Lingo
Macromedia Flash

Graphic Software Adobe Photoshop


Illustrator

Audio Software Sound Forge


Adobe Audition
Wavelab
Audacity

Editing Software Adobe Premier


Pinnacle
Avid Express

B C or C++ Compiler ANSI C


Turbo C++
Programming
Borland C++

C Database MS Access
Management SQL Server
Information Systems Development
Systems Foxpro
Oracle
Lotus

Diagramming Visio
Software Smart Drawing

1.4.3 The school authority is required to make copies of Part 2 to be given to each student.

1.4.4 The teacher should provide explanation on each assignment to the students before it is
carried out.

1.4.5 Students should be given the required skills before the assignment is given and
assessment is made.

2 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

1.5 Assignment Report

1.5.1 Student must complete the assignment individually. Plagiarism will be penalised.

1.5.2 Assignments may be written either in English or Malay.

1.5.3 The teacher is required to set the deadline for the submission of each assignment based
on the duration given in the specified date. Marks will be deducted for late submission
as stated in the Marking Schemes for each assignment.

1.5.4 Once an assignment report is submitted, it is not allowed to be revised or replaced.


Adding or removing of any material to or from the assignment report is prohibited.

1.5.5 Students must complete and submit the assignments according to the criteria stipulated
in Part 2.

1.6 Assessment

1.6.1 The teacher is required to assess each assignment and record the marks in the Student
Record as specified in the Assessment Criteria in Part 1.

1.6.2 Students, work should be annotated by the teacher in the margin or in the text of the
student’s assignment reports.

1.6.3 The total mark should be calculated and recorded in the Student Record. The maximum
overall total mark for the coursework is 250.

1.6.4 The assessment of the coursework must be completed four weeks prior to the written
examination of the third semester.

1.6.5 The student may be given grade ‘X’ for the subject grade for failing to send the
coursework on the specified deadline.

1.7 Moderation

1.7.1 A common standard for marking must be agreed upon and used if more than one
teacher is involved in assessing the assignment to ensure that the internal assessment is
carried out fairly and effectively.

1.7.2 An approved moderator will be assigned to each school by Malaysian Examinations


Council (MEC) for standardising marks across several schools.

1.8 Assignment Record

1.8.1 All copies of the following:


(a) Student Record form;
(b) Declaration Record form;
(c) Printed and softcopies of the final reports on Assignment A, Assignment B and
Assignment C; and
(d) Final products on Assignment A and Assignment C must be kept by teacher, and
should be kept under the secure condition from the time it is assessed in case it is
required by the moderator and MEC.

3 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

1.8.2 The Declaration Form must be completed by the teacher and student and verified by the
school principal.

1.8.3 The principal of a student who has transferred to another school has to submit the
Student Record to the principal of the new school. These records must be certified by
the subject teacher of the former school.

1.8.4 All of the students’ work and record are evidence. It must be kept under secure
condition until six month after the STPM result is released in the following year by the
school.

1.8.5 The overall total mark of the coursework for each student must be submitted to MEC
via electronic submission at the specified date by the teacher at the school.

1.9 Coursework Summary Table

Assignment Semester Number of Task Mark

A 6
Multimedia Development 1 A1, A2, A3, A4, A5, A6 90
and Documentation

B 5
Programming 2 B1, B2, B3, B4, B5 80
and Documentation

C 4
Information Systems Development 3 C1, C2, C3, C4, C5 80
and Documentation

Note: Maximum marks for coursework is 250.

1.10 Marking Schemes for Assignments

Assignment A: Multimedia Development


Each task should be assessed based on the Assessment Criteria below.

Assessment Criteria for Task A1: Idea Analysis

Assessment Criteria Description Mark Max Mark


1. Analysis Study Complete and organise analysis
study with a clear and concise
2 2
idea to represent the subject
matter
2. Project Cost Estimation Propose reasonable cost
1 1
estimation
3. Project Timeline Propose a project timeline with
1 1
the aid of a project Gantt Chart

4 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Assessment Criteria Description Mark Max


Mark
4. Content Outline Complete and organise content outline
with a clear and concise idea to represent 1 1
the subject matter
5. Content, Technology Content
and Delivery − a clear and concise idea of the 1
Analysis subject matter
Technology
− appropriate hardware and 1 3
software to be used
Delivery
− appropriate platform for 1
implementation
Penalty for late submission −2
Total Mark for Task A1 is 8

Assessment Criteria for Task A2: Task Planning

Assessment Criteria Description Mark Max Mark


1. Project Goals Definition Clear and concise project goals
definition to reflect the given 1 1
project
2. Skill Sets Requirement Reasonable skill sets requirement
to be applied to develop the given 1 1
project
3. Quality of Multimedia Reasonable quality of multimedia
Attributes List attributes list for evaluation of the 1 1
final product
4. Reviewed Content Reasonable review of content
Outline 1 1
outline for the final product
Penalty for late submission −2
Total Mark for Task A2 is 4

5 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Assessment Criteria for Task A3: Prototype Development

Assessment Criteria Description Mark Max Mark


1. Screen Mock-up Multimedia elements
− appropriate use of text, image, 1
animation, audio and video in
screen mock-up
Elements of design
− appropriate use of 2D or 3D in 1
screen mock up
Principles of design organisation 4
− appropriate selection of
harmony, variety, balance,
1
proportion, dominance,
movement and economy in
screen mock-up
Overall
− good look and feel of the 1
screen mock-up
2. Content Maps and User Clear content maps
Interface – clear navigation and link
between icons, objects, 2
graphics and movement from
one screen to another
4
User interface
– ability to suggest a clear
composition and linkage of all 2
multimedia elements in an
easy to use manner
3. Overall Story Local content
– giving priority to select local 2
content to be one of the most
important features 3
Overall context
– ability to connect the overall 1
subject matter

6 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Assessment Criteria Description Mark Max Mark


4. Initial Prototype Fulfilling the design content
2
based on the screen mock-up
Fulfilling the multimedia
technology and delivery medium
2 5
identified in the idea analysis
report
Overall
1
– good implementation
Penalty for late submission −2
Total Mark for Task A3 is 16

Assessment Criteria for Task A4: Alpha Development

Assessment Criteria Description Mark Max Mark


1. Storyboard and Flowchart Complete storyboard
Design – sketch all modules with clear
3
instructions for various
elements of media 5
Flowchart
– a clear logical flow of 2
navigation for the production
2. Final Story Script Content
– discuss and suggest
2
improvement based on the
client’s requirements
Overall 4
– ability to fulfil client’s
requirements
2
Note: the client may be the
teachers or person assigned by the
teachers
3. Multimedia Production Multimedia elements
(audio, video and – effective use of text, image,
2
graphics) animation, audio and video in
the production
Elements of design
– effective use of 2D or 3D in 2
7
the production
Principles of design organisation
– effective selection of harmony,
variety, balance, proportion, 3
dominance, movement and
economy in the production

7 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Assessment Criteria Description Mark Max Mark


4. Originality and Creativity Sources
– credit and acknowledgement
of the sources of multimedia
elements used in development 2
need to be mentioned to
promote ethical and 5
professional practices
Creativity
– the production exhibits
3
creativity in effective delivery
of the message
5. User-friendliness User friendly
– elements of multimedia used 2
are self-directed 4
Economical in terms of number
2
of operations
6. Working Prototype Fulfilling the design interaction
1
(interaction and based on the final script
navigation)
Fulfilling the design navigation
1
based on the final script
4
Effective integration of working
1
prototype
Overall
1
– good implementation
Penalty for late submission −2
Total Mark for Task A4 is 29

8 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Assessment Criteria for Task A5: Beta Development

Assessment Criteria Description Mark Max Mark


1. User Testing Conducting successful user
2
testing with real clients
4
Managing test feedback resulted
2
from user testing
2. Production Modification Conducting successful production
2
modification
4
Managing production
2
modification
3. User Documentation and User documentation
Packaging – a clear description on how to 3
use the product 5
Packaging
2
– packaging and labelling design
Penalty for late submission −2
Total Mark for Task A5 is 13

Assessment Criteria for Task A6: Delivery

Assessment Criteria Description Mark Max Mark


1. Master CD Production Auto run of the Master CD with
1
• Working master CD README.txt file
3
Successful links based on the
2
Master CD
2. Final Packaging Complete with labelling 1
• Provide final Aesthetic 3
packaging 2

3. Poster Presentation Design context


– presentation reflects the 2
product content 3

Aesthetic 1
Penalty for late submission –2
Total Mark for Task A6 is 9

Each student is required to compile Task A1, Task A2, Task A3, Task A4, Task A5 and Task
A6 and submit the final report, which shall be assessed according to the criteria below.

9 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Assessment Criteria for Documentation

Assessment Criteria Description Mark Max Mark


1. Format of Report Inclusion of Cover Page, Title
Page, Declaration, Table of 2 2
Contents and Bibliography
2. Completeness of Chapter Completeness of topics covered
1 and clarity of writing 1 1
• Task A1
3. Completeness of Chapter Completeness of topics covered
2 and clarity of writing 1 1
• Task A2
4. Completeness of Chapter Completeness of topics covered
3 and clarity of writing 1 1
• Task A3
5. Completeness of Chapter Completeness of topics covered
4 and clarity of writing 1 1
• Task A4
6. Completeness of Chapter Completeness of topics covered
5 and clarity of writing 1 1
• Task A5
7. Completeness of Chapter Completeness of topics covered
6 and clarity of writing 1 1
• Task A6
8. Appendix Completeness of appendices to
support work written in the report 2 2
and user manual
9. Presentation of Report Organisation - clear, concise and
1 1
systematic presentation
Penalty for late submission −2
Total Mark for Documentation is 11

Note: Maximum mark for Assignment A is 90.

10 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Assignment B: Programming
Each task should be assessed based on the assessment criteria below.

Assessment Criteria for:

Task B1: Selection Control Structure


Task B2: Repetition Control Structure
Task B3: Functions
Task B4: Arrays
Task B5: Structure

Assessment Criteria Description Mark Max Mark


1. Algorithm • Accurate use of program
flowchart symbols and
arrows/well written pseudocode 2
and may have indentations for 4
specific procedures
• Correct logical sequence to solve
2
the given problem
2. Input • Correctly declared meaningful
variable/constant names
!
• Appropriate use of 3 3
input/assignment statements
• Use relevant input test data
3. Process • Write relevant comments and
include white-spaces
1
• Appropriate use of indentations
and brackets
• Orderly sequence of procedures
4
• Apply suitable control structure,
function call or data structure
3
• Formulate accurately
formula/condition/precedence of
operators
4. Output • Use relevant and meaningful
name for output variables
3 3
• Display relevant input prompt
• Display correct output/results
Complete submission 1

Total Mark for each task is 15

11 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Each student is required to compile Task B1, Task B2, Task B3, Task B4 and Task B5 and
submit the final report, which shall be assessed according to the criteria below.

Assessment Criteria for Documentation

Assessment Criteria Description Mark Max Mark


1. Format of Report Inclusion of Cover Page, Title
Page, Declaration and Table of 2 2
Contents
2. Completeness of Report Completeness – inclusion of all
1 1
reports (Task B1 to Task B5)
3. Remarks Reasonable remarks 1 1
4. Presentation of Report Organisation - clear, concise and
1 1
systematic presentation
Total Mark for Documentation is 5

Note: Maximum mark for Assignment B is 80.

12 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Assignment C: Information Systems Development


Each task should be assessed based on the assessment criteria below.

Assessment Criteria for Task C1: Planning Phase

Assessment Criteria Description Mark Max Mark


1. Statement of Problem Clear and accurate 2 2
2. Objective of Project Clear and reasonable 1 1
3. Scope of Project Reasonable work 1 1
4. Project Timeline Proper Gantt chart and complete
1 1
milestones of the project
5. Project Cost Estimation Clear and reasonable 1 1
Penalty for late submission −2
Total Mark for Task C1 is 6

Assessment Criteria for Task C2: Analysis Phase

Assessment Criteria Description Mark Max Mark


1. Model Diagram of The Accuracy of diagram and symbols 1
Current System
Clear and reasonable chart 2
• Flowchart, data flow 1
or workflow
2. Description of Methods Suitability of methods 1
• Determine user and Information coverage 2
system requirements 1

3. Model Diagram of The Completeness of entity and


2
New System process
• Data flow diagram 4
Completeness of diagram 1
Accuracy of symbols 1
Penalty for late submission −2
Total Mark for Task C2 is 8

13 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Assessment Criteria for Task C3: Design Phase

Assessment Criteria Description Mark Max Mark


1. Program Structure Clear and reasonable structure 2
3
Accuracy of symbols and chart 1
2. Entity-Relationship Completeness of entity 2
(E-R) Diagram
Completeness of attribute 2
7
Completeness of diagram 2
Accuracy of the diagram 1
3. Normalisation Process Accuracy and completeness of
2
functional dependency
Normalisation process to the third
3
normal form with justification
8
Mapping of third normal form to
2
relational schema
Completeness of relational
1
schema
4. User Interface Design Completeness of user interface
2
according to program structure
Completeness of forms according
to program structure and database 3
design
8
Completeness of reports
according to program structure 1
and user requirements
Clear and reasonable design of
2
user interface, forms and report
Penalty for late submission −2
Total Mark for Task C3 is 26

Assessment Criteria for Task C4: Implementation Phase

Assessment Criteria Description Mark Max Mark


1. Specification of Hardware Suitability of the choice
1 1
and Software
2. Implementation of Ability to design tables using the
2
Database Tables chosen software
• Evidence by printout Accuracy of database tables 4
and/or demonstration which reflects the database design 2
as in Assignment C3

14 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Assessment Criteria Description Mark Max Mark


3. Implementation of User Ability to use related
Interface tools/features to design the user
interface based on the chosen 1
• Evidence by printout
and/or demonstration software
Accuracy of user interface which
reflects the design of user 2
interface as in Assignment C3
Suitability and friendliness of
user interface design 1

Ability to design forms using the


chosen software 1 10

Accuracy of forms which reflects


the design of forms as in 2
Assignment C3
Ability to use reporting tools/
features based on the chosen 1
software
Accuracy of report which reflects
the design of report as in 2
Assignment C3
4. Implementation of Ability to use SQL queries based
Queries on the chosen software 2
• Evidence by printout 5
Accuracy and completeness of
and/or demonstration
queries which reflects the design 3
of forms as in Assignment C3
5. System Testing Achievement of overall
objectives of the project 2
• Overall system
performance/ Successful data, input and output 4
implementation based testing 2
on demonstration
Penalty for late submission −2
Total Mark for Task C4 is 24

Assessment Criteria for Task C5: Evaluation Phase

Assessment Criteria Description Mark Max Mark


1. Project Discussion Provide the strengths and 2
weaknesses of the system
4
Provide suggestions for further 2
work
2. Project Conclusion Provide a conclusion 1 1
Penalty for late submission −2
Total Mark for Task C5 is 5

15 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Each student is required to compile Task C1, Task C2, Task C3, Task C4 and Task C5 and
submit the final report, which shall be assessed according to the criteria below.

Assessment Criteria for Documentation

Assessment Criteria Description Mark Max Mark


1. Format of Report Inclusion of Cover Page, Title
Page, Declaration,
2 2
Acknowledgements, Table of
Contents and Bibliography
2. Abstract Clarity and reflection of the
whole objective and result of the 1 1
project
3. Completeness of Chapter Completeness of topics covered
1 and clarity of writing 1 1
• Task C1
4. Completeness of Chapter Completeness of topics covered
2 and clarity of writing 1 1
• Task C2
5. Completeness of Chapter Completeness of topics covered
3 and clarity of writing 1 1
• Task C3
6. Completeness of Chapter Completeness of topics covered
4 and clarity of writing 1 1
• Task C4
7. Completeness of Chapter Completeness of topics covered
5 and clarity of writing 1 1
• Task C5
8. Appendix Completeness of appendices to
support work written in the report 2 2
and user manual
9. Presentation of Report Organisation - clear, concise and
1 1
systematic presentation
Penalty for late submission −2
Total Mark for Documentation is 11

Note: Maximum mark for Assignment C is 80.

16 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Student Record

SIJIL TINGGI PERSEKOLAHAN MALAYSIA


ICT COURSEWORK (958/4) STPM 2021

Session
Name of school/institute
Name of candidate
Centre no./Index no. S / I/ C no.

Study semester Assessment criterion Mark allocated Teacher’s mark Moderator’s mark
ASSIGNMENT A: MULTIMEDIA DEVELOPMENT
A1: Idea Analysis 8
A2: Task Planning 4
A3: Prototype Development 16
A4: Alpha Development 29
First
A5: Beta Development 13
A6: Delivery 9
Documentation 11
Total Mark 90
ASSIGNMENT B: PROGRAMMING
B1: Selection Control Structure 15
B2: Repetition Control Structure 15
B3: Functions 15
Second B4: Arrays 15
B5: Structure 15
Documentation 5
Total Mark 80
ASSIGNMENT C: INFORMATION SYSTEMS DEVELOPMENT
C1: Planning Phase 6
C2: Analysis Phase 8
Third C3: Design Phase 26
C4: Implementation Phase 24
C5: Evaluation Phase 5
Documentation 11
Total Mark 80
Overall Total Mark 250
*TEACHER’S OR/ AND MODERATOR’S DECLARATION
*I/We certify that the marks and details recorded above are true.
Study semester First Second Third
Teacher’s signature
Name
Date
Mobile number
Moderator’s signature
Name
Date
Mobile number
*Delete which is not appropriate.

17 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

BRuMKK

MAJLIS PEPERIKSAAN MALAYSIA


SIJIL TINGGI PERSEKOLAHAN MALAYSIA

SUMMARY OF MARKS OF STUDENTS’ COURSEWORK FORM (BRuMKK)

YEAR : SEMESTER :
SUBJECT : CENTRE NO. :
SCHOOL NAME :
(To be filled by the teacher/examiner)

NO. INDEX NO. IDENTITY CARD NO. MARKS NOTES

1
2
3
4
5
6
7
8
9
10
(The list of the marks can exceed one page)

TEACHER’S/EXAMINER’S DECLARATION PRINCIPAL’S DECLARATION

I confirm that the marks and information above are I confirm that the marks and information above are
true. true.

Signature of Teacher/Examiner:……………………….. Signature of Principal:………………………………….


Name:…………………………………………………... Name:…………………………………………………...
Identity Card No.:……………………………………… Identity Card No.:………………………………………
Date: ………………………………………………....... Date: ……………………………………………….......
Phone No. (school):……………………………………. Phone No. (school):…………………………………….
(mobile):………………………………….... (mobile):…………………………………....

Note: The BRuMKK must be submitted to MEC at the latest by a week after the marks are keyed in the e-submission.

18 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Declaration Form

SIJIL TINGGI PERSEKOLAHAN MALAYSIA


ICT COURSEWORK (958/4) STPM 2021

Name of school/institute: ...................................................... Centre no/Index no: …...........................................

Name of student:.................................................................... I/C number:.............................................................


__________________________________________________________________________________

STUDENT’S DECLARATION FOR ASSIGNMENT A / B / C (circle the relevant one)


I have read and understood the specifications and instructions of the assignment. I confirm that this assignment report
is my own work.

Student’s signature: ..................................................... Date: ...........................................................................

Assignment Problem/Modification/Suggestion

General Comments
........................................................................................................................................................................................
........................................................................................................................................................................................
........................................................................................................................................................................................
........................................................................................................................................................................................

TEACHER’S/EXAMINER’S DECLARATION
This is to certify that the coursework marks have been awarded in accordance with the requirements of the
coursework manual. I am satisfied that, to the best of my knowledge, the assignment reports are the candidates’ own
work. I also confirm that the assignment reports are subject to internal to internal standardisation and procedures.

TEACHER’S/EXAMINER’S DECLARATION PRINCIPAL’S DECLARATION


I confirm that the marks and information above are I confirm that the marks and information above are
true. true.

Signature of Teacher/Examiner:……………………….. Signature of Principal:…………………………………..


Name:…………………………………………………... Name:…………………………………………………...
Identity Card No.:……………………………………… Identity Card No.:………………………………………
Date: ………………………………………………....... Date: ……………………………………………….......
Phone No. (school):……………………………………. Phone No. (school):…………………………………….
(mobile):………………………………….... (mobile):…………………………………....
School’s official stamp: School’s official stamp:

Note: This form must be attached to the assignment report of the student.

19 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Part 2: Examples for Information and Communications Technology


(ICT) Coursework

2.1 Example for Assignment A: Multimedia Development

EXAMPLE OF FINAL REPORT

SIJIL TINGGI PERSEKOLAHAN MALAYSIA


2022

INFORMATION AND COMMUNICATIONS


TECHNOLOGY (ICT) COURSEWORK
PAPER 4 (958/4)

ASSIGNMENT A
MULTIMEDIA DEVELOPMENT REPORT

HOLIDAY IN TERENGGANU

Ramlee Bin Mahmood


(I/C No: XXXXXX-XX-XXXX)

Sekolah Menengah Kebangsaan Seroja


Jalan Bukit Antarabangsa
75000 MELAKA

Date of Submission:

20 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Declaration

This is to certify that are submitted based on my own work except those which has been
acknowledged in this documentation.

Signature: ..................................................
Name:
I/C No:
Index No:
Date:

Acknowledgement

I wish to express my ..................................................

21 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Contents

Page

Declaration

Acknowledgment

Introduction

Chapter 1 Idea Analysis

Chapter 2 Task Planning

Chapter 3 Prototype Development

Chapter 4 Alpha Development

Chapter 5 Beta Development

Chapter 6 Delivery

Bibliography

Appendix

22 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Introduction
This section should describe briefly the chosen topic. It should provide the goal, objective and idea on
presenting the subject matter in the multimedia production. Students may include interesting features
on the subject matter and the overall production.

Chapter 1: Idea analysis


This section summarises the content of Idea Analysis report gained from Assignment A1.
Attach Idea Analysis report (Assignment A1) which contains the following topics:
(i) Analysis study
(ii) Project cost estimation
(iii) Project timeline
(iv) Content outline
(v) Content, technology and delivery analysis

Chapter 2: Task Planning


This section summarises the content of Task Planning report gained from Assignment A2.
Attach Task Planning report (Assignment A2) which contains the following topics:
(i) Project goals definition
(ii) Skill sets requirement
(iii) Quality of multimedia attributes list
(iv) Reviewed content outline

Chapter 3: Prototype Development


This section summarises the content of Prototype Development report gained from Assignment A3.
Attach Prototype Development report (Assignment A3) which contains the following topics:
(i) Screen mock-up
(ii) Content maps and user interface
(iii) Overall story
(iv) Initial prototype

23 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

A sample of the prototype development

Chapter 4: Alpha Development


This section summarises the content of Alpha Development report gained from Assignment A4.
Attach Alpha Development report (Assignment A4) which contains the following topics:
(i) Storyboard and flowchart design
(ii) Final Story script
(iii) Multimedia production (audio, video and graphics)
(iv) Originality and creativity
(v) User-friendliness
(vi) Working prototype (interaction and navigation)

SLIDE TITLE: Panorama SLIDE NUMBER: 6/13


SLIDE DESIGN: SCRIPT:

ELEMENT DESCRIPTION SOURCE ELEMENT


CODE SPECIFICATION

Example of a storyboard design


24 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Example of a flowchart design

A screen shot of a working prototype

25 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Chapter 5: Beta Development


This section summarises the content of Beta Development report gained from Assignment A5.
Attach Beta Development report (Assignment A5) which contains the following topics:
(i) User testing
(ii) Production modification
(iii) User documentation and packaging

An example of Beta Development with production modification

An example of Beta Development with production modification

An example of Beta Development with production modification

Chapter 6: Delivery
This section summarises the content of Final Product report gained from Assignment A6.
Attach Delivery report (Assignment A6) which contains the following topics:
(i) Master CD
(ii) Final Packaging of Master CD
(iii) Poster

26 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Master CD or DVD with the final packaging (cover design)

An example of two A4 size (small) colour posters presentation placed on A3 mounting board

27 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Bibliography

This section should list all the references used.

Williams, B.K. and Sawyer, S.C., 2011. Using Information Technology: A Practical Introduction to
Computers and Communications. 9th edition. New York: McGraw-Hill.

Morley, D. and Parker, C.S., 2011. Understanding Computers: Today and Tomorrow. 13th edition.
United States: Thomson Course Technology.

Vaughan, T., 2011. Multimedia: Making It Work. 8th edition. New York: McGraw-Hill.

Ocvirk, O.G., et al., 2009. Art Fundamentals: Theory and Practice. 11th edition. New York:
McGraw-Hill.

Appendix

This section is only needed when a student has some documents to attach. The attachment will be an
added value to the student’s report.

Appendix 1

28 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

2.2 Example for Assignment B: Programming

EXAMPLE OF REPORT

SIJIL TINGGI PERSEKOLAHAN MALAYSIA


2022

INFORMATION AND COMMUNICATIONS


TECHNOLOGY (ICT) COURSEWORK
PAPER 4 (958/4)

ASSIGNMENT B
PROGRAMMING REPORT

Ramlee Bin Mahmood


(I/C No: XXXXXX-XX-XXXX)

Sekolah Menengah Kebangsaan Seroja


Jalan Bukit Antarabangsa
75000 MELAKA

29 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Declaration

This is to certify that are submitted based on my own work except those which has been
acknowledged in this documentation.

Signature: ..................................................
Name:
I/C No:
Index No:
Date:

Acknowledgement

I wish to express my ..................................................

30 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Contents
Page

Declaration

Acknowledgment

Task B1: Selection Control Structure


Question
Flowchart or Pseudocode
Program Source Code
Input and Output

Task B2: Repetition Control Structure


Question
Flowchart or Pseudocode
Program Source Code
Input and Output

Task B3: Functions


Question
Flowchart or Pseudocode
Program Source Code
Input and Output

Task B4: Arrays


Question
Flowchart or Pseudocode
Program Source Code
Input and Output

Task B5: Structures


Question
Flowchart or Pseudocode
Program Source Code
Input and Output

Reflection

31 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Task B1: Selection Control Structure

The owner of FIZI restaurant distributes brochures to his customers informing of discounts offered on
selected menu in the month of April. The discount for each item in the menu is shown in the table
below.

Item Number Menu Discount


1 Appetizers 10%
2 Salads 10%
3 Soups 20%
4 Seafood 8%
5 Chicken/Beef 15%
6 Noodles/Rice 20%
7 Vegetables 25%
8 Pasta 15%
9 Beverages 20%
10 Lunch Special 25%

The restaurant owner has requested you to write a program in C that reads the item number and its
normal price. The item number that is not listed in the table is not entitled for any discount. The
program calculates the amount to be billed to the customer based on the discount given or not given
for the item.

Pseudocode
1. Begin.
2. Declare variables for item number of entree, price, discount price.
3. Prompt user to enter item number of entree (1-10) and price.
4. Read item number and price.
5. If item number = 1 or item number = 2
then discount price = price * 0.90
else if item number = 4
then discount price = price * 0.92
else if item number = 3 or item number = 6 or item number = 9
then price = price * 0.80
else if item number = 5 or item number = 8
then discount price = price * 0.85
else if item number = 7 or item number = 10
then discount price = price * 0.75
else
begin_else
display “The item number of entree is not entitled for
discount.”
discount price = price
end_else

6. Display price before discount and price after discount.


7. End.

32 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

or
Flowchart
Start

Declare variables for item number of


entree, price, discount price

Prompt user to enter item number


of entree (1-10) and price

Read item number and price

Item number Yes Discount Price


= 1 or 2 = Price * 0.90

No

Item number Yes Discount Price


= 3 or 6 or 9 = Price * 0.80

No

Item number Yes Discount Price


=4 = Price * 0.92

No

Yes Discount Price


Item number
= 5 or 8 = Price * 0.85

No

Item number Yes Discount Price


= 7 or 10 = Price * 0.75

No

Display “The item number of Discount Price


entree is not entitled for discount” = Price
Display prices before
and after discount

Stop
33 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Program Source Code

/* Name: Ramlee Bin Mahmood


I/C No: XXXXXX-XX-XXXX
Index No: SD103/0424
Date:
Assignment B1
*/

#include <stdio.h>

main ()

{
int itemNo;
float price, discountPrice;

discountPrice = 0.0;
price = 0.0;

printf ("Please key in the item number of entree (1-10) and price:
\n");
printf ("\tItem No: ");
scanf ("\t%d", &itemNo);

printf ("\tPrice: RM");


scanf ("\t%f",&price);

if ( itemNo == 1 || itemNo == 2 )
discountPrice = price * 0.90;
else
if ( itemNo == 4)
discountPrice = price * 0.92;
else
if ( itemNo == 3 || itemNo == 6 || itemNo == 9)
price = price * 0.80;
else
if ( itemNo == 5 || itemNo == 8)
discountPrice = price * 0.85;
else
if ( itemNo == 7 || itemNo == 10 )
discountPrice = price * 0.75;
else
{ printf ("\nThe item number of entree is not entitled
for discount. \n");
discountPrice = price;}

printf ("Price before discount is:\tRM%6.2f\n", price);


printf ("Price after discount is:\tRM%6.2f\n", discountPrice);

34 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Input and Output

Sample Input and Output with discount

Please key in the item number of entree (1-10) and price:


Item No: 1
Price: RM20.00
Price before discount is: RM 20.00
Price after discount is: RM 18.00

Sample Input and Output without discount

Please key in the item number of entree (1-10) and price:


Item No: 13
Price: RM22.00

The item number of entree is not entitled for discount.

Price before discount is: RM 22.00


Price after discount is: RM 22.00

Task B1: Selection Control Structure


.
.
.
Task B2: Repetition Control Structure
.
.
.
Task B3: Functions
.
.
.
Task B4: Arrays
.
.
.
Task B5: Structures

Reflection

Student is free to express his/her views regarding the programming coursework and share his/her
knowledge and experience gained after completing the assignments given.

35 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

2.3 Example for Assignment C: Information Systems Development

EXAMPLE OF FINAL REPORT

SIJIL TINGGI PERSEKOLAHAN MALAYSIA


2022

INFORMATION AND COMMUNICATIONS


TECHNOLOGY (ICT) COURSEWORK
PAPER 4 (958/4)

ASSIGNMENT C REPORT
INFORMATION SYSTEMS DEVELOPMENT

FORM SIX STUDENT INFORMATION SYSTEM


(FSSIS)

Ramlee Bin Mahmood


(I/C No: XXXXXX-XX-XXXX)

Sekolah Menengah Kebangsaan Seroja


Jalan Bukit Antarabangsa
75000 MELAKA

36 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Declaration

This is to certify that are submitted based on my own work except those which has been
acknowledged in this documentation.

Signature: ..................................................
Name:
I/C No:
Index No:
Date:

Acknowledgement

I wish to express my ..................................................

Abstract
Form Six Student Information System (FSSIS) was developed for Sekolah Menengah Kebangsaan
Tinggi Melaka to assist form six teachers in managing students’ records, subjects registration and
examination marks. FSSIS would be able to generate reports such as subjects registration for each
student in a particular semester, marks obtained by the students in each examination and students’
personal information. These reports can be used by the school to be sent to the respective parents or
guardians. Among the function offered by the system include registration verification, registration and
examination marks update, information search and report generation. The system is developed and
tested using Microsoft Access.

37 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Contents

Page

Chapter 1 Introduction
1.1 Statement of the Problem
1.2 Objective of the Project
1.3 Scope of the Project
1.4 Planning of Project Development

Chapter 2 Analysis of the Problem


2.1 Current System
2.2 Collection of Information
2.3 New System Requirements

Chapter 3 System Design


3.1 Design of System Structure Chart
3.2 Logical Design of Database
3.2.1 Conceptual Data Model: Entity-Relationship Diagram
3.2.2 Normalisation of Database
3.3 Design of User Interface
3.4 Design of Form
3.5 Design of Report

Chapter 4 Implementation of the System


4.1 Hardware and Software Requirements
4.2 Implementation
4.2.1 Database Tables
4.2.2 Form
4.2.3 Report
4.2.4 Queries
4.2.5 User Interface
4.3 System Testing
4.3.1 Input Data Testing
4.3.2 Output Data Testing

Chapter 5 Conclusion
5.1 Strengths and Weaknesses of the System
5.2 Suggestions for Further Work
5.3 Closing Remarks

Bibliography

Appendix

38 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Chapter 1 Introduction

1.1 Statement of the Problem


Sekolah Menengah Kebangsaan Tinggi Melaka (SMKTM) is one of the schools that offers form
six classes. At present, there are seven classes of Semester 1 students and five classes of
Semester 3 students. The total number of students is 368. Form Six students have to choose
four or more subjects offered by the school. SMKTM is offering 14 subjects which can be
registered.
Parents have been complaining of the delay in receiving examination results. Some parents even
received the results one month after the results. SMKTM has to send the analysis of the
monthly tests and semester examination results to the District Education Department and also to
the chairman of the Parents-Teachers Association (PTA). At this moment, SMKTM is facing
problems sending these reports on time.

1.2 Objectives of the Project


The objectives of this project are as follows:
(i) To develop an information system to manage subjects registration and examination
marks
(ii) To produce examination slips, subject registration and examination marks reports

1.3 Scope of the Project


The scope of the project is to build an information system for Form Six students for Sekolah
Menengah Kebangsaan Tinggi Melaka (SMKTM). The information includes students’ personal
records, subjects offered, registration information such as subjects registered by students and
their scores in semester examinations.

1.4 Planning of Project Development


The Gantt chart as shown in Figure 1.1 shows the main activities and duration of the whole
development of the Form Six student information system. It also shows the milestones, i.e. the
deliveries of the study, the design, the implementation, the testing and debugging, and the
documentation of the report on the stipulated dates.

Task Name Start End Duration Jun Jul Aug Sep Oct
1. System Planning 1/6/19 8/6/19 7
2. System Analysis 9/6/19 23/6/19 14
3. System Design 24/6/19 24/7/19 30
4. System Implementation, Testing
25/7/19 10/9/19 45
and Debugging
5. System Evaluation
11/9/19 25/9/19 14
6. Report Writing
Figure 1.1: Gantt chart of Project Development Planning

1.5 Project Cost Estimation

Factor Cost
System software (e.g DBMS, OS) RM 500.00
Hardware (e.g server, peripherals) RM 1 000.00
Implementation (e.g training, file conversion) RM 500.00
Maintenance, back up and update RM 1 500.00
Total Cost RM 4 200.00

Table 1.1: Cost Estimation

39 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Chapter 2: Analysis of the Problem

2.1 Current System


Currently, the students’ records are managed by the school staff manually. The information is
either kept in the computer using word processor, spreadsheet or written in the teacher’s mark
sheet. Similarly, the score of the students’ results for all subjects are kept manually using a
spreadsheet. The environment of the existing system is shown in Figure 2.1.

Registration
Registration
Information
Student Verification
(Manual)
Using Word
Processor or
Spreadsheets

Student
Information File

Guardian

Send to
Using Word Processor
Create Reports and or Spreadsheets
Examination
Transcripts

Figure 2.1: Work Flow Diagram of the Existing System

2.2 Collection of Information


The collection of information for the new system and user requirements was done by
interviewing teachers, parents and students. The existing document of students’ records are
also referred to and studied.

2.3 New System Requirements


The processes involved in the Form Six Student Information System can be modelled using the
flow chart diagram as shown in Figure 2.2.
This system is composed of four processes.
(i) Registration Verification
(ii) Update Registration/Exam Marks
(iii) Information Search
(iv) Report Generation

40 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Registration
1.0 Student Info
Information
Student D1 Student Record
Registration
Verification
Manual Registration
Registration Information
D3 Registration/Exam Info/Exam
Records
Re Marks 2.0
Update D2 Subject Record
Registration Subject Info
/Exam Marks

Information
Search
Request 3.0
Teacher/
Administrator Information
Search
Search Info Subject
Information
Registration
Information

Request 4.0
Teacher/ Send to
Report
Administrator Guardian
Generate
Report

Figure 2.2: Data Flow Diagram of Form Six Student Information System

Chapter 3: System Design

The system design is discussed in five sections.


(i) The first section explains the structure chart.
(ii) The second section explains the logical design for the database system.
(iii) The third section explains the design of the user interface.
(iv) The fourth section explains the design of the forms.
(v) The fifth section explains how to design a report.

41 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

3.1 Design of System Structure Chart


Based on the data flow chart diagram in Figure 2.2, the system structure chart can be drawn as
shown in Figure 3.1 below.

Form Six Student Information


System

Registration
Registration Information Report
Verification
Update Searching Generation
(Manual)

Student Student Student


Information Information Information

Subject Subject Subject


Information Information Information

Registration Registration Registration


Information Information Information

Transcript of
Examination
Result

Figure 3.1: Form Six Student Information System Structure Chart

3.2 Logical Design of Database


The logical design for any database system normally involves two steps. The first step is to
design the entity-relationship (E-R) diagram of the system. The second step is to verify whether
the respective relational tables mapped from the E-R are normalised to the third normal form.

3.2.1 Conceptual Data Model: Entity-Relationship Diagram


The Conceptual Data Model for FSSIS is composed of the binary relationship between
STUDENT and SUBJECT. The activity or transaction between the two entities is
REGISTER. This is shown in Figure 3.2.

42 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

STUDENT SUBJECT
10..* REGISTER 4..10
ICNo SubjectCode
StudentName SubjectName
Gender Semester Description
DateofBirth Year
Address Marks
GuardianName Form

Figure 3.2: The Entity Relationship Diagram using UML notation for
Form Six Student Information System

3.2.2 Normalisation of Database


The entity-relationship diagram shown in Figure 3.2 is mapped into three relations,
namely STUDENT, SUBJECT and REGISTER as shown below.

STUDENT (ICNo, StudentName, Gender, DateofBirth, Address, GuardianName)


REGISTER (ICNo, SubjectCode, Semester, Year, Marks, Form)
SUBJECT (SubjectCode, SubjectName, Description)

The REGISTER relation is formed from the entity-relationship above. Its name is also
derived from the name of the relationship.
Assuming that the address of a student is the same as the address of his/her
parents/guardians, the functional dependencies of the database tables are shown in
Figure 3.3 below.

ICNo ! (StudentName, Gender, DateofBirth, Address, GuardianName)

SubjectCode ! (SubjectName, Description)

ICNo ! (Semester, Year, Marks, Form)


SubjectCode

Figure 3.3: Functional Dependencies of Attributes to the


Primary Key of the Respective Relational Table

From the Figure 3.3, three normalised tables are produced as shown in Figure 3.4.

STUDENT (ICNo, StudentName, Gender, DateofBirth, Address, GuardianName)

SUBJECT (SubjectCode, Subject Name, Description)

REGISTER (ICNo, SubjectCode, Semester, Year, Marks, Form)

Figure 3.4: Third Normal Form of FSSIS Database

43 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

The three tables are already normalised in the Third Normal Form as explained below:

(i) First Normal Form (1NF)


There are no repeating groups in each relation, therefore the relations STUDENT,
SUBJECT and REGISTER meet the condition of 1NF.

(ii) Second Normal Form (2NF)


Since all the attributes in the relation STUDENT are functionally fully dependent
on the primary key ICNo, therefore the relation STUDENT meets the condition
of 2NF. Since all the attributes in the relation SUBJECT are functionally fully
dependent on the primary key SubjectCode, therefore the relation SUBJECT
meets the condition of 2NF.
Since all the attributes in the relation REGISTER are functionally fully dependent
on the primary key ICNo and SubjectCode, therefore the relation REGISTER
meets the condition of 2NF.

(iii) Third Normal Form (3NF)


There exists no transitive dependencies in each of the relations; therefore the
relations STUDENT, SUBJECT and REGISTER are in 3NF.

The final relational schema in 3NF is as follows.

3.3 Design of User Interface

The main menu design for the system is shown in Figure 3.5.

LOGO and SYSTEM NAME

STUDENT INFORMATION

SUBJECT INFORMATION

REGISTRATION BY STUDENT

REGISTRATION BY SUBJECT

REPORT MENU

PRINT MENU

EXIT

Figure 3.5: The Design of FSSIS Main Menu

44 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

3.4 Design of Form

The design of the form for STUDENT INFORMATION data entry and display is shown in
Figure 3.6.

LOGO AND FORM


TITLE

IC NO: ...................................…….
STUDENT NAME: ................…………………
GENDER: .................…………….
DATE OF BIRTH: …………………
FORM: ......................……………
ADDRESS: .......................………
GUARDIAN NAME: ..................…

ADD DELETE PRINT FIND EXIT


RECORD RECORD RECORD RECORD

The SUBJECT INFORMATION, REGISTRATION BY STUDENT and REGISTRATION BY


STUDENT forms for data entry and display were designed in the same manner.

3.5 Design of Report

The design of the report generation menu is as shown in Figure 3.7. The respective buttons in
the report menu will accordingly invoke (open) the indicated form upon clicking by user.

LOGO and REPORT TITLE

STUDENTS LIST

SUBJECTS OFFERING

EXAMINATION REPORT

EXIT

Figure 3.7: The Report Menu

45 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Chapter 4 Implementation of the System

4.1 Hardware and Software Requirements

The hardware and software required by the system are listed in Table 4.1 below.

Hardware Software
Personal Computer with: Microsoft Windows XP operating system and
CPU Pentium IV 833 MHz DBMS package : Access 2000 or above..
512 MB RAM Memory
40 GB Hard Disk Storage
CD ROM

Table 4.1: Hardware and Software requirements

4.2 Implementation

4.2.1 Database Tables


Three relational tables are created, i.e. STUDENT, SUBJECT and REGISTER
according to Figure 3.4.
Using a relationship utility (button) provided by the MsAccess package, the three
relational tables are then linked. Relationships between the tables are shown in Figure
4.1. The figure shows the one-to-many relationship between STUDENT and
REGISTER and the one-to-many relationship between SUBJECT and REGISTER.

Figure 4.1: Relationship between Tables

46 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

4.2.2 Form
A form is used for the data entry and display of a record. The student, subject and
registration forms are created. The main menu form is also created.
Normally, one should create the main menu form last, i.e. after the associated forms
have been developed. This will facilitate the attachment of the appropriate forms to the
main menu. STUDENT form is shown in Figure 4.2.

Figure 4.2: STUDENT Form

4.2.3 Report
Reports are generated for different purposes. Students’ reports contain a list of students’
records. Subject reports contain a list of subjects offered by the school.
Registration reports generate examination transcripts and information.
An example of a report for subjects offered is shown in Figure 4.3. An examination
transcript for a particular student in shown in Figure 4.4.
(A report menu that allows option for users shall also be designed. The menu will offer
some choices for users to select. This is shown in Figure 4.3).

47 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Figure 4.3: Report for Subjects Offered by the School

Figure 4.4: Examination Transcript of a Student

48 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

4.2.4 Queries
Queries are normally used to retrieve information in accordance with the requirements
of users as to whether the information needed resides in one table or more. In this
system, the examination transcript is derived as a result of a query based on STUDENT,
SUBJECT and REGISTER tables. A query table is shown in Figure 4.6.

Figure 4.6: Query Table of Examination Results

4.2.5 User Interface


The user interface is created as shown in Figure 4.7. The associated Student, Subject,
Registration Information, Report Menu, Print Menu and Exit buttons are attached to the
menu via the respective forms created earlier.

Figure 4.7: Main Menu of FSSIS

49 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

4.3 System Testing


System testing involves inputting a set of personal information on 20 students and their
registration subjects.

4.3.1 Input Data Testing


Input data testing is simulated to test the system. An example of an input data is shown
in Figure 4.8 where the table concerned is STUDENT.

Figure 4.8: STUDENT Information Data Testing

4.3.2 Output Data Testing


The system is simulated to test whether the output data can be produced as stated in the
system specification.

50 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Chapter 5: Discussion and Conclusion

5.1 Strength and Weaknesses of the System


This system is capable of generating all reports that are currently required by teachers and
school administrators, e.g. printing students’ examination transcripts with addresses that are
ready to be posted to parents/guardians.
Nevertheless, the system developed exhibits some limitations. The limitations are as follows:
(i) No information of who (teacher) teaches a particular subject.
(ii) Inaccurate information occurs when the address of a student’s parents/guardians is not
the same as the address of the student. As a result, the transcript that has been posted
does not reach the intended recipient (parents/guardians).

5.2 Suggestions for Further Work


Other reports can also be generated to assist teachers in managing student’s information
effectively. FSSIS can be extended to cover all other classes in the school.

5.3 Closing Remarks


The implemented system has achieved its target objectives. However, the system can still be
further improved in the future.

Bibliography

Marakas, G.M., 2006. Systems Analysis & Design: An Active Approach. 2nd edition. New York:
McGraw-Hill.

Roth, R.M., Dennis, A. and Wixom, B.H., 2012. Systems Analysis and Design. 5th edition. New
Jersey: John Wiley & Sons.

Hoffer, J.A., Ramesh, V. and Topi, H., 2011. Modern Database Management. 10th edition. New
Jersey: Pearson Education.

Gillenson, M.L. et al., 2008. Introduction to Database Management. New Jersey: John Wiley & Sons.

Appendix

(This section is only needed when a student has some documents to attach. The attachment will be an
added value to the student’s report.)

Appendix 1

(A copy of every form that has to be filled for subject registration in the system.)

Appendix 2

(A copy of report in the existing practice)

51 RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
AYSIAMAJLI LISPEPER
LI YSIAMAJLISPE
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
AYSIAMAMAJ
AM AJLI
AJ LISP
LI SPEP
SPEPER
EP YSIAMA
MAJL
MAJLISPE
JL
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
AYSI
AYSI
SIAM
AMAJ
AM AJLI
AJ LISP
LI SPEP
SPEPER
EPER YSIA
YS IAMA
IAMAJL
MAJLIS
JL ISPE
IS PE
MAJLISPEPERIKSAANMALAY
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
AYSI
AY SIAM
SI AMAJ
AM AJLI
AJ LISP
LI SPEP
SPEPER
EPERIKSAANMALAYS
ER YSIA
YSIAMA
YS IAMA
IAMAJL
MAJLIS
JL ISPE
IS PEPERIKSAANMALAYSIAMAJ
PE
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
AYSI
AY SIAM
SI AMAJ
AM AJLI
AJ LISP
LI SPEP
SPEPER
EPER YSIA
YS IAMA
IAMAJL
MAJLIS
JL ISPE
IS PE
MAJLISPEPERIKSAANMALAY
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
AYSI
AY SIAM
SI AMAJ
AM AJLI
AJ LISP
LI SPEP
SPEPER
EPERIKSAANMALAYS
ER YSIA
YS
YSIAMA
IAMA
IAMAJL
MAJLIS
JL ISPE
IS PEPERIKSAANMALAYSIAMAJ
PE
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
AYSI
AY
AYSIAM
SIAM
SI AMAJ
AM AJLI
AJ LISP
LI SPEP
SPEPER
EPER YSIAMA
MAJL
MAJLISPE
JL
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
AYSIAMAMAJ
AM AJLI
AJ LISP
LI SPEP
SPEPER
EP YSIAMAJLISPE
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
MAJLIS
JLISPEPERIKSAANMAL
JLISPE NMAL
ALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
ANMA NMALAY
JLISPE
958/4 NMAL ANMA
STPM 2022
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
NMALAY
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
JLISPE
JLISPEPERIKSAANMAL
NMAL ANMA
ANMALAYSIAMAJLISPEPERIKSAANMALAY
NMALAY
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
MAJL MAJ
MA
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
MAJL INFORMATION AND COMMUNICATIONS TECHNOLOGY MA
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
MAJL MA
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
AJLI LAYS
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
AJLI PAPER 4 LAYS
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
AJLI LAYS
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
AM IA
AM COURSEWORK IA
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ
MAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJLISPEPERIKSAANMALAYSIAMAJ

MAJLIS PEPERIKSAAN MALAYSIA


(MALAYSIAN EXAMINATIONS COUNCIL)

SIJIL TINGGI PERSEKOLAHAN MALAYSIA


(MALAYSIA HIGHER SCHOOL CERTIFICATE)

Instructions to candidates:

This paper consists of three assignments. You will have to complete the tasks for each
assignment in the respective semesters.

Semester 1: Assignment A − Multimedia Development (90 marks)


Semester 2: Assignment B − Programming (80 marks)
Semester 3: Assignment C − Information Systems Development (80 marks)

The maximum marks for this paper is 250.

It is important that you work independently from other candidates and make sure that you
submit your unaided work.

Read the tasks carefully to make sure that you understand what is required.

Carry out all tasks and make sure that you check your work carefully to ensure that the
work produced is accurate and correct.

This question paper consists of 22 printed pages.


© Majlis Peperiksaan Malaysia 2021

STPM 2022 - 958/4 [Turn over


RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Part 3: Student’s Manual for Information and Communications Technology


(ICT) Coursework

3.1 Introduction

The Student’s Manual consists of questions for ICT Coursework of Assignment A: Multimedia
Development, Assignment B: Programming and Assignment C: Information Systems
Development.

3.2 Coursework

Assignment A: Multimedia Development (90 marks)

Multimedia production skills are evaluated in six different stages. These stages are reflected and
evaluated as Task A1, Task A2, Task A3, Task A4, Task A5 and Task A6.

The time estimated to complete Task A1 to Task A6 is 9 weeks. The duration to complete each
task is suggested as in the following table:

Task Duration
A1 1 week
A2 1 week
A3 2 weeks
A4 2 weeks
A5 2 weeks
A6
1 week
Documentation

The deadline to submit the report of the above tasks will be decided by the teacher. All tasks
must adhere to the submission date assigned by the teacher. Late submission of any reports will
result in deduction of marks.

Student needs to choose one of the following topics for the multimedia development project:

1 A video montage of ‘University Online Admission’.

A video montage is increasingly required as a preparation of pre admission to university


especially during Covid-19 pandemic. As a prospective applicant, you are required to
design, develop and deliver your two-minute video montage as below:
(a) Brief explanation about yourself in general and your choice of programme.
(b) Select and explain your achievements consisting of academic and extracurricular
activities that contribute to your choice of programme.
(c) Include relevant visuals of your portfolio with different shots and / or other related
media forms.
(d) Include your vision and how do you see yourself in five years’ time.

STPM 2022 - 958/4 2 RESTRICTED


RESTRICTED

ICT COURSEWORK STPM 2022

2 An interactive multimedia content on ‘Good Practices of Smartphone Usage’.

Usage of smartphone is essential nowadays. However, its unwise use can be


counterproductive. In order to create the awareness, your school has requested you to
prepare an interactive multimedia content on the ethical usage of smartphone. You are
required to design, develop and deliver an interactive multimedia content on good practices
of smartphone usage. The interactive content shall consider the following aspects:
(a) Overview of smartphone usage.
(b) Describe two to three for each do’s and don’ts of ethical smartphone usage in the
context of school going students.
(c) Highlight the contexts using two to three different video shots.
(d) Do not reveal any logo or brand of the products being shot.

3 Public service announcement on ‘Kalau tidak dipecahkan ruyung, manakan dapat


sagunya’.

You are required to design, develop and deliver a one-minute public service announcement
(PSA) based on the Malay proverb ‘Kalau tidak dipecahkan ruyung, manakan dapat
sagunya’. The PSA must include the following content:
(a) Create a narrative storytelling depicting the proverb based on local context.
(b) Highlight the value of the proverb by showing relevant acts. The visual must include
full-shot, middle-shot and close-up shot in the form of real shooting or animated
scene.
(c) Use of typography or graphics to present keywords of the proverb above.

4 Multimedia website for ‘My Pet’.

Pet nowadays has become a close companion in a household. Among the common pet
choices are cats, dogs, hamsters, rabbits, fish, birds and to name a few. As a pet lover, you
are required to design, develop and deliver a multimedia website comprising of the
following aspects:
(a) Select your favourite pet that you own. You can choose one, a pair or a type of pet
selection.
(b) Describe your pet including its physical traits, characteristics and memorable stories.
(c) Include a minimum of three different shots of your pet. The visual must include full-
shot, middle-shot and close-up shot.
(d) Include a short video of your pet activities.

STPM 2022 - 958/4 3 [Turn over


RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Task A1: Idea Analysis

(a) Perform idea analysis with regard to the requirements of the given project. The idea analysis
phase includes the following:
(i) Perform an analysis study with regard to the need of the given project
(ii) Estimate the overall project cost
(iii) Plan and develop a project timeline
(iv) Create content outline and prototype on paper
(v) Analyse the content, technology and delivery medium
(vi) Write an idea analysis report

(b) Submit the draft of Chapter 1 report that contains the following topics:
(i) Analysis study
(ii) Project cost estimation
(iii) Project timeline
(iv) Content outline
(v) Content, technology and delivery analysis

Task A2: Task Planning

(c) Perform task planning with regard to the requirements of the given project. The task planning
phase includes the following:
(i) Define project goals and skill set required
(ii) Form a multimedia team specifying the role of each member
(iii) Identify attributes of quality multimedia production
(iv) Create content outline and prototype on paper
(v) Write a task planning report

(d) Submit the draft of Chapter 2 report that contains the following topics:
(i) Project goals definition
(ii) Skill sets requirement
(iii) Quality of multimedia attributes list
(iv) Reviewed content outline

STPM 2022 - 958/4 4 RESTRICTED


RESTRICTED

ICT COURSEWORK STPM 2022

Task A3: Prototype Development

(a) Perform prototype development with regard to the requirements of the given project. The
prototype development phase includes the following:
(i) Build screen mock-up
(ii) Design content maps and user interface
(iii) Develop story
(iv) Test prototype
(v) Write a prototype development report

(b) Submit the draft of Chapter 3 report that contains the following topics:
(i) Screen mock-up
(ii) Content maps and user interface
(iii) Overall story
(iv) Initial prototype

Task A4: Alpha Development

(a) Perform alpha development with regard to the requirements of the given project. The alpha
development phase includes the following:
(i) Detail storyboard and flowcharts
(ii) Finalise story script
(iii) Produce graphic art, audio and video
(iv) Test working prototype
(v) Write an alpha development report

(b) Submit the draft of Chapter 4 report that contains the following topics:
(i) Storyboard and flowchart design
(ii) Final story script
(iii) Multimedia production (audio, video and graphics)
(iv) Originality and creativity
(v) User-friendliness
(vi) Working prototype (interaction and navigation)

STPM 2022 - 958/4 5 [Turn over


RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Task A5: Beta Development

(a) Perform beta development with regard to the requirements of the given project. The beta
development phase includes the following:
(i) Distribute to limited user testing
(ii) Response to bug report (modification and rectification) of the product
(iii) Prepare user document and packaging
(iv) Write a beta development report

(b) Submit the draft of Chapter 5 report that contains the following topics:
(i) User testing
(ii) Production modification
(iii) User documentation and packaging

Task A6: Delivery

(a) Perform delivery stage with regard to the requirements of the given project. The delivery stage
includes the following:
(i) Preparation of master CD including appropriate installers
(ii) Packaging and delivering
(iii) Write a final multimedia production report consisting of user manual and technical
documentation

Documentation

(a) Submit the final report (hardcopy and softcopy) that contains the following:
(i) Cover Page
(ii) Declaration
(iii) Acknowledgement
(iv) Contents
(v) Chapter 1 − Idea Analysis
(vi) Chapter 2 − Task Planning
(vii) Chapter 3 − Prototype Development
(viii) Chapter 4 − Alpha Development
(ix) Chapter 5 − Beta Development
(x) Chapter 6 − Delivery
(xi) Bibliography
(xii) Appendix

STPM 2022 - 958/4 6 RESTRICTED


RESTRICTED

ICT COURSEWORK STPM 2022

(b) Submit the final product that includes the following:


(i) Master CD or DVD with clear instructions for execution or launching of the application
in a README.txt file. The master CD or DVD must be packaged with a well-designed
CD or DVD label and casing label with the title of the project and the student’s details.
(ii) A final packaging of master CD or DVD.
(iii) Two A4 size colour posters presentation placed on A3 mounting board as required in
Assignment A6. The softcopy of the posters shall be included in the Master CD or
DVD.

Note: The Master CD or DVD should be tested prior to submission.

STPM 2022 - 958/4 7 [Turn over


RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Assignment B: Programming (80 marks)

Student is required to complete all programming tasks of Assignment B during specified practical
sessions in the computer laboratory. The teacher should fix another date for the practical session to be
carried out by a student who is absent with a reason.

Programming competencies are evaluated in five given tasks: Task B1, Task B2, Task B3, Task B4
and Task B5.

Duration to complete each task is suggested as in the following table:

Task Duration
B1 2 periods
B2 2 periods
B3 2 periods
B4 2 periods
B5 2 periods
Documentation 1 week

The deadline to submit the report of the above tasks will be decided by the teacher. Marks will be
given for submitting the task on time. Program must be written in C programming language.

Documentation

Submit the final report (hardcopy and softcopy) with the following:
(i) Cover Page
(ii) Declaration
(iii) Contents
(iv) Task B1
(v) Task B2
(vi) Task B3
(vii) Task B4
(vii) Task B5
(ix) Closing Remarks

STPM 2022 - 958/4 8 RESTRICTED


RESTRICTED

ICT COURSEWORK STPM 2022

Assignment B1: Conditional Statements (Duration: 2 periods)

Suria Supermarket sells items and give discounts based on customer’s membership type as shown
below. Non-members are not given any discount.

Membership Type Discount (%)


Platinum 30
Gold 20
Silver 10

Construct an algorithm that reads the membership type and item price. The output will be the
amount to pay after discount.

Write a program in C based on the above algorithm. The program allows both lowercase and
uppercase character input and will prompt user to reenter membership type if code entered is
invalid.

Three examples of the user interface screen are as shown below.

Suria Supermarket
Enter membership type (S or G or P, X for non-member): S
Enter item price (RM): 328.50

Item price : RM 328.50


Membership Type : S
Discount (%) : 10
Discounted Price : RM 295.65

Suria Supermarket
Enter membership type (S or G or P, X for non-member): x
Enter item price (RM): 423.20

Item price : RM 423.20


Membership Type : X
Discount (%) : 0
Discounted Price : RM 423.20

Suria Supermarket
Enter membership type (S or G or P, X for non-member): b
Invalid code, please enter again.

Enter membership type (S or G or P, X for non-member): p


Enter item price (RM): 2384

Item price : RM 2384.00


Membership Type : P
Discount (%) : 30
Discounted Price : RM 1668.80

STPM 2022 - 958/4 9 [Turn over


RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

Assignment B2: Repetition Control Structure (Duration: 2 periods)

Based on Assignment B1, construct an algorithm that allows a customer to purchase more than one
item, calculates and displays the total amount to be paid.

Write a program in C based on the above algorithm. The program allows both lowercase and
uppercase character input and will prompt user to reenter membership type if code entered is invalid.

An example of the user interface screen is as shown below.

Suria Supermarket

Enter membership type (S or G or P, X for non-member): g

Item 1
Enter item price (RM) : 120.00

Discount (%) : 20
Discounted Price : RM96.00

Add Items (Y/N) : y

Item 2
Enter item price (RM) : 340.00

Discount (%) : 20
Discounted Price : RM272.00

Add Items (Y/N) : y

Item 3
Enter item price (RM) : 360.80

Discount (%) : 20
Discounted Price : RM288.64

Add Items (Y/N) : n

*** Purchase Details ***


Membership type : G
Discount (%) : 20
Number of items : 3
Total purchase : RM820.80
Amount to pay : RM656.64

STPM 2022 - 958/4 10 RESTRICTED


RESTRICTED

ICT COURSEWORK STPM 2022

Assignment B3: Functions (Duration: 2 periods)

Based on Assignment B2, construct an algorithm that implements a function


getDiscountPercent(char) that accepts membership type then determines and returns the
percentage discount.

Construct the algorithm for the main function that reads the membership type and item price, calls
function getDiscountPercent to determine the discount percentage. Function main will
calculate and display the total amount to be paid for all items.

Write a program in C based on the above algorithm. The program code in Assignment B2 may be
used.

Use the following declaration in the program:

int getDiscountPercent (char);

The user interface is similar to Assignment B2.

STPM 2022 - 958/4 11 RESTRICTED


RESTRICTED

ICT COURSEWORK STPM 2022

Assignment B4: Arrays (Duration: 2 periods)

Based on Assignment B3, construct an algorithm that reads the customer name, calculates and stores
the total purchase and customer payment after discount made by three customers in an arrays. The
algorithm will then display the payment made by each customer as well as calculates and displays the
total amount collected from the three customers.

Write a program in C based on the above algorithm. The program code in Assignment B3 may be
used.

Use the following declaration in the program:

float totalPurchase[3], customerPayment[3];

STPM 2022 - 958/4 12 RESTRICTED


RESTRICTED

ICT COURSEWORK STPM 2022

An example of the user interface screen is as shown below.

Suria Supermarket

1. Enter customer name: Sheila


Enter membership type (S or G or P, X for non-member): g

Item 1
Enter item price (RM) : 234.50

Discount (%) : 20
Discounted Price : RM187.60

Add Items (Y/N) : y

Item 2
Enter item price (RM) : 98.60

Discount (%) : 20
Discounted Price : RM78.88

Add Items (Y/N) : n

*** Purchase Details ***


Customer Name : Sheila
Number of items : 2
Total purchase : RM333.10
Amount to pay : RM266.48

2. Enter customer name: Joshua


Enter membership type (S or G or P, X for non-member): g

Item 1
Enter item price (RM) : 120.00
.
.
.
Sales Summary
===================================================================
Customer Name Membership Type Total Purchase(RM) Amount Paid(RM)
===================================================================
Sheila G 333.10 266.48
Joshua X 120.00 120.00
Seetha S 267.40 240.66

Total Sales: RM 627.14

STPM 2022 - 958/4 13 RESTRICTED


RESTRICTED

ICT COURSEWORK STPM 2022

Assignment B5: Structures (Duration: 2 periods)

Based on the same scenario as in Assignment B4, construct an algorithm that reads the records of
three customers. Each customer’s record contains customer name, membership type, total purchase
and customer payment.

Write a program in C based on the above algorithm using the following structure:

struct purchaseInfo
{
char custName[30], membershipType;
float totalPurchase, custPayment;
}
typedef struct purchaseInfo custPurchase;
custPurchase purchase[3];

The user interface is similar to Assignment B4.

The output screen is as shown below.

Sales Summary
=====================================================================
Customer Name Membership Type Total Purchase (RM) Amount Paid (RM)
=====================================================================
Sheila G 333.10 266.48
Joshua X 120.00 120.00
Seetha S 267.40 240.66

Total Sales: RM 627.14

STPM 2022 - 958/4 14 RESTRICTED


RESTRICTED

ICT COURSEWORK STPM 2022

Assignment C: Information Systems Development (80 marks)

Information Systems Development skills are evaluated in five different tasks. These tasks are
reflected and evaluated as Task C1, Task C2, Task C3, Task C4 and Task C5.

The time estimated to complete Task C1 to Task C5 is 9 weeks. The duration to complete each task is
suggested as in the following table:

Task Duration
C1 1 week
C2 2 weeks
C3 2 weeks
C4 3 weeks
C5
1 week
Documentation

The deadline to submit the report of the above tasks will be decided by the teacher. All tasks must
adhere to the submission date assigned by the teacher. Late submission of any reports will result in
deduction of marks.

Student needs to choose one of the following topics for the information systems development project:

1 Property Rental Information System

STM Property Consult Sdn. Bhd. manages shop lots at the Cahaya Plaza. The company needs an
information system to manage the rental of the shop lots. Each shop lot is assigned a unique
identification number. Other additional information of a shop lot may include level, size, type
such as shop, kiosk and food court, category such as food and beverages, retail, beauty and sports
and monthly rental amount. The system should be able to check the availability of the shop lot.
Each shop can be rented to only one tenant at one time.

Tenants’ particulars such as name, address, and contact information will be stored. Each tenant is
assigned a unique identification number. A tenant may rent one or more shop lots.

The system should be able to produce these reports:


(a) List of tenants and their particular.
(b) List all shops categorized as retail.
(c) List name of tenants who rent food courts.
(d) List all shop lots with rental amount more than RM 3000.
(e) List all kiosks located at level 3.
(f) List name of tenants who rent more than one shop lot.

STPM 2022 - 958/4 15 [Turn over


RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

2 Workshop Management System

Bengkel Purnama is a car workshop located in Selangor. The owner faces difficulties in
managing his business operation. An information system is needed to support the daily operation.
You are appointed to develop the system to handle the customer and service information of the
workshop.

In designing the system, the following should be taken into consideration:


• Each customer is assigned a unique customer number. Other information may include name,
identification number, gender, address and contact number. A customer may have one or
more cars.
• Each car is assigned a unique car number. Other information may include manufacturer,
model, year manufactured and insurance policy number. A car is owned by one customer. A
car can be serviced more than once.
• Each service stores the date of the car sent to and collected from the workshop.
• A mechanic may service more than one car. Each mechanic is assigned a unique mechanic
number. Other information may include name, gender, address and contact number of the
mechanic.

The system should be able produce these reports:


(a) List of customers and their particulars.
(b) List of all female mechanics.
(c) List of all cars manufactured by Proton after year 2020.
(d) List of all cars sent in July 2022.
(e) List of all cars serviced by each mechanic.
(f) List of all cars owned by Ahmad.

STPM 2022 - 958/4 16 [Turn over


RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

3 Co curriculum Equipment Management System

Juara Cemerlang Secondary School is developing an information system to manage its co


curriculum equipment. The objective of the system is to facilitate the school administrator to
track co curriculum equipment borrowed by co curriculum unit.

In designing the system, the following should be taken into consideration:


• Each equipment is identified by a unique equipment number. Other information may include
equipment name and price per unit. An equipment can be borrowed by many co curriculum
unit.
• Each co curriculum unit is identified by a unique co curriculum number. Other information
may include co curriculum name, type such as sport club, association club and uniform unit
and number of members. Each co curriculum can borrow more than one equipment. Each co
curriculum is managed by a teacher.
• Each teacher is identified by a unique teacher number. Other information may include
identification number, name, and contact number of the teacher. Each teacher manages one
or more co curriculum.
• The dates, times and returned of the borrowed equipment will be recorded. The equipment
must be returned on the same day.

The system should be able to produce these reports:


(a) List of teachers and related information.
(b) List of equipment with a price exceeding RM 500.
(c) List of co curriculum managed by a teacher named Wong.
(d) List of co curriculum for each type.
(e) List of borrowed equipment which is not returned back.
(f) List of most equipment borrowed.

STPM 2022 - 958/4 17 [Turn over


RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

4 Sculpture Store Information System

A manager of a store that sells art sculpture has hired you to build a sculpture information system
to manage its business operations

The system records sculptor information such as name, birthplace, birth date and home address.
The information for each sculpture includes sculpture unique number, year produced, title and
price. Each sculpture may belong to many categories such as kinetic, collage, relief and casting.
Each sculpture is sculptured by one sculptor. One sculptor can sculpt one or more sculptures. One
sculpture can be purchased by more than one collector. One collector can purchase more than one
sculptures. The system also keeps the collectors’ information. Each collector can be identified by
collector unique number, name, address, birth date and contact number. Each purchase made by
collector will be recorded.

The system should be able to generate the following reports:


(a) List of sculptor information.
(b) List of the most popular sculpture purchased in January.
(c) List of the sculpture according to the type.
(d) Total sales according to a particular month.
(e) List of the name of collector with the highest purchase.
(f) List of sculpture produced after the year 2020.

STPM 2022 - 958/4 18 RESTRICTED


RESTRICTED

ICT COURSEWORK STPM 2022

Task C1: Planning Phase

(a) Carry out the planning phase of your information system development based on the problem
statement. The planning phase shall include the following:
(i) Discussion with the teacher to ensure the feasibility and viability of the system to be
developed within the given duration
(ii) Formulation of problem statement, project objective and project scope
(iii) Scheduling of activities of information system development using Gantt chart

(b) Submit the draft of Chapter 1 that contains the following topics:
(i) Problem statement
(ii) Project objectives
(iii) Project scope
(iv) Schedule of activities
(v) Project cost estimation

Task C2: Analysis Phase

(a) Perform an analysis of the problem you have chosen in Assignment C1. The analysis phase
must include the following:
(i) Investigation of the current system
(ii) Modelling of the current system using diagramming tools
(iii) Gathering of information on the new system to determine system requirements
(iv) Specification of the new system requirements using diagramming tools

(b) Submit the draft of Chapter 2 that contains the following topics:
(i) Diagram of the current system
(ii) Description of the methods used to determine system requirements
(iii) Specification of the system requirements using diagramming tools

Task C3: Design Phase

(a) Design a new system based on your findings in the analysis phase as reported in the draft of
Chapter 2. The design phase must include the following:
(i) Designing program structure using structured chart
(ii) Designing conceptual data model using E-R diagram
(iii) Mapping the E-R diagram to relational scheme
(iv) Identifying functional dependencies of attributes of each relation in the relational
scheme
(v) Normalising the database scheme to Third Normal Form with justification
(vi) Designing forms, reports and user interfaces
(vii) Explaining any acronyms used for the entities and attributes

STPM 2022 - 958/4 19 [Turn over


RESTRICTED
RESTRICTED

ICT COURSEWORK STPM 2022

(b) Submit the draft of Chapter 3 that contains the following topics:
(i) The program structure of the system
(ii) E-R diagram for the conceptual data
(iii) The logical design of the database
(iv) The design of user interfaces, forms and reports

Task C4: Implementation Phase

(a) Implement the new system based on your design as reported in the draft of Chapter 3. The
implementation phase shall include the following:
(i) Choosing suitable hardware and software
(ii) Implementing database tables, forms, reports, queries and user interfaces using a
DBMS package. (Note: student can choose any DBMS package provided by the
school); and
(iii) Testing the system using test data (e.g. adding, deleting, updating, sorting and
retrieving) and evaluating the output (e.g. flow of menu, suitability of user interfaces
and report generating).

(b) Submit the draft of Chapter 4 that contains the following topics:
(i) Description of the selected hardware and software.
(ii) Printout screen of user interfaces (e.g. menu) and test report and database relationship,
forms, queries and reports.

(c) Demonstrate the system to your teacher for evaluation.

Task C5: Evaluation Phase

(a) Evaluate the system based on your implementation as reported in the draft of Chapter 4. The
evaluation phase shall include the following:
(i) Discussing the strengths and weaknesses of the system
(ii) Suggesting future work to improve the system
(iii) Providing conclusion

(b) Submit the draft of Chapter 5 that contains the following topics:
(i) Strengths and weaknesses of the system
(ii) Further works and suggestions
(iii) Conclusion

STPM 2022 - 958/4 20 RESTRICTED


RESTRICTED

ICT COURSEWORK STPM 2022

Documentation

(a) Submit the final report (hardcopy and softcopy) which includes the following topics:
(i) Cover Page
(ii) Declaration
(iii) Acknowledgement
(iv) Abstract
(v) Contents
(vi) Chapter 1: Introduction
(vii) Chapter 2: Problem Analysis
(viii) Chapter 3: System Design
(ix) Chapter 4: Implementation
(x) Chapter 5: Evaluation
(xi) Bibliography
(xii) Appendix

(b) Submit the final product that includes a master CD or DVD with clear instructions for execution
or launching of the application in a README.txt file. The master CD or DVD should be
labelled with the title of the project and the student’s name.

STPM 2022 - 958/4 21 RESTRICTED


!"#"$%&"'(("%)*+!*,-$./.'%0.$.1!".%2!&)03
1.'(%4",*$-$.,.'%-$*/%
0.#$"!%)*)*+",!..'%0.$.1!".%20)03
4"",&"+.5%).4.%)*+"'(,.&%.'&.+.6.'(!.
%!*0*'#.,%&./7'%89:;

STPM 2022 - 958/4 22

You might also like