syllabuses for secondary schools computer … · computers work. rather, the aim of the syllabus is...

28
SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER APPLICATIONS (ADVANCED SUPPLEMENTARY LEVEL) PREPARED BY THE CURRICULUM DEVELOPMENT COUNCIL RECOMMENDED FOR USE IN SCHOOLS BY THE EDUCATION DEPARTMENT HONG KONG 1998

Upload: others

Post on 27-Apr-2020

3 views

Category:

Documents


0 download

TRANSCRIPT

Page 1: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

SYLLABUSESFOR

SECONDARY SCHOOLS

COMPUTER APPLICATIONS(ADVANCED SUPPLEMENTARY LEVEL)

PREPARED BYTHE CURRICULUM DEVELOPMENT COUNCIL

RECOMMENDED FOR USE IN SCHOOLS BYTHE EDUCATION DEPARTMENT

HONG KONG1998

Page 2: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

2

Page 3: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

3

CONTENTS

Page

PREAMBLE 5

1. INTRODUCTION 7

2. AIMS AND OBJECTIVES 9

3. ESTIMATED TIME ALLOCATION 10-11

4. NOTES ON TEACHING 12

5. THE SYLLABUS 13-19

6. TEACHING RESOURCES 20-25

7. MEMBERSHIP OF THE CDC COMPUTER STUDIES 26-27SUBJECT COMMITTEE (SIXTH FORM)

Page 4: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

4

Page 5: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

5

PREAMBLE

This syllabus is one of a series prepared for use in secondary schools by the CurriculumDevelopment Council, Hong Kong. The Curriculum Development Council, together with its co-ordinating committees and subject committees, is widely representative of the local educationalcommunity, membership including heads of schools and practising teachers from government andnon-government schools, lecturers from tertiary institutions, officers of the Hong KongExaminations Authority as well as those of the Curriculum Development Institute, the AdvisoryInspectorate and other divisions of the Education Department. The membership of the Councilalso includes parents and employers.

All syllabuses prepared by the Curriculum Development Council for the sixth form will leadto appropriate papers of the Hong Kong Advanced Level Examination.

This syllabus is recommended for use in Secondary 6 and 7 by the Education Department.Once the syllabus has been implemented, progress will be monitored by the Advisory Inspectorateand the Curriculum Development Institute of the Education Department. This will enable theComputer Studies Subject Committee (Sixth Form) of the Curriculum Development Council toreview the syllabus from time to time in the light of classroom experiences.

All comments and suggestions on the syllabus may be sent to:

Principal Curriculum Planning Officer (Sixth Form)Curriculum Development Institute,Education Department,Wu Chung House, 13/F,213 Queen’s Road East,Wan Chai,Hong Kong.

Page 6: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

6

Page 7: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

7

1. INTRODUCTION

This syllabus is recommended for use in Hong Kong secondary schools at Secondary 6-7.It covers a two-year Advanced Supplementary Level course leading to an examination in theHong Kong Advanced Level Examination.

This is a revised edition of the previous syllabus published in 1996. The revision is basedon the recommendations of the Joint Working Group (JWG) comprising members of theCurriculum Development Council and the Hong Kong Examinations Authority Computer StudiesSubject Committees. The JWG was set up to carry out an overall review of the syllabuses ofcomputer subjects in secondary schools in October 1995 and to develop a set of computersyllabuses for students of the 21st Century. Based on the evaluation reports of computersubjects from various sources and the review on the current trend of computer technology, newapplications such as Internet access and multimedia are included in the syllabus.

As suggested by the title ‘Computer Applications’, the approach to the subject should notfollow that of any Computer Studies subjects. It is not intended to teach students in detail howcomputers work. Rather, the aim of the syllabus is to make students feel at ease in usingpersonal computers. The syllabus emphasizes practical skills and the use of commonapplication software packages. The syllabus includes the study of five types of computer-basedapplications which are Databases, Internetwork Communication, Word Processing,Spreadsheet, and Graphics. Students are expected to develop knowledge and skills in handlingthese software packages effectively and with confidence.

