Staff ICT Skills Audit Questionnaire

Note: please FILL IN a questionnaire on this page per each school and the pages from 3 to 6 per each teacher with ICT knowledge.
When completing this questionnaire please note the following guidelines.

For recording your level of confidence against the items on the following questionnaire would you please use the 1-5 scale provided.
Examples of typical responses at each level are given below.

1/ I am not aware of this application/function/operation.
2/ I am aware of this function/operation but not experienced in using/implementing it.
3/ I have used/done this occasionally but need further practice/training to be confident.
4/ I am a regular and confident user of this application/operation.
5/ I am fully competent with this application/operation and could confidently explain it to others.

Does the school have access to the following technologies for administering and delivering the curriculum?
Yes No

Staff room computer
Intranet access
Internet access
Office software (Word, Excel, Access, Powerpoint)
Web publishing software (e.g. Frontpage)
Graphics software (e.g. Coraldraw, fireworks)
Printer
Transparencies for printer/copier
Scanner
CD writer
Digital photo camera
Video camera
Laptop computer
Data projector
Electronic whiteboard
Interactive whiteboard
Tablet PC
Pupils ICT room
Interactive whiteboard

The school uses (circle):
Windows 98 XP 2003
Linux
Mac
Open Office or Microsoft Office

Staff ICT Skills Audit
General ICT knowledge and skills
Name of the teacher:
Please circle your level of confidence along a scale of 1 – 5 (please refer to separate guidelines)

Computer management
• locate and run a programme (software application) 1 2 3 4 5
• use CD-ROM-based software 1 2 3 4 5
• organise your electronic files into folders 1 2 3 4 5
• search for files on the computer system 1 2 3 4 5
• move files between drives (e.g. from A: to I) 1 2 3 4 5
• print to various networked printers 1 2 3 4 5

Computing hardware and environment
• connect up the computer and its peripherals 1 2 3 4 5
• use a scanner for copying images 1 2 3 4 5
• use a scanner for capturing text (OCR) 1 2 3 4 5
• use a digital camera for capturing images 1 2 3 4 5
• use a data projector 1 2 3 4 5
• aware of computer security, copyright and the law 1 2 3 4 5
• aware of Health and Safety issues relating to the computing 1 2 3 4 5
environment

Word Processing
• use simple editing e.g. bold, italics, centring, font size etc 1 2 3 4 5
• use a spellchecker 1 2 3 4 5
• import text and images into a word processed document 1 2 3 4 5
• include tables in a document 1 2 3 4 5
• lay out text and images 1 2 3 4 5
• use templates for standard documents 1 2 3 4 5
• create new document templates 1 2 3 4 5
• divide the page layout into columns 1 2 3 4 5
• use headers and footers 1 2 3 4 5
• use the drawing tools to create shapes and Autoshapes 1 2 3 4 5
• mail merge 1 2 3 4 5
• save a document in various file formats including HTML 1 2 3 4 5

Spreadsheets
• input data in rows and columns 1 2 3 4 5
• auto filling series 1 2 3 4 5
• sort data 1 2 3 4 5
• input formulae 1 2 3 4 5
• replicate formulae along rows/columns 1 2 3 4 5
• produce charts and graphs for data analysis 1 2 3 4 5
• add headers and footers 1 2 3 4 5
• use a spreadsheet to make predictions 1 2 3 4 5
• understand and use relative and absolute cell-referencing 1 2 3 4 5
• display/hide formulae 1 2 3 4 5
• password protect a spreadsheet 1 2 3 4 5

Databases
• set up a database 1 2 3 4 5
• create and format fields in a database 1 2 3 4 5
• enter and update data in a database 1 2 3 4 5
• create different layouts for data entry forms and reports 1 2 3 4 5
• sort data 1 2 3 4 5
• filter data 1 2 3 4 5
• create and run a query 1 2 3 4 5
• produce a report 1 2 3 4 5

