12/27/21, 3:08 PM Module Feedback - SQLZOO
Module Feedback
This system records the responses of students on their learning experience at university.
Most students study three modules every session, they are invited to respond to 19 questions regarding
their experience. For each question, for each student the response can be from 1 (definitely disagree) to 5
(strongly agree).
Contents
Find the student name from a matriculation number
Find the modules studied by a student
Find the modules and module leader studied by a student
Show the scores for module SET08108
Show the frequency chart for module SET08108 for question 4.1
[Link] 1/7
12/27/21, 3:08 PM Module Feedback - SQLZOO
Find the student name from a matriculation number
1.
Find the name of the student with number 50200100
SELECT SPR_FNM1, SPR_SURN
FROM INS_SPR
WHERE SPR_CODE = '50200100';
Submit SQL Restore default
Result:
SPR_FNM1 SPR_SURN
Tom Cotton
Find the modules studied by a student
2.
Show the module code and module name for modules studied by the student with number
50200100 in session 2016/7 TR1
[Link] 2/7
12/27/21, 3:08 PM Module Feedback - SQLZOO
SELECT CAM_SMO.MOD_CODE,INS_MOD.MOD_NAME
FROM INS_MOD JOIN CAM_SMO ON (INS_MOD.MOD_CODE=CAM_SMO.MOD_CODE)
WHERE CAM_SMO.SPR_CODE='50200100'
AND CAM_SMO.AYR_CODE='2016/7'
AND CAM_SMO.PSL_CODE='TR1'
Submit SQL Restore default
Result:
MOD_CODE MOD_NAME
CSN08101 Systems and Services
INF08104 Database Systems
SET08108 Software Development 2
Find the modules and module leader studied by a student
3.
Show the module code and module name and details of the module leader for modules
studied by the student with number 50200100 in session 2016/7 TR1
[Link] 3/7
12/27/21, 3:08 PM Module Feedback - SQLZOO
SELECT CAM_SMO.MOD_CODE, INS_MOD.MOD_NAME,
INS_PRS.PRS_CODE, INS_PRS.PRS_FNM1, INS_PRS.PRS_SURN
FROM CAM_SMO JOIN INS_MOD ON (INS_MOD.MOD_CODE=CAM_SMO.MOD_CODE)
JOIN INS_PRS ON (INS_MOD.PRS_CODE=INS_PRS.PRS_CODE)
WHERE CAM_SMO.SPR_CODE='50200100'
AND CAM_SMO.AYR_CODE='2016/7'
AND CAM_SMO.PSL_CODE='TR1'
Submit SQL Restore default
Result:
MOD_CODE MOD_NAME PRS_CODE PRS_FNM1 PRS_SURN
CSN08101 Systems and Services 40000008 James Jackson
INF08104 Database Systems 40000036 Andrew Cumming
SET08108 Software Development 2 40000408 Neil Urquhart
Show the scores for module SET08108
4.
Show the Percentage of students who gave 4 or 5 to module SET08108 in session 2016/7
TR1
(note that this is not real data, these responses were randomly generated)
[Link] 4/7
12/27/21, 3:08 PM Module Feedback - SQLZOO
SELECT INS_RES.QUE_CODE, QUE_TEXT,CAT_NAME,
ROUND(100*SUM(FLOOR(RES_VALU/4))/COUNT(1)) as score
FROM INS_RES JOIN INS_QUE ON INS_RES.QUE_CODE=INS_QUE.QUE_CODE
JOIN INS_CAT ON INS_QUE.CAT_CODE=INS_CAT.CAT_CODE
WHERE INS_RES.MOD_CODE='SET08108'
AND INS_RES.AYR_CODE='2016/7'
AND INS_RES.PSL_CODE='TR1'
GROUP BY QUE_CODE,QUE_TEXT,CAT_NAME
Submit SQL Restore default
Result:
QUE_CODE QUE_TEXT CAT_NAME score
1.1 Staff are good at explaining Learning and 89
things. Teaching
1.2 Staff made the subject Learning and 82
interesting. Teaching
1.3 The module was Learning and 82
intellectually stimulating. Teaching
1.4 The aims and objectives Learning and 89
were clearly stated. Teaching
1.5 The module was well- Learning and 78
organised and ran Teaching
smoothly.
1.6 The pace was appropriate. Learning and 80
Teaching
1.7 The level was appropriate. Learning and 82
Teaching
1.8 The workload was Learning and 78
managable. Teaching
1.9 I was able to contact Learning and 76
module staff when I needed Teaching
to.
2.1 The assessment Assessment 84
requirements were clearly and
stated. Feedback
2.2 The criteria for marking was Assessment 82
made clear to me. and
Feedback
2.3 I was well supported for the Assessment 80
assessment. and
Feedback
2.4 I was provided with Assessment 80
[Link] 5/7
12/27/21, 3:08 PM Module Feedback - SQLZOO
feedback that aided and
understanding. Feedback
2.5 Feedback was provided Assessment 80
within three weeks of and
submission. Feedback
3.1 The module was well Learning 73
supported by moodle. Resources
3.2 The library resources met Learning 82
my needs. Resources
3.3 The IT resources met my Learning 89
needs. Resources
3.4 The rooms/facilities were of Learning 78
good quality. Resources
4.1 I was statisfied with the Overall 89
module.
Show the frequency chart for module SET08108 for question
4.1
5.
For each response 1-5 show the number of students who gave that response (Module
SET08108, 2016/7, TR1)
(note that this is not real data, these responses were randomly generated)
SELECT MOD_CODE,RES_VALU,COUNT(1)
FROM INS_RES
WHERE INS_RES.MOD_CODE = 'CSN08101'
AND INS_RES.AYR_CODE='2016/7'
AND INS_RES.PSL_CODE='TR1'
AND INS_RES.QUE_CODE='4.1'
GROUP BY MOD_CODE, RES_VALU
Submit SQL Restore default
[Link] 6/7
12/27/21, 3:08 PM Module Feedback - SQLZOO
Result:
MOD_CODE RES_VALU COUNT(1)
CSN08101 2 16
CSN08101 4 15
CSN08101 5 46
Retrieved from "[Link]
This page was last edited on 20 March 2017, at 12:47.
[Link] 7/7