Computer Science Syllabus / Course Outlines Associate in Degree Arts / Science (ADP) Sargodha University

Syllabus / Course Outlines of Computer Science Part One and Two Associate Degree in Arts / Science University of Sergoda

Paper-A:        Introduction to Information Technology & Computer programming     70 Marks This paper will consist of two sections.

Section-I:       Introduction to Information Technology    35 Marks

Overview of Computer Systems: Uses, importance, future needs; Types of Computers: super, mainframe, mini, micro, desktop, notebook, personnel, and workstations. Processing of Data: data and information, text codes. Part of Computer: CPU, control unit, arithmetic unit, memory, ROM, RAM, flash technology,, flash memory, cache memory, computer clock, control bus, data bus, address bus. co-processors, types of microprocessors. Interacting with Computer: input devices, e.g. key board, keys, arrangement on keyboard, mouse trackballs, touch pads pens, touch screens, barcodereaders etc; output devices: monitors, types of monitors, resolution, refresh rate, dot pitch etc. Printers: types of printers, plotters. Storage Devices: floppy disk, hard CD, tape disk, magnetic and optical storage Types of Software: Systems software, shareware, and application software. Operating Systems: operating systems user interface, running programs, managing files, managing hardware, utility programs. Network and Data Communication: uses of network. Types of Network: LAN, WAN, Pile Server, Client/Server, peer-to-peer. Network Topologies: bus, star ring. Network Media and Hardware, Network Software, Data Communication over Telephone Lines: modem, ISDN, Tl, T3 and ATM. Internet: How does internet works, backbones, gateways, addressing schemes. Features of Internet: email, news, telnet, FTP, gopher’ chat’ World Wide Web, online services. Accessing the Internet Application : connection through LAN. connection through modem, connection through high-speed lines.

Recommended Books:

1. Introduction to Computers” by Peter
2. Discovering Computers 2002”, G.B. Shelly. TJ. Cashman and M.E.
3. Introduction to Computer Science”, Scham’s

Section-II:     Computer Programming  35 Marks Tool:

Visual Basics:

Introductory Programming Concept: problem solving, algorithms and pseudo code. Programming Techniques : visual programming, event driven programming, object oriented programming, structured programming. Visual Basic Integrated Development Environment. Control Elements. Data Types. Variables and Assignment Statements. Arithmetic Operators and Scope: data conversions, expressions, variable scope, declaring form and project variables and constants. Modules and Procedures: sub-procedures, event procedures, function procedures, and optional, argument. Branching and Looping: procedures, function procedures, and optional argument. Branching and Looping: relational operators and logical expressions, logical operators, if-then-Else, Case, For- Next, Looping with Do and While Ipp: Menu and Dialog Boxes ; Arrays Searching and ! Sorting: what is array, declaring arrays, using arrays, control arrays, enumerations user defined types. Error Handling. Sequential Files: file details, file operators, add report to programs, programming with fixed report length. Introductory database programming: why use database, data control, and creating data-bound controls.

Recommended Books:

