Filetype PDF | Posted on 02 Feb 2023 | 2 years ago
Authentication
digital resources
224x Filetype PDF File size 0.17 MB Source: www.spuvvn.edu
SARDAR PATEL UNIVERSITY
Vallabh Vidyanagar, Gujarat
(Reaccredited with ‘A’ Grade by NAAC (CGPA 3.25)
Syllabus with effect from the Academic Year 2021-2022
PGDCA (Post Graduate Diploma in Computer Applications)
PGDCA Semester-I
Course Code PS01CDCA51 Title of the PC Software
Course
Total Credits 4 Hours per 4
of the Course Week
Course 1. To introduce students to
Objectives: • computer fundamentals
• features of word processing, presentation tool and spreadsheets.
Course Content
Unit Description Weightage*
(%)
1. Computer Fundamentals & Word processing 25
- Definition, Functions, Block diagram, components of computer,
input and output devices, types of computers and characteristics.
- Introduction to Word Processing software, benefits of Word
Processing software, examples of word processors
- Working with documents – basic operations, formatting text &
paragraphs
- Using tables, shapes, inserting pictures
- Mail merge facility
2. Presentation tool 25
- Presentation tool – Introduction and basic features
- Working with presentation slide – creating, editing, formatting and
previewing
- Inserting picture, clip art, shapes and chart
- Adding header, footer, animations and slide transitions
- Printing slide content
3. Spreadsheet – I 25
- Introduction to Spreadsheet and Spreadsheet packages
- Building Spreadsheets using formulas, conditional calculations
- Built in functions
- Database Utilities : sorting, filtering, extracting
- Creating charts
4. Spreadsheet – II 25
- Working with External data
- Data analysis using What if analysis, Goal seek and scenario
Page 1 of 2
SARDAR PATEL UNIVERSITY
Vallabh Vidyanagar, Gujarat
(Reaccredited with ‘A’ Grade by NAAC (CGPA 3.25)
Syllabus with effect from the Academic Year 2021-2022
- Pivot table and Pivot chart
- Macro facility
Teaching- Blended learning approach incorporating traditional classroom teaching
Learning and online /ICT-based teaching practices.
Methodology
Evaluation Pattern
Sr. Details of the Evaluation Weightage
No.
1. Internal Written / Practical Examination (As per CBCS R.6.8.3) 15%
2. Internal Continuous Assessment in the form of Practical, Viva-voce, 15%
Quizzes, Seminars, Assignments, Attendance (As per CBCS R.6.8.3)
3. University Examination 70%
Course Outcomes: Having completed this course, the learner will be able to
1. To understand computer fundaments
2. To understand features of word processing, presentation tool and spreadsheets.
Suggested References:
Sr. References
No.
1. Manuals of PC software.
2. Taxali R K : PC Software made simple for Windows, Tata McGraw-Hill Publishing
Co. Ltd., 2000.
*****
Page 2 of 2
SARDAR PATEL UNIVERSITY
Vallabh Vidyanagar, Gujarat
(Reaccredited with ‘A’ Grade by NAAC (CGPA 3.25)
Syllabus with effect from the Academic Year 2021-2022
PGDCA (Post Graduate Diploma in Computer Applications)
PGDCA Semester-I
Course Code PS01CDCA52 Title of the Python Programming
Course
Total Credits 4 Hours per 4
of the Course Week
Course 1. To learn the basics of Python programming language, expressions,
Objectives: control structures
2. To learn the concepts of functions and methods, lists, dictionaries and
strings.
Course Content
Unit Description Weightage*
(%)
1. Introduction to Computer Programming 25
− Introduction to computers and computer programming
− Problem analysis, flow charts, algorithms
− Introduction to the Python programming language and
development environment
− Variables, literals, data types, Assignment, Input and output,
comments
2. Expressions and Control Structures 25
− Operators, evaluation of expressions
− The range type
− The if statement, The while loop, The for loop
− The break and continue statements
3. Functions and Methods 25
− Concept of functions and methods
− Built-in functions
− Operations on strings
4. Lists and Dictionaries 25
− Introduction to lists
− Operations on lists
− Introduction to dictionaries
− Operations on dictionaries
− Operations on strings
Page 1 of 2
SARDAR PATEL UNIVERSITY
Vallabh Vidyanagar, Gujarat
(Reaccredited with ‘A’ Grade by NAAC (CGPA 3.25)
Syllabus with effect from the Academic Year 2021-2022
Teaching- Blended learning approach incorporating traditional classroom teaching
Learning and online /ICT-based teaching practices.
Methodology
Evaluation Pattern
Sr. Details of the Evaluation Weightage
No.
1. Internal Written / Practical Examination (As per CBCS R.6.8.3) 15%
2. Internal Continuous Assessment in the form of Practical, Viva-voce, 15%
Quizzes, Seminars, Assignments, Attendance (As per CBCS R.6.8.3)
3. University Examination 70%
Course Outcomes: Having completed this course, the learner will be able to
1. Understand basics of Python computer programming language.
2. Understand expressions and control structures.
3. Understand functions and methods.
4. Understand lists, dictionaries and strings.
Suggested References:
Sr. References
No.
1. Downey Allen: Think Python, O’Reilly, 2012.
2. Lutz Mark: Learning Python, 4th Edition, O’Reilly, 2009.
3. Hetland Magnus: Beginning Python – From Novice to Professional, Apress, 2005.
4. Lutz Mark: Python – Pocket Reference, 4th Edition, O’Reilly, 2009.
5. Python documentation.
*****
Page 2 of 2
no reviews yet
Please Login to review.
