MS Office Skills Test - Word, Excel, PowerPoint

MS Office Skills Test - Word, Excel, PowerPoint

by Joe Hardy -
Number of replies: 5

Hi All

I am developing a basic course for MS Office users for Word, Excel and PowerPoint. At the end of each course I would like participants to take a test which is skills based - not just multiple choice and the standard quiz formats.

I have seen some Office tests online that ask the candidates to complete tasks using either a cloud version of Office or loading Office on the local PC.

For example, a candidate might be asked to format the title of a document. The testing software would load Office and monitor key clicks, and score the effort.

Has anyone any experience with this type of testing? I realise that this is ambitious and may well be beyond my ability but any advice or pointers would be gratefully received.

Thanks

Joe

Moodle 3.5

Using Office 2016 locally

Average of ratings: -
In reply to Joe Hardy

Re: MS Office Skills Test - Word, Excel, PowerPoint

by Colin Fraser -
Picture of Documentation writers Picture of Testers

This sort of skill testing has always been difficult to authenticate in an online environment. The question is whether the person logging in, is the same person who is enrolled. Without the usually expensive and often tempramental software, it is hard to ensure the candidate is the right person. 

What is the targeted environment? Business, College, Training school, University, Secondary School? Or is it all online, a remote learning situation? Each situation has some benefits that can lend themselves to a partial solution, and that is all it is, a partial solution, because nothing is guaranteed. All I have usually relied upon is the honesty of the candidate, which is easy to ensure if I am the Invigilator. I have used email to provide a code to access an activity, but not in Moodle, (don't know if that one would even fly in Moodle). With online things, it is even more difficult. In these things, there is likely no right answer,  I don't think I have one, someone else may have something. 

However, having said that, mostly remote students use laptops, with webcams. The testing software could include a photo if the Candidate, taken at the time of testing. Things like keystroke loggers and that are not just an intrusion on people, they are an outright threat and I would never suggest they be used at any time. I expect that anything that does that will be outlawed in the EU soon anyway, if not already, so I wouldn't go there. Other countries will follow suit, I expect. 


 

In reply to Colin Fraser

Re: MS Office Skills Test - Word, Excel, PowerPoint

by Joe Hardy -

Hi Colin

Many thanks for the reply. This is a course I use at university.

What I would like to achieve is to control Office software from within moodle. So, for example, I want to have a question that asks the student to open a new blank document in Word. The question is in moodle and Word is opened witjin the screen and the student then selects open blank document - Word does this and the the question is marked as correct.

Or in Excel the question might be sum the column from a1:a10 - moodle opens a prepared spreadsheet and the candidates uses the sum function and the question is marked as correct.

We have licensed copies of Office on all testing computers and I think we have access to Office 365 - so either the software is opened locally on the machine or in the cloud. I'm not sure of the licensing using the could though.

I think this is very ambitious but just wondered if there was a way to do it. Or if someone had experience with this style of skills based test.

Thoughts and comments most welcome - I sort of expect that it is not possible but have my fingers crossed smile

Thanks

In reply to Joe Hardy

Re: MS Office Skills Test - Word, Excel, PowerPoint

by AL Rachels -
Picture of Core developers Picture of Particularly helpful Moodlers Picture of Plugin developers Picture of Testers

I used to teach office applications and never bothered to try and automate document evaluations via quizzes the way you mention. I did use multiple choice question based quizzes for making sure they knew office applications vocabulary, tools, locations of items on menus, etc. But, when I wanted to see a student, "format the title of a document," I had them create a whole document and submit it in an assignment. The built in capability of Moodle to convert files to PDF's was very handy and allowed me to mark up their submissions, just as I would if they had submitted the assignment as hard copy on paper. When I bought myself a tablet with pen, it just got even easier to grade.

Being a middle school teacher, I also converted to using the free Open Office/LibreOffice so that any of my students could practice at home without having to try to convince their parents to throw money away on M$ Office. I actually had many students who later took college MS Office classes and used LibreOffice for all the work as each application, Writer, Calc, Impress, etc. could save in Office format or export as a PDF.

As an added bonus, since LibreOffice also included LO Draw, I introduced them to how simple it was to make their own vector graphic pictures.

In reply to AL Rachels

Re: MS Office Skills Test - Word, Excel, PowerPoint

by Joe Hardy -

Thanks AL - good points. Basically this is what I have been doing in the past but wanted to explore the possibilities of automation

I have used libre office as well and agree with you regarding the "throwing away money" - hopefully corporates will wake up to the fact that libre is as good as office and I will not be compelled to use "over-rated" software smile Linux + Libre is a winning combination....



In reply to Joe Hardy

Re: MS Office Skills Test - Word, Excel, PowerPoint

by Stelios Lambropoulos -

Hi all,

We are currently developing a system like the one Joe Hardy is asking for.

We have Office tests both for the online version of Office and for their desktop versions.

As Joe described, the student is asked to perform an action or actions on a document and/or spreadsheet and then our software checks the document (it doesn’t monitor key clicks) and grades the student’s answer.

AL Rachels, we also have the same software for Apache OpenOffice (https://www.test4u.eu/en/e-tests/apache-openoffice) and LibreOffice(https://www.test4u.eu/en/e-tests/libreoffice/).

But what Joe needs is a way to integrate this to moodle.

This feature is almost ready. The teacher will be able to assign certain questions to its students from our vast list of questions (almost 40000 in total). Then the students will solve the questions and they will be automatically graded from TEST4U. The results will be send back to the teacher instantly and shown in moodle. We are in the process of making this whole process fully SCORM compatible in order to be able to integrate it to every SORM compatible system out there.

As far as the testing system that Colin Fraser talked about for remote examination without keyloggers, this is an almost completed project as well.

We have implemented the process of taking photo of the student, in random intervals, which ensures he/she is in front of the PC during the exam and we have taken it a step further. We are able to monitor if there are any remote-control software operated on the student’s PC (such as remote desktop or Teamviewer), which would mean that someone else is taking the exam instead of the student and stop the examination process.

You should expect these pretty soon, but meanwhile you can take a look in TEST4U which will be the main part of both of these applications.

https://www.test4u.eu/

For a limited time TEST4U is completely free for all educational institutes, which means that any teacher in a school, college or university can provide it to their students for free until the end of 2018.

Just follow the link: https://www.test4u.eu/en/free-test4u-1