Collecting, analysing and displaying in databases for HSC Information Processes and Technology
“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”
Collecting gathers data and enters it into the database through forms, barcode and OMR scanners, sensors and online entry, with validation (range, type, list, check digit) ensuring data is reasonable before it is stored. Analysing interprets stored data using queries, sorting, searching, summarising and statistical tools to find patterns and answer questions. Displaying presents the results as screen views, formatted reports, charts and printed output designed for the audience. Each process relies on specific hardware (scanners, screens, printers) and software (data entry forms, query tools, report generators).
Jump to a section
Legacy course. This page covers HSC Information Processes and Technology (IPT), which NESA has replaced. The last IPT HSC exam was held in 2024; current students study Enterprise Computing 11-12 or Software Engineering 11-12 (first HSC exams in 2025). See the IPT hub for what carries over, or our HSC Software Engineering hub. Use this page as background only.
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.
Validation and verification are different. Validation, done by the software, checks data is reasonable (in range, right type, present). Verification, often done by a person or by double entry, checks data was entered accurately against the source. A value can pass validation yet still be wrong, which is why both matter.
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.
Saying validation guarantees correct data. Validation only checks data is reasonable; verification checks it matches the source. Both are needed.
Confusing analysing with displaying. Analysing interprets the data to produce information; displaying presents that information. A query analyses; a chart displays.
Listing input devices without linking them to collecting. NESA wants the device tied to the process and the situation (a barcode scanner for fast retail collecting).
Treating a query only as retrieval. Queries that summarise, group and calculate are part of the analysing process, not just storing and retrieving.
Forgetting the audience in display design. The right display depends on who reads it and why; a wall of raw records is poor display even if the data is correct.
Exam-style questions
Questions in the style of NESA exam questions on this dot point, each with a worked answer. They are written by ExamExplained unless tagged "Past paper"; the year shows the paper a question is modelled on.
2019 HSC-style3 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 HSC-style1 markWhich 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.