ICT - Unit 1: P6, P7, P8

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

https://docs.google.com/document/d/1W6BUkzL1zo8J7n2nkh8FNl7G8jlGuv5hOvlRseWvLHA/pub