New sections such as Information Processing and The Computer System have beenadded for students to develop an awareness of the impact on society due to the increasing use ofcomputers in all walks of life and to understand the fundamental concepts of computer systems.A topic on Social Implications is also included in the section of Information Processing fordeveloping positive attitude of computer usage among students as well. The section Operatinga Microcomputer is extended to include the Chinese input method and the handling of Chinesecharacter.

This subject is intended for all sixth form students. It does not assume any previousknowledge of computing at a lower level.

There are two computer subjects in the sixth form curriculum. The other subject, entitledAdvanced Level Computer Studies, focuses more on principles of computer organization andprogramming. However there are overlapping on the contents of these syllabuses, studentsshould not take both subjects in the same period of time.

Though the knowledge acquired in this subject may not be directly relevant to other subjects,students who go on to further study will find themselves equipped with skills of making use ofpersonal computers as tools and resources for their study process. Those who leave school foremployment should also find the experience extremely useful and highly applicable to their work.

Page 8: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

8

2. AIMS AND OBJECTIVES

AIMSThis syllabus aims to provide students with an opportunity to:

1. develop an understanding of the basic operations of a computer system and computerapplications software;

2. develop the skills of using computer applications software for solving problems;

3. appreciate the social implications of developments in information technology.

OBJECTIVESThe objectives of the syllabus are to enhance students’ ability to:

1. demonstrate an understanding of the basic operations of a computer system;

2. explain the principles of operations for computer systems used in a particular application,specifically in terms of the systems’ hardware and software components;

3. use computer terminology correctly in the context of a particular application;

4. use computer applications software to solve problems;

5. discuss and comment on the social impact of the widespread use of computer technology;

6. automate simple tasks in specific applications.

Page 9: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

9

3. ESTIMATED TIME ALLOCATION

A time allocation of 4 periods per week is recommended for this course. Taking anaverage school year as 22 teaching weeks (excluding examination periods), a total of 176 periodsis available in the two-year course. On a six-day cycle basis, the time allocation should be 5periods per cycle.

In this course, students should work with computers on a regular basis. Thus, thepractical time should be distributed over the two-year period. Throughout this period, teachersshould encourage students to develop their knowledge and skills with the use of computers.

An estimate of the number of periods for each section is shown below :

Topic No. of Periodsallocated

1. Information Processing 241.1 Components of an information system1.2 Information management1.3 Problem solving with computer1.4 Applications in industry, commerce, science and education1.5 Social implications

2. The Computer System 112.1 System unit2.2 Peripheral devices2.3 Communication devices2.4 System software2.5 Applications software

3. Operating a Microcomputer 173.1 Starting up the computer3.2 Operating input/output devices3.3 Using an operating system3.4 Using applications packages3.5 Using a Chinese system

4. Databases 364.1 Concepts and terminology4.2 Database management4.3 Query by using structured query language (SQL)4.4 Multiple databases

Page 10: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

10

Topic No. of Periodsallocated

4.5 Generating screen, report and label4.6 Macros

5. Internetwork Communication 195.1 Concepts and terminology5.2 Internet5.3 Electronic mail5.4 Setting up homepages

6. Word Processing 216.1 Concepts and terminology6.2 Typing6.3 Creating, editing, retrieving, saving and printing a document6.4 Page setup and formatting6.5 Other features6.6 Macros6.7 Desktop publishing

7. Spreadsheet 327.1 Concepts and terminology7.2 Building, editing, retrieving, saving and printing a worksheet7.3 Formatting7.4 Data manipulation7.5 Graphs7.6 Multiple worksheets7.7 Macros7.8 Data analysis

8. Graphics 168.1 Concepts and terminology8.2 Creating and editing a graphic image8.3 Presentation graphics8.4 Graphic files

Total: 176

Page 11: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

11

4. NOTES ON TEACHING

As the aim of the subject is to ensure that students know how to use the computer as a tool,a practical approach should be adopted in the teaching and learning of this syllabus. Practicalwork is essential for students to gain personal experience of computer through doing and problemsolving. The computer should be used as frequently as possible for practical activities. Rotelearning of commands and keystrokes as discrete pieces of information should be discouraged.Instead, students should be asked to carry out case studies through which the use of commandscan be learned with frequent practices.

