CSCD 101 End of Semester Dec2017RegularFinalv1-1
CSCD 101 End of Semester Dec2017RegularFinalv1-1
CSCD 101 End of Semester Dec2017RegularFinalv1-1
2. A mail merge is most commonly achieved using the following software package(s)
a. spreadsheet and database
b. word-processor and graphics package
c. electronic mail system
d. word-processor and database
3. The manager of a leisure centre wishes to estimate the likely effect on profits of a
decrease in entry price by examining the consequences of estimated increase in the
number of people using the centre. What would be a suitable software package to aid
him with the calculations?
a. an expert system
b. a spreadsheet
c. a presentation graphics package
d. a maths package
SECTION B. ANSWER ANY THREE QUESTIONS IN THIS SECTION. ALL QUESTIONS CARRY EQUAL
MARKS [25MARKS]
B1
Plastic cards with magnetic stripes were commonly used in the banking and credit card
industries in the 1980s. In one type of magnetic stripe system, cards are encoded with the
following information:
Customer account number;
Personal identification number (PIN) held in encrypted form;
Customer’s bank branch identification code;
Customer’s daily cash withdrawal limit.
The data is stored on two separate tracks within the magnetic stripe. One of these tracks is read
only, the other is a read-write track.
i) Identify two other items of data which are likely to be stored on the stripe, and explain why
they are necessary.
iii) State which of the six items of data would be stored on the read only track and which would
be stored on the read-write track.
iv) Describe the processing stages which follow when a card is inserted into a cash dispenser
with the intention of withdrawing some cash.
B2
An expert system attempts to automate the knowledge and reasoning of human expert.
i) Name and describe the functions of the components of an expert system.
ii) Is it important for an expert system to justify its reasoning?
iv) State two differences between an expert system and a human expert.
B3
i) Describe the fetch-execute cycle. Explain the use of internal registers in the fetch process.
ii) Describe what happens when a peripheral device interrupts the processor
iii) Explain why interrupts are allocated different levels of priority
iv) Explain what happens when the cpu is servicing a keyboard interrupt and an interrupt
arrives from the line printer
B4
i) What is a stack?
ii) What is a stack pointer?
iii) With the aid of a clearly labeled diagram which includes a stack pointer, describe how a
previously empty stack would hold these names arriving in the given sequence:
Eyram, Tom, Adzo, Serwaa, Yao, Abena
iv) Show what the stack would then have if three of these names were popped (retrieved)
from it and a further name Kofi added.