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

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!

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!

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!

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

This lesson gives students a clear understanding of the required data types which are expected to be known for GCSE 9-1 computer science. Within this unit of work, students will learn: To understand the different types of data used within algorithms e.g. Integer Real Boolean Character String To understand how variables are used to store data. To understand how to analyse and edit string: measuring the length of a string, string indexing and changing case. A range of activities and challenges are included to allow students to consolidate their learning. Solutions are also included. Use this lesson alongside my KS4 algorithms work to give students a comprehensive understanding of how data types are used within algorithms!

This short unit of work introduces year 7 students to the basic concepts of algorithm design. Students will 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. Learn the following algorithm design techniques; Sequence Selection Understand Boolean statements such as <, > and = and know when to apply them within an algorithm. Understand how to use variables to store information for later use within an algorithm. 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 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!

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

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

Dive into the captivating world of data representation with my educational poster set. Designed with clarity and insight, each poster delves into different facets of data representation, providing a visually engaging learning experience. Explore the rhythm of sound waves, understand the intricacies of text and character encoding, and witness the magic of bitmap and raster graphics. Understand the science of calculating image resolution with easy to follow visuals and explanations. Ideal for classrooms and study spaces, this poster set serves as an invaluable educational tool for students and educators alike!

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!

Part 4 of a series of 7 introductory lessons on how to use Python through the use of the IDLE GUI. Within Part 4 you will learn how to make your code perform different actions through the use of decisions. You will learn how to check for a condition through the use of logic and Boolean operators and apply them within simple if statements before learning how to check for multiple outcomes using the ELSE and ELIF functions. 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 :) ***

Introduce your students to key algorithm design techniques with this resource! Within this unit of work your students will: Learn how to write algorithms using both symbols (flowchart) and written notation (pseudocode). Learn how to write algorithms using structured techniques including: * Sequencing * Selection * Iteration (looping) Gain understanding of the need for accuracy when writing algorithms. Practice debugging your code. This resource includes explanations of each algorithm design technique as well as clear structured examples of how to write them using both flowchart and pseudocode. After each technique has been explained, students have the opportunity to apply their understanding within an activity which includes higher ability expectations. A final Rookie, Pro and Beast algorithm design challenge has also been included as well as suggested solutions for each activity.

Within this unit of work, your students will learn to: Understand different methods of sorting data within an array: - Bubble sort - Merge sort Explain how both methods work. Identify advantages and disadvantages of using both techniques. Students will learn about how both sorting methods work through clearly presented explanations, pseudocode, diagrams and animations. Students will develop and consolidate their understanding through a range of tasks and activities including the creation of sorting algorithms using Python. Although this unit of work has been created following the AQA GCSE 9-1 Computer Science specification, it is applicable to anyone who wants to learn about sorting algorithms. Recommended prior learning: KS4 Algorithm Design (Sequencing, Selection & Iteration): https://www.tes.com/teaching-resource/gcse-9-1-computer-science-ks4-algorithm-design-12044669 Data Types: https://www.tes.com/teaching-resource/gcse-9-1-computer-science-algorithm-design-data-types-12047021 Arrays: https://www.tes.com/teaching-resource/gcse-9-1-computer-science-algorithm-design-arrays-12044694 Subroutines: https://www.tes.com/teaching-resource/gcse-9-1-computer-science-algorithm-design-subroutines-12047070

A quick reference poster which I’ve developed to help develop independent learning skills within computer science lessons. The sheet includes key words, programming techniques, data types, flowchart symbols and examples of writing algorithms in both flowcharts and pseudocode. Suitable for KS3 and KS4, I have included both jpg and PNG versions. ***Please leave a review!

The following resources work in conjunction with KS3 Computer Science: Networks. This knowledge organiser includes all the topics learned within this unit of work into one single page. The revision sheet helps your students to prepare for the end of unit assessment while also developing independent learning skills!

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