Complete scheme of work for J808 Cambridge National Level 1/2 in Information Technologies. This is a full set of lessons, homeworks, and an end-of-module test. All lessons are fully explained and ready-to-teach. 1.1 Project Life Cycle Lesson 1.2 Iterative Reviews Lesson 1.3 Inputs and Outputs Lesson and Worksheet 1.4 Initial Project Considerations Lesson 1.5.1-2 Planning Tools Lesson 1.5.2-3 Planning Tools and software Lesson 2 x Homework sheets with marking scheme 1 x End-of-module test question paper with marking scheme 1 x Module self-assessment learning checklist for students All lessons are tried-and-tested. Save yourself hours of work by downloading now.

Use SQL to return results of queries on the supplied James Bond movie database (e.g. What is the average IMDB rating of movies directed by John Glen?) The worksheet includes instructions for creating a new database, uploading the SQL file to it, then using SQL to obtain the answers to questions. Students can copy and paste their queries and results into the worksheet, then save or print for marking. SQL commands used: describe, select, count, from, where, group by, like, and, or; and wildcards. The database is a single-table flat database. This is an intermediate-level task, suitable for students who are already familiar with SQL commands and structure. It also assumes that users will be using phpMyAdmin and they have sufficient privileges to create and edit databases. My Year 12 and 13 Computer Science A-Level students enjoyed the lesson, which took around 1 hour for most to complete. Included: SQL file, student worksheet, teacher’s answer sheet.

** For use with the end of module tests in my J277 OCR 2.1 - 2.5 SoW Bundle ** If you do not have the bundle or any of the individual units of work, please download them from my TES Shop. Save hours of analysing test data with this complete question-by-question analysis pack. Easy to set up Enter student marks into the spreadsheet Percentages and approximate grades are automatically calculated Colour-coded columns allow at-a-glance analysis of which questions students performed well on A Word mail-merge generates a “What went well” and “Even better if” list for each student which can then be used to provide individual feedback and help to fill knowledge gaps Personalised reports can be printed or emailed directly to students Step-by-step instructions included.

** For use with the end of module tests in my J277 OCR 1.1 - 1.6 SoW Bundle ** If you do not have the bundle, or any of the individual units of work, please download it from my TES Shop. Save hours of analysing test data with this complete question-by-question analysis pack. Easy to set up Enter student marks into the spreadsheet Percentages and approximate grade are automatically calculated Colour-coded columns allow at-a-glance analysis of which questions students performed well on A Word mail-merge generates a “What went well” and “Even better if” list for each student which can then be used to provide individual feedback and help to fill knowledge gaps Personalised reports can be printed or emailed directly to students Step-by-step instructions included.

Challenge your higher-ability students to complete these difficult Python programming tasks. Example solutions are included, written using skills which students will be familiar with and no need to install any additional libraries. Music Quiz Create and store music titles and artists in a CSV file, choose one at random, remove most of the characters, and ask the player to enter the correct title and artist. Play Your Cards Right Based on the classic game show. A card is randomly chosen and the player must guess whether the next card has a higher or lower value. You get nothing for a pair! Word Clock Output the current time as a sentence. E.g., 22:53 is “Seven minutes to eleven”. Binary Converter Ask the user to enter a denary integer and convert it to binary. Book Maker Download a free book and write a program which counts the number of characters; calculates the number of words and pages; adds page numbers; and a search function. And you get a free classic book!

Introduce your students to HTML using a drag and drop interface. Designed to be intuitive and colourful, students drag Lego-like ‘tag’ blocks onto the board to build up their page. Works on both mouse-based computers and touch-screen tablets. This resource includes “Tutorial 1” and “Teacher’s Notes”, both as printable PDFs. Tutorial 1 is an introduction to the Weggo! interface and a quick “Hello world” lesson. The Teacher’s Notes provide an overview of Weggo’s usage, system compatibility, limitations and pointers for each of the five tutorials. Please be aware that Weggo! is ‘beta’ software, and some bugs will be present. Weggo! is a free-to-use website with no adverts or logins. I hope you and your students enjoy using Weggo!

Add links to other web pages using the <a> tag. Links can be added to headline, paragraph, and list item tags. Please be aware that Weggo! is ‘beta’ software, and some bugs will be present. Weggo! is a free-to-use website with no adverts or logins. I hope you and your students enjoy using Weggo!

Use the IMG tag to add images to your Weggo! HTML page. Images can be hot linked from other online resources, or a small amount of clipart images are supplied. Support for ALT text is included to promote accessibility and search engine-friendly authoring. Please be aware that Weggo! is ‘beta’ software, and some bugs will be present. Weggo! is a free-to-use website with no adverts or logins. I hope you and your students enjoy using Weggo!

The second tutorial for the Weggo! HTML Editor introduces more text tags such as headlines and paragraphs, which students use to begin adding more content to their web page. Please be aware that Weggo! is ‘beta’ software, and some bugs will be present. Weggo! is a free-to-use website with no adverts or logins. I hope you and your students enjoy using Weggo!

Combining Careers Week and AQA GCSE Business Studies Unit 4 revision, this double-lesson gives students the opportunity to apply their learning to a real-world scenario. Mr Thompson is a highly qualified but disillusioned Physics teacher. Students will research alternative careers based on his interests and qualifications. They will also apply their knowledge of Maslow’s Hierarchy of Needs, financial and non-financial motivators, recruitment, and training to recommend ways to reinvigorate Mr Thompson’s enthusiasm and help the school to retain him. The PowerPoint also includes exam-style questions and answers, and the lesson plan includes suggestions to begin student discussion. This unit is ideal for students who have completed Unit 4 (Human Resources) and ties-in well with Careers Week. Students will need access to the internet to research careers. My students thoroughly enjoyed this lesson. I hope yours will too.

Design and code a Python game with 10 step-by-step worksheets. Use Pygame and Pygame Zero to create a cheese-collecting, cat-avoiding, fast-paced game! Introduces students to: Python graphics Sprites Tile maps Keyboard events Gameplay ideas This is an ideal project for extra-curricular clubs. All images, sample code, and teacher support information is included. I hope your students have as much fun making this game as mine did.