Scribd
Upload
23 views1 page

SEC_2 (1) (1)

The syllabus for the Microsoft Excel & PowerPoint course at Central Sanskrit University aims to equip students with skills for data analysis and presentation using Excel, and to enhance their PowerPoint capabilities. Students will learn to manage workbooks, create advanced formulas, and develop interactive presentations. Assessment includes practical skill evaluation (60 marks) and internal assessment (40 marks).

Uploaded by

anandkumaramitanandarya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
23 views1 page

SEC_2 (1) (1)

The syllabus for the Microsoft Excel & PowerPoint course at Central Sanskrit University aims to equip students with skills for data analysis and presentation using Excel, and to enhance their PowerPoint capabilities. Students will learn to manage workbooks, create advanced formulas, and develop interactive presentations. Assessment includes practical skill evaluation (60 marks) and internal assessment (40 marks).

Uploaded by

anandkumaramitanandarya
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
You are on page 1/ 1

Central Sanskrit University

Syllabus as per NEP 2020.


Shastri- I Year II Semester

SEC 2
Course Name: MICROSOFT EXCEL & POWERPOINT
Objective: The objectives of this syllabus are to equip students with the skills to efficiently utilize
Microsoft Excel for data analysis, manipulation, and presentation. Additionally, it aims to foster an
understanding of advanced Excel functionalities to enhance productivity and decision-making
capabilities. This course helps students get better at making PowerPoint slides by learning advanced
features like animation and multimedia integration.
Learning Outcomes: students will demonstrate proficiency in utilizing Microsoft Excel for tasks such
as data analysis, visualization, and reporting. They will be able to employ advanced Excel features
effectively to solve complex problems and make informed decisions.
Practical Skill Assessment :60Marks
Internal Assessment :40 Marks

Unit Topic Hours Credits


(4)
01 Manage Workbook & Apply Custom Data Formats and Layouts-Create 15 01
Worksheets and Workbooks, Format Worksheets and Workbooks, credit
Customize Options and Views for Worksheets and Workbooks, Apply
Custom Data Formats and Validation, Apply Advanced Conditional
Formatting and Filtering.
02 Create Tables & Perform Operations with Formulas and functions- 15 01
Create and Manage Tables, Manage Table Styles and Options, Filter and credit
Sort a Table, Summarize Data by using Functions, Perform Conditional
Operations by using Functions, Format and Modify Text by using
Functions
Create Charts and Objects-Create Charts, Format Charts, Insert and
Format Objects, insert text boxes and shapes, insert images, modify object
properties, and add alternative text to objects for accessibility
03 Create Advanced Formulas-Apply Function in Formula: Perform logical 15 01
operations by using AND, OR, and NOT functions perform logical credit
operations by using nested functions, and perform statistical operations by
using SUM-IFS, AVERAGEIFS, and COUNTIFS functions. Lookup data
by using Functions: Lookup data by using the VLOOKUP function, look up
data by using the HLOOKUP function
04 Creating Interactive Presentations: Exploring advanced features of 15 01
PowerPoint for creating engaging presentations on Sanskrit topics. credit
Techniques for integrating multimedia elements, animations, and interactive
quizzes into Sanskrit PPTs. Design principles for effective e-content
development in Sanskrit, including visual design, content organization, and
accessibility considerations
Reference Books-
1. 2007MicrosoftOfficeSystemPlain&SimplebyJerryJoyce, Microsoft Press.
2. Excel 2019 All-in-one: Master the new features of Excel 2019/Office 365, Lokesh
Lalwani, BPB Publications.

You might also like