|Module Name||Software Applications II|
|ECTS Weighting||5 ECTS|
|Semester taught||Semester 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
LO6. Produce, test and implement suitable software solutions
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
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 Component||Brief Description||Learning Outcomes Addressed||% of total||Week set||Week Due|
|Practical||Microsoft Excel Assignment||LO1, LO2, LO5||10||4||4|
|Practical||Microsoft Excel Assignment||LO1, LO2, LO3,|
|Practical||Visual Basic Assignment||LO1, LO2, LO5||10||10||12|
|Practical||Visual Basic Assignment||LO1, LO6||10||13||14|
Contact Hours and Indicative Student Workload
|Contact Hours (scheduled hours per student over full module), broken down by:||0 hours|
* MERGEFORMAT hours
|Tutorial or seminar||0 hours|
|Independent study (outside scheduled contact hours), broken down by:||72 hours|
|Preparation for classes and review of material (including preparation for examination, if applicable||36 hours|
|completion of assessments (including examination, if applicable)||36 hours|
|Total Hours||116 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.
Prerequisite modules: STU11001 – Software Applications I
Other/alternative non-module prerequisites: