OCR Model Sample Task Solution NEA : Mr Leeman

OCR Model Sample Task Solution NEA : Mr Leeman

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.
msmarwaha
Introduction to Python (KS3 +KS4 Friendly)

Introduction to Python (KS3 +KS4 Friendly)

An introduction to python programming aimed at students who may not have come across it before. The SOW includes: Printing Commenting Storing and using Variables Data Casting If Statements Elif Statements Using Lists Using LIbraries Turtle Using Random
msmarwaha
Computer Science Unit 1.1-1.8 Revision Sheets / Practice Questions

Computer Science Unit 1.1-1.8 Revision Sheets / Practice Questions

Here you will find easy to follow revision sheets which will help your students to recap the topics: 1.1 Systems Architecture 1.2 Memory 1.3 Storage 1.4 Wired and Wireless Networks 1.5 Network Topologies Protocols and Layers 1.6 Systems Security 1.7 System Software 1.8 Ethical Legal Cultural and Environmental Concerns 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!
msmarwaha
Introduction to Logic Gates (KS3 + 4 Friendly)

Introduction to Logic Gates (KS3 + 4 Friendly)

An introduction to logic gates which i used at KS3 and KS4. Easy to understand and straight forward. Included are: Teachers powerpoint (walks the students through the gates with examples) Progress log (Track students progress) Self marking spreadsheet that includes tasks, extension and a helpsheet
msmarwaha
Unit 18 / 19 / 20 Cambridge Technicals Level 3 *Triple Pack*

Unit 18 / 19 / 20 Cambridge Technicals Level 3 *Triple Pack*

**Unit 18 / 19 / 20 Cambridge Technicals (2016) Level 3 Triple Pack ** This rescource will provide you with the relevant resoucres to complete the following units on the Cambridge Technicals units: Unit 18 - Hardware Unit 19 - Software Unit 20 - Technical Support Combine these 3 units with the examination units (1 & 2) to achieve 1 A Level for your students! Each unit is available on their own in my shop, the 3 together offered at over 40% off!
msmarwaha
Computer Science Unit 2.1-2.6 Revision Sheets / Practice Questions

Computer Science Unit 2.1-2.6 Revision Sheets / Practice Questions

Here you will find easy to follow revision sheets which will help your students to recap the topics: -2.1 Algorithms -2.2 Programming Techniques -2.3 Robust Programs -2.4 Computational Logic -2.5 Translators & Facilities of Languages 2.6 Data Representation 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!
msmarwaha
Unit 19 - Software- Full Unit, Cambridge Technicals Level 3 (2016)

Unit 19 - Software- Full Unit, Cambridge Technicals Level 3 (2016)

Here you will find the resources to complete Unit 19 in the level 3 Cambridge Technicals. All of the Learning Objectives have been covered and the lessons contain notes from the chief moderator from OCR. The assignment which has been used has also been checked using the Assignment Checking service from OCR. (Service is £30 per assignment) Enjoy!
msmarwaha
Binary Addition

Binary Addition

A straight forward lesson which explains the ways in which you perform binary addition, the lesson outlines the rules for binary addition and also has example questions. Answers are included on the final slide.
msmarwaha
Unit 18 - Hardware - Full Unit, Cambridge Technicals Level 3 (2016)

Unit 18 - Hardware - Full Unit, Cambridge Technicals Level 3 (2016)

Here you will find the resources to complete unit 18 in the level 3 Cambridge Technicals. All of the Learning Objectives have been covered and the lessons contain notes from the chief moderator from OCR. Also attached is a sample of how you could complete the practical element to the assignment, although you can choose another method! The assignment which has been used has also been checked using the Assignment Checking service from OCR. (Service is £30 per assignment) Enjoy!
msmarwaha
Computer Science Unit 1.1-1.8 Revision Sheets / Practice Questions

Computer Science Unit 1.1-1.8 Revision Sheets / Practice Questions

Here you will find easy to follow revision sheets which will help your students to recap the topics: 1.1 Systems Architecture 1.2 Memory 1.3 Storage 1.4 Wired and Wireless Networks 1.5 Network Topologies Protocols and Layers 1.6 Systems Security 1.7 System Software 1.8 Ethical Legal Cultural and Environmental Concerns 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!
msmarwaha
3. Creating a Login System  in SQLite3 via Python (Great for NEA / Controlled Assessment practice!)

3. Creating a Login System in SQLite3 via Python (Great for NEA / Controlled Assessment practice!)

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
msmarwaha
1. Writing To a Database using SQLite3 in Python (Great for NEA / Controlled Assessment practice!)

1. Writing To a Database using SQLite3 in Python (Great for NEA / Controlled Assessment practice!)

Attached is a lesson on how to write to a database using SQLite3 in Python. Included are the following: 1. PPT explaining how to write to 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
msmarwaha
2. Querying a Database File via SQLite3 in Python (Great for NEA / Controlled Assessment practice!)

2. Querying a Database File via SQLite3 in Python (Great for NEA / Controlled Assessment practice!)

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
msmarwaha
SQLite 3 in Python Pack! NEA Controlled Assessment Preparation

SQLite 3 in Python Pack! NEA Controlled Assessment Preparation

Here is the bundle available to prep students for their GCSE and also teach them SQLite3. Easy to follow lessons will help you to: 1. Use SQLite 3 2. Write To a Database 3. Query a Database (Using one + more criteria) 4. Create a Login System (multiple ways) 5. Make use of Functions (MAX, MIN & AVG) Also included is a free guide on using DB Browser for SQLite3 (Freeware which i use with students) If you want an individual lesson from this pack check out my shop!
msmarwaha
4. MAX, MIN, AVG functions in SQLite3 in Python (Great for NEA / Controlled Assessment practice!)

4. MAX, MIN, AVG functions in SQLite3 in Python (Great for NEA / Controlled Assessment practice!)

Attached is a lesson on how to use MAX, MIN & AVG in SQLite3 in Python. Included are the following: 1. PPT explaining how to use the functions 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
msmarwaha
OCR Model Sample Task Solution NEA : Mr Leeman

OCR Model Sample Task Solution NEA : Mr Leeman

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.
msmarwaha
(Full Year) KS3 Scheme of work

(Full Year) KS3 Scheme of work

In this pack is a scheme of work which can be used in KS3, why plan when you can have your whole year done for you! Included are the following topics: -Digital Safety -Sequencing & Microbits -Hardware & Software -3d Printing in Sketchup Pro -Python Programming Topics in the pack can also be bought as separates if you prefer from my shop.
msmarwaha
Introduction to Python (KS3 +KS4 Friendly)

Introduction to Python (KS3 +KS4 Friendly)

An introduction to python programming aimed at students who may not have come across it before. The SOW includes: Printing Commenting Storing and using Variables Data Casting If Statements Elif Statements Using Lists Using LIbraries Turtle Using Random
msmarwaha
4. While Loops + Random using Turtle (KS3 + KS4 Friendly)

4. While Loops + Random using Turtle (KS3 + KS4 Friendly)

The fourth lesson in my introduction to python takes the students through the use of while loops and also random. I have used turtle to show the students this as it uses visual graphics and the students tend to enjoy using this. Skills Covered Variables Loops While Loops Libraries Random Turtle
msmarwaha
3. Python, Using Lists (KS3 + KS4 Friendly)

3. Python, Using Lists (KS3 + KS4 Friendly)

This lesson guides the students through Python Lists, it has challenges to test students knowledge and build upon their previous lessons (also available in shop). This will develop their skills in using lists and combining data together.
msmarwaha