MrRoseComputing

This bundle contains packs that teach pupils about the three practical units of the Scottish National 5 Computing Science course. Software Design and Development: VariablesInput, process, outputArithmetic and calculationsString concatenationIF statements (simple, complex, nested)Loops (fixed, conditional, nested)Input validationRunning total within a loopPre-defined functions1-D arrayDatabase Design and Development: Adding a table (with validation rules and linking to another table)SELECT statem

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 booklet contains tasks for pupils to create 7 games in Scratch. All the screenshots were created using the Scratch website coding editor. Solution to the games (and the blank file for 'Slot Machine') are provided.

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 SQL database booklet teaches pupils about: WildcardsComputed fieldsAggregate functions MIN, MAX, SUM, COUNT, AVGGROUP BYNested queriesThe database supplied contains data about NFL conferences, divisions, teams and players (some of the data is not up to date any more). It was created for the Scottish Higher curriculum (year 11). It would also be relevant to parts of the A-Level Computer Science course as well. There are 25 tasks and the pack contains solutions to all tasks.

This SQL database booklet teaches pupils about: Adding a table (with validation rules and linking to another table)SELECT statementSimple searchComplex searchSimple sortComplex sortSearching and sortingQuerying two tablesDeleting a recordAdding a recordThe database supplied contains data about MLB leagues and teams (some of the data is not up to date any more). It was created for the Scottish National 5 curriculum (year 10). It would also be relevant to parts of the GCSE Computer Science course

This software booklet teaches pupils about Python programming: VariablesInput, process, outputArithmetic and calculationsString concatenationIF statements (simple, complex, nested)Loops (fixed, conditional, nested)Input validationRunning total within a loopPre-defined functions1-D arrayIt was created for the Scottish National 5 curriculum (year 10). It would also be relevant to parts of the GCSE Computer Science course as well. There are 48 tasks, and the pack contains solutions to all tasks.

This web design booklet teaches pupils about: HTML tags (html, head, title, body, heading, paragraph, line break, div, image, hyperlink, list [ordered, numbered], audio, video)Inline, internal and external CSS rules (font-family, font-size, color, text-align, background-color)Inline JavaScript operations (font-family, font-size, color, text-align, background-color)It was created for the Scottish National 5 curriculum (year 10). It would also be relevant to parts of the GCSE Computer Science cour

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

This software booklet teaches pupils about Python programming: Find minimumFind maximumLinear searchCount occurrenceParallel arraysPre-defined functions (to create substrings, convert character to ASCII, convert ASCII to character, convert real numbers to integers, calculate modulus division)Modular programmingLocal and global variablesActual and formal parametersRecord structureArray of recordsFile handlingThe programs access csv and txt files containing: African countries, the top 3000 highest

This workbook contains 7 tasks for pupil to work through. The programs are created on the Microbit website, and can be transferred onto a physical Microbit device via USB. If pupils don't have Microbits, they can still complete the tasks and preview their code using the website's in-built "Microbit preview" screen.

This booklet contains worksheets for 4 Kodu games: Cycle RacerFroggerPongMaze

This is a unit assessment for the Scottish Computing Science curriculum. The unit is Computer Systems and the level is National 5 (4th year in Scotland). It assesses: Binary to denary conversion Denary to binary conversion Floating-point representation ASCII code Vector graphics Bitmap graphics Parts of the processor Processor buses Translators: interpreter and compiler Energy use of a computer system Data security