Syllabus (COMPUTER SCIENCE)

Course Type: MDC-1

Semester: 1

Course Code: BMDCCAP01T

Course Title: Computer Application

(L-P-Tu): 3-0-0

Credit: 3

Practical/Theory: Combined

Course Objective: • Learn about basic terminology of Computers. • Familiar with Computer architecture. • Understand Word Processing, Spreadsheet, and Presentation Graphics Software Skills. • Understand basic ideas of Operating System and Computer Network.

Learning Outcome: • Ability to use MS Office Applications. • Ability to analyze data using MS Excel. • Ability to understand Operating System and it’s working. • Ability to use Internet safely.

Introduction to Computer and Operating System

Computer and its Characteristics, Applications, Types, Components of Computer System, Input and Output Devices, Generation of Computer, Concept of Hardware and Software, Types of Software, Computer Memory, Concept of Computing, Data and Information, Computer Arithmetic and Number System (Binary, Decimal, Octal, Hexadecimal), Arithmetic Operations on Binary Numbers, ASCII, EBCDIC, BCD Codes, Operating System and it’s functions. (20 Lectures)

MS Office

MS Word: Word Processing Basics, Opening and Closing Documents, Text Creation and Manipulation, Formatting Text, working with objects, Tables, Merging Documents, MS Excel: Spreadsheet basics, Working with Functions and Formulas, Charts and Graphs, Analyzing Data, Macro, MS PowerPoint: Opening and Viewing Slides, Auto Layouts, Customs Animation, Slide Transitions, Charts and Graphs, Hyperlinks. (15 Lectures)

Internet and Email

Introduction to Computer Network and its types, Internet and Intranet, Internetworking Devices, Transmission Media, www, Popular Web Browsing Software, Search Engines, Web Page, Website, URL, email, Applications of Internet. (10 Lectures)

References:

1. Ron Mansfield , “Working in Microsoft Office” , TMH.
2. Dr. Anita Goel, “Computer Fundamentals”, Pearson Education.
3. V. Rajaraman, “Fundamentals of Computers”, PHI.
4. M. Mano, “Computer System Architecture”, Pearson Education.
5. A. Silberschatz, P.B. Galvin, G. Gagne, John, “Operating Systems Concepts”, Wiley Publications.
6. Tanenbaum, “Computer Networks”, PHI.