Tag Archives: problem solving

Google Sites gets a +1 from me!

Earlier today (well yesterday as now we are in the wee hours of the morning) I posted a blog about Wikispaces and their new ‘verification’ process. The new process meant the Wikispace I created could only be ‘public’ if I became ‘verified’. As I only have a couple of days to go before my assessment is to be submitted and one of the requirements is a ‘public’ site (in order for my lecturer to be able to mark it), I decided to change where my assessment was to be housed and hoped for a good transition from Wikispaces to Google Sites.

I jumped into the world of Google Sites and created my first wiki inspired site Game Based eLearning Toolkit. There are some cool features in Google Sites, like embedding a Google Calendar, a widget for an Announcement feed (from a particular page of your site), and a little more flexibility on the formatting/layout than with Wiki sites. My only complaint is that it is not easy to embed non-Google products and you are (mostly) forced to use iFrames (that don’t always work in the way I want them to – could be a user issue – needless to say, I didn’t go with iFrames).

Overall though, Google Sites gets a +1 from me! I found it very easy to use and I am sure it has something to do with me being accustomed to Google Docs/Drive that  has very similar navigation/menu traits.

I present to you, my Game Based eLearning Toolkit:


before building a database tips and tricks

On reviewing the subject material for DMT over the past two weeks I have come to think a lot about the practices I do at work when developing databases, requesting quotes for others to create databases and upgrading databases…All fun things to do…but complicated and often you need a working knowledge of the content/data before embarking on such a journey.

I have reviewed my processes and provided a summary list of questions that will better assist me in the workpklace, to assist developers and also to make sure the quote we receive can be better tailored (rather than the quotee having to guess what we may be talking about in a project proposal/plan). Hope they will assist you to.

Databases – Questions to answer and document

1. What are the objectives of the database?

To reduce manual input? To provide an approval process of content? To provide some information about a product/service to the public on a website? To create an authoritative source for staff to access across multiple locations? To store procedures

2. What are the fields/tables of the database?

Data modeling is a great starting point – I found that brainstorming what will be in the tables using a spreadsheet really help when there are multiple people in the process. It provides an opportunity for the developer to think about the type of technology that will best assist and the sheer amount of work required (for example, you may have twenty fields, or two hundred fields – this helps in the quoting process). It will also assist you work out where relationships need to be formed in the table. As time progresses, you may find that the tables / fields evolove. This is a good thing to work out on paper, before you create the database.

My spreadsheet template has the following headings (so you are thinking about the content from the beginning):

  • Field
  • Description
  • Field Content Type (text, memo, numeric, list etc)
  • Options (one, multiple)
  • Content Owner
  • Data Source (if fed from database / source)

3. Where will your data be coming from?

Will you be utilising content from other systems? How will content feed into your database – FTP, CSV upload, manual? What are the fields that will have content fed into them automatically? Note: A flow chart is a great way to open the conversation with a developer.

4. Who will be using your database?

How many administrators will be accessing the database? How many reviewers? What are the admin, reviewers, editors roles? Is a log in required? Is some information for some users, and other information for other users?

5. What reports will you need from the database?

And in what file format? Who will need to access the report

6. Is there any special functionality you require?

Do you want a person to enter a form and then a personalised automatic email / PDF is generated and sent to the person completing the form? Make sure you relate the special functionality back to the objectives.

Bringing it all together!

The final part before sending out to vendors for review and the quoting process is to document Functional Specifications – that will include all of the above, plus wireframes if you have an idea of how you would like the data organised on a page.

Most of all, remember, it is a work in progress and the developer may have some ideas to input in relation to technology platform, table structure, field labels and relationships. Take on the feedback and make a decision based on whether your objectives will still be met if the suggested update is made.

xhtml validation problem solving

I completed an XHTML validation check and was confronted with an error, then as I was updating content, was confronted with other errors – all documented below:

Problem 1:

There is an issue with the analytics code 000webhost automatically applies to each page of your site – it forces your page to not be XHTML compliant.


1. Remove the code by going to: http://members.000webhost.com/analytics.php.

2. If you need statistics of your page, you can manually add the code to the body portion of each page, as suggested at http://asianho.net/html/home.html The difference is in the div tag:

<!– http://www.000webhost.com Analytics Code –>

<div><a href=”http://www.hosting24.com/”><img src=”http://analytics.hosting24.com/count.php” alt=”web hosting” /></a></div>
<!– End Of Analytics Code –>

Problem 2:

The error message: “No character encoding declared at document level”.


As outlined by CodersBarn.Com, add the following code in the header section of the page:

<meta http-equiv=”Content-Type” content=”text/html; charset=utf-8″ />

Problem 3:

Error message: Missing xmlns attribute for element html. The value should be: http://www.w3.org/1999/xhtml


As outlined at http://answers.yahoo.com/question/index?qid=20101106065010AAU1G27, the following code needs to be included:

<html xmlns=”http://www.w3.org/1999/xhtml” xml:lang=”en”>


I have my first validated page!!!