43

310

10

00

1INSTRUCTIONS TO CANDIDATES

Use black ink or black ball-point pen. Do not use pencil or gel pen. Do not use correction fluid.Write your name, centre number and candidate number in the spaces at the top of this page.Answer all questions.Write your answers in the spaces provided in this booklet.If you run out of space, use the continuation page at the back of the booklet, taking care to number the question(s) correctly.

INFORMATION FOR CANDIDATES

The number of marks is given in brackets at the end of each question or part-question.Quality of written communication will be assessed in question 10.

SJJ*(S16-4331-01)

Surname

Other Names

CandidateNumber

0

CentreNumber

MAY1643310101 © WJEC CBAC Ltd.

GCSE

4331/01

INFORMATION AND COMMUNICATIONTECHNOLOGYUNIT 1: Understanding ICT(Short Course) INFORMATION ANDCOMMUNICATION TECHNOLOGYUNIT 1: Understanding ICT

A.M. WEDNESDAY, 18 May 2016

1 hour 30 minutes

S16-4331-01

For Examiner’s use only

MaximumMark

MarkAwarded

Total 80

2

(4331-01)02

Examineronly

Answer all questions.

1. A school is organising a Summer Fayre to raise funds.

(a) State which software type would be the most suitable for completing the following tasks. [3]

(b) The first draft of a poster has been created and is shown below.

© WJEC CBAC Ltd.

Task Software Type

Creating a slide show to inform students of the Fayre in an assembly

Creating a letter to send to parents informing them of the Fayre

Automatically recording the number of people entering the Fayre

Saturday 25th June 2016

School Field at 2 pm

Summer Fayre

(4331-01) Turn over.

43

310

10

00

3

03

3Examiner

only (i) Tick (√) the correct boxes below to show three features of Desk Top Publishing

(DTP) software used on the poster. [3]

Feature Tick (√)

Bullet points

Table

Gradient background

AutoShape

Underline

Centre Text

Clip Art

(ii) DTP software could also be used to create other types of documents to help with the Fayre.

Name two types of document, other than letters and posters, and give a different use for each in organising the Fayre. [2x2]

Type of Document 1

Use . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Type of Document 2

Use . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

© WJEC CBAC Ltd.

1

2

3

4

5

6

7

(c) Phishing and viruses are disadvantages of using email. State two other disadvantages of email and describe a different prevention for each. [4]

4

(4331-01)04

Examineronly

2. (a) Many schools use email. Explain what is meant by an email. [2]

(b) Tick (√) the correct boxes below to show whether the following statements about email are True or False. [5]

© WJEC CBAC Ltd.

Statement True False

You can create folders to store and organise your emails.

Using the cc feature will hide all other recipients from each other.

You can add attachments of any file size to an email.

You can add signatures to your emails to give personal contact details.

You can only send emails from a laptop computer.

(4331-01) Turn over.

43

310

10

00

5

05

5Examiner

only

© WJEC CBAC Ltd.

3. Tick (√) the correct box below to show whether each of the following is data, information or knowledge. [4]

4. Many people use Geographical Information Systems (GIS) for navigation. Give three advantages and one disadvantage of the use of GIS for navigation. [4]

Advantage 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Advantage 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Advantage 3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Disadvantage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Data Information Knowledge

The school quiz team with 45 points had the highest points of the day and were the winners

45, 44, 27, 17, 7

45 points, 44 points, 27 points, 17 points, 7 points

Quiz Team A consisted of Katie, Jodie, Ryan, Jamie and Tomas

1

4 5

8

11 12

9

6

7

10

2 3

5. A school has created a database to organise the stalls at the Summer Fayre. Part of the database is shown below.

(a) State how many records are shown in the above database. [1]

(b) State how many fields with a Boolean data type are shown in the database. [1]

(c) Identify the key field and give the purpose of the key field. [2]

(d) The caretaker needs to find out how many medium or large stalls are required. Complete the tables below to show how the caretaker can obtain this information from the database.

[2]

6

(4331-01)06

Examineronly

© WJEC CBAC Ltd.

StallID Stall Type Stallholder

Name Year Popular Last Year

TeacherSupervision Stall Size Date

Booked

3 Pin the Tail S Webb 9 N Y Large 07/03/201612 Cakes H Smith 9 Y N Small 28/03/20167 Bric-a-brac D Jones 10 Y N Medium 28/03/201611 Badges W Davies 10 Y N Small 09/05/20165 Tombola N Khan 10 N N Medium 37/05/20166 Refreshments P Taylor 11 Y N Medium 09/05/20162 Photo booth A Rose 11 Y Y Large 23/05/20169 Book stall J Miller 12 Y N Small 08/02/2016

