Transform your BTEC Level 3 Computer Science Unit 15 (Web Design) lessons with our expertly crafted resources! Designed to engage and empower students, these comprehensive teaching materials cover essential coursework topics (HTML, CSS, and JavaScript) to get your students engaged! Lesson 1: Web design An overview of the client-server relationship used by websites Basic design and layout principles Lesson 2: Introduction to HTML The structure of an HTML web page Commonly-used tags Self-paced worksheet for students Lesson 3: CSS CSS syntax External, internal, and in-line CSS Self-paced worksheet for students Lesson 4: Responsive design Explanation, reasons, and principles behind responsive design CSS media queries and examples Self-paced worksheet for students Lesson 5: Introduction to JavaScript Client-side vs server-side scripting Overview of the document object model (DOM) and how JavaScript interacts with it Self-paced worksheet for students Simple to deliver, with all answers to practical work, this is an ideal introduction to inspire and prepare your students for Unit 15. Download today.

A complete KS3 scheme of work, including how computers process and store binary, conversion to denary, binary addition, bitmaps, vector graphics, and sound. Full of activities, discussions, and games especially written for years 7 to 9, and with all answers provided, this is an ideal introduction to key concepts to prepare and inspire your students for Key Stage 4. Lesson 1: Binary to denary conversion + worksheet Lesson 2: Denary to binary conversion + worksheet Lesson 3: Binary addition and terminology + worksheet Lesson 4: Character sets + worksheet Lesson 5: Bits and pixels (bitmap and vector graphics) + worksheet Lesson 6: Bits and sounds + worksheet A fun scheme of work for students, easy-to-deliver for teachers. My students thoroughly enjoyed it, I’m sure yours will too. Download today.

Ten list programming challenges to help students practice their Python and problem-solving skills and prepare for their Computer Science GCSE. Students use their existing programming knowledge to plan each challenge in the booklet before testing it on their computer. This “writing-before-typing” approach helps to develop the crucial skills needed to gain maximum marks in the algorithms section of their exam. The booklet is supplied ready to be printed and stapled to make a 16-page booklet (uses four duplex-printed A4 sheets), and as single pages for individual printing or uploading to your VLE. A full set of example code is provided for teachers, written in a way which is appropriate for GCSE students to fully understand. This is a great way for students to practice their coding skills. Download today.

Ten string manipulation programming challenges to help students practice their Python and problem-solving skills and prepare for their Computer Science GCSE. Students use their existing programming knowledge to plan each challenge in the booklet before testing it on their computer. This “writing-before-typing” approach helps to develop the crucial skills needed to gain maximum marks in the algorithms section of their exam. The booklet is supplied ready to be printed and stapled to make a 16-page booklet (uses four duplex-printed A4 sheets), and as single pages for individual printing or uploading to your VLE. A full set of example code is provided for teachers, written in a way which is appropriate for the GCSE students to fully understand. This is a great way for students to practice their coding skills. Download today.

Ten programming challenges to help students practice their problem-solving and Python skills and prepare for their Computer Science GCSE. Students use their existing programming knowledge to plan each challenge in the booklet before testing it on their computer. This “writing-before-typing” approach helps to develop the crucial skills needed to gain maximum marks in the algorithm section of their exam. The booklet is supplied ready to be printed and stapled to make a 16-page booklet (uses four duplex-printed A4 sheets), and as single pages for individual printing or uploading to your VLE. A full set of example code is provided for teachers, written in a way which is appropriate for the GCSE students to fully understand. This is a great way for students to practice their coding skills. Download today.

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.

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!

Complete scheme of work for KS3 Computer Science theory topics, aligned to OCR R354 Entry Level Certificate in Computer Science. Introduces J277 topics and provides students with a comprehensive overview of the qualification before they choose their subject options. There are a total of 11 lessons which, depending upon term length, leaves time for an end-of-unit test or the R354 exam papers to be taken as required by OCR. Computer Hardware: external peripherals; internal components; input - process - output Operating Systems: the six primary functions of an operating system Applications Software: different categories of software and their purpose, overview of compression and defragmentation Storage: primary and secondary storage types Data representation: how computers use binary to store text, images, and audio Binary: Converting between binary and denary numbers, and binary addition Boolean Logic: introduction to AND, OR, and NOT gates; creating simple truth tables Moral, Ethical, and Legal Considerations: concerns about the moral, ethical, and legal impact of computers Computational Thinking: decomposition, abstraction, pattern recognition, and algorithms; defining success criteria; and creating a test plan Flowcharts: creating simple flowcharts Programming techniques: sequence, selection, and iteration; code maintainability; and variables Lessons consist of activities including: exam-style questions, discussions, research, and online tasks. Get your students ready for Key Stage 4 - download today.

