evidence for D2; absolute and relative cell references

Unit 1 - Task 6 - M3

Evidence for D2 - how to goal seek

this is a print screen of when i carried out a goal seek. i done this on the 14th of october.

Unit 1 - Task 5 - D1

Evidence for D2 - how to mail merge

the above print screen show me doing mail merge on the 14th of october

Task 3 - P7 - P8

BTEC National Skills audit : ICT

Trainee

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