The two main components of a computer system are hardware and software. Answer the following general questions.
a) Name two (2) primary computer hardware components that are used for data input. (2 marks)
b) Briefly explain each of the following:
i) System software (1 mark)
ii) Application Software (1 mark)
c) What is the acronym or initials ROM stands for? (1 mark)
d) Name two secondary storage devices (2 marks)
a) The spreadsheet in figure 9 contains the data for sales person, sales amount collected and bonus rate. To get the bonus amount, the bonus rate must be multiplied by the sale amount collected.
i. Write the correct excel formula that should go to cell F5 so that, when this formula is selected and copied to all cells in column F, the correct amount will be calculated. (2 marks)
ii. What is the bonus rate in percentage (%)? (1 mark)
iii. Write the function that should go to cell E11, to calculate the total amount collected. (2 marks)
iv. Name the menu option to use in order to combine the column name ‘Sales Person’ in C4 with D4 so that there is only one header for columns C and D. (1 mark)
b) A pivot table in MS Excel can be used to ___________data. (1 mark)
a) What is the purpose of ‘backing up’ your data regularly? (2 marks)
b) Is it appropriate or allowed for anyone to download any photo or images from the World Wide Web to use anytime? (1 mark)
c) Give two (2) examples of what a computer can be used for, in a government hospital. (2 marks)
d) Mary and Tim are accountants in an insurance company. According to company policy, each employee must use his or her own password to access the insurance system. Passwords are administered by the company’s systems administrator. On a particular day, Tim forgot his password and asked to use Mary’s password for an urgent job on the system. Mary was reluctant to share her password with Tim.
i. What would be a valid reason, besides the company policy, why Mary should not share her password? (1 mark)
ii. What should Tim do immediately? (1 mark)
a) List two (2) methods of wireless connections that can allow people to use devices to transfer or receive data.
b) In setting up a LAN for data communication, TCP/ IP should also be set on computers in the network. What do these acronyms stand for?
c) Name two (2) specialized software that can be used for accounting purposes at work. (2 marks)
d) Name one (1) network topology that can be used to design a network.
a) What is the purpose of inserting hyperlinks on web pages?
b) Name a multimedia type or effect that can be found on a website.
c) What is the common file extension for a web page?
d) Explain each of the following terms.
i) html document
ii) html editor