Though this subject does not assume any background in computing, some basic skills areessential. Teachers may begin by briefly introducing the basic skills, such as operatingmicrocomputer, in order to prepare their students for the subject.

The list of topics suggested under each section is by no means exhaustive. Whencarrying out a case study or developing a project work, students may encounter problems that maybe more efficiently or effectively solved by features not mentioned in the syllabus. Under suchcircumstances, teachers should encourage and guide students to explore and use the appropriatefeatures to solve the problem. Upon completion of the course, students are expected to haveacquired the ability of using application packages efficiently to produce solutions to problems andbe able to document these solutions.

The order of the topics presented in the syllabus should not be interpreted as the rigidteaching sequence. Teachers should make relevant adjustments and the topics should be taughtat a pace best suited to the abilities of their students.

Teachers should also encourage students to explore the interrelationship betweenapplication packages. Where appropriate, students should be asked to integrate the use ofdifferent packages in problem solving.

In view of the fast and continuous development in information technology, teachers andstudents should bear in mind that no matter how updated a package may be, it will becomeoutdated some time later. In order to bridge the gap between current developments ininformation technology and the software in use, teachers and students are advised to update theirknowledge regularly from different sources such as magazines, exhibitions, etc. Also, studentsshould be encouraged to develop the habit of consulting user manuals so that at a later stage theycan acquire the skills of using different software through self-learning.

To assess students’ performance, assessment can be broadly divided into two types, viz.formative assessment and summative assessment. Generally speaking, teachers are morefamiliar with the latter one, which usually takes the form of end-of-course tests/examinations.However, it is important that teachers do not underestimate the significance of the former one, asthe purpose of formative assessment is to enhance students’ learning, and is thus equally vital tosuccessful teaching and learning. Formative assessment conducted in oral, practical or writtenforms provides very useful evaluation information.

Based on feedback from teachers, notes on teaching on specific topic(s) would be up-dated and issued from time to time in the form of supplementary information to schools in due

Page 12: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

12

course.

Page 13: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

13

5. THE SYLLABUS

TOPICS CONTENT1. Information Processing1.1 Components of an information

systemRoles of and interrelationship among the followingcomponents: people, procedures, software, hardwareand data.

1.2 Information management Gathering, verification, validation and organisation ofdata.Processing, presentation and distribution of information.

1.3 Problem solving withcomputer

Identification.Analysis of problem.Design of solution.Implementation and testing.Evaluation.Documentation.

1.4 Applications in industry,commerce, science andeducation

Examples of computer applications such as robotics,production control system, embedded systems inhousehold appliances, communication and informationsystems, artificial intelligence, expert systems,computer-assisted learning (CAL), multimedia,computer-aided design (CAD), computer-aidedmanufacturing (CAM), personal information managers,project management software, desktop publishingsoftware.

1.5 Social implicationsSocial and economicaldevelopment

Offices and factories in the future.Electronic information dissemination.Effects of massive interactive communication.Change in life style.Organization downsizing and rightsizing.

Employment Training of staff: skill, attitude.Automation, increased productivity.New job opportunities.

Data protection Data accuracy.Privacy.

Ergonomics Possibility of health hazards, good habits of usingcomputers.Designing computer systems which cope with humanphysical capabilities.

Computer ethics Computer crime: unauthorized access to informationsystem, piracy and misuse of personal data.Software copyright: legal aspectsComputer virus: nature and prevention.

2. The Computer System2.1 System unit Central processing unit.

Memory.

Page 14: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

14

TOPICS CONTENT2.2 Peripheral devices

Input devices Keyboard, pointing devices (mouse, touch screen, lightpen, digitizer), scanning devices (image scanner, faxmachine, bar-code scanner, magnetic ink characterrecognition, optical character recognition, optical markrecognition), voice-input devices and Chinese handwriting recognition device.

Output devices Visual display unit, printer (laser, ink-jet, dot-matrix),plotter and voice-output device.

