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





This comment has been removed by the author.
ReplyDeletewww.P4 Your website, calendar and coursework demonstrate a range of
ReplyDeleteeffective interpersonal skills
www: the above skills audit demonstrates you have successfully identified your training needs as part of your development plan.
P7 part achieved.
www. Abbie this evidence shows that you have used Google calendar to produce a personal development plan. Well done. P7 fully achieved now.
P8 is to follow a personal development plan, your calendar clearly states where you developed your training needs. Excellent work.
www: the printscreens of training show you have D2 reviewed progress on a personal development plan, identifying areas for your improvement.