Faculty of Science

COM101G0: Computer Literacy for Science (New Syllabus)

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)

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.