1. Resources Home
  2. High School
  3. Computing
  4. Data and information
What is an ALGORITHM

What is an ALGORITHM

An introduction to algorithms using a flowchart with sequence, selection and iteration. The worksheet provided enables students to slow down their thinking to focus on each instruction in the algorithm until the last instruction is executed and the program ends.
chris_vidal
Microsoft Word Shortcut Keys A-Z

Microsoft Word Shortcut Keys A-Z

This resource is a worksheet that contains a list of Word shortcut keys from Ctrl A to Ctrl Z. Learners fill out the worksheet to the best of their ability either individually or as a group exercise. An answer sheet is provided. They can then go and try out all the shortcuts for themselves.
Resource_Creator
Data Storage - Presentation Project

Data Storage - Presentation Project

The resource is specifically based against the IGCSE Computer Science syllabus, but is suitable for any Data Storage module. It includes some knowledge tests at the beginning and leads on to creating 5 groups to work on a presentation about a different element of Data Storage. The group worksheets can be handed out or sent electronically and each has a series of keywords to prompt research. Each group is challenged with answering one Big Question and explaining it to the class at the end of the lesson. If you find the resource useful please leave a review so that others can find it. HackDragn
hackdragn
World Cup 2018 Spreadsheet Project Resource Pack

World Cup 2018 Spreadsheet Project Resource Pack

An ICT Spreadsheet project all set up to launch the 2018 FIFA World Cup in Russia - Aimed at Year 9 and KS4 3 resources available: a student template, with no formatting, formulae or functions; a teacher demo version, containing examples of a number of advanced features; finally a fully functioning working model showing a range of advanced features. A great motivational resource for teaching IF / COUNTIF Functions; relative & absolute cell referencing; defining cell names; macros; there is also further scope to develop the project further by incorporating graphs / charts; conditional formatting and VLOOKUP Functions. The project is set up to run through the entirety of the World Cup until its conclusion on 15 July.
craigman
[GCSE + IGCSE] TCP/IP Revision Tasks

[GCSE + IGCSE] TCP/IP Revision Tasks

A few of my revision activities bundled together which were previously listed separately which were highly downloaded. Fill in the blanks activity for students to complete (I have included my answers for this) Second activity as part of the revision to cut out and place the correct answers to correspond to how data is processed through the protocol stack
PaperAirplane
[GCSE + IGCSE] The Bigger Picture (Emerging trends, issues and impact)

[GCSE + IGCSE] The Bigger Picture (Emerging trends, issues and impact)

This is my unit of work to introduce the majority of the Bigger Picture unit. It also is a good research and discussion activity that links to other areas of the course - networking for example and the Internet of Things which has been in several exemplar question papers. It also gives rise to discuss Embedded Systems, discussions covering the whole of Topic 5 and making it relevant to real world examples. I have included in the file my overview of the three lessons that I spend on this. Of the four subsection of Unit 6. It has activities that can be used to introduce, or recover 6.1.1 - 6.1.3 The carousel activity features 5 real world scenarios linked to smart devices, embedded systems which students then record and share their thoughts on the impacts that it has. Class teacher/Students can gather thoughts and lead discussion based on students thoughts - good revision activity, or to assess understanding before progressing in this unit of work.
PaperAirplane
Spreadsheet A&E - OCR Cambridge Nationals Information Technologies

Spreadsheet A&E - OCR Cambridge Nationals Information Technologies

This is a resource that goes through each of the formulae that students need to know for the course. It has an activity for them to practice each formula and apply it to a working situation. My students come back to this when they build any spreadsheet and can’t remember how to do a certain formula.
gwhiting7
AQA GCSE Computer Science Workbook (9-1)

AQA GCSE Computer Science Workbook (9-1)

A workbook covering the whole of the AQA GCSE Computer Science course. Each section has a combination of theory and questions. In class we use it to help students struture their notes and all students are provided with the workbook at the start of the year. Depending on your version of Word, occasionally the formatting may be slightly off-kilter with some information jumping between pages. So it is worth double checking before it goes to print - I learnt that the hard way!
gdown3
REVISION FLASHCARDS - COMPONENT 1 - OCR A Level Computer Science - H446

REVISION FLASHCARDS - COMPONENT 1 - OCR A Level Computer Science - H446

