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

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
• 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, T ypes of Views
• Review Slide Show
• Delivering the Presentation
• Distributing the Presentation

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
• W ordArt
• Smart Art graphic
• Screenshot
• Create Table
• Sort Data i n Table
• Filter Data i n 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