Storage devices Floppy disk, hard disk, magnetic tape and optical disk.2.3 Communication devices Modem, network devices.

Local area network.2.4 System software Operating system.

Utility programs.2.5 Applications software Custom-made software.

Packaged software.3. Operating a microcomputer3.1 Starting up the computer Cold boot, warm boot, booting the computer with a

diskette.3.2 Operating input/output devices

including printer, visualdisplay unit, keyboard, mouseand scanner

Installing and changing the settingsPrinter: loading of paper and envelope.Scanner: selecting image type, colour, size andresolution.

3.3 Using an operating system Basic operations including creating, renaming anddeleting a directory; copying, moving, renaming,deleting files; recovering deleted files; searching forfiles, displaying files information, changing fileattributes, backing up files, creating a batch file.

3.4 Using applications packages Installing and running an applications package.Selecting a suitable package for a given task.Importing and exporting of files among differentpackages.

3.5 Using a Chinese system Characteristics of Chinese characters: character set size,graphical composition, usage frequency, layout ofChinese text and their impact on a computer system.Technical issues of Chinese character processing.Installing and selecting different input methods andChinese fonts.Keying in Chinese characters using a coding schemesuch as Tsang-jei coding scheme.Constructing Chinese characters of different sizes.Appreciation of different methods of inputting Chinesecharacters.

4. Databases4.1 Concepts and terminology Data versus information.

Data characteristics: independence, redundancy,

Page 15: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

15

TOPICS CONTENTintegrity.Database terminology: Database, file, record, field; basetable, table, column, row, view.Components of database management system.Relational database.

4.2 Database managementCreating a database Data types: character, numeric, logic, memo, date.

Database file definition features.Data dictionary facilities.Index definition.Opening and closing a database file.

Database maintenance Concept of record pointer and scope.Adding data to a database.Deleting database contents.Changing database contents.Modifying the structure of a database.

Database manipulation Viewing the contents of a database file.Arithmetic operators, comparison operators, logicaloperators, expression.Using built-in functions.Multiple field indexing and multi-level sorting of adatabase file.Filtering data with logical operations

4.3 Query by using structuredquery language (SQL)

General features of SQL.Basic structure of SQL retrieval commands SQL.Displaying data through SQL.Data retrieval by SQL filteringin, between and like operators.Source and range for query.

4.4 Multiple databases Choosing work areas for database.Setting logical relations between database.Combining database: equi-join, natural join, outer join.Union, difference and intersection of database.Processing data among multiple databases.

4.5 Generating screen, report andlabel

Screen format design.Label format design.Subgroups reporting.Report format design.

4.6 Macros Recording and using macros.5. Internet Communication5.1 Concept and terminology Internet, transmission control protocol, Internet protocol

(TCP/IP), domain name system, UNIX, Web siteaddress, hypertext, homepage, Internet Service Provider(ISP), Internet address, Uniform Resource Locator(URL), Hypertext Transport Protocol (HTTP),Hypertext Markup Language (HTML).

5.2 Internet

Page 16: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

16

TOPICS CONTENTInternet resources Worldwide Web (WWW), newsgroup, bulletin board

system (BBS), electronic mail, conversation over theInternet, remote logon.

Preparing for Internet access Setting up of parameters for Internet accessing software.Dialling up, logging on/off procedures and use ofpasswords.

Using a browser Navigating the Web and traversing hypertext links,accessing documents in the Web (reading , printing andsaving), use of external audio/video viewers andconfiguring the browser (e.g. use of proxy servers).Using search engines to search for information in theInternet, downloading files.

5.3 Electronic mail Using electronic mail addresses and address book.Sending and receiving electronic mail, attachment files,viewers, forwarding and replying mails.Managing mails with folders/mailboxes.

5.4 Setting up homepages Employing simple hypertext links to design homepagesfor presenting information.Use of homepage developing tools.

6. Word Processing6.1 Concepts and terminology6.2 Typing English and Chinese characters, symbols, equations.

Typeface, font size and style.

