1. Resources Home
  2. Primary
  3. Computing
  4. Data and information
GCSE Computer Science: Taboo words (185 terms, 6 topics)

GCSE Computer Science: Taboo words (185 terms, 6 topics)

Banned Words is similar to the games Taboo ™ or Forbidden Words ™. Students must get their teammates to guess key words by giving a definition without using certainly banned words. Great for improving language and explanation skills, and for ESL pupils. This game works well for starters and plenaries. This pack contains fully editable Banned Words PowerPoints for 6 Computer Science topics with almost 200 key terms, plus a separate game file with all topics combined. Two samples are also available on TES for free. This electronic version of the game saves printing and laminating cards. The presentation can be shown to a student on the teacher’s computer. When the presentation is run, key terms will be selected in a random order until each one has been used exactly once. Topics included: Hardware (42 terms) Software (19 terms) Data Representation (29 terms) Algorithms & Programming (38 terms) Networks & The Internet (44 terms) The Bigger Picture (13 terms) Each PowerPoint is fully editable so you can easily add your own terms. A blank template is included to create your own games based on your chosen topics. Notes: The random-slide function will ensure each slide is selected exactly once. For the random-slide functionality to work you must: Enable Macros when opening the presentation Click the blue arrows to change slide (not the cursor keys on the keyboard)
csteacher2048
GCSE Computer Science: Taboo words game (Data representation)

GCSE Computer Science: Taboo words game (Data representation)

Banned Words is similar to the games Taboo ™ or Forbidden Words ™. Students must get their teammates to guess key words by giving a definition without using certainly banned words. Great for improving language and explanation skills, and for ESL pupils. This game works well for starters and plenaries. This fully editable Banned Words PowerPoint contains terms covering the Data Representation topic. You can also download this resource as part of a pack covering 185 terms and 6 topics (see below). This electronic version of the game saves printing and laminating cards. The presentation can be shown to a student on the teacher’s computer. When the presentation is run, key terms will be selected in a random order until each one has been used exactly once. A blank template is included to create your own games based on your chosen topics. Notes: The random-slide function will ensure each slide is selected exactly once. For the random-slide functionality to work you must: Enable Macros when opening the presentation Click the blue arrows to change slide (not the cursor keys on the keyboard)
csteacher2048
GCSE Computer Science 9-1 Data Representation Conversion

GCSE Computer Science 9-1 Data Representation Conversion

Let’s Do It Activities Designed as lesson starters for component 2 - revision of the different data conversion methods: Binary to denary and vice versa, binary to hexadecimal and vice versa, denary to hexadecimal and vice versa, binary addition, binary shift to the left, binary shift to the right, and finally as mentioned in the spec, (how to calculate) the check digit. Each conversion is illustrated through worked examples and tips on how to convert with three practice questions that students can work on independently. In my lessons, I will have a folder with the solutions in so that students can self-mark once they have completed the activity. To follow shortly: Let’s Do It Activities for Sorting & Searching Algorithms and Logic Gates.
Pipjen77
Political and Economic Impacts of ICT

Political and Economic Impacts of ICT

This is a KS3 Year 9 lesson I taught around the political and economic impacts of ICT (topic 22). This lesson gets students to look at a range of articles, looking at the impact of corruption politically and how ICT could have a positive and negative influence. Included: PPT Starter Links to research on corruption ** I had to remove the images for the plenary due to copyright however I have left the names on each slide so is still possible to play, if necessary you can simply add the images back.
HDLouise
LWKS2 Computing Planning - E-Safety and Search Engines

LWKS2 Computing Planning - E-Safety and Search Engines

A unit of work teaching children about e-safety relating to the use of search engines. Also included is some teaching of the technical processes behind how engines work. The unit ends with a mini project where children are taught how to use what they have learnt about search engines in order to research an idea relating to their curriculum topic. Seven Lessons: LO: To know how a search engine functions. LO: To know how to use search engines effectively to get appropriate results. LO: To know how to save and share websites safely. LO: To know how webpages are ranked in search results. LO: To know the risks involved in online communication. LO: To know how to select an idea to research. LO: To know how to use a search engine safely to complete research. Unit is targeted at lower key stage 2, but would be suitable for all of key stage 2, if children had not experienced this topic already.
duncanjhmacdonald
Sunflower Lifecycle Sequencer (Simple) - KS2 Literacy

