INFORMATION & COMMUNICATIONS TECHNOLOGY

ICT Assessment Tasks L1 Contents: Page Task 1 Using a Wordprocessor 2 Task 2 Using a Spreadsheet 5 Task 3 Creating a Chart 8 Task 4 Importing a Spreadsheet Table and Chart into a letter 10 Task 5 Using Email 12 Task 6 Using Presentations 13 Task 7 Using desktop publishing software 14 Task 8 General knowledge quiz 15

2

TASK 1 Using a Word processor To help you complete this task, you have: • a list of detailed instructions to follow (below) • a copy of a letter to use (see next page) Please follow the instructions carefully. If you have any difficulty in understanding what is required or if you have a problem of any kind, don’t hesitate to ask your tutor or assessor for some guidance. Step Instructions 1 Load the wordprocessor

2 Type the text of the letter (see next page) into the

wordprocessor

3 Save your letter with a suitable filename into a folder called Wordprocessing

4 Use the spelling and grammar checker to correct any typing errors, spelling mistakes and grammar mistakes

5 Format your letter to Comic Sans, italic, size 12 Format the letter in the following way, so it would fit onto headed paper: Top margin = 4 cm Bottom margin = 2 cm Left margin = 3 cm

6

Right margin = 2 cm 7 Make the subject heading of the letter (Traveller

Satisfaction Survey) bold

3

8 Centre the line which you have just made bold

9 Right align the name, address and date

10 Save your letter again with same filename

11 Using the find and replace edit tool replace Ross with Brown

12 Justify the main text of your letter

13 Using the internet, search for and save a suitable picture to include at the top of your letter. Save the picture with a suitable filename under your pictures folder. Change the size of one dimension of the image to 4cm (maintaining aspect ratio) and insert into your letter.

14 Save your letter with a different filename

15 For both letters insert a header showing your name and a footer showing the filename and path and today’s date.

16 Save and print both of your letters

17 Close the files

4

Use this copy letter to help you with Task 1 Mr Gordon Ross Customer Services Manger Quest Travel Limited 35 Pilkington Square Warmington SK1 3JW Today’s date Dear Mr Ross Traveler Satisfaction Survey Please find enclosed the results of a recent survey carried out with a specially-selected group of travellers. The table shows the responses to six of the locations we propose two include in our brochure with effect from next summer. Our aim has been to provide excellent value for money and the survey concentrated particularly on this aspect. We have chosen destinations which, we believe, will cater for a wide variety of tastes and the hotels all offer an excellent range of facilities both on site and nearby. Your travel agency has always recommended us highly and I believe that hour extended range of holiday packages will give further scope for expanding your business. I look forward to receiving your comments in future. Yours sincere Helen Wicker Business Development Manger

5

TASK 2 Using a Spreadsheet To help you complete this task, you have: • a list of detailed instructions to follow (Table 1 below) • a table of data (Table 2 on next page) Please follow the instructions carefully. If you have any difficulty in understanding what is required or if you have a problem of any kind, don’t hesitate to ask your tutor or assessor for some guidance. Table 1 Step Instructions 1 Load the spreadsheet programme 2 Enter the data from Table 2 into a new spreadsheet. You will

need to change the width of the columns. (Helpful hint – to make the text in the column headings ‘wrap’ around so that your table is easy to read and will fit the page, place the cursor in the required cell/s, select Format select Cells click on the Alignment Tab click on the Text Wrap Box.)

3 Enter a formula into the last column of the spreadsheet to calculate the percentage of tourists who have considered that the cost of their holiday represented good value for money. (Helpful hint – to calculate the percentage, you need to divide the number of those who felt they had received good value for money by the total number of people who travelled to each destination and multiply by 100.)

4 Replicate (copy) the formula down the column

5 Format the figures in the percentage column to whole numbers (0 decimal places)

6 Give the column headings a fill colour

6

7 Format the cells so that they have a border around them

8 Underneath the Total number of travellers to destination data use a

Sum formula to calculate the total number of travellers to all destination

9 Underneath the Number of travellers considering holiday represented good value for money data use a Sum formula to calculate the total number of travellers who considered the holiday represented good value for money

10 Using the formula: total number of travellers – total number of travellers who considered the holiday represented good value for money Calculate how many travellers did not consider the holiday good value

11 Save the spreadsheet with a suitable filename

12 Print the spreadsheet

13 Show your formulas and save this view with a different filename

14 Print the spreadsheet showing the formulas

7

Use this table to help you with Task 2 Table 2

Hotel Destination Total number of travellers to destination

Number of travellers considering holiday represented good value for money

Percentage of travellers considering holiday represented good value for money. %

Paradise Hotel Gibraltar 127 94 Pacific Heights Hotel Tasmania 46 19 Apollonia Beach Inn Cyprus 76 59 Royal Oak Hotel Guernsey 94 63 Marina Lodge Hotel Corfu 137 109 Rising Star Hotel Sri Lanka 31 27

8

TASK 3 Creating a Chart

To help you complete this task, you have: • a list of detailed instructions to follow (below) • a bar chart for you to use as a model (see next page) Please follow the instructions carefully. If you have any difficulty in understanding what is required or if you have a problem of any kind, don’t hesitate to ask your tutor or assessor for some guidance. Step Instructions 1 Using the spreadsheet you created in Task 2, draw a bar chart

