Unit 1 P7

BTEC 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.

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