![[The University of Leicester]](http://www.le.ac.uk/corporateid/departmentresource/000066/unilogo.gif) | Department of Mathematics & Computer Science |
 |
Next: Year 2
Up: Year 1
Previous: MC198 Information Management
MC199 Information Technology
Credits: 20 |
Convenor: Dr. D. Kuske |
Semester: 1 |
Prerequisites: |
|
|
Assessment: |
Continual assessment: 50% |
One and a half hour exam in January: 50% |
Lectures: |
22 |
Problem Classes: |
none |
Tutorials: |
none |
Private Study: |
98 |
Labs: |
24 |
Seminars: |
none |
Project: |
none |
Other: |
none |
Surgeries: |
6 |
Total: |
150 |
Explanation of Pre-requisites
For the spreadsheet component of the course, it is assumed that
students have the basic mathematical skills that would be acquired
by taking GCSE Mathematics or equivalent.
Experience with computers is NOT a prerequisite for this module, it is
not presumed that one has any prior knowledge of computers.
Course Description
The use of Information Technology has become routine in the modern work
environment. Students of all disciplines can benefit from learning to
work effectively with computers.
The module provides an introduction to Information Technology.
There are two strands which run side-by-side. The first places computers
in context and explains some of the important concepts.
It explores the construction of a computer system and, in general terms,
how it works. The second strand concerns the practical aspects of
using computer packages and is mainly taught through weekly laboratory
sessions.
Aims
This course aims to give students an understanding of Information
Technology and its applications. This includes an appreciation of the
basic architecture of a computer system: the hardware and the
software components of the system, the rôle of each, and their
capabilities and limitations. It also includes the use of the
computer as a tool and focuses on two of the most successful office
applications: the word processor and the spreadsheet. The full scope
of these packages is explored and practical skills are developed
through a series of laboratory worksheets.
Objectives
- To understand the basic concepts of Information Technology and
to learn the language and terminology of the subject;
- to develop a critical appreciation of the relative capabilities
of different sorts of systems and components;
- to gain the basic skills required to use a computer and to understand
the operating system presented by Windows;
- to learn how to use a word processor to prepare documents to a
high standard;
- to learn the basic principles of a spreadsheet; how to prepare a
simple spreadsheet using formulae and charts; how to tackle more complex
calculations;
- to learn some of the more advanced features of a spreadsheet;
how to use the database functions and logical formulae to develop more
advanced applications.
Transferable Skills
- A level of computer literacy which should be of benefit to any
employer,
- an awareness of the capabilities and limitations of Information
Technology that will allow the student to assess its suitability in
a particular application;
- the understanding needed to exploit the full potential of common
computer packages and to achieve results of a professional standard.
Syllabus
Hardware: overview of computer. Computer components. What the
microprocessor actually does. Peripherals (input and output).
Storage devices. Local area networks, (communications, and the
Internet). What the operating system is. How software is made, how
the hardware is made. Sociological implications.
Operating systems and Windows. Document preparation and word
processing in Microsoft Word: formatting, layout, styles,
sectioning, tables, etc. Storage, analysis and presentation of data
using Microsoft Excel: formulae and calculation; charts; databases;
applications.
[Note: There is no recommended reading for the laboratory based
section of this module, the following is for the general I.T. lecture
section]
Reading list
Recommended:
Hutchinson and Sawyer,
Computer Essentials, 2nd edition (or later),
Irwin, 1996.
Long and Long,
Introduction to Computers and Information Systems, 5th edition
(or later),
Prentice Hall, 1996.
Background:
Bandyo-padhyay,
Computing for Non-specialists,
Pearson Education, 2000
Capron,
Essentials of Computing, 2nd edition,
Benjamin-Cummings, 1996.
R. Maran,
Computers Simplified, 3rd edition,
IDG, 1997.
Stern and Stern,
Computing: Concepts for End Users,
Wiley, 1990
R. White,
How Computers Work, 2nd edition,
Ziff-Davis Press, 1995.
Details of Assessment
The laboratory work is examined entirely by continual assessment.
A selection of the weekly exercises are handed in for marking.
The written January examination covers the rest of the material.
There are three questions on the paper, and candidates
can obtain full marks for good answers to two questions.
Next: Year 2
Up: Year 1
Previous: MC198 Information Management
Author: S. J. Ambler, tel: +44 (0)116 252 3884
Last updated: 2001-09-20
MCS Web Maintainer
This document has been approved by the Head of Department.
© University of Leicester.