Faculty of Science

COM101G0: Computer Literacy for Science (New Syllabus)

Theory: 5 Hrs

Practical: 30 Hrs

Independent Learning: 35 Hrs

Objectives

Provide knowledge and practical experience on ICT tools and techniques required in the present learning and working environment.

Intended Learning Outcomes:

Describe the functions of computers and communication networks components
Create documents using word processing software
Design slides using presentation software
Make use of spreadsheet application software for data manipulation and data visualization
Apply Internet tools effectively for learning, communication and personal organization

Syllabus Overview

No	Topic	Hours
1	Fundamentals of ICT	5 hours Lectures
2	Word processing	10 hours practical
3	Presentation Techniques	04 hours practical
4	Spreadsheet Applications	10 hours practical
5	Applications on the Internet	06 hours practical

Fundamentals of ICT (5 Hours)

No	Topic	Hrs
1	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.	1
2	Hardware & Software: System Unit, Input devices, Output devices and Secondary storage devices, System software and Application software.	2
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
4	Challenges of Information Technology: Health Issues, Ergonomics & the Environment, Cyber Ethics, Threats and Safeguarding Computers and Communications Systems.	1

Word Processing (with Advanced Techniques) (10 Hours)

No	Topic	Hrs
1	Introduction to Windows, toolbars and Navigating the word Document.	1
2	Working with Text, Formatting Pages, Formatting Characters and Paragraphs, Tabs, Working with Tables, Documents with Columns and Art	6
3	Automating Tasks, Tracking Changes, Creating simple web pages, Mail merge, Previewing and Printing Documents.	3

Presentation Techniques ( 05 Hours)

No	Topic	Hrs
1	Creating presentations, applying and modifying design templates, viewing and formatting presentations	1
2	Adding and modifying slide text, animating text and objects	2
3	Inserting multimedia information into powerpoint, drawing and modifying shapes	1
4	setting up and delivering a slide show and printing a presentation	1

Spreadsheet Applications (10 Hours)

No	Topic	Hrs
1	Environment settings, working with cells, formatting cells and worksheets	2
2	Working with formulas and functions	6
3	Creating and modifying charts, page set up and printing	2

Applications on the Internet (6 Hours)

No	Topic	Hrs
1	Websites and effective searching, learning with the aid of the Internet.	2
2	Communication tools, personal organization tools.	2
3	document collaboration.	2

Teaching / Learning Methods: Lecture, laboratory practical, Discussion, tutorial classes

Method of Evaluation

In-course assessment : 10%

1	Two Theory Assessment	01 hour each
2	Two Practicals Assessment	90 minutes each

Mid Semester Examination : 30%

Part I	MCQ and Structured questions – 02 hour
Part II	Practical – 02 hours

End of course Examination : 60%

Part I	MCQ and Structured questions – 02 hour
Part II	Practical – 02 hours

Note:

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.
Assessment examination cannot repeated for absentees unless the reason for absence is acceptable to the Board of the Faculty. The repeat examination will be conducted on the next academic year.
A completion certificate may be awarded to those who complete all the practical assignments and obtain a final mark of 40%.

COM106GA2: Computer Literacy (Old Syllabus)

Theory: 15 Hrs

Practical: 45 Hrs

(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.

Objectives

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 formulas
prepare and do effective presentations using computers
create and manipulate databases

and students would be knowledgeable of computer ethics

Outcome

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.

Syllabus Overview

No	Topic	Hours	Credit
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)

No	Topic	Hrs
1	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.	2
2	Hardware: System Unit, Input devices, Output devices and Secondary storage devices	4
3	Software: System software and Application software	4
4	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)	3
5	Challenges of Information Technology: Health Issues, Ergonomics & the Environment, Cyber Ethics, Threats and Safeguarding Computers and Communications Systems	2

Word Processing (with Advanced Techniques) (14 Hours)

No	Topic	Hrs
1	Introduction to Windows	1
2	Working with Text, Formatting Pages, Formatting Characters and Paragraphs, Tabs, Working with Tables, Documents with Columns and Art	6
3	Documentation of project reports/thesis	6
4	Automating Tasks, Creating simple web pages, Mail merge, Previewing and Printing Documents.	1

Presentation Techniques ( 07 Hours)

No	Topic	Hrs
1	Creating presentations, applying and modifying design templates, viewing and formatting presentations	2
2	Adding and modifying slide text, animating text and objects	3
3	Inserting multimedia information into powerpoint, drawing and modifying shapes	1
4	setting up and delivering a slide show and printing a presentation	1

Spreadsheet Applications (12 Hours)

No	Topic	Hrs
1	Environment settings, working with cells, formatting cells and worksheets	2
2	Working with formulas and functions	8
3	Creating and modifying charts, page set up and printing	2

Database Handling (12 Hours)

No	Topic	Hrs
1	Creating and Modifying databases and tables	4
2	Queries and relationship	6
3	Designing forms and reports	2

Method of Evaluation

In-course assessment : 60%

1	Two Theory Assessment	01 hour each
2	Two Practicals Assessment	90 minutes each

End of course Examination : 40%

Part I	MCQ and Structured questions – 02 hour
Part II	Practical – 02 hours

Final Marks = (Practical Marks + Theory Marks)/2

Note:

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. The repeat examination will be conducted on the next academic year.