MIC301A Word and PowerPoint & Spreadsheet Application with Excel PDF
Document Details
Uploaded by Deleted User
Maulana Abul Kalam Azad University of Technology
Tags
Summary
This document provides an outline of course material for a course on word processing, spreadsheets, and presentation software, MIC301A, at Maulana Abul Kalam Azad University of Technology, WB, covering specific units and topics for each software program. The topics listed include Word, PowerPoint, and Excel software with detailed explanations of functionalities. This document is not an exam paper and lacks specific details used in official exam papers e.g. questions and answers.
Full Transcript
## MIC301A - Word and PowerPoint & Spreadsheet Application with Excel | Course Code | Course | Credits | |---|---|---| | MIC301A | Word and PowerPoint & Spreadsheet Application with Excel | 4.0 | ### Maulana Abul Kalam Azad University of Technology, WB (Formerly known as West Bengal University of...
## MIC301A - Word and PowerPoint & Spreadsheet Application with Excel | Course Code | Course | Credits | |---|---|---| | MIC301A | Word and PowerPoint & Spreadsheet Application with Excel | 4.0 | ### Maulana Abul Kalam Azad University of Technology, WB (Formerly known as West Bengal University of Technology) | Chapter | Name of the Topic | Hours | |---|---|---| | **Word** | **Unit-I** | 10 | | Introduction on Word, File operations (Opening, Creating, Sorting, Closing), Text editing (Cut/Move, Copy, Undo, Redo), Text formatting (Text color, Text border, Advanced formatting, adjusting space between characters, Positioning the character, Superscript, Subscript, Raised, Lower of text, Change case), Page setup, Print preview. Paragraph alignment, Line spacing, Indent, Drop cap, Border and shading, Bullets and Numbering, Find and Replace and Go to. | | | **Word** | **Unit-II** | 10 | | Spelling and Grammar, Auto text, Auto correct, Word count, Text background, break, columns, Header Footer, Inserting object/picture/symbol/drawing and editing, WordArt, Tab setting. Creating of Table, Selecting, Moving, Typing, Inserting row/columns in a table, Applying Border, Sorting, Table auto format, Merging the cells, Converting table to text and vice versa, Cell coloring, Mail merge, different views, ruler, zooming. | | | **Power Point** | **Unit-III** | 10 | | Introduction to PowerPoint, Overview of presentation software and its applications, Introduction to PowerPoint interface and features, Creating, saving, and opening presentations, Working with slides, text boxes, and placeholders, Formatting text, shapes, and images, Using templates and themes for visual enhancement, Choosing appropriate slide layouts, Customizing slide backgrounds and colors, Adding and formatting images, charts, and graphs, Using animation and transition effects, Master slides and slide numbering, Design principles for effective presentations | | | **Power point** | **Unit-IV** | 10 | | Inserting audio and video files, Editing and trimming multimedia elements, Adding hyperlinks and action buttons, Creating interactive and engaging presentations, Running and navigating slide shows, Setting up slide show options (timings, loops, narrations), Using presenter view and annotations, Rehearsing timings and managing slide transitions, Tips for delivering effective presentations | | | **Excel** | **Unit-V** | 10 | | Introduction of Excel. File operations and Text operations, Concept of Workbook, Worksheet, Cell, Row, Column and Range, Copying and moving the content of a cell, Inserting cell / Row / Column, Deleting cell / Row / Column, Entering formula in a cell. Functions (Mathematical and Statistical Functions, Text Functions, Logical Functions). | | | **Excel** | **Unit-VI** | 10 | | Auto Sum, Cell Formatting, Fill handle, Auto Fill, Graph, Chart, Types of Charts, Auto Shape, Various types of Charts, adding data series. Data form, Auto Filter, Advanced Filter, Sort, Subtotal, Pivot Table, Data Validation, Goal Seek. | | **Total: 60**
