SFSS 4EX Computing Prelim QP1 2022

[Turn Over SPRINGFIELD SECONDARY SCHOOL Preliminary Examination 2022 Secondary 4 Express/ 5 Normal Academic STUDENT NAME CLASS REGISTER NUMBER COMPUTING 7155/01 Paper 1 Written 12 September 2022 2 hours Candidates answer on the Question Paper. No Additional Materials are required. READ THESE INSTRUCTIONS FIRST Write your class, index number and name in the spaces at the top of this page. Write in dark blue or black pen. You may use an HB pencil for any diagrams, graphs or rough working. Do not use staples, paper clips, glue or correction fluid. Approved calculators are allowed. Answer all questions. The number of marks is given in brackets [ ] at the end of each question or part question. You should show all your working. The total number of marks for this paper is 80. For Examiner’s Use Total /80 Do not turn over this question paper until you are told to do so. ______________________________________________________________________________________________________ This question paper consists of 13 printed pages.

2 1 An administrator of a finance company uses a spreadsheet to record the loans it has given out to car buyers. It records:  loan amount taken  loan period in terms of number of years  interest rate charged per annum  monthly instalment payable  loan amount that is above $50000 or have a loan period of more than 5 years (a) Identify the most appropriate data type for the data in the following cell references: Cell Data type A2 B3 D7 [3] (b) The cell F10 will calculate the total loan amount given out. Identify the function that will need to be entered into F10. ……………………………………………………………………………….…….. [1] (c) The cell F11 will calculate the number of loans that is more than $50000 or has a loan period of more than 5 years. Identify the function that will need to be entered into F11. ……………………………………………………………………………….…….. [1]

3 [Turn Over (d) The cell F7 will indicate “Yes” when the loan that is more than $50000 or has a loan period of more than 5 years, The cell should be blank if otherwise. Describe the formula that will need to be entered in cell F7. …………………………………………………………………………………………. …………………………………………………………………………………………. …………………………………………………………………………………………. …………………………………………………………………………………………. …………………………………………………………………………………………. …………………………………………………………………………………………. ……………………………………………………………………………….…….. [3] 2 (a) Complete the following statements on computer architecture. Most computer parts can be organised into the following roles: The processor consists of the ……………………………………. that processes data by performing basic mathematical logical operation s, and the ……………………………………. follows instructions and decides when data should be stored, received, or transmitted. The ……………………………………. stores data that can be volatile or involatile. The ……………………………………. transport data from one part of the computer to another. The ……………………………………. and ……………………………………. allow user s to enter data and instructions, and to display processed data respectively. [6]

4 (b) The table contains descriptions about types of external storage mediums. Tick () one or more boxes in each row to indicate if the description is about optical, magnetic, or solid-state memory. Statement Optical Magnetic Solid-state Data stored as very small pits Fastest in reading and writing Relatively large storage capacity (at least 1TB) Vulnerable to drops, mechanical shock, scratches and fingerprint [5] 3 (a) Convert the binary number 1001 1101 into a positive whole denary number. …………………………………………………………………………………………. ……………………………………………………………………………….…….. [1] (b) Convert the positive whole number 314 into hexadecimal. Show your working clearly. Answer ……………………………………………………………………………. [2] (c) State two advantages of using hexadecimal notation to represent binary values. 1.………………………………………………………………………………………. …………………………………………………………………………………………. 2.………………………………………………………………………………………. ……………………………………………………………………………….………… [2]

5 [Turn Over 4 (a) An algorithm is designed for a sales record system in a fast food restaurant. The system will record a daily list of the quantity and cost of every item sold in the restaurant. At the end of each day, the system will inform the user on the most popular item sold that day as well as the total earnings for the day. State the inputs, outputs and the processes required for the algorithm. Inputs ……………………………....…………………………………………………. …………………………………………………………………………………………. …………………………………………………………………………………………. Outputs ………….……………………………………………………………………. …………………………………………………………………………………………. …………………………………………………………………………………………. Processes ……………………………………………………………………………. …………………………………………………………………………………………. …………………………………………………………………………………………. …………………………………………………………………………………………. [6] 5 Technology brings about social and economic impact s on various areas of life, as well as related ethical issues. (a) State one positive and one negative social impa cts of technology in healthcare. Positive impact .............................………………………………………………… ………………………………………………………………………………………… ………………………………………………………………………………………… Negative impact ...........................………………………………………………… ………………………………………………………………………………………… ………………………………………………………………………………………… [2]

6 (b) State one positive and one negative social impacts of technology in finance. Positive impact .............................………………………………………………… ………………………………………………………………………………………… ………………………………………………………………………………………… Negative impact ...........................………………………………………………… ………………………………………………………………………………………… ………………………………………………………………………………………… [2] (c) State one ethical issue related to the impact of technology in entertainment. ………………………………………………………………………………………… ………………………………………………………………………………………… …………………………………………………………………………………...… [1] (d) Johnson finds a picture from the Internet very attractive and decides to use it as a logo for his school project straight away. (i) What is the possible infringement he has made by doing so and how can he avoid committing this infringement? …………………………………………………………………………………... …………………………………………………………………………………... …………………………………………………………………………….… [2] (ii) Johnson has also been warned by the teacher against making another type of infringement of intellectual property while doing the writeup for his project. Name and describe this type of infringement. …………………………………………………………………………………... …………………………………………………………………………………... …………………………………………………………………………….… [2]

7 [Turn Over 6 (a) Draw the logic circuit to represent the following Boolean statement. Do not simplify the statement. X = (A NOR B) OR (NOT C AND B) [4] (b) Complete the truth table for the Boolean statement: X = (A NOR B) OR (NOT C AND B) Working space A B C X 0 0 0 0 0 1 0 1 0 0 1 1 1 0 0 1 0 1 1 1 0 1 1 1 [4] X A B C

8 7 (a) Draw one line to link each network term to its correct description. Network term Description Local area network A component that enables the transfer of data between a device and a network Router Network of computing devices connected within the same building such as a school or office Network interface controller A device that converts digital data into a suitable form for transmission Modem Network of computing devices connected typically across m