Registry

Module Specifications

Current Academic Year 2012 - 2013
Please note that this information is subject to change.

Module Title	Business Applications
Module Code	CA113
School	School of Computing
Online Module Resources
Module Co-ordinator	Semester 1: Jane Kernan Semester 2: Jane Kernan Autumn: Jane Kernan
NFQ level	8	Credit Rating	5
Pre-requisite	None
Co-requisite	None
Compatibles	None
Incompatibles	None

Description

This course aims to broaden the student’s computer literacy skills through the use of current Microsoft Office suite providing the students with increased competence, productivity, and credibility in any business environment. Emphasis is on word processing, spreadsheets and presentations working with: Word, Excel and Power Point. Students should master to an advanced level on how to use the applications in the MS Office suite and how to transfer data from one application to another. After course completion, students will be able to use these programs to their full capacity for both business and personal use.

Learning Outcomes

1. Develop a working knowledge of an integrated software suite.
2. Demonstrate marketable skills for enhanced employment opportunities. Create complex documents by adding components such as, customized lists, tables, charts, graphics and macros.
3. Describe proper computer techniques for designing and producing various types of documents
4. Learn the mail merge function to merge variable information into a standard document and create envelopes and mailing labels.
5. Develop the skills necessary to create macros, audit and analyze worksheet data, incorporate multiple data sources, import and export data, and share data with other applications.
6. Create and format spreadsheets, save time with Excel’s table and list management features, including AutoFilter and Automatic Subtotals. Create and use interactive PivotTables, and lookup tables to summarize and retrieve sets of data on the fly.
7. Create professional, high-impact presentations. Customize your presentation with colour, texture, animation schemes, slide templates and slide transitions.
8. Manipulate data from one software application to various other applications within the integrated suite.

Workload	Full-time hours per semester
*Type*	*Hours*	*Description*
Lecturer-supervised learning (contact)	12	lecture
Lab	24	Tutorials and assignments
Independent learning	77	No Description
Group work	12	presentation
Total Workload: 125

All module information is indicative and subject to change. For further information,students are advised to refer to the University's Marks and Standards and Programme Specific Regulations at: http://www.dcu.ie/registry/examinations/index.shtml

Indicative Content and Learning Activities

Develop a working knowledge of an integrated software package.
Complex documents creation.

Techniques for document design.
Mail Merge.

Macro development.
Import and export data.

Advanced functionality in spreadsheets.
Mastering presentation skills.

Assessment Breakdown
Continuous Assessment	100%	Examination Weight	0%

Course Work Breakdown
Type	Description	% of total	Assessment Date
Other	Problem based learning	100%	Every Week

Reassessment Requirement
Resit arrangements are explained by the following categories; 1 = A resit is available for all components of the module 2 = No resit is available for 100% continuous assessment module 3 = No resit is available for the continuous assessment component
This module is category 2

Indicative Reading List

David A. Wilson: 2002, Managing information, Butterworth-Heinemann, Oxford, 9780750656214
Sherry Willard Kinkoph: 0, Teach Yourself Visually Microsoft Office 2007,
Ed Bott: 0, Microsoft Office 2007 In Depth,

Other Resources

None

Array

Programme or List of Programmes

BSSA

Study Abroad (DCU Business School)

BSc in Enterprise Computing

SHSA

Study Abroad (Science & Health)

Timetable this semester: Timetable for CA113

Date of Last Revision

11-JAN-11