Senior Secondary (HKDSE) · Information and Communication Technology
5 multiple-choice questions marked as you go, and 3 written questions with worked solutions. All on Data Manipulation and Analysis .
In a spreadsheet containing student records, you have student names in column A and their scores in column B. To arrange all student records such that the student with the lowest score appears first, and the student with the highest score appears last, which data manipulation technique would you use?
A spreadsheet tracks orders with columns: Region, Product, and Amount. You need to display only orders from the 'East' region for the 'Electronics' product category where the Amount is greater than $$500$$. Which of the following best describes the filtering approach?
A database table ScoreTable contains the fields StudentID, Subject, and Mark. A teacher needs to identify students whose average mark across all their subjects is greater than \( 80 \). Which of the following SQL statements will correctly achieve this?
A spreadsheet contains a list of products in Column A and their prices in Column B. To arrange the products alphabetically by name, which data manipulation technique would be used?
A column in a spreadsheet, from cell D2 to D10, contains the scores of students. Which function would correctly calculate the average score of these students?
Which spreadsheet function would be used to find the smallest number in a range of cells from E1 to E20?
Write your answer out first, then check it against the worked solution.
Explain how a 'what-if' analysis in a spreadsheet can help a business decide on the optimal pricing strategy for a new product.
Write your answer out first, then check it against the worked solution.
A spreadsheet contains a column of student IDs. If you want to arrange these IDs in ascending order, which data manipulation technique would you apply?
Write your answer out first, then check it against the worked solution.
* The content provided by thinka is generated by AI and may not always be accurate or up-to-date. Please use it as a supplementary resource and verify with official materials.
This page can show you how a good answer looks. It cannot tell you what your answer was missing. thinka marks your written work against the real mark scheme in about 15 seconds.
Want more questions like these? Get a fresh set on this topic, marked as you go.
Practise More