DETAILED SYLLABUS FOR DISTANCE EDUCATION Post Graduate Diploma (One Year, Semester System) Post Graduate Diploma in Computer Teachers Training in Schools FIRST SEMESTER PGDCTTS-110 INTRODUCTION TO IT Maximum Time : 3 Hrs. University Examination : 40 Marks Total Marks : 100 Continuous Internal Assessment : 60 Marks Minimum Pass Marks : 40% A) Instructions for paper-setters The question paper will consist of four sections A, B, C, D. Sections A, B and C will have two questions from the respective sections of the syllabus and will carry 20% marks each. Section D will have 10-20 short answer type questions which will cover the entire syllabus uniformly and will carry 40% marks in all. B) Instructions for candidates 1. Candidates are required to attempt one question each from sections A, B and C of the question paper and the entire section D. 2. Use of non-programmable scientific calculator is allowed. SECTION A An Overview of the Compute System- The Processor (CU, ALU), Factors affecting processor speed, The Bus-Data Bus and Address Bus. Memory (RAM, ROM, Registers, Cache). I/O Devices (Mouse, Keyboard, Monitors, Printers, Pens, Touch Screens, Microphones and Voice Recognition), Storage Devices (Diskettes, Hard Disc, CD-ROM). Computer Categorization. SECTION B Network-Uses, Categories & Topologies. System Software and Application Software, Operating System-User Interface, Resource Management, Utility Software. Word Processing and Desktop Publishing, Spreadsheets & Basics of Database Management. SECTION C Programming Language: High level language, Low Level Language & Assembly Language. Major Features of the Internet, Working with Graphics, Types of Information Systems & System Development Life Cycle. References: 1. Introduction to computers by Peter Norton Tata McGraw-Hill Publishing Company Ltd. 2. Using Information Technology by Williams Sawyer Irwin/McGraw Hill. PGDCTTS-120 PC COMPUTING Maximum Time : 3 Hrs. University Examination : 20 Marks Total Marks : 50 Continuous Internal Assessment : 30 Marks Minimum Pass Marks : 40% A) Instructions for paper-setters The question paper will consist of four sections A, B, C, D. Sections A, B and C will have two questions from the respective sections of the syllabus and will carry 20% marks each. Section D will have 10-20 short answer type questions which will cover the entire syllabus uniformly and will carry 40% marks in all. B) Instructions for candidates 1. Candidates are required to attempt one question each from sections A, B and C of the question paper and the entire section D. 2. Use of non-programmable scientific calculator is allowed. SECTION A Windows 2000: - Windows concepts, features, windows structure, desktop, taskbar, start menu, my computer, Recycle Bin, Windows Accessories. System Tools, communication, Sharing Information between Programs. SECTION B Word Processing: MS Word: - Introduction to Word Processing, Interface, Toolbars, Ruler, Menus, Keyboard Shortcut, Editing a Document, Previewing documents, Printing documents, Formatting Documents, Checking the grammar and spelling, Formatting via find and replace, Using the Thesaurus, Using Auto Correct, Auto Complete and Auto Text, word count, Hyphenating, Mail merge, mailing Labels Wizards and Templates, Handling Graphics, tables and charts, Converting a word document into various formats. SECTION C Worksheets: MS EXCEL - Creating worksheet, entering data into worksheet, heading information, data, text, dates, alphanumeric, values, saving & quitting worksheet, Opening and moving around in an existing worksheet, Toolbars and Menus, keyboard shortcuts, Working with single and multiple workbook, Working with formulas & cell referencing, Formatting of worksheet. Reference: 1. Mastering MS Office 97 Professional by Mosley, BPB Publication 2. Mastering MS Office 2000 Professional Edition by Courter, BPB Publication 3. MS Office 2000 Training Guide by Maria, BPB Publications 4. MS Office 2000 complete by SYBEX. PGDCTTS-120 P PC COMPUTING Maximum Time : 3 Hrs. University Examination : 20 Marks Total Marks : 50 Continuous Internal Assessment : 30 Marks Minimum Pass Marks : 40% The laboratory course will comprise of exercises on what is learnt in the theory classes of the same course i.e. PGDCTTS-120 PGDCTTS-130 OPERATING SYSTEMS Maximum Time : 3 Hrs. University Examination : 20 Marks Total Marks : 50 Continuous Internal Assessment : 30 Marks Minimum Pass Marks : 40% A) Instructions for paper-setters The question paper will consist of four sections A, B, C, D. Sections A, B and C will have two questions from the respective sections of the syllabus and will carry 20% marks each. Section D will have 10-20 short answer type questions which will cover the entire syllabus uniformly and will carry 40% marks in all. B) Instructions for candidates 1. Candidates are required to attempt one question each from sections A, B and C of the question paper and the entire section D. 2. Use of non-programmable scientific calculator is allowed. SECTION A Introduction to operating System, its need and Operating system services, Definition, Early systems, Simple batch systems, Multiprogrammed batched systems, Time sharing systems, Personal computer systems, Parallel systems, Distributed systems and Real time systems. Process Management: Process concept, Process scheduling, Definition of context switching and Threads. CPU Scheduling: Basic concepts, Scheduling criteria, Scheduling algorithms SECTION B Deadlocks: Deadlock characterisation, Methods for handling deadlocks, Deadlock prevention, Deadlock avoidance, Deadlock detection and recovery. Memory Management: Logical versus Physical address space, Swapping, Contiguous allocation, Paging, Segmentation, Segmentation with paging. Virtual Memory: Demand paging, Performance of demand paging, Page replacement, Page replacement algorithms, Thrashing. SECTION C File management: File system Structure, Allocation methods: Contiguous allocation, Linked allocation, Indexed allocation, Free space management: Bit vector, Linked list, Grouping, Counting, Directory implementation: Linear list, Hash table. Device Management: Disk structure, Disk scheduling: FCFS, SSTF, SCAN, C-SCAN, LOOK, Selecting disk scheduling algorithm. References: 1. Abraham Silberschatz, Peter B. Galvin, " Operating System Concepts", Addison-Wesley publishing. Co., 4th. Ed., 1994. 2. Brinch Hansen, "Operating System Principles", Prentice-Hall, 1984. 3. N. Haberman, "Introduction to Operating System Design", Galgotia Publication, 1986. 4. Brich Hansen, "The Architecture of Concurrent Programs", PHI, 1978 PGDCTTS-130 P OPERATING SYSTEMS Maximum Time : 3 Hrs. University Examination : 20 Marks Total Marks : 50 Continuous Internal Assessment : 30 Marks Minimum Pass Marks : 40% The laboratory course will comprise of exercises on what is learnt in the theory classes of the same course i.e. PGDCTTS-130 PGDCTTS-140 PROGRAMMING TECHNIQUES AND ALGORITHMS USING C Maximum Time : 3 Hrs. University Examination : 20 Marks Total Marks : 50 Continuous Internal Assessment : 30 Marks Minimum Pass Marks : 40% A) Instructions for paper-setters The question paper will consist of four sections A, B, C, D. Sections A, B and C will have two questions from the respective sections of the syllabus and will carry 20% marks each. Section D will have 10-20 short answer type questions which will cover the entire syllabus uniformly and will carry 40% marks in all. B) Instructions for candidates 1. Candidates are required to attempt one question each from sections A, B and C of the question paper and the entire section D. 2. Use of non-programmable scientific calculator is allowed. SECTION A Problem Solving with Computers: Algorithms, Pseudocodes and Flowcharts. Data types, constants, variables, arithmetic and logical expressions, data input and output, assignment statements, conditional statements. SECTION B Iteration, arrays, string processing, User-defined data types, functions, recursion, Parameter Passing by reference & by value. SECTION C Structures, Multiple structures, Arrays of structures, Unions, and Files: Reading, Writing text and binary files, Pointers, character pointers, pointers to arrays, Array of pointers, pointers to structures. References: 1. Richie and Kerningham, " C programming". 2. Rajaraman, V: Fundamentals of Computers (PHI, 1992) 3. D. Dromey "How to solve it by Computer", Prentice-Hall, 1985 4. R.S. Salaria, "Application Programming in C", Khanna Book Publishing Co. (P) Ltd., N. Delhi. 5. Kanetkar, "Let Us C", BPB Pub PGDCTTS-140 P PROGRAMMING TECHNIQUES AND ALGORITHMS USING C Maximum Time : 3 Hrs. University Examination : 20 Marks Total Marks : 50 Continuous Internal Assessment : 30 Marks Minimum Pass Marks : 40% The laboratory course will comprise of exercises on what is learnt in the theory classes of the same course i.e. PGDCTTS-140 SECOND SEMESTER PGDCTTS-210 COMPUTERS IN SOCIETY Maximum Time : 3 Hrs. University Examination : 40 Marks Total Marks : 100 Continuous Internal Assessment : 60 Marks Minimum Pass Marks : 40% A) Instructions for paper-setters The question paper will consist of four sections A, B, C, D. Sections A, B and C will have two questions from the respective sections of the syllabus and will carry 20% marks each. Section D will have 10-20 short answer type questions which will cover the entire syllabus uniformly and will carry 40% marks in all. B) Instructions for candidates 1. Candidates are required to attempt one question each from sections A, B and C of the question paper and the entire section D. 2. Use of non-programmable scientific calculator is allowed. SECTION A A history of computer technology, inside the computer system unit, data storage, input and output, system software, programming language, an introduction to application software, word processing, spread sheets, databases, presentation packages. SECTION B Special purpose programmes, multimedia and virtual reality, understanding the internet, using the email. Computer issues- ethics, security, emerging technology. SECTION C Computer in society: Computer in business and industry, computer in education, computer in health, computer crime and security. References: 1. Merilyn Meyer, Rober Bakers-"Computers in your future" PHI 2. Nancy stern, Robert A Stern "Computers in your future" PHI PGDCTTS-220 INTERNET & ITS APPLICATIONS Maximum Time : 3 Hrs. University Examination : 20 Marks Total Marks : 50 Continuous Internal Assessment : 30 Marks Minimum Pass Marks : 40% A) Instructions for paper-setters The question paper will consist of four sections A, B, C, D. Sections A, B and C will have two questions from the respective sections of the syllabus and will carry 20% marks each. Section D will have 10-20 short answer type questions which will cover the entire syllabus uniformly and will carry 40% marks in all. B) Instructions for candidates 1. Candidates are required to attempt one question each from sections A, B and C of the question paper and the entire section D. 2. Use of non-programmable scientific calculator is allowed. SECTION A Introduction to HTML, HTML and the World Wide Web, HTML elements, basic structure elements of HTML, the two categories of body elements – block level and text level, creating HTML pages, viewing pages in different browsers, rule for nesting. HTML tags, colours and fonts, formatting the body section, creating links, creating external links, creating internal links. Adding graphics with image elements, image element attributes, using image as links, image maps, image files. Adding sound, sound formats. SECTION B Presenting information in tables, table attributes, layout tools, use of frames, Using forms, form elements SECTION C FrontPage: - Introduction to FrontPage Modules, FrontPage Editor, Microsoft Images Composer (MIC), FrontPage Explorer, Personal Web Server, Using the FrontPage Editor to create pages on the C drive, Creating Hyperlinks, Using Tables, Images – as decoration and as hyperlinks, Creating a feedback form, Importing Pages into FrontPage Explorer, Publishing your Web Page- on an Intranet and on an Internet Server References: 1. E. Stephen Mack and Janam Platt, "HTML", BPB Publications. 2. Minoli, "Internet and Intranet Engineering", TMH 3. Jones " How to do everything with the internet". PGDCTTS-220 P PRINCIPLES OF INTERNET & ITS APPLICATIONS Maximum Time : 3 Hrs. University Examination : 20 Marks Total Marks : 50 Continuous Internal Assessment : 30 Marks Minimum Pass Marks : 40% The laboratory course will comprise of exercises on what is learnt in the theory classes of the same course i.e. PGDCTTS-220 PGDCTTS-230 PLANNING & MANAGEMENT OF COMPUTER CENTRES IN SCHOOLS Maximum Time : 3 Hrs. University Examination : 40 Marks Total Marks : 100 Continuous Internal Assessment : 60 Marks Minimum Pass Marks : 40% A) Instructions for paper-setters The question paper will consist of four sections A, B, C, D. Sections A, B and C will have two questions from the respective sections of the syllabus and will carry 20% marks each. Section D will have 10-20 short answer type questions which will cover the entire syllabus uniformly and will carry 40% marks in all. B) Instructions for candidates 1. Candidates are required to attempt one question each from sections A, B and C of the question paper and the entire section D. 2. Use of non-programmable scientific calculator is allowed. SECTION A Basics of Management Theory and Science, Planning: - Nature and purpose of planning, Objectives, Strategies and policies, Decision making Organizing: - Nature of organizing, Basic Departmentation, Staff Authority and decentralization, Orgnisational Culture SECTION B Staffing: - HRM Human Resource Management and Selection, Performance, Organisation Development SECTION C Leadership: - Motivation, Leadership, Communication Management of Computer Centres and Schools Reference: 1. Essentials of Management by Harold Koontz Heinz Weihrich of TMH PGDCTTS-240 DBMS CONCEPTS Maximum Time : 3 Hrs. University Examination : 20 Marks Total Marks : 50 Continuous Internal Assessment : 30 Marks Minimum Pass Marks : 40% A) Instructions for paper-setters The question paper will consist of four sections A, B, C, D. Sections A, B and C will have two questions from the respective sections of the syllabus and will carry 20% marks each. Section D will have 10-20 short answer type questions which will cover the entire syllabus uniformly and will carry 40% marks in all. B) Instructions for candidates 1. Candidates are required to attempt one question each from sections A, B and C of the question paper and the entire section D. 2. Use of non-programmable scientific calculator is allowed. SECTION A Overview of DBMS: Basic DBMS terminology, DBA and his responsibilities, Physical and Logical data independence. Architecture of DBMS: Distributed Databases, (Structure design), and Client/Server architecture. SECTION B Entity Relationship Model: Entity, Entity Set, Attributes, Tuples, Domains, Keys: Super and Candidate Key. Overview of Hierarchical, Network and Relational Models. Comparison of Network, Hierarchical and Relational Models. SECTION C Relational Model: Storage organisation for relations, Relational Algebra: Set operators, Relational operators, Decomposition of relation schemes, Functional dependencies, Multivalued dependencies, Normalisation. Relational Query Language: DDL, DML, DCL. Database Integrity: Domain integrity, Entity integrity, and referential integrity. Security: Authorisation, Access Matrix, Concurrency, Locks, Serializability, and Recovery. References: 1. C.J. Date, "An Introduction to Data Base Systems", 3rd Ed., Narosa Publishers, 1997 (Reprint). 2. Jeffrey D. Ullman, "Principles of Database Systems", 2nd Ed., Galgotia Publications, 1984. 3. D. Kroenke., "Database Processing", Galgotia Publications, 1987. 4. Henry F. Korth, "Database System Concepts", McGraw Hill. Inc., 1997. Naveen Prakash, "Introduction to Database Management", TMH, 1993. PGDCTTS-240 P DBMS CONCEPTS Maximum Time : 3 Hrs. University Examination : 20 Marks Total Marks : 50 Continuous Internal Assessment : 30 Marks Minimum Pass Marks : 40% The laboratory course will comprise of exercises on what is learnt in the theory classes of the same course i.e. PGDCTTS-240 14 1