REGULATION 2021
GE3361 PROFESSIONAL DEVELOPMENT LTPC 0 0 2 1
COURSE OBJECTIVES:
To be proficient in important Microsoft Office tools: MS Word, Excel, Powerpoint.
To be proficient in using MS WORD to create quality technical documents, by using
standard templates, widely acceptable styles and formats, variety of features to enhance
the presentability and overall utility value of content.
To be proficient in using MS EXCEL for all data manipulation tasks including the
common statistical, logical, mathematical etc., operations, conversion, analytics, search
and explore, visualize,interlink, and utilizing many more critical features offered
To be able to create and share quality presentations by using the features of MS
PowerPoint, including: organization of content, presentability, aesthetics, using media
elements and enhance the overall quality of presentations.
MS WORD 10 Hours
Create and format a document
Working with tables
Working with Bullets and Lists
Working with styles, shapes, smart art, charts
Inserting objects, charts and importing objects from other office tools
Creating and Using document templates
Inserting equations, symbols and special characters
Working with Table of contents and References, citations
Insert and review comments
Create bookmarks, hyperlinks, endnotes footnote
Viewing document in different modes
Working with document protection and security
Inspect document for accessibility
MS EXCEL 10 Hours
Create worksheets, insert and format data
Work with different types of data: text, currency, date, numeric etc.
Split, validate, consolidate, Convert data
Sort and filter data
Perform calculations and use functions: (Statistical, Logical, Mathematical, date, Time
etc.,)
Work with Lookup and reference formulae
Create and Work with different types of charts
Use pivot tables to summarize and analyse data
Perform data analysis using own formulae and functions
Combine data from multiple worksheets using own formulae and built-in functions to
generate results
Export data and sheets to other file formats
Working with macros
Protecting data and Securing the workbook
MS POWERPOINT 10 Hours
Select slide templates, layout and themes
Formatting slide content and using bullets and numbering
Insert and format images, smart art, tables, charts
Using Slide master, notes and handout master
Working with animation and transitions
Organize and Group slides
Import or create and use media objects: audio, video, animation
Perform slideshow recording and Record narration and create presentable videos
TOTAL: 30 PERIODS
COURSE OUTCOMES:
On successful completion the students will be able to
CO1 Use MS Word to create quality documents, by structuring and organizing content for their
day to day technical and academic requirements.
CO2 Use MS EXCEL to perform data operations and analytics, record, retrieve data as per
requirements and visualize data for ease of understanding.
CO3 Use MS PowerPoint to create high quality academic presentations by including common
tables, charts, graphs, interlinking other elements, and using media objects.
