Difference between revisions of "NSS Tutorial"
(→More Computing or Creative Students?) |
(→More Computing or Creative Students?) |
||
| Line 114: | Line 114: | ||
<source lang='sql' class='ans'> | <source lang='sql' class='ans'> | ||
SELECT subject,SUM(score) | SELECT subject,SUM(score) | ||
| + | FROM nss | ||
| + | WHERE question='Q22' | ||
| + | AND subject IN ('(8) Computer Science','(H) Creative Arts and Design') | ||
| + | GROUP BY subject | ||
| + | </source> | ||
| + | </div> | ||
| + | |||
| + | |||
| + | ==Strongly Agree== | ||
| + | <div class='qu'> | ||
| + | <p class='imper'>Show the total number of students who A_STRONGLY_AGREE to question 22 for the subject '(8) Computer Science' show the same figure for the subject '(H) Creative Arts and Design'. | ||
| + | </p> | ||
| + | |||
| + | <div class='hint' title='HINT'> | ||
| + | You will need to use SUM and GROUP BY. | ||
| + | </div> | ||
| + | |||
| + | <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(score*A_STRONGLY_AGREE/100) | ||
FROM nss | FROM nss | ||
WHERE question='Q22' | WHERE question='Q22' | ||
Revision as of 15:46, 10 December 2012
| 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) |
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'
More Computing or Creative 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'.
You will need to use SUM and GROUP BY.
SELECT institution,score FROM nss WHERE question='Q15' AND institution='Edinburgh Napier University' AND subject='(8) Computer Science'
SELECT subject,SUM(score) FROM nss WHERE question='Q22' AND subject IN ('(8) Computer Science','(H) Creative Arts and Design') GROUP BY subject
Strongly Agree
Show the total number of students who A_STRONGLY_AGREE to question 22 for the subject '(8) Computer Science' show the same figure for the subject '(H) Creative Arts and Design'.
You will need to use SUM and GROUP BY.
SELECT institution,score FROM nss WHERE question='Q15' AND institution='Edinburgh Napier University' AND subject='(8) Computer Science'
SELECT subject,SUM(score*A_STRONGLY_AGREE/100) FROM nss WHERE question='Q22' AND subject IN ('(8) Computer Science','(H) Creative Arts and Design') GROUP BY subject
