PGDCA Course Detail

FACULTY OF EDUCATION ORDINANCES & SYLLABUS FOR POST GRADUATE DIPLOMA IN COMPUTER APPLICATIONS (TEACHER EDUCATION) EXAMINATION : 2009
GURU NANAK DEV UNIVERSITY
AMRITSAR

Note : Copy rights are reserved. No body is allowed to print it in any form. Defaulters will be prosecuted Price Rs. 50-00

 

1.1 Any graduate under 10+2+3 system with at least 45% marks in aggregate

2.1 The duration of the course shall be one year from Aug. to May every academic year.

2.2 An examination shall be held at the end of academic year at such place/sand on such dates as may be decided by the University.

2.3 There shall be six papers and one project report of 100 marks.

2.4 The dates/s by which the admission forms and fees for examination must reach the Registrar shall be decided by the University.

2.5 Three days of grace may be allowed after the last date without late fee for the receipt of admission forms and fees.

2.6 The medium of instruction and examination shall be English.

2.7 The examination shall be held according to syllabi and courses of reading recommended by the Board of Studies in Computer Science & Engg. and approved by the appropriate bodies.

2.8 The result shall be declared by the Registrar as soon as possible after the termination of examination.
 

2.9 Each successful candidate shall receive diplomas issued by the University stating marks and division.
The minimum pass marks shall be 35% separately for theory and practical in each paper. The successful candidates shall be placed in the following
divisions :

A

B

C

D

Those who obtained 75% or more First division with
distinction

Those who obtained 60%or more but less than 75%marks. First division.

Those who obtained 50% or more but less than 60%marks.Second division.

Those who obtained less than 50%of the total marks. Third division.

2.10 Two additional consecutive chances may be given to a candidate to clear this examination, i.e. one in September and second in April (Along with regular candidates).

2.11 The examination shall be open to a student who is eligible as laid down in ordinance 1.1 and has his name sent up by the Principal concerned with the following certificates :-
a) of having been enrolled in the college for the academic year proceeding the examination.
b) of good moral character.
c) of having attend 75% of the lectures delivered.
 

2.12 The Principal of the college concerned shall have the power to condone in lectures in each paper up to 10% of the total number of Lectures delivered.

2.13 A candidate who have attended the prescribed number of lectures, does not appear in the examination or having appeared has failed or has been placed under reappear in one or more paper/s, may be allowed to appear as an ex-student on the recommendation of the Principal concerned. In such cases, the candidates shall be examined as per the course outlines in force at that time.

2.14 There shall be an examiner in each paper to be appointed by the University on the recommendation of the Board of Studies in Computer Science. The question paper shall be set by the examiner and answer books evaluated by him as per University suggests.

2.15 The Diploma shall be awarded on the successful completion/evaluation of theory and practical papers.

Note : The Ordinances are subject to the addition/amendments approved by the competent authority. Instructions for the Examiners

1. There shall be six papers and one project report. Each paper will be of 3 hours duration

2. Each theory paper will be of 50 marks. In each paper a separate practical of 50 marks will be conducted before/after the theory papers. Project report will be of 100 marks.

3. Each paper will be divided into five units. Examiners will be set two questions from each unit with internal choice.

 The students will be asked to attempt five questions selecting one question from each unit. Each question will carry 10 marks.

4.SCHEME OF STUDY

PAPER

SUBJECT 

THEORY

PRACTICAL

Total

PAPER-1

Fundamentals of computer
and operating systems.

50

50

100

Paper-2

Computer Aided teaching

50

50

100

Paper-3

PC-computing (MS
office& DTP)

50

50

100

Paper-4

Introduction to scripting
languages and web design.

50

50

100

Paper-5

Database management
system, system analysis & design.

50

50

100

Paper-6

Programming in C

50

50

100

Paper-7

PROJECT REPORT

100

 

100

 

Total

 

 

700


PAPER – I
FUNDAMENTALS OF COMPUTER & OPERATING SYSTEMS

Time : 3 Hours

Max. Marks : 100

Theory: 50

Practical: 50

Instructions for the Paper Setter :-

1. Each paper will be divided into five units. Examiners will set two questions from each unit with internal choice.

