Hero image

Computer Science/ICT

Average Rating4.37
(based on 53 reviews)

Since completing a degree in computer science, I went on to teaching and have done this for many years. I am now working in a secondary school teaching computer science to KS4. Over the years I have developed resources that I have used in the classroom and know how difficult it can be to find suitable resources. I thought it would be great to share these.

29Uploads

39k+Views

101k+Downloads

Since completing a degree in computer science, I went on to teaching and have done this for many years. I am now working in a secondary school teaching computer science to KS4. Over the years I have developed resources that I have used in the classroom and know how difficult it can be to find suitable resources. I thought it would be great to share these.
FREE Python lesson - Introduction to Python
khedges123khedges123

FREE Python lesson - Introduction to Python

(5)
i created a nice introduction to Python for Year 7. It starts with the basics of how to use Python for beginners. Year7 really enjoyed it. I hope it is useful to you. It is a powepoint so you can amend it to your class.
ICT Functional Skills - Scheme of work with lessons - Level 1 and 2
khedges123khedges123

ICT Functional Skills - Scheme of work with lessons - Level 1 and 2

(6)
This is a course for ICT Functional Skills. I used this with 17 to 18 year olds in further education. I have included all teacher PowerPoint presentations, worksheets and the scheme of work. The units included are: Unit 1 Making the most of your computer Unit 2 Managing Information - Passwords and viruses Unit 3 Finding and selecting information Unit 4 to 7 Excel Spreadsheets (Basic Formulas, IF Functions, Absolute function, Lookup formula) Unit 8 Working with Microsoft Word Unit 9 Combining and presenting information Unit 10 Using ICT to communicate I hope that you will find this helpful in the classroom. All presentations are easily adaptable as well the worksheets. Some of the Excel worksheets have been used on older versions of Excel, however they have recently been checked to the most updated version of Excel and do work fine.
Alpine Snow School Project - ICT FS or ICT GCSE
khedges123khedges123

Alpine Snow School Project - ICT FS or ICT GCSE

(2)
I have developed a project called Alpine Snow School Project - This project enables students to develop a wide range of skills by researching, developing a poster, presentation, excel spreadsheet tasks including SUM, MIN, MAX, Average, IF function, Lookup Function, Absolute as well as general ICT questions. This can be used for an assessment to identify knowledge already obtained or need obtaining. I have used this as a mock exam in preparation for an ICT exam. This took my my students 2 lessons to complete but you really do get an idea of what ICT skills they have. I hope you find this useful.
Create an app with AppShed (KS2 Primary) Computing lessons
khedges123khedges123

Create an app with AppShed (KS2 Primary) Computing lessons

(7)
Being new to app creation as well as the year 6 class I was teaching, I decided to make a step by step of instructions using PowerPoint. This worked brilliantly, it really is a beginners guide for them. It is to make a Ratatouille information app about the film but you can adapt this PowerPoint to suit your needs. I hope you find this useful as much as I did.
Audacity - An Introduction (KS2 Primary - Computing)
khedges123khedges123

Audacity - An Introduction (KS2 Primary - Computing)

(5)
A nice introduction to Audacity, I used this PowerPoint with Year 6 for their first ever lesson using Audacity, Helps them to identify the features of Audacity and why we use this software to mix music. I hope you find this useful as I did.
Computer Questions - Lesson Starter
khedges123khedges123

Computer Questions - Lesson Starter

(1)
I use this lesson starter for my students. It gives them questions to answer and when everyone is settled, it is a good way to get the class to discuss what they would do. They are easily adaptable to any ICT/Computing lesson.
Excel LookUp Function (ICT Functional Skills)
khedges123khedges123

Excel LookUp Function (ICT Functional Skills)

(1)
This is a great worksheet that introduces the LookUp function to learners. This gives a step by step process to carry out the lookup function. My students really enjoyed my activity and it really supported their understanding.
Initial Assessment - Answers Only (ICT FS or ICT GCSE)
khedges123khedges123

Initial Assessment - Answers Only (ICT FS or ICT GCSE)

