Elective Modules

Course Code: MTC104
Level 1: 10 credits

An introduction to databases, and their use within an office information system.

At the end of the module the student should be able to:

• Understand the terminology used in database design
• Create a simple flat database
• Create a data input form
• Create filters and queries for sorting and extracting information from the data
• Report on the information obtained

Course Code: MTC105
Level 1: 10 credits

Development of the skills required to produce professional presentations using modern IT systems.

At the end of the module the student should be able to:

• Understand the structure of presentations
• Make effective use of computer-based presentation systems
• Understand and use some of the more advanced features of presentation systems
• Incorporate appropriate graphics and sound effects
• Design effective materials to support presentations

Course Code: MTC106
Level 1: 10 credits

Reinforcement of earlier learning leading on to a greater understanding of how to use a modern word processing system effectively.

At the end of the module the student should be able to:

• Automate document formatting and layout
• Apply style and macro commands to control the design and appearance of documents
• Create tables and integrate with documents
• Automate the creation of contents and index pages for documents
• Integrate office applications and make effective use of mail merge

Course Code: MTC108
Level 1: 10 credits

This module aims to develop skills in the use of Desktop Publishing (DTP) systems and effective techniques in the use of graphics within office information systems.

At the end of the module the student should be able to:

• Understand when to use DTP and when to use word processing
• Analyse the planning and design criteria when creating a publication
• Create effective publications in both media
• Apply text and graphics appropriately
• Analyse and apply different types of output

This module requires you to have a copy of Microsoft Publisher. Please note that this module is not suitable for Office 2000.

Course Code: MTC109
Level 1: 10 credits

Investigation of some of the advanced features within modern presentation systems, students to develop skills in the production of advanced presentations.

At the end of the module the student should be able to:

• Understand the functionality of the advanced features
• Create a self-running presentation
• Make effective use of external data within a presentation system
• Output a presentation for distribution
• Understand the special requirements for publishing presentations on the WWW

Course Code: MTC110
Level 1: 10 credits

Development of the skills required to create a simple website using common page layout components.

At the end of the module the student should be able to:

• Understand the different elements within web page construction and the principles of good design
• Construct a simple web site using a What You See Is What You Get (WYSIWYG) editor
• Understand and apply the use of programming language to create web pages
• Understand and apply the requirements for use of graphics within a website
• Understand and apply the requirements for publishing a web site

This module requires you to have a copy of Microsoft Expression Web.

Course Code: MTC111
Level 1: 10 credits

This module builds on earlier knowledge and provides the skills necessary to create and publish advanced websites.

At the end of the module the student should be able to:

• Understand and apply themes within website development
• Use application plug-ins
• Understand and use forms within websites
• Create and maintain style sheets
• Analyse the difference between static and dynamic websites

This module requires you to have a copy of Microsoft Expression Web.

Course Code: MTC112
Level 1: 10 credits

Building on earlier learning, this module provides the student with the skills to manipulate, analyse and publish data within a spreadsheet.

At the end of the module the student should be able to:

• Understand and create a multi-page spreadsheet
• Use advanced formulae and functions correctly
• Create advanced charts for analysis and publication of data
• Incorporate external lists and databases within spreadsheets
• Present summarised data

Course Code: MTC113
Level 1: 10 credits

Exploration of key components within database development, as well as the rules required for the construction of relational database systems.

At the end of the module the student should be able to:

• Understand the structure and terminology of relational databases
• Make effective use of available tools to assist in the design and creation of a relational database
• Use available tools to design forms and user interfaces
• Design and use queries to extract information
• Design simple relational reports

Course Code: MTC114
Level 1: 10 credits

This module provides students with a sound knowledge of how to develop reliable database systems using advanced features and techniques.

At the end of the module the student should be able to:

• Create advanced tables, forms, pages and reports
• Understand and use advanced queries
• Automate the updating of reports
• Create programmable event procedures
• Produce technical and user-guide information

Course Code: MTC115
Level 1: 10 credits

Investigation of the advanced uses of modern word processing systems within an electronic office.

At the end of the module the student should be able to:

• Create and edit a shared document
• Understand the complexities of long documents, and be able to generate and merge them
• Manipulate graphic images within documents
• Integrate documents with other applications

Course Code: MTC116
Level 1: 10 credits

Use of the electronic office systems. Developing an understanding of the more advanced features of computer operating environments including the control panel.

At the end of the module the student should be able to:

• Understand how to personalise a computer and make the necessary changes with confidence
• Make effective use of the control panel and programme manager
• Understand and use the common diaries, appointments and synchronisation systems provided with Windows and Outlook
• Organise the Windows environment including administrating user rights on a local computer
• Understand the concepts and issues behind the simple networking of computers

Course Code: MTC117
Level 1: 10 credits

Use of the advanced features of spreadsheet applications within office information systems.

At the end of the module the student should be able to:

• Understand the need for and principles of data validation
• Understand and analyse the methodology of collaboration as part of a work group
• Understand and apply the principles of data manipulation and analysis
• Make effective use of templates, macros and forms

Course Code: MTC118
Level 1: 10 credits

This research-based module aims to investigate the current trends and developments within the environment of modern office information systems.

At the end of the module the student should be able to:

• Research and identify the underlying issues of a chosen topic
• Evaluate the issues within the chosen topic
• Understand the implications of the convergence in technologies
• Analyse the possible implications these issues may have on his or her organisation
• Produce a structured report detailing the findings and conclusions