Create quiz questions and answers in a spreadsheet, export to a CSV file, and write a Python program to use the CSV files for a multiple-choice quiz. Printable student instructions; stretch / challenge tasks; and example files for teachers, this makes a great revision or end-of-unit activity! Students can re-visit the CSV file and add more questions as the year progresses. Teaches: CSV (comma-separated value) files Python file-handling; two-dimensional lists; variables; iteration Stretch / challenge activities: Add a scoring system Accept upper and lower case inputs Fix a ‘bug’ where the same question may appear multiple times Add a graphic interface Files included: Printable PDF worksheet (copy and paste is restricted so students must type their code Sample CSV file with six questions and answers Python file of the completed activity Python file containing stretch / challenge solutions (except the GUI) This is a great one or two lesson activity – ideal for a spare lesson at the end of term. Download for free.

** 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.

Complete scheme of work for J277 OCR Computer Science 2.4 Boolean Logic, including PowerPoint for each lesson, homework sheet, worksheets, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following lesson PowerPoints and resources: 2.4.1a Logic Diagram and Truth Tables 2.4.1b Logic Circuits 2.4.1c Solving Problems 1 x Homework sheet plus answers End-of-module test paper plus answers Save yourself hours of planning. Download now.

Complete scheme of work for J277 OCR Computer Science 2.5 Programming Languages and Integrated Delvelopment Environments (IDEs), including PowerPoint for each lesson, homework sheet, worksheets, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. There are two versions of lesson 2.5.2 – one for students using IDLE and an alternative for those using Thonny. Includes the following lesson PowerPoints and resources: 2.5.1a High and Low-level languages 2.5.1b Translators, Compilers, and Interpreters 2.5.2 Integrated Development Environments (IDE) - IDLE 2.5.2 Integrated Development Environments (IDE) - Thonny 1 x Homework sheet plus answers End-of-module test paper plus answers Save yourself hours of planning. Download now.

Introduce your students to databases and SQL / SQLite and build their knowledge through to a mini-project which uses their existing knowledge of Python and Tkinter. 1.3.2a - Database Concepts Flat file databases Entity identifiers Indexing Primary, Secondary, and Foreign keys Relational databases 1.3.2b - Database Normalisation Relational DB design Relationships and ERD Referential integrity Linking DB tables / Link tables Normalisation - reasons and 1NF, 2NF, 3NF 1.3.2c Transaction Processing Capturing Information ACID Record locking Redundancy 1.3.2d SQL SELECT FROM WHERE Conditions Sorting Dot notation JOIN Data types ALTER / UPDATE / DELETE / DROP SQL Worksheets Customer database: Import provided flat-file database and query it James Bond movies: Import provided flat-file database and query it. Note: this resource is available separately from my TES store High Scores: Import provided relational database and query it Marvel Cinematic Universe: examine provided SQL to create a new database Mini-project: plan and create a relational database and use Python and Tkinter to build an interface. Note: this project expects students to have a basic knowledge of Tkinter and independently research how to implement SQLite 3 in Python. No support files are provided for this activity.

Complete scheme of work for J277 OCR Computer Science 2.3 Producing Robust Programs, including PowerPoint for each lesson, homework sheets, worksheets, Python example files, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following lesson PowerPoints and resources: 2.3.1a Defensive Design (plus Python files) 2.3.1b Input Validation (plus Python files) 2.3.1c Maintainability (plus Python files) 2.3.2a Testing 2.3.2b Test Data 2.3.2c Refining Algorithms (plus Python files) 2 x Homework worksheets plus answers End-of-module test paper plus answers Save yourself hours of planning by downloading now.

Complete scheme of work for J277 OCR Computer Science 2.1 Computational Thinking, including PowerPoint for each lesson, homework sheets, worksheets, unplugged activities, Python example files, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following lesson PowerPoints and resources: Scheme of Work document 2.2.1a Variables, Constants, Operators, Inputs, Outputs, Assignments 2.2.1b Sequence, Selection, Iteration (inc Python files) - Updated October 2022 to include Python Switch (match) Statements 2.2.1c Arithmetic and Arithmetic Operators 2.2.2 Data Types (inc worksheet and Python solutions) 2.2.3a String Manipulation (inc Python solutions) 2.2.3b File Handling (inc Python solutions) 2.2.3c Databases and SQL (inc worksheet, answers, and Python SQLite 3 database file) 2.2.3d Arrays 2.2.3e Subprograms 3 x Homework worksheets and answers 1 x End-of-topic test Includes dozens of Python demonstration files and a Python-based SQLite 3 database for students to test their SQL commands. Save yourself hours of planning. Download now.

Introduce Python 3 to your students using Turtle and Edublocks 4 (a free online drag-and-drop Python editor). Students program Turtle to draw a Christmas card. Their code can be downloaded and opened using IDLE or any other Python IDE. Includes: PowerPoint to get students started Printable worksheet with step-by-step instructions to complete the project and challenge activities Completed file which can be imported into Edublocks Python files which can be opened using IDLE Teachers’ instruction sheet This is an ideal end-of-term standalone lesson ready for Christmas. I hope you and your students enjoy it.

Complete scheme of work for J277 OCR Computer Science 2.1 Computational Thinking, including PowerPoint for each lesson, homework sheets, worksheets, unplugged activities, Python example files, end-of-topic exam, and mark sheets. Designed for my mixed-ability group with lots of simple explanations; large clear and bright diagrams; chunked lessons; and stretch and activity tasks for higher-achieving students. Includes the following lesson PowerPoints and resources: Scheme of Work document 2.1.1a Abstraction 2.1.1b Decomposition, including “Decomposing Mickey Mouse” worksheet 2.1.1c Algorithmic Thinking, including “River Crossing Challenge” worksheet 2.1.2a Inputs, Processes, Outputs, including “Problem Solver Cheat Sheet” and Python code example file 2.1.2b Structure Diagrams, including Python files 2.1.2c Flowcharts 2.1.2c Pseudocode, including worksheet, answers, and Python files 2.1.2d Common Errors, including worksheet, answers, and Python files 2.1.2e Trace Tables, including worksheet, answers, and Python files 2.1.3a Linear Searches, including example PowerPoint 2.1.3b Binary Searches, including example PowerPoint 2.1.4a Bubble Sort, including Star Wars Bubble Sort PowerPoint 2.1.4b Merge Sort, including worksheet and example PowerPoint 2.1.4c Insertion Sort, including example PowerPoint 4 x homework sheets, with answers 1 x end-of-unit test, with mark sheet My students especially enjoyed the unplugged searching and sorting algorithms! Save yourself hours of planning by downloading now.

** 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.