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
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
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
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
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
KS3 Scratch Flowcharts 2-lesson mini project

KS3 Scratch Flowcharts 2-lesson mini project

Included in this resource is a Powerpoint which is helpful in recapping flowcharts and then leads into a programming task involving a number guessing game. The students should be aiming to make a flowchart based on the first two tasks in the project, which will help them move on to programming them in Scratch in the second lesson. There is a card sort which involves writing the instructions onto blank paper symbols to form the flowchart, and examples of each task as a flowchart and scratch game. This has been used with Year 7 following two previous units using Scratch, as a warm up for programming as well as a reminder of flowcharts and their usefulness in planning programs.
MrHawes8
Scratch DIRT SHEET - Assessment

Scratch DIRT SHEET - Assessment

Created this DIRT sheet for my Year 8’s but can be used for any year group. SIMPLE TO FOLLOW Teacher can look through their scratch projects and tick the boxes the pupils have covered in their Project. Pupils can then reflect on their project and suggest improvements they could make.
LUKEB82
Scratch Programming Fractal Tree Activity

Scratch Programming Fractal Tree Activity

One of the areas of the national curriculum that we should be introducing students to is RECURSION. This is an excellent activity to introduce that concept in a visual way with a simple task to create a fractal tree in Scratch programming. This activity I had a learning observation on. I had my students work in small groups to try and complete the main activity together. When they finished this, they were to research other fractal activities on-line and see what they could create. Students really enjoyed this activity at the end of the Scratch topic to introduce a very complex topic that is not part of GCSE, but that appears again at IB level and A level. I expect students to learn that recursion is a complex rule that simplifies programs, but is very difficult to understand and it is a function that uses itself to solve a problem.
PaperAirplane
Scratch Programming Test 2 + Answers

Scratch Programming Test 2 + Answers

