Answerall Thequestionsinthissectioninthespacesprovided

3.23COMPUTERSTUDIES(451)

3.23.1ComputerStudiesPaper1(451/1)

SECTIONA(40marks)

Answerallthequestionsinthissectioninthespacesprovided.

1Writeeachofthefollowingacronymsinfullasusedincomputing. (2marks)

(a)CAD

(b)DVD

(c)WORM

(d)POS

2Aschoolkeepsstudentrecordsinadatabase.Thedataiscodedbeforeentry.

Statethreereasonswhythecodingisnecessary.(3marks)

3DifferentiatebetweenBccandccinanemail.(2marks)

4Statethreerisksposedbyimpropercablinginacomputerlaboratory. (3marks)

5Listtwocareeropportunitiesdirectlyassociatedwithcomputernetworking. (2marks)

6Aretailerusesaspreadsheetprogramtocalculateprofits.Figure1showsthespreadsheet.

Figure1

(a)Whichrowcontainslabelsonly?(1mark)

(b)WritetheformulathathasbeenenteredincellF2. (2marks)

7Statethreereasonswhyanorganisationmayopttodevelopitsownsoftwarein-houserather

thanbuyoff-the-shelfsoftware.(3marks)

209

Visit for thousands of revision materials

8Thetopologybelowisformedbycombiningtwotypesoftopologies.

Figure2

(a)Giveonenameforthecombinedtopologyinfigure2. (1mark)

(b)Namethetwotopologiesformingthecombinedtopologyinfigure2. (2marks)

stages.

(a)Namethisimplementationstrategy.(1mark)

(b)Givetworeasonswhytheorganisationisoptingtousetheimplementationstrategyin

(a)above.(2marks)

10(a)Explaintheimportanceofdiskpartitioning.(2marks)

(b)Differentiatebetweenpull-downmenuandpop-upmenuasusedinGraphicalUser

Interface(GUI)operatingsystems.(2marks)

communication.However,thesechangeshavebroughtmanychallenges.

Statethreenegativesocialimpactsofthesetechnologies. (3marks)

designingapublication.

(2marks)

13Acomputerisidlebuttheharddisklightisblinking,indicatingsomeactivity.

Statetwopossiblecausesofthis.(2marks)

14Describecompatibilityasafactortoconsiderwhenpurchasingacomputer. (2marks)

15Identifytheappropriateoutputdevicefortheproductionofeachofthefollowing:

(a)receiptswherecarboncopiesarerequired;(1mark)

210

Visit for thousands of revision materials

(b)anarchitecturaldrawingwhereprecisionisrequired;(1mark)

(c)outputwheretheuserisvisuallyimpaired.(1mark)

SECTIONB(60marks)

Answerquestion16andanyotherTHREEquestionsfromthissectioninthespacesprovided.

16(a)Figure3showsaflowchart.Useittoanswerthequestionsthatfollow.

(i)Determinetheoutputfromtheflowchartif:

I.X=5;(2marks)

II.X=7.(2marks)

(ii)WriteaPseudocodefortheflowchartinfigure3. (5marks)

(iii)Modifytheflowchartsothatitcanbeusedtogetthesumofintegersbetween

50and100.(4marks)

(b)Listtwoprogramminglanguagetranslators.(2marks)

211

Visit for thousands of revision materials

17(a)Describethreetypesofvalidationchecksasusedindataprocessing. (6marks)

(b)Acompanyhasoptedtostoreitsemployees’personaldetailsinacomputersystem.

thesedetails.(4marks)

(c)(i)Describeeachofthefollowingdataprocessingmodes:

I.real-time;(2marks)

II.interactive.(2marks)

(ii)Stateanapplicationareawherereal-timedataprocessingmodeisapplied. (1mark)

follow.

Figure4

(a)(i)Definealaptopcomputer.(1mark)

(ii)Thescreenissaidtobe17inches.Explainwhatthismeans. (2marks)

(b)Stateoneadvantageofhavingeachofthefollowingprovidedwithalaptop.

(i)modem......

(ii)USB......

(iii)freesuite......

(3marks)

212

Visit for thousands of revision materials

(c)Statethesoftwarepackageinthefreesuitewhichismostsuitableforeachofthe

