-
Chapter 1 Types and components of Computer Systems
-
Software
-
May-June 2020 Q1
-
Define the term software
- Software is programs and data
- Programs for controlling the operation of a computer
- Programs for processing of electronic data
- Oxford Textbook pg 1 & 2
-
Types of software
- System software
- Applications software
- Oxford Textbook pg 2
-
CPU
-
May-June 2020 Q3a
-
Describe the CPU including its role
- An item of hardware
- It carries out the instructions of a computer program
- It performs basic arithmetic calculations
- It performs logical operations
- It performs input/output operations of the computer
- It contains the internal storage/control unit
- Oxford Textbook pg 3
-
CLI
-
May-June 2020 Q2
-
Tick for correct statements
- The user has to type in every instruction
- Each instruction has to be typed in correctly
- The user is in direct communication with the computer
- Oxford Textbook pg 5
-
GUI
-
May-June 2020 Q2
-
Tick for correct statements
- The user does not need to learn any of the instructions
- Oxford Textbook pg 5
-
Chapter 2 Input and output devices
-
Direct data entry devices
-
May-June 2020 Q3b
-
Chip reader
- Oxford Textbook pg 17 & 18
-
Bar code reader
- Oxford Textbook pg 19 & 20
-
RFID reader
- Oxford Textbook pg 18
-
Magnetic Ink Character Reader/MICR
- Oxford Textbook pg 18
-
Chapter 7 The Systems Life Cycle
-
Design
-
Testing Strategies
-
May-June 2020 Q4b
- Abnormal or Normal
- Blood Group
- Oxford Textbook pg 83
-
Validation
-
May-June 2020 Q4d
- The age changes every year therefore it will need to be changed regularly; Administration of the database becomes more time consuming
- The age of the donor can be easily and automatically calculated from their date of birth; improving accuracy
- Data only needs to be entered once; reducing errors
- Oxford Textbook pg 81, 82 ,83
-
May-June 2020 Q4e
- Name the most appropriate validation check for the Health_number
- Length check
- Range Check
- Oxford Textbook pg 81
-
Chapter 18 Data Manipulation
-
Data Type
-
May-June 2020 Q4a
- Question 1
- Numeric: Integer/Text: Alphanumeric
- Question 2
- Date/time
- Question 3
- Boolean/logical
- Question 4
- Text/Alphanumeric
- Oxford Textbook pg 174
-
Query
-
May-June 2020 Q4c
- Oxford Textbook pg 178
-
Gender = F AND Blood_group = A OR Blood_group =AB