2008 Computer Applications

Curriclum and School-based Assessment
Examination Papers
- S6 First Term Examination: Question Paper and Suggested Answer
- S6 Second Term Examination: Question Paper and Suggested Answer
- S7 Mock Examination: Question Paper and Suggested Answer (Special Notes)
M1: Computer Systems
- 08-CA-M1-01.doc: Hardware
- 08-CA-M1-02.doc: Software
- 08-CA-M1-03-Ex.doc: Exercise
M2C: Multimedia Presentation of Information
- 08-CA-M2C-01.doc: Text and Image
- 08-CA-M2C-02.doc: Sound
- 08-CA-M2C-03.doc: Video and Animation
- 08-CA-M2C-04.doc: Presentation Software
- 08-CA-M2C-05.doc: Effective Presentation
- 08-CA-M2C-06-Ex1.doc: Exercise 1: PowerPoint (material file)
- 08-CA-M2C-07.doc: Using Multimedia Software
- 08-CA-M2C-08-Ex2.doc: Exercise 2: Using Multimedia Software (material file)
M2A: Using Word Processing in Desktop Publishing
- 08-CA-M2A-01.doc: Basic Operations and Formatting
- 08-CA-M2A-02.doc: More Formatting Features
- 08-CA-M2A-03.doc: Advanced Features in Word Processing Software
- Exercise 1: Demo (page 1) Demo (page 2)
  Text file (Right-click and save to desktop before opening it!)
- Exercise 2: Instruction
  PartA.doc
  Marine Park Map
- 08-CA-M2A-06.doc: Index, Footnote/Endnote, OLE and Mail Merge
- Exercise 3: Instruction / Q1.doc / Q2.doc / Q3.doc / cc_logo.png / newsletter-files.zip (zip format)
M4A: Networking Basics
- 08-CA-M4A-01.doc: Basic Network Components
- 08-CA-M4A-02.doc: Data Communication and Networking
- 08-CA-M4A-03.doc: IP Network and Domain
- 08-CA-M4A-04-Ex1.doc: Exercise 1 (Answer)
- 08-CA-M4A-05.doc: LAN Applications and Internet Access
M2D: Internet Applications
- 08-CA-M2D-01.doc: Internet Basics and the World Wide Web
- 08-CA-M2D-02.doc: Search Engine
- 08-CA-M2D-03.doc: FTP, Internet News, Telnet, BBS, and Communication Services
- 08-CA-M2D-04.doc: Electronic Mail
- 08-CA-M2D-05.doc: Features of Common Web Browsers
- 08-CA-M2D-06.doc: Social Issues: Digital Divide, Globalization and Intellectual Property
- 08-CA-M2D-07.doc: Privacy and Internet Security
- 08-CA-M2D-08.doc: Computer Ethics
- 08-CA-M2D-09.doc: Security and Technology
- 08-CA-M2D-10-Ex1.doc: Exercise 1: Intellectual Property
M2B: Spreadsheet in Data Analysis
- 08-CA-M2B-01.doc: Concepts, Terminology and Basic Operations
- 08-CA-M2B-02.doc: Functions (I) (Sample Excel File)
- 08-CA-M2B-03.doc: Functions (II) (Sample Excel File)
- 08-CA-M2B-04-Ex1.doc: Exercise 1 (Excel File)
- 08-CA-M2B-05-Ex2.doc: Exercise 2 (Excel File)
- 08-CA-M2B-06.doc: Sorting; Graphs and Charts; Advanced Charts (Sample Excel File) (Excel File for Trial)
- 08-CA-M2B-07-Ex3.doc: Exercise 3 (Excel File)
- 08-CA-M2B-08.doc: Filtering, Macro and Pivot Tables (Excel File for Trial and a finished demo)
  >>> File for Exercise 4: 08-CA-M2B-08-Ex4A.xls