2. The students will be asked to attempt five questions selecting one question from each unit. Each question will carry 10 marks.

Unit - I
Fundamentals of Computer : Introduction to computer, Applications of computer, components of computers, Input-output devices (keyboards, mouse, track ball, light pen,cards, printers, plotters, scanners), Secondary storage devices (floppy disk, magnetic disk,Winchester disk, optical disk).

Unit – II
Connecting devices to Computers (Expansion slots, Adapter Boards, Serial/Parallel I/O ports (SCSI). Problem Analysis : Flowcharts, Algorithms, Decision tables. Types of Software, Translators (compiler, interpreter, assembler), Introduction to data communication and network. Number System, Computer Arithmetic.

Unit – III
Introduction to Windows 95 : Parts of window screen (Desktop, window, icons), start menu, Taskbar settings, application & document window, anatomy of a window (Title bar, Minimize, maximize button, control box, scroll bars, scroll buttons, scroll boxes), window explorer (expansion, collapsing of directory tree, copying, moving, deleting Tiles, Folder, creating folders), About desktop icons (recycle bin, my computer, network neighborhood, briefcase), folder, shortcut creation, setting of screen saver, color, setting, wallpaper, changing window appearance.

Unit – IV
Introduction to Operating System: Meaning of operating system, its functions, batch systems, real systems, multiprogramming, multitasking, single, multi user systems. Memory Management Techniques, Process Management, Device Management , File Management Techniques.

Unit – V
Disk Operating System : Define dos, Structure of Ms-Dos (description of booting files, steps to boot the system), hot & cold booting, internal command (cls, dir, date, time, vol, ver, copy con, type, ren, del, md, rd, cd, path, prompt), external commands edit, attrib, backup, restore, chkdsk, diskcopy, diskcomp, deltree, edit, format, fdisk, find, label, more, xcopy, move, print, scandisk, sort, sys, doskey, tree).

REFERENCES :
1. PC Software : By Rachpal Singh & Gurinder Singh
2. Operating System : Galvin Sielberschatz
3. Fundamentals of Computer : By P.K. Sinha

PAPER – II
COMPUTER AIDED TEACHING

Time : 3 Hours

Max. Marks : 100

Theory: 50

Practical: 50

Instructions for the Paper Setter :-

1. Each paper will be divided into five units. Examiners will set two questions from each unit with internal choice.

2. The students will be asked to attempt five questions selecting one question from each unit. Each question will carry 10 marks.

Unit – I
- Teaching its meaning, Principles and Maxims
- Learning its meaning and factors of learning
- Programmed Learning its meaning, types of programmed learning
- Linear, Branching and Mathematics

Unit – II
-Information Communication Technology- Concept, Objectives and role of ICT in teacher education

Unit – III
-Innovations in Teaching technology
-Computer-Assisted-Instructions,
-Personalized system of instruction .
-Learner Controlled Instructions.
-Use of Computer in school education

Unit – IV
-Multi-Media approach in teaching : use of Radio, T.V., Tape Recorder, V.C.R., OHP, Slide Projector and Computer as teaching machines.
-Educational use of internet

Unit – V
Teaching material; pictures, charts, diagrams, graphs, Cartoons and programmed learning packages.
- Use of Computer in making teaching material
-School records and registers - students record- cumulative record card
-Registers
–Pupil attendance register, Teacher attendance register and Admission and Withdrawl Register
-Use of Computer in making records and register.

REFERENCES :
1. Anand Bhushan & Malvinder Ahuja : Educational Technology.
2. M.S. Sachdeva & Inderdev Singh Nandra : A New approach to Technology of Teaching.
3. M. Mukhopadhyay (Ed) : Educational Technology.
4. S.K. Mangal: Technology of Teaching

PAPER III
PC COMPUTING (MS OFFICE & DTP)

Time : 3 Hours

Max. Marks : 100

Theory: 50

Practical: 50

Instructions for the Paper Setter :-

1. Each paper will be divided into five units. Examiners will set two questions from each unit with internal choice.

2. The students will be asked to attempt five questions selecting one question from each unit. Each question will carry 10 marks.

