Friday 22 November 2013

Task 3 - Unit 1























Initial audit

A
I
T
Word Processing



Level 1



I can open a new document
/


I can open an existing document
/


I can save a new document
/


I can save a document using the ‘save as’ facility and I understand why it is important to do so
/


I can format a document
/


I can change fonts
/


I can spell check
/


I can insert text
/


I can insert images
/


I can wrap around text
/


I can use templates appropriately
/


I can use headers and footers appropriately
/


I can use the Thesaurus
/


I can format the background
/


Level 2



I can change the print/page setup
/


I can paginate a document
/


I can import external data from other packages
/


I can use mail merge


/
I can insert footnotes and end notes
/


I can search and replace
/


I can create/format tables
/


I can use Styles
/


I can use Word count
/


Level 3



I can create a customised dictionary
/


I can create an automatic table of contents
/


I can create an index


/
Spreadsheets



Level 1



I can open a new worksheet
/


I can open an existing worksheet
/


I can add new worksheets to exiting ones
/


I can rename worksheets
/


I can move or copy sheets
/


I can add columns
/


I can add rows
/


I can delete columns
/


I can delete rows
/


I can enter data
/


I can copy a formula or a data series along a row or a column
/


I can sort data in ascending and descending order using primary and secondary sort functions
/


I can format data to show different data types
/


I can format data to show different data types, including date
/


I can format data to show different data types, including percentage
/


I can format data to show different data types, including currency
/


I can format cells to show bold
/


I can format cells to show italics
/


I can format cells to show underline
/


I can format cells to show font style
/


I can format cells to show font size
/


I can format cells to show cell border and shading
/


I can format cells to show text alignment and positioning within a cell
/


I can import data
/


I can create formulas
/


I can use functions
/


I can select non-adjacent columns
/


I can use Goal Seek


/
I can create charts/graphs and modify them
/


I can use filters and sort data into order
/


I can amend data on the spreadsheet in order to get different results
/


I can  change font size, type and colour in a cell and over a range of cells
/


I can move cell contents by using the click and drag approach
/


I can create and edit a graph using the chart wizard
/


I can rename worksheets
/


I know how to print formulae
/


I can preview and print spreadsheets using the appropriate orientation
/


Level 2



I can cut and paste data and graphs from spreadsheets into other applications
/


Level 3



I can use absolute cell referencing


/
I can use relative cell referencing


/
I can group worksheets to allow consistent editing of cells in a work book
/


I can use the Paste Special and the Paste Link commands
/


I can use conditional formatting


/
I can merge cell contents
/


PowerPoint



Level 1



I can open a new document
/


I can open an existing document
/


I can save a new document
/


I can save a document using the ‘save as’ facility and I understand why it is important to do so
/


I can format a document
/


I can change fonts
/


I can spell check
/


I can insert text
/


I can insert images, change font and layout
/


I can create and run a slide show
/


I can add animation and transitions
/


I can insert hyperlinks
/


I can add timings and animations to a slide show
/


I can add slides
/


I can amend slides
/


I can delete slides
/


I can create my own backgrounds on a slide
/


I can use backgrounds that are already created
/


I can insert graphics
/


I can use ClipArt
/


I know how to use animations appropriately
/


I know how to edit images by cropping
/


I know how to edit images by resizing
/


I can view a presentation on a mouse click
/


I can set up a show to run automatically on timings
/


I can insert transitions and animations
/


Level 2



I can create a slide master
/


I can import sound – KS 4 & 5
/


I can import video – KS 4 & 5
/


I know how to present printouts as handouts
/


I know how to present printouts as notes pages


/
Email



Level 1



I can send emails
/


I can receive emails
/


I can reply to emails
/


I can forward emails to single recipients
/


I can forward emails to multiple recipients
/


I can attach a file to an email message
/


I can attach multiple files to an email message
/


I can appropriately set the importance of a message
/


Level 2



I can use Cc


/
I can use Bcc


/
I can use an address book appropriately and can store an address
/


I can use an address book appropriately and can retrieve an address
/


I can use an address book appropriately and can use addresses
/


I can create and use an email signature
/


Internet



Level 1



I can navigate to known websites, and do basic searches
/


I can save images from a website as required and use them appropriately
/


I can save text from a website as required and use them appropriately
/


I can connect to the internet using a URL
/


I can navigate around a website
/


I can access and download appropriate information from the internet
/


I can bookmark websites and add to favourites
/


I understand the restrictions of copyright
/


I can use a URL to connect to a website from an intranet
/


I can use a URL to connect to a website from favourites
/


I can use a URL to connect to a website from bookmarks
/


I can use a URL to connect to a website typing accurately
/


Level 2



I can use Boolean Operators to undertake more accurate searches
/


I can save video from a website as required and use them appropriately
/


I can save animations from a website as required and use them appropriately
/


Desktop Publishing (Publisher or Adobe Indesign)



Level 1



I can open a new document
/


I can open an existing document
/


I can save a new document
/


I can save a document using the ‘save as’ facility and I understand why it is important to do so
/


I can format a document
/


I can change fonts
/


I can spell check
/


I can insert text
/


I can insert images, change font and layout
/


I can design documents from scratch
/


I can decide which publication to use at the appropriate time; for example, newsletters, worksheets, brochures, etc.
/


I can use text boxes
/


I can use Word Art
/


I can insert tables
/


I can insert picture frames
/


I can insert Clip Art
/


I can use Shapes and Auto Shapes
/


I can add text
/


I can amend text
/


I can delete text
/


I can use colour
/


I can format backgrounds
/


I can format colours
/


I can format images
/


I can copy text and images
/


I can paste text and images
/


I can move text and images
/


Level 2



I can use templates
/


I can use text effects
/


I can insert tables
/


I can edit tables
/


I can reposition tables
/


I can resize tables
/


Multimedia (cameras, scanners etc.)



Level 1



 I can use a digital camera
/


I can use a digital camcorder
/


I can transfer images from a camera to a computer and edit these images
/


I can use software to import images into appropriate applications
/


I can use software to import images into appropriate applications, including Moviemaker
/


I can use software to import images into appropriate applications, including Publisher
/


I can crop and change file size and format as appropriate to purpose, e.g. save as jpeg
/


Level 2



I can use software to import images into appropriate applications, including Photo Editor
/


I can recognise the difference between different image files, such as vector based
/


I can recognise the difference between different image files, such as bitmapped
/


I can use a scanner to import images into appropriate applications
/


I can use a scanner to capture images
/