Academic Module Manager 3.0
  1. Search
  2. Module Details

CAPP07010 2009 Applied Excel Programming

General Details

Full Title
Applied Excel Programming
Transcript Title
Applied Excel Programming
Code
CAPP07010
Attendance
N/A %
Subject Area
CAPP - Computer Applications
Department
MENG - Mech. and Electronic Eng.
Level
07 - Level 7
Credit
05 - 05 Credits
Duration
Semester
Fee
€
Start Term
2009 - Full Academic Year 2009-10
End Term
9999 - The End of Time
Author(s)
Brian Coll
Programme Membership
SG_EQUAL_J07 200900 Bachelor of Science in Quality SG_EQUAL_H08 200900 Bachelor of Science (Honours) in Quality Management & Tech SG_EQUAL_B07 200900 Bachelor of Science in Quality Engineering
Description

This subject aims to give the student an in-depth understanding of the capabilities of Excel and how to select and utilise its inbuilt functions to solve real-life examples found in manufacturing and service quality.

Learning Outcomes

On completion of this module the learner will/should be able to;

1.

Use advanced features of Excel such as formula, functions and macros.

2.

Create and maintain lists, including filters and subtotals.

3.

Construct pivot tables and pivot charts and use goal seek and solver.

4.

Design charts and graphs using Excel

5.

Distinguish between capabilities of Excel and  other statistical based tools - e.g. Minitab

6.

Demonstrate critical thinking and programming skills by using Excel to model and solve business problems.           

7.

Present project results and analysis in professional reports to management.

Module Assessment Strategies

Indicative Practicals/Projects

ECDL based progression program will be utilised to teach student advanced concepts in Excel.  Students will also utilise self-assessment exercises to improve their competence with Excel.

The lecturer can set various Excel assignments to be submitted throughout the course to solve problems covering the appropriate areas of the syllabus. 

The lecturer will then introduce more complex real life problems in Manufacturing, Quality and Business which the student will need to analyse and solve using Excel. Case Studies can also be used as the student grows in confidence using Excel. The major report(s) should be a more complex problem where students will be required to integrate their knowledge of Excel by compiling a program to solve a real life business problem such as a Quotation, Forecasting, Planning or Reporting tool.

Indicative Syllabus

This subject aims to give the student an in-depth understanding of the capabilities of Excel. The student will work with advanced Excel formulas and functions, creating/using macros, and using pivot tables. The key parts of the syllabus are:

Introduction to Excel

Editing

Data Handling

Sorting / Querying / Filtering

Linking Data and Charts

Charts and Graphs

  • Pie Charts
  • Format chart axes, numbers and text
  • Modifying the chart type

Functions

  • Mathematical
  • Statistical
  • Lookup and Reference
  • Financial
  • Logical
  • Database

Analysis Tools

  • Pivot Tables
  • Goal Seeker & Solver
  • Scenarios - What If analysis?

Auditing a worksheet

Special Tools

Macros

  • Recording a Macro
  • Running a Macro
  • Editing Macros

Introduction to Modeling using Excel

Coursework & Assessment Breakdown

Coursework & Continuous Assessment
100 %

Coursework Assessment

Title Type Form Percent Week Learning Outcomes Assessed
1 Assignment Excel Excercises Coursework Assessment UNKNOWN 60 % OnGoing 1,2,3,4,5
2 Project Excel Projects Coursework Assessment UNKNOWN 40 % OnGoing 6,7
             

Part Time Mode Workload


Type Location Description Hours Frequency Avg Workload
Lecture Distance Learning Suite Theory 1 Weekly 1.00
Tutorial Distance Learning Suite Practical Hours 1 Weekly 1.00
Independent Learning UNKNOWN Moodle & Text Book 4 Weekly 4.00
Total Part Time Average Weekly Learner Contact Time 2.00 Hours

Module Resources

Non ISBN Literary Resources

Authors

Title

Publishers

Year

Advanced Spreadsheets in Excel

Frank Kirk

 

Blackrock Education Centre

 

2009

  Practical Management Science, 2nd Edition.

Winston, Albright

 

Duxbury Thomson Learning

2001

Applied Statistics For Engineers And Scientists : Using Microsoft Excel & MiniTab.

Levine, David M.,

Prentice Hall

2001
Other Resources

Listed on Moodle