PROF. DIPLOMA IN ADVANCED INFORMATION TECHNOLOGY
DURATION: 18 MONTHS
- Computer Fundamentals
- Windows & Operating System
- Outlook Express
MS-WORD
- Introduction of Word with its Interface
- Explain Tabs Briefly
- Shortcuts
- Mail Merge
- Page Setups (Page visualization & printing)
- Protections
- Macros
MS-EXCEL
- Introduction of Excel
- Explain Interface
- Shortcuts
- Diff b/w Functions & Formulas
- Cell references
- Operators
- Basic Calculations
- Text Function
- Date & Time Function
- Mathematic Function
- Logical Function
- Conditional formatting
- Charts
- Reports using Pivot Table
- Protections
MS-POWERPOINT
- Introduction of Powerpoint
- Explain Interface
- Shortcuts
- Explain Tabs
- Quiz Making
- Designing & Formatting
- Transitions & Animations
- Album creation
- Animations
- Slide Master
Functional communication assignments & presentation exam of module - 1
COREL DRAW
- Corel Draw Basics and Interface
- Working on Layer
- Working on objects with its properties
- Working on Drawing tools
- Working on Tools with its Shortcut
- Transforming Objects
- Outlining & Filling Objects
- Tracing & some other Effects
- Blending Objects
- Applying Distortions
- Applying Mesh Fills
- Working with Text
- Layer Setup & printing
- Import and Export
PHOTOSHOP
- Explain interface with Layers
- Making Selections with its inverse
- Working with Mask
- Working on Paths
- Create & Modify path
- Remove and change the background
- Working on Tools
- Special Effects
- Layer Setup & printing
- Import and Export
ILLUSTRATOR
- Illustrator Basics with its interface
- Selections
- Working on Layers
- Working on Rulers and Guide
- Working on Stroke & color Filling
- Special Effects
- Working on Drawing Tools
- Working with Mask
- Working on Paths
- Working on Tools
- Working with Text
- Import and Export
HTML
- Introduction of HTML
- Basic Structure of HTML
- Tags & its implementation
- Attributes & Elements
- Formatting
- Lists & Tables
- Form Design & validation
- Calculator
CSS (Cascading Styles)
- Introduction of css
- How to use CSS
- CSS Types
- CSS Selectors
- Margins & Padding in CSS
- Animation using CSS
- 2D & 3D CSS
- Navigations & Dropdowns
- Progress Bar
- Slideshow
- CSS Effects
- CSS Layout
- Pseudo classes & element
- Web Layout Design
DREAMWEAVER
- Defining a local site
- Creating a page in Layout view
- Inserting an image and a rollover image
- Working with tables in Standard view
- Creating a link to another document
- Inserting assets from the Assets panel
- Inserting Flash Text and Flash Button objects
- Creating and applying a template
- Running a site report
- Adding a Design Note
WORDPRESS
- Introduction to build dynamic websites and blogs
- Installation of Word press on web server
- Download and Install Add-ins Tools
- Working on Tools
- Working on Themes
- Create, Update and Manage website Edit, Publish, and Modify the content of the website
JAVASCRIPT
- Basic Programming
- Working on logical part of programming
- Variables & Constants
- Datatypes & Operators
- Control Statement
- Looping
- Switch case
- Functions
- JavaScript Implementation with HTML
- Events Handling
PHP
- PHP Introduction and Basics
- PHP Variables and Data Types
- PHP Operators
- Decision Making Statements
- PHP Loops
- Arrays and its functions
- String and its functions
- PHP Date time variables and functions
- PHP Functions
- Including files
- Establishing Connection and Error
- Handling
- Cookies and Session
MYSQL
- SQL Introduction
- SQL DML Commands
- SQL DDL Commands
- SQL Clauses
- SQL Logical Operations
- SQL Aggregate Functions
- SQL Wildcards
- SQL Aliases
- SQL Joins
- SQL Case
- SQL Stored procedures
- SQL Comments
ASSIGNMENTS INTERVIEW TECHNIQUES PROJECT WITH PRESENTATION FINAL EXAM
INDESIGN
- Modern Magazines Design
- Business Magazines
- Book Design, Bill Book
- Menu Card
- Flyer
SOUND FORGE
- To record, edit, mix and restore audio pasting data, cutting, deleting, trimming, mixing, floating and docking windows.
ADOBE PREMIERE
- Effects
- Video titling and graphics
- Transitions
- Labels
- Libraries
- Direct Publishing
ASSIGNMENTS & PRESENTATION
EXAM OF MODULE - 5
TALLY PRIME
- Tally & Versions
- Computerized Accounting
- Charts of Accounts
- Accounting Management
- Inventory Management
- Order Processing
- Vouchers
- Payroll
- Banking Features
- Budget
- Back-up & Restore Data
- Job Costing
- Advanced Features
- Taxes : TDS , TCS
- GST
BUSY
- Basic Accounting Practice
- Computerized Accounting
- Charts of Accounts
- Accounting Management
- Inventory Management
- Order Processing
- Vouchers
- Payroll
- Banking Features
- Advanced Features
- TDS
- GST
ADVANCED EXCEL
- Advanced Shortcuts
- Advanced Conditional Formatting
- Advanced Functions
- Lookup & Reference Functions (vlookup, hlookup,index,match,double vlookup, vlookup with match,hlookup with match, index with match & xlookup)
- Depreciation
- Garbage Cleaning
- Errors
- Reports Using Pivot Table & Charts with slicer and timeline
- Working with Templates
- Sorting and Filtering Data
- Restrictions
- What If Analysis
- Array Calculation
- Database Function
- Macro for automation
- Advanced Protections & Print Technique
ASSIGNMENTS
INTERVIEW TECHNIQUES
FINAL PROJECT & PRESENTATION
FINAL EXAM
- Computer Operator
- Graphic Designer
- Web Designer
- Web Developer
- Accountant
- GST Executive
- Tally Operator
PROF. DIPLOMA IN COMPUTER APPLICATION
DURATION: 12 MONTHS
- Computer Fundamentals
- Windows & Operating System
- Outlook Express
MS-WORD
- Introduction of Word with its Interface
- Explain Tabs Briefly
- Shortcuts
- Mail Merge
- Page Setups (Page visualization & printing)
- Protections
- Macros
MS-EXCEL
- Introduction of Excel
- Explain Interface
- Shortcuts
- Diff b/w Functions & Formulas
- Cell references
- Operators
- Basic Calculations
- Text Function
- Date & Time Function
- Mathematic Function
- Logical Function
- Conditional formatting
- Charts
- Reports using Pivot Table
- Protections
MS-POWERPOINT
- Introduction of Powerpoint
- Explain Interface
- Shortcuts
- Explain Tabs
- Quiz Making
- Designing & Formatting
- Transitions & Animations
- Album creation
- Animations
- Slide Master
Functional communication assignments & presentation exam of module - 1
COREL DRAW
- Corel Draw Basics and Interface
- Working on Layer
- Working on objects with its properties
- Working on Drawing tools
- Working on Tools with its Shortcut
- Transforming Objects
- Outlining & Filling Objects
- Tracing & some other Effects
- Blending Objects
- Applying Distortions
- Applying Mesh Fills
- Working with Text
- Layer Setup & printing
- Import and Export
PHOTOSHOP
- Explain interface with Layers
- Making Selections with its inverse
- Working with Mask
- Working on Paths
- Create & Modify path
- Remove and change the background
- Working on Tools
- Special Effects
- Layer Setup & printing
- Import and Export
ILLUSTRATOR
- Illustrator Basics with its interface
- Selections
- Working on Layers
- Working on Rulers and Guide
- Working on Stroke & color Filling
- Special Effects
- Working on Drawing Tools
- Working with Mask
- Working on Paths
- Working on Tools
- Working with Text
- Import and Export
HTML
- Introduction of HTML
- Basic Structure of HTML
- Tags & its implementation
- Attributes & Elements
- Formatting
- Lists & Tables
- Form Design & validation
- Calculator
CSS (Cascading Styles)
- Introduction of css
- How to use CSS
- CSS Types
- CSS Selectors
- Margins & Padding in CSS
- Animation using CSS
- 2D & 3D CSS
- Navigations & Dropdowns
- Progress Bar
- Slideshow
- CSS Effects
- CSS Layout
- Pseudo classes & element
- Web Layout Design
DREAMWEAVER
- Defining a local site
- Creating a page in Layout view
- Inserting an image and a rollover image
- Working with tables in Standard view
- Creating a link to another document
- Inserting assets from the Assets panel
- Inserting Flash Text and Flash Button objects
- Creating and applying a template
- Running a site report
- Adding a Design Note
WORDPRESS
- Introduction to build dynamic websites and blogs
- Installation of Word press on web server
- Download and Install Add-ins Tools
- Working on Tools
- Working on Themes
- Create, Update and Manage website Edit, Publish, and Modify the content of the website
JAVASCRIPT
- Basic Programming
- Working on logical part of programming
- Variables & Constants
- Datatypes & Operators
- Control Statement
- Looping
- Switch case
- Functions
- JavaScript Implementation with HTML
- Events Handling
PHP
- PHP Introduction and Basics
- PHP Variables and Data Types
- PHP Operators
- Decision Making Statements
- PHP Loops
- Arrays and its functions
- String and its functions
- PHP Date time variables and functions
- PHP Functions
- Including files
- Establishing Connection and Error
- Handling
- Cookies and Session
MYSQL
- SQL Introduction
- SQL DML Commands
- SQL DDL Commands
- SQL Clauses
- SQL Logical Operations
- SQL Aggregate Functions
- SQL Wildcards
- SQL Aliases
- SQL Joins
- SQL Case
- SQL Stored procedures
- SQL Comments
ASSIGNMENTS INTERVIEW TECHNIQUES PROJECT WITH PRESENTATION FINAL EXAM
- Computer Operator
- Graphic Designer
- Web Designer
- Web Developer
E-DIPLOMA IN COMPUTRIZED ACCOUNTING AND E-TAXATION
DURATION: 12 MONTHS
- Computer Fundamentals
- Windows & Operating System
- Outlook Express
MS-WORD
- Introduction of Word with its Interface
- Explain Tabs Briefly
- Shortcuts
- Mail Merge
- Page Setups (Page visualization & printing)
- Protections
- Macros
MS-EXCEL
- Introduction of Excel
- Explain Interface
- Shortcuts
- Diff b/w Functions & Formulas
- Cell references
- Operators
- Basic Calculations
- Text Function
- Date & Time Function
- Mathematic Function
- Logical Function
- Conditional formatting
- Charts
- Reports using Pivot Table
- Protections
MS-POWERPOINT
- Introduction of PowerPoint
- Explain Interface
- Shortcuts
- Explain Tabs
- Quiz Making
- Designing & Formatting
- Transitions & Animation
- Album creation
- Animations
- Slide Master
MS-ACCESS
- Introduction of Access
- Explain Interface
- Explain Tabs
- Table(Design & Datasheet)
- Applying Datatypes on fields
- Constraints
- Wild Cards
- Form
- Queries
- Reports
- Applying wild cards on Queries
- Applying Relationship on table
- Macro
Functional communication
Assignment &Â Presentation
Exam of Module - 1
ADVANCED EXCEL
- Advanced Shortcuts
- Advanced Conditional Formatting
- Advanced Functions
- Lookup & Reference Functions (vlookup, hlookup,index,match,double vlookup, vlookup with match,hlookup with match, index with match & xlookup)
- Depreciation
- Garbage Cleaning
- Errors
- Reports Using Pivot Table & Charts with slicer and timeline
- Working with Templates
- Sorting and Filtering Data
- Restrictions
- What If Analysis
- Array Calculation
- Database Function
- Macro for automation
- Advanced Protections & Print Technique
TALLY PRIME
- Basic Accounting Practice
- Tally & Versions
- Computerized Accounting
- Charts of Accounts
- Accounting Management
- Inventory Management
- Order Processing
- Vouchers
- Payroll
- Banking Features
- Budget
- Back-up & Restore Data
- Job Costing
- Advanced Features
- Taxes : TDS , TCS GST
BUSY
- Basic Accounting Practice
- Computerized Accounting
- Charts of Accounts
- Accounting Management
- Inventory Management
- Order Processing
- Vouchers
- Payroll
- Banking Features
- Advanced Features
- TDS
- GST
WORK READINESS SOFT SKILLs
ASSIGNMENTS
PROJECT with; PRESENTATION
EXAM OF MODULE 2
INCOME TAX
- Introduction of income tax
- Manual tax calculation, prepaid tax and interest
- Computation and E--filling of ITR-
- 01-theory & pratical Computation and E--filling of ITR-
- 02 (HP and 01)-theory & practical Computation and E--filling of ITR-02 (CG and agriculture) Computation of PGBP (proprietor)and E-Filling of ITR-
- 03 Computation of presumptive income and E-Filling of ITR-
- 04(SUGAM) Computation of partnership firm and E-filling of ITR-
- 05 Companies return with ITR-
- 06 Online -PAN filling & E-filling Reg.
TDS
- TDS introduction and Process
- Payment to other than salary-26Q
- TDS return -26Q
- Salary component with payroll
- TDS return -24Q
- Tax Collection at source (TCS)
- Payment to non-resident-27Q
- About traces website
- Interest and penalty
- TDS on rent of property
- TAN (tax deduction and collection account number)
GST
- Introduction -goods & service (GST)
- Types of GST and tax payer
- Scope of supply, place and time of supply and invoice
- Input tax credit(ITC)
- Payment in GST
- GST portal
- Registration migration and new user
- Composition scheme and GST
- RCM-Reverse charge mechanism
- E-way bill and GST
- computation and practical assignment
ROC (REG. OF COMPANY)
- Introduction of MCA
- Types of Company
- How to register new company online
- How to apply DIN
- Incorporation & E-filling of company payment in ROC fees
- Issue Certificates of Incorporation
ASSIGNMENT
INTERVIEW TECHNIQUES
FINAL PROJECT & PRESENTATION
FINAL EXAM
- Computer Operator
- Data Entry Operator
- Accountant
- GST Executive
- Tally Operator
- Senior Accountant
- Tax Consultant
PROF. DIPLOMA IN SOFTWARE DEVELOPMENT
DURATION: 12 MONTHS
C LANGUAGE
- Introduction of C with its Syntax Variables, Data, Types and Operators
- Input Output Operation
- Control Statements
- Loop
- Arrays
- Structure & Union
- Sorting Techniques
- Functions
- Recursion
- Pointers
- File Handling
C++ LANGUAGE
- Introduction of C++ with its syntax Variables, Data Types and Operators
- Input Output Operation
- Control Statements
- Loop
- Structure & Union
- Function & Recursion
- Pointers
- Strings (Group of Characters)
- Object Oriented Programming Language
- Class
- Object
- Inheritance
- Abstraction
- Polymorphism
- Encapsulation
- Interfaces
- Constructor and Destructor
- Multithreading
- File Handling
- Exception Handling
Functional communication
assignments & presentation
exam of module - 1
CORE JAVA
- Introduction to Java
- Variables & Data Types
- Operators & Expression
- Input Output Operations
- Control Statement
- Jump
- Statement
- Loop
- Functions
- OOPS Part
- String
- Array
- Data Structure
- Packages
- File & Exception Handling
- AWT
- Swing
- Multithreading
ASSIGNMENTS
PROJECT WITH PRESENTATION
EXAM OF MODULE 2
PYTHON
- Introduction to Python
- Python Environment Setup and Essentials
- Variables & Data Types
- Operators & Expression
- Input Output Operations
- List & its implementations
- Tuple & its implementation
- Dictionary & its implementation
- Strings
- Control Statement
- Loops
- Jump Statements
- Sorting Techniques
- Functions
- Recursion
- Lambda Function
- Libraries and Modules
MYSQL
- SQL Introduction
- SQL DML Commands
- SQL DDL Commands
- SQL Clauses
- SQL Logical Operations
- SQL Aggregate Functions
- SQL Wildcards
- SQL Aliases
- SQL Joins
- SQL Case
- SQL Stored procedures
- SQL Comments
WORK READINESS SOFT SKILLS
ASSIGNMENTS
PROJECT WITH PRESENTATION
EXAM OF MODULE 3
DATA SCIENCE
- Object Oriented Programming
- Comprehension List
- Collections and Advanced Dictionary
- Set & its implementation
- Data Modelling
- Data Visualization using matplotlib
- User Defined Libraries and Modules
- Advanced Libraries & Modules
- Importing & Exporting Data in Python
- Exception Handling
- Data Analytics Overview
- SQL Connectivity
- Excel Connectivity
- Natural Processing with Scikit Learn
- Data Manipulation with Pandas
POWER BI
- Introduction of Power BI
- Interface of Power BI
- Power BI Mobile Apps
- Power BI Services
- Export data in Power BI
- Shaping and Combining Data
- Modelling Data
- Analyzing Data
- Visualizing Data
- Interactive Data Visualization
- Power BI Data Sources
- Relationships
- Calculations
- Working on Tools
- Creating Power BI Reports
- Assignment
GUI(TKINTER)
- Import the Tkinter module.
- Create the GUI application main window
- Add one or more of the above-mentioned widgets to the GUI application
- Enter the main event loop to take action against each event triggered by the user.
ASSIGNMENTS
INTERVIEW TECHNIQUES
PROJECT WITH PRESENTATION
FINAL EXAM
- Software Developer
- Data Analytics
- Games Developer
- Data Scientist
PROF. DIPLOMA IN COMPUTERIZED ACCOUNTING
DURATION: 8 MONTHS
- Computer Fundamentals
- Windows & Operating System
- Outlook Express
MS-WORD
- Introduction of Word with its Interface
- Explain Tabs Briefly
- Shortcuts
- Mail Merge
- Page Setups (Page visualization & printing)
- Protections
- Macros
MS-EXCEL
- Introduction of Excel
- Explain Interface
- Shortcuts
- Diff b/w Functions & Formulas
- Cell references
- Operators
- Basic Calculations
- Text Function
- Date & Time Function
- Mathematic Function
- Logical Function
- Conditional formatting
- Charts
- Reports using Pivot Table
- Protections
MS-POWERPOINT
- Introduction of PowerPoint
- Explain Interface
- Shortcuts
- Explain Tabs
- Quiz Making
- Designing & Formatting
- Transitions & Animation
- Album creation
- Animations
- Slide Master
MS-ACCESS
- Introduction of Access
- Explain Interface
- Explain Tabs
- Table(Design & Datasheet)
- Applying Datatypes on fields
- Constraints
- Wild Cards
- Form
- Queries
- Reports
- Applying wild cards on Queries
- Applying Relationship on table
- Macro
Functional communication
Assignment &Â Presentation
Exam of Module - 1
ADVANCED EXCEL
- Advanced Shortcuts
- Advanced Conditional Formatting
- Advanced Functions
- Lookup & Reference Functions (vlookup, hlookup,index,match,double vlookup, vlookup with match,hlookup with match, index with match & xlookup)
- Depreciation
- Garbage Cleaning
- Errors
- Reports Using Pivot Table & Charts with slicer and timeline
- Working with Templates
- Sorting and Filtering Data
- Restrictions
- What If Analysis
- Array Calculation
- Database Function
- Macro for automation
- Advanced Protections & Print Technique
TALLY PRIME
- Basic Accounting Practice
- Tally & Versions
- Computerized Accounting
- Charts of Accounts
- Accounting Management
- Inventory Management
- Order Processing
- Vouchers
- Payroll
- Banking Features
- Budget
- Back-up & Restore Data
- Job Costing
- Advanced Features
- Taxes : TDS , TCS GST
BUSY
- Basic Accounting Practice
- Computerized Accounting
- Charts of Accounts
- Accounting Management
- Inventory Management
- Order Processing
- Vouchers
- Payroll
- Banking Features
- Advanced Features
- TDS
- GST
ASSIGNMENTS
INTERVIEW TECHNIQUES
PROJECT & PRESENTATION
FINAL EXAM
Computer Operator
Data Entry Operator
Accountant
GST Executive       Â
Tally Operator
PROF. DIPLOMA IN PRE & POST ACCOUNTING
DURATION: 8 MONTHS
ADVANCED EXCEL
- Advanced Shortcuts
- Advanced Conditional Formatting
- Advanced Functions
- Lookup & Reference Functions (vlookup, hlookup,index,match,double vlookup, vlookup with match,hlookup with match, index with match & xlookup)
- Depreciation
- Garbage Cleaning
- Errors
- Reports Using Pivot Table & Charts with slicer and timeline
- Working with Templates
- Sorting and Filtering Data
- Restrictions
- What If Analysis
- Array Calculation
- Database Function
- Macro for automation
- Advanced Protections & Print Technique
TALLY PRIME
- Basic Accounting Practice
- Tally & Versions
- Computerized Accounting
- Charts of Accounts
- Accounting Management
- Inventory Management
- Order Processing
- Vouchers
- Payroll
- Banking Features
- Budget
- Back-up & Restore Data
- Job Costing
- Advanced Features
- Taxes : TDS , TCS GST
BUSY
- Basic Accounting Practice
- Computerized Accounting
- Charts of Accounts
- Accounting Management
- Inventory Management
- Order Processing
- Vouchers
- Payroll
- Banking Features
- Advanced Features
- TDS
- GST
FUNCTIONAL COMMUNICATION
ASSIGNMENT & PRESENTATION
PROJECT
EXAM OF MODULE 1
INCOME TAX
- Introduction of income tax
- Manual tax calculation, prepaid tax and interest
- Computation and E--filling of ITR-01-theory & practical
- Computation and E--filling of ITR-02 (HP and 01)-theory & practical
- Computation and E--filling of ITR-02 (CG and agriculture)
- Computation of PGBP (proprietor)and E-Filling of ITR-03
- Computation of presumptive income and E-Filling of ITR-04(SUGAM)
- Computation of partnership firm and E-filling of ITR-05
- Companies return with ITR-06 Online -PAN filling & E-filling Reg.
TDS
- TDS introduction and Process
- Payment to other than salary-26Q
- TDS return -26Q
- Salary component with payroll
- TDS return -24Q
- Tax Collection at source (TCS)
- Payment to non-resident-27Q
- About traces website
- Interest and penalty
- TDS on rent of property
- TAN (tax deduction and collection account number)
GST
- Introduction -goods & service (GST)
- Types of GST and tax payer
- Scope of supply, place and time of supply and invoice
- Input tax credit(ITC)
- Payment in GST
- GST portal
- Registration migration and new user
- Composition scheme and GST
- RCM-Reverse charge mechanism
- E-way bill and GST
- computation and practical assignment
ROC (REG. OF COMPANY)
- Introduction of MCA
- Types of Company
- How to register new company online
- How to apply DIN
- Incorporation & E-filling of company payment in ROC fees
- Issue Certificates of Incorporation
ASSIGNMENT
INTERVIEW TECHNUIQUES
PROJECT & PRESENTATION
FINAL EXAM
- Data Entry Operator
- Accountant
- GST Executive
- Tally Operator
- Senior Accountant
- Tax Consultant
PROF. DIPLOMA IN MANAGEMENT INFORMATION SYSTEM
DURATION: 6 MONTHS
MS-EXCEL
- Introduction of Excel
- Explain Interface
- Shortcuts
- Diff b/w Functions & Formulas
- Cell references
- Operators
- Basic Calculations
- Text Function
- Date & Time Function
- Mathematic Function
- Logical Function
- Conditional formatting
- Charts
- Reports using Pivot Table
- Protections
ADVANCED EXCEL
- Advanced Shortcuts
- Advanced Conditional Formatting
- Advanced Functions
- Lookup & Reference Functions(vlookup, hlookup,index,match,doublevlookup, vlookup with match,hlookup with match, index with match & xlookup)
- Depriciation
- Garbage Cleaning
- Reports Using Pivot Table & Charts with slicer and timeline
- Working with Templates
- Sorting and Filtering Data
- Restrictions & Errors
- What If Analysis & Array Calculation
- Database Function
- Macro for automation
- Advanced Protections & Print Technique
MS-ACCESS
- Introduction of Access
- Explain Interface
- Explain Tabs
- Table(Design & Datasheet)
- Applying Datatypes on fields
- Constraints
- Wild Cards
- Form
- Queries
- Reports
- Applying wild cards on Queries
- Applying Relationship on table
- Macro
Assignment
Functional communication
Exam of Module - 1
VBA
- Introduction of VBA
- Introduction to Developer tab
- Introduction to Macro Recordings
- Working In the Visual Basic Editor
- Introducing the Excel Object Model
- VBA Excel Macros Programming
- Variable, Const, Operators & Data types
- Input Output Operations
- Control Statement
- Loops
- Select Case
- Arrays
- Functions and Sub Procedure
- Errors & its handling
- User Forms Events(GUI)
- Charts & Dashboards With VBA Macors
MYSQL
- SQL Introduction
- SQL DML Commands
- SQL DDL Commands
- SQL Clauses
- SQL Logical Operations
- SQL Aggregate Functions
- SQL Wildcards
- SQL Aliases
- SQL Joins
- SQL Case
- SQL Stored procedures
- SQL Comments
ASSIGNMENTS
PROJECT WITH PRESENTATION
EXAM OF MODULE 2
POWER BI
- Introduction of Power BI
- Interface of Power BI
- Power BI Mobile Apps
- Power BI Services
- Export data in Power BI
- Shaping and Combining Data
- Modelling Data
- Analyzing Data
- Visualizing Data
- Interactive Data Visualization
- Power BI Dta Sources
- Relationships
- Calculations
- Working on Tools
- Creating Power BI Reports
ASSIGNMENTS
INTERVIEW TECHNIQUES
PROJECT WITH PRESENTATION
FINAL EXAM
- Data Entry Operator
- MIS Executive
- Backend Executive
- Data Analyst
PROF. DIPLOMA IN DIGITAL MARKETING
DURATION: 6 MONTHS
DIGITAL MARKETING PRO
- Introduction to Digital Marketing
- Understanding Digital Marketing.
- Digital Marketing Components.
- Content Basics
- Logo
- Website Banners
- Social Media Post
- Image, Carousel and Graphic Designing (Canva)
- Video Content
- Render Forest
- Article Writing and Blogging
- Types of articles
- Type of blogging
- Social Media Marketing
- Basics and Paid Ads and Content Strategy
- Platforms of SMM
- Website Designing with Zero Programming Knowledge
- Types of websites , domains & Hosting
- SEM-Google Ads
- Analytics and Conversion Tracking
- Types of data in google analytics
- How to get clients & prepare quotations
Â
Â
Functional communication
Project & Assignments
Exam of Module - 1
DIGITAL MARKETING EXECUTIVE
- Affiliate Marketing
- Search Engine Optimization (SEO)
- Search Engine Marketing
- Social Media Marketing
- Facebook Marketing
- Twitter Marketing
- Linked in Marketing
- Instagram Marketing
- Video Marketing
- Pinterest Marketing
- Google ad words
- Mobile Marketing Learning
- Content Marketing
- Email Marketing
- LSI (latent semantic Indexing)
- Google analytics
- Remarketing audience
- Online marketing strategy
- Live Project
INTERVIEW TECHNIQUES
FINAL PROJECT & ASSIGNMENT
FINAL EXAM
- Online Entrepreneur
- Online Lead Manager
- Content Marketer
- Social Media Expert
- Email Marketing
- Digital Marketing Manager
PROF. DIPLOMA IN DOCUMENTATION & GRAPHIC DESIGNING
DURATION: 8 MONTHS
- Computer Fundamentals
- Windows & Operating System
- Outlook Express
MS-WORD
- Introduction of Word with its Interface
- Explain Tabs Briefly
- Shortcuts
- Mail Merge
- Page Setups (Page visualization & printing)
- Protections
- Macros
MS-EXCEL
- Introduction of Excel
- Explain Interface
- Shortcuts
- Diff b/w Functions & Formulas
- Cell references
- Operators
- Basic Calculations
- Text Function
- Date & Time Function
- Mathematic Function
- Logical Function
- Conditional formatting
- Charts
- Reports using Pivot Table
- Protections
MS-POWERPOINT
- Introduction of PowerPoint
- Explain Interface
- Shortcuts
- Explain Tabs
- Quiz Making
- Designing & Formatting
- Transitions & Animation
- Album creation
- Animations
- Slide Master
MS-ACCESS
- Introduction of Access
- Explain Interface
- Explain Tabs
- Table(Design & Datasheet)
- Applying Datatypes on fields
- Constraints
- Wild Cards
- Form
- Queries
- Reports
- Applying wild cards on Queries
- Applying Relationship on table
- Macro
Functional communication
Assignment &Â Presentation
Exam of Module - 1
COREL DRAW
- Corel Draw Basics and Interface
- Working on Layer
- Working on objects with its properties
- Working on Drawing tools
- Working on Tools with its Shortcut
- Transforming Objects
- Outlining & Filling Objects
- Tracing & some other Effects
- Blending Objects
- Applying Distortions
- Applying Mesh Fills
- Working with Text
- Layer Setup & printing
- Import and Export
PHOTOSHOP
- Explain interface with Layers
- Making Selections with its inverse
- Working with Mask
- Working on Paths
- Create & Modify path
- Remove and change the background
- Working on Tools
- Special Effects
- Layer Setup & printing
- Import and Export
Indesign
- Explain interface with page
- Working on Tools and menus
- Setup documents and page size
- Header & Footer
- Working On Master Pages
- Creating table of contents
- Working on Text with its properties & Effects
- Import and Editing Text
- Working on Images
- Working on Frames
- Working on Table
- Transparency
- Vector Graphics practices
- Working on paragraph and characters with its styles creation
- Page & Print Setup
- Exporting
ILLUSTRATOR
- Illustrator Basics with its interface
- Selections
- Working on Layers
- Working on Rulers and Guide
- Working on Stroke & color Filling
- Special Effects
- Working on Drawing Tools
- Working with Mask
- Working on Paths
- Working on Tools
- Working with Text
- Import and Export
ASSIGNMENTS
INTERVIEW TECHNIQUES
PORTFOLIO SUBMISSION
PRESENTATION
FINAL EXAM
Data Entry Operator
Graphic Designer