A pack of just under two hundred flash cards across 24 A4 pages, consisting of past paper questions and key terminology for the OCR A Level Computer Science H446 Specification, Component 1 paper. Question is on the one side and the answer on the other, with a mark breakdown. Ideal for use by students as a revision tool! Can be folded in half by students to test themselves with the question on one side and the answer on the other. This resource is a single file PDF of 24 A4 pages. The questions have been taken from all of the sample, specimen and past papers available as of June 2018. Key definitions have been provided for every part of Component 1 in addition to cover those aspects that have yet to be examined in this component.
joshualh
Solving the Cyber Security Skills Gap

Solving the Cyber Security Skills Gap

Cyber criminals pose a risk to organizations large and small, local and across the globe. More and more, these organizations need qualified cyber security analysts and specialists with the skills and experience to mitigate this risk. As you take the first step toward helping meet this need by pursuing an online Bachelor of Science in Cyber Security, read more about what it will take to solve the gap: About Cyber Crime There are several different types of cyber crime. The motives behind them can be anything from money to hactivism or espionage. The most popular types of cyber crime include: Phishing attacks Malware Ransomware Encryption Blind Spots Cloud Threats Lack of cyber security system maintenance and employee training is often to blame for companies being attacked. What Can Be Done Those pursuing their cyber security degree online right now are going to enter a job market ripe with opportunity, as there is more demand than supply right now. The Benefits of a Cyber Security Career Cisco estimates that there are currently one million cyber security job openings worldwide. Demand is predicted to rise to six million, with Symantec predicting that, by 2019, the shortfall will be 1.5 million.
MaryvilleUniversity
It Revision Guide (KS3)

It Revision Guide (KS3)

The revision guide could form the basis of a revision guide at Key stage 3 and could be enhanced to include other topics. The revision guide covers the following IT topics: Hardware Software Input devices Storage media Output devices Modems Networking Spreadsheets Databases
Teacher_aesg
Microsoft Office Crossword Puzzles

Microsoft Office Crossword Puzzles

This resource contains crossword puzzles for Word, Excel, PowerPoint and Outlook. It’s a great way to get students engaged in learning the vocabulary around the software package they are working on. The crosswords can be printed out and worked on individually, in pairs or as a group activity. My adult learners really enjoy this aspect of the lesson. It can be carried out at the beginning or the end of the lesson.
Resource_Creator
MS Word Crossword Puzzle and Screen Elements Task

MS Word Crossword Puzzle and Screen Elements Task

This crossword puzzle with answers covers the key vocabulary that learners need to be exposed to when learning Microsoft Word. The resource also contains a printable worksheet that covers the Screen Elements of the software applications I use this with my adult learning classes and they really enjoy completing this. It can be done in pairs or groups or individually. It generates useful discussion and is a lot of fun. This is a print and go activity. It comes as both a pdf and word format file.
Resource_Creator
Microsoft Excel Crossword Puzzle

Microsoft Excel Crossword Puzzle

This crossword puzzle with answers covers the key vocabulary that learners need to be exposed to when learning Microsoft Excel. I use this with my adult learning classes and they really enjoy completing this. It can be done in pairs or groups or individually. It generates useful discussion and is a lot of fun. This is a print and go activity. The files are provided in both pdf and word format.
Resource_Creator
[GCSE+IGCSE] RECORDS ARRAYS FLOWCHARTS

[GCSE+IGCSE] RECORDS ARRAYS FLOWCHARTS

A series of 6 activities (15 lessons following structure below) that can either be used to introduce Records, Arrays and Flow Charts, or as a revision tool at the end of introducing these. With each activity, I spend time going over the skills at the beginning of the lesson, with the students completing the flow chart in each scenario. For each activity, I have included extension activities to challenge the more advanced students. After each flow chart is completed, we review the learning at the end of the lesson. The second lesson for each, we review the learning from the previous activity and then code the solutions. I often do these in a mix of group and paired programming scenarios. This would also work well as a carousel activity, giving a set time at each station or, working in groups, students could implement the solutions for them and present their learning back to the rest of the class All in, covering theory, taking time to implement the code, and with testing at the end, this short set of activities takes us around 15 lessons and hugely benefited my students in the Paper 2 in the recent exam. There were a few questions which came up with regards to manipulating records / writing to files which, following these activities, my students were very confident with. This exercise was also used during a Looking For Learning classroom observation.
PaperAirplane
Ancient History Big Bundle!

Ancient History Big Bundle!

