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

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

part of the BTEC Level 3 Diploma in Information Technology that i delivered at Level 3, contains all of the lessons and assignments for unit 8 e-commerce

All of the resources i used for this unit of work at level 3, the pack contains all of the assignments i used as well as the resources for each section.

Unit 17 of the BTEC level 3 course, contains all of the lessons and assignments needed for the students to complete the unit

part of the BTEC Level 3 Diploma in Information Technology which i delivered to level 3 students, pack contains all resources that i used including assignments

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!

Here you will find the resources to complete Unit 20 in the level 3 Cambridge Technicals. All of the Learning Objectives have been covered within the lessons provided. The assignment which has been used has also been checked using the Assignment Checking service from OCR. (Service is £30 per assignment) Enjoy!

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!

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.

This is the full unit for the KS3 hardware and software topic which I delivered, it includes the full lessons along with extensions and an assessment at the end of the topic. included are: 1. Hardware 2. Software 3. Inputs and Outputs 4. The future of Hardware and Software 5. Assessment Single lessons can also be purchased in the shop

Included in this teaching pack is the full set of resources that have been used to complete the BTEC first unit 3- Digital Portfolio It includes all the relevant PowerPoints to guide students towards completion of the unit. The resources cover the full specification of the unit and will enable the students to gain the Pass, Merit or Distinction levels. Enjoy!

A fully set of resources to complete Unit 13, the set includes all the tasks used by myself to teach Unit 13 - website Development. I have added extra hints and tips to the slides to ensure you fully understand what to do! This unit has been moderated several times and has never had an issue. Enjoy!