STU2201A – Software Applications II

Module CodeSTU2201A
Module NameSoftware Applications II
ECTS Weighting[1]5 ECTS
Semester taughtSemester 2
Module Coordinator/s  Michael Walsh

Module Learning Outcomes

On successful completion of this module, students will be able to:
LO1. Develop software solutions with the following tools:
• Microsoft Excel
• Microsoft Access
• Visual Basic for Applications
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 purpose of this module is to give students experience in advanced computer
applications. This will include advanced spreadsheets using Microsoft Excel. The
module will introduce students to database technology using Microsoft Access.
Furthermore, students will learn how to program functions using Visual Basic for
Applications.

Teaching and learning Methods

This module 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, based on a mixture of
individual and group work.

Assessment Details

Here

Assessment ComponentBrief DescriptionLearning Outcomes Addressed% of totalWeek setWeek Due
PracticalMicrosoft Excel AssignmentLO1, LO2, LO51044
PracticalMicrosoft Excel AssignmentLO1, LO2, LO3,
LO4
2068
PracticalVisual Basic AssignmentLO1, LO2, LO5101012
PracticalVisual Basic AssignmentLO1, LO6101314
PracticalMicrosoft Access
Assignment
L01, L02,
L05
51313
PracticalMicrosoft Access
Assignment
L01, L02,
L05
51516
PracticalMicrosoft Access
Assignment
L01, L02,
L03, L05,
L06
251620
PracticalMicrosoft Access
Assignment
L01, L02,
L03, L05,
L06
202024
Practical

Reassessment Details

Contact Hours and Indicative Student Workload

Contact Hours (scheduled hours per student over full module), broken down by:0 hours
contact_lect+contact_lab+contact_tut+contact_other
* MERGEFORMAT hours
hours
Laboratory44 hours
Tutorial or seminar0 hours
Other0 hours
Independent study (outside scheduled contact hours), broken down by:72 hours
Preparation for classes and review of material (including preparation for examination, if applicable36 hours
completion of assessments (including examination, if applicable)36 hours
Total Hours116 hours

Recommended Reading List

Excel 2013 Bible (2013), Walkenbach,J., John Wiley and Sons.2.
Microsoft Excel 2013 Formulas and Functions Inside Out (2013), Jeschke, E. Reinke,
H. Unverhau, S. Pfeifer, E. Fienitz, B. Bock, J., Microsoft Press.3.
Excel VBA: 24-Hour Trainer (2015), Urtis, T., Wrox.4.
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

Module Website

Blackboard