Index of Files

DB Index Home

Index of Files

The table below shows all the files available for download from all the topic areas on the site.

Language & Category	Title	Description
Algorithms General	Algorithms	How to write algorithms
Algorithms General	Algorithm Challenges	Algorithm Challenges - Starter set
Algorithms General	More Algorithm Challenges	Further algorithm challenges with graded complexity levels
Algorithms General	Presentation	A presentation that covers the topics on this page
Algorithms Pseudocode	Presentation	Presentation to explain the principles of pseudocode.
Algorithms Pseudocode	Help Sheet	Writing Pseudocode help sheet
CSS Animation	Cross Fade on Mouseover	Mouse over an image to fade out/in without JavaScript
CSS Animation	Cross Fade two images	Two images cross fade continuously
CSS Formatting	Table	How to format a table
CSS Layout	Table	How to format a table
CSS Layout	Nav and Content	LHS navigation panel and main content with banner across the top
CSS Other	Attach a Style sheet	Instructions on how to attach a style sheet to an HTML page
CSS Other	Positioning	Position layers in columns without using tables
CSS Other	Fonts	How to make use of font libraries on the Internet Notes: You must have a link tag in the head section of your web page to use this feature
Excel Excel	Understanding spreadsheets	Parts of a Spreadsheet Presentation
Excel Excel	Understanding spreadsheets	The basics - Worksheet
Excel Excel	Simpsons Activity	Simpsons Activity
Excel Excel	Chocolate brownies	Brownies Task sheet
Excel Excel	Cell Referencing	Cell referencing exercises
Excel Excel	Superhumans	Superhumans Task Sheet
Excel Excel	If Function	How to use the IF function
Excel Excel	If Function Exercises	If Function Exercises
Excel Excel	A Good Breakfast	A Good Breakfast task sheet
Excel Excel	Duffys Diner Exercise	Using basic formulas to create a spreadsheet to analyse profitability of a sandwich shop
Excel Excel	Duffys Diner Workbook	Excel workbook for use with Duffys Diner
Excel Excel	Heathrow Weather Exercise	Import Data, reformat and use functions to analyse weather data
Excel Excel	Heathrow Weather Data	Data file for the Heathrow Weather Exercise
Excel Excel	Level 2 Exercises Set 1	Simple arithmetic calculations, if function, formatting and charts
Excel Excel	Level 2 Exercises Set 2	Simple arithmetic calculations, if function, formatting and charts
Excel Excel	Epsom Travel exercise	Exercise that brings together formatting, calculations and charts
Excel Excel	Holiday bookings	Excel workbook for the Epsom Travel Exercise
Excel Excel	Custom Formatting Helpsheet	How to setup and use custom formatting
Excel Excel	Using find, match and vlookup	Finding Data
Excel Excel	Practicing absolute cell references	Finding Data
Excel Excel	Working with strings	Identifying parts of a string and placing the results in separate cells
Excel Excel	Working with strings - Instructions	Instructions for use with Working with Films Top 10 Films workbook.
HTML Exercises	Basics of HTML	Description HTML and structure of webpages exercise to complete of final slide
HTML5 Forms	Creating a Form	Creating a Form and defining the action
HTML5 Forms	Creating an aligned form	Creating a Form with fields and labels aligned
HTML5 Hyperlinks	Anchor	Hyperlink to a place on a page
HTML5 Hyperlinks	Internal Hyperlink	Hyperlink to a page within the website
HTML5 Hyperlinks	External Hyperlink	Hyperlink to another website
HTML5 Hyperlinks	Mail Link	Send an email using an email client such as Outlook Notes: The email client must be configured on the local computer
HTML5 Other	HTML Character Code	Hex codes to put in HTML pages to display the correct character (such as the ;& character on your web page Notes: The email client must be configured on the local computer
HTML5 Other	Blank web page (with head, body etc defined)	Example of the structure of a web page
HTML5 Other	Head section with links	Example of links to jQuery, javascript and CSS in the head section
Javascript Arrays	Array Count	Returns a value indicating how many elements are in an array
Javascript Arrays	Array Index	Returns the contents of array element. Notes: By default, array elements start at position 0 There is error checking in this code to prevent n being greater than the length of the array!
Javascript Arrays	Array Search	Searches all the elements of an array to find a value. Returns the index position found or -1 otherwise. Notes: By default, array elements start at position 0
Javascript Arrays	Add array element	Add an element to an array. Notes: This example adds an element to a specified place (not the start or end) of an array
Javascript Arrays	Array Display	Display the contents of all the elements in an array Notes: This is a simple way to iterate (loop) through an array
Javascript Arrays	Add array element at end	Add an element at the end of an array.
Javascript Arrays	Add array element at beginning	Add an element to the beginning of an array.
Javascript Arrays	Array remove element	Remove an element from an array. Notes: Specify the index number to start and how many elements to remove
Javascript Arrays	Array sort	Array sort Notes: By default values are sorted as strings in alphabetical and ascending order.
Javascript Arrays	Array Display - ext version	Display the contents of all the elements in an array - extended version Notes: This example uses for (start val; end val ; increment ). Use this method until you understand it thoroughly.
Javascript Arrays	Associative Array	Notes: Uses names instead of numbers to access array elements
Javascript Arrays	Array Display Table	Display the contents of an array in an HTML table Notes: This is a simple way to iterate (loop) through an array
JavaScript Arrays	2d Array Challenge	Challenge Using 2d arrays. This tryout includes documentation and a partial JS file to get you started Notes: You must fix the errors and omissions in the JS file before it will work
Javascript DTime	Timer	Display a countdowntimer Notes: What happens when the timer ends is up to you. Can be used to display a message, make a layer visible, or load another page when the timer finishes
Javascript DTime	Simple Clock	Output the current time on a page
Javascript DTime	Date and Time	Javascript code to display the date and time on your web page
Javascript DTime	Date Split	Split a date into Split a Date into Days Months and Years
Javascript Exercises	Debug console in Chrome	Setting up the debug console in Chrome
Javascript Exercises	Programming Challenges	JavaScript Programming challenges - including sequence, selection and iteration
Javascript Exercises	Understanding Loops	Develop your understanding JavaScript programming - variables, constants and loops
Javascript Exercises	Collect and Display Data	Develop your JS skills by improving the way collect data from the user and display the results.
Javascript Forms	Get Form Data	Process the data submitted on a form
Javascript Forms	Text Field Single	Read data from single text field
Javascript Forms	Text Field Many	Read data from multiple text fields Notes: each text field has to start with the same ID and end with a number eg input1, input2 etc
Javascript Forms	Read a Checkbox	Read the value of a check box Notes: A checkbox or group of checkboxes can be set or unset resulting in multiple values. If you only want one value,returned, use a radio button
Javascript Forms	Read a Radio Button	Read the value of a radio button Notes: A group of radio buttons (minimum of two) will only return the value of the button that was checked
Javascript Forms	Read a Dropdown	Read the value of dropdown Notes: There should always be a default as the first option in the list
Javascript Forms	Create a dropdown list	Create a drop down list Notes: This creates the options the user chooses from are the same the program is working with. This example already has the < select > tag setup on the form and the list is populated when the page loads with onload="CreateDropList()
Javascript InputOutput	Display output (alert)	Use an alert window to display output Notes: this is the easiest way to display output from your program
Javascript InputOutput	Display output	Use the web page to display output Notes: shows how to use javascript without having to call a function from your page!
Javascript InputOutput	Display output (selector)	Use a named element to display text
Javascript InputOutput	Write to element ID	Use an HTML element for output Notes: The element must be setup with a unique ID eg ID="Result"
Javascript InputOutput	Text field input	Read the content of a text field on a page and display it
Javascript InputOutput	Get Input (prompt)	Use an prompt window to get user input Notes: this is the easiest way to get user input for your program
Javascript InputOutput	Text File Reader (unsatisfactory)	Open and read a text file stored on a local computer Notes: the program reads a file specified in the GET statement and waits for the file to be processed. This style of programming should only be used in exceptional circumstances.
Javascript InputOutput	Text File Reader (preferred)	Open and read a text file stored on a local computer Notes: the program reads a file specified in the GET statement and receives notification that the file has been processed
Javascript InputOutput	Get URL Data	Read the variables on the URL and return the value to the program Notes: If you are calling the page from a form you must use the GET method for this code to work.
Javascript Loops	For Loop	Loops through a block of code a number of times
Javascript Loops	For In Loop	Loops through the properties of an object (like an array)
Javascript Loops	While Loop	Loops through a block of code while a specified condition is true (test a the beginning)
Javascript Loops	Do While Loop	Loops through a block of code while a specified condition is true (test a the end)
Javascript Loops	Break	Used with an If statement to stop the loop
Javascript Loops	Continue	Used with an If statement to go to the next iteration of the loop
Javascript Numbers	To Floating Point	Convert the contents of a variable to floating point Notes: This is necessary because if you need to use math functions on a variable the content must be numeric
Javascript Numbers	To Integer	Convert the contents of a variable to integer Notes: This is necessary because if you need to use math functions on a variable the content must be numeric
Javascript Numbers	Return the Modulus	Modulus - get the remainder after division Notes: This works by dividing number1 by number2 and returns only the remainder as a result
Javascript Numbers	Random Number	Generate a random number Notes: Show how to use javascript without having to call a program (function)from your page!
Javascript Numbers	Decimal Places	Round a number to a specified number decimal places
Javascript Numbers	Round Up	Round a floating point number UP to the nearest integer
Javascript Numbers	Round Down	Round a floating point number DOWN to the nearest integer
Javascript Numbers	Is Numeric	Is the content of a variable a number?
Javascript Other	HTML Character Code	Hex codes to put in HTML pages to display the correct character on your web page
Javascript Other	Show-Hide	Show or hide an object on the page Notes: Useful if there is an object that you only want the user to see under certain conditions. There are three JS functions hide, show and toggle
Javascript Other	Show-Hide on a timer	Show an object then hide it after a delay and display second object Notes: Objects can be anything that you have referenced with an ID
Javascript Other	How functions work	Principles of functions in a programming language
Javascript Other	Animation	Animate an image using JavaScript
Javascript Other	Snow Animation	JavaScript creates a snow scene on the background of your page
Javascript Other	Validate a form	Validate a form with javascript before submitting it to be processed on a PHP server Notes: use the following html to call the javascript and then pass on the form to the normal processing action: lt;form name="myForm" class="user-form" action="FormJSValidate.php" onsubmit="return validateForm()" method="post">
Javascript Other	JavaScript widgets	Links to an external website that has some useful code for clocks, calendars and page counters
Javascript Other	New table row	How to add a row to existing html table
Javascript Other	Local Storage	Using Local and Session storage to save data between page refresh Notes: A page refresh occurs when you submit a form. All the data the page worked with previously is lost.
JavaScript Other	Link to jQuery	Instructions on how to link to the jQuery Library
Javascript Other	StarterPage	Basic HTML page that includes a button linked to a function
Javascript Selection	If Statement	How to set up an if statement
Javascript Selection	Switch	Switch - similar to a long set of nested if .. else but easier to understand if you have a number of alternatives base on the value of one variable
Javascript Strings	charAt	Returns the character at the specified index (position)
Javascript Strings	concat	Joins two or more strings (concatenation), and returns a new joined string
Javascript Strings	indexOf	Returns the position of the first found occurrence of a specified value in a string
Javascript Strings	lastIndexOf	Returns the position of the last found occurrence of a specified value in a string
Javascript Strings	localeCompare	Compares two strings
Javascript Strings	match	Searches a string for a match against a regular expression, and returns the match
Javascript Strings	replace	Searches a string for a specified value, or a regular expression, and returns a new string with the specified values are replaced
Javascript Strings	search	Searches a string for a specified value, or regular expression, and returns the position of the match
Javascript Strings	split	Splits a string into an array of substrings
Javascript Strings	substr	Extracts the characters from a string, beginning at a specified start position, for the specified number of characters
Javascript Strings	toLowerCase	Converts a string to lowercase letters
Javascript Strings	toString()	>Returns the value of a String object
Javascript Strings	toUpperCase	Converts a string to upper case letters
Javascript Strings	toTitleCase	Converts a string to title case letters
Javascript Strings	trim	Removes whitespace (spaces, tabs) from both ends of a string
Javascript Strings	CharMatch	Checks to see if the contents of a character string match a test string. Notes: Returns 0 if the contents are valid (match) -1 otherwise
PHP5 Arrays	One Dimension Array	One dimension array processed with For loop, output to a table
PHP5 Arrays	One Dimension Array	One dimension array processed with Foreach loop, output to a table
PHP5 Arrays	Multiple Column Array	Two dimension array processed with Foreach loop, output to a table
PHP5 Arrays	CSS File	Click on the link to use the CSS file to format your table. Save the file to your includes folder as myStyle.css Notes: in the head section of your page add this line: <link rel="stylesheet" href="includes/myStyle.css" >
PHP5 Other	Session Variables Set	Session variables allow you to save data from one instance of a web page to another
PHP5 Other	Session Variables Clear	Clear (destroy) all session variables
PowerPoint Python HowTo	Variables	Naming and using variables in Python
PowerPoint Python HowTo	Arithmetic Operators	Correct use of symbols and other arithmetic operations
PowerPoint Python HowTo	Selection	Making choices and using relational operators
PowerPoint Python HowTo	Iteration: Condition Controlled	How to use while (condition controlled) loops
PowerPoint Python HowTo	Iteration: Count Controlled	How to use for (count controlled) loops
PowerPoint Python HowTo	Strings	How to use set up and use strings
PowerPoint Python HowTo	Lists	How to use lists
PowerPoint Python HowTo	Code Maintainability	How to use comments and other techniques to improve code readability
Python CSVFiles	Read CSV data	Read data from a CSV file
Python CSVFiles	CSV File read and write	Read and write a CSV file using the methods from the CSV module
Python CSVFiles	CSV File read and append	Read and append to a CSV file using a loop to control the file append
Python CSVFiles	File exists	Use the file system to see if a file exists
Python dictionaries	Initialise dictionary and count	Setup a dictionay and count the number of entries
Python dictionaries	Add or Update dictionary key/value	Add/update a dictionary
Python dictionaries	Delete dictionary key/value	Delete a key/value pair from a dictionary
Python dictionaries	Dictionary From List	Create a dictionary from two lists
Python dictionaries	Get data element using a key	Get data from a dictionary using a key value
Python dictionaries	Display Dictionary Data	Display key value pairs from a dictionary
Python dictionaries	Sort Dictionary Data	Sort a dictionary by key or by value
Python DTime	Timer	Setup a simple execution timer
Python DTime	Execution Time Formatted	Time a piece of code with formatted output
Python DTime	Get current date and time	Return date and time into separate variables for use in code. Shows how to re-format date output.
Python DTime	Convert string to time	Input a text string and convert to date. Shows how to re-format output
Python DTime	Elapsed time using input from user	Accept input from user, converts to date-time and calculates difference in time from now
Python DTime	Users age	Calculate the users age from an input date string
Python DTime	Date and Time	Formatting text strings as standard date-time
Python ErrorHandling	Defensive Programming	Understanding how to design programs to cope with unexpected inputs
Python ErrorHandling	Basic Try/Except	Using Try/Except to validate a number
Python ErrorHandling	Try/Except with Assert	Using Try/Except to validate a number in a range. Shows how to handle multiple exceptions
Python Exercises	Iteration	Using for and while loops to process numeric and character data
Python Exercises	1D List Exercises	A series of exercises to get you familiar with using lists
Python Exercises	2D List Exercises	Using 2D list to analyse time spent by students playing games Includes skeleton code Notes: This is a zip file download, unzip the contents then move to your development folder
Python Exercises	Calculator	Create a basic program to mimic a calculator (add, subtract, multiply and divide)
Python Exercises	Chatbot	Exercise to create a chatbot that remembers who you are and what you said! Designed to cover validation, list, file handling and structured programming
Python Exercises	Code Readability	Exercise to help you understand how to improve the readability of code
Python Exercises	Sports Team	Using DIV and MOD in python. Differentiated task to allow the user to input data, validate and produce a result
Python Exercises	Programming Techniques	Analyse an algorithm to identify where various programming techniques are used.
Python Exercises	Global variables	Understand varaible scope and how to use global variables
Python Exercises	Paint a Room	Exercise to create a program to allow the user to enter the dimension of a room and the program calculates the amount of paint and the cost.
Python Exercises	Universal Converter	Universal converter code template. User chooses the measurement to be converted eg length, weight temperature etc measurement to be converted
Python Exercises	BMI Calculator	Accepting a users height and weight and calculating the BMI and degree of obesity
Python Exercises	Student Weights	Record student weights and analyse the difference at the end of term
Python Exercises	Car Park Manager	Record entry time into the car park then calculates the amount to pay based on the length of stay
Python Exercises	Concrete Products Order system	Allows the user to choose the shape and size and quantity of concrete products. Calculates the final cost of all orders placed
Python Exercises	Flashcards	Electronic flashcards to aid exam revision. Uses a text file to store data
Python files	Read TXT by line data	Read data from a text file line by line
Python files	Read TXT data	Read data from a text file
Python files	Write TXT data	Write data to a text file and add newline characters
Python lists	List Arithmetic	Using builtin functions to find the MAX, Min, Sum and counting the number of entries
Python lists	Basic list setup	Code to setup a simple list and then append data to it
Python lists	Initialise lists	3 ways to initialise a 1d ist
Python lists	2D List setup and print	Setup a small 2D list with numbers and print out using nested for loops
Python lists	List Methods	Common methods such as reverse, sort and append
Python lists	List Index	Finding an element in a list. Counting the number of occurrences
Python lists	List Append (push)	Adds an element to the end of a list
Python lists	List remove (pop)	Removing data from a list
Python lists	Display List Item	Use an index number to display a list item
Python lists	2D List Processing Skeleton	Code to create an empty 2D list Notes: Has an asterisk to denote where the cells are
Python lists	2D List (Variable sized)	Initialise a variable sized 2D list using a comprehension Notes: Uses for loops to control the number of rows and cols in the matrix
Python lists	Finding data in a 2d list	Finding an element in a 2d list. Returns a list of indices where the string was found Notes: only works with strings
Python lists	String to List	Create a list from a word or sentence and reverse back from a list into a word or sentence
Python lists	Largest number in list	Starter code to find the largest number in a list
Python loops	For Loop	simple for loop controlled by a numeric variable
Python loops	For loop with 2D List	Print a 2D list using a for loop
Python loops	While Loop	Loop While a condition is true Notes: the condition is tested at the beginning of the loop and the code may not get executed
Python loops	While Else Loop	Loop While a condition is true, with an else clause after the loop has completed
Python numbers	Extract Number	Extract a number or series of numbers from a text string
Python numbers	Random number	Generate a random number between two values
Python other	Function	Template to define and call a function
Python other	Break	Break from a loop before the end
Python other	Binary Search Starter	Code stub to implement a binary search
Python other	Reverse Programming	Exercises to understand how programs work. Test out the program then add comments to document how logic works and what each of the variables are for. The first exercise has been completed for you as an exemplar. Notes: This is a zip file. When it has downloaded, extract the contents into your development folder.
Python Selection	Largest and smallest numbers	Simple use of If.. Else
Python Strings	Slicing strings	Quick reference to extract various parts of a string
Python strings	Change the case of a string	Change the case of a string
Python strings	Clean a string	Remove whitespace (space and tabs) from the beginning and end of a string
Python strings	Check string for numbers and/or letters	Check string contents for only letters, only numbers or number and letters Notes: when testing for letters the string cannot contain spaces
Python strings	Wrapt Text	Wrap a long line of text by setting the number of columns (characters) to be displayed
Python strings	Split a string	Split a string into parts based on a character in the string
Python strings	Find character(s)	Find a character or string within another string Notes: You can optionally specify the start and end position of the search
Python Turtle	turtle Commands	List of basic turtle commands
Python Turtle	turtle shapes	How to draw basic shapes
Python Turtle	Draw House Starter	Skeleton code to start drawing a house
Python Turtle	DrawHouse	Draw a house Complete Code. The user selects the style of house from a menu
Showcase CA	Code Puzzle	GCSE Controlled Assessment Task to guess the code letters in a series of random words
Showcase CA	Memory Game	GCSE Controlled Assessment Task to guess the words removed and added from a matrix of nine or 16 words displayed at random
Showcase CA	Precious Metals	GCSE Controlled Assessment Task to work out the cost of second hand metals to be brought from a customer
Showcase CA	Encryption	GCSE Controlled Assessment Task to encrypt or decrypt a text file
Showcase CA	Traffic Lights	GCSE Controlled Assessment Task to control the sequence of traffic light using JavaScript
Showcase Challenges	Hello World	Basic program to demo how to start coding
Showcase JSChallenges	Hello User	Programming a simple input
Showcase JSChallenges	Area Calc	Programming a simple input with basic calculation
Showcase JSChallenges	Perimeter Calc	Programming a simple input with basic calculation
Showcase JSChallenges	Biggest Number	Programming using selection
Showcase JSChallenges	Favourite Month	Programming using selection with more options
Showcase JSChallenges	Mini Calculator	Programming using selection and arithmetic
Showcase JSChallenges	Mega Sale	Programming using selection
Showcase JSChallenges	Happy	Programming user input and selection
Showcase JSChallenges	Which Mobile Phone package?	Programming user input and selection and arithmetic
Showcase JSChallenges	Calorie Advisor	Programming user input and selection and arithmetic. Using age and gender works out recommended calorie intake
Showcase JSChallenges	Mobile Phone	Programming user input and selection and arithmetic. Which Mobile Phone package
Showcase JSChallenges	Restaurant Tip	Programming user input and selection and arithmetic. Calculate the tip for a restaurant bill
Showcase JSChallenges	Sports Team	Programming user input and selection and arithmetic. How many volunteers can join the sports team?
Showcase JSChallenges	Login Check	Programming user input and selection
Showcase JSChallenges	Loops	Programming Loops
Showcase JSChallenges	Times Table	Programming using a loop to calculate the times table
Showcase JSChallenges	Treasure Hunt	Create a game to guess where the buried treasure lies
Showcase PHP	Cupcake Bakery	Example of PHP and mySQL to implement a simple shopping site
Showcase PHP	Horoscope	Example of using validation and selection if PHP to create a horoscope program
Showcase Project	Number Conversion	Convert numbers from one base to another
Showcase Project	Fruit Machine	Example of Javascript program to make a fruit machine game
Showcase Python	Paint Calculator	Program to calculate the number of containers of paint required
Software Guides	RAG Rating	RAG your A Level Studies (AQA)
Software Guides	Debug JavaScript in Chrome	Debugging programs with Chrome
VBA arrays	Using 2D Arrays	How to setup and use 2D arrays
VBA arrays	Using 1D Arrays	How to setup and use 1D arrays
VBA arrays	Associative arrays	How to use associative arrays
VBA arrays	Upper or Lower boundary	Find the first or last element in an array Notes: returns an integer value
VBA arrays	Redim an array	Re-size an array. Can increase or reduce the number of elements
VBA CSVFiles	Read CSV file data	How to read a CSV file
VBA CSVFiles	Write CSV file data	How to write a CSV file
VBA Exercises	Loops	Learn how to use loops by creating a series of characters and shapes
VBA Exercises	Decoded	Put the code back together
VBA Exercises	CSV data files	Learn how to read and write data to and from files
VBA Exercises	User Login/registration	Create a user registration and login application. Read and write the data to a CSV file
VBA Files	Read file data	Read data from text file using resource #. Notes: Simpler than FSO
VBA Files	Read file data using FSO	Read data from text files (FSO) Notes: More complicated
VBA Files	Write file data	How to write data to a text file
VBA files	Current folder	get current directory (folder)
VBA Files	File Exists	Test to see if a file exists
VBA loops	For Next Loop	How to setup a For .. Next loop Notes: Controlled by the value of a counter
VBA loops	Do While Loop	How to setup a Do While loop Notes: Test is at the beginning
VBA loops	Repeat until Loop	How to setup a Repeat .. Until loop Notes: Test is at the end
VBA numbers	Random number	Generate a random number between two values
VBA numbers	Number Conversion	Convert from one datatype to another
VBA other	Text Box	Creating and using a text box
VBA other	Message Box	Display output using a message box Notes: You can also get a response from the user by checking which button they clicked
VBA other	Input Box	Simple method to get user input
VBA other	read-write cell data	Read or write data to a cell on a worksheet
VBA Other	Range method	Cell Referencing using ranges
VBA Other	Last used cell	Find last row or column used Notes: This method always returns a number, so column letters are returned as the equivalent number (a=1, b=2 etc)
VBA other	Number to ACSII	Convert a number to an ASCII character
VBA other	ASCIIto number	Convert a character to its ASCII code
VBA other	Image in Cell	Insert an image into a cell
VBA other	Clear a range	Use the range method to change cell contents
VBA other	Clear active range	Find the lastused row and column then use range method to change cell contents
VBA other	Switch Active Worksheet	Switch the active worksheet
VBA other	Background Color by Name	List of color names to be used in VBA code Notes: There is a greater range of colors (56) available by using the color index number
VBA other	Background Color by Number	Set background colour using color.index property Notes: Index numbers range from 1-56
VBA other	Reset Background Color	Clear background color === menu option of no fill
VBA other	Menu	Creating a menu using buttons
VBA other	Simple timer	Simple timer delay. Program stops, waits for the timer to complete then runs another subroutine
VBA other	Timer	Creating a countdown timer
VBA other	Progress indicator	Display progress on status bar at the bottom of the application window
VBA strings	substrings	Substring to return characters from the left, right or middle of a string Notes: returns an string value
VBA strings	Attributes	Find the length of a string and whether a character or string is part of a longer string Notes: These functions return an integer value
VBA strings	Change Case	Change the case of a string to upper, lower or proper case.
Word Word	WP Exercises series 1	Word processing exercises graded with increasing complexity
Word Word	WP Exercises series 2	Word processing exercises graded with increasing complexity
Word Word	WP Exercises series 3	Word processing exercises graded with increasing complexity
Word Word	WP Exercises series 4	Word processing exercises graded with increasing complexity
Word Word	relay	Relay text document for use with WP exercises
Word Word	polinfo	Policy Info document for use with WP exercise
Word Word	Asia image	Map of Asia image