6.3 Creating, editing, retrieving,saving and printing adocument

Delete, insert, cut, paste.Search and replace.Import of different types of files.

6.4 Page setup and formatting Tabs, margins, line spacing, page size.Bullet and numbering.Justification, indentation, pagination.Header and footer.

6.5 Other features:Table handling Converting text to table.Spell checking and thesaurusMail-merge Data file, master file, merge printing.TemplateChinese word processingfeatures

Vertical and horizontal printing, punctuation marks.

6.6 Macros Recording and using macros.6.7 Desktop publishing

Adding graphics and clipartpictures

Shadow background.

Text columns Newspaper-style, parallel columns.7. Spreadsheet7.1 Concepts and terminology Cell, row, column, address, relative address, absolute

address, range, worksheet, table, function, formula,macro.

Page 17: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

17

TOPICS CONTENT7.2 Building, editing, retrieving,

saving and printing aworksheet

Text, numbers, formulae.Inserting and deleting a row/column.Naming a range.Cut and paste, erasing a range.Page setup in printing.Split windows and freeze headings.

7.3 Formatting Setting column widths and row heights.Alignment of cell contents.Assigning date, number and time formats.Border and shading.

7.4 Data manipulation Using various functions of a spreadsheet program tocalculate the sum, average, maximum, minimum, etc.Using and copying formulae.Using relative and absolute addresses.Sorting, including multiple-key sorting.Table lookup.

7.5 Graphs Graph settings, graphs with at most two sets ofdependent values.Adding graph labels, titles and legends.Saving, viewing and printing a graph.Adding graphs to a worksheet.

7.6 Multiple worksheets Referring and manipulating data dynamically linked toother worksheets.

7.7 Macros Recording and using macros.7.8 Data analysis Finding the value that best fits a set of conditions for a

particular cell of a worksheet by changing the values ofone or more cells of the worksheet or of otherworksheet(s).

8. Graphics8.1 Concepts and terminology Pixel.

Resolution, colours, gray levels.Bit-map graphics.Vector graphics.Objects.

8.2 Creating and editing a graphicimage

Drawing shapes, painting pictures and editing a graphicimage.Transformation of graphic images.Grouping and ungrouping.Loading, saving and printing graphical files.

8.3 Presentation graphics Creating and editing a presentation.Applying a template to a presentation.Using transition effects and building effects.Controlling the timing of a presentation.Presenting a slide show.

8.4 Graphic files Capturing and importing graphic images.Exporting graphic images in different file formats.

Page 18: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

18

Appendix

1. List of suggested commands, constants and functions for teaching database:

Type Commands/constants/functions

Constants .F., .T.Variable handling &Operators +, -, *, /, $, >, <, =, >=, <=, <>, AND, NOT, ORFunctions ABS, MOD, ROUND, SQRT

ASC, AT, CHR, LEFT, LEN, LOWER, LTRIM, RIGHT,RTRIM, SPACE, STR, STUFF, SUBSTR, UPPER, VALBOF, DELETED, EOF, FOUND, RECCOUNT, RECNOCDOW, CMONTH, CTOD, DATE, DAY, DOW, DTOC,MONTH, YEAR

Input/output statements ?, ??, @, @GET...TO, @SAY, ACCEPT...TO, DISPLAY,DISPLAY ALL, DISPLAY FOR, DISPLAY STRUCTURE, EJECT,INPUT...TO, LIST, LIST ALL, LIST FOR, LIST STRUCTURE,WAIT

Assignment statements =, READ...TO, REPLACE...WITH...FOR, STORE ...TOProcedure statements DO, QUIT, RETURN,

SET DATE/DEBUG/DECIMALS/DEFAULT/FIELDS/FILTER/ FORMAT/INDEX/PATH/ RELATION/VIEW TO,

SET DELETED/ECHO/EXACT/FIXED/ PRINT ON/OFFComment statement *Database commands ->, APPEND, APPEND BLANK, APPEND FROM...FOR,

