Module Descriptors
COMPUTER ESSENTIALS FOR THE EUROPEAN COMPUTER DRIVING LICENCE
MATH40379
Key Facts
Faculty of Computing, Engineering and Sciences
Level 4
15 credits
Contact
Leader: Joy Harding
Email: J.E.Harding@staffs.ac.uk
Hours of Study
Scheduled Learning and Teaching Activities: 36
Independent Study Hours: 114
Total Learning Hours: 150
Assessment
- CLASS-TEST weighted at 45%
- CLASS-TEST - SECOND CLASS TEST weighted at 50%
- COURSEWORK weighted at 5%
Module Details
Module Indicative Content
The module will consider the 7 units of the ECDL syllabus:
Concepts of Information and Communication Technology:- gain an understanding of the different parts of a computer, as well as some of the key concepts of ICT such as those relating to networks and security.
Using the Computer and Managing Files:- knowledge and competence in using the common functions of a personal computer and its operation system such as how to manage and organise files and directories/folders.
Word Processing:- use a word processing application to accomplish everyday tasks associated with creating, formatting and finishing small-sized word processing documents such as letters and other everyday documents.
Spreadsheets:- understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet, in addition to using standard formulas and functions, and demonstrate competence in creating and formatting graphs or charts.
Database:- understand some of the main concepts of databases and demonstrate the ability to use a database application. This includes creating and modifying tables, queries, forms and reports, and preparing outputs ready for distribution, as well as learning to relate tables and to retrieve and manipulate information from a database by using query and sort tools.
Presentation software:- creating, formatting, modifying and preparing presentations using different slide layouts for display and printed distribution.
Web Browsing and Communication:- Use the Internet for browsing and appreciate some of the security considerations. Understand some concepts of e-mail, send and receive messages, attach files to mail messages.
Concepts of Information and Communication Technology:- gain an understanding of the different parts of a computer, as well as some of the key concepts of ICT such as those relating to networks and security.
Using the Computer and Managing Files:- knowledge and competence in using the common functions of a personal computer and its operation system such as how to manage and organise files and directories/folders.
Word Processing:- use a word processing application to accomplish everyday tasks associated with creating, formatting and finishing small-sized word processing documents such as letters and other everyday documents.
Spreadsheets:- understand and be able to accomplish tasks associated with developing, formatting, modifying and using a spreadsheet, in addition to using standard formulas and functions, and demonstrate competence in creating and formatting graphs or charts.
Database:- understand some of the main concepts of databases and demonstrate the ability to use a database application. This includes creating and modifying tables, queries, forms and reports, and preparing outputs ready for distribution, as well as learning to relate tables and to retrieve and manipulate information from a database by using query and sort tools.
Presentation software:- creating, formatting, modifying and preparing presentations using different slide layouts for display and printed distribution.
Web Browsing and Communication:- Use the Internet for browsing and appreciate some of the security considerations. Understand some concepts of e-mail, send and receive messages, attach files to mail messages.
Module Learning Strategies
36 hours of practical/lab workshops. Some topics will be covered by directed independent study.
Module Texts
Course textbook
ECDL4 The Complete Coursebook for Microsoft Office 2003, B Munnelly & P. Holden, Prentice Hall 2005, 013196431-3
ECDL4 The Complete Coursebook for Microsoft Office 2003, B Munnelly & P. Holden, Prentice Hall 2005, 013196431-3
Module Special Admissions Requirements
None
Module Resources
One computer per student.
A whole range of IT applications, for example Windows Explorer (file management) Word (word-processor), Excel (spreadsheet), Access (database), Powerpoint (presentation package), MS Outlook (email communication), Internet Explorer (internet browser).
A whole range of IT applications, for example Windows Explorer (file management) Word (word-processor), Excel (spreadsheet), Access (database), Powerpoint (presentation package), MS Outlook (email communication), Internet Explorer (internet browser).
Module Additional Assessment Details
100% coursework assessing all learning outcomes
A portfolio consisting of a series of practical based class tests and assignment
A portfolio consisting of a series of practical based class tests and assignment