Computing teaching resources: Functional IT skills

Resources and ideas for computing, functional it skills, written by teachers to support teaching and learning

  1. Home
  2. Computing
  3. Functional IT skills
Databases and SQL - Revision Worksheet

Databases and SQL - Revision Worksheet

A revision worksheet for those students preparing for their GCSE Computer Science exam. They follow SQL statements to determine which football teams would appear in the results (suitable for those studying A Level as well). On the reverse side they must research a series of database related keywords and complete some activities. Learning Objectives1) To have a better understanding of the purpose of a database and to be able to explain some of the related key terms. 2) To be able to use SQL effectively within a database to locate specific data.

By compteacheruk

GCSE and A Level Computer Science Posters

GCSE and A Level Computer Science Posters

A collection of excellent posters for GCSE and A Level Computer Science. The following posters are included in the bundle:1) Networking Keywords2) TCP/IP Protocol Stack3) Units of Storage4) Utility Programs

By compteacheruk

Secondary Storage Devices - Revision Worksheet

Secondary Storage Devices - Revision Worksheet

A revision worksheet for those students preparing for their GCSE Computer Science exam. They are asked a series of questions that focus on optical, magnetic, and solid state storage devices. One task requires that they label the different components of a hard drive. Also suitable for A-Level students.Learning Objectives1) To understand the purpose of secondary storage and to be able to identify examples of such devices.2) To be able to identify the advantages and disadvantages of magnetic, solid state, and optical storage devices.

By compteacheruk

The Effects of using ICT Worksheet

The Effects of using ICT Worksheet

This worksheet is a detailed 3 pages worksheet with mark scheme that covers the igcse ICT topic on effect of using ICT. It covers the effect of using IT on employment, work pattern, microprocessor controlled devices, their effect both positive and negative, health effect on prolong use of IT and their respective prevention methods. Suitable for assessment sheets as well. You can also get the accompanied presentation authored by me.

By ohiolei_sunlaw

Representing Numbers in Binary and Hexadecimal - Revision Worksheet

Representing Numbers in Binary and Hexadecimal - Revision Worksheet

A revision worksheet which can be used by students to revise how numbers are represented by a binary and hexadecimal. Suitable for KS4 and KS5 students studying GCSE and A Level Computer Science.Learning Objectives1) To understand how binary can be used to represent numbers within a computer.2) To be able to convert denary to binary and vice versa. 3) To be able to convert a representation of binary into hexadecimal.

By compteacheruk

3. Python, Using Lists (KS3 + KS4 Friendly)

3. Python, Using Lists (KS3 + KS4 Friendly)

This lesson guides the students through Python Lists, it has challenges to test students knowledge and build upon their previous lessons (also available in shop). This will develop their skills in using lists and combining data together.

By msmarwaha

Databases and Entity Relationships - Teacher Presentations

Databases and Entity Relationships - Teacher Presentations

A PowerPoint presentation which can be used by the teacher to teach their students about the purpose of a databases, entity relationship diagrams (with examples), and normalisation at KS5. Ideal for those studying A Level Computer ScienceLearning Objectives1) To have a better understanding of the purpose of a database and to be able to explain some of the related key terms. 2) To understand the need for entity relationships and to be able to identify the need for normalisation.

By compteacheruk

Training Needs Analysis - Microsoft Excel

Training Needs Analysis - Microsoft Excel

When planning computer training it is essential to have an idea of the skill level of participants. You can hand out or email this form to learners before or during a session. They simply fill it out and return it. The spreadsheet provided allows you to summarise the information.You can then use the information to split up groups into appropriate skill levels or just for general content planning for the session.

By biowriterab

Key Stage 3- Year 8 -  Web Design Unit - Tokyo 2020

Key Stage 3- Year 8 - Web Design Unit - Tokyo 2020

A set of 11 lessons that walk a student through the process of creating a website. Uses Fireworks & Dreamweaver to create a website. For lower ability uses PowerPoint and Fireworks. Uses the full systems life cycle and talks students through what happens at each stage. The project involves students working for the Olympic committee to create a website for the Tokyo 2020 Olympics.

By mrfoxinthebox

Fetch-Decode-Execute Cycle - Teacher Presentation

Fetch-Decode-Execute Cycle - Teacher Presentation

A PowerPoint presentation which can be used by the teacher to be able to demonstrate how the fetch-decode-execute cycle functions within the CPU, at KS4 or KS5.Learning Objectives1) To understand the purpose of the CPU and be able to explain how it typically functions when fetching and decoding instructions. 2) To be able to identify and explain the key differences between an address, control and data bus.

By compteacheruk

Training Needs Analysis forms for use in Computer Training

Training Needs Analysis forms for use in Computer Training

These forms cover Microsoft Word, Excel, Powerpoint, and Outlook as well as a basic users form. When planning computer training it is essential to have an idea of the skill level of participants. You can hand out or email these forms to learners before or during a session. They simply fill them out and return them. You can then use the information to split up groups into appropriate skill levels or just for general content planning for the session.I have also included a Feedback form that can be used to hand out after the session. They are in Word format so that you can easily remove or add any of the skills.I have used these for corporate groups and community groups successfully.

By biowriterab