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)

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
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
Computer Science GCSE - Logic Gates - Match up the name, symbol, description and truth table

Computer Science GCSE - Logic Gates - Match up the name, symbol, description and truth table

Computer Science GCSE CIE 0478 Unit: 3 Topic: Logic Gates A task to match up the name, symbol, description and truth table for each logic gate. The task produces a single A4 sheet/table which is great for a reference/revision of the topic. Students complete a table with four headings; name, symbol, description and truth table. All the details are provided and can be copied and pasted into the table. Final results can be printed and used for revision or as a quick reference guide during the topic. A homework has been included to reinforce the learning. Please leave some feedback.
cormacmcgleenon
Logic Statements to Circuits - Computer Science GCSE 0478

Logic Statements to Circuits - Computer Science GCSE 0478

Logic Statements to Circuits - Computer Science GCSE 0478 Unit 3 – Logic Statements to Circuits A set of exam questions with answers and step by step instructions adapted from past papers Each with solution on presentation and a worksheet for students Ideal for teaching how to answer exam style questions
cormacmcgleenon
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
App Inventor Alluring Audio - (Lesson 4)

App Inventor Alluring Audio - (Lesson 4)

This is the forth lesson in the ‘App Inventor’ scheme of work. This lesson combines practical and theory to teach the “representing sound” concepts covered in the Computer Science 9-1 GCSE specifications, (including; sample rate, sample resolution & calculating audio file size.) All lessons within the scheme are targetted at KS3/KS4. Each slide includes detailed notes to support teacher understanding and have been based on a lesson plan structure. There is no prior knowledge required from the class teacher as the guides provided are step-by-step & all code is catered for in the documentation provided. For this lesson a video tutorial is available to support learners with the design of their app. The lesson includes a minimum 45 minute assessment (electronic & paper based included) with mark scheme both of which are custom made, this will truly test learner’s understanding. Using the ‘App Inventor’ emulator or a mobile device with the 'MIT App Inventor app’ installed will allow learners to practically use the apps they build. The app can be downloaded freely from the ‘Google Play’ store.
beef_keefe
Small Basic Text Window (Using For and While Loops)

Small Basic Text Window (Using For and While Loops)

Worksheet for students to assist them in generating Small Basic code to write a times table and list multiples of a number. (Output in the Text Window) This activity will develop understanding of For and While loops (and consoldiate use of a variable e.g. name) Answers for the teacher included. The worksheet is available in** .docx** and **.pdf **formats.
rhyteach2002
Small Basic Graphics Window (FULL LESSON drawing a polygon)

Small Basic Graphics Window (FULL LESSON drawing a polygon)

FULL LESSON for teaching students how to use Small Basic Graphics Window. **Learning objectives: • Identify mistakes in Small Basic code • Predict what given code will do • Choose code to complete a given outcome Some students will be able to: Comment their code ** Teacher presentation included for large display. Full lesson plan included. 3 levels of worksheets included for use with differentiated groups in your classroom. PowerPoint with further examples of small basic code for optional demonstration to students/further explanation of lesson outcomes.
rhyteach2002
Python Pack

Python Pack

a collection of text files which feature python code including: Creating coloured patterns Guess the Number X’s and O’s
dominicberesford1993
Excel Chart Types Activity

Excel Chart Types Activity

This resource can be used during a lesson with Excel Charts. It is useful to become familiar with different chart types and their application. The activities can be carried out individually, in pairs or in teams. It is always more fun to team up, as two heads are better than one and lots of discussion can be generated. Files are available in both pdf and docx format for editing if required. Preparation for Mix N Match Activity: Print out the document named ‘Chart Type Activity Answers’ Laminate the sheets (optional) Cut out all the segments Learners now match up all three elements (Chart name, Description, Picture). This activity can be timed and completed in teams to add a competitive edge. Other Activity Options: Print out the document named ‘Chart Type Activity without Chart Type’. Learners will review the description and the pictorial view and name the Chart Type. Print out the document named ‘Chart Type Activity without Description’. Hand out the cut outs of ‘Descriptions’. Learners place them in the appropriate slot. Print out the document names ‘Chart Type Activity without Picture’. Hand out the cut outs of ‘Pictures’. Learners place them in the appropriate slot.
Resource_Creator
Flowcharts and Computational Thinking

