| Module Code | STU2201A |
| Module Name | Software Applications II |
| ECTS Weighting[1] | 5 ECTS |
| Semester taught | Semester 2 |
| Module Coordinator/s | Michael Walsh, Fergal Shevlin |
Module Learning Outcomes
On successful completion of this module, students will be able to:
LO1. Develop software solutions with the following tools:
• Microsoft Access
• Python with Pandas for data manipulation and analysis.
• Git for revision control and more.
LO2. Work independently and as part of a team to develop software solutions.
LO3. Work with written and oral descriptions of software application problems
and apply suitable tools to build solutions.
LO4. Source relevant reference material to help in solving software issues.
LO5. Participate effectively in group discussions on technical issues and
problems.
LO6. Produce, test and implement suitable software solutions.
Module Content
The module will introduce students to database technology using Microsoft Access. In addition they will further develop their programming skills using Python.
Teaching and learning Methods
This is a computer laboratory-based module. Students are given notes that encourage self-paced learning. Interaction with the module instructor and peers is encouraged. This module is entirely examined by continuous assessment. Over the year students’ hand in approximately 10 assignments, comprising some individual and some group work.
Assessment Details
| Assessment Component | Brief Description | Learning Outcomes Addressed | % of total | Week set | Week Due |
| Practical | Access Assignments | LO1-LO6 | 50 | 2-6 | 3-7 |
| Practical | Python, Git Assignments | LO1-LO6 | 50 | 8-11 | 9-12 |
Reassessment Details
Contact Hours and Indicative Student Workload
| Contact Hours (scheduled hours per student over full module), broken down by: | 22 hours |
| Laboratory | 22 hours |
| Tutorial or seminar | 0 hours |
| Other | 0 hours |
| Independent study (outside scheduled contact hours), broken down by: | 103 hours |
| Preparation for classes and review of material. | 22 hours |
| Completion of practical assessments. | 81 hours |
| Total Hours | 125 hours |
Recommended Reading List
Access 2013 Bible (2013), Groh, M., John Wiley and Sons.5.
Microsoft Access 2013 In Depth (2013), Jennings, R., Que.6.
Microsoft Access VBA Programming for the Absolute Beginner (2011), Vine, M.,
Course Technology PRT.
All these texts are available on the Safari Tech Books Online database. These can be accessed from the local TCD library page here.
Module Pre-requisites
Prerequisite modules: STU11001 – Software Applications I
Other/alternative non-module prerequisites:
Module Co-requisites
None