AVERAGE, BLANK, BROWSE, COPY FILE...TO,COPY STRUCTURE TO...FIELDS, COPY TO...FOR...FIELDS,COUNT FOR, CREATE, CREATE LABEL/REPORT/SCREEN,DELETE, DELETE ALL, DELETE FOR, EDIT, EDIT FOR,FIND, GO TOP/BOTTOM, GOTO, INDEX ON, LABEL FORM,LOCATE, MODIFY LABEL/REPORT/SCREEN/STRUCTURE,PACK, PLAY MACRO, RECALL, RECORD MACRO,REINDEX, REPORT FORM, SAVE MACRO, SEEK, SELECT,SKIP, SORT ON...TO, SUM, TOTAL,UPDATE ON...FROM...REPLACE...WITH..., USE, ZAP

SQL ADDITIVE, ALL, AS, ASC, BETWEEN, DESC, DISTINCT,FROM, GROUP BY, HAVING, IN, INTO, LIKE,ORDER BY, SELECT, TO FILE, TO PRINTER, TO SCREEN,UNION, WHERE

Page 19: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

19

2. List of suggested commands, constants and functions for teaching spreadsheets:

Type Commands/constants/functions

Constants TRUE, FALSEOperators +, -, *, /, <, >, =, <>, <=, >=, AND, NOT, ORFunctions ABS, EXACT, INT, MOD, ROUND, SQRT

CHAR, LEFT, LEN, LOWER, MID, PROPER, RIGHT, TRIM,UPPER, VALUEAVERAGE(AVG), COUNT, MAX, MIN, SUMDATEFIND, HLOOKUP, VLOOKUP, LOOKUP

Branching/iterationcommand

IF

Page 20: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

20

6. TEACHING RESOURCES

1. Reference books

General reference books

Title Author Publisher Year

A Glossary of Computing Terms (8th

Edition)British ComputerSociety SchoolsCommittee

Longman 1996

Computers L. Long Prentice-Hall 1993Complete Computer Concept and

Windows ApplicationShell Catchman Waggmer 1990

IBM Dictionary of Computing G. McDaniel McGraw-Hill 1994Information System: Theory and

PracticeJ. Burch Wiley 1992

Microsoft Press ComputerDictionary – 3rd Edition

Microsoft Microsoft Press 1997

Peter Norton’s Introduction toComputers

Peter Norton Glencoe 1995

Peter Norton 電腦概論 谷建華等 譯 儒林 1995電腦應用問答 150 士會 譯 萬里 1995

Reference books on Information Processing

Title Author Publisher Year

Computer Security for Users ofSmall Computers System

Peat Marwick RHKPC 1994

Data Processing and InformationTechnology – 10th Edition

C.S. French DP 1996

Guide to Software Management Business SoftwareAlliance

BusinessSoftwareAlliance

1995

Information System: Theory andPractice

J. Burch Wiley

Microprocessing & Microcomputer T. Hanley DP 1993

Page 21: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

21

TechnologyTitle Author Publisher Year

Success in Information Processing John Murray中文版 WINDOWS 3.1 教學範本 黃景增 譯 松崗 1993

Reference books on Operating a Microcomputer

Title Author Publisher Year

Mastering Microsoft Office 97 :Professional Edition

Lonnie E. Moseley, et al Sybex 1997

Office 97 Annoyances J. T. Lee O'Reilly &Associates

1997

Running Microsoft Office 97 Michael Halvorson, et al Microsoft Press 1997Windows Annoyances David A. Karp, et al O'Reilly &

Associates1997

WYSIWYG Guides: The waycomputers and MS-DOS work

Simon Collin DorlingKindersley

1993

Windows NT 一日通 陸斌 譯 萬里 1994中文版 WINDOWS 3.1 教學範本 黃景增 譯 松崗 1993電腦 MS-DOS 新解 士會 譯 萬里 1995WORD 6.0 中文版教學手冊 郭姮劭 碁峰 1995實用倉頡字典 陳雪梅 快拍設計 1995

Reference books on Database

Title Author Publisher Year

Foxpro 2.5 for Windows Jones McGraw Hill 1992Mastering Foxpro 2.5 Special

EditionSyrex/Tech Syrex/Tech 1992

