1. Resources Home
  2. Secondary
  3. Computing
  4. Data and information
Data Structures for Kids and Other Normal People

Data Structures for Kids and Other Normal People

These resources can be used by colleagues teaching high school Computing Science in any education system but, in particular, they reflect my interpretation of parts of the (Scottish curriculum) Level 3 and 4 Computing Science Es and Os in the Broad General Education. I have thought for a long time that coding is often taught too fast and too much from a “let’s just get on and write some code” approach and there has been little emphasis on the data structures underpinning the code. I have found that when I ask a student to draw and name the data structures they plan to use - even if the structures contain simple, single values - their understanding (their computational thinking skills) and their ability to code independently improve immeasurably. My view of the current Scottish curriculum is that it now allows for this, and that was my motivation when I started building these resources. I have tried to create resources that are superficially appealing whilst containing academic content, in order to engage all levels of ability. These resources may go some way to fill the gap between more practical, coding activities and the theory found in certificate courses in the senior phase at secondary level. I have deliberately kept each resource to one page so that they can be used out of sequence. I have not included much in the way of teacher exposition within each task, to allow for different levels of depth depending on circumstances, but the Teacher Notes include my rationale for each task, some tips/hints/notes for each resource and a reference to the (Scottish Curriculum) Benchmarks for the Es and Os.
A_Cowie
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
Binary Addition Worksheet with accompanying answers (Bits, Nibbles and Bytes)

Binary Addition Worksheet with accompanying answers (Bits, Nibbles and Bytes)

A worksheet activity adding binary numbers and conversions to denary. Starts with 4 bits (nibble) and moves on to 8 bits (byte) additions. There is also an accompanying answer sheet. The activity also has some general questions about binary for students to answer, which could be part of an extension or small research activity.
conxxion
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
Cipher Wheel for Primary Cryptography

Cipher Wheel for Primary Cryptography

Encryption & Decryption Cipher wheel for primary pupils from iCompute’s primary computing scheme of work 6-8 week cryptography unit. Teach your pupils about encryption methods and learn the importance of privacy in the modern digital world with iCompute. Credit : www.icompute-uk.com
iCompute
Morse Code - Coder Wheel

Morse Code - Coder Wheel

Morse Code wheel for primary pupils from iCompute’s primary computing scheme of work 6-8 week cryptography unit. Teach your pupils about encryption methods and learn the importance of privacy in the modern digital world with iCompute. Credit : www.icompute-uk.com
iCompute
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
Primary ICT / Computing report templates and statements of progression

Primary ICT / Computing report templates and statements of progression

New UK Curriculum for Computing in Prmary assessment and reports statements for year 1-6 at three levels of progression across Digital LIteracy, Digital CItizenship and Computer Science. Use the sentences as a guide for what to include in your reports for the computing segment. While these do not cover the entire spectrum of assessment for computing, they are a good representation of the most notable standards per strand for the age expected ability and represent what should be taught. Could also be used in a backwards planning model to also develop learning objectives, success criteria and lesson plans or an entire vertical curriculum.
habeebafett
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
Lessons: linear & binary search, bubble & merge sort

Lessons: linear & binary search, bubble & merge sort

Includes the following x1 hour lessons: linear search binary search bubble sort merge sort Format of the lessons: Starter activities Presentations Simulations Worksheets Stretch & challenge activities Plenary assessment Homeworks
Teacher_aesg
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