Monday, 8 June 2015

Unit 1 Task 3 P4 P7 & P8



Unit 1 Task 3 P4 P7 & P8

BTEC National Skills audit : ICT

Trainee
Devis Cojan
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



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


Posted by at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)