Hi… welcome to this Teacher Resource Kit for Microsoft Excel. It has been designed to introduce any audience to Microsoft Excel from zero knowledge. The core teaching resources are 4 PowerPoint presentations for you to amend as you see fit and adapt for your class. Allocate time for students to try the various elements demonstrated. There are 4 Word documents that accompany each PowerPoint to use as handouts if appropriate, and 2 practice spreadsheets with their accompanying solutions for the last 2 presentations. Also included are a set of 4 practice tasks along with instructions and solutions… A ‘Really Useful Functions’ set of tasks, again with instructions and solutions to some common formulas such as VLOOKUP, CONCATENATE, DAYS and MAXIF and others. Finally there is a ‘Fun Spreadsheets’ set which can be used for extension work as students will have to work out how they were put together and create their own versions. Instructions and 4 challenges are included (Company Order Form, Chess, BattleShips and a Random Card Picker). Enjoy, HackDragn

Welcome… The first question: How long would it take you to organise a lesson plan for a great lesson? Here are 50 of them here covering a wide range of topics in Computing to get you started. Use them to create new lessons or breathe new ideas into your current resources. The Word document you are getting has no protection and has been formatted using Titles, Heading 1, Heading 2, and Body text so you can edit it quickly to match your own style. This opens up the opportunity for people to share without buying it, but I would prefer to give you the option to edit freely and trust you would refer somebody to the resource. Please include this resource as a reference in the final lesson you create in accordance with copyright laws. This set of lesson plans does not rely on a particular technology or presentation style as you will create the final resources. The level of challenge can be adjusted by the amount of help you choose to give. There are suggestions for a range of activities in each lesson and extension tasks along with assessment ideas, but how you implement them is completely up to you. I have included a single lesson plan for ‘Control Structures’ so you can see it in preview as all the plans follow the same structure. You will also find the contents page so you know what topics are included. My intention is that each teacher who uses these plans will come up with unique lessons that suits their own style of delivery and challenges students appropriately. A 104 page DOCX and PDF are provided which will allow you to copy and paste easily. That’s just over 21,000 words with each lesson plan taking up a page and a half. I have taught for many years and developed countless lessons and projects over that time. Many of them required rewriting over time as technology and the curriculum changed. I have used lessons created by others on many occasions, but I often discovered I didn’t have access to the same resources or the level of challenge presented did not suit my students. If you find this resource useful please leave a review to help other teachers discover it too.

Aimed at primary and secondary teachers. You will find this a quick solution to create talking points and fun interaction through the month with very little effort. I use it as a once a week tutor time activity to stimulate discussion and raise awareness. This set of resources highlight some of the international days celebrated around the world during November 2018. This includes links to the official websites, ideas for whole school and individual activities for each of the days highlighted in the PowerPoint notes. Events covered: 5th Bonfire Night (Activity: Make A Firework) 11th Armistice Day (Activity: Four Poems) 16th International Day For Tolerance (Activity: Refugee Quiz) 22nd Thanksgiving Day (Activity: Thanksgiving Day Quiz) 30th St Andrews Day (Activity: St Andrews Day Word Search) You can print out the ‘Events’ PowerPoint to create a display for your classroom. Feel free to modify the resources as required for your school. If you find the resource useful, please leave a review so that others can find it. All the best, HackDragn

Aimed at primary and secondary teachers. You will find this a quick solution to create talking points and fun interaction through the month with very little effort. I use it as a once a week tutor time activity to stimulate discussion and raise awareness. This set of resources highlight some of the international days celebrated around the world during October 2018. This includes links to the official websites, ideas for whole school and individual activities for each of the days highlighted in the PowerPoint notes. Events covered: 4th World Animal (Activity: Extinct or Endangered Quiz) 7th World Smile Day (Activity: Cheesy Jokes Fun Sheet) 16th World Food Day (Activity: National Dishes Quiz) 24th United Nations Day (Activity: Top Contributors Quiz) 31st Halloween (Activity: Word Search) You can print out the ‘Events’ PowerPoint to create a display for your classroom. Feel free to modify the resources as required for your school. If you find the resource useful, please leave a review so that others can find it. All the best, HackDragn

Welcome… Teacher Resources including links to all 7 videos with over 35 minutes of instruction. Each video addresses common mistakes and ensures students think about how to implement each piece of code and apply it to their own work. Completion of the tutorials will enable students to create their own simple games that can be evaluated against the worksheet. - 7 Instruction Videos - 2 Working Example Games (Task and Extension) - 2 Wordsearches - 3 Code Helpsheets - 1 Quiz (15 marks) - 1 Evaluation Scheme

Hi… Learn how to start coding using Actionscript to position your objects on the stage The main asset is the 10 page PDF booklet which is a full colour instruction booklet complete with a mini project to complete using the skills taught. Additionally there is a starter, homework, help files, video demonstration of the mini project solution and a set of teacher notes to enable a custom lesson plan.

Welcome… Learn how to go about setting up background scenes for your games and how to add sound effects and music to your creations. The main asset is the 10 page PDF which is a full colour instruction booklet complete with a mini project to complete using the skills taught. Additionally there is a starter, homework, help files, video demonstration of the mini project solution and a set of teacher notes to enable a custom lesson plan.

