Band

Exemplary

Component: Communication Systems

Question 21

Written Paper Section II Question 21 - 2002 HSC

Describe the role of a file server on a network. Identify data redundancy in a database and outline the problems it may cause as the size of the database increases. Normalise the database, identifying primary and foreign keys.

Question 22

Written Paper Section II Question 22 - 2002 HSC

Identify and outline an appropriate transmission medium for segments in the public telephone network. Outline the advantages of using mobile technology for work. Describe how a data dictionary can be useful in writing SQL queries.

Question 23

Written Paper Section II Question 23 - 2002 HSC

Identifying information technology within an information system. Propose and outline two different types of information systems that could be used to analysing purchasing trends.

Component: Information Systems and Databases

Question 21

Written Paper Section II Question 21 - 2002 HSC

Describe the role of a file server on a network. Identify data redundancy in a database and outline the problems it may cause as the size of the database increases. Normalise the database, identifying primary and foreign keys.

Question 22

Written Paper Section II Question 22 - 2002 HSC

Identify and outline an appropriate transmission medium for segments in the public telephone network. Outline the advantages of using mobile technology for work. Describe how a data dictionary can be useful in writing SQL queries.

Question 23

Written Paper Section II Question 23 - 2002 HSC

Identifying information technology within an information system. Propose and outline two different types of information systems that could be used to analysing purchasing trends.

Component: Option: Automated Manufacturing Systems

Question 27

Written Paper Section III Question 27 - 2002 HSC

Describe CAD. Identify two actuators and describe a situation in which each would be used. Draw a block diagram for a letter-sorting system. Explain advantages and disadvantages of using barcodes in commercial applications. Describe and analyse automative warehouse system in terms of collecting, processing and displaying.

Component: Option: Decision Support Systems

Question 26

Written Paper Section III Question 26 - 2002 HSC

Define and give an example of two terms: structured problem and certainty factor. Design a spreadsheet to compare mobile phone plans and outline how different types of graphs could assist in the decision making. Describe and analyse a decision support system in terms of organising, analysing and processing.

Component: Option: Multimedia Systems

Question 28

Written Paper Section III Question 28 - 2002 HSC

Distinguish between LCD screens and CRT monitors and between path-based and cell-based animation. Draw a storyboard for a website using good design principles. Describe and analyse the system in terms of collecting, organising and displaying. Note: Question b (ii) is no longer applicable for the current syllabus. However, the calculation examples can be used to formulate an understanding of storage requirements for a given image file.

Component: Option: Transaction Processing Systems

Question 25

Written Paper Section III Question 25 - 2002 HSC

Define batch processing and describe a situation where it is appropriate. Distinguish between data accuracy and data integrity. Draw a dataflow diagram for a scenario, showing external entities and data stores. Discuss back-up procedures for the system. Describe and analyse an on-line ticketing system in terms of collecting; storage and retrieval; and processing. Note: 'Data accuracy' has been replaced with 'data quality' in the current syllabus.

Component: Project Management

Question 24

Written Paper Section II Question 24 - 2002 HSC

Translate a decision tree into a decision table. Discuss the importance of user documentation for an online store. Identify two social or ethical issues in the design of the online store and propose how they can be addressed.