SPSS 2018 P1 Solution

Sec 4 Prelims 2018 P1 Marking Scheme 1 Function Description MAX Returns the most frequently occurring or repeated value in the given numbers or the given range/cell references LARGE Returns a user-defined number of characters starting from a position of the text value text MODE.SNGL Returns the largest number out of the given numbers or the numbers in the given range/cell references Returns the kth largest number in a range of cells 2a 182 , correct working 2b 11110101, correct working 2c 22, correct working 3 Processor registers ALU / control unit control unit / ALU RAM ROM Secondary storage 4a Data bus Any two of the following: • Carries / transports data / example of data ... • … that is currently being processed / that will be / has been processed • Data can travel in both directions (bidirectional) 4b Address bus Any two of the following: • Carries / transports an address / location … • … of the next item to be fetched • Data travels one way (unidirectional)

5a Language designed for humans to communicate instructions to computers 5b *Compiler / #Interpreter 5c Based on 5b’s answer: *Compiler translates source code into machine code completely before running the compiled program #Interpreter translates source code into machine code while the interpreted program is running 5d Based on 5b’s answer: *Programs run at a faster speed because all the translation has been done beforehand / Compiler is not needed to run after compilation is complete / Syntax errors are detected before program is even run #Changes to the source code take effect immediately / Facilitates learning and experimentation as interpreters usually offer an interactive mode 6 Inputs: Names of 50 employees (string), Contract amount of 50 employees (float) [2 marks] Outputs: Name of the employee who secured the biggest contract and its contract amount. [2marks] Processes: Store the names with the corresponding contract amounts in an array/list. Search the list for the biggest contract amount and output the name of the employee and the contract amount. [2marks] 7 Error: count Correction: count=0 Error: PIN = PIN%10 Correction: PIN = PIN//10 or PIN = PIN/10 Error: IF PIN == 5 Correction: IF count == 5 Error: UNTIL PIN >= 1 Correction: UNTIL PIN < 1 8a Phishing It uses emails and fake websites that appear to be from reputable companies in order to steal personal information from users. 8b Any two of the following: • Email uses a generic greeting, “Dear Customer DBS”, suggesting that it was sent automatically and not by a person • Email has grammatical, spelling and punctuation errors, “verifivation”, “for your safety access has been locked”, that suggest it is not from a legitimate source • Tone of email is excessively urgent or threatening, “Thank you for your immediate attention to this matter”. • Email uses a generic sign off with no indication of the departme