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