Course Syllabus
Module 1: Office Management
WORD (Documentation)
- Page Setup, Text formatting, Data Proofing, Line & Paragraph setting
- Header & footers, Mail Merge, Macro
- Table (Applying Math formulas in table)
- PROJECTS (Resume, Official Application, Letter, etc.)
ADVANCE EXCEL (Spreadsheet)
- Referencing, Functions & formulas, Data Import & Export
- Sorting and Filtering, Macros
- Data Validation, Pivot Table, H Lookup– V Lookup
- Creating MIS Reports, Database Projects
POWERPOINT (Presentation & Projects)
- Slide Layout, Slide Transition, Slide Show, Animation
- Sound and Video Effects, etc. (PROJECT)
Internet
- Email, Bill Payment (mobile, Electricity, Jal Board, etc.)
- Ticket Booking, Railway Reservation, Digital Locker, Job Portals (naukri.com, etc.)
Module 2: Desk Top Publishing (DTP)
Corel DRAW
- Color Properties, Tool Box, Text Effect, Glowing Effects
- Bitmap, Texture, Logo, 3D logo design
- Pamphlet designing, banner design, Invitation cards, book covers
PHOTOSHOP
- Layers, Channel, Tools, Color Adjustment, Background Effects
- Digital Object Painting, Portfolio
- Layer Mask, Vector Mask, Clipping Mask, Quick Mask
- Book Cover, Flyer, Background Designing By Brush
INDESIGN
- Tools, Image Adjustment, Colors Setting, Text Wrapping, FX effects, Master Pages
- Hidden Character Spaces, Character and Paragraph style, Links, Liquid Layout
Module 3: Web Designing
HTML & HTML (5.0)
- HTML Tags, Attributes, Headings, List, Image
- HTML Tags, Attributes, Headings, List, Image
- HTML Hyperlink, frames, Form, Table
- HTML5 Semantic Attributes, Audio Tag, Video tag
- HTML 5 New Form Elements, Canvas
- HTML5 SVG element, Drag and Drop API
- Geolocation, HTML5 Compatibility
CASCADING STYLE SHEET (CSS 3 & 5)
- Backgrounds, Box Model, Dimension, Pseudo-class, Pseudo-element, Navigation Bar
- Image Gallery, Image Opacity, Rounded Corners, Gradients, Shadows
- 2D & 3D Transforms, Animations, Image Slideshow, Image Hover Overlay
- Animation Button, Vertical tabs, Overlay effect
# NOTE : ONE MODULE FROM 4.1/4.2/4.3 CAN BE CHOSEN
Module 4.1: COMPUTER ACCOUNTING
TALLY (ERP) with G.S.T.
- Ledger Posting, Bill wise details, Cost center, Allow Invoice
- TDS(Tax deducted at source), TCS(Tax collecting at sources)
- GST (IGST, CGST, SGST)
- Debit note and Credit note
- Zero value entry, Multiple Godowns, Integrate account and inventory
- Allow multi-currency
- Maintain stock categories
- Use different actual and billed quantity
- Profit and Loss Statement, Balance Sheet
Busy (with G.S.T.)
- Excise implementation, Pay Roll implementation
- Advance POS (point of sales) data entry, Credit limit, Cost centres
- Purchase and Sales challan, MIS report, Data configuration, etc
- GST (IGST, CGST, SGST), CST calculation and payment, Service tax
- Excise implementation, Pay Roll implementation
- Credit limit, Cost centre, Budget, Multi currency
- Purchases & Sales Challan and Delivery goods & receipts note
Module 4.2: WEB DEVELOPMENT THROUGH PHP & MySQL
PHP (WITH MySQL)
- Web Hosting and Domain Name concepts
- Programming Concepts in PHP (Loops, Function, Array, String, File Handling, etc.)
- PHP Forms (Retrieving Form Data, Get & Post Method)
- Regular Expressions (User Input Validation, Metacharacters, Verifying E-mail Address)
- Database Connection with MYSQL
- Admin Panel in PHP
- Block/Unblock/View Users, Design Client and Admin side, Pagination etc.
- Developing an e-Commerce Website (ONLINE SHOPPING WEBSITE)
- Payment Gateway Integration(Shopping Cart)
- Integration of Online Chat Support application, SMS API
- Java Script & CSS with PHP, Cpanel, FTP, AJAX, Admin Panel,
- PHP OOPS, PHP PDO, Website Security
Module 4.3: HARDWARE & NETWORKING CONCEPTS
PC Architecture, Formatting Hard Disk, Hard Disk Partition,
Operating System Installation ( Win-7 , XP, Linux)
- By Using Pen Drive, CD, DVD
- Network Setting / Desktop Setting / Control Panel
- Managing Users & Groups
C-MOS (BIOS) Set Up
- Set Date / Time, Reset BIOS, BIOS Options (Manage Boot Sequence)
- Jumper Setting (Detecting Hard Disk / CD Drive)
Driver Installation
- Mother Board (LAN, Graphic, Sound Drivers), Printer, Scanner Drivers
Application Software Installation
- MS-Office / Open Office/ Tally/Busy etc., .Net/ Java/SQL/PHP, etc.
- Multimedia Software (2D & 3D) etc. WEB Browser Installation
Assembling of Computer, Trouble Shooting (Fault finding)
Networking Concepts
- Network Devices, Cable & Connectors, IP Addressing
- Setup Local Area Network, Sharing (Printers, Files, Folder, etc.)
- Trouble Shooting and Network Problems