Presentation
• create a basic presentation package 1 2 3 4 5
• add clipart to slides 1 2 3 4 5
• modify colours of text, lines and spaces on a slide 1 2 3 4 5
• introduce animation onto slides 1 2 3 4 5
• modify transition between slides 1 2 3 4 5
• edit a master slide 1 2 3 4 5
• incorporate a data chart or graph 1 2 3 4 5
• incorporate an organisational chart 1 2 3 4 5
• rearrange slides within a presentation 1 2 3 4 5
• produce appropriate handout formats 1 2 3 4 5

Using the Internet
• access an Internet site via its website address 1 2 3 4 5
• use search engines to find information 1 2 3 4 5
• use logical operators when searching for information 1 2 3 4 5
• use bookmarks / favourites for marking sites 1 2 3 4 5
• download files from the internet 1 2 3 4 5
• save text and images from web pages 1 2 3 4 5

Using the college intranet (Scone)
• navigate the various user areas 1 2 3 4 5
• log on as an intranet user 1 2 3 4 5
• post files to the user areas 1 2 3 4 5

E-mail
• send and receive e-mail messages 1 2 3 4 5
• attach files to outgoing e-mails 1 2 3 4 5
• open and save files attached to incoming e-mails 1 2 3 4 5
• create new contacts in address book 1 2 3 4 5
• create a distribution list of contacts 1 2 3 4 5
• sort messages and file in created folders 1 2 3 4 5

Staff ICT Skills Audit
ICT Curriculum Planning and Delivery

Please circle your level of confidence along a scale of 1 – 5 (please refer to separate guidelines)

Lesson Planning
• understand advantages and disadvantages of ICT 1 2 3 4 5
• compare different software packages for a specific purpose 1 2 3 4 5
• research for teaching material using CD-ROM or the Internet 1 2 3 4 5
• prepare OHTs and handouts using PowerPoint or similar 1 2 3 4 5
• use graphical images in lesson preparation 1 2 3 4 5
• plan progressively more difficult ICT activities 1 2 3 4 5
• prepare the classroom for an ICT lesson 1 2 3 4 5
comments

Teaching and Delivery
• teach ICT skills to students 1 2 3 4 5
• organise and manage the use of ICT in the classroom 1 2 3 4 5
• teach whole class lessons using ICT 1 2 3 4 5
• extend students learning in a subject through the use of ICT 1 2 3 4 5
• pose questions to stimulate students and direct them when they are 1 2 3 4 5

using ICT
• provide a list of relevant web sites for topic areas 1 2 3 4 5
• include Internet sites in learning activities 1 2 3 4 5
• use a data projector for content delivery 1 2 3 4 5
• encourage students to use e-mail for tutor contact and submissions 1 2 3 4 5
• use the college intranet to publish support material for lessons 1 2 3 4 5
• use the college intranet to post lecture notes and handouts 1 2 3 4 5
• edit a video 1 2 3 4 5
comments

Assessing & Evaluating
• understand the key skills levels of IT 1 2 3 4 5
• assess students ICT capability 1 2 3 4 5
• assess the contribution ICT has made to the learning of a subject 1 2 3 4 5
• judge how the use of ICT can alter expectations of students’ 1 2 3 4 5
attainment
• judge the effectiveness of using ICT in achieving teaching objectives 1 2 3 4 5
• expect students to submit assignments in word processed (printed) 1 2 3 4 5
format
comments

Personal, Professional use of ICT
• use generic software, e.g. word processing, spreadsheets, databases, 1 2 3 4 5
for administration purposes
• use peripherals, e.g. scanner or digital camera, to import images for 1 2 3 4 5
teaching materials
• use the college intranet to publish course information 1 2 3 4 5
• use web publishing software to publish to the Internet teaching and 1 2 3 4 5
information materials
• use e-mail and subscribe to mailing lists to communicate with teaching 1 2 3 4 5
colleagues
comments
Do you have any qualifications in Information and Communications Technology?
If so please list them here

Have you ever used a blog, a content management system or a collaborative platform?