| 
  • If you are citizen of an European Union member nation, you may not use this service unless you are at least 16 years old.

  • You already know Dokkio is an AI-powered assistant to organize & manage your digital files & messages. Very soon, Dokkio will support Outlook as well as One Drive. Check it out today!

View
 

January  2011

Page history last edited by Ms. R. Singh 9 years, 10 months ago

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 
Microsoft Office 2003 
Ubnutu Linux 
Spanish for beginners 

 

Software Type Letter  Type of Software 
Operating System Software 
Specialized  Software 
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 
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
Touch Terminal    A Printing of large building plans
Joystick    B Marking of multiple choice exams
Optical Mark Reader (OMR)    C Preparing architectural drawings
Magnetic Ink Character Reader (MICR)    D Activating a buzzer when someone enters a server room
Biometric System    E Making a selection by touching parts of the screen
Plotter    F Listening to music on your computer
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:

 

 
Bank  Savings  Checking  Loan  Total   
BD 800  500  125     
DB  12,000  15,000  3,000     
GBTI  5,000  600  200     
RB  15,000  1,250  900     
SB  2,500  1,500  600     
           

 

(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  NS 
ECN 100  Economics 1  SS 
HST 100  History 1  EH 
CSI 400  Computer Science 4  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]

 

 

List1[x]  List2[x]  List1[x]:=List1[x] - List2[x]

 

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 

 

(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.