Thursday, 24 October 2013
Unit 1 Task 4 Dummies Guide with correction M2
After reviewing the document I have found several mistakes requiring correction. For the first page there are quite a few alignment issues. The two text boxes at the bottom of the screen are overlapping so you are unable to read the text. In the bottom left hand text box the font size is bigger than the other text boxes, this means that only half of the text can be seen. All of the arrows on this page are also out of line, so do not point to the correct point on the screenshot. Also many of the arrows are overlapping text and making it hard to read. There are two spelling mistakes on this page, "Formating" should be "Formatting" and "Color" Should be "Colour".
There is a spelling mistake on the second page. "Scrol" should be "Scroll". Also again the arrows are out of line with the screen shots so they are not pointing at what the text is describing. All the problems on the second page are similar to those on the first page/
Wednesday, 23 October 2013
Wednesday, 16 October 2013
Unit 1 Task 3 Skills Audit
BTEC National Skills audit : ICT
Trainee
|
Rosey Sellars
|
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
|
/
|
|
|
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
|
/
|
|
|
Subscribe to:
Posts (Atom)