Hilltop Academy

Cambridge Assessment International Education

CANDIDATE
NAME

CLASS 10

SUBJECT: ICT MIDTERM EXAMINATION Date: June 2023

Time: 1 Hour 30 Minutes

INSTRUCTIONS

1. Answer all questions.

2. Write in dark blue or black pen.
3. You may use an HB pencil for any diagrams, graphs or rough working.
4. Do not use staples, paper clips, glue or correction fluid.

INFORMATION

1. The number of marks for each question or part question is shown in brackets [ ] at the end of
each question.
2. The total mark for this paper is 80.
3. This paper has got 10 pages. Please check.
1 For each of these questions, choose the correct response from the five options given. [10]

a What validation type would make sure a d What validation type checks that the
post code, such as LA21 4NN, was entered correct number of characters has been
in the correct layout? entered?

a Length check a Length check

b Presence check b Presence check
c Range check c Range check
d Format check d Format check
e Type check e Type check

b What validation type would you use to e Data is to be entered in the format
make sure a number entered was > 0 but DDMMYY. Which of the following is NOT a
not > 100? valid date?
a Length check a 230421
b Presence check b 010120
c Range check c 30th May 2024
d Format check d 050505
e Type check e 121221

c What validation type checks that a field in f Which of the following statements is
an online form is not left empty? FALSE?
a Length check a Validation can check that
b Presence check data entered is sensible
c Range check b Validation can check a value
lies between an upper and
d Format check
lower bound
e Type check c Validation can check that a
field in an online form is not
left blank
d Validation is an automatic
check done by a computer
e Validation can check that
the data entered is correct
g Temperatures (which must be in the range i Which of the following is NOT a valid
20 to 80 inclusive) are being input into a method of implementing a new computer
computer. Test data is being used to make system?
sure the validation checks work. Which of a Serial changeover
the following are examples of extreme b Direct changeover
c Parallel running
data?
d Pilot implementation
a 0 and 100 e Phased implementation
b 19 and 81
c 20 and 80 j Which of the following data-gathering
d 21 and 81
methods suffers from the Hawthorne
e −1 and 85
effect?
h What is the name given to data which is a Examining existing documents
outside the limits of acceptability? b Interviewing customers who
use the system
a Normal c Interviewing staff who use the
b Live system
c Extreme d Observing workers doing the
d Abnormal tasks
e Erroneous e Filling in questionnaires

189
2 Carlos is designing a new computer system to replace an existing system.
a Tick four items which will need to be designed. [4]

Tick (✓)

Inputs to the current system.

Data capture forms.

Report layouts.

Limitations of the system.

Observation methods.

Improvements to the system.

User and information requirements.

Validation routines.

Problems with the current system.

File structures.

b Following the implementation of the system, technical documentation needs to be written.

Identify three components of technical documentation which are found in user documentation.[3]
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
3 A farmer has purchased a computerized milking system for her cows. She has asked a systems analyst
to create a database to store details of the cows being milked. Examples of the details of the cows
which will be stored are:
Average_milk_ Animal_passport_
Breed_of_cow Date_of_birth Weight_of_cow
yield number
Holstein 25/02/2017 725.9 24.5 998/2017
Ayrshire 15/03/2016 715.0 20.1 972/2016
Jersey 25/02/2017 732.7 25.0 971/2016
Holstein 10/10/2016 715.0 25.0 765/2016

a Complete the following table by entering the most appropriate data type for each field. For any
numeric field, specify the type of number. [5]

Field Name Data Type

Breed_of_cow

Date_of_birth

Weight_of_cow

Average_milk_yield

Animal_passport_number

190

b State which field would be the most appropriate for the primary key. [1]
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
c A validation check is used when entering the animal passport number into the database.
Name and describe the most appropriate validation check that could be applied to this field. [2]
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________

4 In the table below, by using a tick (✓) indicate whether each component is found in user
documentation only, in technical documentation only or
in both types of documentation. [5]

Description of component Technical documentation (✓) User documentation (✓)

How to sort the data

Hardware requirements

How to load and run the software

Program flowcharts/algorithms

Troubleshooting guide/FAQs

Validation rules/routines

Purpose of the system

Program listing/coding

Glossary of terms

Meaning of error messages

5 Put the following six stages of the systems life cycle into their correct order: [3]
» Analysis __________________________
» Design __________________________
» Development and Testing __________________________
» Documentation __________________________
» Evaluation __________________________
» Implementation __________________________

6 Which five computer terms are being described below? [5]

a. A changeover method where the old system is stopped overnight and the new system is
introduced straight away.
b. A changeover method where the new system is introduced into one branch of a company and its
performance assessed before being introduced in all the company’s branches.
c. Type of validation that checks whether or not the correct number of characters has been entered.
d. Part of the system life cycle that considers data capture forms, file structures, validation and
screen layouts.
e. Software development technique where the program is broken down into smaller parts and each
part is tested separately.

191
7 a Describe what is meant by the evaluation stage in the systems life cycle. [3]
________________________________________________________________________________
________________________________________________________________________________

b Give two reasons why hardware may need to be updated ten years after its initial introduction. [2]
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
c Give two reasons why software may need to be updated ten years after its initial introduction.
_________________________________________________________________________________
_________________________________________________________________________________
_________________________________________________________________________________
______________________________________________________________________________ [2]
8 A program is being written which only accepts numbers in the range 1 to 100 (inclusively) to be input.
Validation routines are being used to check the input data.
a Name two validation routines which could be used to check the input data in this program. Give a
reason for your choice in each case. [2]
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________

b Test data can be normal, abnormal or extreme. Explain the differences in these three types of test
data.
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
________________________________________________________________________________
_____________________________________________________________________________ [3]

c For this program being written, indicate, by ticking the appropriate box, whether the following
input data is normal, abnormal or
extreme. [3]
Normal Abnormal extreme
(✓) (✓) (✓)
52

104

100

twenty-five

99
d Explain what is meant by live data and describe how it is used. [3]

_______________________________________________________________________________
_______________________________________________________________________________
_______________________________________________________________________________
_______________________________________________________________________________

9 Create a folder named sample_page

• Create an html page and save it in your folder as page.html [2]

• Set the title of the page should be Sample Page [1]
• Add a heading 1 tag with the text Welcome to Website Authoring 101 [2]
• Below the heading add an ordered list with 2 list items [4]
o Image Tag
o Bold Text Tag
• Take a screenshot of the sample_page folder, with the columns displaying the image
dimensions, file name, and file sizes. [4]
• Save the screenshot as folder.png [2]
• Below the ordered list tag, create a tag that inserts the folder.png image with the appropriate
alternate text [2]

192