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
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
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
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
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
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
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
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
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
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
2. Data Casting & IF Statements (KS3 + KS4 Friendly)

2. Data Casting & IF Statements (KS3 + KS4 Friendly)

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

1. Introduction to Python (KS3 + KS4 Friendly)

An introduction to Python Programming which takes the students through the initial use of: -Printing -Variables -Comments It also explains the use of Syntax and the ways in which students should structure their work. Has been tried and tested many a time! Look out for more lessons on Python soon! Including full SOWs
msmarwaha
*** KS3 Full Unit *** 3d Printing & Google Sketchup Pro

*** KS3 Full Unit *** 3d Printing & Google Sketchup Pro

In the pack you will find a full SOW of lessons for google sketchup. Tried and tested at KS3, these lessons introduce students to 3d printing the developing designs through google sketchup! All lessons complete with tasks, save yourself some hassle!
msmarwaha
3. Design Work in Google Sketchup

3. Design Work in Google Sketchup

As part of the 3d printing module students are tasked with designing and implementing a product, this takes the students through that process and introduces them to the importance of design work They are then tasked with producing a design which is to be implemented ***The whole unit is also available in my shop! Grab a bargain! and decrease your planning time!***
msmarwaha
2. Google Sketchup Skills Development

2. Google Sketchup Skills Development

This is the second lesson on Google Sketchup, it introduces the students to new skills that can be used as part of their designing process. Also included is a worksheet to assist in using the previous tools. ***The whole unit is also available in my shop! Grab a bargain! and decrease your planning time!***
msmarwaha
5. Google Sketchup Review and Assessment

5. Google Sketchup Review and Assessment

As part of the 3d printing module students are asked to showcase their work and assess their progress, they also gain feedback from their peers as part of the process. This lesson is designed to completed the unit and allow the students to improve upon their designs using their own assessments and peers thoughts. ***The whole unit is also available in my shop! Grab a bargain! and decrease your planning time!***
msmarwaha
4. Google Sketchup Developing A Product

4. Google Sketchup Developing A Product

As part of the 3D Printing module students are tasked with creating a product, this lesson takes them through the process of developing their product ***The whole unit is also available in my shop! Grab a bargain! and decrease your planning time!***
msmarwaha