Sunflower Lifecycle Sequencer (Simple) - KS2 Literacy

KS2 Literacy - Sunflower Lifecycle Sequencer (Simple) This is an interactive activity for pupils to sequence the stages of a sunflower’s lifecycle. This is a simple version containing four steps that need to be sequenced. Each picture has a written description with accompanying audio. Pupils are tasked with dragging the pictures into the cyclical diagram and placing them in the right order. Click the winder to rotate the images and press the play button to see and hear the sequence. This is a great resource to use as an introduction to sequencing and explanation writing.
Tes_elements
Seasons Sequencer (Simple) - KS1 Literacy

Seasons Sequencer (Simple) - KS1 Literacy

KS1 Literacy - Seasons Sequencer (Simple) This is an interactive activity for pupils to sequence the seasons. This is a simple version containing four steps that need to be sequenced. Each picture has a written description with accompanying audio. Pupils are tasked with dragging the pictures into the cyclical diagram and placing them in the right order. Click the winder to rotate the images and press the play button to see and hear the sequence. This is a great resource to use as an introduction to sequencing and explanation writing.
Tes_elements
Frog Lifecycle Sequencer (Simple) - KS2 Literacy

Frog Lifecycle Sequencer (Simple) - KS2 Literacy

KS2 Literacy - Frog Lifecycle Sequencer (Simple) This is an interactive activity for pupils to sequence the stages of a frog’s lifecycle. This is a simple version containing four steps that need to be sequenced. Each picture has a written description with accompanying audio. Pupils are tasked with dragging the pictures into the cyclical diagram and placing them in the right order. Click the winder to rotate the images and press the play button to see and hear the sequence. This is a great resource to use as an introduction to sequencing and explanation writing.
Tes_elements
A Hedgehog's Year Lifecycle Sequencer (Simple) - KS2 Literacy

A Hedgehog's Year Lifecycle Sequencer (Simple) - KS2 Literacy

KS2 Literacy - Hedgehog Lifecycle Sequencer (Simple) This is an interactive activity for pupils to sequence the stages of hedgehog’s lifecycle. This is a simple version containing four steps that need to be sequenced. Each picture has a written description with accompanying audio. Pupils are tasked with dragging the pictures into the cyclical diagram and placing them in the right order. Click the winder to rotate the images and press the play button to see and hear the sequence. This is a great resource to use as an introduction to sequencing and explanation writing.
Tes_elements
Butterfly Lifecycle Sequencer (Simple) - KS2 Literacy

Butterfly Lifecycle Sequencer (Simple) - KS2 Literacy

KS2 Literacy - Butterfly Lifecycle Sequencer (Simple) This is an interactive activity for pupils to sequence the stages of a butterfly’s lifecycle. This is a simple version containing four steps that need to be sequenced. Each picture has a written description with accompanying audio. Pupils are tasked with dragging the pictures into the cyclical diagram and placing them in the right order. Click the winder to rotate the images and press the play button to see and hear the sequence. This is a great resource to use as an introduction to sequencing and explanation writing.
Tes_elements
Information Worksheet - Planets and Space - KS1/KS2 Literacy

Information Worksheet - Planets and Space - KS1/KS2 Literacy

KS1/KS2 Literacy - Planets and Space - Information Worksheet This worksheet contains images of different planets and space with a blank space underneath for pupils to record the information they know about each. This is a great resource to use as the basis for a writing task. Pupils can expand on the notes they have taken for planets and space by developing it into an information booklet.
Tes_elements
Information Worksheet - Plants and Trees - KS1/KS2 Literacy

Information Worksheet - Plants and Trees - KS1/KS2 Literacy