End of section test (I use with Y8 students) to assess their comprehension of coding using Scratch (I have uploaded my unit of work which goes with this. This is used a long with the assessment activity uploaded in the other unit of work, to check student progress. This is a problem solving assessment which tests students abilities to read and interpret code, as well as explain it. Checks their logical and computational thinking skills and ability to spot and correct errors.
PaperAirplane
Excel Pivot Table Exercise / Task

Excel Pivot Table Exercise / Task

This resource has been developed as a practice Exercise for learners who have been introduced to Pivot Tables in Excel. It is a practical task that can be undertaken in teams, pairs or individually. It includes a set of data that needs to be analysed. Learners are required to brainstorm questions that a Sales Manager would need to know about the transactional data. They then create pivot tables based on the questions. There is a second spreadsheet that contains 8 sample questions and pivot tables that relate to the questions. This activity has been well received in my classroom of adult learners. They become very engaged in the process and develop a better understanding of the use of pivot tables.
Resource_Creator
Cluedo murder mystery riddle - adaptation from Einstein's '5 houses' logic puzzle

Cluedo murder mystery riddle - adaptation from Einstein's '5 houses' logic puzzle

**Mr Black has been found dead at Tudor Manor. ** You are the lead investigating detective. You have all six suspects brought to the main hall of the mansion, seated next to each other around a circular table. Every one of them has a motive to murder Mr Black, but only one committed the crime. Can you solve the case and bring the killer to justice? Who killed Mr Black? What weapon was used? Where was the weapon hidden? This activity is an adaptation of mine based off Einstein’s ‘five houses’ logic problem Students extract relevant information from text; create an appropriate data structure to record these facts; and use a process of elimination to solve the problem I have been using it with KS4/5 Computer Science classes to demonstrate computational thinking (abstraction and decomposition)
mailmikejenkins
Presentation:   how to test a system (x11 slides)

Presentation: how to test a system (x11 slides)

The presentation introduces the idea behind testing and covers the ideas behind the idea of creating a test plan, difference between a fault and an error and shows a blue screen error. It describes the importance of reliability, using different test data (typical, erroneous, exaggerated data) and how to formulate a test plan.
Teacher_aesg
KS3 Computing - Cryptography Unit of Work - Lesson Presentations, Worksheets and Assessment

KS3 Computing - Cryptography Unit of Work - Lesson Presentations, Worksheets and Assessment

This is a whole unit of work that this aimed at KS3 - it covers all aspects of Cryptography that the students have absolutely loved doing and this has been uploaded to Google Classroom and made the whole unit very interactive. The work is split into Flight Paths and contains an assessment. All work has stretch and challenge extension tasks too. This is a really enjoyable unit of work for about 6 weeks.
cheekieclaire
Teach yourself the ENTIRE AQA GCSE Computer Science specification

Teach yourself the ENTIRE AQA GCSE Computer Science specification

Looking for a complete solution to help you get to grips with the AQA Computer Science GCSE (9-10)? Need to feel more confident with the subject matter? Not sure how to approach some areas of the curriculum? Want a ready-to-use resource that is ideal for use in the classroom, for homework tasks and self-study? “Nichola thank you. They have saved me a lot of time" Matt - Computing Teacher We have created 7 detailed PDF student workbooks that EXACTLY match the AQA GCE (9-1) Computer Science (8520) specification. Each includes theory, tasks to recap the knowledge and put new skills into practice. they even include the answers! Seperatly these would cost £150 but if you buy them as part of this bundle it only costs £100 saving you a massive £50. “Love these packs - saved me so much work” Laura - Head of Computing Perfect for non-specialist teachers, NQTs or teachers who feel a little unsure about the qualification content and want some ready-to-use tasks to use in class. “Love your revision books. Your resources are such a life saver!” Katie - Non-specialist computing teacher Provided as seven separate PDF documents: • Fundamentals of algorithms • Programming • Fundamentals of data representation • Computer systems • Fundamentals of computer networks • Fundamentals of cyber security • Ethical, legal and environmental impacts of digital technology on wider society, including issues of privacy “Brilliant. These have been fab and my students love them.” Debbie - Computing Teacher These are ideal to use in the classroom, as homework tasks or for independent study as revision for the examinations.
nwilkin
Computer Science: Programming with pseudocode and Python AQA (9-1) GCSE

Computer Science: Programming with pseudocode and Python AQA (9-1) GCSE

Great for AQA (9-1) GCSE Computer Science revision and help with the programming project. This workbook covers the AQA GCSE Computer Science (8520) specification section 3.2 “Programming”. It includes a 116-page PDF document including theory, tasks and includes all the answers. Whenever possible pseudocode is shown alongside the Python code to allow students to compare the similarities and differences between them. Perfect for NQTs, non-specialist teachers or teachers who feel a little unsure about the qualification content and want to improve their subject knowledge. Also ideal as a teaching resource and covers programming in Python from the basics to more advanced techniques including writing to text files, 2D arrays and using subroutines. It also gives help on planning robust programs and testing programs along with the difference between an interpreter, a compiler and an assembler. Table of contents: Data types Variables and constants Iteration Selection Subroutines (procedures and functions Global and local variables Operators One-dimensional arrays Two-dimensional arrays Input and Output Reading from and writing to a text file String handling operations Random number generation Structuring programming Robust and secure programming Data Validation Creating a simple authentication routine Testing your programs Low-level and high-level languages Translators Other workbooks in this series: * Fundamentals of Algorithms GCSE revision student workbook Fundamentals of Data Representation GCSE revision student workbook * Computer Systems GCSE revision student workbook Fundamentals of Computer Networks GCSE revision student workbook Cyber Security GCSE revision student workbook Ethical, legal and environmental impacts
nwilkin
Cosmopolitan Coding - Fun INSET Introduction to Coding

Cosmopolitan Coding - Fun INSET Introduction to Coding

Many teachers were never taught the coding and computer science elements of the new curriculum themselves. This introductory activity helps teachers understand the simplicity of using algorithms as instructions to complete tasks. Teachers will learn: Algorithms and how these are simple instructions Syntax and how this is simply known action in new language Problem solving and debugging code Testing code to see if it works Teachers love this INSET introduction!
EuphoricEd
Testing and Review Sheet

Testing and Review Sheet

A double sided / 2-page document that is used for testing and peer reviewing a product or item. The testing and review is general purpose and can be applied to most items that have been developed or created, including programs / software. Aimed mainly at KS3 students but can also be used with KS4 students and easily adaptable if required.
conxxion
KS3 Computational Thinking Project - Practical Problem Solving (Full Unit of Work)

KS3 Computational Thinking Project - Practical Problem Solving (Full Unit of Work)

**KS3 Computational Thinking Project - Practical Problem Solving (Full Unit of Work) ** This project is designed to either introduce computational thinking skills or to supplement and build on knowledge and skills already acquired. It is suggested that the student booklet is used in conjunction with the associated presentation through all of the lessons. The project has been designed so that is hands-on and practical. The suggested time frame from start to finish of the project is approximately 6-8 lessons, depending on what additional aspects the teacher wishes to introduce during the project. Students are asked to create a stationery holder using everyday objects. The problem has to be approached and solved using computational thinking skills. The project can be approached from a totally ‘unplugged’ pedagogy. No computers required! The resource consists of: a) A student booklet. This can be printed as an A4 or A5 booklet. b) A student booklet containing examplar responses. Also contains extension / homework tasks. c) A PowerPoint presentation for use in lessons to guide students and the teacher. Many of the slides have accompanying ‘speaker notes’ with ideas and suggestions for lessons. The project allows students to be very creative when they move on to the development (making) section of the project. Expect to have lots of fun and engagement!
conxxion
Computing Design/Algorithm pro-formas (PDF and editable Word docx)

Computing Design/Algorithm pro-formas (PDF and editable Word docx)

As described in my “Delve in, for twelve min!” video CPD, these are example pro-formas to give pupils to design their computing projects. These could be Scratch projects; animations, games, quizzes etc. The design process, which is largely missed in computing, forms an essential part of a coding project, and also provides many benefits in terms of AFL. Please use in conjunction with the training video, and also check out the entire “Delve in, for twelve min!” series: https://www.youtube.com/playlist?list=PL3kA-gpaSB2a6Vfdq04rGt5xcKQg8FG8x
PhilWickins
Scratch Exercises for computational thinking

Scratch Exercises for computational thinking

Build students ability to make independent progress and think computationally with a range of programming skills using scratch. Students will learn vital keywords required as fundamental building block for computer science GCSE. Each exercise is independent of each other. Challenges range from simple to difficult and students are encouraged to consider and compare alternative solutions. Solutions for each challenge is provided, easy to follow and understand even for a non specialist teacher. This series of exercises is targeted at KS3 students, although KS4 students will also benefit from it as a revision tool for GCSE computer science. It is strongly advised that these exercises are used after students are taught fundamental skills from algorithms in scratch series.
chris_vidal
Mouse Maze - KS3 Algorithm Starter

Mouse Maze - KS3 Algorithm Starter

Mouse Maze is a fun introduction to decomposition, algorithms and iteration (loops). It works well as an extended starter. Print out the simple maze, or distribute the PowerPoint file to students (the mouse icon can be dragged and rotated). They must list the steps required for Mousey to reach the cheese. Decomposition: breaking the problem into smaller steps (i.e. solving the maze) Algorithms: listing the steps to guide Mousey through the maze Iteration: making the algorithm more efficient by repeating parts of it (challenge / extension activity) The download includes: A full set of teacher’s instructions PowerPoint maze for students which can be used electronically or printed out PowerPoint 6 slides showing the task, solution, sections which are repeated, and a more efficient solution. The final slide has definitions of ‘algorithm’ and ‘decomposition’, plus a note to tell students that they have already achieved both during the lesson. Pupils enjoy the activity and it is a great way to introduce the concepts for the first time. I hope you and your pupils enjoy it :)
MrLangford
Python Programming - I CAN Statements

Python Programming - I CAN Statements

These I Can statements are perfect to guide your students to develop the necessary skills when learning to code/program using Python. The teacher or the student can tick off each I Can statement once they have demonstrated evidence for them. I Can statements fall under the following 4 categories: • Criteria 1: Planning • Criteria 2: Skills Development • Criteria 3: Explanation of Code • Criteria 4: Efficiency of Code
balsamgr8
Computer Science:  Algorithms  AQA (9-1) GCSE revision and exam practice

Computer Science: Algorithms AQA (9-1) GCSE revision and exam practice

Great for AQA (9-1) GCSE Computer Science revision and exam practice. This student revision workbook that covers ALL of the “Fundamentals of Algorithms” syllabus for AQA (9-1) GCSE Computer Science. Includes 82 pages covering the theory and giving lots of practical activities and even includes the answers Ideal as a GCSE revision aid or as a teaching resource. Perfect for NQTs, non-specialist teachers or teachers who feel a little unsure about the qualification content and want to improve their subject knowledge. Table of contents: • What are algorithms? • Decomposition • Abstraction • Basic Pseudocode • Arithmetic Operations • Relational Operators • Boolean Operators • Input and Output • Iteration • Selection • Nesting statements • Flowcharts • Trace Tables • Dealing with Arrays • Subroutines • Dealing with strings • ASCII and Unicode • Linear search • Binary Search • Compare the two search algorithms < • Bubble Sort • Merge Sort • Compare the two sort algorithms Other student workbooks in this series include: Programming Fundamentals of Data Representation GCSE revision student workbook Computer Systems GCSE revision student workbook Computer Networks GCSE revision student workbook Cyber Security GCSE revision student workbook Ethical, legal and environmental impacts GCSE workbook
nwilkin
Computer Science Algos | Pseudos for 2210 | 0478

Computer Science Algos | Pseudos for 2210 | 0478

A set of 8-questions based on real-world scenarios that will make students to understand the situations where they can think and demonstrate their abilities to solve these worksheets. They can also be used to set an assessment. You can have it singly or the whole set. Prepared for CAIE 2210 and IGCSE 0478 Syllabus Components.
suas2016
Algorithms | Pseudocode Part 8 | Worksheet

Algorithms | Pseudocode Part 8 | Worksheet

A set of 8-questions based on real-world scenarios that will make students to understand the situations where they can think and demonstrate their abilities to solve these worksheets. They can also be used to set an assessment. You can have it singly or the whole set.
suas2016
Algorithms | Pseudocode Part 7 | Worksheet

Algorithms | Pseudocode Part 7 | Worksheet

A set of 8-questions based on real-world scenarios that will make students to understand the situations where they can think and demonstrate their abilities to solve these worksheets. They can also be used to set an assessment. You can have it singly or the whole set.
suas2016
Algorithms | Pseudocode Part 6 | Worksheet

Algorithms | Pseudocode Part 6 | Worksheet

A set of 8-questions based on real-world scenarios that will make students to understand the situations where they can think and demonstrate their abilities to solve these worksheets. They can also be used to set an assessment. You can have it singly or the whole set.
suas2016
Algorithms | Pseudocode Part 4 | Worksheet

Algorithms | Pseudocode Part 4 | Worksheet

A set of 8-questions based on real-world scenarios that will make students to understand the situations where they can think and demonstrate their abilities to solve these worksheets. They can also be used to set an assessment. You can have it singly or the whole set.
suas2016