Category: Blog

Byte Insight

MySql – Create Database

If you need to create a database via the command line (or through the MYSQL prompt in PHPMyAdmin) then you can use the following where dynamo is the name of the database you wish to create. See W3Schools/Create DB for more information.

CREATE DATABASE dynamo;

MySQL – Create Table

The process and command for creating a table in MySql are similar to that for a database. You will need to make decisions about data types and key fields. Detailed information on creating tables is available at W3Schools/Create Table.

Python – Strings

A string is a list of characters and, in Python, they are easy to declare using speech marks.

myquote = “Talk is cheap. Show me the code.”

Network Configuation

One problem with using a Raspberry Pi in school is that you are protected from evil-web-ness by the PxxxY.  You see we cannnot even say the word without getting this page blocked too.  This page explains how to set up your RPi so you can access the network and internet.

Raspberry Pi

The Raspberry Pi is the infamous credit card sized computer that has revitalised the computer based experiementation first seen with the BBC Micro in the 1980s.   It runs a special flavour of Linux called Raspbian, which encourages students to explore the inner workings of a modern operating system.  The Pi comes with GPIO (General Purpose Input/Output) pins that allow it to be connected to external devices ranging from LEDs and motors to temperature and movement sensors.   There many things that you can do with a Raspberry Pi including:

Potentiometer

This circuit is based on ARDX 8 which uses a potentiometer to change the flash rate of an LED.  

Push Button LED

This simple flashing LED (Light Emitting Diode) circuit is based on the ARDX 07 circuit from Oomlout.  It serves as an excellent introduction to combine inputs and outputs.   It uses a Pull Down Resistor.  

Larsen Scanner

This project is based on ARDX 2 from Oomlout and uses multiple LEDs to create simple patterns.  It gets its name from Glen A. Larsen who wrote the Knight Rider TV Series.  It uses for loops, which are one of the key repetition constructs in computing.

Zumo Robot

The Pololu Zumo Robot is a dual motor rubber tracked robot that fits inside the 10cm x 10cm rule for Mini Sumo Robot Competitions (Click here to see a video). Powered by 4 x AA Batteries it is controlled by an Arduino Uno and the Zumo Robot Shield working in tandem.

Zumo Buzzer

The Zumo Robot shield comes with a buzzer that can be used to signify events or actions.