Syllabus - Modified Scheme of Study

Practical Module-1


PM2 - Management Reporting – IT Office Tools

PART - A WEIGHTAGE 60%
MS Excel
• Getting Started with Microsoft Office Excel
• Navigate the Excel User Interface
• Use Excel Commands
• Create and Save a Basic Workbook
• Enter Cell Data
• Performing Calculations
• Create Worksheet Formulas
• Insert Functions
• Reuse Formulas and Functions
• Modifying a Worksheet
• Insert, Delete, and Adjust Cells, Columns, and Rows
• Search for and Replace Data
• Use Proofing and Research Tools
• Formatting a Worksheet
• Apply Text Formats
• Apply Number Formats
• Align Cell Contents
• Apply Styles and Themes
• Apply Basic Conditional Formatting
• Create and Use Templates
• Printing Workbooks
• Preview and Print a Workbook
• Set Up the Page Layout
• Configure Headers and Footers
• Managing Workbooks
• Manage Worksheets
• Manage Workbook and Worksheet Views
• Manage Workbook Properties
• Working with Functions
• Work with Ranges
• Use Specialized Functions
• Work with Logical Functions
• Work with Date & Time Functions
• Work with Text Functions
• Working with Lists
• Sort Data
• Filter Data
• Query Data with Database Functions
• Outline and Subtotal Data
• Analyzing Data
• Create and Modify Tables
• Apply Intermediate Conditional Formatting
• Apply Advanced Conditional Formatting
• Visualizing Data with Charts
• Create Charts
• Modify and Format Charts
• Use Advanced Chart Features
• Using PivotTables and Pivot Charts
• Create a PivotTable
• Analyze PivotTable Data
• Present Data with Pivot Charts
• Filter Data by Using Timelines and Slicers
• Working with Multiple Worksheets and Workbooks
• Use Links and External References
• Use 3-D References
• Consolidate Data
• Using Lookup Functions and Formula Auditing
• Use Lookup Functions
• The VLOOKUP Function
• Trace Cells
• Watch and Evaluate Formulas
• Sharing and Protecting Workbooks
• Collaborate on a Workbook
• Protect Worksheets and Workbooks
• Automating Workbook Functionality
• Apply Data Validation
• Search for Invalid Data and Formulas with Errors
• Work with Macros
• Creating Spark lines and Mapping Data
• Forecasting Data
• Determine Potential Outcomes Using Data Tables
• Determine Potential Outcomes Using Scenarios
• Use the Goal Seek Feature
PART - B WEIGHTAGE 20%
Microsoft Word
• Getting Started with Word
• Navigate in Microsoft Word
• Create and Save Word Documents
• Manage Your Workspace
• Edit Documents
• Preview and Print Documents
• Customize the Word Environment
• Formatting Text and Paragraphs
• Apply Character Formatting
• Control Paragraph Layout
• Align Text Using Tabs
• Display Text in Bulleted or Numbered Lists
• Apply Borders and Shading
• Working More Efficiently
• Make Repetitive Edits
• Apply Repetitive Formatting
• Use Styles to Streamline Repetitive Formatting Tasks
• Managing Lists
• Sort a List
• Format a List
• Adding Tables
• Insert a Table
• Modify a Table
• Format a Table
• Convert Text to a Table
• Inserting Graphic Objects
• Insert Symbols and Special Characters
• Add Images to a Document
• Controlling Page Appearance
• Apply a Page Border and Color
• Add Headers and Footers
• Control Page Layout
• Add a Watermark
• Preparing to Publish a Document
• Check Spelling, Grammar, and Readability
• Use Research Tools
• Check Accessibility
• Save a Document to Other Formats
• Organizing Content Using Tables and Charts
• Sort Table Data
• Control Cell Layout
• Perform Calculations in a Table
• Create a Chart
• Add an Excel Table to a Word Document (Optional)
• Customizing Formats Using Styles and Themes
• Create and Modify Text Styles
• Create Custom List or Table Styles
• Apply Document Themes
• Inserting Content Using Quick Parts
• Insert Building Blocks
• Create and Modify Building Blocks
• Insert Fields Using Quick Parts
• Using Templates to Automate Document Formatting
• Create a Document Using a Template
• Create a Template
• Controlling the Flow of a Document
• Control Paragraph Flow
• Insert Section Breaks
• Insert Columns
• Link Text Boxes to Control Text Flow
• Simplifying and Managing Long Documents
• Insert Blank and Cover Pages
• Insert an Index
• Insert a Table of Contents
• Insert an Ancillary Table
• Manage Outlines
• Create a Master Document
• Using Mail Merge to Create Letters, Envelopes, and Labels
• The Mail Merge Features
• Merge Envelopes and Labels
• Create a Data Source Using Word
• Manipulating Images
• Integrate Pictures and Text
• Adjust Image Appearance
• Insert Other Media Elements
• Using Custom Graphic Elements
• Create Text Boxes and Pull Quotes
• Add WordArt and Other Text Effects
• Draw Shapes
• Create Complex Illustrations with Smart Art
• Collaborating on Documents
• Share a Document
• Review a Document
• Review Tracked Changes
• Merge Changes from Other Documents
• Adding Document References and Links
• Add Captions
• Add Cross-References
• Add Bookmarks
• Add Hyperlinks
• Insert Footnotes and Endnotes
• Add Citations and a Bibliography
• Securing a Document
• Suppress Information
• Add a Digital Signature to a Document
• Set Formatting and Editing Restrictions
• Restrict Document Access
• Using Forms to Manage Content
• Create Forms
• Manipulate Forms
• Automating Repetitive Tasks with Macros
• Automate Tasks Using Macros
• Create a Macro
PART - C WEIGHTAGE 20%
PowerPoint
• Getting Started with PowerPoint
• Navigate the PowerPoint Environment
• Create and Save a PowerPoint Presentation
• Use PowerPoint Help
• Developing a PowerPoint Presentation
• Select a Presentation Type
• View and Navigate a Presentation
• Edit Text
• Build a Presentation
• Performing Advanced Text Editing Operations
• Format Characters
• Format Paragraphs
• Format Text Boxes
• Adding Graphical Elements to Your Presentation
• Insert Images
• Insert Shapes
• Modifying Objects in Your Presentation
• Edit Objects
• Format Objects
• Group Objects
• Arrange Objects
• Animate Objects
• Adding Tables to Your Presentation
• Create a Table
• Format a Table
• Insert a Table from Other Microsoft Office Applications
• Adding Charts to Your Presentation
• Create a Chart
• Format a Chart
• Insert a Chart from Microsoft Excel
• Preparing to Deliver Your Presentation
• Review Your Presentation
• Apply Transitions
• Print Your Presentation
• Deliver Your Presentation
• Modifying the PowerPoint Environment
• Customize the User Interface
• Set PowerPoint Options
• Customizing Design Templates
• Modify Slide Masters and Slide Layouts
• Add Headers and Footers
• Modify the Notes Master and the Handout Master
• Adding Smart Art and Math Equations to a Presentation
• Create Smart Art
• Modify Smart Art
• Write Math Equations
• Working with Media and Animations
• Add Audio to a Presentation
• Add Video to a Presentation
• Customize Animations and Transitions
• Collaborating on a Presentation
• Review a Presentation
• Store and Share Presentations on the Web
• Customizing a Slide Show
• Annotate a Presentation
• Set Up a Slide Show
• Create a Custom Slide Show
• Add Hyperlinks and Action Buttons
• Record a Presentation
• Securing and Distributing a Presentation
• Secure a Presentation
• Broadcast a Slide Show
• Create a Video or a CD
Top