MrRoseComputing

This bundle contains packs that teach pupils about the three practical units of the Scottish Advanced Higher Computing Science course. Software Design and Development: 2-D ArrayBubble sortInsertion sortBinary searchObject-oriented programmingIntegration with MySQLIntegration with HTMLDatabase Design and Development: CREATE (database and table) and DROP (database and table) statements.Data types (varchar, integer, float, date, time)Constraints (PK, FK, not null, auto increment, checks [restricted

This software booklet teaches pupils about Python programming: 2-D ArrayBubble sortInsertion sortBinary searchObject-oriented programmingIntegration with MySQLIntegration with HTMLThe programs access csv and txt files containing: Asian countries, Mario Kart characters and courses, music artists, Olympic Games host cities, rainfall, South American countries, world countries, a football/soccer league table, mountains, planets, school results, USA states and Super Bowl winners. It was created for t

This bundle contains packs that teach pupils about the three practical units of the Scottish Higher Computing Science course. A description of each resource can be found on my page.

This web design booklet teaches pupils to implement a multi-level website that meets the requirements of the SQA Higher Computing Science curriculum, with: HTML tags (html, head, title, body, header, nav, main, heading, paragraph, line break, section, div, image, hyperlink, list [ordered, numbered], form [text, number, textarea,radio, submit]) External CSS rules (font-family, font-size, color, text-align, background-color, display [block, inline, none], float [left, right], clear, margins, paddi

This SQL database booklet teaches pupils about: CREATE (database and table) and DROP (database and table) statements.Data types (varchar, integer, float, date, time)Constraints (PK, FK, not null, auto increment, checks [restricted choice and range check] )Data dictionary designQueries that use the HAVING clauseQueries that use the NOT, BETWEEN, IN, ANY and EXISTS operatorsSub-queriesThe database supplied contains data about the Marvel Cinematic Universe movies from phase 1 to phase 3 (actors, mo

This web design booklet teaches pupils about: HTML tableCSS media queryPHP echo commandPHP variablesPHP string concatenationHTML and PHP form processing (GET and POST)PHP connection to a MySQL database to add, delete and extract dataPHP session variablesIt was created for the Scottish Advanced Higher curriculum (year 12). It would also be relevant to parts of the A-Level Computer Science course as well. There are 15 tasks and the pack contains an SQL file that contains the CREATE and INSERT quer