Flowcharts and Computational Thinking

An ideal lesson to continue learning of computational thinking and flowcharts. Encourages correct use of symbols and application of knowledge with open ended tasks as well as worksheet which can be used as an assessment material. Requires previous knowledge of flowcharting including correct symbols.
MissC_Computing_Media
App Inventor FortuneT --- (Lesson 3)

App Inventor FortuneT --- (Lesson 3)

This is the third lesson in the ‘App Inventor’ scheme of work. This lesson introduces programming concepts including; Variables, data structures & the randomise method in a completely interactive manner. All lessons within the scheme are targetted at KS3/KS4 and appropriately mapped to elements of the Computer Science 9-1 GCSE. Each slide includes detailed notes to support teacher understanding and have been based on a lesson plan structure. There is no prior knowledge required from the class teacher as the guides provided are step-by-step & all code is catered for in the documentation provided. Using the ‘App Inventor’ emulator or a mobile device with the 'MIT App Inventor app’ installed will allow learners to practically use the apps they build. The app can be downloaded freely from the ‘Google Play’ store.
beef_keefe
Presentation: how a selection sort works

Presentation: how a selection sort works

Presentation on how a selection sort works. It includes: A presentation explaining the principle of operation behind a selection sort A presentation introducing the code written in python to perform a selection sort The selection sort python code in a separate text file.
Teacher_aesg
Programming Using Kodu

Programming Using Kodu

Students will understand the term ‘programming’ whilst using Kodu. Students will use Kodu to create a world and program Kodu to move. Students will then design and create their own game whilst providing evidence. Lesson One-Six Kodu Lesson Seven Revision Lesson Eight Assessment Lesson Nine Feedback and Improvements This unit has a lesson presentation for every lesson that includes a starter activity, main activity and plenary. Resources also include homework, worksheets, helpsheets and an overall assessment sheet that can be used for self, peer and teacher assessment. A full Scheme of Work is also provided. This unit of work is suitable from Years 6-8 depending on ability.
samoliver368
App Inventor Drawing Tools -- (Lesson 2)

App Inventor Drawing Tools -- (Lesson 2)

This is the second lesson in the ‘App Inventor’ scheme of work. This lesson introduces learners to being able to apply drawing tools in ‘App Inventor.’ Learners will code a solution to a given problem and will apply computational thinking skills. All lessons within the scheme are targetted at KS3/KS4 and appropriately mapped to elements of the Computer Science 9-1 GCSE. Each slide includes detailed notes to support teacher understanding and have been based on a lesson plan structure. There is no prior knowledge required from the class teacher. Using the ‘App Inventor’ emulator or a mobile device with the 'MIT App Inventor app ’ installed will allow learners to practically use the apps they build. The app can be downloaded freely from the ‘Google Play’ store.
beef_keefe
GUESS WHO COMPUTATIONAL THINKING CHALLENGE (STEM & DIGITAL TECHNOLOGIES )

GUESS WHO COMPUTATIONAL THINKING CHALLENGE (STEM & DIGITAL TECHNOLOGIES )

