Duration 2 hours ———————————————————————————–Maximum Marks: 100
(I) Word 2013———————————————————25 Marks
(A) Basic and Mid-level
Creating and managing documents, Formatting a document, Customizing Options and Views for Documents, Configuring Documents to Print or Save, Formatting Text, Paragraphs, and Sections, Creating Tables and Lists, Creating and Modifying a List, Applying References ,Inserting and Formatting Objects,
(B) Advanced Topics
Managing and Sharing Documents: Managing Multiple Documents, Preparing Documents for Review, Managing Document Changes and Designing Advanced Documents: Applying Advanced formatting, Applying Advanced Styles, Creating Advanced References: Create and Manage Indexes, Creating and Managing Reference Tables and Manage forms, Fields, and Mail Merge Operations.
II EXCEL 2013 35 Marks
(A) Basic and Mid-Level
Creating and Managing Worksheets and Workbooks: Creating Worksheets and Workbooks, Navigating Through Worksheets and Workbooks, Formatting Worksheets and Workbooks, Customizing Options and Views For Worksheets and Workbooks and Configuring Worksheets and Workbooks to Print Or Save. Cells and Ranges: Inserting Data in Cells and Ranges, Formatting Cells and Ranges and Ordering and Grouping Cells and Ranges. Tables: Creating and Modifying Table. Formulas and Functions: Applying Cell Ranges and References in Formulas and Functions. Charts and Objects: Creating and Formatting A Chart and Inserting and Formatting an Object
(B) Advanced Topics
Managing and Sharing Workbooks: Managing Multiple Workbooks, Preparing A Workbook For Review and Managing Workbook Changes. Applying Custom Formats and ‘Layouts: Applying Custom Data Formats, Applying Advanced Conditional Formatting and Filtering, Applying Custom Styles and Templates. Creating Advanced Formulas: Applying Functions in Formulas: Look Up Data With Functions, Applying Advanced Date and Time Functions and Creating Scenarios. Creating Advanced Charts and Tables: Creating Advanced Chart Elements, Creating and Managing Pivot Tables and Creating and Managing Pivot Charts.
III Access 2013 Basic (Awareness) 25 Marks
Creating and Managing a Database: Creating a New Database, Managing Relationships and Keys, Navigating Through a Database, Protecting and Maintaining a Database and Printing and Exporting a Database. Building Tables: Creating a Table, Formatting a Table, Managing Records and Creating and Modifying Fields. Creating and Modifying Queries: Creating a Query, Modifying a Query, and Utilizing Calculated Fields and Grouping within a Query. Creating Forms: Creating a Form, Setting Form Controls and Formatting a Form. Creating Reports: Creating a Report, Setting Report Controls and Formatting a Report.
IV Power Point 2013 15 Marks
Create and Manage Presentations: Creating A Presentation, Formatting A Presentation Using Slide Masters, Customizing Presentation Options and Views, Configuring Presentations to Print or Save and Configuring and Present Slideshows. Inserting and Formatting Shapes and Slides: Inserting and Formatting Slides, Inserting and Formatting Shapes and Ordering and Grouping Shapes and Slides. Creating Slide Content: Inserting and Formatting Text, Inserting and Formatting Tables, Inserting and Formatting Charts, Inserting and Formatting Smart Art, Inserting and Formatting Images and Inserting and Formatting Media. Applying Transitions and Animations: Applying Transitioning Between Slides, Animating Slide Contents and Setting Time for Transitions and Animations. Managing Multiple Presentations: Merging Content from Multiple Presentations, Tracking Changes and Resolving Differences and Protecting and Sharing Presentations.