IGCSE ICT Training

A Philippine based company want's to have online meeting conference room, can you pick 3 items from the list that are essentials for their conference room ? (Choose all correct answer)

• Computer

• Web-Camera

• Speaker

• Microphone

• Flash disk

What are the advantages of using sensors and microprocessors to monitor the weather of some area rather than manual methods ? (Choose 3)

• It can works 24 / 7

• More safe for human, especially in dangerous area

• More accurate readings

• Needs human to stay in that place

• Animals cannot disturb the machine

Criteria of MODERATED FORUMS are ? (Choose 2)

• Inappropriate post can be deleted by moderators

• Reduces the chance of offensive

  messages.

• Anyone can post anything

• No Moderators

A farmer has purchased a computerized milking system for her cows. She has asked a systems analyst to create a database to store details of the cows being milked.

Examples of the details of the cows which will be stored are in the table.

Which Field Name that use "Decimal" Data Type ?

• Breed_of_cow

• Date_of_birth

• Weight_of_cow

• Average_milk_yield

• Animal_passport_number

A farmer has purchased a computerized milking system for her cows. She has asked a systems analyst to create a database to store details of the cows being milked.

Examples of the details of the cows which will be stored are in the table.

Based on that table, which field would be the most appropriate for the primary key ? and why ?

• Animal_passport_number, because passport number is unique number given to identify the cow

• Date_of_birth, because only one cow can be born for each day of the year

• Weight_of_cow, because all cows have different weight

• Breed_of_cow, because cow breed are unique data

Here's data for Cow with Animal Passport Number 971/2016

If you asked by the farmer, how much milk this cow produce, you can use … functions in excels

• =SUM(B7:B16)

• =AVG(B7:B16)

• =MIN(B7:B16)

• =MAX(B7:B16)

A motor car company has some designers based in London and some in Beijing. The cost of travel between the two cities is very high, so when they wish to meet to discuss new products they use video-conferencing.

Which are the problems that may occur if the designers using video-conferencing systems rather than meeting in either London or Beijing ? (Choose 3)

• Time lag / lip sync caused by the image not being synchronized with the sound

• Confidential material can be leaked if the conference app is hacked

• Different time zones will mean the conference has to take place at inconvenient times

• Cost of travel for normal meeting can be cheaper than making online conference

• The designers needs very big room to held online conference

Find physicals safety issues in this picture ! (Choose 3)

• Electrucution

• Tripping over wires

• Phising

• Computer Virus

• Fire

An auction company sells toys. It uses a spreadsheet to show each person’s items and the amount of money the buyer and seller owe to the company.

Part of the spreadsheet is shown in the pictures.

If the Buyer’s premium is 20% of the Selling price, write a formula to display the Buyer’s premium in cell E6.

The European Space Agency (ESA) is building a new space telescope to orbit the Earth and search for distant galaxies. The ESA is using computer controlled robots to build the lens of the telescope.

Based on that story, what are the disadvantages of using computer controlled robots rather than humans to build the lens ? (Choose 3)

• The equipment's are very expensive to buy

• If something goes wrong, it may be difficult to find the error

• Task / job can be carried out far slower

• Maintenance is very expensive

• Robots cannot work 24/7 / continuously