to show the number of travellers to each destination and the number of those who considered their holiday had been good value for money. Your chart should look very similar to the example on the next page.

a title labelled ‘x’ and ‘y’ axis

2

Include on your chart:

labelled bars 3 Your chart should be placed as a new sheet, not, as an object in

the worksheet

4 Format the bars of your chart so each bar is a different colour

5 Save the bar chart (depending on the programme you are using, it might be saved automatically with the spreadsheet, or you may need to save it separately with a suitable filename)

6 Add a footer to your chart showing your name, the date and the filename and path. (Check your footer in preview)

7 Print out the chart

8 Close the file

9

Use this chart to help you with Task 3

Travel Survey

020406080

100120140160

Gibraltar Tasmania Cyprus Guernsey Corfu Sri Lanka

Tourist Destination

Num

ber o

f Tra

velle

rs

Total number of travellers todestination

Number of travellers consideringholiday represented good value formoney

10

TASK 4 Importing a Spreadsheet into a Letter To enable you to complete this task, you will need the: • letter file you saved during Task 1, • spreadsheet file you saved during Task 2 • bar chart you created as part of Task 3. Please follow the instructions carefully. If you have any difficulty in understanding what is required or if you have a problem of any kind, don’t hesitate to ask your tutor or assessor for some guidance. Step Instructions 1 In the wordprocessor, open the letter file you saved in Task 1

2 Copy the spreadsheet table you saved in Task 2 and paste it

into the letter after the second paragraph

3 Insert the bar chart you saved in Task 3 into the letter after the third paragraph. (Helpful hint – you may have to adjust the size of the bar chart to fit into the letter. You could do this either in the spreadsheet programme, or in the wordprocessor, depending on how you import or copy the chart.)

4 In the first paragraph of the letter, change the words “Please find enclosed” to “I am pleased to inform you of”

5 Try to fit the letter on to a single page. (Helpful hint – you might need to make the chart smaller, change the font size of the text or change the margins.)

6 Save the file with a new filename so that you have both versions of the letter document

7 Print the document

11

8 Close the file

9 Screen print your folders and files to show that you have saved your work as asked, and print out.

10 Finally save all of your files to the tutor’s memory stick in a folder named as you, or email your files to your tutor.

12

TASK 5 Using Email

To enable you to complete this task, you will need the • letter file you saved during Task 4, Please follow the instructions carefully. If you have any difficulty in understanding what is required or if you have a problem of any kind, don’t hesitate to ask your tutor or assessor for some guidance. Step Instructions 1 Open your college email (Hint you access your college email

through Blackboard, your homepage) 2 Create a new email 3 Send an email to your tutor and attach the letter you

created in Task 4 Tutor’s email address Subject Message

4 Your email must include:

Attachment 5 Send your email

13

TASK 6 Using Presentations

To enable you to complete this task, you will need the

• The information about the hotels and destinations from task 3

Please follow the instructions carefully. If you have any difficulty in understanding what is required or if you have a problem of any kind, don’t hesitate to ask your tutor or assessor for some guidance. Step Instructions 1

Using a presentation programme create a presentation for the destinations from task 3

2

Create a slide for each destination

A title slide with the title (Destination Guide) formatted as Word Art The destination as the title Name of the hotel as text

3

Presentation must include:

Relevant image for the destination (images must be found on the Internet and saved to file before inserting them)

4

Save your presentation

5

Format the background to a colour of your choice

6 Insert a slide number and your name and date as a footer

7 Save your presentation again

14

TASK 7 Using desktop publishing software To enable you to complete this task, you will need the

• The information about the hotels and destinations from task 6

Please follow the instructions carefully. If you have any difficulty in understanding what is required or if you have a problem of any kind, don’t hesitate to ask your tutor or assessor for some guidance. Step Instructions 1

Open a desktop publishing programme

2

Using the appropriate publication design template create a flyer for one of the destinations

A title Image of the destination Text about the destination Information on cost of holiday Logo

3

The flyer must include:

Contact details for the holiday company: Quest Travel Limited 35 Pilkington Square Warmington SK1 3JW

4

Change the colour scheme and font scheme for the flyer

5

Save flyer with an appropriate filename

6

Email the flyer to your tutor as an attachment (Hint to access your email you need to go via the Internet and the college Blackboard page)

15

TASK 8 General Knowledge Quiz Please follow the instructions carefully. If you have any difficulty in understanding what is required or if you have a problem of any kind, don’t hesitate to ask your tutor or assessor for some guidance. Step Instructions 1 Write your answers using word processing software

2 Answer the following questions:

Questions: 1. It is important that data stored in computer systems is

kept safe. List three ways in which data be stored safely.

2. How can attack by viruses be prevented?

3. What is the Data Protection Act for?

4. Name an input device?

5. Name an output device?

6. How should you sit at a computer?

7. What health risks are associated with using a computer for long periods of time?

8. What allows you to find websites if you do not know the

website address?

9. A software application which allows you to display web pages is called …………?

10. What is an ISP? And why is it important?