Skip to main content

Trinity College Dublin, The University of Dublin

Menu Search



Module DescriptorSchool of Computer Science and Statistics

Module CodeST2001
Module NameST2001 SOFTWARE APPLICATIONS II
Module Short Title
ECTS5
Semester TaughtSemester 1 and Semester 2.
Contact Hours2 hours per week Semester 1 and Semester 2. 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
Module PersonnelChief Examiner - Michael WalshLecturer – Liliana Mamani Sanchez
Learning Outcomes

On successful completion of this module, students will be able to: ·        

  • Develop software solutions with the following tools:               
    • Microsoft Excel               
    • Microsoft Access                
    • Visual Basic for Applications. ·        
  • Work independently and also as part of a team to develop software solutions.
  • Work with written and oral descriptions of software application problems and apply suitable tools to build solutions. ·        
  • Source relevant reference material to help in solving software issues. ·        
  • Participate effectively in group discussions on technical issues and problems.             Produce, test and implement suitable software solutions.  
Learning Aims

The purpose of this module is to give students experience in advanced computer applications. This will include the advanced applications of Excel. The module will introduce students to database technology using Microsoft Access. Students will use Visual Basic for Applications (MS Office 2013). 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.

Module Content
  • Advanced spreadsheets using Microsoft Excel 2013
  • Databases using Microsoft Access 2013
  • Programming with Visual Basic for Applications (MS Office 2013)  
Recommended Reading List
  1. 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 at www.tcd.ie/Library/collections/databases.php

Module PrerequisitesST1001 – Software Applications I
Assessment Details

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. Students must attend a minimum of 75% of classes and are expected to obtain a passing grade of 40% in the coursework. Failure to achieve this may result in students having to undertake additional project work satisfactorily over the summer in order to pass the year.

Module Website
Academic Year of Data2015/16