Blog

5.3.1 Which function would be used in cell C15 to determine how many students scored 80 marks or more? (1) 5.3.2 Even though the marks in cells C4:C13 were formatted to the nearest whole number, the total of all the marks in cell C16 shows a value after the decimal point. Explain why this is   happening by referring to the difference between using formatting and using the ROUND function. (2) 5.3.3 Name the most suitable data type that should be used in cells D4:D13. (1) 5.3.4 Name a function that could be used in column D to automatically give the answer ‘Yes’ or ‘No’, based on the marks in column C. (1)     [9]     [62]

QUESTION 3:  SYSTEMS TECHNOLOGIES Study the specifications of the computer below and answer the questions that follow. Right click the button below and select open link in a new tab to see the picture. HP Pro x2    612 Core i5 1.6 GHz 8 GB RAM 256 GB SSD 12.2” touch screen 1x USB 3.0 Wireless 7260AN a/b/g/n + BT, 4G, LTE, Ethernet 10/100/1000 Windows 10 Pro 64

If you need an extra upload please use this question.

QUESTION 4:  INTERNET TECHNOLOGIES 4.1 You own a company which has offices in three different cities. What type of network would the company have? (1) 4.2 Which network device is required for connecting a LAN to another network? (1) 4.3 State two possible advantages of using a cabled network instead of a wireless network. (2) 4.4 VoIP software, such as Skype, is becoming increasingly popular to use. Give two reasons why more people are currently using Skype than in the past. (2) 4.4.1 Give one reason why the video and sound quality is sometimes poor when using Skype to make a video call. (1) 4.4.2 Suggest one way in which the sound quality of a VoIP call can be improved without ending the session or changing any hardware. (1)     [9]

Which of these conditions is not considered to be part of metabolic syndrome?

With which condition should you use caution when administering oxygen? 

1.2 Give the most appropriate term that BEST describes each statement. Write down the full term of your choice next to the question number. No abbreviations – no acronyms.   1.2.1 A very large computer used for processing for thousands of users at the same time.   1.2.2 A type of design that focuses on the health needs of the user.   1.2.3 A term which describes the combining of many different devices into a single device.   1.2.4 A device which combines hardware and software to prevent unauthorised access to a network or the sending of unauthorised data from the network.   1.2.5 An Internet site which is used as a personal diary to share with friends or to share ideas with customers.     (5)  1.3 True or False. Read the statement. Write the statement number and either true or false next to it.   1.3.1 Converting is the process of transferring data from a database to a spreadsheet without simply copying and pasting.   1.3.2 Sticky keys allow disabled users to press a combination of keys such as Ctrl, Alt and Del separately instead of together.   1.3.3 Throttling is a practice where employees bring their own devices to access and use the company network.   1.3.4 A query is used to collect data from a group of people.   1.3.5 A section break makes it possible to have different page orientations in the same document.     (5)   [20]

A 2-year old always puts his teddy bear at the head of his bed before he goes to sleep.  The parents ask the nurse if this behavior is normal.  The nurse should explain to the parents that toddlers use ritualistic patterns to establish which factors?

The parents of a preschooler ask the nurse how to handle their child’s temper tantrums. Which technique should the nurse include in the teaching plan? Select all that apply

The parent asks the nurse about a 9-year old child’s apparent need for between meal snacks, especially after school. what information should the nurse include in the teaching plan?