Unit 1 Task 3

TEC 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.

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

Unit 1 P2, P3, and M1

Unit 1 P3

There are many barriers that can disrupt the effectiveness of communication between people. If these barriers are not dealt with, communication can break down and lead to misunderstanding

and ineffective communication. In order for communication to happen successfully, the two or more people must gain a full understanding of what each other is saying, and how they will interpret it.

Badly Expressed Message: Due to the obscurity of language there is always a possibility of wrong interpretation of the messages from one person to another. This barrier is created because of the wrong choice of words, in civil words, the wrong sequence of sentences and frequent repetitions. This may be called linguistic chaos.

Symbols or Words with Different Meanings: A symbol or a word can have different meanings. If the receiver misunderstands the communication, it becomes meaningless. In modern language, a few words can have multiple meanings and if somebody misinterprets what you are saying as a result of this, communication can break down.

Technical Jargon: Generally, it has been seen that the people working in an enterprise are connected with some special technical group who may have their own separate technical language used between each other.

Their communication is not so simple and has to be understood by everybody. e.g. industrial engineer. Hence, technical language can be a barrier in communication if someone doesn't understand the technical terms.

Lack of attention: if somebody is trying to complete a task whilst somebody is trying to speak to them, they will block out a lot of the information that the person is passing on to them because the majority of their concentration will be on their work. This leads to a misunderstanding of information which may lead to a misinterpretation. This can also occur as a result of carelessness, and people forgetting what the person has told them because they were not paying attention to them.

Lack of confidence: Top-level superiors think that the lower- level employees are less capable and, therefore, they ignore the information or suggestions sent by them. They deliberately pay no attention to information passed on or suggested from people of a lower-level to them. As a result of this, their confidence with be negatively affected and they will be less open to communication with a variety of people.

Distrust: For successful communication to occur the transmitter and the receiver must trust each other. If there is a lack of trust between them, the receiver will always derive an opposite meaning from the message that they receive from the transmitter. Because of this, communication will become meaningless.

Lack of basic communication skills: If the transmitter has poor communication skills, then the receiver is less likely to gain a clear and depth understanding of what it is that they are saying to them. If the receiver is unable to gain a great understanding of what information is passed onto them, communication will break down and become meaningless.

Unit 1 P1

Unit 1 P1

Attitudes	Description of attitude.	Why do employers value this attitude.
Hard working	Willing to put maximum effort in when completing assignments.	To get work done quicker and to a higher standard. Harder working people are usually more likely to be rewarded e.g. promotion.
Independent	Being able to work efficiently by yourself without needing help from others.	They will be able to spend less time helping out employees with work and can rely on them to produce satisfactory work at all times.
Determined	Wanting to do something, working hard for it.	You can’t expect to have a successful business with no determined employees.
Tolerant	Listening to other people when they speak and knowing how to behave correctly within the workplace.	If a business's employees are tolerant there is a smaller chance of confrontation to occur within the workplace. Also employees will follow instructions a lot better and complete work quicker.
Leadership	Ability to organize a group to achieve a common goal.	So that an employee is able to control a group of people to get work done. If a group all have a common goal instructed by their leader, then the goal is more likely to be achieved a lot quicker.
Dependable	Trustworthy and to be able to rely on them to perform successful.	So that employees do not let you down and you can rely on the employees to complete work exactly how asked.
Confident	Having belief in yourself to perform successfully.	So that employers know that their employees are capable of finishing work. If employees believe that they can complete work well, then employers are more likely to trust them to do so.
Problem solving	Being able to overcome any problems in order to benefit.	So that workers don’t give up at any sight of trouble. If an employee finds himself stuck, they will not need help to get back to their normal self, you can rely on them to solve the problem.

General attributes (for any job)

Attribute	Description of attribute	Why do employers value this attribute
Planning skills	Ability to decide on how you will do something in the future.	So that workers don’t find themselves lost at work and know exactly what they should be doing e.g. planning a presentation so that they can get the information across to their audience much more effectively due to their plan.
Organisational skills	To be able to systematically organize something in to a correct manner.	So that work doesn't get lost by your employees. If an employee spend time completing work and doesn't save it, then they have wasted a lot of time and will have to waste more useful time to complete the work they did not save.
Time management	To be able to understand the time you have to do something and plan how much time will be spent on each task.	So that work is done on time. If an employee spends too long completing a task then they will not have enough spare time to complete other overdue tasks, and will therefore fall behind.
Verbal skills	Ability to talk to people with confidence and pass on clear information.	So people confidently talk to each other and give help. Employees with good verbal skills can pass on much clearer information in terms of work, meaning that these instructions can be interpreted much more effectively.
Written skills	Ability to write grammatically. Show good written communication skills.	Can come in handy when needing to write letters or instructions etc. Can get clearer information passed on to other people.
Numeracy	Being talented mathematically and being good with numbers.	If working out figures is needed to be done, someone with an attribute of numeracy can offer help. E.g. an accountant within a business to keep on track of finances.
Creativity	To be able to come up with bright, thoughtful ideas by yourself.	Supplies new material to work with that nobody else can think of, this means that a business with creative employees are more likely to stand out above their competitors.

Specific attributes (ICT Job related)

Attribute	Description of attribute	Why do employers value this attribute
Technical knowledge	To know how technology works and how to use it efficiently.	Employees won’t need training when being inducted into a business in which complicated software is in use all the time.
Good working procedures	Following company guidelines for good behavior, following company policies.	So you follow the way you are told to work with no issues. This is valued because employees will not need to be updated on how to behave within the workplace and they will cause no conflicts between employees.
Health and safety	Being safe and disciplined in protection of yourself and others.	So that no injuries occur at work. This is valued by employers because if there are no workplace injuries, then they will not have to pay out and compensation, fines, etc. If someone is injured at the workplace then it builds up a bad reputation for the business.
Security	Being free of danger or threat.	So that no workers feel in danger in the workplace, if employees feel safe in the workplace then they can work more effectively because they will not be thinking about possible dangers.
Keeping up to date with technology	Knowing how new technology works and being able to notice changes in recent technologies.	So that no confusion becomes an issue when working. If a business introduces new technology into the workplace, an employee who has kept up to date with the new technology will be able to train other employees on how to use the technology.