COM106GA2: Computer Literacy

(For Bio Science, Computer Science and Physical Science students at Level 1)

This course is conducted for all first year students to enhance the ICT skills of them. These skills will support them for their studies and helpful when they join in employment after completing the degree. The need for the change is to increase the weight of Practical skills and to support the UCTIT exam conducted by the HETC project.

Students  would be able to
  • describe the basic concepts of ICT
  • identify the basic components of a computer and describe the function of each, identify different types of software and general concepts relating to software categories
  • identify network fundamentals and the benefits of networks
  • design and produce various types of documents such as notes, research reports etc
  • create and format spreadsheets, including the use of formulae
  • prepare and do effective presentations using computers
  • create and manipulate databases

and students would be knowledgeable of computer ethics

At the end of the course student will be able to describe the basic concepts and components of ICT and do Word processing, Graphical presentation, Spreadsheet and Database packages.

Overview

1 Fundamentals of ICT    15 hours Lectures 1 credit
2 Word processing    14 hours practical 1 credit
3 Presentation Techniques    07 hours practical
4 Spreadsheet Applications    12 hours practical
5 Database handling    12 hours practical

Fundamentals of ICT (15 Hours)

Hrs

Topics

2

Basic Concepts of ICT: ICT and its Promises, Computer System, Characteristics of Computer, Type of computers and its classifications, Data versus Information, Units of measurement for  capacity and encoding data.

4

Hardware: System Unit, Input devices, Output devices and Secondary storage devices

4

Software: System software and Application software

3

Networks and communication services: Types of Networks, Major Components of a Simple Network, Data communication standards, IP Addressing and Network Services (Web Browsing,  e-mail, Short message services, Downloading, Teleconferencing, Shared resource, Telnet, E-Learning, E-Commerce, Portable works and etc)

2

Challenges of Information Technology: Health Issues, Ergonomics & the Environment, Cyber Ethics, Threats and Safeguarding Computers and Communications Systems

Word Processing (with Advanced Techniques) (14 Hours)

Hrs

Topics

1

Introduction to Windows

6

Working with Text, Formatting Pages, Formatting Characters and Paragraphs,  Tabs,
Working with Tables, Documents with Columns and Art

6

Documentation of project reports/thesis

1

Automating Tasks, Creating simple web pages, Mail merge, Previewing and Printing Documents.

 

Presentation Techniques ( 07 Hours)

Hrs

Topics

2

Creating presentations, applying and modifying design templates, viewing and formatting presentations

3

Adding and modifying slide text, animating text and objects

1

Inserting multimedia information into powerpoint, drawing and modifying shapes

1

Setting up and delivering a slide show and printing a presentation

 

Spreadsheet Applications (12 Hours)

Hrs

Topics

2

Environment settings, working with cells, formatting cells and worksheets

8

Working with formulas and functions

2

Creating and modifying charts, page set up and printing

Database Handling (12 Hours)

Hrs

Topics

4

Creating and Modifying databases and tables

6

Queries and relationships

2

Designing forms and reports

  • Method of Evaluation
In-Course Assessment   60%
  Theory  Two Assessments   01 hour each
  Practical  Two Tests   90 minutes each
End of Course Examination  40%
  Part I (Theory)  MCQ + Structured questions

on covered topics

 02 hours
  Part II (Practical)  Practical questions

on covered topics

 02 hours
Final Marks  (Practical Marks + Theory Marks)/2

Each student must have 80% attendance to be eligible to sit the examinations at the first attempt. Failing to do so would result in wasting the time for a year or so to sit for the repeat examination.

In-Course Assessments carry 60% weight while the End of Course Examination carry 40% weight. Students are requested to be aware of it, and the attendance is important to score good marks in the assessment tests. Assessment examination cannot repeated for absentees unless the reason for absence is acceptable to the Board of the Faculty.