| Module Code | STU33003 |
| Module Name | Software Applications III – B |
| ECTS Weighting[1] | 5 ECTS |
| Semester taught | Semester 2 |
| Module Coordinator/s | Assistant Professor Aideen Keaney |
Module Learning Outcomes:
On successful completion of this module, students will be able to:
LO1. Write database queries using SQL
LO2. Create online databases with PHP and MySQL.
LO3. Pre-process data, carry out exploratory data analysis (EDA) and develop
data visualisations using Python
LO4. Build dashboards using a number of data visualisation tools.
LO5. Work independently and also as part of a team to develop software
solutions.
LO6. Work with written and oral descriptions of software application
problems and apply suitable tools to build solutions.
LO7. Source relevant reference material to help in solving software issues.
LO8. Participate effectively in group discussions on technical issues and
problems.
LO9. Produce, test and implement suitable software solutions.
Module Content
This module will give students experience in client server database technologies. The module will introduce students to writing database queries using SQL. HTML and PHP will be used to develop user front ends to these databases. The module will introduce students to the data handling and analysis functionality of Python. The module will also introduce students to data visualisation using QlikSense.
Teaching and learning Methods
This module is a practical computer based module. Students are given notes that encourage self paced learning. Interaction with the module instructor and peers is encouraged..
Assessment Details
This module is entirely examined by continuous assessment. Students are expected to obtain a passing grade of 40% in the coursework
| Assessment Component | Brief Description | Learning Outcomes Addressed | % of total | Week set | Week Due |
| Assignment 1 – Semester 1 | Individual SQL Project 1 | L01, L07 | 5% | 3 | 4 |
| Assignment 2 – Semester 1 | Individual SQL Project 2 | L01, L06, L07 | 20% | 4 | 6 |
| Assignment 3 – Semester 1 | Individual PHP My SQL Database Project | L01, L02, L06, L07, L09 | 25% | 9 | 12 |
| Assignment 4 – Semester 2 | Group PHP My SQL Database Project | L01, L02, L05, L06, L07, L08, L09 | 25% | 1 | 5 |
| Assignment 5 – Semester 2 | Group Python Project | L03, L04, L05, L06, L07, L08. L09 | 25% | 6 | 12 |
Reassessment Details
Supplementary coursework (100%)
Contact Hours and Indicative Student Workload
| Contact Hours (scheduled hours per student over full module), broken down by: | 54 hours |
| Lecture | 44 hours |
| Laboratory | 0 hours |
| Tutorial or seminar | 10 hours |
| Other | 0 hours |
| Independent study (outside scheduled contact hours), broken down by: | 170 hours |
| Preparation for classes and review of material (including preparation for examination, if applicable | 20 hours |
| completion of assessments (including examination, if applicable) | 150 hours |
| Total Hours | 224 hours |
Recommended Reading List
Module Pre-requisites
Prerequisite modules: ST1001 – Software Applications I & ST2001 – Software
Applications II
Other/alternative non-module prerequisites: e.g. basic programming knowledge
Module Co-requisites
None