ictt

Question 1

What is the purpose of a “keyfield”

Answer 1

The unique identifier

Question 2

What sensors can you get that may be linked to a burglar alarm?

Answer 2

Movement sensor
Light sensor
Pressure sensor
Make/Break sensor (if window broken)

Question 3

How do you calculate the average across cells?

Answer 3

=AVE(C2:C15)

Question 4

What is a Carbon copy email?

Answer 4

Same email sent to more than one person at same time.

Question 5

What is meant by email?

Answer 5

electronic message sent online sent to computer

Question 6

Name types of software

Answer 6

Data logging
Word processing
Data publishing
Presentation software

Question 7

disadvantages of email

Answer 7

phishing
hacking (change passwords)
viruses
file size limitation (compression)
spam/junk mail (block sender)

Question 8

wildcard

Answer 8

a character that will match any character or sequence of characters in a search.

Question 9

Encryption

Answer 9

encryption is the process of encoding a message or information in such a way that only authorized parties can access it and those who are not authorized cannot

Question 10

How can you minimise errors (data input)

Answer 10

Verification and validation

Question 11

What is software?

Answer 11

Programs that give the computer its instructions.

Question 12

What is hardware?

Answer 12

The devices which make up a computer system

Question 13

What does the word digital mean?

Answer 13

Using 0s and 1s for storing or communicating data

Question 14

Data can’t be checked to see if its correct but can be….

Answer 14

checked to see if its sensible or that its been copied correctly

Question 15

How can you compress music? Why?

Answer 15

In an mp3 to make it smaller and faster to download however a reduction in quality.

Question 16

WAP?

Answer 16

Wireless Application Profile

wap phones can access internet

Question 17

Difference between credit card and debit card?

Answer 17

Debit card- already have the money and the shop takes it straight from your bank
credit card- a company sends you the money and you pay the back later

Question 18

What is a database used for?

Answer 18

Storing data and producing useful reports

Question 19

What is a spreadsheet used for?

Answer 19

Anything involving formulas and numerical calculations (think profits etc for companies)

Question 20

What is an OMR

Answer 20

Optical Mark Reader

Question 21

What is an MIS

Answer 21

Management information system

Question 22

VLE?

Answer 22

Virtual Learning environment

Question 23

Name 3 slide transitions

Answer 23

dissolve, wedge, wipe down

Question 24

What is a file

Answer 24

A file is an object on a computer that stores data, information, settings, or commands used with a computer program.

Question 25

An application used for searching or sorting?

Answer 25

Database

Question 26

Application used for calculations?

Answer 26

Spreadsheet

Question 27

What is personal information?

Answer 27

Name, email address, phone number, home address, school name, bank details

Question 28

Common health issues technology?

Answer 28

Strain injuries (eye) so limit time on it
Back pain from being in the same position. Get a proper chair with an adjustable back.
Mental illness, could encourage depression due to isolation from others.

provide anti-glare screen filters

Question 29

Safety issues

Answer 29

Tripping over wires
Fire- too many devices plugged into one mains outlet.
Electrocution- spilling drinks

Question 30

What is Data Logging

Answer 30

Data logging is the collection of data over a period of time

Question 31

What sensors used in hospitals?

Answer 31

Pulse-rate
Temperature
Breathing rate

Question 32

Outputs used in hospitals?

Answer 32

A large display / monitor
A loud buzzer / alarm
A small printer can produce a hard-copy of the data

Question 33

How can you sort the highest/lowest achievers on a spreadsheet without using a sort format?

Answer 33

MIN(D1:D7)

MAX(D1:D6)