Home

Cambridge International AS and A Level - Papers

1. E eredi Le JUBRRERISEEPBISSERERISSSEIJIHSEPISHEERISHEEFISEPFI H PEL EHE HER nini E in RRIPRE 2 rpUcEIEEUERYTREUCREIEEEECEECECGERPERRS PER ERTETEEET EE PEPR FE PE SE EEI TESA SE EEFI EEIE EE H SE E FE FFS E FELN FE EH SE EH FERETE EH HB BS fii Relative addressing he alien OF the wabvoedi n jg edades ipiiBRSRERIERERISOERFERIESERI RSE SSES EE ISERIES E ISEAN Eh SSP PSS Pssst E a TS es es ed ee oe ee ee ee ee ee EE EENE eee REE ee ee EE gE EFI FE F3 FERH Be HEERE ERI FE EE BE SE ld Bee i ii LAELIA SEL TEEL ETEET EI TETT 2 sein se PT oh daz ded cn ood m od com de ol rani ca om dd emt cal m me oon eoa de odo m eme me rd Examiner comment Part 1 A clear description the address of the address of the data value to be used Part ii There is a clear description of the use of the Index register contents The candidate has followed this with a practical application where it might be used which was not asked in this question and so was ignored when marked Part iii The candidate has tried to use the key word relative to formulate an answer but there is no reference to a number of locations from a specific reference point such as the address of the current Instruction Cambridge International AS and A Level Computing 9691 Paper 3 97 Paper 3 88 Example candidate response grade C i Indirect ad
2. Private Sub cmdlogon Click Set variables Dim username Dim password Get data from the logon form and trims H username Trim Forms frmlogin txtusername password Trim Forms frmlogin txtpassword 160 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Open database Set pocsystem CurrentDb Open the table Set poclogin pocsystem OpenRecordset tblLogin dbOpenDynaset Set pocteacher pocsystem OpenRecordset tblteacher dbOpenDynaset Find the username and corresponding password in table if not found output correct error message else erant access poclogin FindFirst username amp username amp If poclogin Fields username username Then If poclogin Fields password password Then Stores a teacher and tutor 1D from open table as variables ID poclogin Fields TeacherID pocteacher FindFirst TeacherID amp ID If pocteacher Fields TeacherID ID Then Tutorgroup pocteacher Fields FormID Clear username and password fields txtusername SetFocus txtusername Text txtpassword SetFocus txtpassword Text DoCmd Close DoCmd OpenForm frmMenu End If Else MsgBox Your Password is Incorrect End If Else MsgBox Your Username is Not Valid End If End Sub Private Sub cmdexit_ClickQ Quit program DoCmd Quit End Sub Cambridge International AS and A Level Computing 9691 161 Paper 4 Computing project
3. Save the record in Buyer Info Table Change the availability of the flat to Sold End Examiner comment There were also flowcharts for new flat editing and deleting modules Cambridge International AS and A Level Computing 9691 151 Paper 4 Computing project Marks awarded Nature of the solution The major objectives of the new system have been adequately summarised but omissions have been made There is a brief outline of a design specification including mock ups of inputs and outputs process model described including a diagram structure diagram dataflow diagram or system flowchart However there is a lack of completeness with omissions from the process model inputs and outputs Data structures have been identified Comments Teacher comment both parties agreed on the set objectives Examiner comment objectives have been agreed a design specification has been developed but the validation could be improved and there is no clear evidence that a response to the design has been obtained and acted upon but there may be inadequate detail A clear set of objectives have been defined and a full design specification is included but there may be some errors or logical inconsistencies for example validation specified may be inadequate or field lengths incorrect There is clear evidence that a response to the design has been obtained from the end user and any comments have been acted upo
4. Search open table for POC entry that contains the values selected in the list boxes pocrecord FindFirst StudentSubjectID amp Val Istname If pocrecord Fields studentsubjectid Val Istname And pocrecord Fields POC ID dateid Then wt IE first record exists then populate the form objects with the corresponding data in the found record and set progress bar to green found True grade pocrecord POC Grade setgrade txtavg SetFocus txtavg pocrecord A verageMark txtcomment SetFocus txtcomment pocrecord Comment lblprogress BackColor vbGreen Else Search open table for POC entry that contains the values selected in the list boxes pocrecord FindNext studentsubjectid amp Val Istname If pocrecord Fields studentsubjectid Val Istname And pocrecord Fields POC ID dateid Then if next record exists then populate the form objects with the corresponding data in the found record and set progress bar to green found True grade pocrecord POC Grade setgrade txtavg SetFocus txtavg pocrecord AverageMark txtcomment SetFocus txtcomment pocrecord Comment Iblprogress BackColor vbGreen Else Tino record found then set found variable to false and set the progress bar to red found False optok Value 1 Iblprogress BackColor vbRed End If End If End Sub ja 162 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Private Sub cmdsave C
5. This is a good example of an answer where some of the candidate s statements are correct but they do not answer the question Question 2 b Describe how an assembler produces machine code from assembly language Mark scheme Labels added to a symbol table Labels are later looked up to determine the actual address Assembler must allocate addresses to labels Mnemonic looked up in opcode table to find operation code Macro instructions used to stand for groups of instructions 1 per max 2 2 candidate response grade A Cradles an Abend coctt e adtyuchorrs z erben 4 d4 L eLbzLbdddcik rnsarincaga eELEELGAZgd LLLIGASGGJG LELELERZGAROGJG3SGQSLIP RReeggd3 b BER BEBE mnernenea Lo pt i e T to iiber tithe er ope 2 beh BRR RGGI bh bee eee hh hmimumudu4 Oe hehe dd DE E FE ANNATA ee ee eS en N ed Se eee Examiner comment The candidate knows that symbolic names are used for memory addresses but does not follow this with a description of how an op code table and symbol table are used during the translation process Example candidate response grade C rberibuBRRPCOARERRGE E FE S Ye ake p AS E EO Ynad Ris n OS Le Me Comet a oe ee Cambridge International AS and A Level Computing 9691 85 Paper 3 86 Examiner comment The candidate knows that machine code consists of 0 and 1 digits only and that machine code is executable code This is not a strong answ
6. as Input INPUT Word Count 0 a LOOP FOR Index 1 TO Length Word IF Word index a THEN Count Count 1 ENDIF ENDLOOE Examiner comment The same layout was adopted for this trace table Note how the candidate annotated the pseudocode to aid correct completion of the trace table Cambridge International AS and A Level Computing 9691 63 Paper 2 Example candidate response grade C Ward Index mw A dE Us Coo m exu P o Il 3 wih lim A i 4 I i fal em Tox RETI D goe L umm h o j m aa ls HY i Examiner comment Although this candidate continued with a well laid out trace table lack of attention to detail produced an incorrect response When checking if a character is a a computer program would not treat A as equivalent to a unless explicitly programmed to do so as is asked for in part b 64 Cambridge International AS and A Level Computing 9691 Paper 2 Example candidate response grade E iH Camplete this trace table for the pseudocode using Ant as input INPUT Word Count 0 LOOP FOR Index 1 TO Length Word IF Word Index a THEN Count Count 1 ENDIF EBHDLOOP mdm LA 3e Ead he ex Word ndex Werd Indax z z 50 1 2 i urs e LLLILLLPI me Examiner comment
7. nature of the problem 3 marks A candidate should not expect the examiners to be familiar with the theory and practice in the area of the chosen system There should be a brief description of the organisation for example firm or business involved and the current methods used in the chosen areas that may form the basis of the project A clear statement of the origins and form of data should be given At this stage the exact scope of the project may not be known and it may lead to the arranging of an interview with the client Example candidate response Bridal Shop System definition Introduction This report presents details of a computer system that was created with aim of calculating cost of services given to customers that visit C Bridal shop and also to keep records of customers and the services they order for Background of the study C Bridal shop designs people that are going to be involved in parties like weddings Whenever the customers report they choose and pay for specific body design services they need in preparation for ceremonies However most of the records of customers are kept by the cashier using manual receipt books hence making it very difficult for the shop administrator manager to access records of sales made In order to calculate money customers must pay for the services they order the cashier uses a calculator to add up the costs of all services the customer received This project is aimed at creating
8. Again not distinguishing A from a shows lack of attention to detail often found with grade E candidates Question 2 b b Raul wants uppercase A to be counted as well as each lower case a Re write line 4 of the pseudocode so that every A is included in the count Cambridge International AS and A Level Computing 9691 65 Paper 2 Mark scheme b IF Word Index a OR Word Index A 1 mark for OR allow lower case or 1 mark for separate decisions correct 2 marks for If Uppercase Word Index A 2 marks for If Lowercase Word Index a must reflect existing pseudocode style 2 Example candidate response grade A b Raul Wants uppercase to be counted as well as each lower caae a Re write line 4 of the pseudocode so that every A Is Inaliided in tine couril aL werd lode s 18 Mech ede 6 de E Examiner comment This was accepted without the brackets around the two conditions Example candidate response grade C b Raul wants uppercase A ta be counted as well amp each lower case s Ra writa line 4 of Ine pseudeced so that every A is included in the count t2 deinieimicidideiRiaimas SEETHER RR RRR ARE ee eee FHEREIBESEHISESEI FHBSEISEIEAEIS FI EL ET REH F3 ER ETETEHRTRS PHI Examiner comment A lot of candidates failed to separate the two conditions out even though they had done so in e Example candidate respons
9. Sms UNIVERSITY of CAMBRIDGE 8 International Examinations Example Candidate Responses Standards Booklet Cambridge International AS and A Level Computing 9691 Cambridge Advanced University of Cambridge International Examinations retains the copyright on all its publications Registered Centres are permitted to copy material from this booklet for their own internal use However we cannot give permission to Centres to photocopy any material that is acknowledged to a third party even for internal use within a Centre University of Cambridge International Examinations 2011 Cambridge International AS and A Level Computing 9691 Contents MUO d ege TNR 2 Assessment at a glance ssssssssssssss He ee eme nennen nenne nne nnn nn nne ener nnne ia fe 2 aoe peng EPTPTI s 4 gig PTT E 44 wg OETORPPEN gt Paper 4 COMPUTING DIOIBOL usa sei d sakik Ed mpACh Fl kr od PE Pd pe Erb Reve bU PA EE QUK kl tee d gU Kb ni 129 Cambridge International AS and A Level Computing 9691 Introduction Introduction The main aim of this booklet is to exemplify standards for those teaching Cambridge International AS and A Level Computing 9691 and to show how different levels of candidates performance relate to the subject s curriculum and assessment objectives In this booklet a range of ca
10. igre PSP Ps ep oll Dn Bee LL EI Ee md a b A Pe eee ee ee TI ke Bel s m ami mm ee ee m s u mm bu mu a n cm m oe es De BB fae oll og TOFT rr ry ET Ee Siu eri dea du d acheabeer te AB E Jf eo a ak edle fur oti 00 hearer or pn lsrbriserbrii rinie rbin inni ai A LEN a a doni iia idea me mea ma ea cm a cn nona rie in a cog rb mm aca pepper gout pepe cole 7 Date captured wy seier ore n ag fo YE Bas Hag Hie Eee Jeuptedurez f racer ac c Give one other example of a rasl time application Justify why your cholce le s real time application PP ee Be ee eee REIN Example Lownolliing a vwazlebw Bri Aro cl e Justification Dia collated fema petor sbsuld bt prmcerted et sl aud ACUTO AERO quen Jo cd EI TUTUIPmMEPRTPTTTEKRT Tm m Es Ss eee FTT ee G GT disashous erhuedrev 2 oa ie ot one eeiabe monas wcnom a oom gs o ee eg em eo am se ee ee eg oe ug ee a a p p a Cambridge International AS and A Level Computing 9691 Paper 3 Examiner comment Part a is a bookwork definition which has been reproduced Part b An excellent answer which clearly describes the key role of the processor at the centre of receiving data from the sensor s and then when required sending signals to an actuator Part c This is a commonly quoted application which uses real time processing and well explained Example candidate response grade C a State wihal
11. length check explanation format check explanation Max 2 marks 2 NOT presence check 50 Cambridge International AS and A Level Computing 9691 Paper 2 Example candidate response grade A State what la maant by validation aL ade men ER anis d cba e Eae DOR enia Aet md c oe er mM uus Un i Describe two dierent validation checks Ihat can b performed on the ExpecledCompletionGate fald i Manga Ea cul hc alles mm el t el pi SER WE ee crt a PS bes ae a cee aT eT a a T E et an Peel recen ses tal exl y Pom m Examiner comment This candidate has re used the words of the question in the first part but given 2 good answers in the second part clear and accurate Example candidate response grade C ui THER ran IRE Ur oe ih MB On Bie rudes Mert a an eeerther ae aba ie Vailel ot dread uiae ET M Describe two different validation checks ihat can be performed on the ExpactedcampletientDate field beers DESEE C Tali Vi Lee bles nales Seelen nexa ker bat rect fumer UR eate cum s d va pt ae A ere asas Lm E e n RE a ihe sects yi Vecdler he x AER gta he ee gror Messac Examiner comment The answer to the first part is not well expressed but enough for a mark Although length check is a type of validation check the explanation given shows little understanding of what a length check is Cambridge International AS and A Level Comput
12. o earlier om a aL cuu i Em i s Emp qa m cr exi s peor RS E ndun ie rin es ed ed mia td Re ee i ee ee cmd cuan ikai sion s bm a nn ri E ba h n ja h jog e aena Eee Ce i ed ee ritiene Eb EFI ee ee ee ee ee eee i When the member file ls accessed using hashing castes aan ooour sata What ia meant Ey a clash and how it can be dealt wath me PERNE whith Iu tai uet a te 0 e Examiner comment There was no mention of a hashing algorithm with the candidate repeating the words of the question The idea of why clashes occur was clearly not understood Question 5 a Describe the purpose of each of the following parts of a processor i Control unit ii Memory unit iii ALU 24 Cambridge International AS and A Level Computing 9691 Paper 1 Mark scheme i ii Manages the execution of instructions Fetches each instruction in turn Decodes and synchronises its execution by sending control signals to other parts of processor 2 Stores program in current use Stores data in current use Stores parts of OS in current use 2 Carries out arithmetic operations Carries out comparisons Acts as gateway in and out of processor 1 per max 2 per dotty max 6 2 Example candidate response grade A il tii i AL Contre unit Ee E ST L ge drzed 1 whak she ca en e edehua teuei tnd dena TAMA Eg Bay Hai ase ad he T d a dt abit sla attain
13. 106 Example candidate response grade E i a two s complement binary number Ahala Ak is tthe agate ingo eh Ate inde RUE welch sd capplad Sat aya s Lu ND eon ph 1 H a sign and magnitude binary numbm Sis alao mao Ue uh ATE i lps Vas rans Des beth ISEIHHSEPIBEISERPIBEISEISSERIn REIS SEIUERIS ee Cbd Pee ee eee E bubus aibi Reb pnm Examiner comment A grade E candidate might struggle with the conversion of two s complement numbers for ii Note this candidate has completely misread the question were they confused by the term data dictionary and has given an explanation not performed the conversions The BCD conversion is more straightforward but we can only assume the candidate has again completely misunderstood what is required Question 8 a i Explain the difference between static and dynamic implementation of data structures ii Give one advantage and one disadvantage of storing a queue in an array rather than in a linked list Mark scheme i A dynamic data structure changes size A static data structure has the same size dynamic data structure matches size to data requirements static data structure takes no account of data requirements dynamic data structure takes memory from heap as required static data structure is predefined at compile time 2 ii Advantage Array is of fixed size which simplifies algorithms or by example e g retrieval of
14. 500 valid data within acceptable range normal 1 valid data lower boundary included extreme 1000 valid data upper boundary included extreme 1 invalid data below boundary 1001 invalid data above boundary 1 mark per data item 1 mark per matching reason 8 Example candidate response grade A Jab valie Rpzsorn Examiner comment This candidate chose four different types of test data and could also have given Boundary value as the reason for choosing 1000 In questions about test data it is very important to consider different types of test and not give data that essentially test the same thing Cambridge International AS and A Level Computing 9691 Paper 2 Example candidate response grade C a 6a nua enu Examiner comment An answer to test fractions was not accepted as it is not normally possible to enter fractions The last entry in this answer was the same type as the one above it Grade C candidates often found it difficult to select data values that tested for valid and invalid JobIDs Example candidate response grade E Examiner comment The quesiton required the candidate to specify data values that could be entered to test that the validation check worked accurately Grade E candidates often found this difficult Cambridge International AS and A Level Computing 9691 55 Paper 2 Question 2 a i Raul wants to write a program that will count the number of
15. Examiner comment This candidate also continued the format of entering each changed value in a new row of the trace table This clearly helped the candidate as they could show which line of the pseudocode was being followed Example candidate response grade E a i Complete the trace table for this pseudocode using banana as Input Tha first seven rows have been filled in 60 Cambridge International AS and A Level Computing 9691 Paper 2 Examiner comment Grade E candidates often showed evidence that they had not enough understanding of dry running of code setting out the trace table by entering each new value in a new row was intended to aid the candidate to see easily the result from each line of pseudocode Question 2 a ii ii Complete this trace table for the pseudocode using Ant as input 1 Z 3 S 6 q 8 INPUT Word Count LOOP FOR Index e 1 TO length Word IF Word Index a THEN Counc Count l ENDIF ENDLOOP Cambridge International AS and A Level Computing 9691 61 Paper 2 Mark scheme ii Lem Le Wordnded _ Wordinder Maiar 1 mark for correct Count column 1 mark for correct VVord Index a column need false only once after A 1 mark for Index column and Wora Index column correct I3 62 Cambridge International AS and A Level Computing 9691 Paper 2 Example candidate response grade A iH Complete this trace table for the pseudocode using Ant
16. Grading system used to grade students progress between terms Praise OK amp Concern Query A method of displaying specified fields in a database system using selected parameters Record A data structure which is used to organize data within Report A formatted and organized presentation of data which can be printed Software A collection of functions and procedures required to utilize the computer Index s m 127 ON VOU TI TEXT RN Umm 125 126 aaae le NNNM NRCKRRRKERE A 126 fcc MT 127 zl 125 PS SV Le O PRENNE m 122 126 1 EE 123 124 125 POC SS ossi sotosceni ee I eI E VIRES cate sence IU oM amet GaU secre centered t UTMTU EUG UU 122 123 124 125 nd 124 127 OL MNORRRTKCK 126 User Man al assesseer E E EE E rN 121 Geer r TR 122 126 Marks awarded 1 User documentation 5 7 6 marks OOOO OST Comments An incomplete guide perhaps with no screen displays Some options briefly described but difficult for the user to follow Tea
17. Xe and 02S aee aote een BE e end Advantage M GONNA ERR x xui ION ECH GE GUN REGEL O3 CH CH UG COR QU G0 HOO CH RS NUN GS e S N mm a ROGO NOE SUN A FR GS RC OR f Gia n n PEPEE EOS CR ee 83 UHR UO ORC OH GS QE ER ea om me ROG ROM NON om n Po nca m n Bon m n n ga m E mog mm me m acm om gnome EOE Examiner comment There was some confusion here about how bits are transmitted Bit and byte were also confused The candidate s answers showed very little depth of understanding e g it is very fast in part ii presumably referring to data transfer rate The candidate has the general idea but has difficulty explaining it without resorting to vague statements like the one above 20 Cambridge International AS and A Level Computing 9691 Paper 1 Question 8 c The following bytes were received during a data transmission 01101101 10101010 10111101 10110001 Parity is being used as an error check State which one of the bytes has been corrupted Explain why you chose the one that you did Mark scheme 01101101 First byte he other three all have an even number of ones even parity his byte has an odd number of ones 3 Second and third marks depend on first mark Example candidate response grade A Comupledbyie 601 e l Reason H las ma dr ht ON a O Dans tr iei Das siis 2a lation sind BAT AD Gr celere ESETT s a dea minata T Examiner comment daB EEIISERII ERBISSERI
18. al tate t dicted 2 M The unit ntc Aa eceprapht ws er dou ROTORS Fact Wry f lipoi idat meld troda m dL mart ie all ava mm Bite are Se zi Examiner comment In part i the answer went way beyond what was necessary for full marks They referred to the fetch cycle execution of decoded instructions reference to clock etc More than enough for full marks In part ii the candidate clearly understood that data and instructions currently in use are stored in the memory unit This reference to currently in use distinguished grade A candidates from the grade C candidates as seen in the example below The third part was also clearly laid out the ALU performs logical and arithmetic operations is very clear and unambiguous Lower ability candidates tend to refer to doing some arithmetic and making logical decisions which indicates a lack of understanding of how the ALU works Cambridge International AS and A Level Computing 9691 25 Paper 1 Example candidate response grade C I Control unit Sendo unit dati Ha sctvity de mol al JM sprer Jacha lag AM pronase te Edi X lath a pm t iR arem ii ALL Be acute or TE deca Ungli croc af talalta Pana p tag song Mee PRE pe eS eee Be ee ee ees eds bien p be es ed eile eel od ie ede Lele ee RE med pr Examiner comment The candidate uses all the right words in part i i e fetch decode and execute but doesn t really know how they
19. decur elg re X Ce bre eal Jn der A nus iia M UEA Com cedex Examiner comment The candidate knew that characters were found on a standard keyboard and that the computer recognised these characters However there was very little idea of how these characters could be represented in a computer Some vague reference to binary and a mention of 1s and Os was made but ther was clearly not enough understanding to gain many marks Question 3 b Explain the representation of integers in a computer Mark scheme Bits are used to store the correct binary representation of the integer Leading zeroes included to complete required number of bits Standard number of bits irrespective of size of integer Concept of short and long integer dependent on sizes of integers wo s complement used to represent negative numbers 1 per max 3 3 Cambridge International AS and A Level Computing 9691 17 Paper 1 18 Example candidate response grade A EEA aholi cients edic a ont iaceo hes be dene Flac ac duges 2 byte Cchark tateerer Bab A ule fol AGORA a PASEDES QB pe OTS SaS SECS a a Ts ails ssa HEMI they nulel pe uncdendmoed Def he SY SEC no fer Xapaple the natabert amp caulal he NIE ag mm follows 27 36 55 y 37 ra ge fay Gf 321 6 e j m D lO amp 7 4 oco soro 18 e Representing fie mach Pe rede aE binary aligns whic nre created by hina
20. ii Import data does not score the mark is for delete data but the candidate did not say from the database table Question 7 Part of the information stored in the data dictionary describes the type of data which is being stored A particular piece of data is 10010110 otate what the data stands for if the data dictionary describes it as i a two s complement binary number ii a sign and magnitude binary number iii binary coded decimal number Mark scheme i 106 1 ii 2211 iii 96 1 per digit 2 Cambridge International AS and A Level Computing 9691 103 Paper 3 Example candidate response grade A Tl 2 two s comings ant hinam number Ge ee E 6 Dn 4 Q4 10 a iB WOU a hk ks EE Bi idei ii i ka ks mw edd Ak Rall a oak dmm m esis a Rm m I CR RR mn i P RS AL We number 104 eens jt a sign jn and ma jt e binary number pum g n 4 014 ids Ce ee ee ma a e mk ee mi e f j p han sg on h on men s i e i i e fe psh on sian mon m fe pom m f g sihan spon mom ee SSS SS Peer i e oan SSS EPSP PPr pu PP Pe Pe ee Pe ee Pn Pe ee clt Kb Mab 4L T Ii amp pinat coded gecimal number all E oA ce NA 2 MS acram UM Beh eii T iioi di ioi al al es i Be Ree ie feii aion ok a meds ect si on od mee se a Examiner comment A grade A candidate should have no problems with these number conversions Note for all three parts of the question the candidate has shown some working
21. in A delis fa Macc ursa Y E i EE M a NR a ee Pe NEE NEA d eet ee fer ee ee ee ee ee et te 2 PPPOE ee Bed de ee ee hh ee ee S 0S RRS SE PEPE EE T bc Bee i EiT r E Examiner comment The candidate had some idea about time sharing and that the user was given a time slot However they didn t understand how it is actually done using flags polling priorities etc 42 Cambridge International AS and A Level Computing 9691 Example candidate response grade E ues Cems Mog a py Eeer i o da e ded Ur cid MOURI tei eee eee eee rE ERRERA HEEE 0 ee ee eee ee EM EINECMME massa casa iceman OTN Examiner comment Candidates at this level often thought this question referred to networks and gave answers which described servers sharing of resources and so on Cambridge International AS and A Level Computing 9691 Paper 1 43 Paper 2 44 Paper 2 Question 1 a Ahmed a designer stores the following details of each job that he does in a file e job ID a whole number between 1 and 1000 inclusive e job description e price greater than 10 and not more than 5000 e expected completion date e paid yes no a Complete the following table Field Name Data Type Size of Field bytes ee Mark scheme Field Name Data Type Size of Field bytes JobDescription String alphanumeric text alohanumeric text P2080 50 Price Currency integer real deci
22. lj Sara beer bile st a bale ere ipod ane adler cafe dues Te Riese bh f en aa A sessanta catt Advantage Uk Mc redeo edie cade pening ova deas e eae alb mde g menda ap i Parallel AS bib ob Met de ch m eres aane airal ves nales ert Advantage Sete aer gedvp dede geni de geile 4 lE s us Sud MED acra Ec ERE ceni ec UM Examiner comment In part i the explanation of serial was unambiguous and the advantage given was very clear In part ii the explanation and advantage were again very clear the candidate not only correctly mentioned faster transmission but also said why Cambridge International AS and A Level Computing 9691 cry Paper 1 Example candidate response grade C Serial Le Aaa daas m Ale t D Jia B PA a dn Advantage Thee a las a ONDE UR mae f 1 aos o Ls es pesade ba Man hecha Mo od Pale AN Duo ede ant And m Ma n kid db odd nds om omo Re ioca cn ein op gm paci m in d ca Examiner comment The candidate has clearly confused bytes with bits in both parts This makes their answer effectively incorrect Although in part ii the candidate seemed to be aware that parallel data transmission is faster than serial data transmission Example candidate response grade E Seis Vni cle s Seril peur iw SION ncs oc diee tc ee and onkd noe Advantage exter L8 eL acid Qd oa Brie fm me aaa tn eee Niner idaaka As senl Mex
23. 1 Ascending Cambridge International AS and A Level Computing 9691 Size AGO Paper 4 Computing project T8 Paper 4 Computing project Table Relationships lll Queries qryPOCReport Averac thiStudentSubje tbPOC Seer Sa ieee een oe E REE ee ee e o udo lx ll ud 1 d A eut s T a yee ee l 158 Cambridge International AS and A Level Computing 9691 Name StudentID tblStudent FirstName tblStudent LastName tblStudent FormID StudentSubjectID POC ID TeacherID Expr1007 POC Grade AverageMark Comment Title SubjectName Date FormGroup tbiTeacher LastName Level tblTeacher FirstName tblTeacher FormID Data Source QryPOCReport Fatjec famed e ipaa eje p he wem iubeciName Tj Ll ie eacha L AverhgeMakk POC Deadll Level Commen Type Size Long Integer Text Text Long Integer Long Integer Long Integer Long Integer Long Integer Text Update Query Text Text Text Date Time Text Text Text Text Long Integer Paper 4 Computing project ul ul DA 5o0oco UT e imo on Cambridge International AS and A Level Computing 9691 159 Paper 4 Computing project ii Programming Frmlogin i CIE A Leveltomputin 4 i Pod Report System nee BE Prvlogin Form o Private Sub form_loadQ Reset variables Tutorgroup 0 ID 0 End Sub
24. 203 32a JinDong Rd 75 10000 750000 sod Xxxx XX X XXXXX XXXX XX XXXXXXX XX XXXX XXXX XXX There are only two Statuses Primary key p Foreign keys Sold and Available The button can close the frame Flat Records shows all the information of flats including sold and available ones This frame is aim to show a history of transaction in the agency and link all flats with their certain supplier and buyers Due to length of records all data are represented ona text area which is not editable Examiner comment There were also outputs for suppliers and buyers Cambridge International AS and A Level Computing 9691 Data Flow Diagram supplier Add new flat Sell flats Flat Management system Sell flats View Records F ile Management Real Estate Agency Supplier Supplier upplier Info Table Records 1 supplier Supplier Data Suppli Supplier Data 1 0 New Record 2 0 Updates changes Buyer Data Buyer ID and Sold for availability Selling Buyer Data a Buyer ID Buyer Info Table Show Records Records Supplier er ID Show Flat Flat Information Records and supplier ID Flat Records Flat Info Table Flat Data Updates changes Flat data Flat information Deletion Flat Information Buyer Records Buyer f 6 Records Show Records Buyer Cambridge In
25. 4 Computing project Control ActiveX control Button be entered Button Button Variables Form function isn t re launched when the link is Variable 7 needed again in the future Complete FrmInput Makes sure no actions are taken before the Stores the link to the photo so the LaunchCD AH save process is complete OfferDB Opens the corresponding database OpenTable DAO FrmInput Used to open the table in which data needs to Recordset be saved Identifier FrmInput Dateldentifier Compare Compare Compare3 so no records are duplicated a so no records are duplicated IDPlant Integer FrmInput Stores the plant ID for it to be saved in tbitem at the end of the procedure Price Currency FrmInput Stores the price for it to be saved in tbitem at the end of the procedure IDOffer Stores the offer ID for it to be saved in tbitem at the end of the procedure IDRoot Integer FrmInput Stores the root ID for it to be saved in tbitem at the end of the procedure IDHeight Stores the height ID for it to be saved in tbitem at the end of the procedure IDCirc Stores the circumference ID for it to saved in tbitem at the end of the procedure Notes Stores the notes value for it to be saved in tbitem at the end of the procedure Photo Stores the photo link for it to be saved in tbitem at the end of the procedure Cambridge International AS and A Level Computing 9691 ee
26. L GERE ALETA z Fon 3 d aint don be poli 444 IU bid Boa re Sup hE ALORA ERLIE TI fe pow a BBE ERE ASI ETTET Ee eee E Hi LBMEBRIERMHSEREERIREIJIERIBPIRE IIERISESSESSHERG IRESERASGRESELIGSERISERRIGSLISLDINSERINAISERMIJERIJESSEISERIZEILGUEREZGE PLISTI E p ARLE EPE Epu pe ee 1 D eni Lachm beue htm la cite CUL ex ca Aes IB eee Peet EH BSS Sees ele ee E Pe ope aa a E IIHETENLIZELFENLLG UEHEE3E JORG ee 38EPRHEJHJERGENRGE ee a if i adl y an CM eee a eur de La pin fimi fae ed aetna fe a nd bad ba bd ed dd od BENS DLA E ELEN ENA ENNS EI ee ed E E G S S EISE SEN AEI SE LAE ELA D EE GERE NER 2 aas miii HP iuri E BS ee 22 Pe eS EN See E FI EH Bae FI Rp RENEE GELI EEES EH E ee E Epp E 2 Sl Se l Examiner comment This question is knowledge recall only and this is a weak answer The statement about errors being difficult to locate for a compiler is weak a stronger answer would have been that an interpreter provides for better diagnostic features with an explanation Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate response grade E wlth lakerede i ode m Hes gla euet i is T WM pantari adios dana Jes ron Senda n n T Examiner comment A weak answer the description of an interpreter is good and follows on stating how it is different from a compiler Well constructed sentences Question 11 b When a program is run the processor uses special purpose
27. Level Computing 9691 69 Paper 2 iii characters are compared in turn from left hand side start of each word until two characters are different the lower code value determines the first word if 2 words are the same when one ends this is the first word 4 Example candidate response grade A i What fam doas an ASCI code take T Weed aae SE fac Ye x oW 1 ii Describa how ASCI codes cam be used to arrange two lover case barters in ainhahelinal oder pE bum eg MOCI pales of Me s i compara ALL pae rem pp ram pr d less Chan Hos Dhar thor character ae put Corse 2 HE RES wer eter 2 4 45622 hagler t Ter Alay pharti um Lhovattere Clecisje Bec A a hak on Bodlu C heratterd Chara E i MINE Xn M ara rir 2 y ral T Z thendr of A ECHO em 2th sual in at ghe y J rm t uu WE lo m iz oie T a TEUUPEN SE ASET princ E E pare HI a de i Eee Jai E Hu Mt de f Fisk Tc WS CT bitie one Nn n na mart cheraiter de 5 compared ayn t bo th Lua elt have fle tharat bere te be Compared 70 Cambridge International AS and A Level Computing 9691 Paper 2 Examiner comment A very detailed explanation This candidate is perhaps the only one who realised that something happened in iii when one word finished before the other This candidate doesn t say what to do then but it is one of the most comprehensive answ
28. PADELLA xo te heh 18 Examiner comment Well presented answer The candidate could have given some of the detail of cabling but did not and instead went on to describe other transmission media A grade C candidate should be able to score well on an open ended question like this 92 Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate response grade E UTP is te ene viie xn dovest LAMB s ALCP su i len 2 673 4s ilte TE bel shialled aud ite gi A Ake EITA acs NT TT m PRSE A WU UP TNI S MERE E Coniak oati quan BEC ANE AEG aus aec suc EUN RUIN fiber alic ac eiit ga AK eb a nd Ja E aeta 1 E 2 Rec 3 E erar E MERE AELE ee pm f mom pi m n id iem alos bi Red RO Rol D AERA EIL RAPERE AG MR rm mir pa mj mg piapa ed el 8 bJ ELA LE Be ia EIEE i ETETE em om oe SPERIBIBERSERZSEGRISRSERAGERINGZEIRINRGEINTFTISITITETIPIUI ERU eg npe ee nmm PG ell Mal SMG OM ON OE Be ELT Ene a ee none n en n ee ee ed ee en ee T P Po rr rr 08 More adbdRRARARENIEFEFTIUHET IPITTES emery pes emma oll Mc Re Mal SMR Reh GSO OL Se ee og oe ees erm mog pen pepan mea com m don Ge ls Ro eel all Pec IBI GE ee HON ee EDN RS ee es Rond mc iom Rc Rod Red SR ROC 0 RS GS FS ROB ES OG RUE ese ee HIGH RW HE MM RcN RU a MIN RUOR Rem miaconm om om Er a SR Rc B cR Bol ao Rc RR RR an RR T 0 pepe ie om inim mn mi el DRE RGRR SR US MS OSB OM em eee e mh rem mami macie BS ee
29. Paper 4 Computing project 178 Tables Table Name Table Use Tblitem Acts as a central table that links all other tables together to make the database normalized Tbloffer Links the date ID and supplier ID to prevent data duplication Tblsupplier Assigns a unique ID to each supplier to prevent data duplication Tbldate Assigns a unique ID to each date to prevent data duplication Tblplant Links the family name ID species name ID and variety to prevent data duplication duplication duplication prevent data duplication duplication Tolheight Assigns a unique ID to each height range value to prevent data duplication Tbleirc Assigns a unique ID to each circumference range value to prevent data duplication Tblitem Field Name Autonumber Assigns a unique ID to each record Offer ID Number Integer Links to tbloffer Plant ID Number Integer Links to tblplant g L Stores the note s entered tores the price offered Tbloffer Field Name Supplier combination Supplier_ID Tblisupplier Field Name Supplier ID Assigns a unique ID to each supplier Supplier Name Stores the supplier name Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Tbldate Field Name Assigns a unique ID to each Date Stores the date value Tblplant Field Name species variety combination Text Stores the variet Field Nam
30. a computer system that will be used by the cashier to record down all services rendered to customers and also to automatically calculate cost of the services the customers received It will also issue a receipt to a customer PROBLEM STATEMENT Whenever the customers visit the shop they choose specific services they need In order to calculate money customers must pay for the rendered services the cashier uses a calculator to add up the total cost of all services the customer received and also the cashier writes down customer payments and orders in a paper receipt book At the end of the day in case the shop administrator manager wants to review sales made per a day he refers to the receipt book while opening all receipt sheets in the receipt book The problem with this system is that it makes it very difficult and slow for the manager to search for records Another problem with using the calculator is that the cashier gets so tired while pressing calculator all the time and in situations where customers are so many the cashier ends up making mistakes in the figures he presses leading to inaccurate charges of customer orders hence there was need of introducing a good system that calculates customer order charges accurately keeps records efficiently for quick access and keeps records safely Cambridge International AS and A Level Computing 9691 133 Paper 4 Computing project 134 Marks awarded i Definition nature of the prob
31. all link in together Part ii referred to RAM and that data is held here temporarily No real mention that data currently in use is stored here 26 Cambridge International AS and A Level Computing 9691 Paper 1 Example candidate response grade C i n iti Control unir Till coe ears nias aa LORI PLUS A Hn omae omm be Ie in i i ee e OETA chars ems p Bel auc me u s A d REPE C us ct lem ri em red en Fa ullen ee et LONE NE NN NETT NUT RR Memory unit dll ccn RE el park ni dea proce has 0 alae s orca Hades ur ML LC i snis dn argiu LAR Mackan aek s Aahas A es oe oe a i CC Re t be Barra ade S rerea E ALU Mat Pi inae mcn UA e dta s eel ANL P M uda ie EL ib s Dn rt omi ris n LES a lm i en eee en PE Ba dere oak sm oai e Biagi time ashe riot luti quaa E 2 Examiner comment Part i was not really describing the control unit Part ii did not mention that data and instructions currently In use are stored here he third part was sketchy with the candidate describing the ALU as adding numbers and making logical decisions The only part which was awarded a mark was the reference to the ALU acting as a gateway Candidates at grade C tended to know the terms but were unclear of how it all interlinked and produced very vague often incorrect answers to questions of this type Cambridge International AS and A Level Computing 9691 27 Paper 1 28 Examp
32. anle Yom Aa onu C ado Program code is lo be produced fron the paeydocode ii State one other fediune that could be introduced to make the program code easy in understand IM risp AELE Mens cns pes aun Led Mara AX Suec cs be EOM IG uncheck osse DII ili State two ressons why itis important for the program to De egsiy understood RamsOn d ernier FO ake Caachi oooh ca Mappe Rosson 2 Augu dakan se be ensexed B NS cree 2 STILL i EN me mm mm gm em mm io s Examiner comment The first feature is acceptable as no explanation was required However terminology needs to be quoted correctly Indentation although minor spelling errors are acceptable unless they change the meaning The answer in iii repeats the words in the question Question 2 d Each letter in the alphabet has an ASCII code i What form does an ASCII code take ii Describe how ASCII codes can be used to arrange two lower case letters in alphabetical order iii Describe how two words lower case letters only can be arranged in alphabetical order Mark scheme i numeric binary code where each character has a unique value 1 ii letters a z have increasing ASCII codes Each character s ASCII value is compared the character with the smaller value is the first character the character with the larger value is the second character letters are sorted 3 Cambridge International AS and A
33. by a user ID multi tasking Provides security for user files user profiles 1 per max 2 2 candidate response grade A o ud Ed p m Ate s s processo t taa ud eitis an cee ree LEA Quer AT ese ac OVA plar 2 Examiner comment The answer was very clearly laid out using bullet points The candidate clearly understood what was meant by single user OS 40 Cambridge International AS and A Level Computing 9691 Paper 1 Example candidate response grade C Als sd ns Rand clang came Atty ad od Liu cae ape ade apraka sinc Mt Wrth aa nt dis deg a anion 4 peas de Es Fe cmm un at fes al ay poxm T cC Examiner comment A very general answer was given in this example response Key words were missing from the answer e g only one user can work on it the candidate omitted the key phrase at a time Some aspects such as multitasking were mentioned by the better grade C candidates Example candidate response grade E 48 ipae uae i Se Lm y ml e erie mc ac ure le T LE Els zd i ths T snp otek fa eeler Tiere are Peat hat ba Peat LA uses 145 Con aule lin UB Ra RI Lr dala Tener cr cm re re m E e m E T D Examiner comment This candidate knew this probably referred to one user but did not quite show any real grasp of the topics and consequently their explanation lacked sufficient depth to gain marks Question 9 b Explain how a multi user operating system allow
34. causes Press Ctrl Alt Delete and select task manager to end the task The system can then be restarted Press Ctrl Alt Delete and select task manager to end the task The system can then be restarted Program Stops Responding Various possible causes Back up Routine The IT department will be in charge of performing daily backups within the two week period when POCs must be filled out to ensure all data is up to date and secure An updated copy is always held on the server which all teacher have access to Every term a backup is made on the school database to store all term POCS in addition to a yearly backup of the POCs finished that year on a CD that is storage in a separate location Two hard copies are printed for each student one to be stored in the student files and one for the tutors use during parent teacher conferences Finally it is recommended that teachers keep a copy of the system on a usb key or other external storage device 186 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Glossary Default Settings or values set up when a program is set up Form A graphical interface allowing a user to control components and make use of displayed objects Hardware A peripheral device that is used with a computer to enable or simplify its operation List Box A box used to select data from can contain a scroll bar if it contains larger amounts of data POCs
35. data Array controls the maximum size of the queue Disadvantage Queue held in an array cannot expand beyond the size of the array If queue is small then memory space is wasted 2 Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate response grade A i Explain the difference between static and dynamic implementation of dala siruciures oW UAE Sete oo come ede iv en Vidit Sad grim Uem Ois eed bhi ugs IET ves ida riiumbin Ben kr pee th FEP U Pp M AU i NH Give one advantage and one disadvantage of sioring a queue In an array ralher than in a linked list tirin Thee A Aevi rends aiiis TNT ER ee AL Disadvantage Weve n men Um n ee ee ms mom 4 a pfe e EY Yn peto Puta vs Dn Examiner comment Part i A well expressed answer with the detail that this is an issue at runtime Part ii A good example where the second mark is little more than the common sense consequence of using an array Example candidate response grade C i Explain the difference between siatic and dynamic implementation of dati cha Tec qe snp Siete 5 I a E EBREBRGIERGIGIERIDLGENSLAIGRGARGQEBRFETSmRTRTARTRESRRORBSCSCREGGn ROSSO RUE S SOS B OR Cu Rc B n ou gs p B n ma Pon Bm Romo poca saria scm ica ee joa a ma m g mn feds bai othe i Give on advantage amd one disadvantage of stoning amp queue im an armay mthar ihan ima linked Iial Paapa TOMI gh bo
36. define software to an adequate standard This is a noticeably weaker response than a grade A candidate Cambridge International AS and A Level Computing 9691 Paper 1 Example candidate response grade E I hardware Tay ate pate o eor pa sursis eral XX ca Siege cx Nod Ei o SALAM Summis aen mil ii sofware Thap are Acide Hone Ar dre Suet Examiner comment Grade E candidates usually got one part of the definition correct it was rare to see both parts answered correctly There is evidence that actual definitions had not been learnt and the candidate was trying to do the description from memory or experience Question 1 b A supermarket has a number of point of sale terminals Data is read from goods at the terminals and information is produced State two output devices which would be used at the point of sale justifying their use Mark scheme Printer to print till receipt Beeper to indicate correctly read barcode error reading barcode opeakers to give instructions to customer LED LCD screen to show information about purchase 2 per max 4 4 Example candidate response grade A Device 1 m nidev bd nRiEE ee ee store Bad bk card pth ee Justification c disglest The Alene genti htt osea d apsitnli s D aoc b ET is Bes rw a eas Device 2 d EPAMEE ct MELDEN 77 W TM MMC ND MEM NM Justification To pra MER amo X d Joi dit oF noel pavelese flare acude
37. design including diagrams as appropriate should be produced and agreed with the client Proposed record file and data structures should be described and design limitations should be included Design of data capture forms input formats with examples of screen layouts and output formats should be included here where relevant Process designs and a test plan for the system should also be included The test plan should contain test data and the expected results for that data An agreed set of objectives should also be included These items are the design specifications which should be agreed with the client Example candidate response Flat Management Objectives of the system 1 Use a graphical user interface to provide a user friendly operation 2 Provide automatic operations as adding new records updating or changing flat records deleting records selling and viewing records 3 Provide automatic storage and management of data 4 Avoid the problem of duplication of data 5 Provide data verification and validation to reduce the entry error as small as possible 6 Prevent redundant process in the original system 7 Efficient and fast operation of system 8 Simplify the original method by connecting some operations of different tables 9 Automatically calculate the total price of a flat when a new record is entered These objectives are based on the interviews and my suggestions after observing the current system Mr W Ms Z
38. ee ca gm mgo eee zadsciadzazrdizduRRsm pu m m Roni ol ed ed oe mu peer memi m EPEIBERRERSERISEERRAERRAZGELIGARIAEEPISERPRIAEIGERPRIAEITHERRERIGRELRISECLRIBEEFISEL rr i es ee ee c rcioon e acu ee ee ni ja uo Roda m n caoc4 moe i 4 I n n gd 6 Dee Eam ee RR nn nee ep peer ree meee kn mide ER AREERELLAALEE BEG uniaaskaad n ansa aoe mim nri rmn re es in ebemddukiuzdRRiRSRPRRGRRPSGRRERR4RRESRRREPSRRIIRPRPASEREIURRIASIPIZEFNTIZSEPLUTEETINETUFIEFIREEFTISUSETTEEFISEFIUN E PPIE E EUUE p es m e gom om eee DIBELIEILGISEELJSEREASHENIISSEREISEESI ee eee Ebh es rH eB en 2 ee ee EEEE EA EF ee ee eee eee Te Pest Serer se E Examiner comment This candidate correctly calculated the filesize in bytes but then divided by 1000 rather than 1024 to convert to Kilobytes The working is clearly laid out but explanation of the steps is minimal Cambridge International AS and A Level Computing 9691 47 Paper 2 Question 1 c In a high level programming language of your choice write the code to define the record type for the record structure in part a Mark scheme e g Pascal TYPE JobRecord RECORD JobID Integer JdobDescriptaon String Price Currency ExpectedCompletionDate TDateTime Paid Boolean END e g VB6 Type JobRecord DIM JobID AS Integer DIM JobDescription AS String DIM Price AS Decimal DIM ExpectedCompletionDate AS Date DIM Paid AS Boolean END Type e
39. ee ee ee ee rr Er ee 2 ee PEE ee i La bed i ie Ili State two rasons why It i amp Important for lhe program to be easily understood lt ble ue user Ch ula CE i Cambridge International AS and A Level Computing 9691 67 Paper 2 Examiner comment A detailed and correct answer Example candidate response grade C i The pseudocode has fentures ihat make K easy to understand State two sudi mend sete exelean Toe e Feature 2 In tenkettoa 220 mele Abe hne Md GER dm pes bose ANC oann 2 Progam code is la be produced from the pseudocode ii Stale one olher feature that could be introduced to make the program code easy fo understand ee oh E nrariaiia vil Stan fto Dc A Ht De potait ha prograis d be dsl undariiodt son 1 Vo Sind costly The urong aX the oR aa eeen aeaaee e hemalenchmsclencoaiecioechmelseaneepnean Reason 2 dae other Qrteg Ommer 4o choyae spine hw or neun ta the When he can Gl o v eneilu Nas rogil guiderstd CMT Examiner comment There are no comments in the given pseudocode and modularity when required would already be reflected in the pseudocode The reasons why program code should be easily understood are appropriate 68 Cambridge International AS and A Level Computing 9691 Paper 2 Example candidate response grade E i The peeudocede has features that make If asy lo understand State two auch fealuree Festure To Seu inde
40. ee es EEEE SP Pe See a DR RO aa a Hh i Se ee eee CELLE ete Pe re er re il Indexed addressing Als data LA A0 Xd n D DO dam A100 uod Eun ANP uh BAL 2i Iinrbisgriusrrin rri bea ee ee ee ee kbi Iai iid E Uk Bll inst ll b i Wold as Bol it Hs Melt b Bem Bf ih msm jei omy a Gog o pa pe ff om miego mm oy As me om tpg y IR Retalive addressing MOTE cE FO MARINO AT Me ur CPD OONN ipods MEE M FER ER SS ee PEU DTTTTEDTTETUPTEUUPTEDTETTIURETENEINNEI Pe WH BT be ER bida amp Otte fee lteer ter te tat rr tts 2 SS ee EETA ee ee a EH SE RHEE NH EREHE EH DENH Ip pH SE eg ed es ee ee ee ee ee rhs ets kk i ee r Examiner comment Part 1 No hint that the address is a forwarding address to a second memory location Part ii A generous one mark for remembering that the address has something added to it There is no mention of the use of the Index Register Part iii No understanding that the number in the operand part is a displacement from the current address Cambridge International AS and A Level Computing 9691 Paper 3 89 Paper 3 90 Question 3 Discuss the different types of data transmission media Include a comparison of data transfer rates and transmission ranges in your answer Mark scheme Coaxial cable description one transmission medium copper surrounded by insulation Twisted pair description two conducting wires twisted around each other Opti
41. em An 4 a Li he i 1 expression lo b Shaw wiih Ihe ed oof cad how a slacks weed lo um ihe reverse Polish expression inio an expression in init motation BRL jf added d amp c is pushed lis C mucltiphed by l e a5 e cd ely ia Examiner comment Part a Only one reason given A grade A candidate could be expected to know that infix does not require the use of brackets for the second mark Part b This resourceful candidate realised this is best illustrated by drawing a number of stacks with the changing contents The candidate has omitted to show the operator which causes each change to happen Cambridge International AS and A Level Computing 9691 115 Paper 3 116 Example candidate response grade C fa Explain the naed far reverse Polish notation diesel d mae ilh mln at NO cos pat eo etas S u n lini mda ddnde P if Rede Rl ol NBM l EE ee ee ees er tebe epi ede ee a guum b Show with the ald of diagrams how a Steck Is uewd to lum the reversa Polish expression ab coe into an expression in infix nmolabon l Examiner comment Part a This candidate has remembered infix does not require the use of brackets but cannot give a second reason he other two statements are clearly not relevant Part b The candidate has the basic idea of a new row to show how the stack s contents change Unusually
42. estimation included limitations are imitation of the system is well discussed 2 A detailed description of the system Examiner comment some limitations have limitations has been given including been given and an attempt has been made to the estimate of the size of the files estimate the file size including overheads required for the implemented system d Software development programming testing and installation 18 marks i Development 4 marks A technical description of how the solution relates to the design specification produced and agreed with the client should be included ii Programming 5 marks There should be clearly set out program listings that demonstrate the technical competence of the candidate Candidates should make good use of the facilities of a procedural programming language as part of their solution Example candidate response Pupil Records Examiner comment samples of the type of material that the candidate included for the development and programming sub sections are included below e Data structures shown by table descriptions and relationships e Input and output shown by forms and reports e Processing shown by queries and programming code Cambridge International AS and A Level Computing 9691 Paper 4 Computing project d Software development Programming Testing and Installation i Development System Design and Program Listing System Design POC Report System Fr
43. extensions are not required Cambridge International AS and A Level Computing 9691 Paper 4 Computing project C BRIDAL SHOP P O Box xxxx J South Africa Dear Madam RE Evaluation Letter I am writing this letter on behalf of C bridal shop to congratulate you on a job well done The computerized system met all the required objectives It has improved the working time in the bridal shop and I am very grateful Thank you Yours truly MR Smith Manager Examiner Comment This letter added little there are no comments about the actual system it appeared to have been word processed by the candidate Marks awarded i Discussion of the degree of success in meeting the original objectives 1 3 marks Comments Some discussion about the success or otherwise of the Teacher comment none work but with no reference to the specification set out in Examiner comment very n brief provides little Some discussion about a number of the objectives set evidence just repeats out in c I but some omissions or inadequate explanation requirements of success or failure A full discussion taking each objective mentioned in c i and explaining the degree of success in meeting them indicating where in the project evidence can be found to support this or giving reasons why they were not met 1 3 marks Comments Teacher comment none Examiner comment letter The system is in the main user friendly but
44. followed by the first letter of their last name e Default password will be the first word of the subject taught e Contact administrator for password alteration or retrieval 2 Click the Logon button when both fields have been filled in Menu Procedures Nenu 1 Click the button labeled View or Create POCs in order to open the respective POC view or POC creation forms 182 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project POC Creation Procedures Create POCs Level Name Grade Average Mark Comment 1 Editing Existing POCs a Select a previous POC date from the list box labeled date see diagram above b Select the academic level of the student for which the POC should be edited c Select the name of the student for which the editing is wanted d Select the grading fields in need of change and replace the desired values 2 Creating New POCs a Select a new POC date from the list box labeled date b Select the academic level of the student for which the POC should be edited from the list box labeled level c Select the name of the student for which the editing is wanted from the list box labeled name d Select the grading fields and input the desired values Cambridge International AS and A Level Computing 9691 183 Paper 4 Computing project POC View Procedures iew POCs 1 Select a POC date from the list box labeled date Click the View Report button to genera
45. grade E Praeter s h Dro qre prier Ex rep pee es the NC sari axon Loder PX gp a ie es x ord Se SEAN e ne Do Ce bfc Toe PELEARON is irate died cf Jer Ac 1s calc ax amici dcn ed d Examiner comment It was typical to see some reference to how a buffer works and the idea that an interrupt is sent But all the other stages in the process were usually absent The buffer is filled and sends data to the hard disk is typical of the type of answer seen which shows no real knowledge of how this is done or why it is done 30 Cambridge International AS and A Level Computing 9691 Paper 1 Question 6 Complete the table for this circuit of logic gates Mark points Column C first two values Column C last two values Column D first two values Column D last two values OUT first two values OUT last two values 6 Cambridge International AS and A Level Computing 9691 31 Paper 1 Example candidate response grade A Examiner comment No errors were made in the table his is clearly an easy question at this level Example candidate response grade C I5 Examiner comment There was no distinction between grade A and grade C candidate responses in this question Both found it equally easy a2 Cambridge International AS and A Level Computing 9691 Paper 1 Example candidate response grade E mor A OR mes WND kgs 5j Ex
46. idea of pointers indexes in sequence multi level indexes and so on This is a very good answer showing a sound understanding of the topic Example candidate response grade C Pn jl tedak pem 73 6 Soli oer is Basal ian ll gelo He Pgs Can ng Of then next hs ond he ex Midi be Line Sehe dnde wal deno wee ta lied Io nma awe he dabas 20 Cambridge International AS and A Level Computing 9691 Paper 1 Examiner comment The text simply describes the diagram which unfortunately isn t a correct example of how indexes are used Although the candidate has to be applauded for attempting to draw a diagram it isn t very good and is rather confusing which is also reflected in the text Example candidate response grade E ea d Selection Kc e ocn ple 3m Search Mines deeem a S n my emn be F Ear 2 Examiner comment No diagram was supplied in this answer The candidate relied totally on text which went against advice given in the question The whole answer was revolved around a very general method of searching with no indication of how indexes used etc Cambridge International AS and A Level Computing 9691 21 Paper 1 22 Question 4 b i Explain how hashing could be used to access the member file randomly ii When the member file is accessed using hashing clashes can occur State what is meant by a clash and how it can be dealt with M
47. is the ultimate aim However to score any marks in this section there must be some evidence that the client has seen the system in operation This can be done in a number of ways such as by inviting the client to see the product and allowing the candidate to demonstrate the system or by taking the system to the client involved There should be an installation plan written including details of system changeover training required and details of user testing Example candidate response Pupil Record Installation Plan The installation plan was discussed and agreed in the meeting mentioned below see project diary with the client and end user during testing Have the client test the system during development of the system and discuss suggested changes with the end user 1 Give the client and teacher the final project for them to test Pre train staff and pilot the system for form 12 and 13 during the summer term when POCs are usually not made Use feedback acquired from pilot to make any changes to the system or fix any possible bugs Train staff properly depending on agreed staff training plan see below Implement system permanently using agreed system implementation plan see below p E oe EM Maintain the system temporarily before the IT understand the system completely and is self sufficient in its maintenance Cambridge International AS and A Level Computing 9691 171 Paper 4 Computing project HZ Staff Training Plan S
48. lot Disadvantage Memaga an n del wasted es core eee I 2 Examiner comment Part 1 The candidate expresses the idea of a static structure using a fixed amount of memory space but cannot expand on this for the second mark Part it The candidate has come up with a disadvantage but is unable to suggest an advantage Cambridge International AS and A Level Computing 9691 107 Paper 3 Example candidate response grade E M Explain the difference bews Salk and dinane implementation of data Fa Det C mft Bopp der Ger SS Rocwtad ck LR cer Se ede 7 one 5 cderpeniic dete cacy fe onemieetarect cat en are E AUD nee 21 i Give one advantage and one disadvantage of slaring s queue im an array ralhar than ip a haad Ist Advantage Dadebpp We cbe ceca Bolle he ce nent EU ga aen Tae Deote cwrhegn y ceed c lata Cs Disadvantage _ Pefeling gee oet iE fey hee Sill feo fete borere to teat ene A Examiner comment Part 1 The candidate is confusing actual changes to data values with the need to have a flexible amount of storage space Part ii The answer that data can easily be retrieved from an array is a weak answer Question 8 b i Draw a diagram to show how the following members of a Computing class can be stored in a linked list in alphabetic order FRO TSI DON nos BEV ii Describe an algorithm to insert a ne
49. must be left in no doubt the system actually works to the satisfaction of the client This evidence may be in the form of hardcopy output and screen dumps Cambridge International AS and A Level Computing 9691 Test Strategy Test Plan Test Objective Check the outcome if leave the input fields empty For example Student ID Check if the format check applies on the numbers Check if the system allows 0 to be the number of a book when adding a book into the database Check if the password system functions properly This is very import Check if the data can be saved after it is altered Check if one student is only allow to borrow 2 books Check if the fine functions properly when student return books within 14 days Check if the system can process when user tries to borrow a not existing book Check if the report functions properly Check if book can still be borrowed when there is no book available Test Data Used asdfasdf 1234 4321 book Test Method Left the Student ID empty and try to add a student record into database Enter a non numeric value into a number field Input O into the number field in the book section when adding a book Enter both correct password and 09877 incorrect passwords Create a new student record 10 Tony 1234 Try to borrow three N A N A is N A N A books at a time using the same student ID Try to ge
50. order with a clear start pointer and end of list pointer However the diagram makes no reference to a list of available free space Part ii The final value in the list has been shown pointing to another node which is incorrect and there Is no indication of the use of a free space pool of locations Start pointer and ordering of the nodes are correctly shown Example candidate response grade E l Drew a diagram to show how the following members of a Computing class can be stored in a linked lisi in alphabetic ardar PRO T5 DON Ros BEV Rez mw Rex SEW PRO Ses TST Sa je ignored FEO 8 gt fon Se Dom Ge compared Dof t KDS se HE Y Pred Don amp gt wey se JEFF is Feed H Dascribe an algorithm to inser a new member of the class info the correct position in tha list eee dfe eem me Do deett amet hend Pumdar ees esu iis Rd eee CNCOQRON GAOROROA ee Lee SORS HOO OR e MO SR eN OR S2 MCN RD MO SG B N peg cm Su sc mcm n ua i Pare Aati mir TTL a abe in Lad Lig Cai i SR 2s ri rieri eee ee tind peri Posi i nUPPBPISPPITPEUEPPERERE MISMIMEUISRUICQEUEUEPEPPEEIPEHISMEPITUTITIEIDTEPIERBIUPPUNIEEPNIUIHIMPTEITIETUUTT BOUES ee Pees Pe Pee ee Pe Es Ss ae ee Seer Pers ee aa eam ree em Bs EM EAA nia Ge he Ra cba ldidk REGE La ld Lr a Ta cre Mid wl ida LINT ue ali uniakidd4 Eid Rl Eg CLOC COPECO OEE Coe ca JI RE aus ENRGER E EG ina ie keki eo i Bi ok Hs Mesa Bek iad
51. reference to ASCII codes here indicating a lot of confusion between representation of characters and integers Question 4 a A library membership system identifies members by their unique 6 digit ID number Explain how the member file could be accessed using indexes You may find it helpful to draw a diagram Mark scheme Ds indexes kept in sequence Attached to each is a pointer which points to the data for that ID Possible to use multiple indexes Member M1347 xxxx yyy M1479 cccc dddd Member file Index M1564 aaaa bbbb M1565 zzzz wwww pL 1 per max 2 2 Cambridge International AS and A Level Computing 9691 18 Paper 1 Example candidate response grade A qm aa the EB nuaber esken down Bete Seband Hed m RA LLL sid E aan tadga Jed r Lacie TT mb T fiaa e au Ju d ang elc Aem Te eng yx x ug eme ancl allelic later Agi B r v i seno e n malh nel in mmbmbpbemuEmHdd 5 pela i gi A hs ct ich o A Peny ancl ie domai k dulce FU ner te due dada De Fe bare 09 E fi my pa oo bii IM aa Mi anas msuaamududirdibrbkhkr ma ma rei tite tlt tere eer ee Cr Pe 2 Examiner comment This question was well answered by the candidate with good diagrams to accompany and enhance the description Diagrams generally greatly improve the clarity of the text More than two points were made by the candidate
52. registers Describe how the contents of each of the following registers changes during the fetch execute cycle i Memory Address Register MAR ii Memory Data Register MDR Mark scheme i Contents copied from PC Contents changed to the operand address part of CIR 2 ii Instruction copied from memory location to MDR when contents of MAR are from PC Data copied from memory location to MDR when instruction is LOAD Data copied from ALU Accumulator to MDR when instruction is STORE max 2 Cambridge International AS and A Level Computing 9691 123 Paper 3 Example candidate response grade A i Memory Addresa Register MAR Bach Hine Ae FE gramen dme TTE s neuieur lc hr ETEMA senta dim poldros v cepted d o MAR P felt 1 hee po pe ae ILI jiiim PERFIS jt om er salus topi d do EC Ie ente al 2 NIAE EHEM gt MR Eji TEPER cma i il Memory Data Register MDR pad nbi eic zQata feted dom bitine S ave copied to HIE t aa ca mach cma mcum dn mi im li dl E ee eT b cee do Pert later ey CIR as W bkicI u Se EUOEQOEO eU g CR pE 0 3 7ORO3 CUg KORQOF CY YU q ROSUScE 0 4 UDSCQq So 4 OR HQ Oi DR D 3 3 OR GEL A CACHE SS UR E SS RC N B CN NS B GN UH HD COR GO om CR US g TROC N CH NU MCN CU G C G5 a Rn a eee NSON OON ee Rn m Tepe prense ppp ee pae gu mE mie ad E Ee eee iNe SP a ee Pee TIL LLL ey rrTte pu TT ee eo TF mmm Examiner comment Part i The ca
53. reo t T mpuu pE EEEH EELIS EELIS NHE BEidAELARELIZRRIGSRRAdREd ZSLIL4JGAziidgRARI RGEIdJesRdARLGSsIi 4 REddE e LEIP BSR PE PS Pe Pe ee ee ee ee 2 r rE 2 E OCT E UE T DIC 2 es eee Err prr ee ee ee ee ee Se Lib M i PM re ABI MEE edi Meo re adis EMO NER Rc RN kim ie bci iim ie cien m me i om d i eni on em Rn n Renta h ija rnm minm iom je i rdc c m doom e psi m ndo mca qum e gon m e nodo m a bo in iod onda m a ci me ciem mi io a cm s m nid s e aai m inde ini eh bia indici de icon m elc Ried n Peer rs Se ee Ee a imRPFEaRERREAmRRAREERdamprE PG RR RSRRIRSRERRERRERRAARAGdGHERRERRGSREIRAERRERZRERPGRRRGRRLISECd o2 EPIHEF g umesrRcroanmpsdmmhbrdmmprsummsammprummpaumpcbmump a m 7 y b om mi M ROME UA OR BOR GNOME NOR UR OR OMS eaan Go RS SEn N RDUR SR XH RS Aon GS a RO a a a HO NOR a naon OR RD DOR OR CR m maan OR RR RS e Sa C RR Ga NOR OR OR MOOR GN n a HON oa RS RS MO UU RO GR n mma mmm ah aia a EBBZEREFESZLIRLDLZJRLDLIBLRIGJZLIPAJLLIGSERG Examiner comment This candidate calculated the record size and multiplied this by the number of records but did not add the 1096 for overheads The working is clearly laid out and each step labelled Wap ar E 1 HHS PEH 1 ERRE PENE 2 Be PEE 2 EFI FE EA 2 FARER 2 ee ae 0 en JER ee ee ee a Ee ee n rum mra meran fe i z FTE dri dm ibn i a ihiihi hol BLAA EE LAA Eia REN eee Piah iaa HE Epi AE pHa PB be PE Ep E Eji gE a ade l2 overhead EEO pog ua
54. shaven and 5 te eM ERE tp een Soutien OUS law oath ee ig nanan A dee Stour E etre AR Xen Ait Carn deas yw xx Duos S r3 04 5 b F St R 6 Pe ee ee ed ee Eee Examiner comment On an opened ended question like this a grade E candidate should score reasonably well the mark scheme had 12 different points from which the six available marks could be scored The answers here are weak with little explanation of the three security measures given Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Paper 4 Computing project What is the project The project is a substantial piece of work requiring analysis and design over an extended period of time which is organised evaluated and presented in a word processed report otudents choose in conjunction with their teacher a well defined user driven problem which enables them to demonstrate their skills in analysis design and software development including programming testing installation documentation and evaluation Problems should be selected that allow students to demonstrate their programming skills Projects should be chosen to demonstrate the integrative aspects of the work and should avoid needless repetition of the demonstration of a given skill Each student must submit a report on their piece of work supported by evidence of software development including programming a
55. the company works and the analyst is the person who knows what is possible Cambridge International AS and A Level Computing 9691 Paper 1 Example candidate response grade E d he mt RS EC Uviheuld firet ede vadecsi hed AES c f CR mL each ot Pesce arab le E shee ld hepddahiy be demanstonte d tbe cies 1o The eo ay A hg 2hedest rest _vnderstend 2c fle vell xe ble due Toro eina foo 1o calation o else 34 amp aledie n is hd ne be es hle Jo salue De eniginet ul Prose af Ya poter Examiner comment There was obviously no real idea of what needs to be done for this question General answers like manager has to understand problem and the analyst has to understand same problem or else might not be able to solve original problem are insufficient and common at this level This answer lacks substance and there is no mention of the role of the manager or the analyst Question 2 b i Explain how the evaluation of the new system will be carried out ii Explain why the evaluation is important to both the analyst and the manager Mark scheme i Evaluation carried out by Functional black box testing esting against the agreed objectives Testing against user requirements specification Testing done by software house alpha esting done by users beta ii Important to analyst to ensure that there is evidence that all objectives have been met
56. there is not authenticated desirable room for improvement e g no on screen help has been extensions not required provided The user indicates that the system could be used but there are some faults which need to be rectified A fully user friendly system has been produced The user indicates that the system fully meets the specification given in section b and there are no known faults in the system Cambridge International AS and A Level Computing 9691 193 University of Cambridge International Examinations 1 Hills Road Cambridge CB1 2EU United Kingdom Tel 44 0 1223 553554 Fax 44 0 1223 553558 Email international cie org uk www cie org uk University of Cambridge International Examinations 2011 v1 1Y11 PART OF THE CAMBRIDGE ASSESSMENT GROUP
57. tse ee r1 6 An alr canditiening system is a realtime application Faplaln how sensors and actuators are used to control an airconditioning system In an apartment Pee ae eee Oe lo pie ee evereee oe fee cll P Rr deem ene Es one ma lr bove ame Meter cenae tie cool Re eel omer Geata Dum urne em coh i pope bres stel an M eui CEDE EUNTEM TER DP LC ewe tl c Give one other exemple of a real time application Justify why your ohaide is B real time application Example Braking 5 SRP ANEEL rea ee duetification Tats ctf wegedag et Beene refine ell L tl ud cncocewdude rerponee oc eir gooftte ot m 8 es mense AS Tua eer tell cob site pe inne fob fa Examiner comment Part a A very typical answer from a weak candidate they clearly have learnt the standard definition of real time Part b Note the first sentence simply copies the question Credit is given for the idea of a critical temperature and the explaining that a signal is sent to the actuator Part c The application and explanation has nothing to do with real time There are many topics where it is good exam revision practice to learn a definition AND a simple example to support this this is what parts a and c of this question are asking for 96 Cambridge International AS and A Level Computing 9691 Paper 3 Question 5 a Describe what is meant by the spooling of files b i ii otate why files
58. v Ahtm Mid m eC a Oa fetal Therefore 3 feet in Lair leh n OTI qne ics ux Me E print lap ros FUI ie rent des papi lbs ii Explain how t is spooling is erred oul r nor mi mja Jute Je ekids Etn pue eit EEG GE PE OME Ls icm ela icm dn mon hs 2 0 3 31e le m a mosnt per the filo af tada Phy leh uo priority aill kaat ihe bp Ane rpoclisg gute te ae ent ind The Jk Aik Abe fnt cay ll v n hen oe 5 Joalin queus clie wil ve pieta decore the tog one dn ba Print Examiner comment Part a This answer does not go on and give a common sense reason for using spooling Part b 1 A good clear answer which describes how the print jobs would be managed There is a lot of detail given about how priorities might be allocated but this was not asked for in this question Part b ii Some of the mark points which would score here are little more than common sense and the candidate knows that a commonly used data structure is a priority queue 98 Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate response grade C a Describe what js meant by the spooling of files aln nmr ia Pt Tee UPISFFIGSGHSENEPFLRAZZSLIGGEFP FNEEFIGPDEFTTTHEUITOEFIT RN HEETTEITITISTETINUEFTITSHETTTEFKTIET i P Is he rca Hine fon CE kgs a a 3 86 cs dorbrdeemeBiseRBRPbPGeRPRPuRPdE 5 IDEM BEHHEEHH BEEF BEIHISSEHISERPISSERIEEER EBEIIZESNEGEESNERIBKE a
59. you can buy directly in a shop have you looked if there is any software that could do that Yes I have looked into that but there isnt any software that can provide exactly what we require so we need custom written software for this Question 15 Is there anyone else you would recommend me to talk to Yes I think you should talk to one of the 2 teachers who are in charge of recording the results and allocating the points to discuss with them what the problems are and the requirements that a computerized system would need to have to be the most effective You might as well want to talk to one of the teachers who does the direct recording of the results at an event to see the problems there Below are copies of the event selection sheet and the result sheet ee eee u ALLE 4 T f fow a ques p pe ap A qu 7 IF o Dee 1 _ Cambridge International AS and A Level Computing 9691 137 Paper 4 Computing project First Name Last Name Form Gender Houses 150 HJ LJ ball Relay PES NEM s Ao fs F De E psp pm 49 M M E PE O E E fc fee e F ew fe KR e F ew o m e F ew no fma fe F ew fe w s F ew E CG A A A A This is one of the sheets used to record the results and the number of points at sports day aa al lc quur dL ss P re 138 Cambridge International AS and A
60. B 1 um Convert 4D WKillbbursg 15 605 fmm me om emo a m om m m ke momo m cme om ol om im ii D me men ca m Am om Ron ms mh mom om mona om Bh B RR GR m ke OD A gEPTEZERINNEFHEFIIHEFIZEFUTENRETU D E a m B idm beam iu dbrinuprimmbirittriSnEPRaSaKLiERLGJEERGJAELIARELIGEbrImmeEMPEbPaeBIP4BRPISRRPEIBRRPFISSEIPdSRRIMEIEAREPIRnI dRELEISEIIERIESERI a 15 2 kilobytes FUHFIISEHERIZGEPGHERIIHFIITEFTeM pahi ed egg manm qa mot mma pea E n ea a a oa a a a ca m m a a a ee oe ee ie eiil i ii i d ik B hi ic ool Hida lH dbl OP O m Sien i h iein am a ma a m h a br Rm EE N N E I EE EESE BERRA hl E Epa S E a EEE E E EE ee A e ee ee eee e ei E STELIS PL ITEN TERTIT TET ETETE TEL Peeters ee piru mn dien dmmbummmbumiici mmc mmi mma ee eee ee n ra con n ido mi o E Bjo ee m rd mimi oam P RESET cach mau esca acu eo aA p Ou q BG ppm cro ogouoe oaa mani s ee w mom ac Row edo ac mono ci mon aca ue cR cR n E RR RR ORO D RR RC RR GR DOLCE ee eee a a Bo oh hm a a a a ee eee ee eee Pee Examiner comment The candidate used the Tile sizes from part a to calculate the size of one record Correct multiplication by the number of records and addition of 10 for overheads as well as accurate conversion from bytes to Kilobytes make this an excellent answer All working Is clearly laid out and every step explained Cambridge International AS and A Level Computing 9691 Paper 2 Example candidate response grade C hex ou WC Y BEISEPEEISEPTHI SEIT 0 T a i T a 5 4
61. EAMS during the season i State the relationship between LEAGUE and TEAM Draw the entity relationship E R diagram to show this relationship ii State the relationship between TEAM and GROUND Draw the E R diagram to show this relationship iii Explain how the relationship between TEAM and GROUND can be designed in third normal form Mark scheme iii Link table needed with primary key made up of combination of primary keys of TEAM and GROUND Primary keys of TEAM and GROUND used as foreign keys in link table his turns the many to many relationship into a many to many relationship can not be implemented One to many and many to one 2x one to many relationships 1 per max 4 4 Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate response grade A i State tri retmtiansiip h tean LEAGUE TEAM he de Man i Per Drew Ihe e amp nlily relatiorshap E FRO diagram 1o shaw this relatlanmnin LEA ive IN Explair how lve poladionsticr between TEAM and GROUND can be designed in hind mormel form In bhird normal on Ws I 7 x amp dadiobhig m emat exist LM A focis hl am ru sed belek Jo bae culilits eim ES he ok A pom dan AX sinis 1 E is dan oe Examiner comment Part i Correct statement and drawing of the relationship Part ii Correct statement and drawing of the relationship Part iii A clear answer with the key poin
62. Gtk h a e b it ls cee ok ld l el cis i EAA A a i A ll oll e Reh ood MMos Mell i od a i le old e A A e ie A l eld i IERTGE UHEEAZELAEFIZERAEISRI ISESISEIGEL HLAGEIgEISPFiIRaSGEIARI dGabASRiGgELImnRgubiuysIUGERIBEIZE IdERIGBSUITEUISERGHE I2 ie TE TETTE tal Relea Bel ET EE T Cambridge International AS and A Level Computing 9691 118 Paper 3 Examiner comment Part 1 Some key concepts such as a start pointer and end of list pointer are not present in this answer Part it The answer reads an algorithm but there is only one correct step included adding the new value to a free location Question 9 a Explain the need for reverse Polish notation b Show with the aid of diagrams how a stack is used to turn the reverse Polish expression ab cde into an expression in infix notation Mark scheme a reverse Polish expressions can be processed directly trom left to right s free of ambiguities does not require brackets does not require use of rules of precedence 1 per max 2 2 b T p d Leb B TEP del Mark points at least two operators shown between transitions a and b in first stage a b after first operator e d c a b in stack in correct order d e c d e a b c d e 1 per max 6 6 114 Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate response grade A a Epai the peed for reverse Polish matatini arent hey
63. Level Computing 9691 Paper 4 Computing project Interview 2 Mrs M Question 1 Can you please tell me what you do I record the position of the students during the track events and sometimes record the time Question 2 So is there a teacher assigned to each position Well not really there are usually 3 teachers that just take down the name of the student position and his house Each teacher is in charge of 2 or 3 lanes and records the name of the student his position and house Question 3 So who does the timing Well Mr amp is in charge of the actual timing He uses a machine and clocks in all of the runners so he simply clocks in the times but not the positions The machine then prints out a sheet with the times Question 4 What do you then do with those times I then with the help of another teacher assign the times to the position house and names so that we end up with a sheet for each age ground and gender Question 5 And what happens to the data The data is then taken to the desk where Mrs K fills in the results onto a large sheet of paper 1 per age group and gender She fills in the results and then adds up the number of points for each house and writes down the number of points for each house in that age group on a separate prece of paper She also checks if no new records have been broken and writes down any new records Question 6 What are the main issues with filling in the results and allocating the point
64. Or will not be paid ruin his reputation Important to manager to ensure that there is evidence that all objectives have been met Or system may prove unsatisfactory in the future 1 per max 3 points per dotty max 4 4 Cambridge International AS and A Level Computing 9691 e Paper 1 14 Example candidate response grade A ij Explain how ihe evaluation of the new systern Wall be cared owl Examiner comment In this response four clear points were made across parts i and ii correct references were made to testing the system and meeting the objectives set out when originally defining the problem Example candidate response grade C i Explain how the evalustion af The mew system will be carried out ie The ond i ph Aydin a kia te ee Speen y n Ae aia i ahs Dua asa aA 4 SPs biti im ee ee ee End i hihihi fies fi ini i EHH BS A EAE Examiner comment In this response the candidate s ideas are not very clear about how evaluation is done There is some reference to objectives but no mention of any testing Throw away answers such as see if all requirements are met accordingly indicate a lack of understanding of the main features of evaluation but some understanding of why it is done Cambridge International AS and A Level Computing 9691 Example candidate response grade E i Explain how the evaluation of ihe new system will bu carried out Ro a ren B P
65. Part i hints at some understanding that a numerical code is involved Part ii describes the idea behind the relationship of ASCII codes and letters of the alphabet but does not describe the use of the ASCII codes in the process Part iii only considers the first letter of each word and does not deal with the possibility of words that start with one or more letters that are the same for example this that 72 Cambridge International AS and A Level Computing 9691 Paper 2 Question 3 a Raul writes a program which will keep a tally of the number of times each letter appears in a given text He uses an array of size 26 to store the totals for each letter He then initialised each element of the array What value should Raul give each element Mark scheme O zero 1 Example candidate response grade E 623591760 Examiner comment This comes from a grade E candidate s paper but could have come from any graded paper It was mainly ungraded candidates who did not answer this correctly Question 3 b Define the array and initialise each element of the array using a high level programming language of your choice Mark scheme e g Pascal VAR Letter ARRAY 1 26 OF Integer FOR I 1 TO 26 DO Letter i 0 Alternative VAR Letter ARRAY a z OF Integer FOR L a TO z DO Letter l 0 e g VB 2005 DIM Letter 26 AS Integer FOR i 1 IO 26 Letter i 0 NEXT Cambridge Internati
66. Person in charge of Econ writing down the results Results Resuls are added up If match N If mismatch E Total of points Total is checked Total of points are announced Data capture method The data is captured using different methods The student names and house is taken from the school database which is filled by the secretary when a new student joins the school The student choice of events is taken on paper sheets which are filled in by the students during their tutor time For the track events a machine is used to record all of the times for all of the students a teacher clocks in all of the students taking part in the event For the field events a tape measure is used to find the length height thrown or jumped The sheet used by the students to choose their results as well as the sheet used to record the results are shown at the end of the interview with Mr F Cambridge International AS and A Level Computing 9691 141 Paper 4 Computing project 142 Processing The data is recorded using some measuring equipment and is then written on a temporary result sheet where the points are assigned These sheets are then taken to be filled in on the larger record sheets Here the actual result isn t recorded the person filling the sheet checks that the result isn t a new record if it is then they write it down on a separate sheet The person then writes in the name house position and number of points of the student in as
67. RETPINENRZAEIGGRREPRGERRBGAGRPRRRRERRGGERSZGSERGGERG Gd Rd Redi dod ejes redo c rn e n m 3 pupa TR ee ee eee eee PHE EREHE eS SS PS ee ee E Hi BHIE SERIES mimi EE ee eee Eni i es i ee ie anm RUN RIAL Examiner comment This is a common response from a grade C candidate where just the fields are defined To gain full marks the candidate also needs to show how these field definitions need to be enclosed with the correct keywords to declare these fields as a record type Cambridge International AS and A Level Computing 9691 Paper 2 49 Paper 2 Example candidate response grade E sd RO RR ot Rom ow n n Ra m m oc wd nc m n o ac e aom m Ro aca mo doa m e aoc a dead mon dca a m ic os m e acd m ora m m aca m o nc mom RR n icc oca cn Ge ac m as oca a m asa ume acd a eoa m n Goa mo ac mom a m om ca a n B Re Bk Examiner comment Quite a number of candidates stated the high level language to be Algorithm or Pseudocode This is not appropriate For questions such as these candidates need to show evidence of knowledge of a real programming language Question 1 d Some data will need to be validated when entered i State what is meant by validation ii Describe two different validation checks that can be performed on the ExpectedCompletionDate field Mark scheme i to check that data is reasonable acceptable follows rules to check data is complete 1 NOT correctness ii range check explanation
68. SERISEFISSEInEEISERASHEPTSEFIAUE ISHSEREISHBP IRE EA BRE E The correct byte was chosen and the candidate clearly indicated why this was the corrupted byte The meaning of even parity was well explained also a good explanation of why the chosen byte didn t exhibit even parity was given Example candidate response grade C Comupied byte OllOll amp iBis Pe er RESESESHESEHPI PIS Ss EJELB FH EAR Fd 2 ee HAHAE A HAA EEH p Examiner comment The correct corrupted byte was recognised by the candidate and they were aware that even parity was being used However the candidate could not explain properly why 01101101 wasn t even parity and simply indicated it was odd parity No reason given why Cambridge International AS and A Level Computing 9691 39 Paper 1 Example candidate response grade E EOS Bodo S PALO D animen Reason oris eene eb edi Hae modis Taa OE O V Mos Lass lei ia panem 33 M kA C EF Y We oT Me Mr e Examiner comment Grade E candidates just tended to pick out the byte that looked different to the others Consequently 10101010 was often chosen because it was the only one that ended in a O Little if any indication was given whether parity was even or odd although the concept of parity was often mentioned Question 9 a Describe a single user operating system Mark scheme OS will only allow one user at a time to use the computer Each approved user is identified
69. TE BARS ii Sree cd ESN aS uon Deva Ree Ros wodeiug ioe OR hs HSaaERISdEEE IAARELE LAERIASRRIAAEL I AEREEINEFEERZEUTTTEFEFEEFUTIZUEFTTTEEEVFTTTE 4 Examiner comment This candidate has written very vague answers such as testing is to be done or make sure problem solved A mention of the analyst getting paid was one of the only points which gained a mark at this level Generally grade E candidates didn t really understand what evaluation entails Question 3 a i Explain what is meant by the character set of a computer ii Explain how a character is represented in a computer Mark scheme i The symbols recognised used by the computer Often equates to the symbols on the keyboard ii Represented by a set of bits Unique to that character he number of bits needed is equal to 1 byte 2 bytes ASCII Unicode is a common set 1 per max 3 per dotty max 4 4 Cambridge International AS and A Level Computing 9691 Paper 1 Paper 1 Example candidate response grade A i Explain what is meant by the character set af a computer odd d ra cim adERPaumRiGmb GmRRRmRER GdRERAGR Ra P dERAZmmERR a ts ool eB i ah oi al Me Bol a i i aOR ak a BNR NAE Ern E WA SSS ae i ep oe ee eRe pe eh ep em ge Gaiaa eic mie poia mir Bem Be SR Be RS Se ET dc bM W Explain how a character Is represented in a computer I4 inia mnai nin di biad buiadi Examiner com
70. The logic statements are correct Candidates writing pseudocode should use the programming symbols gt and lt rather than the mathematical symbols gt and x Example candidate response grade C Joti pel et Auk pe AWD Tame inn 0 eR 2h gt RT cops bo Paid cee E RUE MARU 4 mm om aom ai aS a a eck eee ei Beia aal ai cme eam Seesmic M m AARBhRRARRERBREREEEEEEPEIETIIEEEEEUDITIEETM Examiner comment The JobID validation is correct No separation of the two conditions of Paid show a common mistake grade C candidates make Example candidate response grade E Mo pe Map 2 2 Amm cm dom mach oneRacamE RE ERmERRUURGERBRTIFINELIZEPTERUE c Yes sr ep AND wan tae Examiner comment This candidate has been awarded a mark for the AND The remainder of the statements do not make any sense Evidence such as this show that candidates need more practice at writing boolean expressions in a real programming language as part of simple programs where execution of the program will quickly show the candidate whether they have constructed the expression correctly Cambridge International AS and A Level Computing 9691 53 Paper 2 54 Question 1 f The code for the validation will have to be tested State four items of data you would use to test the JobID validation State the reasons for using that test data reef ooo cof oS m E S Mark scheme Any sensible reason accepted e g
71. Wendy Fischman UK Best Seller o 29 l a Go Blue E ABE m l EE Ux safasfadsfsaf o i PO a My system can successfully solve this problem 170 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Marks awarded iii Testing 4 5 marks A collection of hardcopy test run outputs with no test plan Teacher comment or a test plan with no hardcopy evidence may also be evidence for every test present A teacher may award 1 mark if they have been run is provided shown the system working satisfactorily and there is no hard evidence in the project report Examiner comment There is cross 2 There is little evidence of testing with a badly developed referenced hard copy test plan with clear omissions There is no description of evidence for at least 8 the relationship between the structure of the development test runs work and the testing in evidence There should be hardcopy evidence from at least eight different test runs cross referenced to the test plan However not all cases have been tested Evidence of each test run cross referenced to the test plan is present in the report Testing should include as many different paths through the system as is feasible including valid invalid and extreme cases Marks may be lost for lack of evidence of a particular test iv Installation b marks It is recognised that the client may not fully install and use the system although this
72. ach of the following types of software would be used for Give a feature of each which makes it suitable for your use i Desktop publishing DTP Mark scheme Producing leaflets flyers brochures posters Using frames to divide up content editing features combining images and text 2 Example candidate response grade A Use e g Ause Mo T lec boule Neele fne n pro luct eund tov iemoheona onal lo Scan scenes Se Rae we ITI Shae Reh ee mms ETETETT CET I a a 0L EET E RR rere Feature AR EA Ie eat MAP de i PT i wakd d MIRO RARUS male epp m deal ed S042 edach we Js e 2 Examiner comment In this response there was good use of DIP i e producing leaflets but the candidate expanded the answer to indicate why the supermarket would produce leaflets It produced a very good comprehensive answer The features of DIP were clearly understood and distinguished it from other software such as word processors I e wrap text around graphics and make complex page layouts Example candidate response grade C Use managemen ean Me im pind ig aang bout a AITTI S E Feature dpa Hop Miis sa 24 y OE callous Bo wer mako derigrs nnd enabler usor create fled Examiner comment The candidate obviously knows what DTP can be used for but found it difficult to explain what features make this software suitable for the task chosen It was very common among grade C candidates to f
73. ain Izi Png dE A open Rn nd thue T cmt LES 24 re Baii um aM as 4 SSPE arron na ANLAN La mim Rll i inlet ener enormi emen ninm ee ee ee ee eee ee EEE i Examiner comment The loop structure is acceptable The candidate did not recognise that in order to keep a tally count the array needs to store integers not characters Within the loop there is no attempt at initialising array elements Example candidate response grade E Language C ee ee iem E IET us mammizarhizsansERiRLEnisEr rr ett sumite Geog bid cree dee dd do he aa Pieris Ce ee ee ee ee ee ee EE CX Ms Qs I deitas ama T Thi a LREN 11 E31 Le I4 2 3 Led MX 2a dde Re Dom En Mio fiche 057 4 Je c B2 f a Da o M Lai AN E m Sf clit r Tr D gm omen eee am a passe ee ose pe i NE EN aac EBS sas EMG as BSL PdasRR IRBAEIAAEREIBRR ERI de EREASEREAGGERFRERIGEEERARERISRRREAGSREEIGRRRIRRRRIAGARIAAARRIGRARRAdAdRRIASRRRIdamRidASAddR PdaRuilidReISARRR Ide RPSREE dar A rcu 4 TH Examiner comment In general candidates offering C struggled the most to gain programming marks Grade E candidates often could not see that a loop structure was required to set each array element to an initial value Cambridge International AS and A Level Computing 9691 in Paper 2 6 Question 3 c Write the statements required to update the array when a letter has been read Mark scheme e g Pasc
74. akes reference to items elsewhere in the candidate s report this is acceptable or a candidate can put the required elements in the systems maintenance document and make reference into that section 11 User documentation 6 marks Clear guidance as friendly as possible should be given to the user for all operations that they would be required to perform These would include input format with screens displays print options back ups file integrity routines security of access to data and a guide to common errors that may occur Note the candidate would not be required to copy out large volumes of any underlying software s user guide but to produce a non technical and easy to follow guide for someone with little computer knowledge Some mention here of the relationship between items of software and the data they deal with may be relevant The user guide should be well presented with an index and where necessary a glossary of the terms used Alternatively an electronic guide could be based around hypertext links screen dumps will be required Cambridge International AS and A Level Computing 9691 181 Paper 4 Computing project Example candidate response Pupil Record User Manual All possible errors will be displayed in the common error guide below Login Procedures POC Logi Username Password 1 Enter username and password in respective fields see diagram above e Default username will be teacher s name
75. aking their Advanced International Programme AS in form 12 and A level in form 13 Every year they organize a big sporting event where students compete against each other to score points for their houses The students in form 5 to seniors form 13 compete in the following events triple jump high and long jump 100m 200m 300m 400m 800 and 1500 as well as javelin and shot putt These events are split into age groups and gender to keep the competition fair There are four houses blue red yellow and green The house that has the most points wins the event Methods currently in use A computerized database contains the different houses with the students in each house separated in different forms The information is printed from the database so that there is one sheet for each form These sheets are used during the event to keep track of all the points scored by each individual student The points are recorded manually during the course of the event on the corresponding sheet of paper At the end of the event all of the points are then added up to have a total for each individual house Origin of the data The data comes from the events the lengths or times are recorded and then the points are allocated depending on what position the student arrived in the event After the event the student the students name and position is written on a result sheet and the number of points are allocated Form the data takes Once the student has done his ev
76. al IhisLetterIndex ASCII ThisLetter ASCII a 1 Letter ThisLetterIndex Letter ThisLetterIndex 1 Alternative if character range used for array index Letter ThisLetter Letter ThisLetter 1 e g VB 2005 ThisLetterIndex ASC ThisLetter ASC a 1 Letter ThisLetterIndex Letter ThisLetterIndex 1 e g C thisLetterIndex asc thisLetter asc a 1 letter thisLetterIndex letter thisLetterIndex 1 1 mark for finding correct array element 1 mark for incrementing running total correctly 1 mark for correct overall logic 3 Example candidate response grade A VALETTE Ro mehe RRR AO NR ERESUENCH LETTER Feeouency vertee x n eu UN a Tees d4ea ERRRRRRRBERRddGduddbCERERPEEEEHHSHNHEUSUHSZGCUERTDERLEEREHSgGGNTDETELERERHGSNGGGG4IAJabkRmRRRRSERORAGG d PRREERRRRdENHUGRGRER oe Sas Se eee ee ee ee ee es Se FE H eee GE bce GA A SB eB oca once s soa d eM i ied mca moa moi a3 o e pPEPHEHHTHIRUG See dioi inan i ee eer Eee ne ee ee Pee ee ee ed deb bee ee E nA nE ee ee nh mh me re nu Frer E r nee ee oe ee ee ee ee ee eee ee eer TT TTT n iriri Examiner comment This is the hardest question on the paper This is one of the few answers that gained a mark There are several different ways to solve it depending on the language used The mark scheme shows the marks for one method Any other correct method would have received comparable marks Keeping a tally is a standard exercise
77. ambridge International AS and A Level Computing 9691 125 Paper 3 all payments communication can be made through a secure connection need to safeguard against bogus websites Procedures in place for authorisation of resources Users allocated access rights to various resources users have access to certain files folders only Files can be password protected read only users can access the network from certain terminals only certain times of the day only use of digital signatures 1 per max 6 6 Example candidate response grade A Examiner comment A good discussion as asked by the question stem with five suggested techniques to address the Issues 126 Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate response grade C MES e M Rt deh by 0 x the pa rey ag di aim E Or Users tUe Ai Saige de Server ar op kata Confidential data going out of the Sewer Examiner comment A clear attempt at a question which started with the keyword Discuss and three relevant solutions described Cambridge International AS and A Level Computing 9691 127 Paper 3 128 Example candidate response grade E Rohe An olan em PCIE BC as ct ss MAMA ps stole Hac Same ce m ELT Aa best oa iem and end Kerne Cop ades at asit fe eene NORIN far ste a Sdn DO Ls bae re Sons Abonos eat ORE Soa sinh tha tag sk eas ops
78. aminer comment This is probably the one question on the exam paper where a grade E candidate matched a grade A candidate Question 7 An interactive computer system in a shopping mall is intended to give information to customers Discuss how the use of colour layout and content will influence the design of the human computer interface HCI Mark scheme Colour Colours should provide suitable contrasts should be meaningful e g red for danger reference to colour blindness epilepsy Layout should use whole screen important information in top left hand corner centre of screen big buttons for ease of navigation similar content grouped together consistent layout when moving from screen to screen Content must be relevant must be understandable must be restricted so no information overload 1 per max 2 per section max 6 6 Cambridge International AS and A Level Computing 9691 d Paper 1 34 Example candidate response grade A b asta atus a ML twill Jas xad Ld ap Layout Law gud hd dela The nnm dag patena o S24 a6 0 fat lt md 344 magi a ETNT TS Tt Over ubttda a bern Ae t p md Bud Gaga ee c Contant Viren AL iind ae palatal pos re ber God tl wand ac ras er ud ahat alo net dh Lalie be LETU A eaea ard caet Aul d be a eeaeee AVETI S d hen dione Te t 8l dia HC caede will net dew Tht of
79. and I have agreed on these objectives Through these objectives I got a clear direction of developing the new system using my programming ability Examiner comment These objectives were signed and agreed Entity relationship diagram According to my investigation of the current system in J X Real Estate I start to design the new system from following Entity Relationship Diagram From my observation one supplier can supplier many flats and one buyer can buy more than one flats so the relationship between supplier and flat is one to many and the relationship between flat and buyer is many to one Therefore this ERD is already normalized Supplier Proposed File Record and Data Structure The following three tables will be used in the new system and the details of data information are listed as follows Cambridge International AS and A Level Computing 9691 145 Paper 4 Computing project 146 Data Dictionary Supplier Table Field Name Length Validations SupplierlD Primary String 10 Presence This is the number to identify each 0019363422 Key Check Supplier uniquely CompanyName String 50 Presence The name of the company which J M Real Estate Inc Check supplies the fht Buyer Table Example BuyerlD Primary String 18 Presence This is the number on buyer s 330283774612723423 Key RN Check ID Card to identify each buyer uniquely Check supplies the fht Check contact the buyer PreviousA
80. ark scheme i Digits in ID are used as input to arithmetic algorithm Result is the location of the data or pointer to it ii When 2 IDs hash to the same value Locations read sequentially from clash until correct value found or free location in which case error Ora linked list structure stored in overflow area with tag or pointer to it a second hashing algorithm is applied 1 per max 3 per dotty max 4 4 Example candidate response grade A i Explain How hashing could be usad ta acces the member file randomly Alas te dene tA moda mess iwhece he date Pe the odde ubere 1t 78 AU ane A qp ahanedlz on ET data ath s eee a member Ira kamit Hee Lg sean x c Add ttt the fila acl sob egt Exemple a Y ASERAY so SEPA 3j upuld be UO nich Ts4dhe ad deto de aaa M Wien ihe memes file ls accessed using hashing clashes can occur Slate what is meant by s clash and how tican ba deat wilh A cla craic heroe oe 0039 a insana cbr Eit M Toren ae a Meadh x aa Examiner comment The candidate gave a very good example of a hashing algorithm and showed clearly how an address can be calculated from the ID digits There were almost enough points in part i to gain full marks In part ii the candidate explained clearly how clashes can occur and how the problem is overcome using the next free space The candidate covered more than the necessa
81. ate explanation Examiner comment of success or failure agreed A full discussion taking each objective mentioned in c i and explaining the degree of success in meeting them indicating where in the project evidence can be found to support this or giving reasons why they were not met 11 Evaluate the client s and user s response to the system 3 marks It is important that neither the client nor the user is assumed to be an expert in computer jargon so some effort must be made to ensure that the system is user friendly It will be assumed that the client will have considerable knowledge of the underlying theory of the business being computerised Clarity of menus clear on screen help and easy methods of inputting data are all examples of how the system can be made user friendly Here marks are awarded for the degree of satisfaction that the client indicates in the acceptance procedure Could the system or its results be used Was the system specification achieved Do any system faults still exist The candidate should evaluate the client s response to the final version of the system It is important that the client and the user become active participants in this section and that their responses are reported and evaluated by the candidate Cambridge International AS and A Level Computing 9691 189 Paper 4 Computing project Example candidate response Garden Centre Client s Response O le 23 mars 2011 Ref Database devel
82. ationm school com Website http www m school com To Whom it May Concern I have tested the programme C P has devised for our POCs reporting system and it works I have also seen the implementation plan and agree with the proposals Examiner comment This letter was on headed note paper and signed by the client there was also a completed questionnaire see below Dear Mrs H Below I have put a questionnaire to collect feedback about the system experience and the discussed installation procedure Please answer all questions if possible and provide any addition notes if you feel it necessary At the end please provide your signature to confirm that you have read and completed this questionnaire Cambridge International AS and A Level Computing 9691 Paper 4 Computing project rimus Nb m problems with the Login form Ludi IN NN problems with the Menu form No a ME problems with the View form didi problems with the Create form a Did you have any complaints about the overall design or layout of the system Does the system provide the users will all functions necessary to POC students effectively 7 Did you have any skill based NJ o a problems when using the system Pd Do you accept the installation Staff and implementation plan Do you have any outstanding questions changes and or comments about any part of the system or installation plan End User Si
83. brief a description of the origin of the data to be used and but covers all the points some indication of the form that data takes required i Investigation and analysis 8 marks This section is the systems analysis he candidate should describe how the client requirements were ascertained possibly by long discussions with the users question and answer sessions should be recorded and outcomes agreed A clear requirements specification should be defined Alternative outline solutions should be discussed and evaluated against one another Cambridge International AS and A Level Computing 9691 tog Paper 4 Computing project 136 Example candidate response Sports Day Investigation To obtain information on the current system how it works data inputs and outputs as well as knowing what the new system will need to do it was decided that key members of the staff who work with the system Interviews will be conducted in order to obtain this information and discuss directly with them what it is they want the new system to do Questions on the how the system works will be asked what the system needs to do any current problems the data used and any useful information relative to the system The first interview planned was to interview the head of the school s P E department Mr F Below are the details of the interview the questions asked and Mr F s responses Question 1 So as you know every year there is the sportsday e
84. c fibre many fibres contained description fine glass strands carry light signals optic fibre is very fragile Interference free Wireless communication Radio signals open to interception latency uses WEP keys for security Infrared Microwave restricted by line of sight transfer rate statement range statement 1 per max 8 8 Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate response grade A Teisted copper pa cable in used ho trans Lent iii s hl o Ja coer A picke np mise she mede ic lowest Copper callo s alad as ES P bie Le ed iS IS Be Ont cables oe aps ui Ar he User h x QUO around Ld n Me ince 3 3 briunicokon Beta Bed Mere 16 imitation fc dhe NUM UNER DTE Hig ioon Examiner comment Not a perfect answer as the candidate should have deduced that 8 marks available should have meant that four media were needed each with an explanation The question brief has been followed with a comparison made of transfer rate and distance Cambridge International AS and A Level Computing 9691 91 Paper 3 Example candidate response grade C yero ag Sake Exits sU NCC CTS S Orilif ien kis orm uns olati be Ns roM qaas EN gs itc bre Chen bul Gocuse ise pules eP Sadako Mean ud Without 52 0 er ic cita ilis ia aem rj ih te aienak E EAEAN aE ana T
85. cending order They then add up all of the points for each house in that age group and fill in the result into another sheet used to keep only the number of points per house and age group This sheet is then used to calculate the final results of the day total number of points per house The total scores for each house as well as any new records are then outputted What works well what doesn t The data capture before the event all work very well The sheet of paper used for the students to choose what events they take part in during the event the collection of the results is also good the results are timed or measured and there isnt another way that it can be done However the last part of the system can be improved All of the results are filled in on a large sheet of paper making it easy to make mistakes and hard to find individual results Computerizing this part of the system would improve the efficiency of the system making the input of the results and addition of points and searching for results a lot easier Inputs e Name Text field size 50 e Age group string e Points Numeric e Event string e House Text Outputs e Total number of points for each house numeric e Total number of points for each house by age group Any new records string Storage All of the documents are stored on Mr F s computer and in the P E office when they have been printed The result sheets are not kept from one year to another For the
86. cessful the database The system should warn user that no book is left Cambridge International AS and A Level Computing 9691 165 Paper 4 Computing project Test 1 There is a presence check in most of the input forms I test the outcome when I input Student Name and Contact but leave Student ID blank when adding a student into the database Similarly other input fields will produce the same warn messages when user do not enter anything into it Main Menu i Reserve Student X nam aac ipee R eSnips ly StudentiD 4 Add To Database i POSER nnn ED NENNEN NNNM EPP E StudentName iMichael Delete From Databse Contact 1 3601982736 Search And View RNR ATANT Clear Test 2 There is also a format check in all fields which only allow numeric inputs The system should not allow any non numeric values to be entered into the fields I tried to enter a non numeric value into one field and the system failed to response in the proper way SiudenilD lasdfasdf l StdentName After a deep consideration of the problem I added a code into the project and solve to problem The code is also added into other fields which may have the same problem 166 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Test 3 The last input check is to check a particular value of input It is the number of a book Th
87. cher comment a full user guide with all options included but descriptions could have been more detailed All but one or two options fully described for example back up routines not mentioned In the main the options are easy for the user to follow with screen displays clear user guide with all options included but description lacking in places e g backing up to a USB drive possibly as booklet with an index and a glossary No omission of any of the options available including back up routines guide to common errors Marks may be lost for inadequate descriptions of some options For full marks good on screen help should exist where this is a sensible option and be present in the form of a hypertext document A full user guide with all options described well presented Examiner comment Cambridge International AS and A Level Computing 9691 187 Paper 4 Computing project f Evaluation 6 marks i Discussion of the degree of success in meeting the original objectives 3 marks This discussion should demonstrate the candidate s ability to evaluate the effectiveness of the completed system The agreed set of objectives should be matched to the achievements taking into account the limitations Client and user evaluation is also essential and should arise from a questionnaire or preferably direct evaluation For full marks it is important that the user provides sets of data as they are likely to occur in pra
88. chlorine MIUFRUEBRHESHEREUSGHERSERETMEGS mium iom m om penal dom Be om el om hen 3 are bus ie ee m epum Be ee em mnie miram ema em miu miu meer en om mim min mper eina e E nm peng eb eed ird emm EP LRL E When a purse oike Lj read a wed b rn minii sisi tr To on a I well uela Hye madioamn ponlble jeapacil Examiner comment The candidate knows the names of the three main buses but is unable to give a clear description of two of the three Example candidate response grade E F 1 Y CELAT ridi s m u f n E T uius m es wom om ech oom ce com Bo om el do cll ad T ET ETETE EEIEIEE od fe ed BiBi ia mk ee See ee ee cx md em NN IET M MEINE BIRABLJISENEAIAERENUIBEEF EUEn iod mimimiuuinsuimirimpesubdbimemiesnininemdasnbasniniEanP ed RR iniiRiPIBPCIBARRRERREIRIZIRISIGETITITEREITIT 6j i Eel cd Rond d non Ro R B RR m cR RE RR Examiner comment The candidate knows the correct names for only two of the buses but is able to describe only partially the use of these Cambridge International AS and A Level Computing 9691 83 Paper 3 34 Question 2 a Explain the relationship between assembly languages and machine code Mark scheme One to one Mnemonics are used to represent operation codes Labels are used to represent memory addresses machine code is binary codes only assembly code can not be executed machine code can be executed machine code and a
89. ctice and that the results arising from such data be taken into account This data is typical data rather than test data and it may show up faults or problems that the candidate s own test data failed to find Example candidate response Garden Centre List of user objectives as found in section C i 1 The system must be very user friendly for the Buyer 2 The system must deal with the inputs e Family Name e Species Name e Variety e Date Of Offer Price Offered gt Supplier Name Bare Root e Root Ball e CLT e Height e Circumference Photo e Additional Notes 3 The system must be able to store many offers records keep them organized and easily accessed 4 There should be the ability to edit offers and delete out dated ones D The system must save them time over the old system 6 Similar offers as well as unrelated offers must be able to be entered easily without the need to retype a lot of data T Offers must be able to be found quickly to provide immediate feedback for customers Evaluation The following table evaluates the user objectives discussed in section C i and gives examples of where the evidence can be founds Evaluation 2 Z jEvdeme The system has been made as easy to use as possible Hopefully anyone Design pg 31 33 can start using the system without any training however basic knowledge of the business is required The input form has been sepa
90. d and leading on from this is then willing to write a letter of acceptance of the system including any criticisms of it In this way students can be encouraged to look beyond school or college life into the businesses and companies in the community of the surrounding area The emphasis is on analysing an existing system and producing a computer based solution to fit the needs of a client At the end of the project students should submit a concisely written and well laid out report which should be word processed The solution must be implemented using a programming language and any of the following that are appropriate e pre written modules or toolkits e applications software and programmable packages Cambridge International AS and A Level Computing 9691 129 Paper 4 Computing project 130 Very brief descriptions of any programming languages or software packages used together with reasons for their selection should be included in the report Choosing a suitable project otudents may choose to solve their problems by either the use of a software applications package and or by writing their own program s The exact method of solution will be the choice of each student but the teacher will need to ensure that all options have been covered during the course so as to allow the student maximum flexibility in their choice of solutions The use of a specific programming language is the responsibility of the school and will be dete
91. d to be mada to the pseudocode t i Fig Sear Foi FAA Powe Tae gt ee vam Ik E ue je eb bn ine rrr rere M rid ad JECTED dia bbidaRPdARREPARRIRIELTISERAGETITIRI 13 EinbegrinSEITS EFIE RHEE RELIES Ltt Be oo oe eee Ss ree ee eee ri m mha m mpa eee Examiner comment There is a good understanding demonstrated in part i It seems a pity that the ingenious ideas in ii will not work though they show that this candidate does appreciate how the program works Example candidate response grade E i What eS if the parameter passed EE EN NE Quipuk NL une Pn jean Lou MAI sec aa bb Eip red ee n pia nc wit tlt lee Wa ay Prod eo sa rai NM A a M bia Onute midek Ot dhhil i A bis Bis dhf ji Wich ig impiae udocoda tu address the problem in i What changes will need lo be made lo the pee pi D Aetat i ot Aie fg WAL ue alU Lolo nsiditta disp ARM ti stp o T ce TO atm prod A an 2 v ENLACES AER SNR 2 Examiner comment This candidate has some idea of what happens in recursion Many who answered 4 a correctly could not answer 4 b Cambridge International AS and A Level Computing 9691 Paper 2 79 Paper 2 80 Question 4 c Rewrite this function in pseudocode as an iterative function Mark scheme FUNCTION prod n x 1 FOR i 1 TO n x x i NEXT 1 pud Xx ENDFUNCTION RETURN 1 mark for initialisat
92. ddress Presence The previous address ofthe buyer Room 1 NO 3 Check is used for mailing or fnding the J M Rd buyer P0 Box 2 Sichuan Flat Table Field Name Length Validations l Key Check fht BuyerlD Foreign String 18 Presence Foreign Key Originally occurring 330283774612723423 Key Check when in Buyer Table This feld is left the fbt is blank unless the fbt is sold sold SupplierlD Foreign String 10 Presence Foreign Key Originally occurring 0019363422 Key Check when in Supplier Table sold Check Presence The name or number of the M Building or F53 BuildingNameNo String StreetName String 30 Presence The name of the street where the Grand Garden Road Check fbt is located Square meter UnitP rice Format Check Price per square meter of the fat 10000 IN eme TotalP rice Presence The total price of a fbt It equals 970000 Check unit price multiplied by area Availability String 10 Presence This is used to show whether the Available or Sold BE o Check fbt has been sold The system will automatically generate the status of the fht Data input forms All data enter the system through following input forms so the user doesn t have to access to the database directly to save data All the forms contain input fields and button providing a user Cambridge International AS and A Level Computing 9691 Paper 4 Computing project friendly interface There are totally four input f
93. de C ouant a l 08 palnda DE mug ha dado is Tend unugh pon hio Ihe m P e Biorluce a bend which vtenbelt dida bo cerieed Output 2 iplis canke used of He paid osale oe endo ea meak as mob a AQMD prar spon ber S4 onda were SM om parfialox ptis 4l Output 3 Ter optpot CAD ha used hb anae dha gaa FF bed token A Ja sendomos ull he prid on A paper duing chuc idan a is deter le Examiner comment The candidate correctly knows that the question required output types and gave audio in the form of a beeping sound then found it difficult to distinguish between output device and type of output and came up with the answers graphs and texts Both of these were throw away answers It is common at grade C level for candidates not to understand the subtle difference between output device and the output produced by a device Example candidate response grade E lko verdad ak e m 8 vale hac eb Output 3 UE nud dae SD EA Examiner comment A typical grade E candidate finds it difficult to distinguish between output devices and output types This candidate s answer was typical of the confusion although they did suggest a print out which gained them a mark Cambridge International AS and A Level Computing 9691 Paper 1 Question 1 d i The management of the supermarket use a number of different types of software State what e
94. de C candidate Nearly all candidates at all grades answered these two parts correctly Cambridge International AS and A Level Computing 9691 77 Paper 2 78 Question 4 b i What happens if the parameter passed is 1 ii What changes will need to be made to the pseudocode to address the problem in b i Mark scheme i cannot end infinite loop produces error message heap stack overflow crash 2 ii Before second line extra code needs to be added If n 1 OR if n O then error or equivalent 2 Te hochon id Kaper olla lil Hy ne Pad n i AT P bgal d End so s be a ad Ten th 38 400 4 EIE TER ke 2 ii What changes will need ta be made to the pseudocode to address the problem In tiq an Cte duco Aral toe se ia C i L odi ling Te nezo MEO wi bti AN Example candidate response grade A i What happens if the parameter passed is 17 CTRasadd RRR RRS ETET Examiner comment Both parts have correct answers that show good understanding of the problem Cambridge International AS and A Level Computing 9691 Example candidate response grade C i What happens If the parameter passed is 17 disell prodate on 3o foils AOI uns ug nee S Fa TN St emp adibo kd wel nare be EPHE dii BEI PS BPEL Ee ee TA SPEPSEPEH FELIHTEPISSEFEPITEPHEEPPESEPUTEEPUIREPIS PEEPHERBHIEI H ii changes will nee
95. dressing ENG C MECNCNECONCS NC E NR casis Ae Pies in Ke AR u e Wa WEN hund Sees t it Indexed addressing em Diana Re m s Se Xs E E Tex pe is i Mes uu MP TO I D A iSESPISERSERASERSPIEPdSEISFIBPEREERIPISERSEIdSSRISPRPSPEdBEPSRPGCeE Ce eePRePTeCPTEICEEITEIBERSERIERAEISE HEELIEIBEBRARAAdG eI R1 l iil Relalive addressing mes no oe on aca m SE LE LE TE a as a a dd b a a Med d doe acid rds cos cdd dicia tes Dots tee tl eG ee ee en te E VM Es abo do bee Or Poe Rowen Ri did fee el eer Pee ma n eee fe om 8 8 S04 X om oe 831 Higa Gia hide He A iaiia janna om me ee m gos m me om em em G on g oman g o on g on eg ibm me me em om mieu acu m pod poa go ee om REP REEBRUGERTZIAOEAELALAEERGL Examiner comment Part i This describes direct addressing not indirect Part ii The candidate has remembered that the Index Register contents is used for indexed addressing The candidate has gone on to say that the Index Register contents will be incremented which may or may not follow and this has been ignored by the examiner Part iii Not attempted Cambridge International AS and A Level Computing 9691 Example candidate response grade E i indirect addressing L Jpaapung Mnt drea p DT pe ee ie i ee ee eee ee ete erate ete tee ert eet te ts mg HR An gm n ca p e ge n rderiussrigdpiaEskidkkbidbbem4idbke4ejeebt ep eei rami mpm mii ed mi
96. e grade E State the relationship between LEAGUE and TEAM TAT A a ER IAEA dpa DLP fone oe Gn Bis Rectal oll Bi ne Draw the entity relailanship ER disirgram ta show this relalonship 2 ltl Explain how tne relationship between TEAM and GROUND can be designed in Inird narmal farm l Errand i i dom rota PRO safe asen maa i NI A O n a err dA Ei ai Lace o e ce ROM seen EA M o mte aur decet BM eene is dins MMC aile a EGER Tr eo re me EE Im Meer err deret err eere render Ir TW TRIP N A E Examiner comment Part i A grade E candidate should be able to draw on their practical work with a relational database and produce a correct statement and diagram of the relationship and so score full marks Part ii As above for i Part iii The candidate has worked out a third entity will be required but the detail is wrong including crucially the new relationships needed This is a weak answer for part iii Cambridge International AS and A Level Computing 9691 121 Paper 3 122 Question 11 a Describe the differences between interpretation and compilation of a high level language program Mark scheme Interpreter translates one instruction runs it before going on to the next Compiler translates all the instructions before run Compiler creates object code executable file Interpreter does not Interpreter makes for easier debugging Compiled programs will e
97. e grade E b Raul wants uppercase A to be counted as well gs esch lower case a Re write line 4 af the pseudondde sn that every A ig included in the court i Word Cds er TL earn oan iaae TET BEGEREIBEAEYdERRRIGERAERARAAEIRAALEARRIRRAARRABAREIAERALIARIAAERRERTITET ale Mns Ce s A uu a Che Gewnl pon Examiner comment Using an else in this question was common among grade E candidates 66 Cambridge International AS and A Level Computing 9691 Paper 2 Question 2 c i The pseudocode has features that make it easy to understand State two such features Program code is to be produced from the pseudocode ii State one other feature that could be introduced to make the program code easy to understand iii State two reasons why it is important for the program to be easily understood Mark scheme i meaningful variable names indentation white space structured English good formatting lower case upper case reserved words are capitalised In capitals 2 ii Annotation comments 1 iii to make it easier to find correct errors to make it easier to modify the program maintenance 2 Example candidate response grade A i The panci has fealures ihat make it easy to understand State two such ii State one other feature that could te Intred cer to make the pogam code many to undarcsisnd T nome in UREN i Ei 1 nu fart PP ee ee ee ee
98. e Family ID Assigns a unique ID to the family name Text Stores the family name Tblspecies Field Name Assigns a unique ID to the species name Stores the species name Tblroot Field Name Root_ID Autonumber Assigns a unique ID to each bare root Rot root ball CLT combination CLT ID Number Integer Links to tblclt Tblcit Field Name CLT ID Assigns a unique ID to the CLT values Stores the CLT values Tblheight FieldName DataType Use Height ID Assigns a unique ID to the height range values Alphanumerical Stores the CLT values Tblcirc Field Nam DataType 1 Use J Circ ID Assigns a unique ID to the circ range values Circumference Range Alphanumerical Stores the CLT values Cambridge International AS and A Level Computing 9691 179 Paper 4 Computing project Section References Most of the sections required for the system maintenance documentation already occur previously in this document Possible Adaptive Maintenance To further improve the system future work and updates could include Connecting the database to the internet e Connecting to the database via a smart phone e Better sorting of data in cboclt cboheight and cbocirc on frminput e Use an input mask on cboclt and cboheight for added data consistency e The ability to sort records on frmmain by different fields e Have the ability to decide how to sort files on a report
99. e from which the next new value would be allocated to a location Part ii The standard of answers for this question was particularly poor and this answer was a rare example of a candidate who was able to describe the algorithm They have the idea of needing to check for any special cases and the use of identifier names FREE NEXT PREVIOUS and HEAD to refer to particular nodes Example candidate response grade C i Draw a diagram to show how the following members ol a Conpuling class can be Stored imn a linked liat m alphabetic ordar FRO TSI DON ROS BEV 7 7 Cambridge International AS and A Level Computing 9691 111 Paper 3 M Deseribe an aigorilhim la insert a new member of the dass inita the correct position i r hy ireport on ror p Slap pore We hew member quits movers nhe list Ro ait the golnter of the cel les fan e wem volug of Pottek Insert fre dado ten mmmzumcilacmmum n l m meum uso M Om NUNC ZR eo La Ee Pee eee Pe Peo Amo Ag cell fined by le TREE fomave this Tirra g pin te die lah ELZRLLALLALIE LIELLS LEE EL LL Meo added Remove the pointer PotwTEg Oe ee eee reer ory connect it do dhe cell dheg He new eh wlth haar value Cn WI 112 Cambridge International AS and A Level Computing 9691 Paper 3 Examiner comment Part i A grade C candidate should score well on this question The solution shows the nodes linked together in
100. e Ble ER uebbRGRRRERRBERRGRRBRGGRRRbGReREPGRRER a a a ce ee es es ee ee ee bd edge ae eto idn eo ee a m eiai ice mici aloe rp md ie ed ee ie gd ee ed es Ps ed se ee er er ee re ee ee eee eee tee te ee ee ee ee er ere oe er Examiner comment Part i Some understanding that the DDL will involve the setting of data types for various attributes Part ii Some understanding and the key tasks of retrieving and deleting data Note if only the answer had stated that data is deleted from a database table this would have scored a further mark A good example of a candidate needing perhaps to pause and formulate their answer before they start writing 102 Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate response grade E i Description Language DDL Prescees Ie dest febies their Fr DOMUS T Uo Dec dh ees is teed creer eee Erma e pees been dei ee ee ETETETT 0d 2 il Data Manipulation Language DML QA MU ers take ove tain thee PP SPS SERIE ERPS SE PPS SEEPS SEIS SE Bis dheis Ss bets rides ride Priestess rejp pjata er Ps ppr Pei PE ED ee ee Pee bee sp ee ee TEETE GE esl RR Dkk oh a oak mo om om om om mo ame d oa mu ons aca gi mm sm om Sm Oy ro gcgog geom PPPI eeu ee PrP tg pg ee TAE ee ee biddh So ey ae ee ee ee ee E T i 3 Examiner comment Part 1 A good clear answer to design tables but has failed to give any detail about this for the second available mark Part
101. e Have the ability to decide what data will be included on a report by using a search e Be able to store more than one photo per offer e The system could be made with larger objects and with larger windows so it doesn t appear too small illegible on a high resolution monitor Back Up Procedure Storage Media To back up the system use 4 USB flash drives with a least 4 GB of free space on each e Two of the drives will be used to make daily back ups e Two of the drives will be used to make weekly back ups Storage Media Use The two daily drives should be updated every other day but separately from each other Eg Drive 1 should be backed up on day 1 followed by drive 2 on day 2 then drive 1 on day 3 and drive 2 on day 4 etc The two weekly drives back up should be updated at the end of each week working on a similar rotation pattern as the daily drives but using weeks instead of days 180 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Marks awarded i Systems maintenance documentation 4 4marks Some items are present with some annotation attempted Teacher comment all 3 4 One or two omissions but the rest is present and sections present annotation is used sensibly Examiner comment cross referencing is used sensibly so that all items can be found Examiner comment Candidates do not need to duplicate evidence in their reports this candidate s systems maintenance section m
102. e library rules stated that any book that is inputted into the database must have at least one copy That means the library must buy at least one copy of the book before it is available for the reader to borrow The system will warn the user if the user tries to do so Main Menu Borrow Return Book Reserve Exit Student Report BooklD H BookName Making Gno Number m Author hy Fischman Nation juk Intraduction ew books far Pedagagy a Please input Number Larger than 0 AddToDatabase DeleteFromDatabase i SearchandView Cambridge International AS and A Level Computing 9691 167 Paper 4 Computing project Test 4 This test is very important for the system It is the security check I need to ensure that the password system functions well to avoid from safety problems I tested a few group of wrong passwords and tried to enter the system Only the correct password can let me in UserP ssvord ji ES 0 75 27 Login Alter Password User Name MngYu Password 1234 NS Only one set of wrong password is shown but I tested many other sets and proved that my system does not suffer from security issues 168 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Test 5 I need to test whether or not the user can save data in the database I tried to create a new student record and tried to view it in the database after it is
103. e oa oak oll E E eG At Ba a ed a a eee eS IET TI EPN ETE ee es p z Se eR ert memg acm mea ca om gen om om i me m Rim had medo ei E LE NOR KU roy rs e ce p m rct i m apa ee repo uoi eei us iei aei mio aca ird dna 8 i eig pm hea mmm moo Beni aah Bemis Bec al sR sR blau a a a ee ee ee eee RE ERES i a ee ae Examiner comment A minimalist answer where the candidate has suggested three different cable types There was a second mark available for describing the make up of each one which was not attempted The candidate just gets the fourth mark for describing that twisted pair cabling will have the shortest range Note that stating that Fibre optic is very fast is not a comparison as asked for in the question stem Question 4 a State what is meant by a real time application b An air conditioning system Is a real time application Explain how sensors and actuators are used to control an air conditioning system in an apartment c Give one other example of a real time application Justify why your choice is a real time application Mark scheme a A system in which the output is produced quickly enough to affect the next input current process a system that reacts fast enough to influence behaviour in the outside world 1 b A number of sensors stationed around apartment Temperature humidity sensor sends temperature humidity to processor Use analogue to digital converter to convert the temperature humidity measure
104. ent system Explain the importance to both analyst and manager of defining the problem accurately You should make clear the part played by each person Mark scheme Manager must provide knowledge of and requirements of business as they are expert in how the business works Analyst provides knowledge of what is possible particularly within confines placed by manager e g budget lf not properly defined analyst will solve the wrong problem Manager s requirements and analyst s understanding must match 1 per max 4 4 Cambridge International AS and A Level Computing 9691 11 Paper 1 12 Example candidate response ciii A t nee Examiner comment Four clear points were made here In a well structured response The grade A candidate should make It very clear what the roles of the manager and the analyst are and avoid very vague references to their areas of expertise Example candidate response grade C Te manager must devine Ha problem connect Ja tho a ager knang ahon Upper fondo STER v vodeszan TAY VE hdc Analy tud alra nt toiles tj ame rc pri 20 8 h u56 mi Examiner comment A lot of writing saying they must define the problem correctly otherwise a different problem will be solved The candidate clearly knows why it is important to define the problem but misses out some of the key points for example the manager is the expert in how
105. ent the data is then given to one of the teachers from the P E department to then be written in the sheet of paper so you can see how many points each student has gotten and in what event Then the points are added up to get the total number of points for each house The final form for the data is then the numerical data on paper document The samples are showed after the first interview since they were obtained then This is the sheet of paper which is used to fill in the results It contains the fields to enter the name of students in the position that they arrive as well as a field to enter the number of points scored by the student Cambridge International AS and A Level Computing 9691 Paper 4 Computing project NAME NAME HSE E t i NAME HSE a 1 E a S S B E D B B A E E TF ORSONO TEE DON SE BEE DAE A DOREEN OA DA L A RORE E DNE mp1 E E E E O L AEN DA A O E E Lx 0 OG A A E E N M N a a e pL A S O A S O E TOTOE C NOORE G T E DEOD OE BE A E A O U E 2 i OE R E ERE R E e e e e E 2m E BS A E T DS E E LL ELLA e e erT m p A a r L EL A A A A 7 IL A A Gc e e a e a dO a Sn dO A DE E L E E E wp 311 8 e a EL MEA E E O TE E LA O A T U FH mI O 1 PE LE EA a B B KA S E E Comments Teacher comment description of organisation methods origin of data and form data takes 3 Full description of the organisation and methods 3 l l currently in use in the area of the chosen project with Examiner comment
106. enue ext lc e Atria Wie Lowel a Feat Nono ean rura ida aa qel Hm avril a een tud ens a rl pr merca Shada Hie NEN E E E e EENETI NLE E Examiner comment The use of colour seemed to be understood but layout and content were even sketchier than for grade C candidates E g it should be written top and left in the layout section was correct but the candidate couldn t explain why this was done The answer was often very vague with little understanding of how layout and content can influence HCI design Question 8 a State two differences between a local area network LAN and a wide area network WAN Mark scheme LAN over short distances buildings site WAN geographically remote LAN uses own communication medium WAN uses third party LAN more secure WAN more open to attack 1 per max 2 2 Cambridge International AS and A Level Computing 9691 2 Paper 1 Example candidate response grade A 1 KON sues on A Pe TERIS wi BONERS D e sain mas nto Mrs c M a SY eS 85 8L OA Os eu n e bo 2 ARA vi ase ii c 9A Pers du 9 im WEP AS O mee D LAN sirens Examiner comment It was rare to see any good answers for this question with very few getting full marks Even this answer is not that good Generally candidates even at this level found It difficult to explain the difference between LAN and WAN and didn t realise that some implication of a huge geo
107. er Example candidate response grade E VN sai aos VE Site ai Jd sti Rene anb ep dips d saat 2 Examiner comment The use of mnemonics was expected as an answer for 2 a i However the mark scheme has allowed this mark to be available and credited here for ii Question 2 c The address part of a low level instruction can be the address of the data to be used This is a direct address Describe the following types of addressing i Indirect addressing ii Indexed addressing iii Relative addressing Mark scheme i Address in instruction is the address of the address of pointer to the location which contains the data to be used 2 11 Address in the instruction has added to it the contents of the Index Register IR 2 iii Address in the Instruction is the displacement from the address of the first current instruction the value is added to the PC 2 Cambridge International AS and A Level Computing 9691 Example candidate response grade A 90 amp the chon Of the adem of oala bidi Li ba db Bldbad E msdhb maa maia d lacia B mmcH m aoo nd Rm RO Im m2 aoa simm RH Bon SR DR Ro ROSE OD CHORUS N R CR SE m e OON DH ONU ES N ROS HS EEn OH RS RS SOON p Pi wed fo guts oitu OF rementi Hat oce not ends Ael s IBEAAGAGE ER UARLEE Ld ae kbbi i Meee Erin lal di ein m ird on enin i eje ge ee rnm rn ert g eee ee ee ee eee 2 i Indexed scdcdrassing TT
108. ers Example candidate response grade C i Whal form does an ASCII code take nnn e LL AR Hem Batu mie 0 nemus M dr d 1 i Describe how ASCII codes can be used to arrange wo lower case stlers in alphabetical order ABETE eec cm n ten b alla arba en NENNT N NET CN Beane AA ERR ac A TRIER inni e duran et tl QI am Hon dim due ee MET NES ee NE ONE DEOS Aa a ee ee ee a i itl how two Words lower case letters only can be srranged in alphabetical order EE NTC al vba tbe E lilac fy di tanta Be cepe en dun eade a PE i MS ye dete laada then fiene io nhe Me Rb aedi oe US int han RIO axes rd a EXER agea Met anale ipla zi dale a a es mde erum M b Ide cnn ll e tn c tone a M fe Tr Examiner comment Part i is well explained In part ii there is evidence of some understanding that ASCII values are compared numerically but the statement of what happens after this comparsion is not clear Part iii starts correctly but explanation is not followed through Cambridge International AS and A Level Computing 9691 71 Paper 2 Example candidate response grade E i What form does an ASCI code lake Bescesss d ATS ee eee et Bia asse ee seas meena Taser biiidBERII4SPRRISSPEPRIHASERInaunbladambidu mEurbrimtutrbmitisiis idERFIdEREARAARERSRRRELIAGG li Describe how AGC codes can be used to arrange two lower letters in alphabetical order m R
109. es jety Text Box The variety name of the plant is entered here Cbosupplier Combo Box The combo box is filled with the supplier name values from Tblisupplier Txtprice This is where the price of the plant is entered Txtdate The date that the offer is made is entered here Optbareroot Option Button If a plant is bare root the option is selected here Optrootball Option Button Ifa plant s roots are in a root ball the option is selected here Cboclt Combo Box The combo box is filled with the CLT values from Tblcit This combo box is only enabled if Optclt is selected Combo Box The combo box is filled with the height range values from Tblheight Cbocirc Combo Box The combo box is filled with the Circumference Range values from Tblcirc Txtnotes Any additional notes that the user wants to input can be entered here Cmdphoto Command When this button is pressed Cdcphoto activates and Button allows the user to select a photo to be input into the system The URL of the selected photo is then saved here Imgphoto Image A preview of the selected photo after clicking Cmdphoto is given to allow the user to see if the correct photo was selected and if the format 1s correct Cdcphoto Common When Cmdphoto is clicked a window pops up that allows Dialog the user to select an image file which s URL is saved be s lt s Cboheight Cambridge International AS and A Level Computing 9691 Paper
110. es bu ms s aicnmslcm clon ci c8 c cn Roc cn nc cn om o B cn n Rc m Rc cR c4 cR Rc R cR m BOR cn m BOR m 88 cR Rco B c4 cR c lm ee B 8 cR Rc Boc Rc cn Rc cR cR Rc B cR n Rc cn c B cR RooR R cR Rc cR ee Rc cn ocn Ro Roc cn Rc c4 wc B cm m B cm wc o B cR Rc cR RC A c UR c n Examiner comment Part i A good clear answer probably the candidate has had practical experience of the use of SQL Part ii A good clear answer again probably the candidate has had practical experience of the use of SQL Cambridge International AS and A Level Computing 9691 101 Paper 3 Example candidate response grade C I Data Description Language DDL DDL ved by data bere as eee ee eee nd ee ee tei Lie ie Premi mm ee schon e ne om mam a oe m ee a ee om ee om ee oa eo nmg Debes dhe dala 1 du diuell abu Poros eee es TIT CPPS ee eee eee eee ee ees eee ee cme m cm cm mm ca mm mm mo NR SON Eg HS 8H Ra e ge rimuugNFTTI S ILETIZGALFIAJELIASERIAJSEEFRIERIGSEERIASERINZIEAGIAZERIAZERIENERELAZERERAEE EIARBEERIAEEERZRE GE a LIE Rp INLINE RE LRL ELI eiudsRRPEuSBRRRRPduEemRPPbueRPEeRPPUeRDCEECED I eed Sede eid ids wis Ss bebe Pde eri Pe Pe ee n ee ims ii Date Manipulation Language DML m TECTITI E A ACAS fab bide D e Ba ae E Lig rade ia ie PPS Spe Pe Wes te AME v Mi n ee i ia et re re ee eer tee torr reer ee ee ee e acm m a a om n go gom m rs age s di Ferrie Best Rl ee ihe Bb me food om om fie oem ee eeu pr
111. es produced similar answers or did not respond Cambridge International AS and A Level Computing 9691 81 Paper 3 82 Paper 3 Question 1 Name three different types of bus in a processor and state what each is used for Mark scheme e g Data bus to carry data from one location to another in processor e g from MDR to CIR Address bus carries the address of a memory location e g Address of location in memory from MAR Control bus Carries control signals around processor to synchronise the operation of the processor components by example memory read write completed each line carries a different signal Accept system bus memory bus firewire USB PCI explanation 2nd mark is dependent on correct bus name 2 per max 6 6 ae candidate response UT A cael DP kk He soe om n mi eal i Ej a IPINI ETE i T PI PI E a a ic ook ih Goal ok i Gl i EE arian ee ee ee ete te nl tonis Aw _ fom mond E e Gg uit b ME Be Ads 7 a using DET os Ui Examiner comment The candidate is able to name the three common buses and follow each with a clear and detailed explanation Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate response grade C 1 Qenlktl b p EE TREE ee ere ree rra Dui y i CR be caued dbollichitdss xci y Meer eer car gni pacc ie c LH may conuat Of gE X The wellie OF dhe dale dua ia atg ducl s j
112. etimes scored marks for ii in their answer for i and vice versa 100 Cambridge International AS and A Level Computing 9691 Paper 3 Question 6 Describe the purpose of the following parts of a database management system DBMS i Data Description Language DDL ii Data Manipulation Language DML Mark scheme i language to describe alter table designs NOT file includes Identifiers data type relationships any validation rules that the data must adhere to 1 per max 2 2 ii designed to allow a user to query retrieve data sort the database insert delete update data in the database table s 1 per max 3 3 Example candidate response grade A i Date Description Language DDL sew getty Seconda envie Keys DAAEFRREPRGEE ii Biei E i i D a a RambRPdguERPdHbaumRGERERGSRRG RRGdnPbASRRGRRamEPRRRPGRRGERR REGdRRRRRRESRRARRAHRPERRRGRPRGRRRGRERERERAGRPERFESRPGRRIRRGR cmm Rm mm Be Rem ma Mo cm mco RR CORO SR ORO R CR A icm m biie idhibh R cm mco cR cm R c4 Da he cR Rc R cm Rc R c ca Reo mh BOR SR Re 4 c Rs s Rm sc RR s OR GR d OR s b io biim man ee GS f OR SR RC MCOM NC RCHR RE ROO ORO GO OW ii Data Manipulation Language DWL i DltnaiS X at tnssnrnnnannsninssnsnine ae en eee ed Sa UR 4 0 o AR M ot E T Mta Gig PiERSHRRGPRGaGRRAPERRRRRGERRGPPGRPRRRRERGRERGSRRRRPRBRRRRRRRERRARPRASPRRRRGSRRIREREREEAREIGRRESRPZRRERRRRZREPAHERAmPRRREGmjuePkrGREaSeEPE pe
113. g VB 2005 STRUCTURE JobRecord DIM JobID AS Integer DIM JobDescription AS String DIM Price AS Decimal DIM ExpectedCompletionDate AS Date DIM Paid AS Boolean END STRUCTURE e g C struct jobRecord public int JobDID public string JjobDescription public decimal price public datetime expectedCompletionDate public bool paid 1 mark for heading 1 mark for structure 1 mark for all 5 fields correct 3 48 Cambridge International AS and A Level Computing 9691 Example candidate response grade A Aven aM Side Code Mis class elt EL dette abr ebr mir miapitniut nium remite eminent mmi mre b aimaciurbadestiambimRisbigeium imi meia ma CELS EE TETE TE TETTE ff bee beeen BLE I Pe ee prn es me mia e a a e see Pee fe Fe a er ES 3 LAELBHEFPITERE Me WS la Meso Me OD od SM IGRGERGERERRENLGERERGERJEG mici d sin cic m dd d m ecd oc os a ion ioca com on ande com cm c di coca mie oo c e c m ms Examiner comment Java is not explicity given in the mark scheme The answer is correct and the candidate was credited for this It is very important that the answer matches the language stated Example candidate response grade C mU TERUTEGUTSGPE EGG WUPPNNNENNWEELIZZEDIQJSERIQSERISERBHINBEEISSBERERFHSEFISEFPISERPIQHEFISR EFHHSERISHERAS EFI Hui irivi di iid inb il inii dbi ini eR no d a ba din OK A or waltliemm ss n Hir Li _ Oe Ld Tu Sm mm m aa auem aom m aga E PP PP EUCEETPIUEEFTIESSEPPHEFPIFTEVIPRUEIS
114. g SetFocus txtavg pocrecord AverageMark txtcomment SetFocus txtcomment pocrecord Comment Ibiprogress BackColor vbGreen End If Cambridge International AS and A Level Computing 9691 163 Paper 4 Computing project 164 Marks awarded 1 Development 4 4 marks Comments Program listings or evidence of tailoring of a software Teacher comment package is provided in the form of printouts The developed evidence of tailored solution does not fulfil the design specification A teacher software package may award 1 mark if they have been shown the system data structures I O working satisfactorily and there is no hard evidence in the processing and code roject report prol P Examiner comment Program listings or evidence of tailored software packages clear development that are provided in the form of printouts Data structures are matches the design illustrated as part of the listings where appropriate detailing their purpose There is some annotation evident to illustrate how the package was tailored for a particular purpose or to indicate the purpose of sections of code in a program listing The developed solution has logical flaws and does not fulfil the design specification Program listings or evidence of tailored software packages are provided in the form of printouts Data structures are illustrated as part of the listings where appropriate detailing their purpose There is a full set of printouts sho
115. gnature Marks awarded iv Installation 3 4 marks Comments Details of system changeover have been documented Teacher comment some evidence of client and or user testing is given implementation plan usually by questionnaire or written comments by fellow training user testing students or others who were not directly involved in the changeover development of the system E l Examiner comment the An implementation plan with details of systems evidence of user testing changeover and training required There is written evidence is not sufficiently available from the client indicating that they have seen the detailed for 4 marks system in operation A clear and detailed implementation plan including planned systems changeover training required and detailed stages of user testing There is written evidence available from the client and or user that they have tested the system and agree with the strategy for implementation Cambridge International AS and A Level Computing 9691 173 Paper 4 Computing project 174 e Documentation 10 marks i Systems maintenance documentation 4 marks Much of the documentation will have been produced as a by product of design and development work and also as part of writing up the report to date The contents of the guide should where relevant include the following record file and data structures used data dictionary data flow or navigation paths annotated prog
116. grade E what is meant by tha spooling of files M y a co Mata don Sdn NES re ed ai den prs dank abd ted ann fh Simp chus alien S p es ee ee ee 0 a Describe b i State why spooled LEON dbo Dee Dep all je Bal S NN CR Ts To dito ben Senek ai Ww Ibm died EREFRSHBBRISBRRIBBEDFRISSSEPFEIBSHEERIJESEERLIJZEZEERLIZSELEIGIZEEREIJSAJILLIJSNELIEZSAIEENRAHZENEPPEEENWPIENTFENFFIHENEFIENUFPEFEEWLET ELE les which are seni to a shared pinter on a local network will IERARHI ETE hminm rbascurkrimmmrindurkmririmembrimumenrbriuummbrienrpimmebrdcrn Explain how this spooling is carried out cef 4 ee CT ena Sfosape 3 aee ABNER anse hen BAED DER noceat nn EN MPO USE ne gis e Queug oan le BB lh ki E c AEEEPRASERK ND E A EE dambis ee be dd BE BS dd Bee d BB BE Be SB cm us s uas momo m Ws B R o Rc n B Bo cn cn n BR 4 I n Rn ee ie Rh lead i eb mt S LILLLLLL ee et es GUEPTUIPTUOEFUETE 5 BPE GU am om em CH SOR om om cm mm om DEE M UOS M CS CA D ROM ACC a mg om om om ks ac so dn BO Gb Du Fg cs Bak P Rue Bet P Ga E ERE HEEL Examiner comment Part a This candidate has some idea what is meant by spooling but is unable to answer the question set Part b A minimalist answer However two correct key points are made that the files go to the hard drive and are managed with a queue data structure The marking of this question was flexible as candidates som
117. graphical area was needed in the explanation Example candidate response grade C wort TD ant mer EAS ATT NES nS Be Pa buds Mi ANa Agreed vtr end aa han ass Dueh r rth alit dora ad WA WAN JA adus ond Lal aed loa Examiner comment The same problem occurred with grade C candidates as with grade A candidates There was a general problem trying to explain the difference between LAN and WAN in geographical terms UUITPTPPDPTTETTEETITE Example candidate response grade E T Lagal orga Ded Ts pant lod wie vea e xa Egone us mele ertet 2 Jaca nien redeo Ms e nomen dec eeu h Polench axe dele anga veru s Lumen ind Rese lt 3eletT hone binet Examiner comment The same problem occurred here as with grade A and grade C candidates The problem was further compounded by many candidates at this level confusing WAN with wireless LANs 36 Cambridge International AS and A Level Computing 9691 Paper 1 Question 8 b State what is meant by each of the following types of data transmission Give an advantage of each i Serial 11 Parallel Mark scheme i Individual bits sent one after another along single wire can be used over long distances Less chance of corruption less chance of bits having order changed 2 i a byte is sent simultaneously at the same time along 8 wires Much faster transmission rate 2 Example candidate response grade A
118. igned to work on a windows environment and operating system Since all of the computers in the school run on a windows environment and the users are used to it Microsoft Office Access This software is required since the program will be linked to a database created in Access because it was available Cambridge International AS and A Level Computing 9691 143 Paper 4 Computing project 144 Hardware requirements Input device Qwerty keyboard To type in numerical and text data in the database such as the house and number of points Laser mouse Needed for the programs gui that will have command buttons that need to be clicked to show the information Output devices 17 inch flat screen monitor Allows all of the action performed in the program to be seen in colour Ink jet printer Needed to print high quality colour documents of the sportsday result Storage External hard drive Used to make backup copies of the data and can be used to store the program if the computer doesn t have enough space Can be used to transfer files to another computer that isn t on the network if a different computer is used during sportsday Server storage 5Gb Allows all of the information or program to be accessed by different computers on the server Processing Processor 2Ghz Even if computers have fast enough processors 2Ghz will make the program more ef fective Marks awarded Investigation and analysis 5 7 8 marks Com
119. illustrated evidence for all the given sections of the report Also the text must be understandable to the reader and without obvious mistakes in spelling punctuation and grammar VVhere there are two or more recognised spellings for a word the student should be consistent throughout in their choice of spelling Cambridge International AS and A Level Computing 9691 131 Paper 4 Computing project 132 Example candidate response Contents b Definition investigation and analysis eterne terne tenete nennen tnn tn tnnt e D Defnition nature or The Di OO OT a ome perat md IRI ee ease rere 2 ii Investigation and Analysis cascada RIEN retrieve INIRE nd ie PU UNUM NUS 4 i Un M 4 Lu 10 SS SU 9 G M 17 TOS euis ordo nre RR m 17 D MS crece VIC IIA Sie Nm ET 41 Cu Limit Sr The scope SOINTION eto temas ttes ae a aa EAEE 42 d Software development programming testing and installation esses 45 MEI fou PR m 45 iD POS abl f oom ne T EE ee nn E A A E E A E 64 CONI e ce 85 Aa MERE carelleniTol NIRRQRRRRORRORRN 123 C2 DO CUS e Mm 124 Systems maintenance documentation susocropi
120. in many textbooks To do well with the more challenging questions in this paper candidates need plenty of practice at programming short exercises to gain an understanding of the effect of key programming constructs Cambridge International AS and A Level Computing 9691 Paper 2 Example candidate response grade C and E EILLLILLL LL sd n iade on ain ar E Teee eaa E 2s PPP es serene Ce Pe eee te ee ee Peers aed e AAE EEE T gi AY aas rd damn b dim mm minim den Set efter eb eds eet er de eee ede eee a E rc hn le ee pEr EBBEFEHIHSSEBEEEFIAJSSSEEEFISAHSSSAFREFIAREEEREI Ee eicere Farts Eom ERA is Al i Neg x ST cue Timer ia pud chay Ke ou lii eT d ff Appian 9 u Tr EFBHFUFITITITUSHEFTEFIT Tzu Sra Saran BED ara aR ER EQ Coo UR 3 Examiner comment There is no understanding of how to tackle this problem in this answer Most did not attempt the question Question 4 a The following pseudocode is a recursive function where n is an integer FUNCTION prod n IF n 1 THEN prod a I ELSE prod lt n prodin 1 ENDIF RETURN i What value is returned by prod 1 ii What value is returned by prod 3 Mark scheme a i 1 1 ii 6 1 Example candidate response grade C i What value is raturved by prodi ies gam DL MAE eee eee oe m m gona mae aca e nai cu e BR E ii What value is returmed by prod 3 7 Lb oN Examiner comment This response is from a gra
121. ind it difficult describing the features of DTP Cambridge International AS and A Level Computing 9691 9 Paper 1 10 Example candidate response grade E Use faX nexis a a amg FEEEHS IPEBRBEBSETPBBRTE FE bPBSRddpthR cPERPHdaddhrauc rkuESudnREdadaksm Cee te ee te EP i i TAN CESE TIL Cote Peete te Hu m m ee eee a Lade Xs Pel ond etene Feature PF pups cape EEERBSBQEIEBEHHH EEER TAS T BREEHHSESEPBEHRHOEIBEEBHHH HEEE HH ESSE Fe bomi int ed Hibridi dhetee sb eee ce iiri ar dee imeri intri oe ed Pridi d Examiner comment Frequently at this level use of features were confused or combined together A mark was frequently gained for e g leaflets but generally little or no idea about software features Question 1 d il ii Presentation software Mark scheme Producing presentation for an audience perhaps for head office to produce training materials for advertisements Use of multi media to maintain interest in presentation Don t accept same point in i and ii 1 per max 2 2 Example candidate response grade A Use le amahe wz PRC el edat dn erus Ls i thew gaitun feer oditi e vem foi Whey nida ad gavqeet Hu Ea lakear aba Feature Mei lih Enep ren ione ereen do atoia melet dri fhe farea lahon janet asc ello tg aE ntm ren uu 2 Examiner comment Use of presentation software to advertise products to an audience is a good use of thi
122. ing 9691 51 Paper 2 Example candidate response grade E i Slate whet is meant by validation Ao cnecte Abok deta wsedel is Ane ame Spork cas ynencthad Aa en M n Describe two diferent valisbun checks ibat can be performed on the ExpecisdCorveralonDale field Ae codd Jae Xuped AIEE ond AXalyed Agaekher T une E 2 menial Check s paa peg mene og SURREY HF in eed noc ju Ine hatad Cn eu ot 4ne doko h Examiner comment The candidate appears to be writing about verification This is a common error from grade E candidates Question 1 e The logic statement to validate the Price field is Price gt 10 AND Price lt 5000 Write a similar logic statement to validate each of the following JobID Paid Mark scheme JobID gt 0 AND JobID lt 1000 Alternative answers JobID gt 0 AND JobID lt 1001 JobID gt 1 AND JobID lt 1000 JobID gt 1 AND JobID lt 1001 Correct brackets 1 mark correct operator 1 mark Paidz True OR Paid False Accept Paid2yes OR Paid no Accept Paid 1 OR Paid 0 Correct brackets 1 mark correct operator 1 mark 4 n Cambridge International AS and A Level Computing 9691 Paper 2 bali ae candidate response A PFUUPTIUPETED UUETZGDEUETSUETEPTETPTEUTEETTS ee oes E PrI PTE IUEEUUPTUICEKPUCUERUEM r FTE EIE UPTUPTPEPUPEUUPEDUUETEUDEU UEPEETET TE L fad ya TITA p Examiner comment
123. ing to an input frame The user doesn t have to access to the database directly e Secure keeping of records Since the original system is based on paper data can be damaged due to destructions of paper In the new system all records are kept in computer and user can also make a backup in a removable storage device such as a flash drive 152 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project ii Intended benefits 2 2 marks 1 One valid benefit of the new system has been Teacher comment candidate has identified and explained comprehensively discussed the 2 The benefits of the new system have been benefits of the system comprehensively described Examiner comment benefits for the flat management system have been described But could have related better to the flat management system iil Limits of the scope of the solution 2 marks This may include volume sizing limitations and limitations of the facilities used For full marks there must be some estimate of the size of the files required for the implemented system Example Candidate Response Flat Management III Limits of the scope of the solution Although the new system might solve many problems in the original one there are still some limits and disadvantages of using the new system First of all the new system has higher costs than the old one The original method of managing records was based on papers but the new system mu
124. inputted into the system If two set of data is exactly the same then the system is able to save data i AM Main Menu Borrow Return Book Reserve Exit Student Report Studenti 10 ME NE StudentName fro ny Contact 1234 t i Tp Aa m intente a nenas Add successfully 123 13601231122 13601231133 iaa Ree PH n LO Examiner comment There were also comments and results for all the other tests in the plan the final test 10 is shown below Cambridge International AS and A Level Computing 9691 169 Paper 4 Computing project Test 10 There is always a chance that some books in the library have been borrowed away and there is no reserve left in the library I need to check if my system can tell the user that no book is left during a borrow process ar ERR RIT att cts TH ertt aet i epic eite pat eh Eh Lebe p aterert reir m Scr nef pt ac certet Sig UE ERSTE SRT AM TR pS detenta NEE La SLO eg tane Led uer ariel ice cpm denne iae carece e rore uns rena yn ortae te EO RC Osa ot Costes tene etd nons GRR Ta NUS IDA V ERI Rota te ARR rgo on RI ag i ets DA EA SS ma Laertius in iT i E TB M 3i n HE 1 H on enu v E Yu ln VER wea ie 5 007 O Sue pO O Jooo No Book Left Reservetniconditiona _ Borrow with Reserve Borrowlist lPedagogy and the Pol _ Giroux Interesing Book on Pedagogy 48 2 Making Good o
125. ion 1 mark for correct loop from 1 ton 1 mark for multiplying current value by i 1 mark for assigning return value 4 Example candidate response grade A Bra en CD RR ce THU ee HUE ILI ha ird m Er LIRE eee rs eee ere erar RARERRSERRdEdERERERSEdESEdERere rr PUE Pts i c o REN E PERE E prp eb eer ca ch eee ed ce ki ia maii Liha ABA 1 mrg foc Eus ELi m i m ain UN oon mom ber ac eee PE ee ee ee TRIES Pe ae pre de E ead och k C EILLILLL nip ee befje me je ete eg oe ee eee oe De UT ew WU Bae TETE a RRR pEi aiai Di Bi E i a iba Ei adai i E hai Bi dd rem er med m V es C PEA Erm eLA Pe Ei BEELA od PE Re baia ja nihii inga iih ih gaa g j aoa j a pai G oi em mea em m em om pon pom m m pm pen hel eia m mag LL a L ES eee pepe te eek eee eee Pee ee Raph sh 01 ENERO T 4 Examiner comment This is a good answer Cambridge International AS and A Level Computing 9691 Paper 2 Example candidate response grade C BE um pla E a a L E xe d all ies em n fod ed Ree on pee ee ee i Ce T IBERRZSPRSRRERRSIRASZPRLGPDBERRIRPRRSRAPRERASEPRRSRS xil ag gg i ee ee see Be mm ett Pit ne OUTPUT PU RED eed bAi nhi de eC barn ped aen Pei mei G kiere emi miner mbi ener emm Is SAI roel 4 IF AW ual T Aler Peel CL Poca nt Enal if Helen Examiner comment This was a typical response from a grade C candidate They have still left a recursive type assignment in their solution Grade E candidat
126. lcs oot Bk puwGherre Cambridge International AS and A Level Computing 9691 5 Paper 1 Examiner comment Two good examples of output devices were given in this answer monitor and printer The choices were very clearly justified by the candidate The answer was further expanded indicating a clear and deep understanding of peripheral devices and the reasons why a device would be chosen for a given application Example candidate response grade C Device 1 ee are Ta maaana aTrrriur Pere ee eg E Device d We oll RENTE PRECOR 13 Justification s Od Se em uae Nau nl Moe enata isa fa Jl ie iei bmi beih inii iaa be Examiner comment There was little difference between grade A answers and grade C answers in this question The main difference being the lack of additional information in the answer when compared to an grade A candidate but enough was usually done to get full marks Example candidate response grade E Davice 1 Macca code 82424 ee Bd EEEEE EE EHIH Justification Jae x aina dax uda d edet of Gin sk So p Pe ee Pe ee er es ee et ss i NI a EEEREN oe ol oh ol ind His eh m mo oio do olio dod dde db Bt eb oo dede n Rm alot e cd di n Device 2 ipe Justification Te cam Tec RENE TESTE Mn A a 4 Examiner comment In this candidate s response there is obvious confusion between output devices and input devices In this case a barcode reader has been chosen as an output de
127. le candidate response grade E i iii Control unit m kem mbs E G Bei ma Bei Si in Bi Ga Bo i ae B aA E o oa ai on meman me Gan ee Gea me ri rn T up CCCII eR Mernory unit M Scand ee Sh Wet em sae is Process AMA a Mec OE a ERAN Ac xk teal oe ee RAT HIP ee ALU Aranna are ene Aes LL Cu dec Ce n un F b i Banian L i P Ca 7 NET Ramon ee R oR c Ez R cA Rs R R mm HON cR He dca micum E R md m Ram Rs SR RR cR D B cm mco mccm mm RR Gu me HON SECOS NBN HO NON OH RON CH NON ERO NO NCOR NS ROCA OR Nc n Gn g 7H R OU RS B OH HS M CR A N OW WR CHOR NOCH oe PP Fn Y UFFFIZFPIZERSELARRRRREARRG BE RREARE 4dakPRARIGERSERGERG4SRSARRSRLRERgaeesm ex mim mii mi m rhe mm Tice ieee Examiner comment The occasional correct word like fetch was used but the candidate had no real understanding of how the control unit works Part ii was a little better with the candidate showing some idea of how the memory unit works but falls short of making some key comments which could gain marks reference to arithmetic and calculations was the level of understanding There was no mention of arithmetic operations or logical comparisons in their answer Cambridge International AS and A Level Computing 9691 Question 5 b Describe the use of buffers and interrupts in the transfer of data between primary memory and hard disk Mark scheme 1 temporary storage area Data transterred from primary me
128. lem 2 3 marks SE Description of the organisation Teacher s comment none made Description of the organisation and the methods currently used in the area of the chosen project Examiner comment very brief description of organisation with an attempt to describe the methods comment about the perceived difficulties this type information would only be known after the investigation and analysis origin of the data to be used and some indication of the form that data takes 3 arde on d currently in use no clear description oat uh i is ee ida ems of the origin of data or the form Mies M bow Ub ob adve Lus that the data takes Too much chosen project with a description of the Example candidate response Sports Day Description of the organization The organization is a private international school formed in 1964 called M School located in S A in the south of France due to its ideal location close to both the Alps and sea The teaching staff consists of 45 teachers in different departments maths sciences and languages There are currently 454 students in the school The school has a Library 2 art studios 3 science laboratories Information Technology centre music room and a performing arts hall examinations room as well as a synthetic football pitch and outdoor games court and a gymnasium The students in form 11 take the IGCSE International General Certificates in Education examination and then go on into t
129. lick Open database Set pocsystem CurrentDb Cpen ine tanie Set pocrecord pocsystem OpenRecordset tblIPOC dbOpenDynaset Prompt user when similar record is found asking permission io overwrite i If found True Then response MsgBox Similar record already exists are you sure you would like to overwrite it vbYesNo Overwrite if yes is cheked eise don If response vbYes Then txtavg SetFocus Perform Null value validation if value is null output error If IsNull txtavg or txtavg Then response MsgBox No average mark input vbOKOnly Else pocrecord FindFirst StudentSubjectID amp Val Istname Pertorm grade validation if percentage input is in possible range else output error If pocrecord Fields studentsubjectid Val Istname And pocrecord Fields POC ID dateid And Val txtavg gt 0 And Val txtavg lt 100 And Trim Str Val txtavg txtavg Then H input is valid then save the data in the opened table under the correct record fields pocrecord Edit pocrecord StudentSubjectID Istname pocrecord POC ID dateid pocrecord POC Grade grade pocrecord AverageMark txtavg txtcomment SetFocus pocrecord Comment txtcomment pocrecord Update Else response MsgBox Invalid value for average mark voOK Only Call clear procedure Clear grade pocrecord POC Grade Call setgrade procedure Setgrade Output error and set fields back to previous values txtav
130. ls meant by a realtime application HekbRaERERERD4dRPdRGbuklakd cra ool ik hol cal in ko Bi Ms ik Boot ak Gs ot a oh Bs bs Bk in lB bi fs b An air conditioning system is a real ime appkcalian Liim Explain how sensors and aciumiorg am usad Io control an air conditioning System in ari apartment e Eni cect ELM cm aid oi einsi the pee sun Vit S86 Hep s ien a ibis WT the celia ea Oaa tek a a peak ba ovedsics ced nx mmt AEE AE on EAEN R EAA mee m EE E E EEEE H en EE ia c Give one other example of a realtime application Justify why your choline is a real 4ime application Empe folet in m Va e Les ons cxi di ecm Justification eau LE bas n aaki SENSO ime Pel collassi ab Examiner comment Part a A grade C candidate should be able to reproduce a bookwork definition Part b This is a weak answer that the application will use temperature sensors and the idea that there Is a critical temperature at which something will happen No suggestion as to how the sensors processor and actuator interact Part c One of the standard bookwork type applications and this has been followed by a clear explanation Cambridge International AS and A Level Computing 9691 95 Paper 3 Example candidate response grade E a Siate what is meant by a realtime application Tks when esta Ir nme ed imneoditoly poe dopt os CRF avi aive Bet i enel ier SPs
131. mal e ExpectedCompletionDate Date Date ate integer I es 7 mark per box NOT variant as a data type 10 Cambridge International AS and A Level Computing 9691 Paper 2 Example candidate response grade C Examiner comment Most candidates got this part correct This response is by a C grade candidate but A grade candidates answers were the same Example candidate response grade E 10 Examiner comment Making the boolean field too large was the most common error in this part Cambridge International AS and A Level Computing 9691 45 Paper 2 46 Question 1 b The details of the last 200 jobs are stored in the file Estimate the size in kilobytes of the file Show your working Mark scheme Result e g 4 29 8 8 4 1 50 size of 1 record Multiplied by 200 e g 10 000 Add 10 e g 11 000 Divided by 1024 e g 11 000 1024 Result between 6 2 and 59 7KB e g 10 7KB 5 Example candidate response grade A Size af rec rd 4 504 Eagt F bytes i aeia pm m a i E e a a a l a o a p a i a al a E j E a l a D a i a a E h h i a E a aa a a te E E ie ena i Ce cL noo retord AI X200 M4200 bu Lbes ee ee ee eee RR eee A OPS Oa AAA ee ee pidh eee ol ee i bed i i Ss i de Big bbe ei SRB ID roy 25 but Add 10 hon x 00 15 626 bytes aw ei BP ee ee id ee Gee ee Eee BEE g oR E ee Spem me a ea n ae ea a EY ee ae ame Y p PTT PIT
132. mcreate rptPOC qryPOCreport Tbidate Frmlogin Tblform Frmmenu Tbllogin Frmview TbIPOC Tblistudent Tblstudentsubject Tblsubject Tblteacher Tblteachersubject Program Listing To prevent data duplication and maintain internal documentation order the program listings will be displayed in section d ii annotated indented and containing clear and comprehensible variable names Cambridge International AS and A Level Computing 9691 195 Paper 4 Computing project 156 tbIStudent Name StudentID FirstName LastName FormID Table Indexes Name PrimaryKey Fields StudentID Student ID Fields StudentID StudentForm Group Fields FormID tblFormtbiStudent Fields FormID Type Size Long Integer Text Text Long Integer Number of Fields 1 Ascending 1 Ascending 1 Ascending 1 Ascending Cambridge International AS and A Level Computing 9691 tblStudentSubject Name StudentSubjectID StudentID SubjectID x Name PrimaryKey Fields StudentSubjectID StudentID SubjectID StudentID Fields StudentID StudentSubjectID Fields StudentSubjectID SubjectID Fields SubjectID tbIStudenttbiStudentSubject Fields StudentID tbiSubjecttblStudentSubject Fields SubjectID Type Long Integer Long Integer Long Integer Number of Fields 3 Ascending Ascending Ascending 1 Ascending 1 Ascending 1 Ascending 1 Ascending
133. ment In this answer four clear points were made characters computer understands each character has a unique binary code Which can be 7 8 or 16 bits use of ASCII codes The candidate had a very clear understanding of how characters are represented in a computer system and the answer was laid out in a very structured manner An excellent answer Example candidate response grade C i jm Whal i meanl by the charackar set of compuler mTTETI ree mmy jr eno PPS PE 5 583 3n ada EET do give i BEI M m i diddidelamdamiandanil ii Expiaim how a character is represented in a computer s pxesended wach dehet TT E pU pee pe irme 14 gm aca mca naci m ac aor yee gon goa mar mpm go a aom een deg iri ee 16 Cambridge International AS and A Level Computing 9691 Paper 1 Examiner comment The candidate did not really understand what a character was However they had a good idea of how characters can be represented in a computer i e using 8 bits There was clearly not as much understanding of the topic as a grade A candidate Example candidate response grade E I Explain what is meant by the character sel of a computer canale set B a Gorn By chari dh ite ke koari arn he Sut ern AD ic ERR E BR BPE EUIS Veeiapptaa iia bEABEIABEEIAEFI RARI SEHR ERAS EREEREER EEIE REIR EFI AERE RR EIRREHI i Expimin how a character is nepressntled m a computer
134. ments Cambridge International AS and A Level Computing 9691 93 Paper 3 94 Processor decides whether air conditioning system Is in operation processor compares measured temperature humidity to required temperature humidity f necessary actuator is used to adjust settings turn on cooling heating humidifier Delay before next reading is taken from temperature humidity sensor temperature readings are sampled taking readings Is repeated Sensors on windows to warn if they are open during operation 1 per max 4 4 Wn c Any suitable real time or pseudo real time application e g To play a racing game So that the player can steer the car realistically any reservation type system to prevent double booking 2 Example candidate response grade A a State what is meant by a real time application Wee dam ipu verd de be Meere p ie a MT T affect ine Pert pub cm m sul cm miea cR DE NS Rc BOR C RS RDON CR SM RON OR M Cm B An air conditioning system ts s real time application Explain how sensors and sctuators are used to control an air conditioning system In an anarnmsnt Genaoe detect truperatire je e apanhuenL omal Sed the data do fie miens t M Iis TERIS Sl es eee ere ere Tere Ta ese mpre mam pag ro qum opum mn PEPITA FETE fae TELTET BGERPIEAGEEPRZSERDSNRSEEEGE Die Rhee pie ee The pipcetsar couapares ik ent pre geb pamwe TO I DABUS fe ie doo ha Fur dae hor
135. ments n elements have been discussed but little or no user involvement some evidence that an attempt has been made to interview the user and some recording of it has been made An attempt has been made to develop a requirement specification based on the information collected Teacher comment good user involvement alternative approaches mentioned some analysis and requirements agreed with user see letter Examiner comment good user involvement and recording but not that type of diagram provides summary of information The requirements specification is based on information collected but lacks detail approaches A requirements specification based on the information collected is present but with some omissions Excellent user involvement with detailed recording of the user s requirements Alternative approaches have been discussed in depth The report demonstrates a thorough analysis of the system to be computerised A detailed requirements specification based on the information collected has been produced Good user involvement and recording of the of interviews Alternative l interview s Most of the necessary items have been approaches rather superficial covered including a detailed discussion of alternative diagram labelled as dataflow Cambridge International AS and A Level Computing 9691 Paper 4 Computing project c Design 12 marks i Nature of the solution 8 marks A detailed systems
136. mm open eom e po gegen eme ow om e pog cm cao sa di cm dicic a ie icio mide ho acia cd ie De indir dcin iind ch c ac Rn ci iced i i be o d Det l ae cidem e Rim ie be d cn Roe o e Ro cn m dd cn i ld ia 2 gg ee eo 8 oe Rd ak A a a ee ee ENNET b i state zu files which are sent ip e shared printer on a local network will be finka TTA uisi wet Foe lor ee AEE EEEE E ee PGRRRRIARER ATE alls ns jode d i Explain how this spooling i amp carried oul Ad the printer jobs aye died if d fours of ave no en Ru RS RC on ORG OR ROG UR GR GN RN RR GR m iim m us acm chon me me nea ca n Re nnm d OMA oak ue n piga Ex iem cleni tuU a aisi D3AEELPAARIRORRRISRERRIZSEEGSRUERIGERPGSETSSEEFIZEEFIZZITUZEEPUSZEFTASEFTARET E EHE bis akii bihi isis n erben n 6 1 a W LE rut TE EPIGEAHEEIGEERGJECISZERE RU ALL HEEL umm on TEPP TEET TE Ce mao gs gom m gogo gom mn aom om Pn a Pere Te ee eee uem ERUPTIBHCUMMMSEEIEHHEBERP SP ee eee rere rer CELIS IEEE as Pe ii Examiner comment Part a Some idea given that spooling involved the temporary storage of data Part b i Has not answered the question Some of the points are true but do not convey any common sense reasons why spooling is used Part b ii Some understanding shown which follows on from the answer given for a Cambridge International AS and A Level Computing 9691 99 Paper 3 Example candidate response
137. mmrcirten riot eee ap d Ue tier itk Vosa sek ea Uum ERER DEUS vn 124 E aldat o eean E e e O AEE A E 130 i Discussion of the degree of success in meeting the original objectives sus 130 ii Evaluate the client s and user s response to the system essere 131 Marks awarded a Quality of report 2 3 marks a Quality of report Comments Evidence for most sections is included there may be Teacher comment none errors of spelling punctuation and grammar P UT 9 Examiner comment an Evidence for all sections is included the report is excellent well ordered report well ordered and there are few errors of spelling but some errors of spelling punctuation and grammar punctuation and grammar 1 3 The report is complete well organised with good use of illustrations and there may be a few minor errors of spelling punctuation and grammar Examiner comment Although this is the first section of the report the examiner would check this mark after they have looked through the whole report However inclusion of a contents page is good practice and can help to show the organisation of the report The contents page set out below provides some evidence for the mark awarded by the teacher as it is clearly set out and well organised Cambridge International AS and A Level Computing 9691 Paper 4 Computing project b Definition investigation and analysis 11 marks i Definition
138. mory to buffer or vice versa When buffer full processor can carry on with other tasks Buffer is emptied to the hard disk When buffer empty interrupt sent to processor requesting more data to be sent to buffer according to priorities per max 5 Example candidate response grade A dal ce ala eidsRRiaatRRREBEERIA aee EIER REL DELLE Lee ee re oe hee e EI ER S CN LU MM M E da alfa n Rune be de n es eas LE NEUTER mes Hh Bes dead kink Pet ts p n NEL TERN SOIL irae on fhe de geh dk dta REO gs ee ecu aro ncm no n am ca lee ar gms tent egal ended Bs RC EE oh dhe Belated RON AEN x3 5 Dmdan on duc teri if Ds Ne Ae p ENIIC s docet Examiner comment There are eight points on the mark scheme and this candidate covered all these points to ensure maximum marks were gained The answer was logically set out using bullet points which made it easy to see each step in their discussion A good clear answer Paper 1 5 Cambridge International AS and A Level Computing 9691 29 Paper 1 Example candidate response grade C de miens di e rum cis AbLLid LA Examiner comment The candidate shows some idea of how buffers and interrupts work but was not very clear with the finer details and confused processor with memory The candidate clearly understands the concept but finds it difficult to link it all together logically Example candidate response
139. n A clear set of agreed objectives with a detailed and complete design specification which is logically correct There are also detailed written descriptions of any processes modules and a clear complete definition of any data structures The specification is sufficient for someone to pick up develop and test an end result using the software and hardware specified in the requirements specification ii Intended benefits 2 marks There should be some discussion of the relative merits of the intended system and of the previous mode of operation This may include any degree of generality beyond the original scope of the system Example Candidate Response Flat Management II Intended Benefits e Fast speed of operation The new system can reduce the redundant processes in the original method and use program to increase the speed of searching checking entering data and many other operations Therefore the new system can increase the efficiency of the business e Reduce the amount of errors The new system provides data validation and verification functions to reduce the input errors Also the system provides automatic checking of duplication of primary keys e g Flat ID so the problems of two records sharing same primary key is eliminated e Easy to use Comparing to the original system entering data editing deleting and all other operations can be easily done on the computerized system The user only has to input data by typ
140. n Evaluation letter Next page Achievements The new system is able to do the following functions e It should be able to calculate the total price for the cashier instead of her doing it manually e It should store records of all he transactions made in the bridal shop e g number of items bought a day or at the end of each week e It should allow the staff member to the following tasks after they have successfully logged into their accounts i Record down all services rendered to customers ii Automatically calculate cost of the services the customers received iii Issue a receipt to a customer e It should allow the manager to do the following tasks after he is logged in i Add new employees ii Edit employee details ill Delete employee details Recommendation The new system was not able to perform the following tasks e It should not allow non members to login into the system e It should not allow members of staff apart from the manager to order for new items Desirable extension If a new system is to be created then it should be able to automatically order for new items instead of sending a message to the manager alerting him that the stock level of a certain item is low Sometimes the manager has a lot of work to do so he might forget to order for new stock which leads to a very big loss for the bridal shop when customers come to buy the items and they find out that the item is not in stock Examiner Comment Desirable
141. n Section 1 of syllabus No calculators allowed Paper 2 2 hours Practical programming techniques Paper 3 2 hours Written paper on Section 3 of syllabus also assuming knowledge from Section 1 No calculators allowed Paper 4 Computing project Advanced Subsidiary AS forms 50 of the assessment weighting of the full Advanced Level Teachers are reminded that a full syllabus and other teacher support materials are available on www cie org uk Cambridge International AS and A Level Computing 9691 3 Paper 1 Paper 1 Question 1 a Define the terms 1 hardware ii software Mark scheme i The physical electronic parts of a computer system Parts you can see touch no mark ii Sequence of instructions programs 2 Example candidate response grade A i hardware Mad emp inet pt rd m pene Es Ted mele np tmm pol SM lim NUS NGA CR MOS i software Tg msi M page jie lectis Mele Iano on eene dua Mel En A aste enne ch od ams NM A Examiner comment This candidate response was clear and precise In both parts of the question the definitions were almost straight from the text book A very good answer Example candidate response grade C i hardware Ferda ae physical ei al thee committe Mat udi unt Com bet ox deste i sofware Examiner comment There was some idea that hardware are the physical parts of the computer but the candidate struggled to
142. nd testing The teacher marks the projects using the marking criteria in the Guidance on Marking Projects section of the syllabus then moderation takes place The selection of the problem for which a computerised system is to be designed and implemented is extremely important It should be chosen by the student in consultation with the teacher and should always involve a client who requires the solution to the problem and a user s the person who Is going to use the computerised system The client and the user may be the same person e g if a sole trader s business requires a computerised system It is important to stress that the student should endeavour to produce a system which will solve a given problem sensibly within the constraints of resources available to the student oince the computing project seeks to assess the systems analysis section of the specification in a practical manner students should not produce a system from their own limited knowledge of the requirements of the system The client has to be someone who is willing to be involved in the project e inthe analysis of the problem where the client s requirements are obtained this may take the form of recorded interviews with the student e at the software development testing and implementation stages where the client and or user is involved in prototyping e at the evaluation stage where the client is involved in checking that the system Is completed as specifie
143. ndidate is able to describe the use of the PC at the fetch stage and also later for certain Instructions once the instruction has been decoded Part ii The candidate understands that values are copied from memory and that later a value will be used from the Accumulator or ALU would have been better Example candidate response grade C i Memory Address Register MAR s T Anthem ed E Aie pies me Esdr raum fl eri iE eid el SE ee dE BS ee REGIS ee ee cory Te Ee ae ee 2 li Mamdry Data Register MOR helb the dude f be he TEEGEE EEE mpa mergo p ppi mn m don fp and from nent SS aumammsdurrracmkbr urbricurmsdum Gb inshuthones Dn theu fp QE Se np mim i jn Rom y beg m on nom si i nom i e cen Whew MAR ciskkbibaiumdddbrddtRiGGbbiuedd MAES adiens Hirer gom m ppg n m gegom quon aca nee n ee G8 som p e re a ng p EN EEE E NON GS m MUN SH GS GN ER CH RD B ONCE GUOGCN OR Gp HOD RGS Rom mm com rc caca uno Rn d c om nodos ros cos ol e loded wiih alhvucdem n RPARERERGGnRR RARRARGAaRRRRSERIRARRIGSEERSEEETL DEA Ps Pe Om es ee ee en ee ee e 124 Cambridge International AS and A Level Computing 9691 Paper 3 Examiner comment Part i The candidate appreciates that the contents are copied from the PC but does not suggest that for a LOAD or STORE instruction the contents of the PC will change as a memory cell has to be referenced Pa
144. ndidate responses has been chosen as far as possible to exemplify grades A C and E Each response is accompanied by a brief commentary explaining the strengths and weaknesses of the answers For ease of reference the following format for each paper has been adopted Example candidate response Examiner comment For Paper 1 each question is followed by a general comment which explains what the examiners are looking for For Paper 1 Paper 2 and Paper 3 comments are given to indicate where marks were awarded and how additional marks could have been obtained In this way it is possible to understand what candidates have done to gain their marks and what they still have to do to improve their grades Past papers and Principal Examiner Reports for Teachers and other teacher support materials are available on http teachers cie org uk a password protected website available to teachers who are registered as a Cambridge School 2 Cambridge International AS and A Level Computing 9691 Assessment at a glance Assessment at a glance Centres and candidates may choose e to take components 1 2 3 and 4 in the same examination session leading to the full A Level e to follow a staged assessment route by taking Papers 1 and 2 for the AS qualification in one session then Papers 3 and 4 for the full A Level at a later session e to take Papers 1 and 2 only for the AS qualification Weighting Paper 1 1 hours Written paper o
145. nerate fine when return date is not 14 days away from borrow date Enter a Book ID which does not exist in the borrow frame Open the reports and database to check if they matches Try to borrow a book with number of 0 Paper 4 Computing project Example candidate response Library System Like most of the program in the world my library system also suffers from errors I have decided to test my programs before it is hand to Ms J I will use many different testing strategies to ensure that very possible error is considered I will input both normal and abnormal values to test my system Hopefully after the testing I can reduce the number of errors to almost zero Evidence Actual Expected Outcome on page Outcome The system will warn Successful the user that it cannot process and tell user to input correct data The system will not Unsuccessful But resolved allow the input The system will not allow the input and it will warn the user Successful No The system should not allow pass when wrong passwords are entered The data can be directly viewed in the sql database The system should reject the third borrow Successful Unsuccessful and warn user The system should display the fine to be But resolved zero The system should Unsuccessful warn the user and stop But resolved process The data should not be in the database The report should match Suc
146. new system the program will be stored on a computer with the files backed up on an external hard drive and also a server so that it can be shared between different computers Alternative approaches Alternative solutions to the problem were discussed with the end user Buying off the shelf software Buying off the shelf software would be a cheaper solution to the problem as well as being sure that the software will work since it has already been tested and would have the support offered with an off the shelf software The response to that was that sportsday is a unique event relevant only to this school so finding a software that does that will be very complicated and it might not be exactly what the user wants Adapting a current software Adapting existing software would be less costly than creating a new software but more costly than using generic software since the software will have to be bought plus the cost of the modifications it still has the same issues for the user The final program will not be as fitting as creating one from scratch will be I will also take more time since the program will have to be tested where it has been modified Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Creating custom software This is the chosen solution It ensures that the software created will completely meet the demands of the user the software can also be changed once it s been created if the user wa
147. nts a machine is used to time all of the students then the teachers in charge of the results allocate the points Question 11 To whom does the information number of points go to The information is collected and then taken to the desk where 2 teachers fill in the results into a large grid and allocate the points to the different houses At the end of the day the points are added to find the total for each house and the winner is announced the next day Question 12 What would you say are the main problems with the current system Well it takes time to accumulate the results as well as checking any calculation errors in the addition of the points Also since all of the results are kept on a large sheet of paper which is hard to store and it is difficult to find any individual results that need to be looked af Question 13 So what do you think the best thing to do to improve the system would be Improving the manual system a computerized or partially computerized system I believe that a partially computerized system would be the best option for this Computerizing the whole system would be too expensive and not necessarily more efficient The data will still be collected manually events but during the event the data will be directly recorded on a computer so that all of the addition of points is done automatically and it is a lot easier to find individual records as well as storing it Question 14 Off the shelf software is software that
148. nts changes Of course it will take longer but time isn t an issue since sportsday is a once a year event and the program can be created tested and implemented in that time Requirements These are the requirements for the new system which have been discussed and agreed with the user e System must be able to deal with all of the inputs student details results users and events so that it entirely replaces the old system e System must be able to add up the total house scores this will be one of the main the features of the program since a large part of the problem was having to add up the total Scores for each house e Search function to find individual results to make it easier for the users to quickly find a result in case an error has been made or simply for checking e User friendly interface to make the program simple and easy to use even for people who aren t familiar with computers e Way of writing down a new record if there is one so that the new records can be directly entered while entering the results e Must be able to navigate through the results to allow to see all of the results e Possibility to edit result in case an error has been made e Must run on a windows environment since it is readily available at the school and the users are already used to it Examiner Comment There was a signed agreed copy of these requirements in an appendix Software requirements Windows operating system The program must be des
149. ols provided by the DBMS including validation techniques to check the input data use of primary and secondary sorts use of OBE to create multi table queries and the use of forms and reports As the weaker students progress through their solution it should be possible to extend the work gradually so that they can include a range of these techniques All students should include some program code that they have written and developed themselves in order to demonstrate their ability to write a maintainable routine for a program Better students could make good use of the data description language DDL and data manipulation language DML provided linking to the work studied for Paper 3 Other types of project could be developed making use of the programming language that the student studied for Paper 2 These could include control systems simulations etc The use of the Internet for business educational and recreational purposes has led to an increase in the number of projects involving the design of websites At its basic level this type of project is often not well documented by the weaker students and so does not score highly We would expect to see the HTML code for such a project together with a site map and links to external sites The solution could be extended to include an email facility use of forms and links to a database to collect user information In the case of web design the current solution to the problem may be harder to identify and so
150. onal AS and A Level Computing 9691 73 Paper 2 4 e g C string letter new string 26 tor int i l i lt 26 i letter i 0 1 mark for correct declaration range 1 mark for correct data type 1 mark for loop to address full range of array 1 mark for correct assignment 4 Example candidate response grade A Language VE NN T ertt bm emna a mpi e apr PEPI EPT PrE EEr rrr FFPFTHEEFI EFIINHFFTHEZWEI HPFI TRENTHEN FTIHEFEPFIEHEFIBLI oa rs FERBEPIHHEITHEEIRHAENWRZE BENE SS Pras mop me PPE ee ee ee ee ee EENEN E FA A LSE rimr Ld odi dedos nde do Hos cmd d dos doa is aede nd inis Dod som cm d Radon d B cmomecis aca me Rm o m RS hm mm oO RS UO NUR Gm Gn e H EN GUN COR HR GE EU CO GEO ROC GE OR RU HC ROS NC ORE NU o OR OR m Re pom n pe e em a FP RA He a Bs am oh lhc nh i a sh ah Mlk i ek i ah nh enh bh a i Bo oh ih kt i ik a om om lh lam ks is kk ak tn ol am bre Bed bee tb eit iis ee hich isi nni A ee EAEE TT Se A LICCLISEC IST EISCL LTTE LLIEETETE T 4 ELEEERILAERAA AE za bip ij I II HRIRIeIT MM PERUCUDIEDCTCE ETEUETEDCETUUEIFIICPTEETITEN RITESEN E RE ee es E ETE m NE Examiner comment While using array as a variable name is not good this candidate had the programming points that were relevant Cambridge International AS and A Level Computing 9691 Paper 2 Example candidate response grade C mene e AE j Basic eee rere ee emerunt Pie nien oen mie ad ie ie DM Charl Alp taht AS o
151. opment for stock purchase tracking Dear 5e Further to our phone conversations I am very pleased to let you know that the issues we brought up regarding the sorting and ordering in the report have been perfectly resolved thanks to your most recent changes Having had it operational now in the company for nearly two weeks I am confident that all of the issues are now resolved Also many thanks for changing the back colour to grey and changing the field layout it s just a little more intuitive for me I find like this The program is now very natural and instinctive to work with In all a really well executed project for which we are very grateful It has turned out to be exactly what we set out to obtain I m positive that this will provide us years of good use and hopefully save us money by providing accurate and timely procurement data when it s needed Should you require a reference we would be happy to provide one unreservedly With kind regards J H Director E G G Examiner comment This letter includes specific comments about the system provided showing that the client has seen the system it was written on headed note paper and signed by the client 190 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Analysis of client s response The client had been given the software almost two weeks before asking for a response as part of a beta test so the system could be fully te
152. orms in the new system Based on my observation and interviews the following designs will meet the requirements of the system and the agreement of user access to the database directly to save data All the forms contain input fields and button providing a user friendly interface There are totally four input forms in the new system Based on my observation and interviews the following designs will meet the requirements of the system and the agreement of user This button saves New Flat new suppliers to Supplier Table These are two radio buttons If the supplier is new the user should Check if there is a choose the New Supplier Otherwise duplication of ID the user should choose the first button and select the Supplier s ID from combo box Room Number n Building Name No This is a combo box containing all Street Name the IDs of current supplier in record i fields Area Square meter Price per square meter This button aims to calculate total price of a flat It should also ld i provide data format ds TE ne d is not The button saves all validations editable it is used for dissi ih records and provides i i tota es otc Mu presence check of all price ofa flat text fields This New Flat Form is used to input new records of flats This form contains mainly two parts First selecting or adding a supplier If the supplier has been saved before in the Supplier Info Form the u
153. ram listings detailed flowcharts details of the algorithms used adaptive maintenance to provide for some future proofing All parts of the guide should be fully annotated since this is important for subsequent maintenance of the system The specifications of the hardware and software on which the system can be implemented should be included Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Example candidate response Garden Centre report E i Systems Maintenance Documentation Data Dictionary Forms FomName se FrmMain Displays the data in the system and allows for data manipulation Can be used to input new data into the svstem FrmInput FrmMain Objects Displays the family name of the plant in the offer currently being looked at Source Qryoffer Displays the species name of the plant in the offer currently being looked at Source Qryoffer Displays the variety of the plant in the offer currently being looked at Source Qryoffer Displays the supplier name of the plant in the offer currently being looked at Source Qryoffer Displays the price of the plant in the offer currently being looked at Source Qryoffer Displays the date that the offer currently being looked at was given Source Qryoffer Button be given bare root Source Qryoffer Option Displays if the roots of the plant in the current offer will Button be given in a root ball Source Qryoffer t
154. rated from the User main form so as not to confuse the user Because the two forms are so Documentation similar the photo placement and command button placements have been switched around between forms so as to make them look less identical On pg 232 248 screen help has been provided to help the user further validation rules return text boxes to point out mistakes to users etc Mio E cnl ac ensure the data is entered in the correct format There are several tables in a database that can deal with a lot of data The Tables pg 25 29 tables are set up in such a way that the database is normalised to its 3rd form The data is all displayed in an organized manner on the main form Record navigation and can easily be navigated with the navigation buttons og 89 98 4 Using the main form frmmain the user can easily edit the data being Editing pg 99 103 displayed which changes it in the source tables thus editing the original data Using the delete command button the user can easily delete a Deleting selected record on the main form removing it from the source tables og 104 106 188 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project The system might not initially save time over the original system as it Data access requires constant updating with every new offer obtained whereas the old system required no such updating This should cost less than a minute per navigation pg offer entered The new sys
155. rmined by the available resources within the school However If students choose to write their own program then the choice of language must allow them to construct their program in a structured modular approach Previous experience of students work indicates that the choice of certain projects for example games quizzes word processing and websites that just provide information make unsuitable projects and are not capable of achieving high marks unless they are both very well designed and clearly documented The following list is offered as a suggestion of some suitable projects but it is in no way complete and students should be actively encouraged to investigate e Booking systems e g Doctor s Dentist s Hospital appointments Leisure centre facilities beauty salons etc e Ordering and stock control e Borrowing systems e g Libraries DVD rental e Seat reservation systems for theatres cinemas concerts etc e Control systems e g greenhouses air conditioning lifts traffic lights etc e Management of club memberships e Management of events e g School sports day Centres should be reminded that the project should be the student s own work and so joint projects should not be allowed Successful projects usually involve the use of a database management system DBMS that supports the use of a programming language Database projects allow the students to achieve at different levels the weaker students may only be able to use the to
156. rt ii The answer suggests that values are obtained from main memory The candidate does appreciate that the MDR will also be used following the decode of a STORE instruction Example candidate response grade E 0 Memory Address Register MAR ha ME P one penis Mes Pe RCE X E x3 scc sb deis dosis dna o eee tat j m Mie C E ong MC m Ms cadet eiit a iz il Memory Data Realster MDR Examiner comment Part i A weak candidate should realise that the initial use of the MAR is to copy the contents of the PC The use also of the MAR for certain instructions after the decode is a difficult concept for this candidate Part ii There is an easy mark available here for describing that the value will come from main memory The first sentence suggests that the candidate understands what is happening but omits the key words from memory Question 12 A business uses the Internet to communicate with suppliers and to pay bills electronically Discuss the problems of maintaining confidentiality of data on the Internet and techniques that can be used to address these problems Mark scheme Must safeguard against unauthorised access to the computer system Firewall used to restrict access to known sources Control access to the network using accounts user IDs with passwords procedures in place for authentication File contents can be encrypted procedures in place to protect against malware C
157. ry points to gain maximum marks A very good answer Cambridge International AS and A Level Computing 9691 Paper 1 Example candidate response grade C i Expluin how hashing could be used ta aecass the member file randomly NTT spun em Tht nadie EA a mde EIE per op DU PUR M inen Ti 16 ena ba tae SV A RIM AREAL Ph eH Ies tone TPR ARAL a oss Bis EAR A fena ma NID Sc clos Tl fes Ad zik The Res manal Tent Netter hile les mnultiphianl Aaa E genie ii Wren the member fila ig accessed using hashing dashes can occur State whet is maant by a clash sid how it can b desit with iM iota dean cand Final ole emu TERT a ETE T Th lcd A8 teme i ied us M etim A cmd UC opha la tton DRE daas See uti Esau aude Hense In rni pm c 4 Examiner comment There was a marked difference here to the grade A answer No real examples of how a hashing algorithm works were given but there was a good general idea of why clashes occur and how it can be overcome using next free space The level of knowledge between the grade A candidate and grade C candidate responses Is very marked in this question Cambridge International AS and A Level Computing 9691 23 Paper 1 Example candidate response grade E i Explain how hashing could be used to access Ihe member file randomly sevens cy 9003 il Be iced 39 cac Tea oer bay acl Yay Ane Kent datis Al toe eina pers Cu
158. s Well there really only is one problem consists in finding the 6 fastest times since there can be a lof of students taking part in an event Another problem can be when the timing machine doesn t work where the teachers have to time the students The rest is fairly easy and straightforward Question 7 If we were to partially computerize the system what would need to be entered into the system for the results Well the interface must allow the input of everything required to enter the results So that would be the Student ID the position of the student in his event the number of points scored and the time or length he or she achieved Cambridge International AS and A Level Computing 9691 199 Paper 4 Computing project Analysis Flow chart showing the steps of the system Students choose their events Data is recorded at an event Data is written on a result sheet and the points are assigned The data is then taken to be filled in a larger result sheet one for each age group and gender any new records are noted The number of points are then all added up for each house and are then filled in on another sheet that simply contains the house age groups and points New records Points added to find winning house 140 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Data flow diagram Result is recorded Results are collected invalid Results are checked valid
159. s many users to use the computer system Mark scheme Each user given short processor time time slice n turn so all users serviced in one rotation Flags used to stop waste of processor time if terminal has nothing to do Priorities used to allow some terminals more regular time slices or longer time slices different users data programs are stored in different areas of main memory 1 per max 4 4 Cambridge International AS and A Level Computing 9691 41 Paper 1 Example candidate response grade A E Sees Vor mr erede sse cimi mdi does d aon Mo Mags colety For a Mete s Q se o Klaas on di amp kerenr kermi PEE Hj es rs phprs Pes e sees eee TIT ts xw Aeme60is oOo bulbs ABLIGENRA3HERITLEIASERLAFLRAJALI JZSERE ARJ ier ui eS GPS E cm c Thou e Vea Disk ima bida Rehd m m d CR ol mm RR od me TEENRELRZERRGH is email eiiiai m mimi cum meas RR Ro noc An Ro Ron m RR ra S04 ie Ox EI Mee Con PINE gyo Slee trent Vul Serna sal ols ROME ay hive 4 epewdisa o Te FES Hs det ns Examiner comment The candidate understood the concept of multi user systems The idea of time slices polling and use of flags was clearly understood But very few candidates got full marks on this question indicating that this topic is not generally well known Example candidate response grade C p MAR LM M s T Gea aac Ap En Tadd geet neste Dua tha
160. s software The features were particularly well explained i e morph one screen into another and use of animation the candidate made more points than were necessary to gain the maximum marks Cambridge International AS and A Level Computing 9691 Paper 1 Example candidate response grade C ca OBOE APOE thee E TEMER e In ues AOS ees p AM eA prt doa uan anii nd winiz EE Feature is SeLiomee aa dn Len ROLSCR Qon lu eC he a 2 3 CNET NICA LC IER Examiner comment Allows a business presentation doesn t say much but the candidate was aware of the features of the software although they were a little too close to a description of multi media software There was evidence of lack of depth of knowledge when compared to grade A answers Example candidate response grade E MAS cine Ehini Ee 2 LLLLLLLSL ea ol om Pemmsadd is Blt iki Ble lh Be amy om Rf OY kmh home emt off eB i mom oma fe ae Ge ad megs As yA mah ee om nme remy om om ge ie rm mom atom bh d ieh n Om Om Rm es om mem hami Eh E am a er Examiner comment Not a lot of idea really apart trom claiming to present something There was little idea about the software features and vague answers were given such as slide shows without explaining how they would be used or why Question 2 a A systems analyst is employed to produce a new stock control system for a company The manager of the company is not satisfied with the pres
161. ser only has to choose its Supplier ID Otherwise the user should choose to add a new supplier In this case there will be two input dialogues to gather the Supplier ID and Company Name of the supplier Another process is saving new flat records User can input a new Flat ID and use the check button to avoid the duplication of Flat ID Unless the new Flat ID is unique the following text fields will not be editable Furthermore the user has to press a Total Price button which can calculate the total price of the flat and check if the Area and Price per square meter have correct data format which is float or integer Once the Save is clicked the record is saved to Flat Info Form Examiner comment There were also forms for editing records deleting records and selling flats Cambridge International AS and A Level Computing 9691 147 Paper 4 Computing project 148 Data Output All the data out from the system are shown in a text area According to the structure of the original system and the ERD diagram I designed following three output forms of data with agreements of Mr W and Ms Z The total price equals area Flat Records multiplies unit price The data type of these fields is Address of Flats float Flat Records The following are all the records of flats i Fiat ID Buyer D Supplier ID Room No Building Name No Street name Area Unit price Total Price Availability 54300 2356 X 5676543
162. ssembly language are both low level languages machine specific 1 per max 2 2 Example candidate response grade A Branly mo 4 gn pope Tee i at ye uadit it A peame anc OA fexolued NO Le ee tse qie eee em pijane ee em em eam mem ome Bee ie Be om ak eg Be phani pe eB mem em ok ie es oth ome i dt om eis off om a Bs fe oo ee pd mulis end Bon ra Hat and O 05 Bernat Tana Tr Sg om om om n ae m meg aia miem ee a a a oa ms au m gom me it pasar ecole ele Examiner comment The candidate has described two of the key features for assembly language and machine code The third point is not precise enough Candidates at a grade A level should have an understanding that even high level language programs are stored within computer systems as Os and 1s The difference is that machine code consists of binary codes Example candidate response grade C E fi SA eT cm s Bog ci cm sm Rr uc pora cm pu me a cu mw un R PSP RR aE E jaah REPRE Ri RE RR hb RR bed RR eR eR ee Re errs Used Sor Noes semis meer M cool NON ONNGUR SU Examiner comment Grade C candidates mostly scored with the most fundamental statement that there is a 1 to 1 correspondence Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate response grade E YT NES ars n E nd Ead PEU M frr m a aka ee By eee Em E E i Lal a rpm de a ee ee d mds cei ia E R Examiner comment
163. st run in a computer Therefore the agency needs to spend lots of money on creating an environment for the new system Secondly although the new system is user friendly and easy to use the user still needs some basic computer skill for example installing and running the new system Also the user may not be very used to the change of the system and this may reduce the efficiency of the new system Thirdly there are some limitations of a computerized system For example data can be lost due to an accident power off and attacks of the computer system can reduce the security of the data Therefore the user has to make regular back ups of data Table Fields Example Maximum Size Size of table in Bytes in Bytes estimated number of records in a year Flat Info 142 20028400 Area Jeo Je UnitPrice 1000 1 8 TotaiPice 8000 J8 O Supplier CompanyName S M Real Estate Inc 60 20 1200 Info BuyerID 330302889307719364 Buyer Info BuyerName P Pae 253 150 37950 PreviousAddress Room352 No 425 Lai 200 M Rd P District Shanghai China Size of record in one year 67550 Add overheads 10 74305 Size of Database in KBs Approx 73 Cambridge International AS and A Level Computing 9691 153 Paper 4 Computing project 154 Marks awarded iil Limits of the scope of the solution 2 2 marks 1 A discussion of what the system Teacher comment file
164. sted in use the user could get used to the system and formulate an opinion on its functionality and suitability After the client had used the program for a few days he was asked for an initial impression and ways of possibly changing the system to better suit their use of it The client had a few minor issues regarding the layout of the main form however the functionality of the system was fully approved with as of yet no faults being detected The layout designs were promptly changed to the manner the client had requested The client was given several more days to use the system as a test The client was then asked for a final opinion on the system over the phone What followed was a discussion with the client asking specifically how he felt about the final system considering user friendliness functionality and the future use of the program The client had indicated to be fully satisfied As can be seen in the e mail sent by the client on the 23rd of March 2011 e The client indicates the current final system is very user friendly The program is now very natural and instinctive to work with e The client indicates the current system is of great use to them and will most likely be used by them in the future I m positive that this will provide us years of good use e The client indicates the current final system lives up to the requirements identified at the start of this project and that the system performs the task it was planned
165. t A Aes E be rapeste lin ae eiel aluet dish low Mawe wil Vet e ela nd hat the Walt of XE Ret Te EP PPS es ee a es es oe pe ed mmmumempracuemrk arend t us qti Li nding odo Pone Ss TE ee ees ee se XM tu Lovet post Wes wlohe tnt a vdi PPri sprr es d erp n riria ne rhe eed es ee ee re pian ei 2 pjege n prinser rrine phr ee e Preiser bihis eer eee ees mmm ee ee HCM MmPPPmImmpmmmmE ee rre 3 i Describe how two words lower case letters only can be amanged in alphabetical mujer ss bes diera des es ees Yen Glar f Ses jb iis SE ee es re ed ee ee eed 2 ee ees deed es ee ee ee riss 1 RH Werle Het leue te Sg a GcR ee a ge emg a E GEL JO SD ee ee ee a Pe ge Creeley Date fe Arr her Ete se eid ol of EE TEN a ai AbsbidurhiiudumRblbiBEBPPSBRPRIESERFISSEIPInabeisdBPiiisSarbbinskrkIdSSEbrdE at t EE TL LN S NL RR Glee es es ee riris ee eed riris dE ie da es tE eee ee ie re miim dus ff tects sinere minii oe dee bees ee ed mre rm Sent uo nest OorumPrpuEBRETTUPHEPPPISEBPEITSEFEDFINEEF RPUSASETTISHRIISETEFHUSERSLISELETIZERNEFLZNERHIIJENEUTPUSTPIGSTEPEIUTUTIOUSEITUHUHEREIUSNE aaa oe LI ee ee LI Bijak ag pae e td pE ee el r eis di ris di TEUPUEHBEISSEEEDISSHREEFISSIEREISHELINSEEIGAIREEERISEEEINRIZEELILJSERBELISEEEITTERFITTEFTP TTCUUPDITHEFINSSHELLISSSEEPRARGIEELIGSARNEELGEM 4 SE Sa See Be ee Ee EbEia aE si RARRRR ERE Pee ee ee eee RET se a a DIG b ee oe SP tee ee TE Examiner comment
166. te reports of the existing POCs for the students in the teacher s tutor group for the selected date Individual POCs can be viewed by scrolling through the list box POC Report Procedures t Access POC Report Subject ame Titia Teacher Avere geM ak h POC Grace Charity Mr Hope 12 Concam Subject Mame Title Teacher verageMark A POC Grade English Mr Myers 30 Conem IGGE Subject Heme Title Tescher BAversgelark POC Orade L ve Comment Biokey Mr Green Ok GCSE Subject Heme Title Tascher Avengehah POC Grade Laval Comment At My mon 3 Concert KCSE Excelent 1 Click print button to open print menu allowing to print multiple or single POCs 2 Click zoom button to increase the report size on screen 3 Click cross to close the report and return to View POCs form 4 Use navigation buttons or arrow keys to navigate through form POCs Examiner comment Other procedures were also described in the guide 184 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Back Logout and Exit Procedures 1 Click on the labeled buttons to perform the following procedures Back Button Returns user to the previous form Logout Button Returns user to the login screen enabling other users access Quit Button Shuts down POC Lunch System On Screen Help All objects that require input selection clicking or any other sort of user interaction have a control tip te
167. tem should be able to save the employees time however when the offers need to be accessed Depending on the age of the 89 98 offer this could save them anywhere from a few minutes of searching the inbox to several weeks of re negotiating Finding Data pg 135 141 Input pg 142 214 Frequently used I replicated inputs have been identified for the entries Input using that require them These entries have been put in a combobox on the input form frminput The list for each combobox is filled with the data in the combobox table it saves to This way any new data that is entered in the combobox is automatically added to the combobox selection list pg 142 221 Using the system it is very easy to quickly find data This can be done on Find pg 135 141 the main form frmmain either by using the navigation buttons or by using the included find function which can be called upon using the command Navigation button og 89 98 Degree of success From the evaluation and evidence presented it can be concluded that all requirements are fully met Marks awarded i Discussion of the degree of success in meeting the original objectives 3 3 marks oome discussion about the success or otherwise of the Teacher comment each work but with no reference to the specification set out in objective discussed c including where evidence some discussion about a number of the objectives set can be found out in c i but some omissions or inadequ
168. ternational AS and A Level Computing 9691 Paper 4 Computing project Real Estate Agency Manager 22 149 Paper 4 Computing project Menu and Module Design According to the structure of the original system and the requirements of users I proposed a new system with four main modules Each module has its specific functions Also a menu design is needed to lead the user to access to different working modules The following is my design Module Design New Flat Module Edition Module Deletion Module Selling Module Viewing Records Module Menu Design Main Menu File New Record New Flat Module Edit Edition Module Delete Deletion Module Sell Viewing Records Selling Module View Supplier Records Flat Records Module JU ne Buyer Records Help About this program Exit 150 Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Flowcharts for different modules Selling flats Start Check if there are any available flats YES Read all Flat ID of available flats to a combo box Select a Flat ID Show the address of the flat YES Is the buyer new Read all Buyer ID from Buyer Info Table to a combo box Input a new Buyer ID and other personal information YES Select a Buyer ID Check if the Buyer ID has been saved before Insert the Buyer ID to the record of sold flat
169. that of The ume Examiner comment This was a very thorough answer The candidate was clearly aware of what made a good HCI Several of the points on the mark scheme were covered he candidate explained why certain things were done and didn t just state facts Example candidate response grade C colour Brigit We TOS chaud bo nad dca cpi mead b Ce a a lenak pm a Rh SA iid dh shih koh rea sha lass nih Sod liad oboe nt ei bi its Layout Tes dane PN le fs port c iM he ind sos le wale Jom eMe des e dis Adi ahead iz acf ada danke Content FR Due td coe ha a ro as p A Cambridge International AS and A Level Computing 9691 Paper 1 Examiner comment The answer covers all the main points but struggles to explain the contents part Although comments about use of colours were correct the candidate couldn t explain why some of the features given were done under layout and content Again a good general idea but lacking in the finer detail to get more than half marks Example candidate response grade E Colour Castres tp iOS Ving hacker aus d SR dik should nare Aeron TCN hmm Mn elg lae Med A Anota T Hae bazza Red d een Sine he aaide my cotex Lindi Layout Sua oe verni Mer dep aed eX side onm s e OR OR xg 80 lenis Ades RC ences oec ERA nk mime ao cin Ext Sie S Shaali ag Peces Popel mower to Shed Woe S v
170. the student may find it more difficult to score marks in those sections relating to the investigation of the current solution Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Guidance on marking the computing project Computing projects are assessed as follows Toth 60 mars Teachers should mark their students projects using the following sub sections and record their marks for each individual project on the marking grid pages 48 51 of the syllabus and any comments that may be helpful to the moderator e g identification of missing items page references for items Example candidate responses For each section of the report marked extracts from candidates work are included together with a completed section of the marking grid showing the teacher comments and examiner comments The extracts are from a wide range of projects including e Sports Day e Flat Management e Garden Centre e Bridal Shop e Pupil Records e Library System a Quality of report 3 marks A candidate should produce a well ordered report that covers all the information from the sections set out below The report must be the student s own work and any evidence that has been included from elsewhere including other students work must be properly referenced as such and cannot be credited towards the student s mark for that section For full marks to be awarded for this section the student must provide clear well
171. this answer has the first position of the stack at the top which is fine most candidates drew the stack with the first value at the bottom The start of this answer is accurate but then errors are introduced Candidate has omitted to illustrate what operator causes each change Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate response grade E 8 a Explain the need for reverse Polish notation So thot ag computer cmo do Hae acia C Sg EDUP ey CH SOM NC R CR RIO acm miu pg ppn m exsilu a Crow put e Can Lain d rst Bem prr ES an ol ee Boim sa mnn lm i mo ce meom lel oe moon mom DR moon 6 Show wih the aid of dagane now s stick bs used to ten he reverse Polish expression HL ead ba mip an expression im iri notalar ea xb cul Uu ala axb l ra d e 8 Stecka last th Are dise Examiner comment Part a This answer is merely stating the obvious and not worthy of a mark Part b The candidate has no idea how to document the changing stack contents but has written the final infix which does score one of the available marks Cambridge International AS and A Level Computing 9691 117 Paper 3 118 Question 10 A country has a national football competition based on leagues Each LEAGUE has a number of TEAMs but each TEAM is only in one LEAGUE Each TEAM plays at a number of GROUNDS during the season and each GROUND will host a number of T
172. to do correctly It has turned out to be exactly what we set out to obtain e The client indicates that after an extended test period there are no known faults with the system Having had it operational now in the company for nearly two weeks I am confident that all of the issues are now resolved Marks awarded ii Evaluate the client s and user s reponse to the system 3 3 marks some effort has been made to make the system user Teacher comment see friendly but the user still has difficulty using the system scanned letter The system is in the main user friendly but there is Examiner comment client room for improvement e g no on screen help has been indicates the system is user provided The user indicates that the system could friendly and the candidate be used but there are some faults which need to be has evaluated their response rectified known faults in the system 3 A fully user friendly system has been produced The user indicates that the system fully meets the specification given in section b and there are no Cambridge International AS and A Level Computing 9691 191 Paper 4 Computing project 192 Example candidate response Bridal Shop Examiner comment The response below is minimal the candidate hasn t drawn on the evidence provided in their project report to support the evaluation the client s response appears to be contrived and hasn t been evaluated by the candidate Evaluatio
173. to illustrate to the examiner how they have arrived at the answer 104 Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate response grade C 7 Part of the information stored in tbe data dictionary describes ihe type of data whith ls being stored aC as particular piece of data is 10010110 ALS State what the data stands Tor W the tite dictionary describes tas 53 ib A ug o65 I a two s complement binary number GE 28 diye ol5Lo p X COCleloiob ite wg es tS o N p orc n Ae Inl aa Re seme e m e GUN ST i U x Be Bk ek AER iiki ihid Be me em Be Be Be BiB ad ee Bie me ee Be Bom ee em me mi een Gon et iam im ee om mod epe mdi reote iom meter 1 M x T oe 2 uL asign and magnitude ninry number y AR 1 5 a RR ce 1 E A TUNWC ONE DE ONERE ONES HR 1 HW amp binary coded decima number AN S n n bt auxccusEmnenm e Een hcl iis o b ded cd b sin ides ic dod d bd imd a chim eom aim TITLE lea mira ci d cm i sm s RR om an cm and m ci missi m edo m acu mn mim mica mcd i m p i m s m on pe mm 12 Examiner comment A grade C candidate should be confident in performing these number conversions This is a very typical answer where part I is correct but then part ii shows no working and an incorrect answer The candidate recovers with a correct answer for the final part iii Cambridge International AS and A Level Computing 9691 105 Paper 3
174. ts made in a logical order and illustrated by the new diagram The candidate has failed to explain how these new relationships will be formed i e by the use of foreign keys in the new third table Cambridge International AS and A Level Computing 9691 119 Paper 3 Example candidate response grade C i State Ihe relatanship between LEAGUE sad TEAM 2 iii Explain how the relationship between TEAM and GROUND can be designed in hird normn fpem Fact tae stould he ei eo TAMAA BA Mis Ane Aga keke dninibale Shed stele Tri ntc non pel ITITMETESUILLDIITIIHDDIDILETmEE Le Cand hormal ede Tn do 3 au imis bed bd amice m mam e n butes Should nol ae m E per OAM Lim Bn addon Table Sive de piman fey of the TEAM amp gru dap W ms M uud d link he Moro lin pd normal fora Examiner comment Part i A grade C candidate should be able to draw on their practical work with a relational database and produce a correct statement and diagram of the relationship Part ii Correct statement and drawing of the relationship Part iii The candidate has initially written several general statements which do not score then finally describes what will need to happen for this scenario that there is a third table which needs to include the primary key attributes of TEAM and GROUND 120 Cambridge International AS and A Level Computing 9691 Paper 3 Example candidate respons
175. udent joins In October when the lists are given out so that the students can select what events they do then the members of staff quickly realize that a student is missing Question 7 What security methods are used I cannot tell you about the security used for the database but for the spreadsheets which are on my laptop computer and is protected by a username and password which I or carry or lock away Security isn t a concern the students know the names of other students and the details are not of sensitive nature Question 8 Before sports day sheets of paper are printed so that the students can choose what event they do Who is in charge of printing these and where are they kept after they have been filled in by the students Iam in charge of printing out a sheet for each house then all of the students are grouped in their houses and fill on the sheet the events they want to do Once they have been filled in I keep them in the RE office in the sportsday folder Cambridge International AS and A Level Computing 9691 Paper 4 Computing project Question 9 Is there any backup of this data made There is no copy of the paperwork the sheets filled in by the student but there are backups of the spreadsheets used Question 10 During the event How are the results recorded For the track field events it s fairly simple For the throwing events the length is simply measured and then written down same for the jumps For the track eve
176. uggested Training Date 25th of May 5th of June Reason The dates of the closest teacher training day lie between these and are the nearest to the next term Suggested Training Method Teach department coordinators at inset day the coordinators will be able to train their department staff Reason Only a handful of coordinators need to be trained so the time taken will be limited and so the changeover can be ensured System Implementation Plan Method of Implementation Direct Implementation Reason System is to be implemented as soon as possible and due to its simplicity and user friendliness direct implementation is the most feasible Suggested Implementation Date Mid Winter Term 2011 Reason This is next time a POC system is required Evidence of User Testing A meeting was scheduled with the client and end user see project diary The meeting was set up so that the user and client could test the final version of the system in addition to see the written up training and implementation details that had been previously discussed The user was then asked to fill out a questionnaire type document to provide feedback of any problems with the system and write a letter to confirm that she had seen the system and the installation plan and approved for documentation purposed The document is included below as evidence of user testing M School 6 Avenue D M D F BP M C France T l phone O Fax O e mail inform
177. ushi mad fF ap Teper sua prese Arel eE os 4 Erat de 2 Ein Tite ov vto des fe peceduna ponens fe by FEER RIDDLms P Na I ER C TE prre Chead ponerse af fu FREE Li rex d ahh porie do drer onn c azxduidbibigaisinRGEGRAERGERDRRRGERLARAGERRGERGERERSE deb R TEMP ee Freee TEHE rard polaris sipi i pE ee ei ee pe es 2s se o ios ga ici ki su i Li ii bree gii sE la EELS L iS f eres PT SSAC TREE T the panter Jei cel pomtes do ba JE mr 4 Tiori PE bith nere iip Adi es fren IE Bon m n kk Ae Bom oe Be ee a A EE DOE egg go EDGE RON WOES NOH G RD eg DR ER OD R GS RD RC SR S DO UE ER IO RR y FREE Lib a a a meas emm mma rmm reper re Tep rri ee eee ee ee es eee ee ee Sitreblus fio HEAD folio poimt rs um tne cen Pe ee ee PrE a ee ee eee peeve Feo UP PRevieurs EAD then cep pointer PM Sen wie new meee ir de HERI cet HEAD Je TEMP pad mnt a df panter na PRE bior en DLL Hagen SEE Paty n Pi EE 4p TERM E pad peti tut Tet ggn mie maa pies o Nite erp IF ETE B F at et pointer fag PREV EHE e a Balter In PEREviIoUF da TEME evel eeu 110 Cambridge International AS and A Level Computing 9691 Paper 3 Examiner comment Part 1 A clear diagram which illustrates almost all the key points about the linked list values in order start pointer links shown and there is an end of list pointer The candidate has not indicated there would need to be a pool of free spac
178. vent and you are in charge of the event Yes I am currently in charge of that sporting event as well as the current system used to record the scores of the events Question 2 The following questions will relate to the system s use before the actual event Where is all the data such as the students names forms and houses are stored Where does all this data come from The data is stored in a spreadsheet on my laptop All of this data actually comes from the schools database which keeps records of all the students details A copy of the database is then taken and the data is then extracted into the spreadsheet Question 3 Who is in charge of entering the data into the database and then transferring it into the spreadsheet The schools secretary is in charge of entering the data into the school database and I am the one who extracts the data from the schools database into the spreadsheet Question 4 What validations and verifications are used Once the data has been transferred from the database to the spreadsheet I look through the spreadsheet I generally know which students are in which class I also check that there isn t any missing information such as name or gender and check that the student is in the correct house Question 5 Where is the database stored The database is stored on the school server Question 6 How often is the database updated The database is updated at the start of every year and straight away when a new st
179. vice Cambridge International AS and A Level Computing 9691 Paper 1 Question 1 c otate three types of output needed at the point of sale terminals For each type of output explain why the output is needed Mark scheme Sound indicates barcode properly read without operator diverting attention from job sound to indicate terminal is free Video image or screen output or soft copy to allow shopper to check goods and prices as they are input to system Receipt or printout or hard copy to allow shopper to check payments and shopping at home proof of purchases 2 per max 6 6 Example candidate response grade A Ouputt fuo ouem ob a eant ell ia pu Dan ede dia DOLL i TY E N T o habean ipana sees AM Coole Output Jo trzat Lp au pul i eed tly hal ebirPisssEEEPREBRErS ee eee URE toa eer yt te et iededs cbrdedaddbhRRhbebibodGdbehidARNGREEREERARdad Output 3 Hd p ig rem TN tiep ar endi cna lp Da t teh o th Bought pui rae wre uth fe ai lied a W 6 A Cho Dn T Luahkan thaige allo c L rE i dE FE EE FE FERH H pE EE NFHR F FE EENH HT Examiner comment Three good choices were given which were clearly correct types of output The reasons for type of output were well laid out and referred correctly to the application in the question Cambridge International AS and A Level Computing 9691 F Paper 1 Example candidate response gra
180. vowels in a word He starts by writing some pseudocode that will count the number of letter a s 1 INPUT Word 2 Count OQ 3 LOOP FOR Index 1 TO length Word 4 IF Word Index a D THEN 6 Count Count 1 d ENDIF 9 ENDLOOP a i Complete the trace table for this pseudocode using banana as input The first seven rows have been filled in 56 Cambridge International AS and A Level Computing 9691 Paper 2 Mark scheme a i Wod Count Index Word ndex Wordindexi wmw co 6L 1 mark for each correct column except Word column 1 mark for correct sequence 1 mark for readable presentation 6 Cambridge International AS and A Level Computing 9691 57 Paper 2 DO Example candidate response grade A a i Complete the trace table for this pssudocode using banana as input The first seven rows have been filled in Examiner comment Clearly laid out trace table with correct values showing for each variable at every stage The convention of leaving the cell blank when the content has not changed has been followed This gives a clear indication of correctness Cambridge International AS and A Level Computing 9691 Paper 2 Example candidate response grade C Lederer i rola n Wore ijade lera x i fount fet 4 1 e 2 4 SASQ p ow ag Cambridge International AS and A Level Computing 9691 Paper 2
181. w member of the class into the correct position in the list 108 Cambridge International AS and A Level Computing 9691 Mark scheme i ii Either Start 5 NFree 6 Mark as follows Start pointer some value arrows All values included Null pointer Indication of free space Diagram in arrival order in arrival order with correct pointers OR Diagram in alphabetical order with correct pointers OR Array diagram in arrival order correct pointers 1 per max 5 Input Newltem Store Newltem in next free space Set Current to value at Start Read values in list following pointers until Current value in list Newltem Pointer of Previous points to Newltem Newltem points to Current update free space list Start 4 NFree 5 5 Mention of any special cases e g Newltem being First in list list empty list full no free space 1 per max 5 5 Cambridge International AS and A Level Computing 9691 Paper 3 109 Paper 3 Example candidate response grade A B 9 Draw a diagram to show how the following members af e Computing class can be stored in a linked Hel in alphabetic order FRO Tal DON ROS BEV ii ESTE EN amp larithrmi to insert a new member of tine elass inte the correct position n fhe ReaL Lari Check iiObeHuerdhe FREE Hk uapa free dentes iB bed Dace le ei LILIloLi ba miii mia bih te cade eh fn em i eee ne m eer s
182. which are sent to a shared printer on a local network will be spooled Explain how this spooling is carried out Mark scheme bd a Temporarily storing data for output later several computers can send data to be printed at the same time when queuing jobs sent to a single device 1 per max 2 2 b i ii Jobs can be queued to ensure that none are missed Stops jobs being frozen lost when printer unavailable complete documents are printed print jobs are stored on secondary storage jobs can be given a print priority jobs are maintained by a queue priority queue data structure data structure consists of reference data to each print job When printer free job with highest priority at head of queue is printed print files are sent from secondary storage to print buffer 1 per max 4 per dotty max 5 5 Cambridge International AS and A Level Computing 9691 97 Paper 3 Example candidate response grade A a Describe what la meant by tha spooling of fils dei E Komi i NEM pintat of a Ahe opa ge Shen dine adire pe pam Eu A roa A lini eM E eme o me RES 2 BIG See S ua e cuo e gn ems PETTE Se pT cam mhi ddnsbarisd ERR b i Stato why fies which sre sent to a sharod printer on a local network will be spanigd Dort my Jot many IS oie ave n ir oti Joe ptpsie s Ihe ptio tym At diee Koved Avent ns td
183. wing input and output as well as data structures The developed solution does fulfil the design specification ii Programming 5 b marks Teacher comment good technical competence 3 4 Some technical competence in programming shown by formatted meaningful a program listing that makes use of meaningful identifier variable names and names indentation and formatting to show the control annotated structures used The code should be annotated with some Examiner comment comments so that the logic of the solution can be followed agreed Good technical competence in programming shown by a self documented program listing that makes good use of meaningful identifier names indentation and formatting 1 2 A program listing showing code written by the candidate is included 5 to show the control structures used The code should be annotated with comments so that the logic of the solution can be easily followed ii Testing b marks An attempt should be made to show that all parts of the system have been tested including those sections dealing with unexpected or invalid data as well as extreme cases Showing that many other cases of test data are likely to work by including the outputs that they produce is another important feature Evidence of testing is essential Comments by teachers and others are of value but the test plan must be supported by evidence in the report of a properly designed testing process The examiner
184. xecute faster interpreted code will execute slower Interpreter must be present to run the program compiler not needed at runtime Interpreter will translate code in loops more than once Compiler only once once compiled no further translation needed every program execution requires interpreter 1 per max 3 3 Example candidate response grade A Dung wtevprubatrevi Sath utes je BR temelateal asd Seidapa Rgdtpiuadd eneuted before Teuulatiesa T tee HEE 107 o sepang SERERE EHE Hai 1 iani edad Tamen ette ATT iesus mien cde Hn seb wian se SOUTEE epele is Hedeltd When gwentig Wee Oa were eel Hinde rina m ee ee ee ee ee PS ets ee cow la bros Hu uou prse it ibewaelareal Eee oe ET ee DR fhe ESPs Pe RPS Se See sees ee ee es ees ee Pte ee ese F avd a c nwate pico ode file li created ao phat 3 mm EB mmm m m me n on ma a on m c gecm ms momcmcm noa R molo mmm mcm OL ee ee ee ee PSP Ps PETEERE rT djece cond fat merda atferearede Examiner comment A good explanation of the differences between using a compiler and interpreter This is a strong answer the candidate appreciates that the interpretation process does not produce object code one of the more subtle points available on the mark scheme Example candidate response grade C Dattnprtitory in Olurtsa onil akon We md ee ee ee ld PEHARI 4 BS eS EH Se 2 EPH ce Tu TET HISELIBEIGERINWEFHEELRIENEJELIELIZISGEZJELRIERE
185. xt this will display the objects function if you place your cursor over it for 3 seconds Examples below list object type object name form location Text Box txtavg frmcreate average Mark Command Button cmdlogout frmmenu Date First Name Last Name Subject Teacher Form POCGrade 01 10 2010 cia List Box Istdate frmview o1os201 Cambridge International AS and A Level Computing 9691 185 Paper 4 Computing project Common Error Guide Message Username is Typo non existent or no Retype contact admin or incorrect username inputin username enter username textbox Typo non existent or no password input in username textbox Text or value outside 0 100 range input in average mark textbox No mark input in average mark textbox Retype contact admin or enter password Message Password is incorrect Enter numeral value between 0 100 Message Invalid value for average mark Enter value in average mark textbox between 0 100 Move off the object with your cursor and back onto it again waiting 3 seconds Message No average mark input Control tip text will not show up Program momentarily does not recognize cursor or cursor has not being placed on the object for sufficient time administrator Printer is not connected Contact the system administrator Program Stops Responding Various possible
186. xtclt Text Box Displays if the roots of the plant in the current offer will Momm be given in a container and if so the size of the container Source Qryoffer Displays the height of the plant in the offer currently being looked at Source Qryoffer txtcirc Text Box Displays the circumference of the stem of the plant in qoe the offer currently being looked at Source Qryoffer Displays the link to the photo of the plant in the offer currently being looked at Source Qryoffer txtnotes Displays notes about the offer currently being looked at Source Qryoffer Button Button cmdreport Command Opens the report in print preview Button cmdprint Prints the offer currently being looked at Cambridge International AS and A Level Computing 9691 Fes Paper 4 Computing project 176 Bun OOOO 7 Button in imgphoto cmdeditphoto Command Used to edit the offer A file navigation window Button emerges to select the photo The Photo s link gets input into txtphoto cmdremovephoto Removes the link from txtphoto and hides the image Button being displayed in imgphoto cmdsearch Opens access s find function window Button imgphoto Displays the image of the plant from the offer being looked at FrmInput Objects Object Use Name Cbofamily The combo box is filled with the family name values from Tblfamil Cbospecies Combo Box The combo box is filled with the species name values from Tbispeci
187. y e which i5 a 4 stem Jat contarns 2 digis ont O and 1 Examiner comment An excellent answer worth more than the three marks available The candidate gave examples of how integers are stored showing leading zeros etc he answer was very clear with good examples making it much easier for the candidate to explain how integers are represented typically in a computer Diagrams in questions of this type are to be recommended since they make any description much clearer Example candidate response grade C aris represented u Bb cede hirs Inlerers have Hho iial btaa dsi m iband sls Bet costes thetic e tx ed v the Sign bid 1 ren res PPP Pee 2 ee Pees rr ree BI IH ere ee ee ee ee eer ee E a a ee imarsmemnmenel 1 3 dodo bebe eb hdd de eh ede bebe dee ed EEEL ol GOB OO Rees eee ee eee eee Examiner comment The candidate seems to have a reasonable idea of how integers are represented in a computer and understands the use of 8 bits and the sign bit However they were not confident enough to give examples or to show how sign bits and 2s complement tie up Not as much depth as the grade A candidate above Cambridge International AS and A Level Computing 9691 Paper 1 Example candidate response grade E to LO inkggar 19 8 fails be FA ER Examiner comment This is a very vague answer with some reference to bytes and binary numbers 1 and O It was frequent at grade E to see

Cambridge International AS and A Level - Papers

Contents

Download Pdf Manuals

Related Search

Related Contents