Microsoft FoxPro 2.5 for Windows Cataputt Microsoft Press 1993Microsoft Office Ron Mansfield TP 1994The Practical SQL Handbook :Using Structured Query Language

Judith S. Bowman, et al Addison-Wesley Pub Co

1996

Programming Foxpro 2.5 Liskin PC magazine 1993

Page 22: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

22

Using Foxpro 2.5 for Windows Slater & Arnott QUE 1993

Page 23: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

23

Title Author Publisher Year

Using Visual Foxpro 5 Michael P. Antonovich,et al

Que Education& Training

1996

超級數據庫 FOXPRO 蔡浩良 萬里 1995趣味 dBASE . FOXBASE程序 袁慶華 北京師範大學 1994

Reference books on Internetwork Communication

Title Author Publisher Year

Easy Web Publishing With Html 3.2 Jonah Neugass Que Education& Training

1997

The Non-Designer's Web Book : AnEasy Guide to Creating, Designing,and Posting Your Own Web Site

Robin Williams, et al Peachpit Pr 1997

Reference books on Word Processing

Title Author Publisher Year

Microsoft Office Ron Mansfield TP 1994Microsoft Word 97 : Complete

Course : Step by StepRussell Borland Microsoft Press 1997

Word 97 Bible Brent D. Heslop, et al IDG BooksWorldwide

1997

WORD FOR WINDOWS 新解 士會 譯 萬里 1995視窗 WORD 一日通 陳啟泰等 譯 萬里 1995

Reference books on Spreadsheet

Title Author Publisher Year

Excel 4.0 for Windows Ricky & Patty Winter QUE 1992Excel 5 Super Book Paul Mcfedries SAMS 1994Inside Excel for Windows Bruce Hallberg NRP 1992

Page 24: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

24

Title Author Publisher Year

Microsoft Excel 97 Step by Step Inc. Catapult Microsoft Press 1997Microsoft Office Ron Mansfield TP 1994Using Excel Ver 5 for Windows RonPerson QUE 1994Using Microsoft Excel 97 Laura Monsen Que Education

& Training1997

EXCEL 5.0 中文版教學手冊 許家豪 碁峰 1994EXCEL FOR WINDOWS 新解 士會 譯 萬里 1995EXCEL 宏程序設計 方中 北京大學 1995LOTUS 123 教學手冊 黃秀芳 碁峰 1994視窗 EXCEL 一日通 彭易 譯 萬里 1995

Reference books on Graphics

Title Author Publisher Year

Mastering PowerPoint 4 Murray TP 1994Mastering Powerpoint 97 Katherine Murray Sybex 1997Microsoft Office Ron Mansfield TP 1994Microsoft PowerPoint for Windows Steve Johnson Microsoft Press 1994Running Microsoft Powerpoint 97 Stephen W. Sagman, et

alMicrosoft Press 1997

30分鐘系列 PowerPoint Gotop 碁峰 1994

Reference books on Computer Ethics

Title Author Publisher Year

Computer Ethics Tom Forester Blackwell 1990Computer Security for Users of

Small Computers SystemPeat Marwick RHKPC 1994

Copyright in Hong Kong Intellectual PropertyDepartment,Government of HKSAR

GovernmentPrinter, HongKong

1998

Guide to Software Management Business SoftwareAlliance

BusinessSoftwareAlliance

1995

Page 25: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

25

Title Author Publisher Year

Intellectual Property in Hong Kong Intellectual PropertyDepartment,Government of HKSAR

GovernmentPrinter, HongKong

1997

Internet Surfing with Privacy inMind

- A Guide for Individual Net Users

Office of the PrivacyCommissioner forPersonal Data, HongKong

GovernmentPrinter, HongKong

1998

Personal Data Privacy and theInternet - A Guide for Data Users

Office of the PrivacyCommissioner forPersonal Data, HongKong

GovernmentPrinter, HongKong

1998

Personal Data (Privacy) Ordinance:A Guide for Data Users - No. 1Personal Data Privacy

Office of the PrivacyCommissioner forPersonal Data, HongKong

