|
|
|
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, units 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. |
|
|
|