Full Title:Technology and Office Applications 2
Module Code:COMP B7008
 
Credits: 5
Valid From:Semester 1 - 2013/14 ( September 2013 )
Module Delivered in 2 programme(s)
Module Description:no description provided
Learning Outcomes:
On successful completion of this module the learner should be able to
  1. Produce more advanced, high quality business documents to a standard compatible with corporate requirements.
  2. Further analyse numerical data using features such as advanced filtering techniques, lookups and validating table data.
  3. Design and query a multi-table relational database.
  4. Complete projects that integrate word processing, spreadsheet and database software.
 

Module Content & Assessment

Indicative Content
Advanced Word Processing
Further developing multipage documents. Working with styles and templates. Working with references, building forms and integrating word processing with other programmes.
Advanced Spreadsheets
Analysing data using functions such as: filters, validating table data, lookup tables, creating subtotals, what-if analysis, scenario manager, goal seek and solver.
Database Design
Understand and design a relational database. Querying a database using multi-table queries, calculated queries, summary and crosstab queries incorporating pivot tables and pivot charts. Designing forms and reports.
Integrating Data between Applications
Creating sophisticated documents incorporating data from multiple office programmes. By creating links between the programmes, tasks can be kept up-to-date and ready to go at a moment's notice.
Assessment Breakdown%
Course Work100.00%

Full Time

Course Work
Assessment Type Assessment Description Outcome addressed % of total Marks Out Of Pass Marks Assessment Date Duration
Continuous Assessment n/a 1,2,3,4 100.00 0 0 n/a 0
No Project
No Practical
No End of Module Formal Examination
Reassessment Requirement
A repeat examination
Reassessment of this module will consist of a repeat examination. It is possible that there will also be a requirement to be reassessed in a coursework element.

DKIT reserves the right to alter the nature and timings of assessment

 

Module Workload & Resources

Workload: Full Time
Workload Type Workload Description Hours Frequency Average Weekly Learner Workload
Practical No Description 3.00 Every Week 3.00
Independent Study No Description 3.00 Every Week 3.00
Directed Reading No Description 3.00 Every Week 3.00
Total Weekly Learner Workload 9.00
Total Weekly Contact Hours 3.00
This course has no Part Time workload.
Resources
Recommended Book Resources
  • Duffy, Jennifer and Cram, Carol 2013, Microsoft Word 2010 Complete, International Edition Ed., Course Technology [ISBN: 978-0-538-74825-4]
  • Beskeen/Cram/Duffy/Friedrichsen/Wermers 2013, Microsoft Office 2010 Second Course, International Edition Ed., Course Technology [ISBN: 978-0-538-74956-5]
  • Friedrichsen, Lisa 2013, Microsoft Access 2010 Complete, International Edition Ed., Course Technology [ISBN: 978-1-111-53157-7]
  • Wermers, Lynn 2013, Microsoft Excel 2010 Advanced, Course Tecnology [ISBN: 978-0-538-74838-4]
Supplementary Book Resources
  • Cram, Carol 2013, Microsoft Office 2010 Projects, Course Technology [ISBN: 978-0-538-74848-3]
This module does not have any article/paper resources
This module does not have any other resources

Module Delivered in

Programme Code Programme Semester Delivery
DK_BBSTY_7 Bachelor of Business in Business and Technology 2 Mandatory
DK_BBSIS_C Higher Certificate in Business in Business and Technology 2 Mandatory