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.

Student Responses (15)

Band 5/6 response 1 Band 5/6 response 2 Band 5/6 response 3 Band 4/5 response 1 Band 4/5 response 2 Band 4/5 response 3 Band 3/4 response 1 Band 3/4 response 2 Band 3/4 response 3 Band 2/3 response 1 Band 2/3 response 2 Band 2/3 response 3 Band 1/2 response 1 Band 1/2 response 2 Band 1/2 response 3

Question 22

Written Paper Section II Question 22 - 2010 HSC

Describe the difference between thin and fat clients. Design a data dictionary for a school payment system. Explain how the message is organised into packets of data to be transmitted and reassembled. Explain an error detection technique.

Student Responses (17)

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.

Student Responses (1)

Exemplary response 1

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.

Student Responses (13)

Band 5/6 response 1 Band 5/6 response 2 Band 5/6 response 3 Band 4/5 response 1 Band 4/5 response 2 Band 4/5 response 3 Band 3/4 response 1 Band 3/4 response 2 Band 2/3 response 1 Band 2/3 response 2 Band 2/3 response 3 Band 1/2 response 1 Band 1/2 response 2

Question 24

Written Paper Section II Question 24 - 2010 HSC

Describe one social and one ethical issue arising from downloading digital books. Discuss the feasibility issues relating to the success of Digibook. Explain the communication protocols used during transmission for this scenario.

Student Responses (15)

Question 24

Written Paper Section II Question 24 - 2001 HSC

Describe methods of error detection. Outline new trends in processing, organising, storing and retrieving data and how these trends might be applied to an information system. Analyse issues associated with an e-mail message.

Component: Information Systems and Databases

Question 1

Written Paper Section I Question 1 - 2010 HSC

Use of a card-based system to determine location of a book

Question 1

Written Paper Section I Question 1 - 2001 HSC

Computer based method for organisation data

Question 2

Written Paper Section I Question 2 - 2010 HSC

Issue to consider when sending a digital photograph of another student in an email

Question 3

Written Paper Section I Question 3 - 2002 HSC

Mode that does not support hypermedia

Question 4

Written Paper Section I Question 4 - 2010 HSC

Statement about quality of data in a database when details are updated

Question 4

Written Paper Section I Question 4 - 2002 HSC

Storage medium that does not support direct access

Question 4

Written Paper Section I Question 4 - 2001 HSC

Components of a database schema

Question 7

Written Paper Section I Question 7 - 2010 HSC

Statement referring to normalisation

Question 7

Written Paper Section I Question 7 - 2002 HSC

Effective use of data warehouse

Question 8

Written Paper Section I Question 8 - 2010 HSC

Term for screens and reports produced from a database

Question 9

Written Paper Section I Question 9 - 2010 HSC

Approximate storage space required for records in a database

Question 9

Written Paper Section I Question 9 - 2002 HSC

Non ethical practice in management of a medical information system

Question 10

Written Paper Section I Question 10 - 2010 HSC

The schema for two new tables

Question 10

Written Paper Section I Question 10 - 2001 HSC

Not an example of metadata

Question 11

Written Paper Section I Question 11 - 2002 HSC

Method to narrow a search within a search engine

Question 14

Written Paper Section I Question 14 - 2002 HSC

Output from an identified SQL statement

Question 15

Written Paper Section I Question 15 - 2002 HSC

Selection of data using SQL

Question 16

Written Paper Section I Question 16 - 2001 HSC

Selecting data using structured query language (SQL)

Question 17

Written Paper Section I Question 17 - 2002 HSC

Data types within a data dictionary

Question 17

Written Paper Section I Question 17 - 2001 HSC

Minimising data redundancy

Question 18

Written Paper Section I Question 18 - 2010 HSC

Screen elements displayed in a sequence of screens

Question 19

Written Paper Section I Question 19 - 2010 HSC

Purpose of a specified information system

Student Responses (17)

Question 21

Written Paper Section II Question 21 - 2002 HSC

Student Responses (15)

Question 22

Written Paper Section II Question 22 - 2010 HSC

Student Responses (17)

Question 22

Written Paper Section II Question 22 - 2002 HSC

Student Responses (15)

Question 22

Written Paper Section II Question 22 - 2001 HSC

Explain an advantage and a disadvantage of computerised information compared to paper-based records. Discuss technology issues relating to storage and retrieval, and displaying images in the information system. Explain why a receptionist and doctors have different screen views of the data.

Student Responses (13)

Band 5/6 response 1 Band 5/6 response 2 Band 4/5 response 1 Band 4/5 response 2 Band 4/5 response 3 Band 3/4 response 1 Band 3/4 response 2 Band 3/4 response 3 Band 2/3 response 1 Band 2/3 response 2 Band 2/3 response 3 Band 1/2 response 1 Band 1/2 response 2

