
– Online Database –
– SQL Activities –
Feeling confident with your computing knowledge of Relational Databases?
Spend a few minutes to answer or research the following questions:
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?
?

Feeling confident with your computing knowledge of Relational Databases?
Spend a few minutes to answer or research the following questions:
Our aim is to use the BBC micro:bit to create an automated Car Park Display to inform drivers of the number of empty spaces left in a car park.
Our system should:
Use the microbit.org website to get started!
We will complete this project in 4 blocks of code.
First let’s initialise two variables:

Then we will decrement the number of empty spaces by 1, everytime the A button is being pressed. (A car enters the car park), making sure that we only let cars in if the number of empty spaces is greater than 0. (There is at least on empty space).

Using a similar approach, we will increment the number of empty spaces by 1 everytime the B button is pressed (A car leaves the car park)

Finally, depending on the number of empty spaces in the car park, we will display the relevant message as scrolling text to inform users of the number of empty spaces in the car park.


In cryptography, a Caesar cipher, also known as shift cipher, is one of the simplest and most widely known encryption techniques. It is a type of substitution cipher in which each letter in the plaintext is replaced by a letter some fixed number of positions down the alphabet. For example, with a left shift of 3, D would be replaced by A, E would become B, and so on. The method is named after Julius Caesar, who used it in his private correspondence.
The action of a Caesar cipher is to replace each plaintext letter with a different one a fixed number of places down the alphabet.

The cipher illustrated above uses a left shift of three, so that each occurrence of E in the plaintext becomes B in the ciphertext.
The transformation can be represented by aligning two alphabets; the cipher alphabet is the plain alphabet rotated left or right by some number of positions. For instance, here is a Caesar cipher using a left rotation of three places, equivalent to a right shift of 23 (the shift parameter is used as the key):
Plain: ABCDEFGHIJKLMNOPQRSTUVWXYZ
Cipher: XYZABCDEFGHIJKLMNOPQRSTUVW
When encrypting, a person looks up each letter of the message in the “plain” line and writes down the corresponding letter in the “cipher” line.
Plaintext: THE QUICK BROWN FOX JUMPS OVER THE LAZY DOG
Ciphertext: QEB NRFZH YOLTK CLU GRJMP LSBO QEB IXWV ALD
Deciphering is done in reverse, with a right shift of 3.
The encryption can also be represented using modular arithmetic by first transforming the letters into numbers, according to the scheme, A = 0, B = 1,…, Z = 25.[2] Encryption of a letter x by a shift n can be described mathematically as,
Decryption is performed similarly,
![]()
The Caesar cipher is named after Julius Caesar, who used it, more than 2000 years ago, to protect messages of military significance.

Vercingetorix throws down his arms at the feet of Julius Caesar. Painting by Lionel Royer – Musée CROZATIER du Puy-en-Velay – France, Public Domain.

N qtaj uwtlwfrrnsl zxnsl Udymts!
Key: right shift by 5 characters

Imagine a building with 8 rooms.

Each room is fitted with a card reader used to give access or not to different members of staff.
Each member of staff has a card giving them access to some of the rooms.
The card is used to store an access code:

This card gives access to:
Hence the Access Code: 00101001
| Access Card | Room Access |
|
|
![]() |
|
![]() |
|
![]() |
The locking system at the door uses both the access code of the staff member’s card and the building access mask to decide if a staff member can unlock a room:

This means that this member of staff can only access room 5 and room 8. This operation consists of applying an AND mask to determine the resulting room access code.
Considering the following Access Mask:
| Access Card | Room Access |
|
|
![]() |
|
![]() |
|
![]() |

Use an OR mask with the following cards access code to determine which rooms these sets of two cards will give access to:
| Access Card 1 | Access Card 2 | Room Access |
|
|
|
|
|
|
|
|
|
|
|
When designing a website, you have to consider the different sizes of screens of your internet users. These may access your website using a computer (desktop/laptop), a tablet, a smartphone, a smart TV…
A responsive website is a website where the layout adapts to the size of the screen.
On a large screen, the layout may include a header, a footer, several columns, left and right panels. A responsive layout can then adapt to smaller/narrower screens such as smartphones by adopting a linear layout (where all the sections mentioned above appear one after the other).

Using CSS it is possible to apply different sizes and positions to different sections of the website based on the size of the screen.
If you have used one of the layout from “HTML – Website Layout” then you can add the extra CSS provided below to make your website responsive.
@media screen and (max-width: 1040px) {
BODY {
margin: 20px 20px 20px 20px;
}
.page, .pageHeader, .pageContent, .pageLeftPanel, .pageRightPanel, .pageFooter {
width: 100%;
}
.pageContent, .pageLeftPanel, .pageRightPanel {
min-height: auto;
}
IMG {
max-width: 100%;
}
}
A quick approach to test if your website is responsive is to resize your bowser window to the size of a smartphone and see how your website behaves.
Other aspects of a website can also adapt to the size of the screen. These includes pull-down navigation menus, font sizes, picture sizes, interactive elements such as tabs, accordion menus… However these can sometimes be trickier to implement.
When formatting text on a webpage, you will more likely want to use different types of fonts. You may be tempted to use fonts that are installed on your own computers. However, you need to be careful as there is no guarantee that these fonts are also installed on the computers of the client computers/tablets/smartphones of users who will access your webpage.
To remedy this problem, you can limit your choice of fonts to “web-safe” fonts. These are a set of fonts which are installed on nearly every computer/tablet/smartphone. Check this page to access a list of web-safe fonts: http://www.w3schools.com/cssref/css_websafe_fonts.asp.
The list of web-safe fonts being very limited, you may then investigate using Google Fonts. These are fonts that are hosted on Google servers and that you can link from your webpages. Which means every time a user loads your page, their browser will also load the required fonts from Google servers. Though this may slow down the loading of your page, it will give you access to hundreds of fonts to choose from and is a very reliable approach to spice up the look and feel of your website.
Check the list of available Google Fonts: https://fonts.google.com/.
The following video clip explains how to use Google fonts on your own webpages.
Additional Video:
Google Fonts in less than 3 minutes: https://youtu.be/peR9V-f9OkI
<link href="http://fonts.googleapis.com/css?family=YOUR_CHOSEN_FONT" rel="stylesheet" type="text/css">
And then in HTML your code either use the
<FONT face="YOUR_CHOSEN_FONT">...</FONT>
Or in CSS:
BODY, H1, P {
font-family: 'YOUR_CHOSEN_FONT';
}
In this blog post we will create a Python program that will help us calculate the total resistance when two resistors are connected either in series or in parallel.
This program will be based on the following formulae:

| Test # | Input Values | Expected Output | Actual Output |
| #1 | R1: 6 (Ohms) R2: 6 (Ohms) Series |
12 Ohms | |
| #2 | R1: 6 (Ohms) R2: 6 (Ohms) Parallel |
3 Ohms | |
| #3 | R1: 6 (Ohms) R2: 12 (Ohms) Series |
18 Ohms | |
| #4 | R1: 6 (Ohms) R2: 12 (Ohms) Parallel |
4 Ohms | |
| #5 | R1: 33000 (Ohms) R2: 56000 (Ohms) Series |
89000 Ohms | |
| #6 | R1: 33000 (Ohms) R2: 56000 (Ohms) Parallel |
20764 Ohms |

Complete the following snowman using HTML and CSS code. You can edit this code in a new window using this button: ![]()
<DIV id="message">Merry Christmas!</DIV>


In this challenge you will be asked to solve four mazes by designing their matching escape flowcharts. You can download and print this pdf booklet to draw your flowcharts.
The escape flowchart for this maze is already done for you:



