Communications Software

Question 1

What is a search engine

Answer 1

A search engine allows a user to enter keywords or phrases to locate relevant websites

Question 2

What does URL stand for

Answer 2

Uniform Resource Locator

Question 3

Http =

Answer 3

Protocol

Question 4

Www. =

Answer 4

World Wide Web

Question 5

Ccea =

Answer 5

Domain name

Question 6

/ICT

Answer 6

Folder

Question 7

Org

Answer 7

TLD

Question 8

.uk

Answer 8

Country code

Question 9

What does TLD stand for

Answer 9

Top level Domain

Question 10

Four main features of Email software

Answer 10

• Inbox
• Date and Time
• The Subject box
• The Address Book

Question 11

What does Cc stand for

Answer 11

Carbon copy

Question 12

What does Bcc stand for

Answer 12

Blind carbon copy

Question 13

What does VLE stand for

Answer 13

Virtual Learning Environment

Question 14

3 advantages of VLE

Answer 14

• Shared resources for teaching and learning
• Access to multimedia
• An organises central storage method

Question 15

Services available to pupils on VLE

Answer 15

• Ability to upload files
• Access to a personal timetable
• Participation in online discussion forms

Question 16

Services for teachers on VLE

Answer 16

• Tools for administration
• Reporting on pupil progress
• Tracking tools that allow teachers to monitor work

Question 17

Test you should conduct on a presentation

Answer 17

• To ensure that there are no grammar or spelling mistakes
• To ensure that all pictures are present
• To ensure that all hyperlinks and buttons link to the correct slides

Question 18

Define Query

Answer 18

A query facility allows users to search or select r cords from the database which fit certain criteria

Question 19

What does CSV stand for

Answer 19

Comma-separated variable

Question 20

4 features of a spreadsheet

Answer 20

• They perform calculations
• They allow results to be displayed in tabular or graphical format
• They consist of a table divided into rows and columns to produce cells
• They consist a number of worksheets

Question 21

Conditional formatting

Answer 21

Conditional formatting allows you to apply cell shading or front colour to a cell if a specified is condition is true

Question 22

Definition + example of SUM function

Answer 22

The SUM function calculates the total of a Group of selected cl, values
E.g =SUM(C5:H5)

Question 23

Average function

Answer 23

the average function calculates the average of a group of selected cell values
E.g =AVERGAE(C5:C16)

Question 24

MAX function

Answer 24

The max function finds the largest value stored in group of cells
E.g =MAX(15:16)

Question 25

IF function

Answer 25

The IF function sets the cell value depending on the result of examining a condition
E.g teachers wanted to give a score over ‘95’ “excellent” and the rest “well done”
If Grand total > THEN ‘Excellent’ ELSE ‘Well done’

Question 26

Define Absolute Cell Reference

Answer 26

A cell reference that does not change when copied and will automatically update relevant formula to the new row or column
E,g $F$3

Question 27

Spreadsheet tests

Answer 27

• It meets the user requirements
• The formulas Work
• recalculation are automatic