Important

Question 1

Describe the purpose of the Evaluation stage

Answer 1

To see if the program is fit for purpose, robust, maintainable and makes use of efficent coding constructs

Question 2

Explain why the Developmental process is iterative

Answer 2

Each stage can be revisited in order to improve the final stage

Question 3

A program reads data from an outdoor temperature sensor and displays an appropriate message to the user

Identify the inputs, process and outputs

Answer 3

inputs - temperature
process- decide message
output-message

Question 4

Explain what is meant by the character data type

Answer 4

a single character

Question 5

A school wants to reduce the energy consumption of the computing department.
Pupils are already encouraged to put the computers into standby mode when not in
use.
Describe two other methods to reduce the energy consumption of the computers.

Answer 5

• settings on monitors
• power down when not in us

Question 6

Claire is no longer able to run the 3-4 Years class on a Tuesday in the
Autumn block.
The SQL statement below is written to make the change.
DELETE FROM Class
WHERE leaderName = “Claire”
AND classAge = “3-4 Years”;
Give one reason why this SQL statement is not fit for purpose

Answer 6

All Claire’s ‘3-4 Years’ classes are
removed.

Question 7

Why would a low fidelity prototype be used during the web design stage

Answer 7

to show the intended user
interface to client

Question 8

Field type for mobile phone numbers in a database: 07968877171

Answer 8

Text

Question 9

What is 87 in binary

Answer 9

01010111

Question 10

What is an insert anomaly

Answer 10

When a table only permits new data in all fields

Question 11

What can be determined by listing the fields and tables that need to be included in the database?

Answer 11

Functional Requirements

Question 12

The following HTML is to be added to the website.
<a>Car of the Week</a>
State the purpose of adding this HTML to the website.

Answer 12

adds a hyperlink

Question 13

What is the purpose of the ˂div˃ element in HTML?

Answer 13

To allow for styles to be applied to a group of elements within a section of HTML code

Question 14

What is the purpose of the ˂ul˃…˂/ul˃ tags?

Answer 14

to show an unordered list

Question 15

Arthur’s Antiques sells old furniture. All staff receive a monthly bonus of £50, which is increased if they sell over 10 items of furniture. The bonus is increased further if they sell over 20 items of furniture. List the variables and data types required to implement the solution

Answer 15

loop, integer
bonus, real
sales, integer

Question 16

Explain why the telephone number 07700 901012 should be stored as a text field type and not a numeric field type.

Answer 16

The telephone number contains a leading zero which would be dropped if stored as a number

The telephone number contains a space which is not valid in numeric field

The telephone number will not be used for calculations

Question 17

Name the part of the computer system that will carry out each of the following tasks during the execution of Line 23.
(i) Carries the location of redAvailable in main memory.

Answer 17

address bus

Question 18

State the component that enables a processor and a hard disk drive to
communicate.

Answer 18

interface

Question 19

What is the name for the graphical representation of entities in a database that shows their relationship to each other?

Answer 19

Entity Relationship diagram

Question 20

businesses must (under Data Protection)

Answer 20

process information lawfully

Question 21

what is not a vector object

Answer 21

circle

Question 22

what is the purpose of using a pre defined function

Answer 22

no need to write code
 error free (no need to test)
 re-useable

Question 23

what is a purpose of a data dictionary

Answer 23

a plan of how data will be implemented

Question 24

ASC

Answer 24

ascending order

Question 25

DESC

Answer 25

descending order

Question 26

what is the default order for databases order by

Answer 26

ascending