1 / 22

ASCA 2007 Review

ASCA 2007 Review. 07/07/07. Old syllabus 1. Information Processing 2. The Computer System 3. Operating a Microcomputer 4. Databases 5. Internet Communication 6. Word Processing 7. Spreadsheet 8. Graphics. New syllabus 1. Computer Systems 2. Office & Internet Applications

mostyn
Download Presentation

ASCA 2007 Review

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. ASCA 2007 Review 07/07/07

  2. Old syllabus 1. Information Processing 2. The Computer System 3. Operating a Microcomputer 4. Databases 5. Internet Communication 6. Word Processing 7. Spreadsheet 8. Graphics New syllabus 1. Computer Systems 2. Office & Internet Applications 3. Databases 4. SOHO Networking Curriculum Change

  3. http://sfcs.edb.hkedcity.net/

  4. Exam Statistics

  5. 2007-ASL CA Paper 1 Section A (40%) Q.1 – Q.7 Section B (60%) Q.8 - Q.10

  6. Q.1 (Computer Systems) • System requirements • Compare hardware performance • Cache? • CoreTM 2 Duo Average

  7. Q.2 (SOHO Networking) • Function of a router • Router setting Difficult

  8. Q.3 (Office & Internet Applications) • Character encoding • E-mail client setting • FTP vs E-mail attachment Easy

  9. Q.4 (Databases) • Data Dictionary • Program-data independence Difficult

  10. Q.5 (Office & Internet Applications) • Excel pivot table Average

  11. Q.6 (Databases) • E-R diagram Easy

  12. Q.7 (Office & Internet Applications) • Public Key Infrastructure Average

  13. Q.8 (Office & Internet Applications) • Symptoms of Spyware infection • Advantages of PDF • Handling text in presentation • Excel formula • Frequency() Average

  14. Q.9 (SOHO Networking) • Network design consideration • Advantages of Fiber • RAID, UPS, DHCP,VPN • Wireless LAN • P2P vs client-server Average

  15. Q.10 (Databases) • SQL commands: Select … Insert ... Alter … • Database Concepts: Primary key, foreign key, referential integrity Average

  16. Students’ performance • Better than 2006 • Complete sentenses • Elaboration • Strong in SQL • Basic computer knowledge • Misunderstanding of questions

  17. Remarks • “Common” abbreviations are accepted. RAM, VPN, CPU,…. • SQL commands in abbreviation form are not accepted. E.g. “sele” is not accepted. • Logical AND in Excel is a function, not an operator. =AND(3>2,4>6) accept = (3>2) AND (4>6) reject

  18. Remarks (Cont.) • Printed on the back of the paper 1. Suggested list of reserved words and functions 2. E-R diagram symbols • Important Document Curriculum & Assessment (C&A) Guide Available at edb.gov.hk

More Related