Computer Science: Introduction to Networks for KS3 students The aim of this unit of work is to introduce KS3 students to computer networks. Within this unit of work, students will learn the following: What will you learn? To understand what is meant by a Local Area Network (LAN). Hardware required Methods of connection (WiFi & Ethernet cable) To understand what is meant by a Wide Area Network (WAN). Methods to connect (GPRS, mobile, telephone cables & satellite). To understand how peripheral devices can connect to a computer system using a Wireless Personal Area Network (WPAN). Methods to connect (Bluetooth). Understand the following methods of keeping you computer secure on a computer network: - Firewall - Anti-malware - Passwords - Encryption This unit of work includes a range of information and activities to develop student knowledge and understanding of computer systems. Please note two practical activities require the use of rope to create a human networks! A final assessment is also included. Teacher answer PowerPoint also included. **Please leave a review!

This unit of work introduces students within KS3 to the concepts of computational thinking by helping Rob-bot the robot make a jam sandwich. Through the activity, students will learn about decomposition, pattern recognition, abstraction and algorithm design (through both basic flowcharts and pseudo code). They will also lean about the importance of debugging their algorithms. The duration of this work usually takes between 2-3 hours to complete, so is perfect as an introductory unit to computational thinking and programming. ***Please leave a review!***

An end of unit assessment for the topic of computer networks. The test has been made to be printed and answers written. The test takes around 30 - 45 minutes to complete, allowing for peer assessment to be conducted within the same lesson. The assessment covers the follow topics: Network types - LAN, WAN & WPAN, advantages and disadvantages Network topologies - Star, Bus & Mesh, advantages and disadvantages, diagram creation Network security - explanations of Firewall and Encryption Final consolidation exercise - create a network using given guidance. Answers with supportive guidance also included. ***Please leave a review!***

Teach your students how to use Excel through Dino Park! Students have been given a budget of £100,000,000 to build their park. They need to consider what dinosaurs they want to buy, how much space they will need, what facilities they require, staffing costs and ticket price. Excel Dino Park teaches you how to use functions and formulas through a series of engaging and interactive tasks which are differentiated to support a range of abilities. Skill that you will learn include: Add Raw data Create a graph Title a graph Formatting data Make arithmetic calculations using Excel Data validation (Drop down menus) Lookup formulas Use cell referencing in formulas Format graphs Cross worksheet referencing Advanced arithmetic calculations (nested) Use absolutely relative cell referencing Adding messages to data validation Efficient calculations (autosum) Conditional formatting Advanced graph formatting IF formulas Linking IF formulas and conditional formatting The clear explanations and step by step nature make it ideal for KS3 classes, but it is also suitable for ECDL, GCSE and beyond! Use alongside RobbotResources’ How2Excel’ workbook for a comprehensive understanding of how confidently use Excel! ************************Please leave a review!*************************

Within this short unit of work, students will learn the following: To understand why subroutines are used. To explain the difference between a procedure and a function. To explain the purpose of a local and global variable. To understand how to write a subroutine. Learning is consolidated with a series of differentiated subroutine algorithm tasks that challenge students on their understanding of algorithms and subroutines. It is highly recommended that students complete the Rob-Bot Resources KS4 Algorithm Design unit of work before completing this unit.

Within KS3 Computer Science: Data Representation - Year 8, your students will recall and build upon understanding developed within Data Representation for Year 7 and learn the following: To recall binary and denary conversion techniques from year 7. To be able to add two binary numbers using binary addition and understand the term overflow error. Understand the use and purpose of ASCII and Unicode character sets. Understand how images are stored on a computer. Understand the relationship between resolution, colour depth and file size. Recap the terms ‘Base 2’ and ‘Base 10’ number systems. To apply understanding to the use of Hexadecimal (base 16). Your students will learn these concepts through a range of clearly presented explanations and a range of tasks and challenges to consolidate learning. This unit of work also includes a final assessment. Full teacher solutions also included! Before completing this unit of work, it is recommended that your students complete Data Representation for Year 7 and Computer Systems for Year 8 so they have an understanding of the different hardware components of a computer.

Learn how to record information onto trace tables with this great resource! Within this unit of work students will learn: What a trace table is and how they are used. How a trace table is used to record changes using the following algorithm techniques; * Sequence * Selection * WHILE loop * FOR loop * REPEAT loop * Arrays There are a range of different trace table activities to complete, with solutions also included! **It is recommended that students complete the following units prior to attempting this unit of work: GCSE 9-1 Computer Science: KS4 Algorithm Design GCSE 9-1 Computer Science: Arrays**

Rob-bot Resources presents a complete guide to support primary school teachers in the delivery of the Digital Competence Framework (DCF) in Wales. Following the Donaldson Report (2015), the need to improve digital competency within students across Wales was identified as being as important to the development of students as literacy and numeracy. This document provides practical solutions as to how primary teachers of years 3-6 can confidently deliver these requirements across a broad range of subjects. Where possible I have included “unplugged” solutions, i.e those that don’t require a computer to fulfill the requirements, so that teachers of all backgrounds can feel confident in the delivery of the framework. ***Please leave a review! ***