- 08-CA-M2B-09.doc: Data Analysis and What-if Analysis (Sample Excel File)
- 08-CA-M2B-10-Ex4B.doc: Exercise 4B (Text file for Q.1, Excel file for Q.2-5)
- 08-CA-M2B-07-Ex5A.doc: Exercise 5A (Excel File)
- 08-CA-M2B-12-Ex5B.doc: Exercise 5B (Excel File)
M4B: SOHO Network Design and Implementation
- 08-CA-M4B-01.doc: Networking Basics: A Quick Revision
- 08-CA-M4B-02.doc: Need Analysis and Design
- 08-CA-M4B-03.doc: Building a LAN
- 08-CA-M4B-04.doc: Documentation and End-user Support
  Reference: Sample CIT Report (Networking)
M4C: SOHO Network Management and Security
- 08-CA-M4C-01.doc: Monitoring the Server Performance
- 08-CA-M4C-02.doc: Troubleshooting Network Problems
- 08-CA-M4C-03.doc: Backup and Storage Technology
- 08-CA-M4C-04.doc: Security Threats and Protection Measures
M3A: Introduction to Databases
- 08-CA-M3A-01.doc: Concepts and Terminology
- 08-CA-M3A-02.doc: Applications of Database
M3X: Extra Topics for Database
- 08-CA-M3X-01.doc: Using MS Access: Table, Relations, and Simple Query (Database file: school_eca.mdb)
- 08-CA-M3X-02.doc: Using MS Access: Table Join and SQL Query (Database file: joint_test.mdb)
- 08-CA-M3X-03.doc: Using MS Access: Dat Entry Form (Database file: staff.mdb)
- 08-CA-M3X-04.doc: Using MS Access: Parameter Query, Sub-form and Report
M3B: Relational Databases and Working with SQL
- demo.mdb: A demo database file (Access 2000 format, may be updated from time to time)
- 08-CA-M3B-01.doc: Basic Concepts of a Relational Database
- 08-CA-M3B-02.doc: SQL: Introduction, Create, Insert, Delete and Update
- 08-CA-M3B-03.doc: SQL: Table manipulation and Simple query with exercise
- 08-CA-M3B-04.doc: SQL: Operators, Aggregate Functions and Group by with exercise (Suggested Answers)
- 08-CA-M3B-05-Ex1.doc: SQL: Exercise 1 (Suggested Answers)
- 08-CA-M3B-06.doc: SQL: Numeric, String and Date Functions (Suggested Answers in Appendix)
- 08-CA-M3B-07-Ex2.doc: SQL: Exercise 2 (Suggested Answers)
- 08-CA-M3B-08.doc: SQL: Tables Joins: Inner Join
- 08-CA-M3B-09.doc: SQL: Tables Joins: Outer Join
- 08-CA-M3B-10-Ex3.doc: SQL: Exercise 3
- 08-CA-M3B-11.doc: SQL: Sub-query
- 08-CA-M3B-12.doc: SQL: Union, Intersect and Minus
- 08-CA-M3B-13.doc: SQL: Index and View
- 08-CA-M3B-14-Ex4.doc: SQL: Exercise 4
- Useful Web Sites about SQL:
M3C: Introduction to Database Design Methodology
- 08-CA-M3C-01.doc: Concept Data Model
- 08-CA-M3C-02.doc: Entity-Relationship Modeling
- 08-CA-M3C-03.doc: Creating ER Diagrams (Example Diagrams)
- 08-CA-M3C-04-Ex1.doc: Exercise 1 - Drawing ER Diagrams
- 08-CA-M3C-05.doc: Refining ER Diagrams
- 08-CA-M3C-06.doc: Database Schema
- 08-CA-M3C-07.doc: Normalization
- 08-CA-M3C-08-Ex2.doc: Exercise 2 - Normalization

Notice about copyright: Some of the content in the notes are copied or derived from Wikipedia under the GNU Free Documentation License. Sources of derived content are listed in the notes.

Back to Isaac Lau's Computer Page