This student workbook is ideal for students, non-specialist teachers, NQTs any anyone who wants to gain confidence in the programming techniques section of the  OCR GCSE (9-1) in Computer Science (J276) specification using Python.

 

This 97-page PDF which covers the theory, directly comparing the preferred OCR pseudocode standards and Python language.  It includes ready-to-use tasks and practical programming challenges and even the answers are provided for you.

 

Table of Contents:

  • Data types
  • Using data types
  • Integer
  • Real
  • Boolean
  • Character
  • String
  • Casting
  • Programming Concepts
  • Variables
  • Constants
  • Defining variables and constants
  • Rules of naming variables and constants
  • Assignment
  • Sequence
  • Iteration
  • Condition-controlled iteration
  • Count-controlled iteration
  • Indenting lines of code
  • Selection
  • Nested selection and nested iteration
  • Nested iteration
  • Nested selection
  • Standard selection statement
  • Additional condition selection statement
  • Nested selection statements
  • Sub programs
  • Advantages of using sub programs in programs
  • Functions and Procedures
  • Passing data within programs
  • Returning single values
  • Returning multiple values
  • Global and local variables
  • Why use local variables?
  • Operators
  • Common Arithmetic Operators
  • Relational operators
  • Boolean operations
  • Using operators in iteration and selection structures
  • Arrays
  • One-dimensional arrays
  • Two-dimensional arrays
  • Complex data types (records)
  • File Handling
  • File location
  • Writing to a text file
  • Adding new data to an existing text file
  • Reading from a text file
  • String handling operations
  • Length
  • Substring
  • Concatenation
  • Character codes
  • Changing case
  • The use of SQL to search for data
  • Understanding a relational database
  • Setting up an SQL database
  • Selecting data from an SQL database
  • Selecting specific fields
  • Where statements
  • Complex SQL searches
  • Partial SQL searches
  • Displaying SQL data on separate lines
  • Closing the database

OCR Programming techniques with pseudocode and Python

£30.00Price
  • Digital resources purchased from Nichola Wilkin Ltd. are to be used in the original individual school which purchases the resources only.

     

    Resources may not be shared, distributed or displayed digitally for public view, uploaded to school or borough websites, distributed via email, submitted to file sharing sites or shared with another school or institution, even those within the same academy chain.

     

    For full terms and conditions visit https://www.nicholawilkin.com/terms

24 Crow Hill Lane, Great Cambourne, Cambridge, CB23 5AW, UK    
 +44 (0)1954 205263

admin@nicholawilkin.com

© Nichola Wilkin Ltd. 2019