Difference between revisions of "NSS Tutorial"

From SQLZOO
Jump to: navigation, search
(Unhappy Computer Students)
(Unhappy Computer Students)
Line 92: Line 92:
 
   AND score<50
 
   AND score<50
 
   AND subject = '(8) Computer Science'
 
   AND subject = '(8) Computer Science'
 +
</source>
 +
</div>
 +
 +
==Unhappy Computer Students==
 +
<div class='qu'>
 +
<p class='imper'>Show the total number of students who responded to question 22 for the subject '(8) Computer Science' show the same figure for the subject '(H) Creative Arts and Design'.
 +
</p>
 +
 +
<source lang='sql' class='def'>
 +
SELECT institution,score
 +
  FROM nss
 +
WHERE question='Q15'
 +
  AND institution='Edinburgh Napier University'
 +
  AND subject='(8) Computer Science'
 +
</source>
 +
 +
<source lang='sql' class='ans'>
 +
SELECT subject, SUM(response)
 +
  FROM nss
 +
WHERE question='Q22'
 +
  AND subject IN ('(H) Creative Arts and Design','(8) Computer Science')
 
</source>
 
</source>
 
</div>
 
</div>

Revision as of 16:18, 10 December 2012

FieldType
ukprnvarchar(8)
institutionvarchar(100)
subjectvarchar(60)
levelvarchar(50)
questionvarchar(10)
A_STRONGLY_DISAGREEint(11)
A_DISAGREEint(11)
A_NEUTRALint(11)
A_AGREEint(11)
A_STRONGLY_AGREEint(11)
A_NAint(11)
CI_MINint(11)
scoreint(11)
CI_MAXint(11)
responseint(11)
sampleint(11)
aggregatechar(1)

Contents

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 and score where the score for '(8) Computer Science' is less than 50 for question 'Q15'

SELECT institution,score
  FROM nss
 WHERE question='Q15'
   AND institution='Edinburgh Napier University'
   AND subject='(8) Computer Science'
SELECT institution, score
  FROM nss
 WHERE question='Q15'
   AND score<50
   AND subject = '(8) Computer Science'

Unhappy Computer Students

Show the total number of students who responded to question 22 for the subject '(8) Computer Science' show the same figure for the subject '(H) Creative Arts and Design'.

SELECT institution,score
  FROM nss
 WHERE question='Q15'
   AND institution='Edinburgh Napier University'
   AND subject='(8) Computer Science'
SELECT subject, SUM(response)
  FROM nss
 WHERE question='Q22'
   AND subject IN ('(H) Creative Arts and Design','(8) Computer Science')
Personal tools
Namespaces

Variants
Actions
Reference
Toolbox
Google AdSense