SECTION 1 - THEORY (60 MARKS)
1. (a) A user interface allows a user to communicate with the computer to get some tasks done
(i) List ONE hardware user interface and give an example of when it is used
Touch screen, used in retail stores
(ii) State TWO types of software user interfaces and indicate which is more suitable for use by someone who is learning to use a computer
Command Line interface
Graphical User Interface (GUI) - suitable for someone who is learning to use a computer
(b) List ONE advantage and ONE disadvantage of real-time processing
Advantage - Data is always up-to-date
Disadvantage - delays can occur if the processor is offline
(c) Match the following applications with the type of software that BEST describes the application
Application No |
Application |
1 |
Microsoft Office 2003 |
2 |
Ubnutu Linux |
3 |
Spanish for beginners |
Software Type Letter |
Type of Software |
A |
Operating System Software |
B |
Specialized Software
|
C |
Integrated application software |
1-C
2-A
3-B
2. (a) (i) If the ASCII code for the letter 'f' is 1100110, find the ASCII code for the letter 'K'. Show all calculations.
- f is in position 6 in the alphabet
- Converting 6 to binary, we get 110 (last 3 digits of the ASCII code)
- K is in position 11 in the alphabet
- Converting 11 to binary we get : 1011
2 11
2 5 R 1
2 2 R 1
2 1 R 0
2 0 R 1
- Replace last 4 bits of the above code with 1011
- ASCII code for K = 1101011
(ii) Convert the binary number 01011110 to hexadecimal
Step 1: convert binary number to decimal
128 |
64 |
32 |
16 |
8 |
4 |
2 |
1 |
0 |
1 |
0 |
1 |
1 |
1 |
1 |
0 |
0+64+0+16+8+4+2+0 = 94
Step 2: convert decimal number to hexadecimal
16 94
16 5 R 14 (E)
16 0 R 5
Answer: 01011110 = 5E
(b) John has an external hard drive with a capacity of 1 terabyte (TB) and Mary has a USB flash drive with a capacity of 16 gigabytes (GB). Calculate how many flash drives of information, similar to Mary's can be accommodated on John's external hard drive.
1 TB = 1024 GB
Therefore if 1 flash drive holds 16 GB
Then, 1 external hard drive can accommodate (1024/16) flash drives OR 64 flash drives
(c) For EACH of the following storage media, indicate whether it is a secondary or primary storage media
(i) Flash Memory Card Secondary
(ii) Random Access Memory Primary
(iii) Programmable Read Only Memory (PROM) Primary
3. Match the following tasks with the BEST device suitable to perform the task.
Device No |
Device |
|
Task Letter |
Task |
1 |
Touch Terminal |
|
A |
Printing of large building plans |
2 |
Joystick |
|
B |
Marking of multiple choice exams |
3 |
Optical Mark Reader (OMR) |
|
C |
Preparing architectural drawings |
4 |
Magnetic Ink Character Reader (MICR) |
|
D |
Activating a buzzer when someone enters a server room |
5 |
Biometric System |
|
E |
Making a selection by touching parts of the screen |
6 |
Plotter |
|
F |
Listening to music on your computer |
7 |
Inkjet Printer |
|
G |
Allowing access to a computer by scanning the iris of your eye |
8 |
Pads and Tablets |
|
H |
Processing of cheques |
9 |
Headphones |
|
I |
Printing colour greeting cards at home |
10 |
Sensors |
|
J |
Used for playing games |
1 - E
2 - J
3 - B
4 - H
5 - G
6 - A
7 - I
8 - C
9 - F
10 - D
4. A computer supplies company has eight technicians who travel to businesses and homes to sell computer supplies and accessories. Each technician has the ability to complete purchase transactions using debit or credit cards at any client's location.
(a) Explain, giving a reason, the type of transaction media that is described above.
Wireless Electronic Funds Transfer (EFT) because the machine can work without being connected to a phone line
(b) Explain what is a 'hotspot' and give ONE disadvantage of having access to a hotspot.
A hotspot is a public place which offers free Wi-Fi access to their customers
Disadvantage: connectivity may be poor or slow if there are many users accessing the Internet at the same time
(c) Name TWO devices that can connect to a Wi-Fi.
Laptops, Tablets, Smart phones
(d) Explain the difference between 'point-to-point' and 'broadcast communication'.
Point-to-point: data goes from one device, to the next, to the next and so on until it reaches the last device, e.g. Bus and Ring
Broadcast Communication: one device (server) is responsible for sending to all devices connected to it, e.g. Star
5. State ONE advantage and ONE disadvantage of EACH of the following scenarios:
(a) Offering automated voice mail where the caller presses a number to be transferred to an extension
ADVANTAGE: the call can be transferred directly to person without going through the operator
DISADVANTAGE: if the extension number is not known, you may be transferred to several departments before being connected to the right person
(b) Working at home or conducting business using a computer to communicate with colleagues and/or clients.
ADVANTAGE: business and communication available 24/7 and can be done at your own pace
DISADVANTAGE: one may be come 'too relaxed' at home and not put in as much work as one should
(c) Using only credit or debit card transactions.
ADVANTAGE: safer since one does not walk with a bulk of cash in his/her wallet
DISADVANTAGE: leads to over-spending
(d) Use of Information Technology and computers in most areas of work.
ADVANTAGE: easy storage of data and retrieval of information
DISADVANTAGE: data can be changed or destroyed if accessed by unauthorized personnel
(e) Using a computer for a long time to complete an urgent task.
ADVANTAGE: applications and the features they come with (editing and formatting tools) allows tasks to be performed in a timely fashion
DISADVANTAGE: eye strain, wrist pain, back pain can develop if breaks are not taken every 30 mins
6. For EACH of the file structures labelled (i) to (v) below, state whether the record arrangement is ordered (O), unordered (U) or, can either be ordered or unordered (OU)
(i) Direct Access File OU
(ii) Indexed-Sequential File O
(iii) Random Access File OU
(iv) Sequential File O
(b) State whether EACH of the following files is temporary or permanent.
(i) Grandfather file Permanent
(ii) Master File Permanent
(iii) Transaction file Temporary
(iv) Transaction log Temporary
SECTION 2 - PRODUCTIVITY TOOLS (15 MARKS)
7. Answer the following questions based on the spreadsheet below:
|
A |
B |
C |
D |
E |
F |
1 |
Bank |
Savings |
Checking |
Loan |
Total |
|
2 |
BD |
800 |
500 |
125 |
|
|
3 |
DB |
12,000 |
15,000 |
3,000 |
|
|
4 |
GBTI |
5,000 |
600 |
200 |
|
|
5 |
RB |
15,000 |
1,250 |
900 |
|
|
6 |
SB |
2,500 |
1,500 |
600 |
|
|
7 |
|
|
|
|
|
|
(a) State the range of cells containing the names of the banks. A2:A6
(b) What data format has been applied to the data with the number of accounts for each bank. Custom
(c) The data in the spreadsheet have been sorted. Indicate the name of the field used for the sort. Bank
(d) Write the function that should be used to find the HIGHEST number of loan accounts in a bank. =MAX(D2:D6)
(e) You are asked to create a pie chart to show the TOTAL number of accounts in EACH bank. Write the TWO ranges of data you would use.
Range 1 - A1:A6 Range 2 - E1:E6
8. A university uses a database with two tables to store information on courses that are being offered by the various faculties. The data in the two tables are given below:
TABLE 1: COURSE
Cid |
Name |
Credits |
Faculty |
MTH 200 |
Mathematics 2 |
3 |
NS |
ECN 100 |
Economics 1 |
4 |
SS |
HST 100 |
History 1 |
6 |
EH |
CSI 400 |
Computer Science 4 |
8 |
NS |
TABLE 2: FACULTY
Faculty |
Dean |
NS |
Tiwari |
SS |
Scott |
EH |
Hussain |
(a) What field in the COURSE table is used to sort the records. Credits
(b) State the primary key in the COURSE table. Cid
(c) The two tables have been joined by a common field. State the name of the Dean of the faculty that is offering the course with Cid = ECN 100. Scott
(d) Write a query to show ALL courses in the NS faculty with MORE than 5 credits
Table Name |
COURSE |
COURSE |
COURSE |
COURSE |
Field Name |
Cid |
Name |
Credits |
Faculty |
Criteria |
|
|
>5 |
"NS" |
(e) In the COURSE table, it is required to insert a calculated field name FEE to compute the fee for EACH course. If the cost per credit is $250, write the formula for the calculated field.
FEE: [COURSE].[Credits] * 250
(f) State the field in the COURSE table that would be MOST appropriate to use to group data when preparing a report. Faculty
SECTION 3 - PROBLEM SOLVING AND PROGRAMMING (45 MARKS)
9. The two arrays below contain four numbers each
List1: 2 4 5 8
List2: 1 3 5 7
(a) Write code in Pascal to declare the array List1 List1: array[1..4] of integer;
(b) Write the contents of the two arrays after execution of the following fragment code:
for x := 1 to 4 do
List1[x] := List1[x] -List2[x]
x |
List1[x] |
List2[x] |
List1[x]:=List1[x] - List2[x] |
1 |
2 |
1 |
1 |
2 |
4 |
3 |
1 |
3 |
5 |
5 |
0 |
4 |
8 |
7 |
1 |
contents of List1: 1 1 0 1
contents of List2: 1 3 5 7
10. A program reads two characters comprising * or # into a 6-index array named TEST. Assuming that the array and all variables are already initialized, write a program fragment to:
(a) Initialize the array.
for x := 1 to 6 do
TEST[x] := ' ',
(b) print the number of stars
for x := 1 to 6 do
begin
if (TEST[x] = '*') then
count := count + 1;
end;
writeln('The number of stars are: ',count);
(c) print the comment "NO" for all characters other than * or # in the array
for x := 1 to 6 do
if (TEST[x] <>'*') OR (TEST[x] <>'#') then
writeln('NO');
11. (a) Copy and complete the trace table below to show the result of the following algorithm:
1 last = 4
2 count = 0
3 While number = 3 to 7 Do
4 While (number <> last ) Do
5 Count = Count + 1
6 End While
7 Output Count
Number |
Count |
3 |
1 |
4 |
1 |
5 |
2 |
6 |
3 |
7 |
4 |
(b) What is the name of the structure form lines 3 to 6? WHILE Loop
12. Explain the difference between EACH if the following pairs of terms:
(a) Low-level and High-level language
Low level language - a language which uses machine code
High level language - a language which uses english-like statements
(b) Looping structure and conditional structure
Looping structure - repeats a series of statements either a fixed number of times (e.g. FOR loop) or an unknown number of times (e.g. WHILE, REPEAT...UNTIL)
Conditional structure - an action that is performed based on the result of a logical test (e.g. IF...THEN....ELSE)
(c) Testing and Debugging
Testing - entering data values to see if the program gives the required output
Debugging - fixing errors in a program
(d) Variable and constant
Variable - a label or name which identifies a piece of data in memory which changes with each run of the program , e.g. num1
Constant - a fixed value assigned to a variable, e.g. pi = 3.142
(e) The symbols = and <>
= equal to
<> NOT equal to
(f) Integer and real values
Integer - whole numbers
Real - values with decimal places
(g) Pseudocode and flowchart
Pseudocode - an algorithm written in english-like statements
Flowchart - a diagrammatic representation of an algorithm using specific symbols.
Comments (0)
You don't have permission to comment on this page.