These e-books are merely static versions of content from a new Open Source FLEXIBLE LEARNING project — everything in ONE PLACE and usable both in and out of the classroom.
Ready-to-go, community-authored 'COURSEWARE' freeing you up to get on with SUPPORTING ACTUAL LEARNING rather than incessantly having to reinvent the wheel.
Highly scrutinised, cross-platform, and crucially, COMMUNITY-OWNED and authored.
Read about the project here: https://sirclickalot.co.uk/assets/the-bit-by-bit-project/
These e-books are merely static versions of content from a new Open Source FLEXIBLE LEARNING project — everything in ONE PLACE and usable both in and out of the classroom.
Ready-to-go, community-authored 'COURSEWARE' freeing you up to get on with SUPPORTING ACTUAL LEARNING rather than incessantly having to reinvent the wheel.
Highly scrutinised, cross-platform, and crucially, COMMUNITY-OWNED and authored.
Read about the project here: https://sirclickalot.co.uk/assets/the-bit-by-bit-project/
ABOUT THIS RESOURCE
This resources takes the absolute beginner step-by-step through learning relating to the following learning outcomes:
Databases
I can explain the concept of a database.
I can use the SQL commands SELECT, FROM, WHERE and ORDER BY to retrieve data from a relational database.
I understand the need for a dedicated language to enable communication between SQL clients and SQL servers
I understand the database concept of a foreign key.
I can select a suitable primary key for a table for the design of a single-table database given a set of data management requirements.
I can use the SQL operators <, >, =, <=, >=, <>, AND, OR, LIKE and BETWEEN to retrieve data from a relational database.
I can demonstrate that I understand the concept of CONSTRAINTS in the context of SQL
I can use the SQL commands UPDATE, SET and WHERE to retrieve data from a relational database.
I can choose appropriate field types and lengths for the design of a database given a set of data management requirements.
I can use the SQL commands INSERT INTO and VALUES to insert data into a relational database.
I understand the database concepts: table, record, field and primary key.
I can evaluate a database solution in terms of accuracy of output and fitness for purpose.
I can explain the concept of a relational database.
ABOUT THIS RESOURCE
This resources takes the absolute beginner step-by-step through learning relating to the following learning outcomes:
Databases
I understand the purpose of and can create and use SQL DDL scripts.
I understand the purpose of and can create and use SQL DML scripts.
I can use a GUI-driven database building tool.
I can identify entities for the design of a relational database given a set of data management requirements.
ABOUT THIS RESOURCE
This resources continues on from the beginner e-book, and takes the beginner step-by-step through the next steps in the rite of passage to becoming a bonafide Python coder.
It relates to many basic learning outcomes such as:
Programming
I can code algorithms which use local and global variables in functions and subroutines (methods).
I understand and adhere to the Single Responsibility Principle when writing code.
I can explain the benefits of, and write algorithms and code which uses subroutines (methods).
I write programs that use pre-existing (built-in) libraries.
I can code algorithms which use two-dimensional (collection/container) data structures for modelling simple 2D lookup tables.
ABOUT THIS RESOURCE
This resources takes the absolute beginner step-by-step through:
Getting started setting up Python and cross all three platforms: Windows™, macOS™, and Linux (Ubuntu™)
Interacting with the beast via the Python shell.
It relates to many basic learning outcomes such as:
I am able to describe when and why a particular programming language or language level is a suitable choice.
I can explain the idea and action of translators (interpreters, compilers, assemblers).
I understand the idea of coding through a console and am confident with doing so.
I use arithmetic operators for addition, subtraction, division, multiplication, modulus, integer division and exponentiation in algorithms and code.
I use variable declaration, constant declaration and value assignment.
I am able to determine the type of an object such as a named variable.
I can explain and use the data types integer, real, boolean, character appropriately.
It ends with a first foray into using an IDE and we opt for the industry standard Pycharm™ because in the real world, there is little or no point in using anything else.
This resources continues on from the beginner e-book, and takes the beginner step-by-step through the next steps in the rite of passage to becoming a bonafide Python coder.
This resources takes the absolute beginner step-by-step through the basics of Boolean logic through to building working simulations using Digital™
The following learning outcomes are covered:
Boolean logic
I can explain the term ‘gate’ in relation to Boolean logic.
I can construct truth tables for simple logic circuits using combinations of gates.
I can explain the simplification of Boolean expressions using Boolean identities and rules.
I appreciate the role of Boolean logic in computer architecture.
I can form Boolean expressions from truth tables and vice versa.
I have a sense of what ‘logic’ is and where it originated.
I can explain the logical operator AND, OR and NOT.
I can create logic circuit diagrams from simple Boolean expressions.
I recognise 1/0 as two-state logic levels.
Impacts
I can describe the contribution of Claude Shannon to Computer Science.
I can describe the contribution of George Boole to Computer Science.
I can describe the contribution of Augustus De Morgan to Computer Science.
This resources takes the absolute beginner step-by-step through learning relating to the following learning outcomes in addition to Part 1:
Boolean logic
I can explain the logical operator XOR.
I can explain the logical operator NAND.
I understand the value of implementing logic circuits using only one type of gate (NAND or NOR).
I can explain the logical operator NOR.
I can explain the simplification of Boolean expressions using Boolean identities and rules.
I can simplify Boolean expressions using Karnaugh maps.
I can explain how to create an SR flip-flop using primitive logic gates.
I can form Boolean expressions from truth tables and vice versa.
This resource is designed as the absolute starting point for introducing Artificial Intelligence (AI) to classes.
It relates to a very general learning outcome…
I can describe issues associated with the use of artificial intelligence, machine learning and robotics in terms of accountability, safety, algorithmic bias and legal liability.
It is meant to be used flipped in that students are set the task to read some or all of it, take rough notes along the way on their own thoughts, questions, and pointers to other resources and come ready for a group discussion in lesson time.
This guide is merely a curation of others’ thoughts and ideas sampled here under the fair use for education policy; we do not take any credit for its content, only for the curation into a neat booklet.