KS3 Computer Science: Algorithm Design - Year 8 recaps and builds upon the basic understanding of algorithm design learned within Algorithm design for Year 7 and allows your students to learn the following: Understand that an algorithm is a set of instructions used to solve a problem. Use both flowchart and pseudocode to design an algorithm. To recap the following algorithm design techniques Sequence and Selection. To understand the following data types: Character String Real Integer Boolean To learn how to use looping to write repeatable sequences of code. To apply understanding into subroutine challenges. To understand different types of errors that can occur while writing algorithms (Syntax, Logic and Runtime) and methods used to identify them. This resource includes a range of clearly presented explanations as well as a range of structured tasks to help your students practice their skills. It is recommended that students first complete the Algorithm Design - Year 7 and Computational Thinking for KS3 unit of work in order to develop a basic understanding of both computational thinking and algorithms. This unit of work also includes a final assessment. Full teacher solutions also included!

Teach your students how to mail merge using this resource! This pack contains; A power point presentation to explain how to conduct a mail merge - this can be used independently by students. Mail merge address list A letter with identified fields to merge An example of how the merge should look Ideal for supporting ECDL students!

Introduction to computer systems for Year 7 students. The aim of this unit of work is to introduce year 7 students to the basic concepts of computer systems. What are we learning? To show understanding of the difference between input and output devices with suitable examples. To understand the difference between internal and external devices with suitable examples. To describe the different types of storage: Magnetic, Optical and Solid State. To understand the role and purpose of the CPU and the relationship with RAM (Fetch-Execute Cycle). To show an understanding of an embedded system including suitable examples. This unit of work includes a range of information and activities to develop student knowledge and understanding of computer systems. A final assessment is also included. Teacher answer powerpoint also included. **Please leave a review!

"There are 10 kinds of people in the world; those who understand binary numbers… and those who don’t!" Alongside understanding the joke above(!), KS3 Computer Science: Data Representation - Year 7 will teach your students the following: Explain why a computer uses binary. To be able to identify the number of bits in different units of data e.g. Bit, Nibble, Byte, Kilobyte, Megabyte, Gigabyte, etc. To explain the difference between ‘base 2’ and ‘base 10’ numbering systems. To be able to convert binary into denary and vice versa. Explain how characters are stored in the ASCII character set. Your students will learn this information through a variety of clearly presented instructions as well as a range of tasks and activities designed to consolidate learning. This unit of work also includes a final assessment. Full teacher solutions also included! Before completing this unit of work, it is recommended that your students complete Computer systems for year 7 so they have an understanding of the different hardware components of a computer.

Ideal to support the delivery of GCSE, BTEC and ECDL ICT courses! If you like the quality of my other resources, you won't want to miss this!!! A comprehensive guide on a broad range of differentiated Excel skills which include; Data Types: Raw, Changing Type, Relative & Absolute Cell Referencing Formatting: Cells, Colours, Font & Borders Basic Arithmetic Formulas: Simple arithmetic (+ - * /), Relative & Absolute Formulas, Common Errors Functions: SUM, AVE,MIN, MAX, COUNT, COUNTA, ROUND Advanced Functions: BOOLEAN (< > =), COUNTIF, IF, Nested IF, LOOKUP, CONCATENATE Applying Cell Referencing Validation Rules: Including Drop Down Lists Using Table Filters Creating Graphs and Charts Conditional Formatting Creating Macros Each skill includes a tutorial and a task to show you how to apply it. There are also two consolidation exercises which require the application of a range of skills learned within the tutorials. These include; Create an Interactive Spreadsheet Dream Team Generator A checklist at the start of the workbook allows you to keep track of your progress. ***Please Leave a Review!***

Revision clocks are a great way for students to develop retrieval practice in preperation for exam season! My students loved it and really engaged with it! This resource contains two revision clocks for both paper 1 and paper 2 topics for the AQA GCSE Computer Science specification as well as instructions to support their use. Note: it is recommended that the posters are printed out on A3 paper for best effect.

A simple poster to help explain the four concepts of Computational Thinking: Decomposition, Pattern Recognition, Abstraction and Algorithm Design! Computational Thinking is a skill set that can be used across the curriculum, not just within computer science! The logical approach to solving a problem means that it’s application can be used to develop and improve students ability to deal with difficult problems in a more rational way. The aim of my posters is to make you realise that many of the brilliant tasks that teachers facilitate week in, week out actually include computational thinking. It’s just a matter of making it more explicit!

The following quiz is based upon the four parts of Computational Thinking: Decomposition, Abstraction, Pattern Recognition and Algorithm Design. The quiz includes 8 questions including definitions and scenarios to test your students understanding of Computational Thinking. Ideal to use as either a starter or plenary! Give students a mini white board and marker pen for instant feedback! Also includes a Computational Thinking Recap slide prior to the quiz itself. Please leave a review!