Attached is the solution i made to the sample task released by OCR, it has been created using Python (version 3) with the use of the SQLite3 library. An SQL database was created called students to store the information needed. The program allows the user to log in and do the following: 1. Enter and store the students details 2. Recall a students details (need ID number) 3. Show all students 4. Show students by gender 5. Show students by form 6. Delete a Student 7. Log out the data in the database was created using a random name/street generator.

The second lesson in my Python scheme of work, this is aimed at building upon the introduction lesson and taking the students through the following: - Data Casting -If statements -Elif Statements Students will be challenged to complete some tasks alongside these, easy to follow and all set up for you to use! Reduce your planning time!

Attached is a lesson on how to create a login system using a database of users in SQLite3 in Python. Included are the following: 1. PPT explaining how to create a login system (2 ways) 2. Example programs (in zip file) 3.Example Database (in zip file, access through a program such as DB Browser (Freeware)) if you need free software to run and connect to sql databases please download the DB Broswer for FREE and also check out a little guide i made to the software, also FREE: https://www.tes.com/teaching-resource/sqlite-program-introduction-db-browser-11751031

Attached is a lesson on how to query a database using SQLite3 in Python. Included are the following: 1. PPT explaining how to run a query in a database 2. Example programs (in zip file) 3.Example Database (in zip file, access through a program such as DB Browser (Freeware)) if you need free software to run and connect to sql databases please download the DB Broswer for FREE and also check out a little guide i made to the software, also FREE: https://www.tes.com/teaching-resource/sqlite-program-introduction-db-browser-11751031

Attached is a lesson on how to read and write to a csv file in Python. Included are the following: 1. PPT explaining how to write and read from a csv file 2. Example programs (in zip file)

Attached is a lesson on how to create a login system using a csv file in Python. Included are the following: 1. PPT explaining how to create a login system 2. Example programs (in zip file)

Here you will find easy to follow revision sheets which will help your students to recap the topics in 2.4 Making Financial Decisions, these include: 2.4.1 Business Calculations 2.4.2. Understanding Business Performance Attached at the end of the notes are revision questions which the students should be able to answer once they have studied the topic. Enjoy! Also check out the other revision sheets for the topics within this GCSE in my shop!

Here you will find easy to follow revision sheets which will help your students to recap the topics in 2.5 Making Human Resource Decisions, these include: 2.5.1 Organisational Structures 2.5.2 Effective Recruitment 2.5.3. Effective Training & Development 2.5.4. Motivation Attached at the end of the notes are revision questions which the students should be able to answer once they have studied the topic. Enjoy! Also check out the other revision sheets for the topics within this GCSE in my shop!

Here you will find easy to follow revision sheets which will help your students to recap the topic: 1.8 Ethical, legal, cultural and environmental concerns which includes: how to investigate and discuss Computer Science technologies while considering: ethical issues legal issues cultural issues environmental issues. privacy issues. how key stakeholders are affected by technologies environmental impact of Computer Science cultural implications of Computer Science open source vs proprietary software legislation relevant to Computer Science: The Data Protection Act 1998 Computer Misuse Act 1990 Copyright Designs and Patents Act 1988 Creative Commons Licensing Freedom of Information Act 2000 The revision sheets include exam questions at the end of each topic to help the students recap their revision and apply it to a question. Check out my shop to save on buying multiple sheets!! Enjoy!

Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.6 Data Representation Units bit, nibble, byte, kilobyte, megabyte, gigabyte, terabyte, petabyte how data needs to be converted into a binary format to be processed by a computer. Numbers how to convert positive denary whole numbers (0–255) into 8 bit binary numbers and vice versa how to add two 8 bit binary integers and explain overflow errors which may occur binary shifts how to convert positive denary whole numbers (0–255) into 2 digit hexadecimal numbers and vice versa how to convert from binary to hexadecimal equivalents and vice versa check digits. Characters the use of binary codes to represent characters the term ‘character-set’ the relationship between the number of bits per character in a character set and the number of characters which can be represented (for example ASCII, extended ASCII and Unicode). Images how an image is represented as a series of pixels represented in binary metadata included in the file the effect of colour depth and resolution on the size of an image file. Sound how sound can be sampled and stored in digital form how sampling intervals and other factors affect the size of a sound file and the quality of its playback: sample size bit rate sampling frequency. Compression need for compression types of compression: lossy lossless. The revision sheets include exam questions at the end of each topic to help the students recap their revision and apply it to a question. Check out my shop to save on buying multiple sheets!! Enjoy!

Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.3 Producing Robust Programs defensive design considerations: input sanitisation/validation planning for contingencies anticipating misuse authentication maintainability: comments indentation the purpose of testing types of testing: iterative final/terminal how to identify syntax and logic errors selecting and using suitable test data. The revision sheets include exam questions at the end of each topic to help the students recap their revision and apply it to a question. Check out my shop to save on buying multiple sheets!! Enjoy!

Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.5 Translators and facilities of languages characteristics and purpose of different levels of programming language, including low level languages the purpose of translators the characteristics of an assembler, a compiler and an interpreter common tools and facilities available in an integrated development environment (IDE): editors error diagnostics run-time environment translators. The revision sheets include exam questions at the end of each topic to help the students recap their revision and apply it to a question. Check out my shop to save on buying multiple sheets!! Enjoy!

Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.4 Computational logic: why data is represented in computer systems in binary form simple logic diagrams using the operations AND, OR and NOT truth tables combining Boolean operators using AND, OR and NOT to two levels applying logical operators in appropriate truth tables to solve problems applying computing-related mathematics: – / Exponentiation (^) MOD DIV The revision sheets include exam questions at the end of each topic to help the students recap their revision and apply it to a question. Check out my shop to save on buying multiple sheets!! Enjoy!

NEW J277 SPEC Here you will find easy to follow revision sheets which will help your students to recap the topic: 1.6 Ethical, Legal, Cultural and Environmental Impacts of Digital Technology ¨ Impacts of digital technology on wider society including: o Ethical issues o Legal issues o Cultural issues o Environmental issues o Privacy issues ¨ Legislation relevant to Computer Science: o The Data Protection Act 2018 o Computer Misuse Act 1990 o Copyright Designs and Patents Act 1988 o Software licences (i.e. open source and proprietary)

NEW J277 SPECIFICATION: Here you will find easy to follow revision sheets which will help your students to recap the topic: 2.1 – Algorithms Principles of computational thinking: o Abstraction o Decomposition o Algorithmic thinking Identify the inputs, processes, and outputs for a problem ¨ Structure diagrams ¨ Create, interpret, correct, complete, and refine algorithms using: o Pseudocode o Flowcharts o Reference language/high-level programming language ¨ Identify common errors ¨ Trace tables Standard searching algorithms: o Binary search o Linear search ¨ Standard sorting algorithms: o Bubble sort o Merge sort o Insertion sort The revision sheets include exam questions at the end of each topic to help the students recap their revision and apply it to a question. Enjoy!