Phase 2 elective modules

Choose any three modules from the following:

MTC104 An Introduction to Databases Download sample
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

 

MTC105 Introduction to Presentation Systems Download sample
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

 

MTC106 Word Processing 2 - Beyond the Basics Download sample
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

 

MTC108 Desktop Publishing and Using Graphics  
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.
Please note that this moduleis not suitable for Office 2000

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.

MTC109 Advanced Presentation Systems Download sample
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

 

MTC110 Web Site Development Download sample
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.

 

MTC111 Moving Ahead in Web Development  
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.

 

MTC112 Spreadsheets 2 – More Number Crunching Download sample
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

 

MTC113 Intermediate Databases Download sample
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

 

MTC114 Advanced Databases
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

 

MTC115 Word Processing Expert Download sample
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

 

MTC116 Electronic Office and the Windows Environment Download sample
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

 

MTC117 Advanced Spreadsheets Download sample
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

 

MTC118 Information Society Download sample
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