Essential Skills ICT
Initial Assessment Activities
These activities will allow you to demonstrate some of your ICT skills – you are not expected to be able to do any/all of these tasks at this time.
This is not a test however, it is very important that you do not ask your neighbour to help.
If you are unable to do any of these activities, don’t worry, tick this handout beside the things you need to ask about and move on to the next task.
When you’ve completed an activity, move on to the next Activity or if you are finished or cannot continue, sit quietly until you get help or advised otherwise. .
Essential Skills ICT
Print full name here:_____________________________ Activity 1 – Word Processing
Insert the number of the task(s) you need help with
Carry out the following instructions.
1
1. Start the Computer 2. Open a new word processing document.
2
3. Insert an image from clipart into your document. 4. Using bold & italics, insert the text replacing the symbols << and >> 3
and the text enclosed between them with the specified information.
My name is: << insert your full name here >>. I << have/have not >>
4
an email address. I << never/seldom/ regularly >> use the Internet to search for information. I << never/seldom/ regularly>> use CDROMs
5
to do research. I << never/seldom/ regularly >> . use chat rooms e.g. MSN Messenger and << never/seldom/ regularly >> use Bebo 6
5. Insert a footer into your document with the title of your course and today’s date.
7
6. Underline the word Bebo in the paragraph entered. 7. Save this work as activity1 to a folder called Word Processing
8
8. Print the document. 9. Close the application
9
Page 2 of 6
Essential Skills ICT
Print full name here:_____________________________ Insert the number of
10. Open a new word processing document.
the task(s) you need help with
11. In the header or first line enter your name; this should be aligned at the right-hand margin, font size 20.
10
Further information”, aligned-centre.
12. Enter the title: “
Change the font style of this text to: Arial, font size 20.
11
Take a new line. 13. Change the font style to Comic Sans, size 14, and enter the text below, left aligned with double line spacing & using bullets to identify the separate tasks.
12
Each day when I come to ICT class, I will practice the following good habits:
13
1. I will always save my work to the correct folder and at the end of each session, take a backup onto my pen drive. 2. I will name each file I am saving with a title which will indicate the
14
data it contains. 14. When you have finished put a border around the paragraph. 15. Open the document you created earlier, named activity1 from the folder called Word processing.
15
Select the clipart image and copy and paste it in the document. 16
16. In your document ‘activity 1’, insert the title “My ICT Experience
to Date” using any font, style and alignment you feel is suitable for a title.
17
17. Embolden and italicise the text ICT Experience in the title above.
Page 3 of 6
Essential Skills ICT
Print full name here:_____________________________ 18. Save this document as Activity 1b.
Insert the number of the task(s) you need help with
19. Print the document named activity1b.
18
20. Close this file. 21. It has been decided that activity1b should be renamed as activity2. Using My Computer, access the Word Processing Folder on your network drive and make this amendment.
19
20
21
Page 4 of 6
Essential Skills ICT
Print full name here:_____________________________ Activity 2 – Spreadsheets
Insert the number of the task(s) you need help with
22. Open an Excel spreadsheet document. 23. Input the text below as you see it leaving the Total cells blank. 22
24. Use the SUM function to total the ticket sales for each night.
23
25. Centre the heading Cinema Ticket Sales across cells A1:D1 using the merge function
24
26. Create a Bar chart using cells A3:D7. Label the axis appropriately. 27. Insert a footer in the document with your name and today’s date.
25
28. Save this work as activity2 to a folder called Spreadsheets. 29. Print the spreadsheet showing gridlines. 30. Close the application
26
27
Insert the number 28
of the task(s) you need help with
31 29
30 32
Activity 3
33
31. Create a new email with the subject “your name & Activity3-Message1” and include the text below. 34
Page 5 of 6
Essential Skills ICT
Print full name here:_____________________________ Emma, I have completed Activities 1 and 2 and I am sending this email as part of Activity 3. Regards, << Insert your full name here >>.
32. Send this email to
[email protected]
33. Create a new email with the subject “your name & Activity3-Message2” and include the text below.
Emma, I have completed message 2 and I have attached a word document called Activity 1 Regards, << Insert your full name here >>.
34. Attach the word document you created earlier to the email and send to
[email protected]
Page 6 of 6