KS1/KS2 Literacy - Plants and Trees - Information Worksheet This worksheet contains images of different plants and trees with a blank space underneath for pupils to record the information they know about each plant. This is a great resource to use as the basis for a writing task. Pupils can expand on the notes they have taken for plants by developing it into an information booklet.
Tes_elements
Woodland Food Cycle Sequencer (Simple) - KS2 Literacy

Woodland Food Cycle Sequencer (Simple) - KS2 Literacy

KS2 Literacy - Woodland Food Cycle Sequencer (Simple) This is an interactive activity for pupils to sequence the stages of the food cycle within woodland. This is a simple version containing four steps that need to be sequenced. Each picture has a written description with accompanying audio. Pupils are tasked with dragging the pictures into the cyclical diagram and placing them in the right order. Click the winder to rotate the images and press the play button to see and hear the sequence. This is a great resource to use as an introduction to sequencing and explanation writing.
Tes_elements
Ring the Bells Interactive Game - Christmas KS1/KS2

Ring the Bells Interactive Game - Christmas KS1/KS2

KS1/KS2 Christmas - Ring the Bells - Interactive Game This is a fun, seasonal interactive game perfect for pupils to play individually, in pairs, or even with the whole class. Pupils are tasked with watching the sequence of bells and then repeating it. Pupils can use visual skills to remember the different colours of the notes, as well as practicing auditory skills in playing back the actual tune. There are three different levels to play at, and a ‘free play’ mode or pupils to compose their own tune.
Tes_elements
Compare Shapes Interactive Activity - KS1 Geometry

Compare Shapes Interactive Activity - KS1 Geometry

KS1 Geometry - Compare Shapes Interactive Activity This is an interactive activity for comparing shapes. Pupils compare shapes using the comments listed, pressing pos/neg to get opposite statements. There is a testing panel to focus on a shape and assess lines of symmetry and whether it has a right angle. This is a useful exercise for pupils to explore shapes in more detail, and to draw comparisons between different shapes.
Tes_elements
Shape Sorting Interactive Game - KS1 Geometry

Shape Sorting Interactive Game - KS1 Geometry

KS1 Geometry - Shape Sorting Interactive Game This is an interactive activity for pupils to sort a collection of shapes according to different criteria. Pupils select what criteria they would like to sort by: colour, size or number of sides. This is a useful activity for generating discussion on properties of shapes.
Tes_elements
3D Shape Sorter - Interactive Activity - KS1 Geometry

3D Shape Sorter - Interactive Activity - KS1 Geometry

KS1 Geometry - 3D Shape Sorter - Interactive Activity This is an interactive activity to sort 3D shapes into different numbers of sets. Pupils can choose their own criteria for sorting. This is a useful resource for exploring shapes and their different characteristics.
Tes_elements
Labelling and Sorting Size Interactive Activity - KS1 Measurement

Labelling and Sorting Size Interactive Activity - KS1 Measurement

KS1 Measurement - Labelling and Sorting Size Interactive Activity This interactive activity asks pupils to level and sort animals of different sizes. Drag words from the word bank, or type in your own words, to describe the animals on the cards. These cards can then be sorted into two categories, based on your own criteria. This is a useful activity to use with the whole class to explore using comparative language.
Tes_elements
Data Representation for OCR GCSE (9-1) in Computer Science (J276)

Data Representation for OCR GCSE (9-1) in Computer Science (J276)

Data Representation Student Workbook This student workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about data representation to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “2.6 Data representation” specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 58-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: • Units • Amount of storage space required • Numbers • Denary (base 10) • Binary (base 2) • Convert from binary to denary • Convert from denary to binary • Add binary numbers • Binary Shifts • Hexadecimal (base 16) • Why is hexadecimal used? • Convert from binary to hexadecimal • Convert hexadecimal to binary • Convert hexadecimal to denary • Convert from denary to hexadecimal • Number base notation • Check Digits • Characters • Binary codes to represent characters • Character Set • ASCII, extended ASCII and Unicode • Images • Pixels • Colour Depth • Metadata • Calculating file size • Converting binary into a bitmap • Sound • How sound can be sampled and stored in a digital form • Sample frequency / sample rate • Bit rate / Resolution • Calculate sound file sizes • Compression • Lossless • Lossy
nwilkin
ICT KS 2/3 Create a board game on how to become an entrepreneur

