Welcome… Teach the basics of Microsoft Excel to beginners. Students will learn the difference between workbooks and worksheets, cell referencing, simple calculations, auto complete, formatting and functions (SUM, AVERAGE, MAX and MIN). There is a starter activity and 3 tasks to complete in a student spreadsheet which can be distributed. There are teacher notes in the comments for each slide, along with key points for demonstration and challenges for students if they complete the work. As always, if you enjoyed the resource please leave a review so that others can find it. 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.

Hi… This is a simple example of some python commands that creates the start of a random number guessing 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. Extension work could include adding a way to use the currently unused ‘playerScore’ variable, checking if the player gets it in 1 guess and gives a special message and lots more. (If you find the resource useful, please leave a review as it helps other teachers find it) HackDragn

Welcome… This is a preview of the first 3 YouTube tutorials to create a game using Scratch. The full 7 tutorials and teaching resources are also available.

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.

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