20 credits at level HE4
The first year of a computing degree is an exciting phase of a students life. It is the point at which they start to take a professional view of many tools they have previously encountered. The focus of the student also changes as they appreciate business needs and are also introduced to technologies and techniques that enable computers to be exploited to provide genuine advantage to an organisation. It is with this aim in mind that this module has been developed.
For students who choose not to complete a degree programme, this module will provide them with skills that will be useful in almost any office environment in which they work, for the majority of students the focus will be to furnish them with skills that are pre-requisites for modules they will encounter later in their degree.
The specific aims of this module are:
1. To provide students with a string grounding in Microsoft Excel
2. To use Microsoft Excel to resolve realistic business problems
3. To provide an holistic understanding of commonly used processing strategies and the data processing life-cycle
4. To introduce students to databases and database design
5. To discover Microsoft Access and to use it in a simple but realistic scenario
Fundamental database concepts
Entity relationship modelling and the fundamentals of database design.
Data processing and information systems
The data processing lifecycle
Business disciplines in which spread sheets are commonly employed
The module will be taught by a combination of lectures, tutorials, seminars and practicals.
The module is assessed by two assignments, in which students will demonstrate their ability to use de-facto office tools to resolve realistic business problems. The first assignment will primeraly be based on Access and the second on Excel.
NB Where this module is offered online (via BoltOnline) lectures and seminars delivered by Elluminate.
when you have successfully completed this module you will:
to demonstrate that you have achieved the learning outcome you will:
|1.||Be capable of manipulating files in a windows environment||Manage files relating to course work and practical excercise|
|2.||Understand the fundamental principles on which databases operate||Create a database design using appropriate keys and entity relationships|
|3.||Be able to use Microsoft Access to create a complete application.||Create a database using Microsoft Access inclusive of a front end, input forms, queries and reports|
|4.||Understand an example business scenario in which spread sheets are commonly and use Excel to convert realistic data into useful information||Use Excel to manipulate a significant quantity of data with a focus on the business requirements.|
|5.||Be able to use advanced spread sheet utilities||Create a spread sheet that demonstrates use of such utilities|
Your achievement of the learning outcomes for this module will be tested as follows:
|Description||Production of a database using Microsoft access and a an analysis of the processing that this has introduced||Using a spread sheet to resolve a realistic business problem, converting data into information. In this assignment students will also exploit Excel to create an easy to use user environment|
There are no prerequisites for this module.
No restrictions apply.
Successful ICT Projects In Excel (3rd Edition) ISBN: 1903112710
Successful ICT Projects In Access (3rd Edition) ISBN: 1903112737
|Host Subject Group:|
|User Name||Date Accessed||Action|