1. Computer programming with Visual Basic 6” by Alka R. Harriger, Susan K.
2. Visual Basic 6: How to Program” by Deitel, Deitel and Nieto Prentice-Hall.
3. Visual Basic” by B. S. Gottfried (2001 Schaum’s
4. Using Visual Basic (Special Edition)”, by Brian Siler and Jeff

Paper-B: Practical 30 Marks

Section-I:    15 Marks

Windows 2000:

1. Exploring Windows 2000 work place: desktop component and customizing them exploring parts of a window, menu and dialog boxes, multitasking, and shutting down windows.
2. Working with the Accessories: calculator, notepad, wordpad, paint program, media player,
3. Organizing files and folders using window
4. Using Windows System Tools, Working with Control Panel Installing new software and hardware
5. Using Internet: Working with Internet explorer, surfing with internet explorer, working with e-mail.

Word 2000:

1. Exploring Word 2000 work place: document, menus, toll bars, dialog boxes and other icons:
2. Saving and opening
3. Editing and formatting
4. Formatting and printing documents
5. Working with tables and graphics
6. Working with Mail ‘Merge and hyper links

Excel 2000:

1. Exploring Excel 2000 work place: workbook; worksheet, menus, toll bars, dialog boxes, and other
2. Worksheet basic: entering data, editing worksheet, inserting & deleting cell, hiding data, copying data and auto
3. Formatting and printing a work
4. Using functions in –
5. Creating chartsa and adding

Front Page 2000:

1. Exploring Front Page
2. Designing documents: working from Page
3. Developing the basic page: text, list, and hyperlinks, tables,
4. Enhancing pages with graphics and
5. Publishing pages on the

Recommended Books:

1.  “Microsoft Windows 2000 Professional : Comprehensive Course” by D. Busceh and M. Bergerud (2001).
2. “Teach Yourself: Microsoft Windows 2000-Professional” by B.
3. “Microsoft Windows: millennium edition fast & easy’, by D. Koers (2000).
4. ‘.Microsoft Word 2000 Simplified” from maran Graphics, IDG Books (1999).
5. “Learn Word 2000″ by J. Preston. S. Preston, and R. Ferrett (1999).
6. “Excel for Windows 2000” by M.-Langer (1999).
7. “Microsoft Excel 2000: Comprehensive Course” by H.A. Napier and P.J. Judd
8. “Using Front Page 2000: special edition” by N. Randall and D. Jones (1999).
9. “Mastering Front Page 2000” by D.A. Tauber & et. al. (2001).

Section-II:   15 Marks

Students must implement the concepts studied in theory part. For practice see examples given in “Computer programming with Visual Basic 6” by A. R. Harriger, S.K. Lisack and “Visual Basic 6: How to Program” by Deitel. Deitel and Nieto. Some practical examples AS guide line are given below:

1. Test if a given integer is odd or
2. Given the sides of a triangle, determine the type of the
3. Print integers in the specified range; make every alternate integer in the output
4. Print Leap years in a give
5. Given two strings, count the number of times the second string appears in the first
6. Create a Program that convert Fahrenheit temperature to the Celsius scale and back
7. Search to a given name in an array of
8. Reverse an
9. Reverse a given
10. Build a scientific

Associate Degree in Arts / Science Computer Studies-II

Paper-A:        Data Base Management Systems

& System and Network Administration   70 Marks

Section-I:Database Management System  35 Marks

Theory:

Introduction to Database Processing: relationship of application programs and the DBMS, file-processing systems, database processing systems, history of database processing. Database Development: database and DBMS, creating a database, components of database applications, database development processes. Entity Relationship modeling. Semantic Object Model. Relational Model and Normalization: relational model, normalization —l to 5th normal forms, domain/key normal form, synthesis of relations, multivalued dependencies, Iteration 2. Database Design Using Entity- Relationship Models: transformation of entity-relationship models into relational database designs. Database Design with Semantic Object Models: transformation of database designs. Database Design with Semantic Object Models: transformation of semantic objects into relational database designs. Database Application Design: characteristics of database applications, form design, report design, application program design. Foundations of Relational Implementation: defining relational data, relational data manipulation. Structured Query Language: querying a single table, querying multiple tables, exists and not exists, changing data. Relational Implementation for Personal Databases: creating the database schema, creating forms, creating reports. Client-Server database systems : client-server architecture, reliability and security, open database connectivity (ODBC) standards, applications of ODBC in client-server systems.

Recommended Books:

1. “Data Base Processing”, Sixth Edition by David M. Kroenke (1998).
2. “Database Systems” by C.M.
3. “Fundamental of Database Management Systems”, by R. Elmarsi and S.B.
4. “Fundamental of Database Systems” by C. J. Date

Section-II:  Operating Systems and Networks 35 Marks

Introduction to Operating Systems: Types of operating systems, operating systems modes. Process Management: process scheduling, process state, scheduling criteria, process supervisor calls. Inter-process Communication and Synchronization : inter process communication, deadlock, deadlock presentation, deadlock avoidance, deadlock detection recovery from deadlock. Memory Management : simple absolute partition, single relocate able partition, multiprogramming, multi partitions, simple paging, simple segmentation. segmentation with paging, page and segment table, swapping, overlaying. Virtual Memory: demand paging, segmentation. File Systems Management: directories and names, types of file systems objects, file system functions, information types, file system architecture. Device Management: hardware I/O organization, software organization, devices. Security: authentication, preventation. detection, correction, identification, threat categories, program threats.

Networking Basic Concepts: line configuration, topologies, transmission modes, categories of network, internetwork. The OSI Model: layered architecture, functions of the layers. TCP IP protocols suite. Transmission Media: twisted-pair, coaxial cable optical fiber:

Recommended Books:

1. “Operating Systems” by J.A. Harris (Schaum’s outlines)
2. “Data Communications and Networking” by B.A. Forouzan. 2nd

Paper-B: (Practical) 30 Marks

Section-I           15 Marks

1. Exploring Access 2000 work place: opening access applications, menus, toll bars other components.
2. Designing and creating a
3. Entering and editing data into
4. Designing and using basic
5. Integrating Access with other Microsoft Office applications and
6. Establishing Relationships between
7. Finding sorting and filtering
8. Creating basic
9. Designing and using basic
10. Creating and using data access
11. Creating action queries.nine advanced

Recommended Books:

1. “Microsoft Access 2000: Comprehensive Course” by H.A. Napier & P. J. J. (2001)

Section-II   15 Marks

1. Installation of Windows 2000 Professional: Installation from CD, Installation from
2. Configuring the Windows 2000 Environment: Control Panel, Management Installing New Hardware.
3. Managing the Desktop: Desktop Settings, Accessibility Features, Local
4. Managing Users: Creating Users. Disabling User Account, Deleting User Account. Renaming User, Changing Password. Managing User
5. Managing Groups: Creating Groups, Group Membership, Renaming Group, Deleting Group, Local Group
6. User Profiles and Hardware Profiles: Local User Profiles, Roaming Profiles. Mandatory Profiles, Managing Hardware
7. Managing Disks: File Systems. File System Conversions. Disk Storage, Disk Management Utilities.
8. Files and Printing Management: File and Folder Basic Management, Creating Shares, Share Permissions. Managing Printer Properties. Sharing Printer, Printer
9. Managing Network Connections: Network Dataflow, OSI Model Layer, Installation and Configuration of Network Adaptor. Installing and Configuring Network
10. Dialup Networking and Internet Connectivity: Configuring General Modem Properties. Running Modem Diagnostics, Configuring Advanced Modem Properties
11. Managing System Recovery Functions: Recovery and Backup, Using Backup Utility. Using Restore

Recommended Books:

1. “Windows 2000 Professionals Study Guide” by L, Donaisald (2001).