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
|
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. |
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. |
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. |
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. |
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: |
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 |