Welcome… Learn how to set up Adobe Flash and learn some simple techniques for drawing objects. The main asset is the PDF booklet which is a full colour instruction booklet complete with a mini project to complete using the skills taught. Additionally there is a starter, homework, help files, video demonstration of the mini project solution and a set of teacher notes to enable a custom lesson plan.

Welcome… Learn how to create Arrays to keep track of game objects using Actionscript and start using Loop constructs to control the flow of the program. The main asset is the 10 page PDF which is a full colour instruction booklet complete with a mini project to complete using the skills taught. Additionally there is a starter, homework, help files, video demonstration of the mini project solution and a set of teacher notes to enable a custom lesson plan.

Welcome… Learn about the use of Dynamic Text within user interface design and also how to control button use via Actionscript while taking advantage of the built-in button class. The main asset is the 10 page PDF which is a full colour instruction booklet complete with a mini project to complete using the skills taught. Additionally there is a starter, homework, help files, video demonstration of the mini project solution and a set of teacher notes to enable a custom lesson plan.

Hi… Learn how to delete backgrounds behind objects and copy them onto a different image. Students are shown 3 different ways to delete background pixels with different levels of difficulty. All the instructions are clearly explained and there is a section about the common mistakes that people often make when getting used to Photoshop and how to solve them. The main asset is the PDF booklet which is a full colour instruction booklet complete with a mini project to complete using the skills taught. Additionally there is a starter, homework, assessment spreadsheet, resource files and a set of teacher notes to enable a custom lesson plan.

Hi… Learn how to set up Adobe Photoshop and learn the basics of the workspace along with how to download images and open them with Photoshop. The main asset is the PDF booklet which is a full colour instruction booklet complete with a mini project to complete using the skills taught. Additionally there is a starter, homework, assessment spreadsheet, example images and a set of teacher notes to enable a custom lesson plan.

Hi… Learn how to control object position on the stage using Actionscript. Additionally we will look at the Event system that Flash uses to notify functions when to activate. The main asset is the 10 page PDF booklet which is a full colour instruction booklet complete with a mini project to complete using the skills taught. Additionally there is a starter, homework, help files, video demonstration of the mini project solution and a set of teacher notes to enable a custom lesson plan.

Welcome… Learn how to deal with object collision using Actionscript. You will program event listeners and handlers using a standard methodology which is applicable to many other languages. The main asset is the 10 page PDF which is a full colour instruction booklet complete with a mini project to complete using the skills taught. Additionally there is a starter, homework, help files, video demonstration of the mini project solution and a set of teacher notes to enable a custom lesson plan.

Hi… This lesson is a general guide to enable students to plan projects effectively and how to cope with the inevitable errors that will occur during development. The main asset is the 10 page PDF which is a full colour instruction booklet complete with a mini project to complete using the skills taught. Additionally there is a starter, homework, help files, video demonstration of the mini project solution and a set of teacher notes to enable a custom lesson plan.

Welcome… Here is a Computing assessment framework for KS3 based on UK descriptors. Useful as a suggestion of topic ideas linked to strands across all 3 years. Modify to your own specification as required. Useful for heads of departments or those coordinating an 11-14 Computing curriculum. Linked Strands: Computational Thinking, Programming, Data Representation, Computers, Networking, Information Technology Blooms Taxonomy Links: Knowledge, Comprehension, Application, Analysis, Synthesis, Evaluation

Hi… Combine all the skills taught in the previous tutorials to create a magazine cover. The main asset is the PDF booklet which is a full colour instruction booklet which shows the development process. Additionally there is a planning document, support images, assessment spreadsheet and a set of teacher notes to enable a custom lesson plan.

Welcome… This resource is intended to be an extension to the** Beginning Photoshop series** and gives you an idea of the quality of resources. It assumes some skills will have been previously taught, but you can also have a go if you know the basics. All images and printed materials are supplied in the download which includes the tutorial booklet. As a standalone project this tutorial does not have any accompanying starter, assessment or homework activities and is simply there to support the teaching of the Layer Mask tool. (If you find the resource useful, please leave a review as it helps other teachers find it) HackDragn

Welcome… This is a simple example of some basic python commands that creates a basic Rock, Paper, Scissors game. The explanation lines have been commented out so you can simply copy and paste the whole document into IDLE (or similar) and see it working, or print to use as a help guide. There is plenty of scope to improve the code: Adding scoring, checking for a real choice instead of assuming a default value of ‘Scissors’, Correct the error if the user types ‘Rock’ or ‘Paper’ and lots more that I’m sure you’ll think of. If you enjoy this free resource, please download the other ones and consider purchasing the Dungeon Escape to help support more free resources. (If you find the resource useful, please leave a review as it helps other teachers find it) HackDragn

Welcome… this is a simple example of some basic python commands that creates a code breaking game. The explanation lines have been commented out so you can simply copy and paste the whole document into IDLE (or similar) and see it working, or print to use as a help guide. The task can be extended to include a longer code, different scoring systems, characters instead of numbers, password guesses or allow one player to enter a code that the other has to guess then swap turns… and loads more! (If you find the resource useful, please leave a review as it helps other teachers find it) HackDragn