A project based scheme of work and lessons which has pupils investigating and researching types of videogames before designing and creating their own game concept which they can pitch to groups. The tasks include Challenge prompts and can be easily scaled up or down in terms of complexity for different year groups. Suitable for a fun and engaging KS3 or year 9 scheme of work for ICT or computing and digital media. This is excellent preparation for digital media based courses such as the OCR Creative iMedia and units such as R091 : Designing a Game Concept Pupils will need access to PowerPoint or Google Slides to complete the activities

A look at some more basic functions in Excel All: Will be able to identify the uses of basic functions in Excel (Level 4) Most: Will be able to fix basic problems in Excel (Level 5) Some: Will be able to fix more advanced problems in Excel (Level 5a) Used previously for KS3 and KS4 ICT. Can be adapted to fit any scheme of work involving spreadsheets.

A bundle of resources to teach all of the skills required to pass ICDL Microsoft Word. Also includes an example test with files and lots of revision activities for your quick finishers.

A bundle of resources to teach all of the skills required to pass ICDL Microsoft Excel. or to teach basic spreadsheet skills. Also includes an example test with files.

Complete unit of work and resources Suitable for KS3/KS4 Covers a range of Excel skills such as Sort/filter Renaming/arranging worksheets Formatting cells Has videos and a task for each skill

A look at how to create tables and charts in Excel. All: Present information as a table(Level 4c) Most: Present information as a chart (Level 4b/4a) Some: Justify choices of chart (Level 5c) Used previously for KS3 and KS4 ICT. Can be adapted to fit any scheme of work involving spreadsheets.

A selection of whole lessons, videos links, discussions, activities and whole lessons to teach E-safety for KS3. Can be adapted to fit any scheme of work for ICT.

An ideal first lesson to introduce the subject or topic surrounding computing, computer science or computational thinking. -Computational Thinking -Introduction to Flowchart design Complete with information slides, activities, starter and plenary. Suitable for a 1 hour lesson.

A project based scheme of work which has pupils investigating and researching types of digital graphics before designing and creating their own. The theme is horror films which has proven to be very popular with our pupils and can be easily scaled up or down in terms of complexity for different year groups. Suitable for a fun and engaging KS3 or year 9 scheme of work for ICT or computing and digital media. This is excellent preparation for digital media based courses such as the OCR Creative iMedia and units such as R082 : Creating Digital Graphics. Pupils will need access to a digital graphics editing software such as Photoshop or an onlinefree version.

Allow your students to be able to recommend a device to a particular person based on requirements. Provides scenarios that students have to recommend for and justify their decisions. Covers smartphones, tablets and computers

An introduction to using spreadsheets in Excel. Objectives covered: All: Will be able to identify the uses of basic functions in Excel Most: Will be able to use basic functions in Excel (+ - / *) Some: Will be able to use more advanced functions in Excel (SUM, MIN, MAX, AVERAGE) Includes video walk through for the whole lesson so students can complete completely independently. Suitable for both KS3 and KS4 ICT.

A fun lesson to teach these advanced Excel skills. Comes with video tutorials so students can complete independently. Previously used for ECDL, KS3 and KS4 ICT.

Whole lesson covering important hardware inside the computer and peripherals. Includes video resource (from Youtube), and two worksheets as well as instructional Powerpoint. Useful for independent learning, or video can be shown to whole group and discussions to follow as a whole class. Computing, Computer Science, ICT

A worksheet to help students learn about finding and searching for information online safely

A lesson and a worksheet to help students learn about finding information online, researching and using search engines.

A bundle of sample assessments to teach all of the skills required to pass ICDL Improving Productivity.