2022 BVSS 4E Computing Prelim P1 - Marking Scheme

1 Marking Scheme Q1 1 mark for each correct line. Maximum 4 lines. Description Spreadsheet Function FLOOR.MATH() Returns the integer portion of a division. HLOOKUP() Returns the remainder after a number is divided by a divisor. MOD() Rounds a number down to the nearest integer. OR() Looks for a value in the top row of a table or array of values and returns the value in the same column from a row specified. QUOTIENT() [4m] Q2 2(a) 35 employee names of string data types and 35 employee reporting times of date data type [1m] Note: Accept if the student specifies some valid range or dd-mm-yyyy or time. 2(b) Names of employees who are late for more than 3 times in the month and their average number of minutes late, rounded to appropriate accuracy. [1m] 2(c) List [1m] Any one of the following. Maximum 1 mark. ● A list of items can be indexed. In this case, the list can be used to store the 35 records. ● A repetition / loop can be used to process the list of 35 records and this makes the program code more concise.

2 Q3 3(a)(i) Any 1 from the following. Maximum 1 mark. ● Shared resources: A network allows a group of computers to make use of shared resources such as printers or files. ● Shared Internet access: Depending on the network’s configuration, every user who logs on to the network may have access to the Internet. ● Shared software: Software can be stored on the central server of a network and deployed to other computers over a network. ● Shared storage: Data files can be stored on a central server for ease of access and backup purposes. ● Communication: Computers in the same network are often able to share instant messages and emails for communication. 3(a)(ii) Any 1 from the following. Maximum 1 mark. ● Initial costs: Installing a network could be costly due to the high setup and equipment costs. ● Maintenance costs: There are also subsequent costs associated with administering and maintaining the network. ● Security risks: As files are shared through a network, there is the risk of virus or worm attacks spreading throughout the network even with just one infected computer. ● Risk of data loss: Data may become lost due to hardware failures or errors. Using a network means regular data backups are needed. ● Server outage: If the server fails, the network will not be able to function, thus affecting work processes.

3 3(b) 1 mark for identified network device and 1 mark for the description. Maximum 2 marks Network Device Description Network interface controller (NIC) NIC provides the hardware interface to enable the transfer of data between a device and a network. Network hub A device that transmits the received packets to all connected devices on the same network. Network switch A device that constructs a single network by connecting multiple similar networks together and it uses MAC addresses to k