Unit I
MS-Word : Introduction to MS-Office, Ms-Access, Ms-Excel. Parts of window of word (Title bar, menu bar, status bar, ruler), Creation of new documents, opening document, insert a document into another document. Page setup, margins, gutters, font, Properties, Alignment, page breaks, header footer. Deleting, moving, replace, editing text in document. Saving a document, spell checker, printing a document. Creating a table,
entering and editing Text in tables. Changing format of table, height width of row or column. Editing, deleting Rows, columns in table. Borders, shading, Templates, wizards, Drawing objects, mail merge.

Unit II
Ms-Power point : Introduction to Ms Power point. Power point elements (templates Wizards Views, color schemes, Exploring power point menu (opening & closing menus, working with dialogues boxes), adding text, adding title, moving text area, resizing text Boxes, adding pictures. Starting a new slide, saving presentation, printing slides. Views (slide View slide sorter, notes view, outline view). Formatting & enhancing text formatting, Choosing transitions. Creating a graph, displaying slide show, adding multimedia. Slide transitions. Timing slide display, adding movies & sounds. Using a pick look Wizards to change format.

Unit III
Ms-Excel : Introduction to Worksheet/Spreads, Features of excel, Describe the excel Window, different functions on different data in excel, creation of graphs, editing it and formatting, changing chart type of 2nd chart or 3rd chart, creation of worksheet, adding, deleting, moving the text in worksheet, linking different sheets, 9 sorting the data, querying the data, filtering the data (auto and advance filters), What-if analysis, printing a worksheet.

Unit IV
PhotoShop 5.5
1. Introduction to Graphics, Vector Graphics & Bitmaps.
2. Understanding Image Size & resolution.
3. Relation between resolution, File sizes & output.
4. Using menus & Palettes.
5. Concept of Path (Segment, Anchor, Curved, Closed, Open, Sub path).
6. PhotoShop Tools (Pen, Pencil, Brush, History, Air, Eraser, Rubber stamp, Smudge, Dodge, Burn, Sponge), Marks & Histogram.
7. Acquiring & Importing Images.
8. Concept of Lyres Channels & Path, Filters, Rendering Effects, Transformation, Strokes, Image Modes, Canvas & Images.
9. Using navigator & PhotoShop plug-in.

Unit V
CorelDraw9
1. Concepts of vector graphics.
2. Color palate, Pasteboard & Print Page.
3. Using ruler, unit’s etc.
4. Corel Tools (Pick, Shape, Knife, Eraser, Zoom, Freehand, Natural Pen, Dimensions, Ellipse, Polygon etc.).
5. Transformations, Trimming, Wielding, Intersection of Objects, Snapping, Using Object Manager.
6. Giving effects, (Envelope, Adding Perspective, Contours, Blending Images).

REFERENCES :
1. PC Software by R.K.Taxali
2. PC Software by Rachpal Singh & Gurinder Singh

PAPER IV
INTRODUCTION TO SCRIPTING LANGUAGES, WEB DESIGNING

Time : 3 Hours

Max. Marks : 100

Theory: 50

Practical: 50

Instructions for the Paper Setter :-

1. Each paper will be divided into five units. Examiners will set two questions from each unit with internal choice.

2. The students will be asked to attempt five questions selecting one question from each unit. Each question will carry 10 marks.

Unit I
Introduction to Internet, Web Browser, Protocols- TCP/IP, FTP, POP3, SMTP
- Hardware/Software Requirements
- Client/Server Model
- URL
- E-Mail

Unit II
Introduction to HTML and DHTML

Unit III
Front page 2000 : Introduction to Front page 2000 : FrontPage windows, various toolbar of FrontPage. Creating a web page using wizard, creating a web page using templates and toolbars.

Unit IV
Themes : Creating your own theme, selecting a color scheme, selecting graphics, selecting text, Normal page, confirmation page, Feedback from, guest book, one column body, Search page, Two-column body, Three-column body.
Forms : Creating form using wizard, adding text boxes, adding radio buttons, adding check box, adding drop-down menus, adding pushbutton & pictures.

Unit V
Web Page Designing : Adding shared borders to the page, Giving title to a page selecting a background for page, adding text to page, Hyperlink, turning text to heading, adding picture to the page, adding a clipart, adding navigation bars, Publishing your web page, making your web page searchable.

References :
1. Learning Front Page 2000, Ramesh Bangra, Khanna Book Publishing Co. Pvt. Ltd.
2. Learning to use Internet by Earnest Ackerman.

PAPER V
DATABASE MANAGEMENT SYSTEM, SYSTEM ANALYSIS & DESIGN

Time : 3 Hours

Max. Marks : 100

Theory: 50

Practical: 50

Instructions for the Paper Setter :-

1. Each paper will be divided into five units. Examiners will set two questions from each unit with internal choice.

2. The students will be asked to attempt five questions selecting one question from each unit. Each question will carry 10 marks.

Unit I
Basic concepts : An overview of database Management, (database, database system, why database, data independence). An architecture for a database system (levels of the architecture, mapping, DBA), Introduction to Relational database systems.

Unit II
Relational Model : Domain and relations, Relational data integrity, relational algebra, relational calculus and SQL languages, Normalization concept – 1NF, 2NF,3NF,4NF, Boyce-Codd Normal Forms.

Unit III
System Analysis and Design : System development life cycle, System Development Tools.

Unit IV
ORACLE 8 : SQL *PLUS
Introduction to Oracle 8, SQL-DDL, DML,DCL
Join methods & Sub query, Union, Intersection, Minus, Tree Walking, Built in functions, views, Security amongst users, Sequences, Indexing Object Oriented, Features of Oracle 8.0

Unit V
PL/SQL : Introduction of PL/SQL, Cursors-Implicit & Explicit, Procedures, Functions & Packages, Database Triggers

References :
1. Database Systems Concepts- by Silberschatz, Korth & Sudarshan
2. (International Editions, Computer Science series- 1997)
3. An Introduction of Database systems by C. J. Date (Addison- Wesley Publishing Co.)
4. SQL/PL/SQL The Programming Language of Oracle by IVAN BAYROSS

PAPER VI
PROGRAMMING IN C

Time : 3 Hours

Max. Marks : 100

Theory: 50

Practical: 50

Instructions for the Paper Setter :-

1. Each paper will be divided into five units. Examiners will set two questions from each unit with internal choice.

2. The students will be asked to attempt five questions selecting one question from each unit. Each question will carry 10 marks.

Unit I
Fundamentals of C : Introduction of C, Data Types, Operators, their precedence, expressions and their evaluation.
Input/Output Functions : Formatted I/O, Character I/O & String I/O Functions.

Unit II
Control Structures : Taking decisions using if, if-else, switch constructs and Conditional Operator, Description of break and continue statements. Performing loops using for, while, do-while Constructs.

Unit III
Functions : Library Functions vs User-Defined Functions, Declaring (Prototyping) and defining User-Defined functions, ways of passing parameters to functions, Recursive functions, storage classes.
Arrays & String : What are Arrays ?, Declaring arrays, initializing arrays, processing of arrays, passing arrays as arguments to functions. What are Strings ? How strings are handled in C ? String functions, arrays of strings.

Unit IV
Pointers : What is a pointer variable ? Declaring pointers, accessing values via pointers, pointer arithmetic, pointer to strings, passing arguments using pointers.Structure and Unions : Defining a structure type, declaring variables of structure type, initializing structures. Accessing Structure Elements, Use of assignment Statement for structures, array of structures, nested structures, Unions ; Declaring a Union, Accessing elements of a type union.

Unit V
Managing Data Files : Processing a file, Standard Input/Output, System Level
I/O, File Updating

REFERENCES :
1. Yashwant Kanetkar : Let us C, BPB Publications, New Delhi.
2. R.S.Salaria : Application Programming in C, Khanna Book Publishing Co.
(P) Ltd., Delhi.

PAPER VII
PROJECT REPORT

Project report of 100 marks assigned by the subject teacher will be prepared by a group of students (not exceeding five) under the supervision & guidance of concerned teacher. The contents/theme of the project report will be based on paper II (Computer-Aided- Teaching) or any other area related to the Viva-voce of Project report will be conducted by an external examiner to be appointed by the university.

   
 
 


Developed By : Balaji Tech