Spreadsheet: 65731d1266419659-copying-storing-entered-information-to-another-worksheet-staff-skills-audit4
Sheet: Sheet1

 | Individual Teacher's responses to [NAME] and % responses by section.                              Select staff name from drop down list.
 | Select Name | Teacher 1 | Response |  |  | Total Summaries
 | CH01 | connect up the computer and its peripherals (mouse,  keyboard, monitor etc.) | 1 | Staff List |  | Teacher Total Score
 | CH02 | use a scanner for copying images | 2 | Teacher 1 |  | Teacher Average
 | CH03 | use a digital camera for capturing images and upload | 3 | Teacher 2 |  | School Average
 | CH04 | use a digital camera for capturing moving images and upload | 4 | Teacher 3 |  | Number of Staff
 | CH05 | aware of H&S issues relating to the computing environment | 5 | Teacher 4 |  | Number of Replies
 | CH06 | Store/retrieve files using a USB device or a memory stick | 5 | Teacher 5
 | CM01 | locate and run a programme (software application) | 1 | Teacher 6 |  | Section Summaries - NB the %s are only accurate when data is sorted by question
 | CM02 | use CD-ROM-based software | 1 | Teacher 7
 | CM03 | organise your electronic files into folders | 1 | Teacher 8 |  |  | WP | SS | PR | UV | IW | UI | EM | LP | TD | UG | CM | CH | US
 | CM04 | search for files on the computer system | 1 | Teacher 9 |  | Reply scale: 5 = strongest | Word Processing | Spredsheets | Presentations | Using VLE | Interactive White Boards | Using Internet | E-Mail | [NAME] | Teaching & Delivering ICT | Using Graphics Software | Computer Management | Computer Hardware | Using SIMs
 | CM05 | move/copy files between drives (e.g. from A: to C:) | 1 | Teacher 10
 | CM06 | backup files onto various media types (CD-RW, USB Hard drive etc) | 2 | Teacher 11
 | CM07 | print to various networked printers | 2 | Teacher 12
 | CM08 | delete files/programs
 | EM01 | send and receive e-mail messages
 | EM02 | attach files to outgoing e-mails
 | EM03 | open and save files attached to incoming e-mails
 | EM04 | forward emails to selected contacts |  |  |  | 1
 | EM05 | create new contacts in address book
 | EM06 | create a distribution list of contacts |  |  |  | 2
 | EM07 | sort messages and file in created folders
 | IW01 | change pen/line/shape size/colour/shape/transparency |  |  |  | 3
 | IW02 | Alter the settings e.g. pen size/colour/rubber size
 | IW03 | Use the keyboard function |  |  |  | 4
 | IW04 | Use the right mouse button function
 | IW05 | Move on slides in PowerPoint |  |  |  | 5
 | IW06 | Link up and use a Visualiser in lessons
 | IW07 | draw shapes
 | IW08 | insert pictures/animations
 | IW09 | change page background
 | IW10 | use the infinite cloner
 | IW11 | change the level of objects
 | IW12 | lock objects in place
 | IW13 | use the recording tool
 | IW14 | Orient/align the whiteboard
 | LP01 | understand advantages and disadvantages of using ICT
 | LP02 | compare different software packages for a specific purpose
 | LP03 | research for teaching materials using CD-ROM or the Internet
 | LP04 | prepare presentations and handouts using PowerPoint or [NAME] notebook
 | LP05 | use graphical images in lesson preparation
 | LP06 | plan progressively more difficult ICT activities/differentiate ICT
 | LP07 | prepare the classroom/computer suite for an ICT lesson
 | PR01 | create a basic presentation package
 | PR02 | incorporate a data chart or graph
 | PR03 | rearrange slides within a presentation
 | PR04 | change slide timings and presentation options
 | PR05 | produce appropriate handout formats
 | PR06 | add clipart to slides
 | PR07 | modify colours of text, background, lines
 | PR08 | change the layout of slides
 | PR09 | introduce animation onto slides
 | PR10 | add sound to slides
 | PR11 | insert a hyperlink
 | PR12 | modify transition between slides
 | PR13 | edit a master slide
 | SS01 | input data in rows and columns
 | SS02 | auto filling series
 | SS03 | sort data
 | SS04 | input formulae
 | SS05 | replicate formulae along rows/columns
 | SS06 | produce charts and graphs for data analysis
 | SS07 | add headers and footers
 | SS08 | print a selected area
 | SS09 | password protect a spreadsheet
 | TD01 | teach ICT skills to students
 | TD02 | organise and manage the use of ICT in the classroom
 | TD03 | teach whole class lessons using ICT
 | TD04 | extend children’s learning in a subject through the use of ICT
 | TD05 | incorporate ICT links across the curriculum
 | TD06 | pose questions to stimulate students and direct them when they are using ICT
 | TD07 | provide a list of relevant web sites for topic areas
 | TD08 | include Internet sites in learning activities
 | TD09 | encourage students to use the learning platform for lessons/homework
 | UG01 | Draw a simple shape (e.g. a square or a circle)
 | UG02 | Use a drawing package to annotate a graphic (e.g. label a diagram)
 | UG03 | Adapt a piece of clip art for your own use
 | UG04 | Draw a simple straight line diagram e.g. flow chart
 | UG05 | Draw a simple curved line diagram e.g. basic map
 | UG06 | Change fill and line colours
 | UG07 | Save and open drawing files
 | UG08 | Print files
 | UG09 | Use the on-line help
 | UG10 | Draw a complex straight line diagram e.g. floor plan
 | UG11 | Draw a complex curved line diagram e.g. complex map
 | UI01 | access an Internet site via its website address
 | UI02 | use search engines to find information
 | UI03 | use safe searching options
 | [NAME] | save/use bookmarks / favourites for marking sites
 | UI05 | download files from the internet
 | UI06 | save text and images from web pages
 | US01 | understand how access to SIMS can improve productivity
 | US02 | access SIMS
 | US03 | access assessment manager
 | US04 | enter data into your marksheets
 | US05 | use SIMS to check pupil information
 | US06 | use SIMS for reporting
 | UV01 | Logging on to the VLE
 | UV02 | Using the VLE in lessons
 | UV03 | Creating Rooms on the VLE
 | UV04 | Creating Folders on the VLE
 | UV05 | Uploading Resources to the VLE
 | UV06 | Marking work on the VLE and leaving comments
 | UV07 | Using tools such as Forums, Polls etc
 | WP01 | use simple editing e.g. bold, italics, centring, font size etc
 | WP02 | use headers and footers
 | WP03 | use the drawing tools to create shapes and Autoshapes
 | WP04 | mail merge
 | WP05 | print a document (change colour options, page size, layout etc)
 | WP06 | save a document in various file formats
 | WP07 | use a spellchecker
 | WP08 | import text and images into a word processed document
 | WP09 | include tables in a document
 | WP10 | insert a hyperlink
 | WP11 | alter the layout and positioning of text and images
 | WP12 | use templates for standard documents
 | WP13 | create new document templates
 | WP14 | divide the page layout into columns