Quelpr

CAPE Computer Science Unit 1 · 2008 · Paper 2 · Question 6(a)(i)

A foreign-used car dealership sells five types of cars and collects monthly sales counts per type to produce sales summaries.

Design the layout of a spreadsheet to generate the required summary information, CLEARLY specifying the formulae that you will use in the spreadsheet.

The mark scheme is shown once you've answered.

Practise this question

Other parts of this question

  1. 6(a)(ii)Describe TWO types of graphs that can be generated from the spreadsheet to make it easier for management to grasp trends in the sales information.[4 marks]
  2. 6(b)(i)What is the BEST computer-based tool that can be used to store the specified hospital information?[1 mark]
  3. 6(b)(ii)Discuss FIVE features of the chosen tool that make it appropriate for managing patient information in a hospital context.[15 marks]

More practice: the rest of this paper · more Problem-Solving Concepts and Stages questions · all CAPE Computer Science Unit 1 past papers