ICT SCQF 5 – Task 2

ICT SCQF 5 – Task 2
Assessed
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 in appropriate alphabetical order.
Put in an extra row at the foot of the table and using formulae display the totals
Put in an extra column at the right of the table and using formulae display the totals
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 relevant data. Display each category and value as a percentage on the pie chart
Create a bar chart comparing the totals
Ensure that both graphics are adequately labelled and captioned
Save and close the spreadsheet
Assessed
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 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
insert one graphic for each in to the new second top row
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
Share with the assessor
Assessed
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
Sign Here