Field Name Operator Search Criteria

=

OR

Field Name Operator Search Criteria

=

(4331-01) Turn over.

43

310

10

00

7

07

7Examiner

only

© WJEC CBAC Ltd.

(e) Name the field that has been sorted into ascending order. [1]

(f) The database contains an error. State the error and describe a suitable validation technique that could have prevented the error. [3]

6. A spreadsheet has been created to organise the cost of the Summer Fayre, as shown below.

(a) State the number format used in cell D6. [1]

(b) Name the spreadsheet formatting feature that has combined cells A1 – F1. [1]

(c) Which of the following formulas could be used to give the Total Outgoings in cell F6? [1]

A =SUM(D3:D6) B =D6+D11+D17 C =SUM(B6:D17) D =D6+D11

(d) The school need to set the ticket price to break even. Give a suitable formula for calculating the Ticket Price in cell F9. [1]

8

(4331-01)08

Examineronly

© WJEC CBAC Ltd.

A B C D E F1 SUMMER FAYRE 20162 OUTGOINGS Estimated Number Attending3 Item Number Required Cost per item Total 4004 Marquee 2 £350.00 £700.005 Stall tables 45 £3.00 £135.00 Total Outgoings6 Total £835.00 £2,035.0078 Entertainment Number of Hours Cost per Hour Total Ticket Price9 School dance group 3 £0.00 £0.00 £5.0910 Local band 2 £25.00 £50.0011 Total £50.001213 Refreshments Total Unit Price Total14 Hot dogs 400 £1.50 £600.0015 Fruit salad 300 £1.00 £300.0016 Bottles of water 500 £0.50 £250.0017 Total £1,150.00

(4331-01) Turn over.09

9Examiner

only

© WJEC CBAC Ltd.

(e) Give three advantages of using spreadsheets to help organise the finances for an event. [3]

Advantage 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Advantage 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Advantage 3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

(f) Spreadsheets can use absolute and relative cell referencing. Explain the difference between these types of cell referencing. [2]

43

310

10

00

9

7. ICT has many uses in schools.

(a) Tick (√) one of the methods of electronic registration listed below and give two different advantages and two different disadvantages of your chosen method. [4]

Biometric Methods

Swipe Cards

Advantage 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Advantage 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Disadvantage 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Disadvantage 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

(b) Virtual Learning Environments (VLE) allow students to access revision material and to submit work. Give one advantage and one disadvantage of using a VLE for students.

[2]

Advantage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Disadvantage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

10

(4331-01)10

Examineronly

© WJEC CBAC Ltd.

(4331-01) Turn over.11

11Examiner

only

© WJEC CBAC Ltd.

8. Webcams are used to access webcam services.

Explain what is meant by the term webcam and give one use, one advantage and one disadvantage of using a webcam to access webcam services. [4]

Use . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Advantage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Disadvantage . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

9. Many people book their flights online.

(a) Give two items of data that may need to be verified by the customer when completing an online booking form and give a suitable different verification check for each. [2x2]

(b) Give four advantages of booking flights online to the customer. [4]

Advantage 1 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Advantage 2 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Advantage 3 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

Advantage 4 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . .

12

(4331-01)

Examineronly

(c) Give one disadvantage of online booking to the customer. [1]

© WJEC CBAC Ltd.12

(4331-01) Turn over.13

13Examiner

only10. Computer gaming is a popular method of home entertainment.

• Give three input devices used for computer gaming.

• Name two health hazards associated with computer gaming, describe how they could occur and for each give a different prevention.

• Describe other advantages and disadvantages of computer gaming. [13]

Remember that the quality of written communication will be assessed in this question.

© WJEC CBAC Ltd.

END OF PAPER

14

(4331-01)14

Examineronly

© WJEC CBAC Ltd.

BLANK PAGE

PLEASE DO NOT WRITEON THIS PAGE

(4331-01)15 Turn over.

15

© WJEC CBAC Ltd.

Questionnumber

Additional page, if required.Write the question number(s) in the left-hand margin.

Examineronly

16 (4331-01)

16

© WJEC CBAC Ltd.

(4331-01) Turn over.

17

Examineronly

Questionnumber

Additional page, if required.Write the question number(s) in the left-hand margin.

17 © WJEC CBAC Ltd.

Questionnumber

Additional page, if required.Write the question number(s) in the left-hand margin.

Examineronly

18 (4331-01)

18

© WJEC CBAC Ltd.

BLANK PAGE

PLEASE DO NOT WRITEON THIS PAGE

(4331-01)19

19

© WJEC CBAC Ltd.

BLANK PAGE

PLEASE DO NOT WRITEON THIS PAGE

(4331-01)20

20

© WJEC CBAC Ltd.