AnsweredAssumed Answered

Test Export Formatting

Question asked by Ian Holder on May 4, 2018
Latest reply on May 16, 2018 by Ian Holder

Hello Educators and Instructional Designers,

 

Just a question on the formatting of a Test's results when you download them from the Grade Centre.  I was asked by a department to analyse the results of weekly quizzes over 3 terms for 3 courses, to look for patterns, etc.

 

The downloads seem to come in all sorts of formats.  For example, one weekly quiz has an answer column like:

 

<span style="font-family: arial,helvetica,sans-serif; font-size: small;">somewhat relevant</span>

 

another has:

 

somewhat relevant </br>

 

and yet another has:

 

<p style="margin: 0px 0px 0.0001pt; padding: 0px; border: 0px; outline: 0px; font-weight: normal; font-style: normal; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: small; color: #000000; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; line-height: normal;"><span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-weight: inherit; font-style: inherit; font-family: Verdana, sans-serif; font-size: medium; color: #111111;">somewhat relevant             </span></p>  <p style="margin: 0px 0px 0.0001pt; padding: 0px; border: 0px; outline: 0px; font-weight: normal; font-style: normal; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: small; color: #000000; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; line-height: normal;"><span style="margin: 0px; padding: 0px; border: 0px; outline: 0px; font-weight: inherit; font-style: inherit; font-family: Verdana, sans-serif; font-size: medium; color: #111111;"> </span></p>  <p style="margin: 0px 0px 0.0001pt; padding: 0px; border: 0px; outline: 0px; font-weight: normal; font-style: normal; font-family: 'Helvetica Neue', Helvetica, Arial, sans-serif; font-size: small; color: #000000; font-variant-ligatures: normal; font-variant-caps: normal; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; white-space: normal; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-style: initial; text-decoration-color: initial; line-height: normal;"></p>

 

And sometimes I get it between words:

 

not relevant at all 

 

 

Because I'm a lazy data analyst I'd like to get the data as clean as possible.  I thought I was downloading these the same way (Download Results | Select .csv ... )   Is there something I am doing wrong?  Is it the way the quiz is set up?  Given students select a response rather than typing one I'm not sure it could be them, but perhaps it is their browser?  I generally get the same formatting but occasionally I have got example 1 above and a longer example 1 with more HTML [not as much as 3!] interspersed in the same column in the one test download...

 

Thanks for any help,

Ian.

Outcomes