Wednesday, 13 November 2013

Skills Audit

BTEC National Skills audit: ICT

Trainee
Kyle Mair
School
Kingswood Secondary Academy



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
a


Level 1
a


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

a

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


a
I can create an automatic table of contents


a
I can create an index


a
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
a


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


a
I can create charts/graphs and modify them
a


I can use filters and sort data into order

a

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
a


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


a
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

a

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
a


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
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 favorites
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 favorites

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

a