GovernmentPrinter, HongKong

1997

Personal Data (Privacy) Ordinance:A Guide for Data Users - No. 2Compliance with Data Accessand Correction Requests

Office of the PrivacyCommissioner forPersonal Data, HongKong

GovernmentPrinter, HongKong

1997

Personal Data (Privacy) Ordinance:A Guide for Data Users - No. 3Outline Action Plan ForComplying with the DataProtection Principles

Office of the PrivacyCommissioner forPersonal Data, HongKong

GovernmentPrinter, HongKong

1996

Personal Data (Privacy) Ordinance:Code of Practice on the IdentityCard Number and other PersonalIdentifiers

Office of the PrivacyCommissioner forPersonal Data, HongKong

GovernmentPrinter, HongKong

1998

香港的知識產權 香港特別行政區政府知

識產權署

香港政府印務局 1997

香港的版權法 香港特別行政區政府知

識產權署

香港政府印務局 1997

保障網上私隱須知

- 互聯網個人用戶指引個人資料私隱專員公署 香港政府印務局 1998

Page 26: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

26

Title Author Publisher Year

個人資料私隱與互聯網

- 資料使用者指引個人資料私隱專員公署 香港政府印務局 1998

個人資料(私隱)條例:

資料使用者指引-第 1號個人資料私隱

個人資料私隱專員公署 香港政府印務局 1997

個人資料(私隱)條例:

資料使用者指引-第 2號處理查閱資料要求及改正資料

要求

個人資料私隱專員公署 香港政府印務局 1997

個人資料(私隱)條例:

資料使用者指引-第 3號遵守保障資料原則的行動計劃

摘要

個人資料私隱專員公署 香港政府印務局 1996

個人資料(私隱)條例:

身分證號碼及其他身分代號實

務守則

個人資料私隱專員公署 香港政府印務局 1998

Page 27: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

27

7. MEMBERSHIP OF THE CDC COMPUTER STUDIESSUBJECT COMMITTEE (SIXTH FORM)

The membership since 1 September 1995 has been as follows:

Chairman Mr WONG Kwong-wai, Raymond

Vice Senior Inspector (Curriculum Development/Computer Education)1,Chairman Curriculum Development Institute, Education Department

(Mr LEUNG Shiu-keung, until 1 Feb. 1998)(Mr CHAN Hau-wing, from 2 Feb. 1998 to 14 May 1998)(Mr CHAN Hing-lam, from 15 May 1998)

Ex-officio Senior Inspector (Computer Education),Member Advisory Inspectorate Division, Education Department

(Mr SIN Tak-wah, until 21 Jul. 1998)(Mr TANG kin-hung, from 22 Jul. 1998)

Members Ms AU Kit-ming

Prof CHIN Yuk-lun, Francis(until 31 Aug. 1997)

Mr CHUNG Sze-kwong

Mr CHUNG Yik-fai, Gordon(until 31 Aug. 1997)

Mr FUNG Yuk-lun(from 1 Sep. 1997)

Dr KAO Chi-ming, Benjamin(from 1 Sep. 1997)

Dr HUNG Sheung-lun(until 31 Aug. 1997)

Page 28: SYLLABUSES FOR SECONDARY SCHOOLS COMPUTER … · computers work. Rather, the aim of the syllabus is to make students feel at ease in using personal computers. The syllabus emphasizes

28

Mr LEE Yee-wing, Bobby(from 7 Jul. 1998)

Mr LEUNG Ka-kiu, Philip(until 31 Aug. 1997)

Mr NGAI Lung-fai, Francis(from 1 Sep. 1997)

Dr NGAI Tin-fook(from 1 Sep. 1997)

Dr MOON Yiu-sang(until 31 Aug. 1997)

Mr PUN Sai-wing

Mr TUNG Lai-sun(until 6 Jul. 1998)

Mr WONG Wing-hong, Robert(from 1 Sep. 1997)

Mr YUI Choi-king

Secretary Curriculum Officer (Computer Education),Curriculum Development Institute, Education Department(Mr LUI Kam-ming)