Unit 1 Task 3

Unit 1 Task 3

TEC National Skills audit : ICT

Trainee

School

The Kingswood School

Subject Audit:

This Subject Audit is designed to help you review your own ICT knowledge and to identify those areas where you anticipate that you may need support.  Throughout Unit 1 you will need to regularly review the development of your subject knowledge as a vital element in your training experience.

How to assess your knowledge:

In the spaces provided on the following pages please classify your status by ticking against the three point scale:

A	I	T
Advanced: can complete task without thinking	Intermediate: can complete task but has to think about it or ask teacher for a reminder.  This needs to be added to the training plan as a low priority Training need.	Training required: This needs to be added to the training plan as high priority training need.

	A	I	T
Word Processing
Level 1
I can open a new document	X
I can open an existing document	X
I can save a new document	X
I can save a document using the ‘save as’ facility and I understand why it is important to do so	X
I can format a document	X
I can change fonts	X
I can spell check	X
I can insert text	X
I can insert images	X
I can wrap around text	X
I can use templates appropriately	X
I can use headers and footers appropriately	X
I can use the Thesaurus	X
I can format the background	X
Level 2
I can change the print/page setup	X
I can paginate a document			x
I can import external data from other packages			x
I can use mail merge			X
I can insert footnotes and end notes	x
I can search and replace	X
I can create/format tables	X
I can use Styles	X
I can use Word count	x
Level 3
I can create a customised dictionary			X
I can create an automatic table of contents			X
I can create an index		X
Spreadsheets
Level 1
I can open a new worksheet	X
I can open an existing worksheet	X
I can add new worksheets to exiting ones	x
I can rename worksheets	X
I can move or copy sheets	X
I can add columns	X
I can add rows		X
I can delete columns	X
I can delete rows		X
I can enter data	X
I can copy a formula or a data series along a row or a column			X
I can sort data in ascending and descending order using primary and secondary sort functions			X
I can format data to show different data types			X
I can format data to show different data types, including date		X
I can format data to show different data types, including percentage			X
I can format data to show different data types, including currency			X
I can format cells to show bold	X
I can format cells to show italics	X
I can format cells to show underline	X
I can format cells to show font style	X
I can format cells to show font size	X
I can format cells to show cell border and shading	X
I can format cells to show text alignment and positioning within a cell		X
I can import data		X
I can create formulas			X
I can use functions			X
I can select non-adjacent columns			X
I can use Goal Seek			X
I can create charts/graphs and modify them			X
I can use filters and sort data into order			X
I can amend data on the spreadsheet in order to get different results		X
I can  change font size, type and colour in a cell and over a range of cells	X
I can move cell contents by using the click and drag approach	X
I can create and edit a graph using the chart wizard		X
I can rename worksheets	X
I know how to print formulae			X
I can preview and print spreadsheets using the appropriate orientation			X
Level 2
I can cut and paste data and graphs from spreadsheets into other applications	X
Level 3
I can use absolute cell referencing			X
I can use relative cell referencing			X
I can group worksheets to allow consistent editing of cells in a work book			X
I can use the Paste Special and the Paste Link commands			X
I can use conditional formatting		X
I can merge cell contents			X
PowerPoint
Level 1
I can open a new document	X
I can open an existing document	X
I can save a new document	X
I can save a document using the ‘save as’ facility and I understand why it is important to do so	X
I can format a document	X
I can change fonts	X
I can spell check	X
I can insert text	X
I can insert images, change font and layout	X
I can create and run a slide show	X
I can add animation and transitions	X
I can insert hyperlinks	X
I can add timings and animations to a slide show	X
I can add slides	X
I can amend slides	X
I can delete slides	X
I can create my own backgrounds on a slide	X
I can use backgrounds that are already created	X
I can insert graphics	X
I can use ClipArt	X
I know how to use animations appropriately	X
I know how to edit images by cropping	X
I know how to edit images by resizing	X
I can view a presentation on a mouse click	X
I can set up a show to run automatically on timings		X
I can insert transitions and animations	X
Level 2
I can create a slide master		X
I can import sound – KS 4 & 5		X
I can import video – KS 4 & 5		X
I know how to present printouts as handouts		X
I know how to present printouts as notes pages			X
Email
Level 1
I can send emails	X
I can receive emails	X
I can reply to emails	X
I can forward emails to single recipients	X
I can forward emails to multiple recipients	X
I can attach a file to an email message	X
I can attach multiple files to an email message	X
I can appropriately set the importance of a message		X
Level 2
I can use Cc			X
I can use Bcc			X
I can use an address book appropriately and can store an address			X
I can use an address book appropriately and can retrieve an address			X
I can use an address book appropriately and can use addresses			X
I can create and use an email signature		X
Internet
Level 1
I can navigate to known websites, and do basic searches	X
I can save images from a website as required and use them appropriately	X
I can save text from a website as required and use them appropriately	X
I can connect to the internet using a URL	X
I can navigate around a website	X
I can access and download appropriate information from the internet	X
I can bookmark websites and add to favourites	X
I understand the restrictions of copyright	X
I can use a URL to connect to a website from an intranet	X
I can use a URL to connect to a website from favourites	X
I can use a URL to connect to a website from bookmarks	X
I can use a URL to connect to a website typing accurately	X
Level 2
I can use Boolean Operators to undertake more accurate searches		X
I can save video from a website as required and use them appropriately			X
I can save animations from a website as required and use them appropriately	X
Desktop Publishing (Publisher or Adobe Indesign)
Level 1
I can open a new document	X
I can open an existing document	X
I can save a new document	X
I can save a document using the ‘save as’ facility and I understand why it is important to do so	X
I can format a document	X
I can change fonts	X
I can spell check	X
I can insert text	X
I can insert images, change font and layout	X
I can design documents from scratch	X
I can decide which publication to use at the appropriate time; for example, newsletters, worksheets, brochures, etc.	X
I can use text boxes	X
I can use Word Art	X
I can insert tables	X
I can insert picture frames	X
I can insert Clip Art	X
I can use Shapes and Auto Shapes	X
I can add text	X
I can amend text	X
I can delete text	X
I can use colour	X
I can format backgrounds	X
I can format colours	X
I can format images	X
I can copy text and images	X
I can paste text and images	X
I can move text and images	X
Level 2
I can use templates	X
I can use text effects	X
I can insert tables	X
I can edit tables	X
I can reposition tables	X
I can resize tables	X
Multimedia (cameras, scanners etc.)
Level 1
I can use a digital camera			X
I can use a digital camcorder			X
I can transfer images from a camera to a computer and edit these images			X
I can use software to import images into appropriate applications			X
I can use software to import images into appropriate applications, including Moviemaker			X
I can use software to import images into appropriate applications, including Publisher		X
I can crop and change file size and format as appropriate to purpose, e.g. save as jpeg	X
Level 2
I can use software to import images into appropriate applications, including Photo Editor	X
I can recognise the difference between different image files, such as vector based	X
I can recognise the difference between different image files, such as bitmapped	X
I can use a scanner to import images into appropriate applications		X
I can use a scanner to capture images	X