| Module Code | STU11001 |
| Module Name | Software Applications I |
| ECTS Weighting[1] | 5 ECTS |
| Semester Taught | Semester 1 |
| Module Coordinator/s | Mimi Zhang |
Module Learning Outcomes
On successful completion of this module, students will be able to:
LO1. Develop spreadsheet models in Microsoft Excel.
LO2. Design and develop web sites using Microsoft Expression Web 4 (alt: Adobe Dreamweaver).
LO3. Learn a programming language – Python.
LO4. Work independently to develop software solutions.
LO5. Source relevant reference material to help in solving software issues.
Module Content
• Spreadsheets using Microsoft Excel.
• Designing and Publishing WWW pages using Microsoft Expression Web 4, including CSS and JavaScript.
• Programming using Python.
Teaching and Learning Methods
The purpose of this module is to provide an introduction to the practical uses of computer applications particularly in the area of spreadsheets, web page design and development, and programming language. 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.
Assessment Details
| Assessment Component | Brief Description | Learning Outcomes Addressed | % of total | Week set | Week due |
| Assignments | There will be 3 assignments: 1 on Excel, 1 on Web, and 1 on Python. | LO1-LO5 | 95% | n/a | n/a |
| Attendance | You are required to attend all the classes. | 5% | n/a | n/a |
Reassessment Details
Failure to achieve the passing grade or low engagement with coursework will result in students having to undertake additional coursework satisfactorily over the summer in order to pass the year. Note that, your re-assessment mark will be capped at 40%.
Contact Hours and Indicative Student Workload
| Contact Hours (scheduled hours per student over full module), broken down by: | 24 hours |
| lecture | 0 |
| laboratory | 24 |
| tutorial or seminar | 0 |
| other | 0 |
| Independent Study (outside scheduled contact hours), broken down by: | 60 hours |
| preparation for classes and review of material (including preparation for examination, if applicable) | 0 |
| completion of assessments (including examination, if applicable) | 60 |
| Total Hours | 84 hours |
Recommended Reading List
- Excel 2016 Bible, John Walkenbach, John Wiley and Sons.
- Excel 2016 Formulas and Functions, Paul McFedries, Que.
- Microsoft Excel 2016 Step by Step, Curtis Frye, Microsoft Press.
- CSS: The Missing Manual, 4th Edition (2015), David McFarland, O’Reilly Media.
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
- Free video courses on Dw (and web development) can be found in LinkedIn Learning – lil.tcd.ie (https://www.tcd.ie/hr/learning-and-development/linked-in-learning/).
- Introduction to Computation and Programming Using Python, John V. Guttag.
- Python Beginner Tutorials (https://www.youtube.com/user/onestopprogramming/videos).
Module Pre-requisites
none
Module Co-requisites
none