THIS BUNDLE CONTAINS EACH OF THE ANCIENT HISTORY KNOWLEDGE ORGANISERS, IN ADDITION TO THE ANCIENT HISTORY POINTLESS GAMES! The clear, detailed and visually-appealing knowledge organisers offer complete reference points for students learning or revising knowledge relating to each of the following ancient history topics: Ancient Egypt; Ancient Greece; The Romans. Each organiser contains a number of comprehensive sections explaining the key elements of the topic, timelines detailing key times and events, diagrams and images to visually aid understanding, and key facts to extend the learning of higher attaining students. The resources are designed to be printed onto A3, and are provided as both PDFs and Word documents (so that you can edit should you wish to). All images used are licensed for commercial use and are cited on a separate document (included). Based on the popular game show, the ‘Pointless’ games are perfect for use as whole lesson resources, enrichment options, or revision tools. The games are editable, so that you can change to any other topic or change questions. Each game contains around 25 slides of sound clips, engaging visuals, and suitably challenging questions and they are effective at both promoting engagement and enhancing learning. There are several full rounds of questions to build or revisit knowledge of Romans, Ancient Egyptians, and Ancient Greeks. The nature of the games ensures that the resources can challenge students of all levels. A blank template has also been added, so that you can create your own games!
TandLGuru
Cluedo murder mystery riddle - adaptation from Einstein's '5 houses' logic puzzle

Cluedo murder mystery riddle - adaptation from Einstein's '5 houses' logic puzzle

**Mr Black has been found dead at Tudor Manor. ** You are the lead investigating detective. You have all six suspects brought to the main hall of the mansion, seated next to each other around a circular table. Every one of them has a motive to murder Mr Black, but only one committed the crime. Can you solve the case and bring the killer to justice? Who killed Mr Black? What weapon was used? Where was the weapon hidden? This activity is an adaptation of mine based off Einstein’s ‘five houses’ logic problem Students extract relevant information from text; create an appropriate data structure to record these facts; and use a process of elimination to solve the problem I have been using it with KS4/5 Computer Science classes to demonstrate computational thinking (abstraction and decomposition)
mailmikejenkins
Lesson:   Merge sort, (lesson plan  & x 6 resources)

Lesson: Merge sort, (lesson plan & x 6 resources)

Lesson: Merge sort, (lesson plan & x 6 resources) (GCSE Computer Science) • To understand and explain how a merge sort works An easy to follow and timed lesson plan (x1 hour) that includes x6 resources. Starter activity where pupils compare the performance of the bubble and merge sort. A merge sort presentation that introduces and explains the sorting algorithm (divide & conquer) A link to a merge sort simulation demonstrates a working model An worksheet exercise to dry run the merge sort algorithm (answers provided) There is a sample merge sort written in python that the pupils edit and make changes. A stretch and challenge exercise to program the first half of the merge sort. A plenary exercise containing an x8 question assessment on the merge sort A homework to represent the performance of the bubble and the merge sort on a chart
Teacher_aesg
[GCSE + IGCSE] Computer Science Programming (Visual Basic)

[GCSE + IGCSE] Computer Science Programming (Visual Basic)

Advanced programming resources for teaching IGCSE + GCSE Computer Science and beyond This is also useful for anyone teaching IB Computer Science using Visual Basic 8 individual ‘activities’ with advanced challenges for each. More than 8 lessons work once I build in introduction, designing of the code and plenary reviews at end of lessons. Taking our time to build up skills, do traces on the code etc, each takes (or could take) three lessons to thoroughly cover the knowledge
PaperAirplane
Lesson:   Bubble sort, (lesson plan  & x 6 resources)

Lesson: Bubble sort, (lesson plan & x 6 resources)

Lesson: Bubble sort, (lesson plan & x 6 resources) (GCSE Computer Science) • To understand and explain how a bubble sort works An easy to follow and timed lesson plan (x1 hour) that includes x6 resources. Starter activity where pupils watch a video comparing the performance of different sorting algorithm A bubble sort presentation that introduces and explains the sorting algorithm (includes a flowchart) A link to a bubble sort simulation demonstrates a working binary sort model A further presentation demonstrates how to code a bubble sort in python There is a sample bubble sort written in python A stretch and challenge exercise to identify what happens when the number of data items in the list grows A plenary exercise whereby the class are separated into two teams (A & B) and each team are asked a series of questions about a bubble sort A homework to research three difference between a bubble sort and a merge sort (answers provided)
Teacher_aesg
Marketing 2-Week Outline Lesson Plan  > Project - Activity & Store Promotion + 4 PowerPoints

Marketing 2-Week Outline Lesson Plan > Project - Activity & Store Promotion + 4 PowerPoints

