Task 1: Performing ICT operations Carry out the following two activities:
Show that you can use hardware responsibly and take account of other users’ needs
Present information in the appropriate way for the chosen activity, eg printed, displayed on screen, through multimedia files, or share a file safely and securely
Task 2: Processing information Carry out the following three activities.
1 – You are required to analyse the following data provided by local house builders. It shows how many homes of different types have been built by each builder during the past year.
Builder
1-bed flat
2-bed flat
3-bed flat
2-bed semi
3-bed semi
Detached house
Probuild
16
22
8
28
32
17
Smith Builder
0
24
0
16
8
3
Andy Preston
29
22
10
0
12
0
Buildgood
6
18
0
0
0
21
Sinchouse
3
6
0
4
18
0
Raulton
0
12
0
8
34
0
McKinnone
15
34
8
40
44
18
Using your spreadsheet software, enter the data, producing a well formatted layout
Print a copy of the resulting spreadsheet or save it to cloud based storage for sharing with your assessor
Rearrange the spreadsheet with the builders in alphabetical order.
Put in an extra row at the foot of the table and using formulae display the total number of each type of home built
Put in an extra column at the right of the table and using formulae display the total number of homes build by each builder
Print out a copy of the resulting spreadsheet or save it to cloud based storage for sharing with your assessor
Create a pie chart showing the proportions of the total numbers of the different types of homes built. Display each category and value as a percentage on the pie chart
Create a bar chart comparing the total number of homes built by each of the builders
Ensure that both graphics are adequately labelled and captioned
Save and close the spreadsheet
2 – You are required to use your word processor to prepare a short report
based on the data from the spreadsheet in part 1
Create a new document and write a short paragraph describing the data existing in the spreadsheet
Open the spreadsheet and copy the spreadsheet data, pasting it as a table
in the word processor
In the word processor extend the table by two additional rows at the top
In the new top row, merge the cells and insert a suitable title for the table
Your assessor will supply you with six graphics. In the new second top row,
insert one graphic for each house type
Copy the pie chart and the bar chart created in the spreadsheet graphics to
the word processor document as graphics
Write a short paragraph for each graphic, briefly describing what it shows
Format all aspects of the whole document to give it a uniform appearance
and supply a title for it
Save and print out a copy of the resulting document or save it to cloud
based storage for sharing with your assessor
3 – Using the database of client contact details below, which you will use in a mail merge
First Name
Last Name
Company Name
Email Address
Address
City
Postal Code
Country
John
Smith
ABC Enterprises
john.smith@abc.com
123 Business Street
London
SW1A 1AA
United Kingdom
Jane
Doe
XYZ Solutions
jane.doe@xyzsolutions.com
456 Innovation Avenue
Manchester
M1 1AD
United Kingdom
Emily
Brown
Creative Co.
emily.brown@creativeco.uk
789 Design Road
Glasgow
G1 2AB
United Kingdom
David
White
Tech Dynamics
david.white@techdyn.com
101 Tech Lane
Birmingham
B1 1AA
United Kingdom
Alice
Miller
Green Solutions
alice.miller@greensol.com
11 Eco Street
Edinburgh
EH2 3AB
United Kingdom
Ben
Mitchell
BuildTech Group
ben.mitchell@buildtech.com
22 Engineer Way
Newcastle
NE1 4AA
United Kingdom
Catherine
Moore
Innovate Labs
catherine.moore@inno.com
33 Discovery Road
Leeds
LS1 5AD
United Kingdom
Write a short business letter describing the report you have produced
Create place holders for the address and name of the recipient
Use your database software to create a file of clients whose surname begins with the letter M
Carry out the mail merge, using the file just produced, only creating documents for recipients whose surname begins with the letter M
Print out the letters
Task 3: Finding information Discuss the topic of your search with your assessor then:
1 – Draw up a search strategy, including points such as:
likely sources
the order in which sources will be searched
suitable search terms (keywords)
2 – Carry out the searching process.
3 – Evaluate the items of information you find for suitability and reliability.
4 – Evaluate your search strategy in the light of the information you have found.
5 – Document your search.
Task 4: Keeping information safe Carry out each of the following:
1 – Provide an explanation of the importance of password security and multifactor authentication.
