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

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

Get your students into the right mindset from the off with these fantastic starter activities! With 20 different puzzles for your students to try and solve, there are enough activities to cover a full 8 week term! This resource includes a range of puzzles such as code breaking, symbol grids, number pyramids, understanding algorithms and many more! Solutions included!

Wrap your students minds around my latest poster collection, ideal as a revision tool to support all GCSE Computing courses! Todays World is full of online information and data, but how much is there? How much are we able to store now? What does the future hold? What is a bit? What is a Megabyte? How big is a Petabyte? A series of 12 informative posters on base 2 memory storage that begin at bits, nibbles & bytes then continues through to the mind blowing number of a Yottabyte! The posters include real world examples to help students comprehend what the numbers really mean! I have provided the posters as both a collection of JPEG files and in PDF format. Update: now in high resolution 2560x1440 ** Please leave a review!!! **

Introduction to computer systems for year 8 students. The aim of this unit of work is to build upon the knowledge and understanding of computer systems developed within KS3 Computer Science: Computer Systems Year 7. What are we learning? Explain factors affecting CPU performance. Clock Speed Cache Size Number of Cores RAM, ROM and Virtual Memory – understanding of differences between volatile and non-volatile memory. Explain factors affecting secondary storage. Cost Capacity Speed Portability Understand the Fetch – Execute Cycle. 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!

This versatile resources is aimed to develop your GCSE Computer Science retrieval skills and practice a range of fundamental skills which consistently appear within GCSE Computer Science exams. This resource is an ideal revision activity and includes a pack of 10 activity sheets within both PowerPoint and PDF format. I have included three different versions: Student pack - activity sheets only Teacher pack - answers (with explanations) only Student self assessment pack - both activity and answers Skills covered include: ASCII conversion Understanding binary and hexadecimal values Binary, denary and hexadecimal conversion Huffman coding Binary addition Memory size conversions These activities can be used as classroom starters, homework or as main classroom activities. It is recommended that these activities are used to practice and assess students ability to perform these skills, not as an introduction. Please leave a review!!!

Part 6 of a series of 7 introductory lessons on how to use Python through the use of the IDLE GUI. Within Part 6 you will learn how to edit string in a wide range of ways using python functions, for example, count elements, replace letters, use variable indexing, titling text and changing the casing . This resource builds on the skills learned within previous resources within the Rob-Bot Resources Introduction to Python Programming series. Learn new programming skills through clearly presented explanations before applying your newly developed skills within a series of easy to follow tasks, explained through written explanations as well as flowcharts and/or pseudo code. Each unit in this series is fully differentiated using Rob-Bot Resources’ unique Rookie, Pro and Beast leveling system; apply your new programming skills by completing the introductory Rookie tasks. Once you've got a grip of the basics, push yourself by completing the Pro exercises before finally testing your skills by completing the Beast scenarios. Once you have completed the practice tasks it’s time to test your skills within the differentiated programming challenges! All task and challenge coding solutions are also included. Suitable for both KS3 and KS4 classes. ***Please leave a review :) ***

Practice makes perfect with this activity pack which includes over 1000 questions split between four different challenge levels, allowing students of all abilities to learn how to convert decimal numbers into hexadecimal! Level 1: Eight activity sheets containing four sets of eight numbers each set within a progressive range. Level 2: Eight activity sheets containing two sets of sixteen numbers both sets within a progressive range. Level 3: Eight activity sheets containing thirty two numbers each page within a progressive range. Level 4: Eight activity sheets containing thirty two random numbers within the range of 0 to 255. Each pack includes 8 pages of 32 questions, converting the numbers 0 to 255 (a byte). Each challenge pack includes clear explanations on how to make conversions and calculation tables to support the given conversion techniques and make students feel confident in doing it themselves. Each challenge pack is provided as printable pdf so that students can complete them on paper. All answers are included on both pdf and ppt to allow for both teacher or self assessment. Ideal to use as starter activities, plenaries or homework!

Within this unit of work, students will learn how to apply the concepts of computational thinking to a range of different problem solving puzzles. The resource is split into four sections; 1. Computational thinking puzzles - a range of different types of puzzles which encourage students to apply the concepts of computational thinking to solve them. Puzzles include mazes, word ladders and even a game of draughts (or checkers)! 2. Logic Gates - students will need to solve the logic gate puzzles to identify if the output is on (1) or off (0) dependent on the gate sequences. This also helps develop Boolean decision making through the use of AND, OR & NOT gates which produce a TRUE (1) or FALSE (0) output. 3. Flowchart puzzles - students need to work out the correct answers to the questions asked dependent on the input information and the flowchart conditions set. Flowcharts include the use of algebra variables which can help support mathematics students. 4. Pseudo code puzzles - students need to read through the pseudo code algorithms and demonstrate their understanding by answering the questions asked. Pseudo code sequences include the use of algebra variables which can help support mathematics students. Each puzzle is given a score. Once complete students check their answers and work out their overall scores and place them in the grid provided. They then compare this with the overall levels to find their overall level: Rookie, Pro or Beast! This can then be used within assessment to see if students are performing at, below or above expected levels. Pack includes a student PowerPoint resource to complete and answers for each puzzle. ***Please Leave a Review!***

Part 7 of a series of 7 introductory lessons on how to use Python through the use of the IDLE GUI. Within Part 7 you will learn how to improve the efficiency of your coding by writing loop functions. You will learn how to write two different types of loop sequences; While loops and For loops. This work builds upon and applies concepts learned within the previous work within the Rob-Bot Resources Introduction to Python Programming series. Learn new programming skills through clearly presented explanations before applying your newly developed skills within a series of easy to follow tasks, explained through written explanations as well as flowcharts and/or pseudo code. Each unit in this series is fully differentiated using Rob-Bot Resources’ unique Rookie, Pro and Beast leveling system; apply your new programming skills by completing the introductory Rookie tasks. Once you've got a grip of the basics, push yourself by completing the Pro exercises before finally testing your skills by completing the Beast scenarios. Once you have completed the practice tasks it’s time to test your skills within the differentiated programming challenges! All task and challenge coding solutions are also included. Suitable for both KS3 and KS4 classes. ***Please leave a review :) ***

Download my poster which includes example task ideas on how to apply computational thinking problem solving skills to Art. The poster includes a range of tasks and classroom ideas that use key computational thinking skills! 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! Update: High Resolution 2560x1440 in both PNG & JPEG Please leave a review!!!

A series of 6 classroom wall posters to promote the concept of computational thinking. Alongside the 4 parts of computational thinking (Decomposition, Pattern Recognition, Abstraction and Algorithm design), I have also included debugging which includes common errors (example syntax and logical). PNG and PDF versions included. 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! Please leave a review!

Included in pack - PDF and PPT versions. Includes; Procedures, Functions, IF then Else statements Loops (Repeat, Forever, Forever IF) Getting around (Moving jumping techniques) Game based (Scoring, collecting objects, timers) Scratch specific techniques (Broadcasting, variables, costumes) Bouncing off things (edge of screen, walls) Creating a scrolling background Ideal for KS3, but also suitable for KS2. Also includes flowchart diagrams to help explain the concept of the programming. *****************************************Please leave a review!***************************************