Back to the full dot-point answer
NSWInformation Processes and TechnologyQuick questions
Core: Information Systems and Databases
Quick questions on Collecting, analysing and displaying in databases for HSC Information Processes and Technology
3short Q&A pairs drawn directly from our worked dot-point answer. For full context and worked exam questions, read the parent dot-point page.
What is collecting?Show answer
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.
What is analysing?Show answer
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.
What is displaying?Show answer
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.
Have a question we have not covered?
This dot-point answer is short enough that we have not extracted many short questions yet. Read the full dot-point answer or ask Mo, our study assistant, in the chat for follow ups.