following:

(i)computingbudgets......

(ii)creatingdocuments......

(iii)designingofbrochures......

(iv)recordsmanagement......

(4marks)

(d)(i)Statethreeadvantagesofusingacomputertodesignanadvertsuchastheone

inFigure4.(3marks)

(ii)Statetwobenefitsofhavingtheadvertuploadedontheinternet. (2marks)

19Aworkerisunabletotraveltotheofficebutmaystillbeabletodotheofficeworkthrough

telecommuting.

(a)Explainwhytheworkermayuseeachofthefollowing:

(i)email;(2marks)

(ii)fax;(2marks)

(iii)digitalcamera;(2marks)

(iv)firewall.(2marks)

(b)Theworkerneedstomakeregularbackupsofdocumentssenttotheoffice.

Statethreereasonsforthis.(3marks)

(c)Explaintwobenefitsthattheemployerwillgetbyallowingthisworkertodothe

officeworkthroughtelecommuting.(4marks)

20(a)(i)Differentiatebetweenone’scomplementandtwo’scomplementindata

representation.(2marks)

(ii)Explainthepreferenceofbinarynumbersystemsoverdecimalnumbersystems

incomputers.(2marks)

(b)(i)Usingone’scomplement,subtract1000112from0100102. (4marks)

(ii)Convertthenumber21.0312510toitsbinaryequivalent. (5marks)

(c)Performthefollowingbinaryoperations.

1101+11011+101+11111(2marks)

213

Visit for thousands of revision materials

3.23.2ComputerStudiesPaper2(451/2)

1Table1,table2andtable3areextractsofrecordskeptinahealthcentreforpatients,doctors

andconsultationsrespectively.

Table1

Table2

Table3

(a)(i)Usingadatabaseapplicationpackage,createadatabasefilenamed

(ii)CreatethreetablesnamedPATIENTS,DOCTORSandCONSULTATIONSthat

(14marks)

(iii)Settheprimarykeyforeachtable.(3marks)

(iv)Createtherelationshipsamongthetables.(2marks)

214

Visit for thousands of revision materials

(b)(i)Createadataentryformforeachtable.(3marks)

(ii)Enterthedataintable1,table2andtable3intothePatients,Doctorsand

Consultationstablesrespectively.(9marks)

(c)(i)CreateaquerynamedPatientAgetodisplayPatients’Names,GenderandAge

ontheyearofvisit.(4marks)

(ii)CreateaquerynamedBeatricedetailstodisplayPatients’Names,Ailmentand

ConsultationDatesforpatientstreatedbyDoctorBeatrice. (3marks)

(d)(i)CreateareporttodisplaythePatients’Names,ConsultationDates,Ailments

andtheNamesoftheDoctorsconsulted.Therecordsinthereportshouldbe

groupedbyPatients’Namesandthenumberofconsultationsbyeachpatient

shouldbedisplayed.(5marks)

(ii)Titlethereportas“ConsultationsPerPatient”andsaveitasConsultations.

(2marks)

(e)Printthefollowing:

(i)Tables:Patients,doctorsandconsultations;(1mark)

(ii)Queries:PatientAgeandBeatricedetails;(1mark)

(iii)Report:Consultations;(1mark)

(iv)Form:Consultations.(1mark)

2TheFigureonpage5showsthedesignofthecoverpageofabook.Itcomprisesofthefront,

thebackandspaceinbetweenwherebookpageswillbeattached.Useadesktoppublishing

packagetodesignthecoverpageasfollows:

(a)Createanewpublicationnamedbookcoverwiththefollowingpagelayout.

Visit for thousands of revision materials

(i)papersize:A4,

(ii)orientation:landscape,

(iii)margins:3cmor1.18inchesallround.

(4marks)

Visit for thousands of revision materials

(b)EnterthetextandobjectsandformatthemastheyappearintheFigure.Thefrontand

backsectionsofthebookcover,eachmeasures18cm(7.1inches)by12.5cm(4.9

inches)andthespacebetweenthemmeasures1.7cm(0.7inches). (45marks)

(c)Saveandprintthepublication.(1mark)

215

Visit for thousands of revision materials