GCSE Computer Science - Programming Techniques :
LO1: The use of records to store data
LO2: The use of SQL to search for data
Using the subject matter of a Year 11 Computer Science class, students learn how to create a table in a database, how to add individual records, how to add multiple records and then how to search for records.
The extension task is then to create a database on a topic of their choice using the programming techniques shown in the walk-through-talk-through example.
This lesson comes complete with notepad copies of the Python code with and without comments (just copy and paste code into Python).
LO1: The use of records to store data
LO2: The use of SQL to search for data
Using the subject matter of a Year 11 Computer Science class, students learn how to create a table in a database, how to add individual records, how to add multiple records and then how to search for records.
The extension task is then to create a database on a topic of their choice using the programming techniques shown in the walk-through-talk-through example.
This lesson comes complete with notepad copies of the Python code with and without comments (just copy and paste code into Python).
Get this resource as part of a bundle and save up to 53%
A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.
Bundle
Component 2 SQL: Help with Structured Query Language
In the OCR GCSE Computer Science 9-1 Paper 2 2018, the paper started with an SQL question. Of all the questions in Paper 2, this is the one that they struggled with. In this bundle are previous resources for the GCSE Computing course which are relevant, and newly created resources for the GCSE Computer Science 9-1 course.
£8.00
Bundle
Python Efficiency Bundle
A follow-on unit to Python Basics. Introducing procedures and functions for more efficient code. Procedures & Functions Using menus (selection) Adding to and reading from file. Importing modules Using lists Using SQL to search for data
£14.00
Something went wrong, please try again later.
This resource hasn't been reviewed yet
To ensure quality for our reviews, only customers who have purchased this resource can review it
Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.
£4.00