Syllabus
|
Course Code: BCA-202 Course Name: OFFICE AUTOMATION- II |
||
| MODULE NO / UNIT | COURSE SYLLABUS CONTENTS OF MODULE | NOTES |
|---|---|---|
| 1 | PowerPoint Basics: Ribbon Menus, Creating a New Presentation, Designing a Slide, Adding Text and Images, Slide Master, Adding Notes, Applying Design Template,Inserting and Formatting Tables, Data Labels, Chart Legends, Chart Styles, Chart Color Scheme, Adding Objects, Smart Art, Adding Special Effect, Printing Options, PowerPoint Views, Saving PowerPoint Files in Different Formats. | |
| 2 | MS-PowerPoint Advance: Design Template, Adding Transitions, Animation, Motion Paths, Effects and Timing, Animation Pane, Adding and Timing Videos, Adding Sounds, Screen Recording, Photo Albums, Preparing Audience Handouts, Import and Export to and From Non PowerPoint Files, Using Office Mix, Online Collaboration. | |
| 3 | Access Basics: Fundamental Concepts and terminology of Database System, Creating a Database, Determining Tables and Fields, Creating a Table, Importing or Linking Data from other Applications to Access, To Change Database Properties, Determining Keys, and Determining Relationship between Tables. Assigning Data Types to Fields, Identifying and Removing Redundancy. | |
| 4 | Access Advance Features: Creating a Database Query, Use a Wildcard, Comparison Operator, Sorting Data in a Query, Joining Tables, Crosstab Queries, Designing Form for a Query, Updating Records, Filtering Records, And Exporting Data. | |
