1. Resources Home
2. High School
3. Computing
4. Data and information

#### 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.

#### 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.

#### Using a Binary Box to Convert Binary to Denary / Denary to Binary (Worksheet)

A worksheet that allows pupils to convert between binary and denary / denary binary.

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.

#### 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

#### Karnaugh Maps - 8 Karnaugh Maps - Good starter - With answer booklet - Computer Science A Level

8 page PDF document with a Karnaugh map on each page. Answer booklet included showing groups and final solutions. I have used these sheets after teaching this topic as a starter to ensure over a number of lessons that the students haven’t forgotten how to find boolena expressions from a Karnaugh map representation.

#### Computer Science Research Essay Ideas

Four different activities for researching different areas of Computing. 4 research essays bundled.

#### A comparison of Smart Phones

Directed research activity to compare different brands of smart phones in an ‘Extended Essay’ type format

#### Games Consoles Research Activity

Activity sheet for researching and presenting on the History and development of Games Consoles

#### Computer Science Y8 Extended Essay Research Activity

My activity sheets for Y8 extended essay Included marking rubric and levelling descriptors for this task

#### Wearable Technology Essay Research Tas

This is my handout for a research and extended essay type activity that I do with my Y8 students. Levelling criteria is included

#### [GCSE] Sound Representation Activity Sheet

Activity Sheet with directed research questions for searching and recording information about how sound is stored in a Computer System

#### 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 &amp; 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.

#### [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

#### [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.

#### GCSE Computing Revision Flash Cards - Ethics

GCSE Computing Revision Flash Cards for Students. See Full Set of Flashcards for Computing for a Discounted Price! Based off of the OCR Specification (9-1)

#### **Over 50 Slides of content **Unit 1 CamTech 2016 Revision Slides**

The resource covers the different topics as per the unit content in a user friendly way for students.

#### GCSE Computing Paper 1 Exam Style Questions and Answers

GCSE Computing Paper 1 Questions and Answers. Great for tests or student revision. Based off of the OCR Specification (9-1)

#### 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.

#### 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!

#### 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.

#### 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.

#### Edexcel Computer Science 9-1 paper 2 half a terms lessons

This half a term worth of lessons cover: error types data types relational databases test Each lesson begins with the basic concepts, then adds until they are at GCSE level. Students have been very engaged with this work.

#### Memory Unit Poster

A set of posters to display for memory units.

#### 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

#### 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.

#### 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.

#### 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.

#### OCR GCSE Computing - Translators presentation task

Student are required to create a presentation on translators in groups or pairs, to present to rest of the class

#### [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.

#### 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!

#### 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)

#### 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 &amp; challenge activities Plenary assessment Homeworks

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

Lesson: Merge sort, (lesson plan &amp; 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 &amp; 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

#### [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

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

Lesson: Bubble sort, (lesson plan &amp; 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 &amp; 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)

#### 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 &amp; 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 &amp; Planning Sheets Plus Lots of How-to Suggestions

#### [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.

#### Graphic Arts Bundle> Activities + Projects + PowerPoints=Complete Semester Pack!

Graphics Semester Bundled for Bonus \$avings! Curricula Outlined for ENTIRE Semester Worth of Projects. Individual Accompanying Aids, PowerPoints &amp; Assignments

#### 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.

#### Graphic Arts PowerPoints 4-Pack = *Logos *MockUps *Thumbnails *Project Charters

Save on this Informative Graphic Arts 4-Pack bundle packed with Activities and creative techniques . Includes ALL 4 of these PowerPoints that can be purchased separately as well.