INFORMATION & COMMUNICATIONS TECHNOLOGY
ICT Assessment Tasks L2 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
Using databases
16
Task 9
General knowledge quiz
18
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 1
Instructions 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
6
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 Right margin = 2 cm Make the subject heading of the letter (Traveller Satisfaction Survey) bold
7
8
Centre the line which you have just made bold 2
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), give the image a border and insert into your letter.
14
Set tabs for the list of destinations to 2cm for the hotel, 8cm for the country, and alignment left
15
Save your letter with a different filename
16
For both letters insert a header showing your name and a footer showing you’re the filename and path and today’s date.
17
Save and print both of your letters
18
Close the files
3
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. The destinations are: Paradise Hotel, Gibraltar Pacific Heights Hotel, Tasmania Apollonia Beach Inn, Cyprus Royal Oak Hotel, Guernsey Marina Lodge Hotel, Corfu Rising Star Hotel, Sri Lanka
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 4
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 1 2
Instructions Load the spreadsheet programme 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
6
Use suitable formatting to make the headings stand out
5
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
Using an If function show that if the % is equal to or over 50 that it is good and if the % is under 50 it is poor
12
Using conditional formatting format the cells so that the poor cell are red and the good are green 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
6
Use this table to help you with Task 2
Table 2 Hotel
Destination
Paradise Hotel Pacific Heights Hotel Apollonia Beach Inn Royal Oak Hotel Marina Lodge Hotel Rising Star Hotel
Gibraltar Tasmania Cyprus Guernsey Corfu Sri Lanka
Total number of travellers to destination
127 46 76 94 137 31
7
Number of travellers considering holiday represented good value for money 94 19 59 63 109 27
Percentage of travellers considering holiday represented good value for money. %
Good/Poor
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 1
Instructions 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.
2
Include on your chart:
3
a title labelled ‘x’ and ‘y’ axis labelled bars 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
Format the vertical axis so the scale is a maximum of 140 Format the vertical and horizontal axis labels to italics 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
7
Add a footer to your chart showing your name, the date and the filename and path. (Check your footer in preview)
8
Save and print out the chart
9
Close the file 8
Use this chart to help you with Task 3
Number of Travellers
Travel Survey 160 140 120 100 80 60 40 20 0
Total number of travellers to destination Number of travellers considering holiday represented good value for money
Gibraltar Tasmania
Cyprus Guernsey Tourist Destination
9
Corfu
Sri Lanka
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 1
Instructions 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 saved in Task 3 as an object which is linked to file, into the letter after the third paragraph.
(Helpful hint – you may have to adjust the size of the bar chart once it is inserted to fit into the letter.)
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
8
Close the file 10
11
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 1 2 3 4
5 6
Instructions Open your college email (Hint you access your college email through Blackboard, your homepage) Create a new email Send an email to your tutor and attach the letter you created in Task 4 Your email must include: Tutor’s email address Subject Message Attachment Send your email Add your tutor’s email address to your contacts list
12
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 1 2 3
Instructions Using a presentation programme create a presentation for the destinations from task 3 Create a slide for each destination Presentation must include:
A title slide with the title (Destination Guide) formatted as Word Art The destination as the title Name of the hotel as text 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
Add a slide transition to each slide and add a custom animation to each image. Add navigation action buttons to your presentation
7
Insert a slide number and your name and date as a footer
8
Set up your show so that it runs automatically
9
Save your presentation again 13
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 1 2 3
Instructions Open a desktop publishing programme Using the appropriate publication design template create a flyer for one of the destinations The flyer must include: A title Image of the destination Detailed text about the destination (150 words, you may have to use autoflow) Set the text box to two columns Information on cost of holiday Logo 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
Add a coupon for 10% discount on a holiday using. (Hint this
6
Arrange the margins to 2cm for each margin
is done through inserting a design gallery object) 14
7
Save flyer with an appropriate filename
8
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 Using databases To enable you to complete this task, you will need to • access your college email and save the attached customer database excel version into an appropriate folder in your My Documents 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 1
Instructions Import the spreadsheet into a database program and save with an appropriate filename in an appropriate folder
2
Open the file customerstbl
3
Change the account balance column to currency
4
5
Add a new record Mr Ashred Smith, 25 London Road, Ipswich, IP3 2JH, 01473 562986, ashred@sky.com, 14/07/1989 and account balance 13 £450 Save the changes
6
Create a query to find customers who live in an IP postcode
7
Save the query with the filename qryippostcaode
8
Amend the query to find those customers whose account balance is greater than £900 Save the amended query as qrybalance
9
Create a justified autoform form of the customer database 16
10
Create a report of the customer database ensure all details are shown on 1 page
11
Save
12
Screen print your folders and files to show that you have saved your work as asked.
13
Email your files and folders screenshot to you tutor.
17
TASK 9 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 1
Instructions 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?
18