AV Software Technologies

Boost your skills with our expert training

Computer Fundamentals & M S Offfice Course Syllabus

Duration: 60 Days | Total Hours: 50+ | Fee 5000/-

Day Chapter Topics Hours
Module-1 Introduction of Computer
WEEK-IIntroduction of Computer
  • Introduction, Definition, Characteristics of Computer
  • Block diagram of Computer and Components of a computer
  • Functions and Application of computer.
  • its basic terminology – Hardware(H/W), Software(S/W)
  • Classification of Computer, Generation of Computer
  • Input Unit, Processing unit (memory Unit,Control Unit, ALU), Output Unit
  • SMPS,Motherboard (North Bridge, South bridge, Chipset, 20 pin ATX power connector, CMOS,Ports and other connected devices)
  • 7
    Module-2 Number System
    WEEK-IINumber Sysstem
  • Definition, Types of Number System (Decimal, Binary, Octal, Hexadecimal)
  • Number Conversion: Decimal to Binary Conversion
  • Decimal to Octal Conversion, Decimal to Hexadecimal Conversion
  • Binary to Octal Conversion, Binary to Hexadecimal,Hexadecimal to Binary
  • Hexadecimal to Octal, octal to Binary
  • Octal to hexadecimal,negative number conversion
  • 7
    Module-3 File, folder, Notepad and MS-DOS
    WEEK-IIIFile,folder,Notepad and MS-DOS
  • What is file and Folder
  • How to crete ,delete,open,close,remane of file,folder.
  • cut,copy,past ,delete ,update the data in file
  • Definition and History of DOS ,Versions of DOS
  • DOS Prompt and Syntax Rules,
  • File and Directory Management:Concept of Files and Directories
  • Naming Rules,Creating, Renaming, Deleting Files
  • Directory Structure (Root, Subdirectories)
  • Creating, Changing, and Removing Directories
  • File Extensions and Attributes
  • Commands:DIR, CD, MD, RD, COPY, DEL, REN, TYPE, CLS, DATE, TIME
  • 7
    Module-4 MS Office
    WEEK-IVMS Office Word
  • Introduction: Basics of MS-Word, Tools(Status bar, Title bar,
  • Help, Ruler bar, Dialog box launcher, Document area
  • Zoom control, Quick access bar, View Buttons, File Tab, Ribbon)
  • Tabs(Home, Insert, Page Layout, Reference, Mailings, Review, View, Design, Layout)
  • Creating a new word document, Opening an existing document, Editing and saving a document
  • Text Alignment, Formatting Text, Find, Advance find and replace,
  • Formatting page, margins, page size, portrait and landscape
  • 7
    Module-5 MS Word
    WEEK-VSymbols,Pictures and Tables,header, footer
  • Insertion: Inserting a Picture,
  • Inserting a clip art, inserting shapes.
  • Inserting smart art,Inserting charts,
  • Inserting Equation, Inserting Symbol, Use of Bullets.
  • Tables: Basics, Table Creation, table manipulation: Using and manipulating tables.
  • inserting / deleting of rows and columns, sorting tables
  • Working with headers, footers and page numbers
  • Changing character width and line spacing, Print a document
  • Shortcuts: Shortcuts for various activities in MS Word
  • 7
    Module-6 MS-Excel
    WEEK-VI MS-Excel
  • Introduction, definition,Understand the MS-Excel.
  • Creating a new excel workbook, creating an excel worksheet
  • formulas, Data filtering, Data sorting
  • Using ranges, Data validation, Using styles,
  • Add and delete graphics (Picture, Clip Art, Shapes, Smart Art and Word Art)
  • Conditional formatting
  • Format cell (Format Number, Alignment, Font, Border, Fill), Text Decoration.
  • 7
    Module-7 MS-PowerPoint
    WEEK-VIIMS-PowerPoint
  • Introduction: Basics of MS-Word
  • Tools ( File tabs, Home, Insert, Design, Transition,Animation, Slide show, Review, View, Format)
  • Features of Power Point: Presentation views, setting presentation background
  • Cut and Paste Operations, Copy and Paste Operations
  • Edit PowerPoint Presentation, Special Characters,
  • Adding audio and video to a slide,Working with charts on a slide,
  • Convert PowerPoint to PDF, Convert PowerPoint to Video,
  • Create an Image from PowerPoint, Print a PowerPoint, Broadcast PowerPoint presentation
  • 7
    Enroll Now