NSS Tutorial

Field	Type
ukprn	varchar(8)
institution	varchar(100)
subject	varchar(60)
level	varchar(50)
question	varchar(10)
A_STRONGLY_DISAGREE	int(11)
A_DISAGREE	int(11)
A_NEUTRAL	int(11)
A_AGREE	int(11)
A_STRONGLY_AGREE	int(11)
A_NA	int(11)
CI_MIN	int(11)
score	int(11)
CI_MAX	int(11)
response	int(11)
sample	int(11)
aggregate	char(1)

National Student Survey 2012

The National Student Survey http://www.thestudentsurvey.com/ is presented to thousands of graduating students in UK Higher Education. The survey asks 22 questions, students can respond with STRONGLY DISAGREE, DISAGREE, NEUTRAL, AGREE or STRONGLY AGREE.

The table nss has one row per institution, subject and question.

Check out one row

The example shows the number who responded for:

• question 1
• at 'Edinburgh Napier University'
• studying '(8) Computer Science'

Show the the percentage who STRONGLY AGREE

SELECT response
  FROM nss
 WHERE question='Q01'
   AND institution='Edinburgh Napier University'
   AND subject='(8) Computer Science'

SELECT A_STRONGLY_AGREE
  FROM nss
 WHERE question='Q01'
   AND institution='Edinburgh Napier University'
   AND subject='(8) Computer Science'

Calculate how many agree or strongly agree

Show the institution and subject where the score is at least 100 for question 15.

SELECT response
  FROM nss
 WHERE question='Q01'
   AND institution='Edinburgh Napier University'
   AND subject='(8) Computer Science'

SELECT institution, subject
  FROM nss
 WHERE question='Q15'
   AND score>=100

Unhappy Computer Students

Show the institution where the score for '(8) Computer Science' is less than 50 for question 'Q01'

SELECT institution
  FROM nss
 WHERE question='Q01'
   AND institution='Edinburgh Napier University'
   AND subject='(8) Computer Science'

SELECT institution
  FROM nss
 WHERE question='Q01'
   AND score<500
   AND subject = '(8) Computer Science'