(1)
I have developed an ICT initial assessment test - this resource contains the answers only. This assessment is great to see what my students already know before they start lessons in ICT. This can also be used at the end of the course to establish what knowledge they have developed. Questions asked range from trouble shooting in ICT, Word, Excel, Presentations and Database usage. Please also see the Initial Assessment - to support this assessment answers resource.
Initial Assessment for ICT (ICT FS or GCSE ICT)
khedges123khedges123

Initial Assessment for ICT (ICT FS or GCSE ICT)

(1)
I have developed an ICT initial assessment test. This assessment is great to see what my students already know before they start lessons in ICT. This can also be used at the end of the course to establish what knowledge they have developed. Questions asked range from trouble shooting in ICT, Word, Excel, Presentations and Database usage. Please also see the Initial Assessment answers - to support this assessment. This took my students 1 hour to complete.
Creating a database - ICT or FS Level 2
khedges123khedges123

Creating a database - ICT or FS Level 2

(1)
Creating a database worksheet was used with my students to help them create a basic database, in MS Access. This worksheet contains how to create a database, a report and how to create a query. This worked really well for 15 years plus but I am sure this will suit secondary amd even primary.
Computer Science GCSE - Mini Test - Fundamentals of Algorithms
khedges123khedges123

Computer Science GCSE - Mini Test - Fundamentals of Algorithms

(3)
I created a mini test for my year 10s and 11s on the fundamentals of algorithms. There are 10 questions and takes about 30 minutes to complete. I have also included a marking scheme. The questions can be changed so that they are easy adaptable to your students. Questions include binary search, merge sort and abstraction.
Movie worksheet - Excel/Word/ICT Questions/Email Tasks
khedges123khedges123

Movie worksheet - Excel/Word/ICT Questions/Email Tasks

(1)
I developed this worksheet to help studens use Excel basic functions, these include the IF function, Min, Max, Average and also SUM. This worksheet also gives students a chance to design a poster and write an email. This is in a Word document, so you can amend the worksheet to suit the abilities of your learner.
Alpine ICT Project  (ICT FS or ICT GCSE)
khedges123khedges123

Alpine ICT Project (ICT FS or ICT GCSE)

(1)
This booklet includes a range of activities to support learners in ICT functional skills. This can even be used for ICT GCSE classes. This covers the following: Using ICT activity, Email activity, Word poster activity, Gathering information activity, Excel activity including absolute, Lookup and IF functions as wells a chart activity. A great range of skills to identify any gaps in their ICT knowledge. This took my students around 2 lessons to complete.
Research Activity on Spyware (ICT Curriculum)
khedges123khedges123

Research Activity on Spyware (ICT Curriculum)

(0)
Students need to learn about spyware and also how to research. This activity asks the students to develop a poster on spyware but using the internet to find information. A fabulous activity to get the learners developing their knowledge on spyware. Learners need to know how to research as part of any ICT course.
How to create a professional email (ICT FS or ICT GCSE)
khedges123khedges123

How to create a professional email (ICT FS or ICT GCSE)

(0)
A nice PowerPoint on how to create a professional email. Could also be used in a literacy lesson. This was used in a recent ICT lesson workshop as well as an English functional skills lesson. This PowerPoint provides information on the difference between informal and formal emails, how you start an email as well as ending an email. As this is a PowerPoint, you can adapt it to your own lessons. I hope you will find this useful. Kathy's ICT Resources.
How to use PowerPoint effectively (KS2 Primary and Secondary)
khedges123khedges123

How to use PowerPoint effectively (KS2 Primary and Secondary)

(0)
Recently used as a lesson 16+ year olds. Can easily be used from Year 6 to Secondary. Explains the importance about getting your presentation across to the audience. By the end of the lesson, students will be able to think more logically about how to present an effective presentation to the class.
Alpine Projects
khedges123khedges123

Alpine Projects

3 Resources
I created these great resources to help my students aquire further skills in Excel, Word, PowerPoint amd creating emails. These worksheets can be used as assessments for when they first visit your class. I have used these as mock exams as well.