13 marks
A systems analyst has been asked to carry out an analysis of a company’s current computer system.
State three methods of analysing the current system.
Did this page help you?
The Systems Life Cycle (Cambridge (CIE) IGCSE ICT): Exam Questions
1 hour16 questions
24 marks
Tick (✓) whether the following advantages of analysing a system refer to looking at existing paperwork, observation or questionnaires.
Looking at existing paperwork (✓) | Observation (✓) | Questionnaire (✓) | |
|---|---|---|---|
This method gives the systems analyst an overall view of the system | |||
Individuals can remain anonymous | |||
This method allows information to be collected that cannot be obtained from any other method | |||
This method gives the quickest analysis of the data |
Did this page help you?
32 marks
A library system has two tables; one for borrowers and one for books. Extracts from these tables are shown.
Borrower_ID | Borrower_name | Contact_telephone | Contact_email |
|---|---|---|---|
5404 | Susan Stranks | 01632 960321 | |
9867 | Fei Hong Zhao | 07700 900222 |
Borrowers table
Book_ID | ISBN | Name_of_book | Author_of_book | Date_published | Borrower_ID | Date_due_back |
|---|---|---|---|---|---|---|
1 | 0859550153 | Bird of Prey | David James | 1977 | 5404 | 27/10/2021 |
34 | 3301028345 | The Fifth Man | Colin Turner | 1998 | 9324 | 05/10/2021 |
35 | 4237681321 | A View of the Temple | Yu Yan Zhang | 2017 | 8854 | 07/10/2021 |
54 | 4237681321 | A View of the Temple | Yu Yan Zhang | 2017 | 5404 | 27/10/2021 |
Books table
The data type for Contact_telephone has been set as text.
Explain why this field has been set to text rather than integer.
Did this page help you?
42 marks
RockIT Airlines representatives use a computer booking system to book flights for customers.
A representative from the airline types in the customer reference number, the number of passengers, departure time, departure date, departure airport and the destination airport.
A customer is planning to take a flight from London Heathrow Airport. The representative types in a code LHR for London Heathrow Airport. One of the reasons for using a code for the airport is to improve data accuracy.
Describe two other advantages of using a code rather than typing out the full name.
Did this page help you?
13 marks
A student is creating a spreadsheet of airports for a project.
The formula in G2 is:
=VLOOKUP(F2,A2:B9,2,0)
Before the spreadsheet can be used, data needs to be entered to test the spreadsheet.
There are three types of test data: normal, abnormal and extreme.
Explain what is meant by these three types of test data.
Did this page help you?
22 marks
The manager of a cinema has purchased a new booking system. There are 26 rows in the cinema with 20 seats on a row. Each seat is identified by a unique ID. The seat ID consists of the row letter 5 followed by the position of the seat on the row. An example of the seat on row F position 12 would be F12.
He is setting up a test plan to test the system.
Write down one example of each of the following types of test data. The answers must be different in each case.
Normal
Abnormal
Did this page help you?
36 marks
Tawara Tours has created a new online booking system to allow customers to book holidays. The system was written using modules.
Describe how the new system could be tested prior to it becoming operational.
Did this page help you?
44 marks
Rockit Motors recently created a new car sales website. The website uses internet shopping features. Customers can ask questions of the virtual salespeople on the website, and then purchase the car on the website.
Before the website became operational it needed to be tested. The web designer created a test plan including module and whole system testing.
Explain the difference between module and whole system testing.
Did this page help you?
52 marks
A school is planning to change the way it reports back to parents about their child’s academic progress. They plan to produce a mail merged document and then email this to parents.
They have created a spreadsheet which shows the pupil’s name, target, attainment and effort levels for Maths and the Science subjects.
Part of the spreadsheet is shown.
The attainment levels range from 1 to 9 and the effort levels range from 1 to 3. Before teachers are allowed to enter data, the spreadsheet needs to be tested.
Write down one example of extreme data to test the attainment field and one example of abnormal data to test the effort field.
Did this page help you?
64 marks
Tick (✓) the most appropriate method of implementation to match the statements below.
Direct (✓) | Parallel (✓) | Pilot (✓) | |
|---|---|---|---|
All of the benefits are immediate. | |||
If the new system fails the whole of the old system is still operational. | |||
This is the cheapest implementation method. | |||
The system is implemented in one branch of the company. |
Did this page help you?
7a3 marks
The owner of Tawara Hotels is planning a new computerised booking system. There are ten Tawara Hotels throughout the world. The current booking system allows people to book rooms in any of 7 the Tawara Hotels. He has employed a systems analyst to research the current system and then install the new system.
When analysing the current booking system, the systems analyst must identify the user requirements.
Explain why it is important for the systems analyst to do this.
7b4 marks
Tick (✓) the relevant stage of the systems life cycle for each of the following activities.
Activity | Analysis (✓) | Development and testing (✓) | Evaluation (✓) |
|---|---|---|---|
Identifying the problems with the current system | |||
Comparing the solution with the original task requirements | |||
Create the file structure | |||
Identify limitations to the new system and improvements to be made |
Did this page help you?
13 marks
A developer is writing a program to record the results of examinations taken by students in a school.
The program will be tested to make sure that it works.
There are three types of test data that can be used to test a system: normal, abnormal and extreme.
Explain what is meant by normal, abnormal and extreme test data.
Did this page help you?
26 marks
A system can be analysed using different methods.
Discuss the advantages and disadvantages of analysing a system by interviewing staff rather than using questionnaires.
Did this page help you?
36 marks
Different methods can be used to analyse a system.
Discuss the benefits and drawbacks of analysing a system by observing staff rather than looking at the current systems documentation.
Did this page help you?
46 marks
When a system is being planned, analysis needs to take place.
Questionnaires and interviews are examples of methods of researching existing systems.
Evaluate, by weighing up the advantages and disadvantages, each of these methods.
Did this page help you?
56 marks
The owner of Tawara Hotels is planning a new computerised booking system. There are ten Tawara Hotels throughout the world. The current booking system allows people to book rooms in any of 7 the Tawara Hotels. He has employed a systems analyst to research the current system and then install the new system.
Before the new booking system is installed, the systems analyst has to decide on a method of implementation. One method of implementation is pilot running.
Name two other methods of implementation and describe two benefits of each.
Did this page help you?