Faculty of Science
Theory: 5 Hrs Practical: 30 Hrs Independent Learning: 35 Hrs Provide knowledge and practical experience on ICT tools and techniques required in the present learning and working environment. Intended Learning Outcomes: Fundamentals of ICT (5 Hours) Word Processing (with Advanced Techniques) (10 Hours) Presentation Techniques ( 05 Hours) Spreadsheet Applications (10 Hours) Applications on the Internet (6 Hours) Teaching / Learning Methods: Lecture, laboratory practical, Discussion, tutorial classes In-course assessment : 10% Mid Semester Examination : 30% End of course Examination : 60% 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%. 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. Students would be able to 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. Fundamentals of ICT (15 Hours) Word Processing (with Advanced Techniques) (14 Hours) Presentation Techniques ( 07 Hours) Spreadsheet Applications (12 Hours) Database Handling (12 Hours) In-course assessment : 60% End of course Examination : 40% 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. COM101G0: Computer Literacy for Science (New Syllabus)
Objectives
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
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
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
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
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
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
Method of Evaluation
1
Two Theory Assessment
01 hour each
2
Two Practicals Assessment
90 minutes each
Part I
MCQ and Structured questions – 02 hour
Part II
Practical – 02 hours
Part I
MCQ and Structured questions – 02 hour
Part II
Practical – 02 hours
COM106GA2: Computer Literacy (Old Syllabus)
Objectives
Outcome
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
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
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
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
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
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
1
Two Theory Assessment
01 hour each
2
Two Practicals Assessment
90 minutes each
Part I
MCQ and Structured questions – 02 hour
Part II
Practical – 02 hours