☀️ This has got to be one of our most engaging STEM activities yet!!! An absolute cracker of a resource for teaching COMPUTATIONAL THINKING, ALGORITHMS, MATHS and TECHNOLOGY. The challenge is simple… CAN YOU CREATE THE PERFECT FACIAL RECOGNITION ALGORITHM? It draws upon the classic game “GUESS WHO?” to instantly engage students with ease. The learning is incredibly deep and this resource could easily FILL A WEEK of class time or a single 90 minute session depending on how far you wish to go… And it’s completely EDITABLE Whats inside ⭐Computational Thinking resources and activities related to the topic ⭐Teacher Hints and Tips ⭐ Complete lesson plans ⭐ Facial Recognition Lessons and Content ⭐ Removable / Hints and Tips for Beginners ⭐ Lessons on Data and Attributes ⭐ Custom made Graphic Organizers ⭐ Custom made Flowcharting Activities ⭐ Heaps of digital video and interactive content ⭐ Literacy related tasks to the ethics of facial recognition ⭐ Glossary of terms ⭐ Video tutorial explaining the perfect solution ⭐ Assessment and Reflection Tool Compatibility with Google Classroom and NO PREP REQUIRED
Innovativeteachingideas
Computer Science Poster: How to read and write Edexcel pseudo code

Computer Science Poster: How to read and write Edexcel pseudo code

This handy poster is a great revision tool to help your GCSE computer scientists prepare for their computational thinking problem solving paper! Although focused around Edexcel specification, it is also easily applicable for others. This poster will help your students to both understand what the pseudo code means within exams as well as help them write their own, well structured pseudo code. Update: High Resolution 1440x2560 in both PNG & JPEG Please leave a review
RobbotResources
End of year Computing Summer Quiz 2018

End of year Computing Summer Quiz 2018

NEW COMPUTER SCIENCE QUIZ FOR THE END OF YEAR / SUMMER TERM 2018! A fun whole class quiz, ideally suited to keep pupils engaged and settled for the final lesson of the summer term. Suitable for year 7 to year 11. The quiz includes computer science elements as well as other fun summer related questions getting them into the summer holiday spirit. Guaranteed to make the final lesson fun before they break up for summer. Print out the answer sheets (enough for 1 per team) and then run through the quiz on the whiteboard. After each section the answers are provided allowing the quiz to easily be cut shorter if you wish. Suitable for GCSE Computer Science classes and KS3 Computing and ICT classes.
nwilkin
Introduction to Computer Science

Introduction to Computer Science

An ideal first lesson to introduce the subject or topic surrounding computing, computer science or computational thinking. -Computational Thinking -Introduction to Flowchart design Complete with information slides, activities, starter and plenary. Suitable for a 1 hour lesson.
MissC_Computing_Media
Microbit- a lazy set of 6 problem-solving lessons

Microbit- a lazy set of 6 problem-solving lessons

This is a great set of lessons for microbit that require NO prep on the teacher, entirely student led, guaranteed to create engagement. Perfect for year 7 but could be extended to year 8 and 9 as well. my students love it! it gives opportunity for discussion,planning, pseudocode,flowchrt, testing. each lesson has a real life problem that the students need to solve using the microbit I used the microbit “let’s create” block editor online software (which will give simulation of the real microbit on days when i am too lazy to even get the microbits off the shelf!),though my higher students are asked to complete it in Python once they have solved the problem successfully in the block editor.
annetortue
Gamemaker Language Resource

Gamemaker Language Resource

I have made this resource using GameMaker to help teach how to use GameMaker Language. The resource is interactive and allows object to be dragged into space and code dragged onto the object to see what the code does. It explains all code that can be dragged onto object. It is bug/error free but there are things I plan to add when I have more time. There are some easter eggs like the player objects can be controlled by WASD. Please see my other resource if you want something to support teaching logic gates and boolean algebra. You will need to extract the zip and make sure both files are together when running the .exe. Please support me with reviews and constructive feedback, this will encourage further contributions. Please do not maximise the window as this will cause the mouse pointer to not set objects down properly.
axepage1
Python Mathematical Operators Practical Challenges

Python Mathematical Operators Practical Challenges

A great 2 page handout for your pupils to practice using mathematical operators and functions in Python. Includes example code, a task to correct code and 6 practical challenges for them to practice writing for loops in Python code. It even includes a PDF containing the answers. Great for homework tasks, classroom activities or self-study.
nwilkin
Python Random Values Practical Challenges

