CERTIFYING BODY

  • W3Schools

CAREER PROSPECTS

Web designers/developers who aspire for a comprehensive knowledge of Web development practices and conceptsto perform hands-on coding and understand architecture of web applications can undergo this course.

  • MS-office

SYLLABUS

    • Find & Replace
    • Look up words in the thesaurus
    • Look up words in the dictionary
    • Make text superscript or subscript
    • Adding Pictures/WordArt
    • Paragraph/Character Styles
    • Bullets & Numbering
    • Borders & Shading
    • Footnotes and Endnotes
    • Headers and Footers
    • Page numbers, Date & Time
    • Text Box, Screen shot
    • Pictures & ClipArt
    • WordArt, SmartArt graphics
    • Create an organization chart
    • Rotate text in a SmartArt graphic
    • Add alternative text to any shape
    • Add or delete a table
    • Mail merge – Letters, Labels
    • Compare documents
    • Macros – Recording, Execution
    • Tables – Drawing, Formatting
    • Review tracked changes & comments
    • Hyperlink, OLE
    • Preview & Print Documents
    • List of recently used files
    • Keyboard Shortcuts
    MS POWERPOINT
    • Introduction to Powerpoint
    • Design Slides, Create Presentation
    • Working with Text, Tables, Shapes
    • Working with Charts, Pictures
    • Custom Animation, Custom Transition
    • Organizing & Formatting Slides
    • Rehearse timings
    • Adding Graphics, Media Clips
    (eg. video, audio)
    • Using Slide Master, Types of Views
    • Review Slide Show
    • Delivering the Presentation
    • Distributing the Presentation

    INTRODUCTION TO COMPUTERS
    • Computer Definition
    • Data, Characters, Information
    • ANSI, ASCII
    • Advantages, Disadvantages
    • Computer Architecture
    • Memory, Types of memories
    • Storage devices, Hardware
    • Software, Classification
    WINDOWS
    • GUI Environment
    • Keyboard shortcut keys
    • Desktop features- Window, Icon
    • Folder, Taskbar, Start Menu
    • Calculator, MS Paint
    • Notepad, Wordpad, Clipboard
    • Date/Time properties
    • Display properties, Screen Saver
    • Mouse, RecycleBin
    MS OFFICE
    MS WORD
    • Introduction to Word
    • File – Open, Save, Close
    • Backstage view, Ribbon
    • Quick Access toolbar
    • Create a document
    • Page Setup, Page Layout
    • Print Setup, Page break
    • Count no. of words in a document
    • Formatting text, paragraphs
    • Add a heading, Clear formatting
    • Add or remove text effects
    • Line spacing, Paragraph spacing
    • Set the default font
    • Apply themes to documents
    • Read documents in Word
    • Show or hide formatting marks
    • Proofreading a document
    • Check spelling and grammar

    MS ACCESS
    • Introduction to MS Access
    • Database, DBMS, RDBMS
    • Create Database
    • Manage Database
    • Create Tables
    – Design View
    – Table Wizard
    – Datasheet View
    • Add Records to Table
    • Update data using queries
    • Create Queries
    • Types of Queries
    – Select, Crosstab, Maketable
    – Append, Update, Delete
    • Create Forms with UI controls
    • Form Wizard
    • Fine-tune Form
    • Sort Data
    • Filter Data
    • Generate Reports
    • Report Wizard
    • Custom Reports
    INTERNET
    • World Wide Web, Web Server
    • Webpage, Website
    • Send E-mail
    • Add attachments
    • Browsing (information searching)
    • Sending SMS
    • Using Job portals
    • Online Ticket booking
    • Online Shopping
    • Downloading files
    PC UTILITIES
    • CD writing
    • Virus detection & removal
    • Printing documents
    • Managing Audio
    • Backup data
    MS EXCEL
    • Introduction to Excel
    • Introduction to Worksheets
    • Introduction to Workbooks
    • Cell, Column, Row, Range
    • Entering / Editing data
    • Copying / Moving data
    • Reposition the data in cell
    • Wrap text in a cell, Merge cells
    • Move or copy cells / cell contents
    • Copy specific cell contents
    • Cell borders, Cell shading
    • Text color, Text Formatting
    • Gridlines, Sheet Background
    • Selecting the cells
    • Navigation in the worksheet
    • Organizing the sheets
    • Entering & Formatting Titles
    • Worksheet calculations
    • Formatting Rows/Columns
    • Hiding Columns/Rows/Sheets
    • Lock Cell
    • Cell Alignment, Font styles
    • Cell Formatting, Cell Styles
    • Cell Referencing
    • Row Height, Column Width
    • Find, Replace, Goto
    • Conditional Formatting
    • Format as Table
    • Number Series, Fill Handle
    • Adding Formulas
    • Formula bar, Status bar
    • Math Functions
    • Text Functions
    • Date& Time Functions
    • Logical functions
    • IF function
    • Add Pictures/Shapes
    • WordArt
    • Smart Art graphic
    • Screenshot
    • Create Table
    • Sort Data in Table
    • Filter Data in Table

    • Page Layout
    • Themes, Colors, Effects
    • Margins, Size, Orientation
    • Page breaks, Page scaling
    • Page background
    • Print setup
    • Print area, Print titles
    • Gridlines, Headings
    • Creating Graphs/Charts
    • Types of Charts
    • Insert Text Box
    • Header & Footer
    • Insert Object
    • Insert Symbol
    • Data Sort
    • Data Filter
    • Data Validation
    • Macros – Record, Execute
    • Add Header & Footer
    • Workbook Views – types
    • Freeze /Unfreeze panes
    • Create Payrolls/Tables
    • Keyboard shortcuts
    ADVANCED EXCEL
    • Add Smart Art objects
    • Align objects, Themes
    • Objects – Align / Group / Arrange
    • Absolute Cell Referencing
    • Calculation options
    • Insert Page breaks
    • Paste Links, Paste Special
    • Working with Comments
    • Lookup & Reference functions
    • VLookup, HLookup
    – Sheet to Sheet
    – Sheet to Workbook
    – Workbook to Workbook
    • SumIF, CountIF, CountBlank
    • Index, Match, Transpose
    • Find, Search
    • Replace, Substitute
    • Naming Range
    • Name box, Name Manager

    • Enhancing Chart Titles
    • Changing colors of Data bars
    • Rotating Charts
    • Sparklines • Slicer
    • Signature Line
    • Filter data
    – Text, Number, Date, Color
    • Advanced filter
    • Custom List
    • Custom Sort
    • Get External Data
    – from Access, Notepad
    • Text to Columns
    • Remove Duplicates
    • Data Consolidation
    • Pivot table
    – Sort data, Filter data
    – Refresh Pivot table data
    • Pivot chart
    • Data Subtotal
    • What-if Analysis
    • Scenarios, Scenario Manager
    • Goal Seek,
    • Data Table
    • Formula Auditing
    • Protect Workbook/Sheet
    • Share Workbook
    • Save Workspace
    • Export Excel tables to Word
    • Excel Options
    • Reporting using Excel
    – Financial statements
    – Sales / Purchase Report
    – Product Report
    – Summary Report
    – Business Reports
    – Academic Reports
    OTHER USES OF EXCEL
    – Calendar
    – Gantt Chart
    – Meeting Agenda
    – Invoices