![[The University of Leicester]](http://www.le.ac.uk/corporateid/departmentresource/000066/unilogo.gif) | Department of Mathematics & Computer Science |
 |
Next: Level 2
Up: Level 1
Previous: CO1098 Information Management
CO1099 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 Windows operating system;
- 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: Level 2
Up: Level 1
Previous: CO1098 Information Management
Author: S. J. Ambler, tel: +44 (0)116 252 3884
Last updated: 2002-07-11
MCS Web Maintainer
This document has been approved by the Head of Department.
© University of Leicester.