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