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

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 (I use this with year 7) to the concepts of computational thinking and logical thinking. It is split into three fully differentiated sections: 1. Design an interactive story using a flowchart to identify the key decision points within your story. 2. Create an interactive story using PowerPoint, hyperlinking the slides to the correct locations. 3. Test and evaluate your story and make improvements where required. I have included some slides to provide additional assistance, for example hyperlinking auto shapes, removing the on mouse click advancements, etc. Alongside developing computational thinking skills, this unit is also an opportunity for students to develop their graphic design skills. I have also included an example interactive story so students can get an idea of what they could create themselves, while considering what they could make even better themselves. This resource is a perfect continuation from my Introduction Computational Thinking for KS3 resource! ***Please Leave a Review***

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

Develop your students problem solving skills with this resource! Learn about and break codes used across the ages including: Caeser Cypher Polybius Square Pigpen Cypher Braille Morse Code Also learn about how cryptanalyst Alan Turing shortened the length of World War II and saved millions of lives in the process! Includes both student PowerPoint work book and Teacher solutions. Final consolidation exercise includes differentiated challenges!

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

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

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.

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 :) ***

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!

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!

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.

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!