This is a 2 Week Lesson Plan OUTLINE for introducing students to Decision Making & Concept Building for Promotion. Students will take the concept of the “Corner Store” and develop branding and advertising around a theme. This lesson is active and will engage students in critical thinking exercises. The packet comes complete with: Teacher Notes for Guidance All PowerPoints Class Handouts All Grading Rubrics Daily Objectives Time Management Suggestions Lesson Targets & Planning Sheets Plus Lots of How-to Suggestions
PattyAnnsPetProject
Python Basics II - (2 X full lessons) GCSE - Variables / Inputs / Operator Precedence

Python Basics II - (2 X full lessons) GCSE - Variables / Inputs / Operator Precedence

This lesson is one of a series (scheme of work) to teach Coding techniques in Python It has been especially designed for GCSE but it can also be used for A Level / IB Diploma specifications. Learning Objectives Understand what a Variable is in Python Know what the different types of Variables are and what they are used for Understand and use Operator Precedence Know how to take an input of different data types from the user Understand what a Function is The resources in this pack will be enough for 2 X double lessons of Computer Science (each double lesson of around 1 hour 50 minutes) . All necessary resources to run the lessons are included in this download. Lesson presentation with examples of the code Eight Challenges to allow students to show their mastery of the concepts Possible solutions for each of the eight challenges Original Python files to allow you to run the programs to see how the programs work Variables Worksheet This lesson is perfect to use to deliver a full lesson or as revision to help students recap skills they have learnt previously It is also ideal for NQTs and non-specialist teachers who need to learn Python programming or any teacher wanting to fill in gaps in their Python programming knowledge The aim of all my resources is to provide lessons / activities of good quality that will add value to your lessons / schemes of work. All activities and resources have been used in class and any errors will be fixed and resources updated as soon as I am aware of any errors. I have priced my resources at what I consider to be a reasonable cost based upon the amount of effort and work I have put into them but <strong> all comments and suggestions are very welcome </strong> and will be used to improve future resources. If you have an idea for a topic / resource that you would like to see, feel free to leave a comment. The contents of this page and all downloaded materials are copyrighted Harvey Taylor (2018) To see other resources in my shop, click here
haltest
[GCSE + IGCSE] Computer Science Trace Tables, Algorithms and Efficiency

[GCSE + IGCSE] Computer Science Trace Tables, Algorithms and Efficiency

This is an excellent resource that I have created and used with my Y10 and Y11 GCSE class (Y10 are IGCSE, and is relevant to both courses) I use this as a collaborative carousel activity where students in pairs (or however you want to work it) look at two algorithms at a time, tracing the values of the variables. This is a problem solving activity that should hopefully challenge students Computational Thinking, as well as revising their skills with Trace Tables and predicting output of code, as well as spotting Logical errors. I have also used it to introduce the idea of preprocessing. This series of activities leads nicely into more challenging activities, such as sorting of data. When I teach this lesson, I use some theory resources and plenary activities, as well as some on-line quizzes over 3 lessons. Had a looking for learning observation whilst using these activities and feedback from observation was excellent. Having reviewed it with students, their feedback was (a long with the Data Structures activities uploaded and used prior to these activities) is that it really helped them to visualise how data is stored and manipulated in arrays, as well as introducing preprocessing (which appeared in this year exam) as well as revising trace tables. Allowing the students to work in collaboration, discussing with one another and doing some peer review tied in neatly with some of the observational areas which we are looking at with ATL and Life After Levels. I was also toying with doing this as a group presentation activity, where the students can ‘lead’ this activity and ‘Be the Teacher’ explaining the inefficiency of their algorithm and how the data can be as issue also. This was also a perfect opportunity to revise why we use arrays in the first place - as I got students to re-write the code without arrays and it was a crazy series of IF statements, so plenty of scope to draw in other areas of the course.
PaperAirplane
Graphic Arts Lesson Plans All-in-One ~ Full Curricula Book + 4 PowerPoints

Graphic Arts Lesson Plans All-in-One ~ Full Curricula Book + 4 PowerPoints

“All-in-One Graphic Arts Lesson Plan” is a complete curriculum- or use as a supplemental educational aid. Lesson ideas are outlined with guidelines. Packed with true-life application assignments! This Teachers Edition comes with: ~ Instructional Aids and Outlines ~ Interactive Activity Lessons ~ Ready-Made Assignments for Full Semester ~ Rubrics Included for Grading ~ Easy Modular Curriculum to Implement ~ INCLUDES 4 PowerPoints -Integrated into the Curriculum.
PattyAnnsPetProject