Python Random Values Practical Challenges

A great 2 page handout for your pupils to practice using random values in Python. Includes example code, a task to read code, a task to correct code and 4 practical challenges for them to practice writing for loops in Python code. It even includes a PDF containing the answers. Great for homework tasks, classroom activities or self-study.
nwilkin
Year 9 Computer Science Assessment

Year 9 Computer Science Assessment

This year 9 computer science assessment could either be used at the start of the year to assess suitability or at the end to assess learning. Another option is to do both and measure student progress and impact of teaching. Students aspiring to student computer science at GCSE must aim to score between 30 and 75. Answers/ Mark scheme provided.
chris_vidal
Scratch UltraBundle - 3 Units

Scratch UltraBundle - 3 Units

This bundle includes the Scratch beginner’s bundle, intermediate bundle and expert bundle all in one. I have used this for Years 5-7, using one unit each year as they move up the school. This could be used for other year groups as they encounter and improve with Scratch. Each unit should take 6-8 lessons, which is why I have spread them out over three year groups. In total there are 18 different resources bundled together here.
MrHawes8
KS2 / KS3 Scratch Expert Bundle

KS2 / KS3 Scratch Expert Bundle

This bundle is the third in a series of Scratch units, intended for KS3 or possibly high ability KS2 students. The first two lessons include looking at flowcharts and creating an algorithm using a flowchart, which then feeds into creating the game in Scratch. The third lesson involves creating a slug trail maze, which draws on what they might have done previously in creating mazes and drawing with the pen tool. The fourth lesson is more in depth with a look at variables and iteration, creating an endless scrolling flying game. The fifth lesson involves debugging and coding a Space Invaders-style game using starter code. This task includes subroutines and is the hardest of the unit. The unit ends with a project (3+ lessons) where the students create their own game based on some loose instructions. They then write about how they have made their game using a template in Powerpoint.
MrHawes8
KS3 Scratch Game Project

KS3 Scratch Game Project

This resource is a set of instructions for KS3 students to create their own game. Ideally they will be at or near to finishing with Scratch before moving on to more complex programming languages. This is intended for the end of my KS3 Scratch Unit of work. Included is the Word document which details what they will need to include in their game (and what they might want to include), as well as an example game evaluation written in Powerpoint to make it easy for them to write about. There is also a skeleton evaluation which describes what they need to include in their evaluation. As the students can create their own game and need to write about how they have made it, this is likely to take a minimum of three lessons.
MrHawes8
KS3 Scratch Space Intruders game tutorial

KS3 Scratch Space Intruders game tutorial

This resource includes a finished Space Invaders-style game made with Scratch, as well as a starter code version of the game and a tutorial/help sheet. This is intended for one lesson to help teach variables and subroutines. The finished version can be shown as a demonstration of how the game should work, then the students can be shown the starter code. This version does not work, and they will need to complete the tasks on the tutorial to get it working correctly. The tutorial includes screenshots of code snippets and explanations of how any why they work to get the game functioning correctly.
MrHawes8
KS3 Endless scrolling game scratch tutorial

KS3 Endless scrolling game scratch tutorial

This resource is a tutorial to help students understand how variables and iteration are used to create a simple scrolling game. The tutorial includes screenshots of code snippets and instructions on how and why the code works to create the finished version of the game. The resource also includes the finished version of the game, which I use to demonstrate the game before showing the first few steps in making it. The tutorial can be used as a help sheet for students who push on further with the game before the rest of the class, or who might need help in getting their game to work as intended.
MrHawes8
KS2/KS3 slug trail maze tutorial

KS2/KS3 slug trail maze tutorial

In this resource is a working version of a ‘slug trail’ maze game, and a Word document tutorial to go with it. The tutorial can be given to students as a help sheet once they have been given an introductory demonstration, or if they are pushing on further than the rest of the class. The tutorial help sheet includes screenshots of code and explains how and why this code is used to create the finished version of the game.
MrHawes8