Snapshot use of VLE (LearnUCS): Identifying the sample size

For noting, we’ve have identified 745 modules on LearnUCS which are classified as active during 2012/13. The definition of active is the course is set as available (the default at UCS is unavailable) and has a person enrolled as an instructor (we do not auto enrol instructors / lectures on courses at UCS).

The sample size (95% confident, +/- 5%) is 254 (based on

To identify the courses which will form this statistically significant sample population I’ve used the following condition in Google Spreadsheet to randomly select 245 rows (module IDs) from the 745 rows (module IDs). This will create the random sample:

=ArrayFormula(FILTER( SORT(‘Sheet1’!A1:A745;RANDBETWEEN( 0+ROW(‘Sheet1’!A:A) ; ROWS(‘Sheet1’!A:A)); TRUE); ROW(‘Sheet1’!A:A)<=254))

The data collection work has been allocated to week commencing 19th August (approximately 50 modules per day)

For more info read


Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )


Connecting to %s