ICT KS 2/3 Create a board game on how to become an entrepreneur

Computing / ICT KS 2/3 Create a board game on how to become an entrepreneur This is an award winning entire unit of work using Publisher to create a board game on how to become an entrepreneur. (10 hours of lesson plans) This includes the lesson plan, all templates and completed samples for this unit, as well as all learner support material. This can be easily adapted to suit just about any topic. Unzip the file, keeping the format. Run the file in the project plan folder and everything is linked to this.
wsparrow
ICT KS 2/3 Play the Stock Exchange using Excel or Google Sheets unit of work

ICT KS 2/3 Play the Stock Exchange using Excel or Google Sheets unit of work

ICT KS 2/3 Play the Stock Exchange using Excel or Google Sheets This is a 26 page unit of work on playing the London Stock Exchange using Microsoft Excel or Google Sheets. (8 hours of lesson plans with formal assessment at the end) It includes extensive lesson plans, completed samples and everything you need to run this module.
wsparrow
OCR GCSE in Computer Science Component 1 (J276/01) student workbooks

OCR GCSE in Computer Science Component 1 (J276/01) student workbooks

These workbooks cover EVERYTHING outlined in the OCE specification for component 1 of the GCSE in Computer Science for OCR (J276/01) It includes the following workbooks: 1.1 System architecture 1.2 Memory and 1.3 Storage (combined into one workbook) 1.4 Wired and wireless networks 1.5 Network topologies, protocols and layers 1.6 System security 1.7 Systems software 1.8 Ethical, legal, cultural and environmental concerns Each PDF workbook includes theory, tasks and all the answers so you and your students are confident you are covering the specification. Ideal for classwork, as homework tasks and as self-study revision aids. They are written in student-friendly language which breaks down technical topics into easy to understand chunks making these workbooks perfect for students, NQTs and non-specialist teachers.
nwilkin
Microsoft Excel Activity - Ice Cream Shop Sales

Microsoft Excel Activity - Ice Cream Shop Sales

A Microsoft Excel worksheet activity which tests students’ knowledge on the following skills: Cell referencing Use of formulae/calculations such as subtraction and multiplication. Making predictions by changing data Use of Sum() function What if questions Use this superb resource as a simple warm up exercise or to teach new skills. Answer Key included.
balsamgr8
Microsoft Excel Spreadsheets - End of Year Awards

Microsoft Excel Spreadsheets - End of Year Awards

This resource encourages students to interpret data in tally chart to then enter into a Excel Spreadsheet. Students are then expected to read the instructions on their worksheet to either add to or modify their spreadsheet. This resource covers the following skills: Entering data Writing and entering formulae. Formatting spreadsheets Creating graphs and charts
balsamgr8
Excel Spreadsheet Activity Sheet - Pocket Money

Excel Spreadsheet Activity Sheet - Pocket Money

A Microsoft Excel worksheet activity which tests students’ knowledge on the following skills: Cell referencing Use of simple formulae/calculations such as addition, subtraction, multiplication and division. Use of Sum() function Making predictions by changing data
balsamgr8
Coding: IB Key Concepts Posters

Coding: IB Key Concepts Posters

This is a set of 8 IB KEY CONCEPT posters to help align the key concepts with coding concepts and terms. This is a great way of making connections from the Key Concepts to the topic of coding, and helping students to understand more about how coding relates to areas of their life and learning.
LyndsDive
Pivot Tables Shortcut keys Mix n Match Activity

Pivot Tables Shortcut keys Mix n Match Activity

This resource contains a worksheet that can be printed out. It has a list of short cut keys pertaining to pivot tables and data management in Excel. The activity is a mix and match. Students are required to match the shortcut with the Description. The answer page is included as well as a blank sheet for further shortcut keys to be added. I generally use this at the beginning of a lesson, once I’ve covered off a bit of general knowledge around pivot tables. I then encourage students to put these short cuts into practice during the session. Included is a word document and a pdf file, so further editing is permitted. This activity can be carried out individually, in pairs, or groups to add a competitive edge.
Resource_Creator
KS3 Spreadsheets with Minecraft - Half Term Unit Resources

