P6-Dummies Guide

P7 & P8

Skills Audit

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	A
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	A
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			T
I can use mail merge	A
I can insert footnotes and end notes	A
I can search and replace	A
I can create/format tables	A
I can use Styles	A
I can use Word count	A
Level 3
I can create a customised dictionary			T
I can create an automatic table of contents	A
I can create an index			T
Spreadsheets
Level 1
I can open a new worksheet	A
I can open an existing worksheet	A
I can add new worksheets to exiting ones	A
I can rename worksheets	A
I can move or copy sheets	A
I can add columns	A
I can add rows	A
I can delete columns	A
I can delete rows	A
I can enter data	A
I can copy a formula or a data series along a row or a column	A
I can sort data in ascending and descending order using primary and secondary sort functions			T
I can format data to show different data types	A
I can format data to show different data types, including date	A
I can format data to show different data types, including percentage	A
I can format data to show different data types, including currency	A
I can format cells to show bold	A
I can format cells to show italics	A
I can format cells to show underline	A
I can format cells to show font style	A
I can format cells to show font size	A
I can format cells to show cell border and shading	A
I can format cells to show text alignment and positioning within a cell	A
I can import data	A
I can create formulas	A
I can use functions	A
I can select non-adjacent columns	A
I can use Goal Seek			T
I can create charts/graphs and modify them	A
I can use filters and sort data into order			T
I can amend data on the spreadsheet in order to get different results	A
I can  change font size, type and colour in a cell and over a range of cells	A
I can move cell contents by using the click and drag approach	A
I can create and edit a graph using the chart wizard			T
I can rename worksheets	A
I know how to print formulae	A
I can preview and print spreadsheets using the appropriate orientation	A
Level 2
I can cut and paste data and graphs from spreadsheets into other applications	A
Level 3
I can use absolute cell referencing			T
I can use relative cell referencing	A
I can group worksheets to allow consistent editing of cells in a work book	A
I can use the Paste Special and the Paste Link commands	A
I can use conditional formatting	A
I can merge cell contents			T
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	A
I can insert images, change font and layout	A
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	A
I can amend slides	A
I can delete slides	A
I can create my own backgrounds on a slide	A
I can use backgrounds that are already created	A
I can insert graphics	A
I can use ClipArt	A
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	A
I know how to present printouts as handouts	A
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	A
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			T
I can use Bcc			T
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	A
I can create and use an email signature	A
Internet
Level 1
I can navigate to known websites, and do basic searches	A
I can save images from a website as required and use them appropriately	A
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	A
I understand the restrictions of copyright	A
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			T
I can save video from a website as required and use them appropriately	A
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	A
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	A
I can insert tables	A
I can insert picture frames	A
I can insert Clip Art	A
I can use Shapes and Auto Shapes	A
I can add text	A
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	A
I can paste text and images	A
I can move text and images	A
Level 2
I can use templates	A
I can use text effects	A
I can insert tables	A
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	A
I can use a digital camcorder	A
I can transfer images from a camera to a computer and edit these images	A
I can use software to import images into appropriate applications	A
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	A
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	A
I can use a scanner to import images into appropriate applications	A
I can use a scanner to capture images			T

 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	A
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	A
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			T
I can use mail merge	A
I can insert footnotes and end notes	A
I can search and replace	A
I can create/format tables	A
I can use Styles	A
I can use Word count	A
Level 3
I can create a customised dictionary			T
I can create an automatic table of contents	A
I can create an index			T
Spreadsheets
Level 1
I can open a new worksheet	A
I can open an existing worksheet	A
I can add new worksheets to exiting ones	A
I can rename worksheets	A
I can move or copy sheets	A
I can add columns	A
I can add rows	A
I can delete columns	A
I can delete rows	A
I can enter data	A
I can copy a formula or a data series along a row or a column	A
I can sort data in ascending and descending order using primary and secondary sort functions			T
I can format data to show different data types	A
I can format data to show different data types, including date	A
I can format data to show different data types, including percentage	A
I can format data to show different data types, including currency	A
I can format cells to show bold	A
I can format cells to show italics	A
I can format cells to show underline	A
I can format cells to show font style	A
I can format cells to show font size	A
I can format cells to show cell border and shading	A
I can format cells to show text alignment and positioning within a cell	A
I can import data	A
I can create formulas	A
I can use functions	A
I can select non-adjacent columns	A
I can use Goal Seek			T
I can create charts/graphs and modify them	A
I can use filters and sort data into order			T
I can amend data on the spreadsheet in order to get different results	A
I can  change font size, type and colour in a cell and over a range of cells	A
I can move cell contents by using the click and drag approach	A
I can create and edit a graph using the chart wizard			T
I can rename worksheets	A
I know how to print formulae	A
I can preview and print spreadsheets using the appropriate orientation	A
Level 2
I can cut and paste data and graphs from spreadsheets into other applications	A
Level 3
I can use absolute cell referencing			T
I can use relative cell referencing	A
I can group worksheets to allow consistent editing of cells in a work book	A
I can use the Paste Special and the Paste Link commands	A
I can use conditional formatting	A
I can merge cell contents			T
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	A
I can insert images, change font and layout	A
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	A
I can amend slides	A
I can delete slides	A
I can create my own backgrounds on a slide	A
I can use backgrounds that are already created	A
I can insert graphics	A
I can use ClipArt	A
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	A
I know how to present printouts as handouts	A
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	A
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			T
I can use Bcc			T
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	A
I can create and use an email signature	A
Internet
Level 1
I can navigate to known websites, and do basic searches	A
I can save images from a website as required and use them appropriately	A
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	A
I understand the restrictions of copyright	A
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			T
I can save video from a website as required and use them appropriately	A
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	A
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	A
I can insert tables	A
I can insert picture frames	A
I can insert Clip Art	A
I can use Shapes and Auto Shapes	A
I can add text	A
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	A
I can paste text and images	A
I can move text and images	A
Level 2
I can use templates	A
I can use text effects	A
I can insert tables	A
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	A
I can use a digital camcorder	A
I can transfer images from a camera to a computer and edit these images	A
I can use software to import images into appropriate applications	A
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	A
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	A
I can use a scanner to import images into appropriate applications	A
I can use a scanner to capture images			T

 v