STU11001 – Software Applications I

Module CodeSTU11001
Module NameSoftware Applications I
ECTS Weighting[1]5 ECTS
Semester TaughtSemester 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 Adobe Dreamweaver (Dw).
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 Adobe Dreamweaver, 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 ComponentBrief DescriptionLearning Outcomes Addressed% of totalWeek setWeek due
Quiz (open book)You will be asked to define a few functions to provide the required functionality. You will have 55mins to complete it. The quiz is related (but not limited) to the three lectures on Python.LO3, LO4, LO515%TBDTBD
AssignmentsThere will be 5 assignments: 2 on Excel, 2 on Dw, and 1 on Python.LO1-LO585%n/an/a
AttendanceYou are required to attend all the classes. n/an/an/a

Reassessment Details

According to the feedback of previous students, the workload of this module is heavy. (Apparently, 5 assignments are acceptable in normal years but not during the pandemic …) Well, I have to say your final mark will look good if you do what I ask you to do :).

Failure to achieve the passing grade or low engagement with coursework will result in students having to undertake additional project work 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:30 hours
lecture20
laboratory10
tutorial or seminar0
other0
Independent Study (outside scheduled contact hours), broken down by:40 hours
preparation for classes and review of material (including preparation for examination, if applicable)10
completion of assessments (including examination, if applicable)30
Total Hours70 hours

Recommended Reading List

  1. Excel 2016 Bible, John Walkenbach, John Wiley and Sons.
  2. Excel 2016 Formulas and Functions, Paul McFedries, Que.
  3. Microsoft Excel 2016 Step by Step, Curtis Frye, Microsoft Press.
  4. 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

  1. 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/).
  2. Introduction to Computation and Programming Using Python, John V. Guttag.
  3. Python Beginner Tutorials (https://www.youtube.com/user/onestopprogramming/videos).

Module Pre-requisites

none

Module Co-requisites

none

Module Website

Blackboard