KS3 Spreadsheets with Minecraft - Half Term Unit Resources

This is a set of lesson resources to span 6 lessons in which spreadsheet & data analysis skills are introduced through the medium of minecraft! Combining IT and Computing skills using the logical aspects of spreadsheets gives students a solid set of skills to take further whether they follow a Computer Science or IT pathway. Suitable for Years 7 - 9 (US Grades 6-8). Pack includes: Teacher / student powerpoint to record progress with clear assessment points Student excel workbook with templates for each activity Initially written for use on Google Drive, but easily transferable to Excel / PowerPoint
hbillinghurst
BTEC Tech Award in Digital Information Technology Homework Project (6 weeks)

BTEC Tech Award in Digital Information Technology Homework Project (6 weeks)

The following homeworks are intended to support the SOW for the BTEC Tech awards in Digital Information Technology. I have used the project GameExchange123 found in the Appendix A of the SOW. Students can improve or comment on their drafts during lessons after they have completed the tasks at home. The tasks could also be completed in lessons.
mrappleton
Understanding and Using Databases (9 Lessons)

Understanding and Using Databases (9 Lessons)

Understanding and Using Databases This Unit could be taught at Key Stage 2 or Key Stage 3 (Year 7-8). This unit introduces the students to Microsoft Access. It includes 9 lessons that involves students exploring the software whilst understanding the basics. For example students are asked to: Explain what a database is and its uses (give examples) Understand both paper based and electronic databases Design and create a Superhero Database from scratch Add and edit records in the database Ask the database questions in order to search Create different types of queries to search (basic, multiple and Boolean) Produce a report to show evidence of understanding Unit includes an overview of all the lessons and an overall teacher/students assessment checklist.
samoliver368
Using Spreadsheets (8 Lessons)

Using Spreadsheets (8 Lessons)

Using Spreadsheets This Unit could be taught at Key Stage 2 or Key Stage 3 (Year 7). This unit introduces the students to Microsoft Excel. It includes 8 lessons that involves students exploring the software whilst understanding the basics. For example students are asked to: Explain what a spreadsheet is and its uses Edit and format an existing spreadsheet Understand and use basic formula and functions Create and label graphs and charts correctly Produce a report to show evidence of understanding Unit includes an overview of all the lessons and an overall teacher/students assessment checklist.
samoliver368
Network topologies, protocols and layers for OCR GCSE (9-1) in Computer Science (J276)

Network topologies, protocols and layers for OCR GCSE (9-1) in Computer Science (J276)

Network topologies, protocols and layers student workbook This student networks workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about computer network topologies to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “1.5 Network topologies, protocols & layers��� specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 27-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: Network topologies Star network topology Mesh network topology WiFi Frequency Channels Encryption Packet Switching Bandwidth Ethernet IP address MAC address Network Protocols TCP/IP HTTP HTTPS FTP POP IMAP SMTP TCP/IP model The 4 layers of network protocols Application layer Transport layer Internet layer Link layer
nwilkin
Wired and Wireless Networks for OCR GCSE (9-1) in Computer Science (J276)

Wired and Wireless Networks for OCR GCSE (9-1) in Computer Science (J276)

Wired and Wireless Networks Student Workbook This student networks workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to learn more about wired and wireless networks to gain confidence in the OCR GCSE (9-1) in Computer Science (J276) “1.4 Wired and wireless networks” specification. Can be used in the classroom as a teaching aid, for self-study or as a revision tool. This 29-page PDF which covers the theory and includes ready-to-use tasks and even includes the answers. Table of Contents: What is a network? Types of network Local Area Network (LAN) Wide Area Network (WAN) Factors that affect the performance of networks Bandwidth Number of devices Cable or wireless media Error rate Latency The different roles of computers in a client-server and a peer-to-peer network Client Server Peer-to-Peer The hardware needed to connect stand-alone computers to a LAN Stand-alone computer Network Interface Controller/Card Transmission Media Switch Router Wireless Access Points The internet Domain Name Server Hosting Cloud storage Local storage compared to cloud storage Cloud computing Security and ownership of data and software on the cloud Virtual Networks
nwilkin
Most used Excel functions - function, syntax, description quick reference sheets

