Quiz email results

Hi all,

I have built a quiz using the Articulate Quiz-maker which consists of multiple choice, TRUE/FALSE, click on the hot-spot, fill in the blank questions etc. Now as a test, I done this quiz on our LMS and then at the end, emailed the results to a pre-designated email address (to my manager) but he got the following:-

Quiz Results=

Status, Raw Score, Passing Score, Max Score, Min Score, Time

passed,21,20,25,0,10:50:00

Date, Time, Score, Interaction ID, Objective Id, Interaction Type, Student Response, Result, Weight, Latency

6/4/2014,10:47:10,1,Ib3287331-fec3-4ceb-8986-5661b77b4f21,Question1_1,multiplechoice,Houses in Multiple Occupation,correct,1,7260 6/4/2014,10:47:18,1,Iea6d39fc-66d0-400e-ad5b-d3cf66b64f84,Question2_1,multiplechoice,Gives Local Housing Authorities (LHA) extensive duties and powers to remedy hazards within residential properties.,correct,1,5840 6/4/2014,10:47:28,0,Ida822978-45ec-43f6-9d50-00e3f780dda3,Question3_1,multiplechoice,To allow housing inspectors to hand out prohibition orders to landlords whose properties represent a significant fire risk to their respective occupants.,wrong,1,8415

6/4/2014,10:47:33,0,I15169af8-7862-47d3-b3b4-279ba4de81fe,Question4_1,truefalse,YES,wrong,1,3449

6/4/2014,10:47:39,1,I797b8b05-3ec7-4dae-b1ba-4fa8bb557cab,Question5_1,multipleresponse,The Local Housing Authority|#|The Fire Rescue Authority,correct,1,5087

6/4/2014,10:47:46,1,Idbeca208-4492-4e33-9e57-e2ea8e4d17da,Question6_1,multiplechoice,FRA,correct,1,4401

6/4/2014,10:47:52,1,Ib4b92ffc-5f0d-4d60-afe2-8805b783cfd3,Question7_1,matching,A Hotel|#|FRA|#|A self contained flat that has been constructed for that purpose|#|LHA,correct,1,4008

6/4/2014,10:47:56,1,I4e6e861e-a7af-4356-8bc8-06563990ae96,Question8_1,multiplechoice,5 years with a £5000 fine,correct,1,2770 6/4/2014,10:48:05,1,I48763e0f-8593-4e41-91cf-33f2d4563cdc,Question9_1,multipleresponse,Consisting of three or more storeys |#|Being occupied by five or more tenants in two or more households,correct,1,7214 6/4/2014,10:48:12,1,I9f687535-8f91-40fd-bf5b-80b75739f26c,Question10_1,multiplechoice,If planning permission has been obtained for the conversion of the HMO back to a house occupied as a single private dwelling. The TEN is normally only granted for a maximum of three months, unless in exceptional circumstances, LHA may issue a second TEN to last a further three months. ,correct,1,4597 6/4/2014,10:48:18,1,Ic5ca88ed-0e09-4fe4-bb6b-0b2010f5532a,Question11_1,multiplechoice,A building converted into self-contained flats before the 1991 Building Regulations and does not meet those standards.

It may have been converted without permission.,correct,1,4380

6/4/2014,10:48:24,1,Ibe2d0a56-fdbd-4b3e-8e24-3900780c5956,Question12_1,multiplechoice,34.8%,correct,1,4280

6/4/2014,10:48:27,1,I0f203de3-ba1f-4f96-8410-c0d369847ec0,Question13_1,truefalse,True,correct,1,2188

6/4/2014,10:48:44,1,If0ac61ec-ac80-4226-bd0a-6356fc532c30,Question14_1,multiplechoice,Replace portable heating appliances with fixed convector heaters or a central heating system.,correct,1,13777 6/4/2014,10:48:53,1,Ie7fd214c-2762-46b4-957e-d7053c39737b,Question15_1,multipleresponse,The system is linked to a fire alarm indicator panel.|#|The system indicates exactly where the fire is.,correct,1,7494 6/4/2014,10:48:57,1,I4ccf540a-96cb-4c4e-80b8-315d63560e42,Question16_1,multiplechoice,See that all furniture complies with the Furniture and Furnishings (Fire)(Safety) Regulations 1988.,correct,1,2241

6/4/2014,10:49:01,1,Id7688b91-f12b-43f5-9fdc-f5f9002b0141,Question17_1,multiplechoice,30-60 minutes,correct,1,2576 6/4/2014,10:49:14,0,I0e9bf48d-3edb-468d-bd75-57b338463acb,Question18_1,multipleresponse,Electrical cables being run under carpets or near to dangerous hazards e.g. a heat source.|#|Electrical products not being checked to see if they are on trading standards product recall list, a list of items which have been recalled by the manufacturers.,wrong,1,11618

6/4/2014,10:49:21,1,Ie9ac548b-1507-4e0d-b2ff-597761266f75,Question19_1,truefalse,YES,correct,1,5759

6/4/2014,10:49:31,1,Iad2dae8a-2e3d-438d-8d91-a62b0a2428e6,Question20_1,multipleresponse,A maintenance man working in an isolated part of the building.|#|People with mobility problems.|#|A person with learning difficulties.,correct,1,8345 6/4/2014,10:49:42,0,I771b189e-a956-4ae1-906f-afc67ee7b2a8,Question21_1,multipleresponse,Openable from the inside without the use of a removable key and the ground below is level and free of obstructions.|#|In possession of an openable area, the bottom of which should not be more than 1,100mm above the floor.|#|Be at least 450mm high and 450mm wide.,wrong,1,8673

6/4/2014,10:49:45,1,I930b8ad7-4639-4535-9f8c-d176a9bb3fa8,Question22_1,hotspot,b5ad24c0-1c60-485b-aac0-5ffc0c23a2d8,correct,1,1828

6/4/2014,10:49:49,1,I84d326b5-3b24-4342-9bb9-18ac1548d546,Question23_1,hotspot,91add846-82e5-417b-90d5-787714eaf277,correct,1,1206

6/4/2014,10:49:56,1,Iecc670b7-6fc0-4636-8c31-d7c1c034eacf,Question24_1,hotspot,35e76769-ed53-431a-b2fb-b72fbb03f295,correct,1,5668

6/4/2014,10:49:59,1,I4b2d7e3e-4b62-48d9-86c5-e13641b1ca2a,Question25_1,hotspot,e5769a1d-0934-4ad9-a9db-af2e49b30c4f,correct,1,2085

I think my manager might get confused with this...

NOW, I see that these values are separated by COMMAS. Is it possible to convert this into either an EXCEL or CSV file where these values are separated into COLUMNS under the headings:-

Date, Time, Score, Interaction ID, Objective Id, Interaction Type, Student Response, Result, Weight, Latency

ETC

I have marked these in ABOVE in BOLD so that this file is clear?

I look forward to hearing from you.

My email is:-

keith_trodden@yahoo.com

Thanks in advance.