How do information systems collect, analyse and display data, and what technologies support these processes?
Describe how collecting, analysing and displaying are carried out in database information systems, including data validation, querying and reporting, and the hardware and software involved
A focused answer to the HSC Information Processes and Technology dot point on collecting, analysing and displaying in database systems. Data validation, querying and reporting, and the hardware and software involved, with the traps markers look for.
Reviewed by: AI editorial process; not yet individually human-reviewed
Have a quick question? Jump to the Q&A page
What this dot point is asking
NESA wants you to describe how a database information system carries out three of the seven information processes: collecting (getting data in), analysing (interpreting it) and displaying (presenting it to people). For each you should name the methods, the validation or techniques used, and the hardware and software involved. This complements the storing and retrieving and processing dot points.
The answer
Collecting
Collecting is the process of gathering data and entering it into the system. Methods include keyboard entry through on-screen forms, barcode scanning at point of sale, optical mark recognition for multiple choice forms, optical character recognition for printed text, and automatic capture from sensors or other systems. The choice depends on volume, speed and accuracy needs.
Validation checks that entered data is reasonable and complete before it is stored. Common validation types are range checks (a date of birth not in the future), type checks (a number field rejecting letters), list or lookup checks (a state field accepting only valid codes), presence checks (a required field not left blank) and check digits (an extra digit that detects keying errors in account or barcode numbers). Validation does not guarantee data is correct, only that it is plausible.
Analysing
Analysing interprets stored data to produce meaning, answer questions and reveal patterns. In a database this is done largely through queries: SELECT statements that filter, join and summarise data, with aggregate functions such as COUNT, SUM, AVG, MIN and MAX. Sorting and searching arrange and locate records; cross-tabulation and grouping summarise data across categories. The analysing process turns raw stored records into information a person can act on, for example a query that lists which products sold below target this month.
Displaying
Displaying presents information to people in a clear, useful form. The same data can be displayed as an on-screen view, a formatted printed report with headers and totals, a chart or graph that reveals trends visually, or an export to another system. Good display design suits the audience and purpose: a manager wants a summary chart, an operator wants a detailed list. Report generators and the database front end produce these outputs from the stored and analysed data.
Hardware and software
Collecting uses input hardware such as keyboards, barcode scanners, OMR and OCR readers and sensors, driven by data entry software and on-screen forms. Analysing uses the processing power of the server or workstation, driven by query tools and the database management system. Displaying uses output hardware such as monitors, printers and projectors, driven by report generators, dashboard and charting software.
How these processes fit together
Collecting feeds the database, storing and retrieving holds and recalls the data, analysing interprets it, and displaying presents the result. A weakness in collecting, such as poor validation, corrupts everything downstream, because analysis and display of bad data produce confident but wrong information.
Exam-style practice questions
Practice questions written in the style of NESA exam questions on this dot point, with worked answer explainers. The year tag is the paper they imitate, not the source.
2019 HSC3 marksA city of over six million people conducts a census online rather than on paper, with every resident logging on to a website to complete questions. Describe the advantages to the city of conducting the census online rather than on paper.Show worked answer →
Collecting is the information process being assessed. For 3 marks describe three advantages tied to collecting census data online.
Faster and automated data entry. Residents enter data directly into the system, so it is captured straight into the database without manual transcription from paper forms, speeding up collection and analysis.
Improved data accuracy and validation. Online forms can apply validation (for example required fields, range and list checks) at the point of entry, reducing errors and missing data compared with paper.
Lower cost and easier handling at scale. With over six million residents, online collection avoids printing, posting and manually processing millions of forms, and the data is immediately available for storing, retrieving and analysing.
Markers reward advantages that relate to collecting and processing the data, each clearly explained.
2022 HSC1 marksWhich of the following highlights the usefulness of interviews as a data collection method? A. Final statistics can be produced. B. Participants can remain anonymous. C. Information can be analysed from closed questions. D. Allows for a targeted group of participants to be used.Show worked answer →
The answer is D, "Allows for a targeted group of participants to be used."
Interviews are a direct, person-to-person data collection method. Their strength is that the interviewer can select and question specific, targeted people in depth and follow up with open questions to gather rich, detailed information.
The other options describe surveys or questionnaires: producing final statistics and analysing closed questions suit large surveys, and anonymity is a feature of surveys rather than face-to-face interviews. So D is the response that genuinely highlights what interviews are useful for.