Most used Excel functions - function, syntax, description quick reference sheets

This resource contains a Table of the most used functions in Excel. It is separated by Core functions, Date Functions, Text Functions, and Lookup / Reference Functions. It is set out attractively in a table, the column headings being: Function Name, Syntax and Description. It gives a quick reference to over 35 different functions. It is available in a pdf and word document so that you can make any changes required.
Resource_Creator
Year 7 Computing/ICT Scheme of work & Resources

Year 7 Computing/ICT Scheme of work & Resources

Complete collection of Scheme of work, lesson plans, Power Points and homework for Year 7 introduction to computing and ICT. Includes: Topic 1 - Introduction & using computers safely and effectively • 7 Lessons, Power Points, Assessment, Homework and Pupil Progress Diary Topic 2 - Introduction to coding through Scratch • 5 Lessons (can be stretched depending on pupil progress), Power Points, Assessment, homework and Pupil Progress Diary Topic 3 - Spreadsheet Modelling • 6 Lessons, Power Points, Assessment, homework and Pupil Progress Diary All lessons are ready to teach and require minimal, if any preperation (may need tweaking to work with your school system) - everything is provided! Pack includes a scheme of work with lesson objectives and lesson overview and how these lessons fit into and satisfy the new National Curriculum for Computing. Ideal resource for non-specialists to follow, or for a specialist to pick up and run with. Feel free to adapt the resources as needed. All lessons are ready to teach. Year 8 and Year 9 packs coming soon.
Confusion101
1&2 Bit Binary Art

1&2 Bit Binary Art

This tool creates 10 by 10 one-bit-per-pixel or two-bits-per-pixel binary images from a binary string of 0 and 1s. The choice of colour palette is left to the user with a default black and white option. Works well with snipping tool to use as part of a computing science digital portfolio. could be used in a wide variety of lessons within the context of data representation.
OliverJennings
Mobile Application Development Activity

Mobile Application Development Activity

This could be used whilst teaching ‘Appshed’ to KS3 students. It would be a good homework for either the 1st or 2nd week as it begins to questions the features of mobile applications which will support when students begin to draft their own applications. This could either be used as an activity in class or as a homework.
HDLouise
Binary and Hexadecimal for GCSE

Binary and Hexadecimal for GCSE

A high quality, complete course for the teaching of binary and hexadecimal concepts for GCSE. Students can scan the QR codes in the worksheet to see a video of the question being worked through, step-by-step, this ensures that all students of different ability levels can access the content and practice the skills. Contains: A full set of teaching presentations showing step-by-step how-to guides to each type of conversion (Keynote/PowerPoint/PDF) A comprehensive set of worksheets with explainers and QR code based video workthroughs (PDF) Front page (how-to guide) Binary to Denary Denary to Binary Binary Addition Binary Subtraction Hexadecimal to Denary Denary to Hexadecimal Binary to Hexadecimal Hexadecimal to Binary Bitwise Manipulation (Bit shifting) Answers One PDF file with all of the above Assessment set: Synoptic assessment (Word/PDF) Markscheme (Word/PDF) Markscheme workthrough (PDF) Question level analysis document (Excel) Guide to using the Question level analysis document This covers the specification for all major GCSE courses and can also be used for KS3 and the basis of KS4 Computer Science. Please feel free to mix and match as appropriate.
lessonhacker
Researching the Aztecs - KS2

Researching the Aztecs - KS2

This resource includes: PPT Starter Integrated handbook for students to complete all about ‘the Aztecs’ ‘Code breaker’ plenary Lesson plan Support ‘cheat sheet’ for L.A Students This lesson plan is based around using ‘microsoft encarta’ for researching, however the lesson could easily be used alongside other similar software. Enjoy!
HDLouise