Curriculum

Christian Alliance Cheng Wing Gee College
Computer Literacy
S.1 Curriculum

Learning units
Main topics
Addressed generic/
thinking/subject-based skills
No. of periods
Introduction Logon to School Network Introduction of different IT facilities in school Logon to e-class Information Technology Skills
2
Prezi (1) Registration of Prezi Using different templates Text formatting Information Technology Skills
7
Prezi (2) Inserting diagrams, symbols and images Create paths Inserting frames, arrows and highlighter Information Technology Skills, Creativity
Prezi (3) Insert symbols, diagrams and images Insert music, video Sharing and downloading of Prezi Information Technology Skills
Multimedia (1) - Text Text attributes Text encoding Information Technology Skills, Students' English Language Proficiency skill
5
Multimedia (2) - Graphics Bitmap images Vector graphics Difference between bitmap images and vector graphics Different graphic file formats Information Technology Skills, Students' English Language Proficiency skill
Multimedia (3) - Sound Sampling rate and sample size Different audio file formats Information Technology Skills, Students' English Language Proficiency skill
Multimedia (4) - Video Basic principle of video Concept of frame Different video file formats Information Technology Skills, Students' English Language Proficiency skill
PowerPoint (1) Review of basic functions of PowerPoint Editing slides Text formatting Inserting pictures Information Technology Skills, Creativity
6
PowerPoint (2) Inserting sound Transition effects Themes Information Technology Skills, Creativity
PowerPoint (3) Inserting video Set auto-play of video Set auto-play of slide-show Different file formats: pptx vs ppsx Convert still images into video Information Technology Skills, Creativity
Copyright Copyright issues Information Technology Skills
1
Word Processing Name Tag Information Technology Skills, Creativity
2
Spreadsheet (1) What is a Spreadsheet? Working environment of MS Excel 2007 Manage the files of electronic spreadsheets Data presentation in a Spreadsheet Information Technology Skills, Numeracy Skills, Creativity
12
Spreadsheet (2) Concepts of sorting and filtering Hide columns Freeze pane    Sorting and Filtering Information Technology Skills, Numeracy Skills
Spreadsheet (3) Concepts of formulae and functions Formulae in spreadsheet Spreadsheet operators Spreadsheet functions Information Technology Skills, Numeracy Skills
Input devices (1) Basic principle of Keyboard Information Technology Skills, Students' English Language Proficiency skill
2
Input devices (2) Basic principle of Mouse Information Technology Skills, Students' English Language Proficiency skill
Introduction to Mathematical software - Tess Learn to make tessellation patterns using mathematical software Information Technology Skills,Creativity
4

Click here for PDF version.

Christian Alliance Cheng Wing Gee College
Computer Literacy
S.2 Curriculum

Learning units
Main topics
Addressed generic/
thinking/subject-based skills
No. of periods
Introduction Logon to School Network Introduction of different IT facilities in school Logon to e-class Information Technology Skills
2
Computer Graphics (I)   Types of Computer Graphics   - Understand "Computer Graphics"
- Understand the types of computer graphics i.e. bitmap graphics and vector graphics
- Understand the key terms related to bitmap and vector graphics
- Daily applications of types of graphics
- Define the size of different photos sizes

Students should be able to
1. Understand What Computer Graphics is
2. Understand the Basic Concepts of Computer Graphics
3. Define the Size of a 2R, 3R or 4R Photo in Term of Pixels
8
Computer Graphics (II)   Objects and Effects 1   - To understand the concept of image object
- To create and apply photo effects to an image Object
- To create and apply effects to a text box
- To integrate students photo editing skills (i.e. image objects, photo effects and text box)

Students should be able to:
1. Understand the Concept of Image Object
2. Create and Apply Photo Effects to an Image Object
3. Create and Apply Effects to a Text Box
Computer Graphics (III) Objects and Effects 2   - To understand features of different graphical file format
- To handle lasso tools
- To arrange layers of objects
- To handle Image object and text transform
- To integrate students photo editing skills (i.e. lasso tools, arranging layers of objects and transforming Image/text objects

Students should be able to
1. Understand Features of Different Graphical File Format
2. Handle Lasso Tools
3. Arrange layers of objects
4. Image Object and Text Transform
Computer Graphics (IV)     Preparation of Animated Clips   - To understand the concepts of Animation
- To prepare GIF animation

Students should be able to
1. Understand the concepts of Animation
2. Understand the features of GIF image format
3. Create an animated GIF file
Computer Programming (I)   Visual Basic Programming:
1. Introducing the working environment
2. Executing, saving and retrieving programs
Students are able to
1. Practice Visual Basic programming environment
2. Write simple computer programs
3. Execute the Visual Basic program
14
Computer Programming (II)   Visual Basic Programming:
Basic input/output techniques
Students are able to
1. Know how to use the input/output features in programs: to accept input from keyboard and output information to the screen.
2. Write simple programs with input/output features.
Computer Programming (III)   Visual Basic Programming: Uses of flow control Students are able to Use IF-THEN-ELSE statement
Computer Programming (IV)   Visual Basic Programming:
Project Lesson 1
Students are able to
1. Define the problems of the project.
2. Use the design the flow control of their project.
3. Use input and output programming skill.
Computer Programming (V)   Visual Basic Programming:
Project Lesson 2
Students are able to Modify and improve
Use of Web Page Editor (I)   Introduction on Webpage Design       - To understand the basic concepts of webpage
- Web Page Introduction
- Web Development Workflow
- Editing Text, Color and Sound

Students should be able to
1. Understand the basic concepts of a webpage
2. Understand the basic design concepts of creating a web page
3. Design a simple web page with text, color and Sound
14
Use of Web Page Editor (II)   Simple Animation   - To understand the concepts of object / text layers and timeline in webpage
- Apply the concept of object / text layers and timeline to create an animation in a webpage

Students should be able to
1. Arrange Images / Text using Layer
2. Create Simple Animation using Timeline
Use of Web Page Editor (III)   - Standard Table and Layout Table
- Web Page Publication
- To understand the absolute and relative table width in a webpage
- To understand the different between the absolute and relative table width in a webpage and the related applications
- Create tables with absolute and relative table width in a webpage
- Host student’s webpage in public web server

Students should be able to
1. Create a Table with Relative and Absolute Table Width
2. Format a Table
3. Create Hyperlinks
4. Upload Web Pages
Use of Web Page Editor (IV)   - Editing Images
- Creating Hyperlinks
- Frames: the Window Partitions
- Create frames in a web page
- Create buttons with links in a web page
- Create frames and buttons with links in a web page

Students should be able to
1. Create Frames in a Web Page
2. Create Buttons with Links in a Web Page
Web Page Project (Computer and Science Join Project)   Project work follow up   Science Project work follow up
- Students should make use of webpage to facilitate the presentation of their experimental data, analysis, collected information
Students should be able to - facilitate the presentation of their experimental data, analysis, collected information
- prepare of the draft version of their science project
- Upload the web pages (final version) to the FTP server
DIY Computer (I)   Computer Hardware 1
- Basic Components of a Computer System,
- Input Devices
- Output Devices
 
- Identify different types of input and output devices
- To be able to identify different types of input and output devices

Students are able to
1. Understand the Basic Ideas of Hardware
2. To identify Different Types of Input Devices
3. To identify Different Types of Output Devices
4
DIY Computer (II) Computer Hardware 2
- Introduction on Central Processing Unit
- Evaluation of Different Types of DIY Computers
 
- To identify and evaluate the components of their ideal PC computer
- To be able to understand the basic features of central processing unit
- To evaluate different types of DIY computers

Students are able to
1. Understand the Basic Features of Central Processing Unit
2. Evaluate Different Types of  DIY Computers

Click here for PDF version.

Christian Alliance Cheng Wing Gee College
Computer Literacy
S.3 Curriculum

Learning units
Main topics
Addressed generic/
thinking/subject-based skills
No. of periods
Introduction Students should be able to
- Aware of the rules and regulations in using the Computer Room.
- Log in/logout and reset personal password
- Update of E-class password
- Know the computer room regulations
Information Technology Skills
2
Video Editing (T1) - Basic attributes of a video file Students should be able to
- Understand what is a video
- Understand the video attributes such as resolution and frame rate.
- Understand how the video attributes affects the playback quality of a video
Information Technology Skills
9
Video Editing (P1) - Trimming of video and transition effects Students should be able to
- Perform trimming of video clips
- Combine trimmed video clips into single one.
- Add transition effects between trimmed video clips.
Information Technology Skills Creativity  
Video Editing (T2) - Video compression(formats) and storage medium Students should be able to
- Understand the need for data compression in video files.
- Understand the difference between lossless and lossy compression
- Differentiate the suitable storage medium for video files for different purpose.
Information Technology Skills
Video Editing (P2) - Adding captions & background music Students should be able to
- Add captions to the combined video
- Add music or other special sound effects to the combined video.
Information Technology Skills Creativity  
Video Editing (T2) - Cyber bullying Student should be able to
- Understand what is cyber bullying
- Understand the consequences of cyber bullying
Information Technology Skills
Video Editing (P3) - Photo Slideshow (Unit Assessment) Students are required to:
- Collect 10+ scenic photos in the world
- Combine the collected photos into a photo slide show with captions and transition effects added.
Information Technology Skills Creativity  
Flash Animation (T1) - Basics of animation Students should be able to
- Understand the difference between computer animation and video.
- Understand how computer animation was made
- Understand what is motion tween and shape tween.
Information Technology Skills
11
Using Flash (I)

l   Basic concept of Flash movies.

l   Possibilities with flash.

Students should be able to
- Distinguish the differences between video and flash movies.
- Understand the basic concept of Flash Animation.
- Navigate through the user interface of Flash.
- Create symbol based on Text and Shapes
- Insert Keyframes in Flash
- Add Motion Tweening by using Keyframes.
- Insert pictures in Flash
Information Technology Skills  
Flash Animation (T2) - Properties of Vector graphics, Graphics tablet Students should be able to
- Understand the difference between the two computer image formats: Bitmap & Vector files.
- Appreciate the advantage of using vectors in computer animation.
Information Technology Skills  
Using Flash (II) : Christmas Flash Card - Part 1 Students should be able to
- Add Tweening motion with the help of motion guide
- Setup a self-rotating object in Flash
- Manipulate image alpha settings
Information Technology Skills Creativity  
Using Flash (III) Students should be able to
- Manipulate shapes to form new shapes
- Group existing shapes together as one.
Information Technology Skills Creativity  
Using Flash (IV)  - Realistic Flash symbol creation by means of “Carbon Copying?br> - Simple Split-frame cartoon generation
Information Technology Skills Creativity
Intro to Database (T1) Students should be able to
- Understand the importance of Database software as an effective way to manage large number of data.
Information Technology Skills  
12
Intro to Database (P1) Students should be able to
- Perform manual query on a large number of data entries
- Build a simple address book database
Information Technology Skills Creativity  
Intro to Database (T2) Students should be able to
- Understand what is Data types, validation rules and mechanisms
Information Technology Skills  
Intro to Database (P2) Students should be able to
- Import a large amount of raw data into a database
- Make use of queries to extract useful information from a database
Information Technology Skills Creativity  
Intro to Database (T3) Students should be able to
- Understand what is RDBMS, Table structure & key fields
Information Technology Skills  
Intro to Database (P3) Students should be able to
- Perform more queries on database such as pattern matching and calculations
Information Technology Skills Creativity
Intro to Database (T4) Students should be able to
- Understand what is data mining and  its applications in our daily life.
Information Technology Skills  
Computer system (T1) - Basic IPOS model in PC Students should be able to
- Understand the conceptual model of a modern computer system - the IPOS model.
Information Technology Skills  
9
Computer system (P1) - DIY Students should be able to - Connect the different components to build a working computer. Information Technology Skills Creativity
Computer system (T2) - What is OS, Drivers Students should be able to
- Understand the function of an Operating System (OS)
- Understand the function of driver programs.
Information Technology Skills  
Computer system (P2) - OS setup Students should be able to
- Try to install/boot up a sample OS using Virtual PC.
- Understand the difference of using different OS on the same set of hardware
Information Technology Skills Creativity
Computer system (T3) - Computer Network Basics Students should be able to
- Understand the function of a computer network
- How the Internet works as the largest network in the world.
Information Technology Skills  
Computer system (P3) - Computer Network (Inquiry approach: How does Google search for the information I want?)   Students should be able to
- Understand the necessary steps required to get connected to Internet
- Understand how the Internet works as a packet switched network
Information Technology Skills Creativity

Click here for PDF version.

Christian Alliance Cheng Wing Gee College
Information and Communication Technology
S.4 Curriculum

Learning units
Main topics
No. of periods
Introduction Introduction to ICT Syllabus
1
1.1 Basic Concepts of Input-Process- Output Cycle Recognize the Input-Process-Output cycle.
1
1.2 Use of Stored Programs Recognize the importance and applications of stored programs.
1
1.3   Difference between Data and Information Recognize the difference between data and information.
1
1.4   Types of Data Identify different types of data.
1
1.5 Components of an Information System Identify the five components of an information system.
Recognize the functions of each component of an information system.
1
1.6 Information Processes Recognize the processes in an information life cycle.
Study a real-life example of information processing.
1
1.7   Information Technology and the Information Age Explain what the Information Age is and its importance on fostering a knowledge-based society.
1
6.1 Introduction to Word Processors Understand the basic operation of word processing in the working environment of Microsoft Word.
3
6.2 Text Editing Be familiar with the techniques of editing a document through editing commands.
3
6.3 Formatting Features Become familiar with the skills to polish the appearance of a document through the formatting features.
4
6.4 Advanced Word Processing Features Recognize advanced word processing features. 2
7.1 Introduction to Spreadsheets Understand the basic concepts of a spreadsheet.
2
7.2 Basic Operations of Microsoft Excel 2007 Be familiar with the basic operations of spreadsheet software.
2
7.3 Formula and Cell Reference Recognize common formulae used in a spreadsheet.
Recognize different types of cell reference.
2
7.4 Functions Use the common functions for calculation.
3
7.5 Creating Charts Recognize the way to create a suitable chart to present data.
2
7.6 Data Manipulation Techniques Acquire the data manipulation techniques using table.
3
7.7 Data Analysis Recognize a spreadsheet which can be used to carry out data analysis.
3
3.1 Denary, Binary and Hexadecimal Number Systems Recognize the representation of different number systems.
1
3.2 Number System Conversion Recognize the conversion of different number systems.
1
3.3 Number Representation in Computer Systems Describe how binary numbers are stored and manipulated in a computer.
1
3.4 Addition and Subtraction of Different Number Representations Study the addition and subtraction of different number systems.
1
3.5 Character Coding Systems Recognize different types of character coding systems.
1
8.1 Database Concept Recognize the advancement of information management.
Identify different database applications.
2
8.2 Using the Database Management System (DBMS) Know more about designing a database, key field and input mask.
2
8.3 Microsoft Access Identify different database objects in Microsoft Access.
Be familiar with basic operations of a table in Microsoft Access.
Know more about data sorting and filtering.
6
8.4    Forms Recognize the functions of forms.
Become familiar with the Form Wizard.
2
8.5    Reports Recognize the functions of reports.
Become familiar with the Report Wizard.
2
8.6    Queries Recognize the functions of queries.
Become familiar with the SQL view.
4
4.1 Digital Multimedia Elements Describe common graphics, audio and video file formats. Compare the characteristics of common graphics, audio and video.
2
4.2 Analogue Data and Digital Data Identify the characteristics of analogue data and digital data.
Describe common applications of conversions of analogue data to digital data.
4
9.1   The Need for Integrating Data among Different Types of Software Recognize the need for integrating data among different types of software.
2
9.2 Methods for Integrating Data among Different Types of Software Identify the methods for integrating data among different types of software.
Be familiar with Object Linking and Embedding (OLE).
Recognize the differences of object linking and object embedding.
Recognize some common tasks that can be accomplished using OLE.
3
10.1 Different Ways of Presenting Information Understand different ways of presenting information.
1
10.2 Using Multimedia Elements in a Presentation Recognize different types of multimedia elements.
1
10.3 Creating a Presentation Construct a presentation and plan the storyboard.
2
10.4 Using Microsoft PowerPoint to Construct a Presentation Construct a presentation using Microsoft PowerPoint.
4
2.1 Data Input and Sources of Error Describe the data input methods and sources of error.
1
2.2 Data Control Describe how data validation and parity check can detect data errors.
Explain how verification and validation can prevent errors in the process of data entry.
1
2.3 Data Hierarchy Identify data, fields, records, tables and databases in the hierarchical organization of data.
2
2.4 Database Management System Software (DBMS) Explain how records can be organized, stored and retrieved.
2
2.5 File Access Modes Describe the advantages, disadvantages and applications of direct access and sequential access.
2
5.1 Basics of Office Automation Recognize the basic concepts of office automation.
0.5
5.2 Software and Hardware for Office Automation Describe the common types of software and hardware used in office automation.
2
5.3   Basic Activities in Office Automation Recognize the basic activities in office automation.
2
5.4   Effectiveness of Office Automation Understand the factors affecting the effectiveness of office automation.
0.5
11.1    The Components of a Computer Identify the basic components of a computer system.
1
11.2  Central Processing Unit (CPU) Recognize the structure of a CPU and how it executes an instruction.
2
11.3   Machine Cycle Recognize the process of executing an instruction.
1
11.4    Measurement of CPU Speed Describe the factors affecting the performance of a CPU.
1
11.5  Main Memory Describe the functions of main memory.
2
12.1  Input Devices Describe how the input devices work and be familiar with their special features.
3
12.2  Output Devices Describe how the output devices work and be familiar with their special features.
2
12.3  Daily Applications of Input and Output Devices Recognize some daily applications of input and output devices.
1
13.1  Secondary Storage Devices Express the speed and capacity of secondary storage devices in their proper units.
Understand the basic concept of magnetic storage and optical storage.
1
13.2  Magnetic Storage Devices Describe the operations and basic features of magnetic storage devices.
1
13.3  Optical Storage Devices Describe the operations and basic features of optical storage devices.
1
13.4  Other Forms of Secondary Storage Devices Describe the basic features of MO disks, memory cards and USB flash drives.
1
13.5  Network Storage Describe the basic features of network storage.
1
13.6  Latest Development of Secondary Storage Devices Describe the latest development of secondary storage devices.
1
14.1  The Relationship between Hardware, Software and Users Understand the relationship between hardware, system software, application software and users.
1
14.2  Systems Software Understand the functions of operating systems, utility programs and driver programs.
Distinguish among different operating systems and identify their special features.
2
14.3  Application Software Understand the functions of different types of application software.
2
15.1  Classification of Computers Recognize the classification of computers.
3
15.2  Characteristics of Computer Systems Recognize the characteristics of different types of computer systems.
2

Click here for PDF version.

Christian Alliance Cheng Wing Gee College
Information and Communication Technology
S.5 Curriculum (Module A: Databases)

Learning units
Main topics
No. of periods
Introduction Introducing the elective module A: Databases to students. Module requirement and SBA arrangements were briefed
1
1.1  Applications of Databases in Our Daily Life Describe the uses and applications of databases in our daily life.
1
1.2  Applications of Databases in an Organization Describe concepts of data and information. Understand the importance of databases in an organization. Understand how databases improve the operations of an organization. Recognize some examples of a database system in our daily life.
2
1.3   Introduction to Database Models Describe the importance of database models. Recognize the hierarchical model. Recognize the relational model.
1
1.4  Basics of a Database Management System (DBMS) Describe the use of a database management system. Recognize the major components and functions of a DBMS. Recognize the advantages of using a DBMS
2
2.1  Overview of Data in a Database Acquire an overview of how data is stored and managed in a database.
2
2.2  Organization of Data in a Database Understand the relationship between fields, records, tables and databases
2
2.3  Common Data Types   Describe common data types such as integer, real, character, string, Boolean and date.
1
2.4  Data Management Understand the uses of data definition language (DDL) and data manipulation language (DML) for data management.
2
 
2.5  Data Dictionary Understand the use of a data dictionary and construct a simple one in a database.
2
3.1  Concept of Program-Data Independence Understand the limitations of the file-based approach. Explain the concept of program-data independence.
2
3.2  Introduction to Relational Databases Understand basic concepts of relational databases. Recognize relational data structure. Understand the characteristics of relations.
3
3.3  Relational Database Terminology Identify primary keys, candidate keys, composite keys and foreign keys.
4
3.4  Integrity Constraints Understand the integrity constraints, such as entity integrity, referential integrity and domain integrity.
2
4.1  Operations on Relations Understand the basic operations on relations.
2
4.2  Creating a Simple Relational Database Create a simple relational database.
2
4.3  Data Browsing and Indexing Recognize the operations on data browsing and indexing.
1
4.4  Data Searching Be familiar with data searching operations.
1
4.5  Sorting and Filtering Be familiar with sorting and filtering operations.
2
4.6  Creating Relationships among Tables Establish required relationships among tables.
2
5.1  Introduction to SQL Understand the basics of SQL.
2
5.2  Creating a Database with SQL Know how to create a database and a table with SQL Know how to include constraints on creating a table with SQL. Know how to create an index for a table with SQL. Know how to insert data into a table with SQL.
6
5.3  Changing the Structure of a Table with SQL Know how to change the structure of a table with SQL.  
1
5.4  Removing a Table and a Database with SQL Know how to remove a table and a database with SQL.
2
6.1  Data Query in a Database Become familiar with the SELECT statement and the WHERE clause for data query.
2

6.2   Built-in Functions

Become familiar with the usages of some built-in functions, such as mathematical functions, aggregate functions and string functions, provided in MySQL.
2

6.3   Queries with Some Other Clauses in a SELECT Statement

Become familiar with the ORDER BY clause for sorting, the GROUP BY clause for grouping and the HAVING clause for filtering.
2

6.4   Data Update in a Database

Become familiar with the UPDATE statement for data update.
2

6.5   Deleting Records from a Database

Become familiar with the DELETE statement for deleting records.
1

6.6   Creating Data Views in a Database

Become familiar with the CREATE VIEW statement for data retrieval.
1
7.1  Fundamentals of Multiple Table Manipulations Describe why and how data should be stored in multiple tables.
1
7.2  Equi-join Perform queries on multiple tables using an equi-join.
2
7.3  Natural Join Perform queries on multiple tables using a natural join.
2
7.4  Left Outer Join Perform queries on multiple tables using a left outer join.
2
7.5  Right Outer Join Perform queries on multiple tables using a right outer join.
1
7.6  Full Outer Join Perform queries on multiple tables using a full outer join.
1
7.7  Sub-query Describe how sub-queries work in a SQL statement.
2
7.8  Exporting Query Results Describe how query results are exported to different file formats in Microsoft Access and MySQL.
1
8.1  The Basics of Database Design Be aware of and appreciate the importance of a good database design in effective database management. Realize the problems caused by using a poorly designed database.
2
8.2  Data Abstraction Levels Understand the necessity of the three levels of data abstraction. Describe the three data abstraction levels in database design. Identify the data needed for each data abstraction level. 3

8.3  Conceptual Level of Database Design

Recognize the need for the conceptual level in database design. Identify the elements involved in the conceptual level of database design. Understand the basic flow of the conceptual level in database design.
2

8.4  Physical Level of Database Design

Recognize the need for the physical level in database design. Know the storage units used in a database. Know the two main methods for storing data: indexing and table storage.
2

8.5  View Level of Database Design

Recognize the need for the view level in database design. Understand how the view level of database design is applied in real situations.
2
9.1  Introduction to ER Diagrams: Entities and Relations Describe the functions of ER diagrams. Identify the components in ER diagrams.
2
9.2  Relationships Understand different kinds of relationships among entities. Understand degree constraints, cardinality constraints and participation constraints.
2
9.3  Creating ER Diagrams with Two Entities Create a simple ER diagram with two entities.
3
9.4  Resolution of Many-to-many Relationships Resolve many-to-many relationship into multiple one-to-many relationships.
2
10.1   Data Redundancy Describe what data redundancy is. Identify different anomalies brought about by data redundancy.
4
10.2  Understanding Normalization Know the reason for normalization. Describe different kinds of normal forms used for reducing data redundancy. Know how to reduce data redundancy through normalization up to third normal form (3NF).
3
10.3  Database Design Project: Sports Day Enrolment System Be able to design well-structured relational database tables with given database specifications.
3
11.1  What is the Database System Development Life Cycle? Describe what the database system development life cycle is.
1
11.2  Stages Involved in the Database System Development Life Cycle Be familiar with the stages involved in the database system development life cycle.
2
11.3  Computer Aided Software Engineering (CASE) Tool and Its Applications Practise the main design activities associated with the stages of the database system development life cycle with a Computer Aided Software Engineering (CASE) tool.
1
11.4  A Database System Design Project Using Toad Data Modeler Practise the main activities associated with the stages of the database system development life cycle using Toad Data Modeler.
3
12.1  Introduction to Data Mining Understand what data mining is. Describe the steps involved in the process of knowledge discovery in databases.
2
12.2  Data Mining Techniques Recognize the uses and applications of different sorts of data mining techniques. Appreciate how data mining can improve our quality of life.
2
12.3  Applications of  Data Mining Recognize the applications of data mining in various aspects.
1
12.4  A Data Mining Project: Building a Decision Tree Using AlphaMiner Build a decision tree and test its precision using AlphaMiner.
1
13.1    Database Personnel Identify different database personnel such as database administrators, designers, developers and data entry operators. Describe the roles and responsibilities of database personnel in database development and maintenance.
2

13.2  Data Privacy and Ethical Issues

Realize the importance of data privacy. Develop proper attitudes to respect data privacy and be an ethical user of database.
2

13.3  Control on Data Access

Describe the ways of achieving data privacy in database applications.
1

13.4  Impact of Database   Systems on Our  Life

Describe the applications of databases in daily life. Appreciate how effective use of database applications changes people’s life.
1
14.1  The Needs for Database Applications Explain the needs for different database applications, and factors such as volume of data, variety of data and variety of users should be considered.
2
14.2  The Impact of  New Technology on  Database Development Recognize the impact of technology such as mobile and wireless technology, and dynamic web pages on database development.
2
14.3  Trends of  Database Models  for Future Database Development Recognize the trends in database models, including distributed, parallel and multimedia models and their impact.
2
19.1  Introduction to HTML Understand the use of HTML and the basic structure of an HTML document.
2
19.2  Basic HTML Tags Learn and familiarize yourself with different HTML tags for different format settings.
5
19.3 Colour Representation Recognize the two ways of colour representation in web page authoring: colour names and 6-digit hexadecimal colour codes.
2

Click here for PDF version.

Christian Alliance Cheng Wing Gee College
Information and Communication Technology
S.5 Curriculum (Module C: Multimedia Production and Web Site Development)

Learning units
Main topics
No. of periods
Introduction Introducing the elective module C: MM & Web Production to students. Module requirement and SBA arrangements were briefed
2
1.1  What is Multimedia? Recognize the elements of multimedia applications.
1
1.2  Use of Multimedia Understand the varied use of multimedia applications.
1
1.3  Benefits of Using Multimedia Applications Recognize the benefits of using multimedia applications.
1
1.4  Digitization of Multimedia Elements Recognize the differences between analogue media and digital media.
1
2.1  Text Attributes Understand the basics of text attributes.
1
2.2  Text Layout Recognize different text layouts, font families found in a word processor.
1
2.3  Text File Formats Understand the properties of different text file formats. Understand the possible conversions of text file formats in some common word processors.
2
2.4  Text Production with OCR Input text into a computer using a scanner and OCR software.
1
3.1  Bits and Bytes Understand the concepts of bits and bytes.
1
3.2  Graphics and Text Understand the advantage of using graphics over text.
1
3.3  Bitmaps and Vector Graphics Understand the differences between bitmaps and vector graphics.
1
3.4  Bitmap Graphics Attributes Understand the concepts of pixel, resolution, aspect ratio and colour depth. Recognize different colour models. Understand the calculation of uncompressed graphics file size.
3
3.5  Bitmap File Formats   Recognize various graphics file formats. Understand lossless compression and lossy compression.
2
3.6  Graphics File Format Conversion Understand hoe to convert among different graphic file formats
1
3.7  Graphics Production Understand the processes of graphic production
2
4.1  Audio Attributes Recognize the attributes of digital audio files.
2
4.2  Audio File Formats Recognize different audio file formats.
2
4.3  Audio Production Capture, edit and convert audio files.
3
5.1  Video Attributes Recognize different attributes in describing a video.
1
5.2  Video File Formats Recognize some common video file formats.
2

5.3  Video Production

Understand the techniques of video production, including video capturing, editing and processing.
1
6.1  Animation Attributes Recognize different attributes in describing animation.
2
6.2 Animation File Formats Recognize different animation file formats.
2
6.3 GIF Animation Production Understand how GIF animation is produced.
2
6.4 Flash Animation Production Understand how Flash animation is produced.
3
6.5 Animation File Format Conversion Understand how animation file formats are converted to other file formats.
2
6.6 Comparing GIF and Flash Animations Identify the differences between GIF and Flash animations.
2
7.1  Stages of Multimedia Production Understand the four basic stages of multimedia production.  
2
7.2 Integrating Multimedia Elements Learn how to integrate different multimedia elements into a project.  
2
7.3 Finalizing Multimedia Products Finalize the multimedia product for different purposes.
2
8.1 Design Factor of Web Pages (I)   Plan and organise the information of website
Design the file structure
Decide on the content of the web pages
2
8.2 Design Factor of Web Pages (I) Understand the web page layout structure
Design the website layout
2
8.3 Design Factor of Web Pages (I) Know the importance of organisation for files and folders. Web Page Construction using Fireworks
2
9.1 Design Factors of Web Pages (II)   Know how to use frames
Create frames using Macromedia Dreamweaver
Understand the difference between fixed frame width and relative one.
2
9.2 Design Factors of Web Pages (II) Understand basic concept of colour schemes Use of colour codes, body background colour and text colour
2
9.3 Design Factors of Web Pages (II) Use of table with different styles Use Lists to organize information
1
10  Using Web Authoring Tools (I) Use of Hyperlinks
Know how to insert images
Use of basic HTML tags such as <H1>, <BR>, <HR>, <B>
2
10  Using Web Authoring Tools (I) Insert background images using Cascading Style Sheets (CSS) and Insert line Break, heading
Understand different web authoring tool
3
11.1  Creating Fill-out Forms Construct simple web pages using features such as fill-out forms and Mailto.
2
11.2  Manipulating Browser Windows Create pop-up windows, manipulate window location and window size, and allow scrollbars to appear when necessary.
Embed messages in browser window’s status bar such as displaying the current date, time, URL and its description.
2
11.3 Creating Special Effects Perform special effects:
Create special effects such as scrolling messages, rotating image banners, mouse over effect, blinking text and changing colours.
2
11.4 Publishing a Web Site Publish web site:
Know the basics of getting a domain name and web hosting.
Able to transfer web pages onto web sites on the Internet.
2
12.1 Static Web Pages Understand the difference between server-side and client-side technologies. Describe the characteristics of client-side scripting.
3
12.2 Dynamic Web Pages
12.3 Comparison between Static and Dynamic Web Pages
12.4 Introduction to JavaScript Recognize the basics of JavaScript.
3
13.1 Conditional Statements Explain how to use conditional statements to execute code selectively.
2
13.2 Loops Recognize for loops, while loops and do...while loops.
2
13.3 Event Handlers Understand event handlers and explain how to handle load, click and mouseover events.
2
13.4 HTML Document Object Model (HTML DOM) Describe the HTML Document Object Model (HTML DOM) and use some common objects. Perform validation using functions.
2
14.1 Creating Interactive Menus Create interactive user selection, such as the 2-level interdependent select list, pull down menu and click-to-expand menu.
2
14.2 Validating Inputted Data   Validate and manipulate input data:
Check text data, numeric data, required input, length of input, manipulate radio buttons and check boxes and valid values for all input data.
Perform simple computations to create quizzes and simple mathematics games.
2
14.3 Processing Client Information Describe how to use cookies to store and retrieve clients?information.
2
19.1 Introduction to HTML Understand the use of HTML and the basic structure of an HTML document.
2
19.2 Basic HTML Tags Learn and familiarize yourself with different HTML tags for different format settings.
4
19.3 Colour Representation Recognize the two ways of colour representation in web page authoring: colour names and 6-digit hexadecimal colour codes.
4
20.1 What is Web Authoring? Recognize the concept and the process of web authoring.
1
20.2 Planning and Organizing a Web Site Identify and familiarize yourself with the procedures and considerations in web site development, which involves planning, building, publishing and testing.
3
20.3 Basic Operation of Adobe Dreamweaver CS3 in Web Site Development Be familiar with the working environment and the flow involved in web site development in Adobe Dreamweaver CS3.
4
20.4 Project – An Integrated Practice on Web Authoring Practise developing a web site with an assigned topic.
3

Click here for PDF version.

Christian Alliance Cheng Wing Gee College
Information and Communication Technology
S.6 Curriculum

Learning units
Main topics
No. of periods
Introduction Introduction to ICT Syllabus, topics to be covered in S6 and arrangements, Public exam result analysis
1
21.1 & 21.2 Problem-solving Concepts Outline the major stages in problem-solving and explain the needs of each stage.
2
21.3  Real-life Applications and Practical Considerations Use real-life examples to illustrate the various stages in problem-solving procedures.
2
21.4  Different Ways to Solve the Same Problem Solve a problem by breaking it down into sub-problems or modules.  
2
22.1 Introduction to Algorithm Design Define algorithm. Use pseudocode and program flowchart as methods for representing algorithms.
3
22.2 Identifying Inputs and Outputs of a Problem Outline and discuss the input and output requirements of a problem, and design an appropriate user interface.
1
22.3  Basics of Constants and Variables in Computer Programming Recognize the uses and nature of simple data types and data structures in solving a problem.
1
23.1 Input Statements, Output Statements and Assignment Statements Recognize how input statements, output statements and assignment statements are used and represented.
2
23.2 Basic Control Structures Be familiar with the use of the sequence, selection and iteration control structures to control the flow of a program.
2
23.3  Algorithms for Manipulating Arrays Understand the use of an array. Learn how an array is used and manipulated in an algorithm.
2
23.4  Advantages of Using the Modular Approach in Programming Describe the advantages of modularity in designing computer solutions.
2
24.1  Tracing and Testing Algorithms Learn how to trace algorithms by identifying their boundary cases. Learn how to generate appropriate test data for algorithm testing.
2
24.2  Comparing Different Solutions to the Same Problem Compare different solutions to the same problem in different aspects, such as in the problem-solving approach, steps of operation and resource usage.
2
25.1  Equity of Access Recognize equity of access. Identify the pros and cons of freedom of information on the Internet. Recognize the digital divide and globalization and their impacts. Recognize gender equity. Learn how technologies assist people with disabilities.
2
25.2  Work Issues Recognize the changes in the working environment resulting from the advance of technology.
2
25.3  Work and Health Issues Recognize computer-related diseases.
Recognize ergonomic devices.
Recognize healthy and safe ways of using computers.
2
25.4  Consequences of Indulging in Internet Activities Recognize the consequences of Internet Addiction.
2
26.1  Intellectual Property Rights Understand the types of intellectual property rights. Recognize the Copyright Ordinance in Hong Kong.
3
26.2   Copyright of Software State the difference between proprietary software and open source software. Recognize different types of licence schemes.
2
26.3  Piracy Recognize the nature, impact and prevention of piracy.
2
27.1 Security Threats on the Internet Identify different types of malware. Recognize different ways of distributing malware. Recognize how computer users are threatened by spyware and adware
2
27.2  Security Application Software Be familiar with anti-virus software, anti-spyware program and firewall software.
2
27.3  Browsers and Security Become more familiar with the capabilities of latest web browsers. Recognize ActiveX controls and Java applets. Recognize vulnerabilities of web browsers.
1
28.1  Data Privacy Understand data privacy and the Personal Data (Privacy) Ordinance.
1
28.2  Privacy Threats on the Internet Know the privacy threats on the Internet.
2
28.3  Ways to Maintain Privacy Describe the ways to maintain privacy while surfing the Internet.  
2
28.4  Encryption Technologies Recognize the encryption technologies to protect data privacy.
2
28.5  Access Control – Authentication and Authorization Understand the basic concept of authentication and authorization.
2
28.6  Securing Transactions on the Internet Understand the software and hardware technology to secure transactions on the Internet.
2
28.7  Latest Development in Security Measures Be aware of the latest development in security measures.
2

Click here for PDF version.