2014年11月6日星期四

INFORMATION AND COMMUNICATIONS TECHNOLOGY (ICT 958) Syllabus and Specimen Papers

FIRST TERM: INTRODUCTION TO INFORMATION AND COMMUNICATIONS TECHNOLOGY (ICT) AND MULTIMEDIA



Topic
Teaching Period
Learning Outcome
Theory 
Practical

1


ICT and Multimedia Fundamentals

20


3



Candidates should be able to:

(a)      distinguish between data, information and knowledge;
(b)      define ICT and multimedia;
(c)      explain the hardware aspect of computing technology: central processing unit (CPU), storage, input and output;
(d)      explain the software aspect of computing technology: system software and application software;
(e)      explain the communication technology:
computer network, wired and wireless communication media and  communication protocols; 
(f)       explain the information (content) types:
text, audio, images, animation and video;
(g)      explain the software development tools: programming languages, mark-up and scripting languages and authoring tools;
(h)      explain the Internet and World Wide
Web;
(i)        describe the evolution of ICT convergence: information (content), computer and communication.


2



ICT and Multimedia
Applications and
Governance

16




Candidates should be able to:

(a)      describe the application and impact of ICT and multimedia as an enabler in
agriculture, manufacturing,                    e-government, Internet banking and           e-commerce that contribute towards the socio-economic development;
(b)      describe ICT and multimedia as an industry that contributes towards business opportunity and job creation;










(c)      describe the purpose of acts that govern the usage of ICT and multimedia in
Malaysia: Communication and
Multimedia Act 1998, Computer Crimes
Act 1997, Telemedicine Act 1997 and
Digital Signature Act 1997;
(d)      discuss the ethical and social issues in cyberspace of ICT and multimedia: privacy, obscenity, defamation, Internet and information security, Internet and computer crime; 
(e)      describe the types of threat to information, computer and network security: viruses, natural disasters, cyber crime and intrusive Internet.

3

Multimedia Design

12





Candidates should be able to:

(a)      explain the principles of design organisation: harmony, variety, balance, proportion, dominance, movement and economy;
(b)      explain the elements of two-dimensional (2D) design: line, shape, texture, value and colour; 
(c)      explain the elements of threedimensional (3D) design: line, plane, volume and mass (space), texture and colour;
(d)      explain the elements of multimedia: text (fonts and faces, computer and text and hypertext and hypermedia), images (bitmaps, raster, vector, rendering and drawing and colour), animation
(principles of animation), audio (digital, musical instrument digital interface (MIDI)) and video (video standard, analogue, digital, recording and editing);
(e)      describe the features of user interface design in multimedia environment.



Multimedia Delivery

4



Candidates should be able to:

(a)      explain the multimedia delivery options
(compact disc and www (World Wide Web)) in terms of its potential and limitation (capacity and speed); 
(b)      calculate the content size of the multimedia elements on each delivery model;
(c)      describe other medium of delivery: mobile devices (phone and personal digital assistant (PDA)) and game consoles.

5

Multimedia Development

8

57

Candidates should be able to:





5.1       Idea analysis

1


6

(a)      perform an analysis study with regard to the need of the given project;
(b)      estimate the overall project cost;
(c)      plan and develop a project timeline;
(d)      create content outline and prototype on paper;
(e)      analyse the content, technology and delivery medium;
(f)       write an idea analysis report.



5.2       Task planning
1

6

Candidates should be able to:

(a)      define project goals and skill set needs;
(b)      form a multimedia team specifying the role of each member;
(c)      identify attributes of quality multimedia production;
(d)      review content outline and prototype on paper;
(e)      write a task planning report.



           5.3
           

Prototype  development

2

15

Candidates should be able to:

(a)      build screen mock-up;
(b)      design content maps and user interface;
(c)      develop story;
(d)      test prototype;
(e)      write a prototype development report.

           5.4
           

Alpha  development

2

15

Candidates should be able to:

(a) detail the storyboard and flowcharts; (b) finalise story script;
(c)      produce graphic art, audio and video with the consideration of originality and user-friendliness;
(d)      test working prototype;
(e)      write an alpha development report.

           5.5

Beta development
 1
 12

Candidates should be able to:

(a)      distribute to limited user testing;
(b)      response to bug report (modification and rectification) of the product;
(c)      prepare user document and packaging;
(d)      write a beta development report.

           5.6

Delivery

1


3

Candidates should be able to:

(a)      prepare master compact disk (CD) including appropriate installers;
(b)      packaging and delivering;
(c)      write a final multimedia development report consisting of user manual and technical documentation.



SECOND TERM: PROGRAMMING



Topic
Teaching Period
Learning Outcome
Theory 
Practical

6


Introduction to
Programming

2





Candidates should be able to:

(a)      define a computer program; 
(b)      distinguish between five generations of programming languages: first generation (machine languages), second generation
(assembly languages), third generation (high-level procedural languages), fourth generation (problem-oriented languages) and fifth generation (natural languages);
(c)      give examples of programming languages according to generations;
(d)      distinguish between language translators: assemblers, compilers and interpreters.

7


Fundamentals of C
Programming
Language

8

12

Candidates should be able to:





7.1       C program

2


3

(a)      explain the C program development environment: edit, preprocess, compile, link, load and execute;
(b)      explain types of programming errors:
runtime error, syntax error and logic error;
(c)      explain the structure of a C program: 
preprocessor directives, global declarations, main function block and other required function blocks;
(d)      explain and use special commands on C preprocessor directives: #include and
#define;
(e)      explain and use C language reserved words;
(f)       write a simple C program.



           7.2




Basic data types

2


3


Candidates should be able to:

(a)      identify and use types of integral data: integer, character and Boolean;
(b)      identify and use type of floating-point data: real;
(c)      identify and use types of constant data: integer constants and real constants;
(d)      identify and use types of derived data: array and structure;
(e)      declare and initialise integral, floatingpoint and constant data types;
(f)       write a C program that uses integral, floating-point and constant data types.

           7.3
           

Expressions and operators
2

3

Candidates should be able to:

(a)      convert algebraic expressions to C expressions;
(b)      explain types of operators: arithmetic operators, assignment operators, unary operators, equality operators, relational operators and logical operators;
(c)      determine precedence of operators;
(d)      write a C program that uses different types of operators.

           7.4

Input and output
2

3

Candidates should be able to:

(a)      explain formatting output with printf statement;
(b)      explain formatting input with scanf statement;
(c)      write a C program that uses formatted output and input statements.



8          Problem Solving             in
            Programming

12



Candidates should be able to:

(a)      explain the importance of  the order of actions to be executed; 
(b)      explain steps of problem solving in programming: program clarification, program design, program code, program test and program documentation and maintenance;
(c)      explain the meaning of an algorithm;
(d)      construct algorithms using flowcharts       and pseudocodes.

9          Control               Structures


18


21


Candidates should be able to:

(a)      explain types of control structures:
sequential, selection and repetition;
(b)      use suitable algorithm representations in constructing algorithms to solve problems using control structures;
(c)      explain the general format for each control structure;
(d)      convert algorithms which use sequential control structure into C statements;
(e)      convert algorithms which use selection control structures: if, if...else, nested if and switch...case into  C statements;
(f)       convert algorithms which use repetition control structures: for, while and do...while into C statements;
(g)      use break and continue statements
to alter the flow of control;
(h)      write a C program that uses control structures.


10 Functions

12

15
Candidates should be able to:


            10.1 Types of function


4


6

(a)      explain the meaning and the use of a function;
(b)      explain types of functions: standard library and programmer-defined;











(c)      explain types of standard library:
standard input/output library functions and math library functions;
(d)      explain the general format of a programmer-defined function;
(e)      write a C program that uses standard library functions.

            10.2 Function 
                        statements


