Browsing all articles in ICT & e-Learning

I’m positing this since it may help someone out there in the ether….!!

This became a serious headache while as was using Tableau since the dates were all formatted US style. The ones which were ok in the UK were still wrong even though Excel thought they were dates. What a mess…. After 8 hours of stress I managed to find / create the following VBA macro which kinda works !! Yippee…

Option Explicit

Sub ConvertDateToUK()

‘ ConvertDateToUK Macro

Dim theDay As String
Dim theMonth As String
Dim nStartOfSecondPart As Integer
Dim nEndOfSecondPart As Integer
Dim nLength As Integer
Dim sValue As String
Dim sFirstPart As String
Dim sSecondPart As String
Dim sRest As String

Dim c As Range

For Each c In ActiveSheet.UsedRange.Columns(“R”).Cells

If (c.Row <> 1) And (Trim(c.Value) <> “”) Then

sValue = CStr(c.Value)
nLength = Len(sValue)

nStartOfSecondPart = InStr(1, sValue, “/”)
nEndOfSecondPart = InStr(nStartOfSecondPart + 1, sValue, “/”)

sFirstPart = Mid(sValue, 1, nStartOfSecondPart – 1)
sSecondPart = Mid(sValue, nStartOfSecondPart + 1, nEndOfSecondPart – nStartOfSecondPart – 1)

sRest = Mid(sValue, nEndOfSecondPart, Len(sValue) – nEndOfSecondPart + 1)

c.Value = “”

c.NumberFormat = “@”

c.Value = sSecondPart + “/” + sFirstPart + sRest

c.NumberFormat = “dd/mm/yyyy h:mm:ss AM/PM”

End If

Next c

‘sValue = ActiveCell.Value
‘MsgBox CStr(ActiveCell.Value)

‘nLength = Len(ActiveCell.Value)

‘nStartOfSecondPart = InStr(1, ActiveCell.Value, “/”)
‘nEndOfSecondPart = InStr(nStartOfSecondPart + 1, ActiveCell.Value, “/”)

‘sFirstPart = Mid(sValue, 1, nStartOfSecondPart – 1)
‘sSecondPart = Mid(sValue, nStartOfSecondPart + 1, nEndOfSecondPart – nStartOfSecondPart – 1)

‘sRest = Mid(sValue, nEndOfSecondPart, Len(sValue) – nEndOfSecondPart + 1)

‘MsgBox (sFirstPart)
‘MsgBox (sSecondPart)
‘MsgBox (sRest)

End Sub


Who’s the Diva?


Instructional design models can be confusing since they seem more like process models and could be simply labelled as instructional design methods as defined by McGriff (2001) “systematic guidelines instructional designers follow in order to create a workshop, a course, a curriculum, an instructional program, or a training session”. These models are more of an adapted development life cycle for e-Learning with a flavour of instructional design involved where educational theories should be applied to ensure learning objectives are met. Read more »


Is your Organisation ready ?

Baby on elearningAlong with all the practical aspects of creating an enterprise eLearning strategy I’ve come to realise getting an organisation to move forward and adapt is a difficult endeavour especially when the bulk of personnel in Learning and Development are stuck on the old ways.
Read more »


Evolution of SCORM

Designing and developing eLearning is difficult enough but when it comes to explaining the technology which allows communication between the content and the LMS most eLearning and training professionals fall short of being able to understand it let alone explain the intricacies of the way this happens. Read more »


Tell, show and do – kinda of matches the typical PPP process of present, practice and produce and is just as applicable to online learning objects as it is to the classroom face to face situation. High quality learning can be achieved using learning objects and student interaction and response can be positive especially when coupled with high levels of motivation. The tell, show and do model of LO development is detailed in a particularly insightful paper written by Salas, K. & Ellis, L. (2006). Read more »


Old Skool !

With all the fancy tools and all the new technology both social and interactive trainers and teachers out there need to be careful not to let their classroom quality slip. We all want more tech stuff (do we?) that can help us do things faster but real good instruction is real good instruction – old skool style !
Read more »


OER and the Future of University Education

OER – Open Educational Resources are growing and yet we’re still trying to understand the problems that they can solve and how they’ll effect teaching. Educational Resources can be defined as anything that can be used for teaching or learning in any format which is not necessarily electronic. Read more »


Learning Objects: A Quick Overview

Have you heard about OERs?  That’s Open Educational Resources… wow – there are terms for everything – and I thought it was just a worksheet !!! Now imagine a world where everyone is willing to share their knowledge, a world where we can reuse educational resources as needed – modifying, merging and integrating without restrictions or costs – I know I can hear you say – there’s no way anyone’s going to share their hard work.  Even if they did there’ll be legal licensing issues ( for sure some benefit to the sharer) , technical issues (it probably won’t run) and educational issues ( my standards are higher – I want the learner to learn !!)

Read more »


Recently watched a presentation on mass collaboration by the Wikinomics author Anthony Williams.Future of Collaboration.
Read more »


Augmenting Human Learning and Intellect

Isn’t that what its all about. How can we help ourselves to learn better, more efficiently to raise our levels of intellect? The subject raised its head as far back as 1962 by Engelbart who proposed some incredibly accurate techniques which only became reality once technology had caught up with his thinking. Read more »

Random Testimonial

  • ~ Watt Gilchrist

    Watt Gilchrist"All tasks were approached with a high degree of professionalism. By gaining a good understanding of the business Mohammed approached the project in an open manner interacting and communicating well. A successful project with a superb handover.(P. Hinchliffe, Watt Gilchrist, Leeds,"

  • Read more testimonials »

Fatal error: Call to undefined function aktt_sidebar_tweets() in H:\hshome\geniserv\\wp-content\themes\wisebusiness\sidebar.php on line 41