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.

Welcome… Note that the illustrations are from Dreamweaver CS6. Creative Cloud is very similar, but will not be exactly the same. This is a set of 3 booklets, an exemplar analysis and a complete website example, that will show students how to create a multipage website. It is loosely based on the Cambridge Nationals iMedia R085 course, although you would need to include a testing table to satisfy those requirements for example. Instead of focusing on a particular examination board, these tutorials will walk students through the usual tasks that often arise. You can obviously teach additional skills or miss out parts that are not relevant to your course. The software illustrated is Dreamweaver CS6, but will also work very similarly in Creative Cloud. Contents: Booklet 1 - Analysis (5 Pages): This takes students through the process of analysing a brief. It looks at Client Requirements, Target Audience, Mind Maps, Mood Boards, Templates and House Styles. There are 5 tasks totalling around 100 minutes of learning exercises and an exemplar document is also included. Booklet 2 - Template (17 Pages): Here students will create a template page following a simple table layout (I find this easier than DIV’s for my students). It shows how to setup the file structure, set up a table, add a banner, rollover images for the main menu and attaching a CSS stylesheet. Booklet 3 - Content (12 Pages): This final section shows how to create the multiple pages from the template and then add content such as images, text, hyperlinks, email links, and forms. The website is included in a ZIP file so you can provide students with as much material and support as you want, or get them to create their own content. If you enjoy the tutorial, please leave a review to help others find it too :) 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.

Hi… This resource is specifically based against the IGCSE Computer Science syllabus, but is suitable for any Data Storage module. It includes some knowledge tests at the beginning and leads on to creating 5 groups to work on a presentation about a different element of Data Storage. The group worksheets can be handed out or sent electronically and each has a series of keywords to prompt research. Each group is challenged with answering one Big Question and explaining it to the class at the end of the lesson. If you find the resource useful please leave a review so that others can find it. HackDragn

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 an Excel spreadsheet to track assessment time over multiple lessons. Enter the start and end time for each lesson and mark if each student is present. The total time students have used is tracked directly next to their name. Track up to 32 students over 20 lessons, or extend it to suit your needs. (If you find the resource useful, please leave a review as it helps other teachers find it) HackDragn