8

9

Candidates should be able to:

(a)      explain types of function statements:
function prototype, function definition and function call;
(b)      explain the use of function prototype, function definition and function call;
(c)      explain the general format of function prototype, function definition and function call;
(d)      write a C program that uses function prototype, function definition and function call.

11 Data Structures

8

12
Candidates should be able to:


            11.1 Arrays


4


6

(a)      state the meaning of an array;
(b)      write an array definition statement;
(c)      initialise an array;
(d)      explain the application of an array in sorting (insertion and bubble) and searching (linear);
(e)      write a C  program that performs up to two-dimensional array operations for
simple statistical functions (minimum, maximum and mean);
(f)       write a C program that performs passing of a one-dimensional array to functions:
call by value and call by reference.



            11.2 Structures


4


6


Candidates should be able to:

(a)      explain the meaning of a structure;
(b)      write a structure definition statement;
(c)      explain the general format of a structure;
(d)      distinguish between types of derived data: array and structure;
(e)      create and initialise a structure;
(f)       write a C program that uses structures.



THIRD TERM: INFORMATION SYSTEMS DEVELOPMENT AND DATABASE SYSTEMS


Topic
Teaching Period
Learning Outcome
Theory 
Practical

12 Information Systems
            Development

4



Candidates should be able to:

(a)      state the purposes of systems analysis and design;
(b)      explain the differences between manual systems and computerised systems;
(c)      describe the duties and responsibilities of personnel in systems development information system: managers, systems analysts and programmers;
(d)      describe the differences between types of information systems: transaction processing systems, management information systems, decision support systems and expert systems.


13 Systems Development
            Life Cycle (SDLC)

20

39
Candidates should be able to:



            13.1 Introduction to
                        SDLC


2


(a)      describe systems development methodologies: waterfall model, rapid application development model and spiral model;
(b)      describe the phases in SDLC: planning, analysis, design, implementation and maintenance with reference to waterfall model.

            13.2 Planning phase


2


3

Candidates should be able to:

(a)      state the purpose of the planning phase;
(b)      describe and perform the activities in the planning phase: initial evaluation and feasibility study;
(c)      produce the deliverables of the planning phase: feasibility report, problem statement, project objective, project scope and project schedule.



            13.3 Analysis phase

6

12

Candidates should be able to:

(a)      state the purpose of the analysis phase;
(b)      describe the activities in the analysis phase: determination of users’ requirements and structuring of system requirements;
(c)      state the methods of determining users’ requirements: interview, survey, observations and review of procedures and documents;
(d)      apply suitable methods of determining users’ requirements;
(e)      describe structuring of system requirements: process modelling, logical modelling and conceptual data modelling;
(f)       use data flow diagrams to model the  processes;
(g)      use logical model representations:
decision tree and decision table;
(h)      use entity-relationship (E-R) diagrams to model conceptual data;
(i)        produce the deliverables of the analysis
phase: users’ requirements
specifications, process model, decision tree or decision table and data model.

            13.4 Design phase


4


9


Candidates should be able to:

(a)      state the purpose of the design phase;
(b)      describe and perform the activities in the design phase: logical data design, physical data design and program structure design;
(c)      produce the deliverables of the design phase: logical data design, user interfaces, form design, report design and program structures using structure charts.





13.5 Implementation
            phase

4

15

Candidates should be able to:

(a)      state the purpose of the implementation phase;
(b)      describe and perform the activities in the implementation phase: coding, testing, installation, evaluation, documentation, training and support; 
(c)      explain the types of testing: manual (inspections, walkthroughs and desk checking) and automated (syntax checking, unit testing, integration  test and system test) and user acceptance testing (alpha and beta);
(d)      produce the deliverables of the implementation phase: test report, installed system (direct, parallel, pilot and phased) and documentation (system and user);
(e)      explain user training and support: (design and content) and (method and delivery).




13.6 Maintenance 
            phase

2





Candidates should be able to:

(a)      state the purpose of the maintenance phase;
(b)      describe the activities in the maintenance phase: obtaining maintenance requests, transforming requests into changes, designing changes and implementing changes.

14 Fundamental of
          Relational Database
          Systems


14





Candidates should be able to:

(a)      explain the importance of data as an asset to organisations such as schools and hospitals;
(b)      explain the types of data operation: sorting, validation and abstraction;
(c)      describe the characteristics of good data and information which can help users in making decisions;










(d)      explain the data hierarchy;
(e)      define database, database systems and database management systems (DBMS);
(f)       explain the importance of database systems in administration, business and daily life;
(g)      explain the importance of software, hardware, data, people and procedure as integrated components of a database system;
(h)      describe the functions of the DBMS components: data dictionary, data manipulation language (DML) and data description language (DDL);
(i)        describe the advantages of database systems as compared to file processing systems;
(j)        describe the representations of a relational database: table, row and column;
(k)      explain the concept of keys: primary key, foreign key and candidate key;
(l)        explain the concept of data  integrity.


15 Database Systems
            Planning, Design and
            Administration

16

18
Candidates should be able to:

(a)      explain data redundancy, data inconsistency, data independency and data abstraction in the context of a database design;
(b)      identify the entity set, attribute, relational set and cardinality in data modelling;
(c)      use E-R diagrams to model data;
(d)      map the E-R diagram to a relational model: one-to-one, one-to-many and many-to-many binary relationships;
(e)      explain the concepts of full functional dependency, partial functional dependency and transitive functional
dependency;










(f)       normalise the database scheme up to the third normal form (3NF);
(g)      explain the importance of an effective database administration;
(h)      state the duties and responsibilities of database administrators.


16 Query Language


6


3

Candidate should be able to:

(a)      use the structured query language (SQL) to implement basic data manipulation: adding, deleting, updating, arranging and retrieving;
(b)      use SQL to create tables and to define views.




Coursework (Practical Assignments)


The objective of the coursework is to develop candidates’ knowledge and skills in multimedia development, programming and information systems development.

 The coursework manual can be downloaded from MEC’s Portal (http://www.mpm.edu.my) by the subject teacher during the first term of form six. The manual contains regulations and guidelines on the conduct and assessment of coursework which needs to be implemented by the school as well as coursework assignments which need to be done by candidates in the respective terms.

 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. The result of the assignments should be submitted to the teacher in the respective terms to be assessed according to the regulations contained in the coursework manual. 

Scheme of Assessment


Term of Study
Paper Code    and Name
Theme/Title
Type of Test
Mark (Weighting)
Duration
Administration
First
Term
958/1
Information and
Communications
Technology
(ICT) 
Paper 1
Introduction to
Information and
Communications
Technology and
Multimedia 
Written Test:

Section A Answer all 5 questions of variable marks.
Section B
Answer 1 out of 2 questions. 
All questions are based on topics 1 to 5.
50     
(20%)
35



15
1½ hours
Central assessment
Second Term
958/2
Information and
Communications
Technology
(ICT)           Paper 2
Programming

Written Test:

Section A Answer all 5 questions of variable marks.
Section B
Answer 1 out of 2 questions. 
All questions are based on topics 6 to 11.
50      
(20%)
35



15

1½ hours
Central assessment
Third Term
958/3
Information and
Communications
Technology
(ICT) 
Paper 3

Information
Systems Development and Database
Systems

Written Test:

Section A          Answer all 5 questions of variable marks.
Section B          Answer 1 out of 2 questions. 
All questions are based on topics 12 to 16.
50     
(20%)
35



15

1½ hours
Central assessment
First,
Second and
Third
Terms
958/4
Information and
Communications
Technology
(ICT)           Paper 4
Information and
Communications
Technology
(ICT) 

Coursework:
5 assignments and 2 projects to be carried out. 

250          to be
scaled to
100 
(40%)
Throughout the three terms
School-based assessment