Search this site
Embedded Files
Skip to main content
Skip to navigation
Inverurie Academy Business and IT Faculty
Home
S1 Business & IT
Introduction
File Management
OneDrive in GLOW
Internet Safety
Cyberbullying
Social Media & Accountability
Memes & The Social Media Bubble
Security
Stay Safe Online
Internet Searches & Email
Internet Searches
Search Engines
Fact or Opinion
Email
Email - What is it?
Email Attachments
Email Copies & Replies
Netiquette
School Disco
Presentation Software
Words & Pictures
Sound & Video
Collaborating
Scary Movie
Inside The Case Study
Input, Output & Storage
Architecture
Data
Networks
Compression & Encryption
Creating Games With MakeCode
Introduction & Taking The Sprite For a Walk
All By Itself
Collision Detection
Variables
More Games!
Your Own Game
Spreadsheets: Theme Park
Laying Out The Foundations
No Such Thing As Bad Publicity
The View From The Concession Stands
Visualising Information
Additional Expenses
Word Processing
Sentences
Paragraphs
Extension Work
Practice Assesssment
Databases & Information
Information & Data Types
Structured Information & Records
All About Everyone Else Too
Let's Go To The Movies
Shop Till You Drop
On Your Marks
Animation
Domino Man
Snowball Fight
Crash
Jump
Monsters
Santa Vs The Martians
Graphics
Lolcats
Our House
Easter Card Design
S2 Business & IT
File Management
Castle Jam
Setting the Scene
Getting Organised
Selecting Acts & Bands
Promotional Logo
Newspaper Article
Employee Database
Managing Money 1
Managing Money 2
Further Work
MakeCode Arcade 2: Code Harder
Jungle Run
New Blocks For The Kids
10 Things I Love About Games
Yet More Games
Attack of The Sequel - Your Own Game 2
The Business Factor
The Entrepreneur
Faces Behind The Idea
Goods & Services
Factors of Production
Primary, Secondary, Tertiary
Chicken Run
Counting Coup Costs
Break Even
Marketing & Fundraising
Administration Tasks & Skills
Eggsternal Factors
Eggstra Work
Chill Room
Introduction
Costs & Calculations
Income, Profit & Expenses
Setting The Scene
Stock
Databases
GDPR
Key Fields
Activities Day
Five-a-Side
Exact Match Searches
Other Comparison Searches
AND Searches
Boats, Boats, Boats
S3a Computing Science
Animation
Simple Pixelart
Tiles and Tilemaps
Anti-Aliasing
Animation
From Conception to Execution
Create a Character
Games Design
Game Mechanics
No Dice
Wasn't This Easier Last Time?
Aliens Arrayed Against Us
Fruit Basket
Security Software
Software Downloads & Licensing
Internet Threats
Comparing Security Software
How To Stay Secure Online
Physical Computing
Let's Get Physical
Be There or Be Square! (Ish)
Your Finest Hour
Unexpected Obstacle In The Driving Area
Where's My Line
Hardware
Data Representation - Numbers
Data Representation - Text
Data Representation - Graphics
Analogue & Digital Values
Trends in Processor, Memory & Storage
Input & Output Devices
Computer Types
Emerging Technologies
Investigation
Report
I Heart My Smartphone
Smartphone Programming Theory
User Interface Design & Properties
Event Handling
Procedures
Smartphone Programming Practical
Virtual Pet
Finger Painting
Mole Masher
Times Table
Wiff Waff
S3b Computing Science
Website Programming
Website Programming Theory Notes
Hypertext
Hyperlinks
Styles & Formatting
JavaScript
Website Programming Practical Tasks
Simple HTML Tags
More Pages
Hyperlinks
Formatting
Interactivity
Everything You Ever Wanted To Know...
Games Review
Python Programming
Python Programming Theory Notes
Variables
Algorithms
Testing
Selection
Fixed Loops
Python Programming Practical Tasks
Input & Output
Assignments
Selection
Fixed Loops
School Heating
More Problem Solving
Database Development
Database Development Theory Notes
Tables & Fields
Relationships
Adding Information
Searching A Database
Database Development Practical Tasks
Database Tables
Linked Tables
Adding Data
Simple Searches
Complex Searches
Marathon Man
National 5 Computing Science
N5 Website Design & Development
Web Design Theory Notes
How The Web Works
Analysis
Design
Media Types
Standard File Formats & Copyright Law
HTML & Content
CSS & Formatting
JavaScript & Interactivity
Testing & Evaluation
Web Design Practical Tasks
Web Authoring Packages
Adding Content With HTML
Formatting With CSS
More Pages
Audio & Video
Adding Interactivity With JavaScript
Extra Practice: From Design to Development
Extra Practice: A Website of Your Own
Extra Practice: Old CWAs
N5 Database Design & Development
Database Design Theory Notes
Analysis
Design: Tables & Key Fields
Design: Tables & ER Diagrams
Design: Fields & Data Dictionaries
Data Validation
General Data Protection Regulation
SQL: Queries & Searching
SQL: Complex Searches
SQL: Sorting
SQL: Multiple Table Queries
SQL: Data Modification
Testing & Evaluation
Database Design Practical Tasks
From Design to Database
Validation Rules
Lookups
Populating a Database
SELECT and FROM
Exact Match Queries
Partial Match Queries
Other Comparison Operators
Complex Queries
Sorting
Queries Using Two Tables
Adding Records to a Database
Deleting Records from a Database
Editing Records in a Databas
Extra Practice: SQL
Extra Practice: Creating a Database
Extra Practice: Old CWAs
N5 Software Design & Development
Software Design Theory Notes
The Software Development Process
Analysis
Design: Structure Diagrams
Design: Flow Charts
Design: Pseudocode
User Interface Design
Variables & Data Types
Assignments & Arithmetic Operators
Selection
Fixed Loops
Iterating Arrays & Running Totals
Conditional Loops
Input Validation
Predefined Functions
Combining Standard Algorithms
Errors & Bugs
Testing & Documentation
Evaluation
Software Design Practical Tasks
Introduction to Python
Arithmetic Operations
Simple Selection
Complex Selection
Fixed Loops
Running Totals
Conditional Loops
Input Validation
Arrays
Problem Solving: Guess Number
Problem Solving: Youth Orchestra
Problem Solving: Gone Kayaking
Problem Solving: Extension Exercises
Extra Practice: Old CWAs
N5 Computer Systems
Data Representation - Numbers
Data Representation - Text & Graphics
Computer Architecture
The Need for Translation
Environmental Impact
Security Precautions
Coursework Assignment
Useful Techniques and Links
Higher Computing Science
Website Design & Development
Website Design & Development Theory Notes
Analysis & Design
HTML Divisions
CSS Selectors
Positioning & Display Styles
Navigation Bars
HTML Forms - Part 1
HTML Forms - Part 2
JavaScript
Testing & Evaluation
Website Design & Development Practical Tasks
Before We Begin: The Design
Divisions
Simple Formatting
Positioning Styles
Inline Hyperlinks
Horizontal Navigation Bars
I Suppose There's Lots of Forms To Fill In
Input Validation
Now You See It
Mort's Fun Time
The View From The Gallery
Database Design & Development
Database Design & Development Theory Notes
Database Analysis
Attributes & Their Properties
Data Dictionaries
Entity Occurrences
Relationships & Relationship Diagrams
SQL: Wildcards
SQL: Calculations & Aliases
SQL: Aggregating Functions
SQL: Grouping
SQL: Data Modification
Testing & Evaluation
Database Design & Development Practical Tasks
From Design To Database
Wild Things
A Calculated Approach
The Sum of All Queries
Widget Groupies
Out For The Count (& Average)
Max & Min
Tables Within Tables, Within Tables
What You Lose on the Swings
Putting Right What Once Went Wrong
Software Design & Development
Software Design & Development Theory Notes
The Software Development Process
Development Methodologies
Subprograms
Design Notations
Errors & Bugs
Testing Techniques
Standard Algorithms
String & Other Operations
Data Structures
File Handling
Reading & Interpreting Code
Writing & Adapting Code
Evaluation
Software Design & Development Practical Tasks
Return to Python
Subprograms & Modularity
Pass the Parameters
Linear Searches
Finding the Maximum (& Minimum)
Counting Occurrences
Strings - Slicing & Dicing
Strings - Top Sekret!
Reading a File
Writing a File
Records
Record Arrays
Problem Solving: Coded Messages
Problem Solving: A Grades All Round
Problem Solving: Can't Get No Customer Satisfaction
Computer Systems
Data Representation - Integers
Data Representation - Real Numbers
Data Representation - Text
Data Representation - Graphics
Architecture & The Fetch Execute Cycle
Security Risks
Security Precautions & The Computer Misuse Act
Environmental Implications
NPA Games Development
Computer Games Design
Gaming Platforms
Input & Output on Gaming Platforms
Genres
Game Mechanics
Narrative Design
Character Design
Environment Design
User Interface Design
A Game of Your Own
Computer Games Media Assets
Media Assets Theory
Types of Media
Legal Implications
2D Bitmap Graphics
2D Vector Graphics
Sound
3D Graphics
Media Assets Practical
Simple Pixelart
Anti Aliasing
Pixelart Animation
From Concept to Pixelart
Simple Vector Drawings
Keyframe Animations
Keyframe Walkcycles
Block Party Music
Now Use Both Hands
Samples
The Observer's Guide to Ships in Service
Maps & Lights
Dem Bones
Lights, Camera, Inaction
Computer Games Development
The Main Loop
Subclasses, Events & Logic
Animating Sprites
Collision Detection
Maps & Tiles
Gravity & Jumping
Sound & Music
The Mouse Pointer
User Interface Elements
Killing Sprites
Map Classes
Loading Maps
Scrolling Maps
Sprite Sheets
Simple Follow AI
Advanced Higher Computing Science
Project Management
Analysis & Requirements Capture
Resources & Scheduling
Feasibility Studies
Use Case Diagrams
Specifications
Testing
Evaluation
Website Design & Development
Website Design & Development Theory Notes
Website Design
HTML Forms & Attributes
HTML Tables
Responsive Websites with CSS
Server Side Scripting with PHP
PHP Basic Constructs
PHP Database Connections
PHP SQL Queries
PHP Validation
PHP Session Variables
Website Design & Development Practical Tasks
Site Design
FORMs & FORM ACTIONs
ECHO Chambers
A 'Simple' Search
Little Bobby Tables
GET Linking
The Website is in Session
Responsive Websites
INSERTing Information
Complex Database Operations
Challenge Tasks
Database Design & Development
Database Design & Development Theory Notes
Entity Occurrence Diagrams & Participation
Entity Relationship Diagrams
Data Dictionaries
DDL: CREATE
DDL: Constraints
DQL: Logical Operators
DQL: HAVING
DQL: Subqueries
Data Definition Language Practical Tasks
Database Design
The Secrets of CREATE
An Empty Database Gathers No Customers
Presence & Primary Keyness
CHECKing Out and AUTO INCREMENTing In
All of the Keys
This Seems Familiar?
Data Query Language Practical Tasks
Data Import
NOT
BETWEEN
HAVING
IN
Subqueries
ANY
EXISTS
Software Design & Development
Software Design & Development Theory Notes
Properties & Methods
Inheritance & Polymorphism
Class Diagrams
Wireframes
Other Design Methodologies
Arrays
Linked Lists
Sorting
Searching
Database Connectivity
Object Orientated Programming Practical Tasks
A Class Act
This Is Private Property!
Danger! Mutagenic Risk!
Planes, Trains, But Mostly Just Automobiles
I Heard You Like Classes
Is It A Bird?
Data Structures & Algorithms Practical Tasks
Parallel Lives
I Heard You Like Arrays
Everyone's A Critic
Age Before Beauty
A Game of Grades
On Tour
Database Connectivity Practical Tasks
Starring Role
A Symbol of Distrust
Confirming the Record
Computer Systems
The Project
Starting Out
Project Analysis
Project Design
Project Implementation
Project Testing
Project Evaluation
Compilation & Submission
Inverurie Academy Business and IT Faculty
SQL: Aggregating Functions
Report abuse
Page details
Page updated
Report abuse
