Expressing colors in CSS
This article is a follow up to Expressing colors in HTML and is part of a series of posts aiming at helping learners transition from HTML to HTML and CSS.…
Writing your PAT summaries
You must create a summary for each of your 10 (or more) sources. Summarise the web page, do not answer the question. Ensure that your summaries will enable you to…
UPDATE query to split values in a field into 2 fields
We covered the Excel solution to this post’s scenario in the post Cleaning data in Excel. Using exactly the same logic and almost identically named Access functions, we can create…
Create and add a favicon to your website
A “favicon” is the little icon that appears in various places in your browser & if a favicon is available it will replace the standard Firefox / Microsoft / Safari…
Advanced criteria in Excel logic functions
This solution was arrived at whilst doing some advanced analysis for a Matric PAT where data from a Google Form questionnaire is being analysed. A closed question required respondents to select 3 of…
Text mask effect in PowerPoint
PowerPoint presentations are often the target of derision. This is largely due to people misunderstanding the effective use of the software and/or creating boring presentations that have been seen before.…
Using an Excel function as part of another function
Using one Excel function as an argument for a second Excel function is an important skill to master. This process can become fairly complex, for example, a Nested-IF statement. Here…
Using Excel’s COUNTIF function
Below is a simple, self-explanatory example of using the COUNTIF function to evaluate a range of data. The COUNTIF function counts the number of values in a range of cells…
The <img> tag
The WWW is largely a visually rich experience. A single HTML web page can be (and usually is) made up of more than just one single HTML file. The page often includes…