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