Question 23

Written Paper Section II Question 23 - 2010 HSC

Identify and explain a technique that has been implemented to reduce data entry errors. Explain the use of specified screen elements over other data collection methods. Design a screen to display data results for the scenario. Describe the analysing processes needed to generate information.

Student Responses (1)

Exemplary response 1

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.

Student Responses (15)

Question 24

Written Paper Section II Question 24 - 2001 HSC

Component: Option: Automated Manufacturing Systems

Student Responses (1)

Exemplary response 1

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

Student Responses (1)

Exemplary response 1

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

Student Responses (15)

Question 28

Written Paper Section III Question 28 - 2010 HSC

Define interactivity and the difference between linear and non-linear storyboards. Identify characteristics of file formats to embed video data into a web page. Describe a situation where path- and cell-based animation could be used. Explain the need for data compression of multimedia files. Describe the collecting and displaying processes. Predict a future application of the technology, considering future multimedia systems and virtual worlds.

Student Responses (17)

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

Student Responses (15)

Question 25

Written Paper Section III Question 25 - 2010 HSC

Describe RFID tag and the use of transmission logs in TPS. Identify characteristics of real-time processing and where batch-processing is the best solution. Construct a data flow diagram for the subsystem. Describe the collecting and storing/retrieving processes for the scenario. Predict a future application of the technology, considering security and changing nature of work.

Student Responses (1)

Exemplary response 1

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.

Student Responses (15)

Question 25

Written Paper Section III Question 25 - 2001 HSC

Discuss the advantages of a specific backup procedure and explain why alternative procedures for transactions should be tested periodically to cope with computer failure. Propose and justify modifications of a specified website and discuss potential issues. Critically analyse issues arising from a new on-line banking facility.

Component: Project Management

Question 1

Written Paper Section I Question 1 - 2002 HSC

Communication skills for effective data gathering

Question 3

Written Paper Section I Question 3 - 2001 HSC

Design tool showing movement of information in an information system

Question 5

Written Paper Section I Question 5 - 2010 HSC

Type of conversion method for updating an information system

Question 5

Written Paper Section I Question 5 - 2001 HSC

Issue relating to the storing of personal data

Question 6

Written Paper Section I Question 6 - 2010 HSC

Type of development approach for designing an information system

Question 6

Written Paper Section I Question 6 - 2002 HSC

Primary consideration in determining economic feasibility of a proposed solution

Question 8

Written Paper Section I Question 8 - 2001 HSC

Requirement prototype

Question 12

Written Paper Section I Question 12 - 2010 HSC

Use of Gantt chart to determine which tasks were completed over five weeks

Question 12

Written Paper Section I Question 12 - 2001 HSC

Interpreting a Gantt chart

Question 13

Written Paper Section I Question 13 - 2010 HSC

Use of Gantt chart to determine the delay in implementing a plan

Question 14

Written Paper Section I Question 14 - 2010 HSC

Type of test data for the testing stage of project development

Question 14

Written Paper Section I Question 14 - 2001 HSC

Context diagram symbol

Question 16

Written Paper Section I Question 16 - 2010 HSC

The next step in a traditional system of project development

Question 18

Written Paper Section I Question 18 - 2001 HSC

Interpreting a decision table

Student Responses (15)

Band 5/6 response 1 Band 5/6 response 2 Band 5/6 response 3 Band 4/5 response 1 Band 4/5 response 2 Band 4/5 response 3 Band 3/4 response 1 Band 3/4 response 2 Band 3/4 response 3 Band 2/3 response 2 Band 2/3 response 3 Band 2/3 response 1 Band 1/2 response 1 Band 1/2 response 2 Band 1/2 response 3

Question 21

Written Paper Section II Question 21 - 2010 HSC

Construct a context diagram for a new red light/speed camera system. Identify the information technology and justify a method of conversion. Describe a social and/or ethical issue for the owner/driver or government that relates to the new system.

Student Responses (15)

Question 23

Written Paper Section II Question 23 - 2001 HSC

Identify and describe criteria to be considered when conducting a feasibility study. Analyse the business initiative from a social and ethical perspective.

Student Responses (13)

Question 24

Written Paper Section II Question 24 - 2010 HSC

Student Responses (16)

Exemplary response 1 Band 5/6 response 1 Band 5/6 response 2 Band 5/6 response 3 Band 4/5 response 1 Band 4/5 response 2 Band 4/5 response 3 Band 3/4 response 1 Band 3/4 response 2 Band 3/4 response 3 Band 2/3 response 1 Band 2/3 response 2 Band 2/3 response 3 Band 1/2 response 1 Band 1/2 response 2 Band 1/2 response 3

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.