College and Professionals Training

English and Language Courses

English Proficiency Courses with Level Test

Duration: 48 to 60 Hours based on the level, Conducted at Colleges, and Online.

Constellation conducts a number of English Language courses for students and professionals. These courses start right at the Beginner’s Level and goes up to Upper Intermediate Level.

The courses are meant for everybody. We teach school students right from primary to high school level. We conduct the courses for college students, professionals, artists, housewives, you name it. The objective is Learning and Improving on the English Language. The classes can be one to one or in batches.

We give below the different levels of the English Language courses that we teach. These levels are based on the International Standards of Common European Framework of Reference (CEFR) for Language levels.

Level	Name
Pre A1	Beginner’s
A1	Elementary
A2	Pre Intermediate
B1	Intermediate
B2	Upper Internediate

How do I find out my level?

The best way to find out your level is to take our English Proficiency Level test. The test is conducted online and based on your performance; we shall recommend the right level for you.

To know more about our English Proficiency and English Proficiency Level test, click on the link below.

I want to know more

Communicative English

Duration: 50 Hours, 25 classes of 2 hours each. Conducted at Colleges, and Online.

Communicative English is a Flagship course of Constellation. We have been taking this course at our center and in colleges for many years. The course encompasses a comprehensive learning of all the four skills of a language namely Listening, Speaking, Reading and Writing. Smaller sub modules of this course can be customised as per requirements and offered. There are a few unique features about this course.

It is meant for both college students and working professionals
A basic idea of English is required for joining the course, rest is left to us to train you
The course is slow paced and gives ample time to practice and absorb what has been taught in class
The course starts with a diagnostic test to understand your level of competence so that the teacher is also aware of your strengths and areas of improvement
The course has the right mix of grammar and sentence construction through which we ensure that you can write correct English
Next, we take you through a lot of exercises on vocabulary to build your stock of words which is necessary for speaking and writing confidently
The mix of exercises on Listening, Speaking, Reading and Writing ensure that you have the overall grooming to communicate effectively in English
Finally, we assist you with inputs on preparation for placements, the dos and don’ts

The curriculum is given below:

Class No.	Course Component
1	Introduction, Ice-Breaker and Diagnostic Test.
2	What is listening? Importance of Listening. Importance of having good speaking skills. Components of good speaking skills – vocabulary.
3	The listening processes; improving listening skills and becoming an active listener. Intonation and Tongue twisters.
4	Different types/modes of listening and the levels of communication. Reading and speaking.
5	Grammar: Introduction to Parts of Speech I. (Nouns/Pronouns/Adjectives). Activities on Listening and Speaking (Self Introduction).
6	Grammar- Continuation of Parts of Speech II. (Adverbs, Verbs). Activities on reading, understanding your reading deficiencies.
7	Grammar: Continuation of Parts of Speech III (Articles, Prepositions). Different types of reading, Bad reading habits. Activities on reading.
8	Vocabulary: kinds of vocabulary and words, antonyms, synonyms, one-word substitution, words and phrases, common list of verbs. Activity on reading Comprehension/Identifying new words/creating sentences.
9	Fluency development techniques in reading comprehension (long and short) with practice. Reading practices with comprehension.
10	Benefits of active listening and suggestions, body language. Sources of listening difficulty created by the speaker and listener, listening practices. Factors affecting Reading Comprehension, reading practices for improving pronunciation and fluency development.
11	Opening a communication, being assertive, managing speech anxiety. Knowing the art of persuasion and influencing. Role-playing real life scenarios.
12	Grammar: Subject Verb Agreement Role-playing real life scenarios continued.
13	Speaking practices: focused on proper sentence structure & tense on given topics. Grammar: Tenses (present tense, present continuous) Exercises: sentence correction, scrambled sentences, fill in the blanks with correct tenses, prepositions, conjunctions, determiners, correct vocabulary.
14	Grammar: Tenses (past tense, present perfect) Reading practice through scripts.
15	Types of writing – for example expressive, journal, literary, etc. Activities on writing, writing Essays & Reports. Understanding common errors in English
16	Basic writing and common writing requirements – sentences, paragraphs, essays, reports, business correspondence. Brainstorming and organizing ideas. Activities on punctuation, creating rough drafts Vocabulary: Learning new words with Exercises Generating ideas with words, writing paragraphs.
17	Email Writing Proposal Writing Listening to silent but loud messages and creating responses.
18	Vocabulary Building: Word groups, Spelling Rules + Dictation. Verbal enhancers. Reading Drills: identifying various accents (through audio). Watching a movie (Part 1) and writing a review.
19	Reading Comprehension Practise: Time based (short and long). (Watching a movie part 2)
20	Reading out the review Grammar: (Past continuous, Past perfect, Future) Speaking Practice: Extempore and Debate.
21	Speaking : Extempore and Debate continued. Activity : Social interactions (you may elaborate a little on various scenarios of social interaction). Activity : Social interactions (meeting an unknown person, interactions in get together and parties).
22	Assessment on the overall development. (Test)
23	Business Correspondence Using Phrasal Verbs: In General conversation Using Phrasal Verbs: In Business Correspondence
24	Presentations: Importance of oral presentations in Education and Business, Essential skills necessary to be a good Presenter/Orator Creating a good presentation Activity: Creating Group Presentations, Giving Presentations
25	Extempore, Debate, assessment on the general improvement of the students. Discussion/Evaluation on Challenges faced while in unfamiliar situations, Debate and Extempore, & working out on shortcomings that was found in the assessment (Test)

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

Indian and Foreign Languages

Duration: 48 Hours, Conducted at Colleges, and Online.

Constellation teaches a number of Foreign Language courses both at colleges and online in batches or individually. We conduct the classes for various levels – A1: Beginner, A2: Elementary, B1: Intermediate, B2: Upper Intermediate, C1: Advanced and C2: Proficiency.

Following are the courses:

Indian Languages	Hindu, Bengali, Sanskrit and Urdu
Foreign Languages	English, French, German, Spanish, Portuguese, Polish, Dutch, Chinese, Japanese, Arabic

To know more about our Indian and Foreign Languages, click on the link below.

I want to know more

Placement Preparation Courses

Aptitude Test Preparation with Online Test Portal

Duration: 80 Hours, Conducted at Colleges, and Online.

The Aptitude Tests are an important component in the placement process. Aptitude tests are conducted for campus placements and most freshers job recruitment drives. The cut-off marks in Aptitude tests can be as high as 80 percent and students need to be very thorough with the topics and work fast in solving the problems.

Other than placement preparation, Aptitude Tests are standard tests conducted by many Government organisations and departments as well as Banks as part of their recruitment procedure.

At Constellation we have been taking classes on Aptitude Tests for the last 9 years at various campuses. We are also conducting them online. The teaching consists of instructions from our tutors on each chapter, introducing the tricks to quick problem solving and practice on our test portals. We clear your doubts in the class.

There are 5 broad topics of the course.

Quantitative Skills
Logical Reasoning
Data Interpretation
Data Sufficiency
Verbal Aptitude

To know more about our Aptitude Test Preparation with Online Test Portal, click on the link below.

I want to know more

Group Discussions and Personal Interview

Group Discussion and Personal Interview are two key components of a recruitment process. We have been conducting training sessions on these two topics for many years and in many colleges including the IITs.

We usually cover the training session on these two topics in the following manner.

Group Discussions (GD) Orientation
Personal Interview (PI) Orientation
Group Discussions practice
Personal Interview Practice

Group Discussions (GD) Orientation

We take the students through an awareness session on what a GD is, how to conduct oneself in a GD and how to work out a strategy for success. The areas we cover are

What is Group Discussions and why do companies conduct GDs
Rules of a GD
Types of Topics – General Awareness, Abstract and Case Studies
The Dos and Don’ts of GDs
Factors essential for success in a GD
Group Enterprise Roles in a GD
Dysfunctional Roles
Demonstration Practice

Personal Interview (PI) Orientation

Similarly, we conduct a orientation class for the students on how to face an interview. The areas that we address are:

Appearing for an interview
The Dos and Don’ts of an interview
Sense of Time
Appearance
Walking in
Greetings
Body language
Communication
Self-Introduction
Listening
Etiquette and Manners
Asking a question

After the two sessions on GDs and Interviews, we conduct practice sessions for the students.

Group Discussions Practice

Students find it difficult in performing well in Group Discussions (GD). The best way to be successful is to practice with a coach. Our trainers are experts in conducting GDs and assessing students on their performance. Feedback is given to each student after every round. The consolidated results are made available to the institute.

We practice three types of GDs with the students. They are:

Generic topics
Abstract topics
Case studies

A rigorous practice with multiple rounds helps the students to do well in any kind of GDs with any company.

Personal Interview Practice

During this round, each student gets a chance to go through 15 minutes of interview and feedback session with an interviewer. He/she is judged on a number of parameters prevalent in the industry like dressing & grooming, etiquette & manners, self-introduction, communication skills, confidence, how well did the person answer technical questions and how well did he/she answer HR questions. An assessment is provided, and the student is given a detailed feedback on areas of improvement.

The results are also shared with the institute. Currently we conduct interview rounds with only HR questions or with IT and HR questions. In case an institute would like us to interview on other domains, they should let us know so that we are able to involve experts from that domain.

You may contact us by filling in the form at For contacting us: https://constellationtnp.com/contact-us/ or you may call us.

Assessment through Online Test, GD and IT or HR Mock Interview

This programme is part of a placement preparedness assessment of students of a college. It is meant for the pre-final or final year students to assess how prepared they are for placements.

It helps the students to gauge their level of preparedness and areas of improvement. For the college, it is a good feedback on the overall performance of the students and a guidance on what needs to be done for further improvement.

We replicate a Day of a Campus Interview during which the students get a feel of what really happens during the actual campus interview visit of a renowned company.

The steps of the programme include:

Topic	Description
Introductory Session	We conduct an hour’s session for the students in which we explain process of placements by reputed organisations, the components of placement and how to prepare for each of them.
Written Assessment	The students have to appear for an assessment test which consist of an Aptitude Test and an IT Test. The IT test is optional. Each of the tests is of duration 1 hour. The tests are similar to what is asked in Placement Aptitude tests of companies. Topics for Aptitude Test Verbal Ability Quantitative Techniques Logical Reasoning Data Interpretation and Data Sufficiency Topics for IT Test Data Structure DBMS C C++ Java Networking Operating Systems
Group Discussions	There will be one round of Group Discussion. Groups of 10 will be called in to face a round of 10-minute group discussion. The student will be scored on the basis of his/her performance. The topics for discussion will include: General topics Abstract topics
Mock Interview	Each student goes through a one to one Personal Interview with a competent interviewer. We usually conduct IT oriented interviews which are popular among Engineering students. For General students and students from Management streams we conduct HR interviews. The parameters of assessment are: How well is the candidate dressed? Etiquette and manners How well did the candidate self-introduce? Ability to answer technical questions Ability to answer HR questions Each student will be given an assessment sheet in which he/she will be marked on the above aspects and he will also be given a consolidated score. His/her areas of improvement is discussed.
Final Results	The assessment of each student will be based on written test, group discussion and mock interview and. The details will be shared with the student as well as the college.

Colleges and Institutes may contact us by filling in the form at For contacting us: https://constellationtnp.com/contact-us/ or you may call us.

Advanced IT Courses

Advanced Technologies Internship on Industrial Design Thinking and Mechatronics

Duration: 1 year, Conducted Online.

The Advanced Technologies Internship is a flagship course offered jointly by Constellation and Plumule Research. It has been conceptualised by Ms. Riti Chatterjee, the CEO of Plumule Research and a veteran in the IT industry for the last 30 plus years.

This course is meant for students of pre final and final years, students who have completed their graduation or post-graduation studies as well as working professionals. It is meant for those who would love to make a career in the new technologies of Industry 4.0.

Objective of the Course

This is a one-year internship program where the student is put on a journey of industrial design thinking and prototyping a minimum viable product for the industry.

During the journey the student will:

Learn to build a sample connected system spontaneously by breaking complex industrial scenarios into sub systems and modules.
Build on crystallizing ideas to pilots and structures evolving through self-organization and natural instincts.
They will learn about systems theory and non-linear dynamics, use of IoT, AI, Machine Learning and Deep Learning.
In all it will be an enriching experience through real world projects and context appreciation and change management.

Benefits of the Course

The benefits are summarised as:

An end to end knowledge of the components of the Industry 4.0 framework
Ability to think independently, ideate and formulate a solution on your own with guidance of an industry mentor
Understand business processes at work in industry and appreciate the role of technology as an enabler
Work on an industry problem, research on the probable solution, build and test
Confidence in pursuing a career in advanced technologies of the future
Access to the Constellation placement network of companies across who recruit from the pool of students that we train

Course Content

The course content is given below:

Sl. No.	Phase	Content
1	Onboard	Register for the course Understanding Global Citizenship Education: ESG & SDG Exposure to Code of Business Ethics Idea Storm: Complex Systems and Self Organization
2	Immerse	Technology Learning: Python, IoT, AI/ML, AR/VR, Robotics, Cloud, Cybersecurity, Big Data/ Hadoop, Blockchain, Quantum Computing Hybrid Microservices architecture Enterprise Architecture Industrial Design Thinking Business Model Innovation, Case Studies Financials & Legal Flipped Learning Models
3	Explore	Search for the problem of your choice in a repository Look for partnerships in the community to build team Study available industry reference Proactively look for signals for change to see what’s next in that industry
4	Innovate	Creative thinking, use technology to bring new benefits, new consumers, new contexts, new products, new services. Democratizing and building the culture of practising innovation
5	Design	Gated entry: minimum 3/5 in each dimension: Rate of learning of business & technology Ecosystem / connected thinking Hybrid visualization Application of Systems & Standards Power of Imagination and Long Thinking Critical thinking Empathy Stakeholder / Beneficiary Modelling, Design Principles, Data Leverage & AI, Business & Technology Innovation, Governance
6	Test	Autonomous testing, instilling robustness and resilience, contextual sensitivity, building capacity for zeitgeist leadership Building a product or a solution that evolves with time.
7	Deploy	Create return on experience, create sustainable outcomes, moving upward in downturns, continue to know from the market, build readiness for disruption, complete retooling, build leadership and psychology for turnarounds, thinking through the impossible to build the Art of the Possible

To know more about our Advanced Technologies Internship on Industrial Design Thinking and Mechatronics, click on the link below.

I want to know more

Full Stack Developer Course

Duration: 80 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

The Full Stack Developer Course is a Flagship programme of Constellation. It is a course meant for students and professionals who are interested to develop all the skills; frontend, middle tier and backend using a popular set of technologies to become a complete developer. The industry today likes to recruit an IT professional who has complete knowledge of a set of technologies required for development of all the components of a software application.

The course provides an in-depth learning to a student to become a full stack developer. The teaching methodology will consist of a mix of lecture, demonstration, hands on problem solving and working on a project.

This course is offered under the mentorship of our senior trainer Ms. Sreya Banerjee. Ms. Banerjee has done her BTech in Computer Science and Engineering and has more than 10 years of experience in teaching and software development.

The student is eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below.

Sl. No.	Content
1	Front End Tool HTML CSS Javascript
2	Front End Framework and Libraries Bootstrap – Angular React.js JQuery
3	Back End Development and Framework PHP Laravel
4	Database MySQL

To know more about our Full Stack Developer Course, click on the link below.

I want to know more

Python

Duration: 30 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

This course is offered in collaboration with InsAnalytics, our partners in advanced IT courses. The training methodology involves a mix of teaching, demonstration, hands on problem solving and working on a project. On successful completion of the course or internships, the student is eligible for longer duration internships with InsAnalytics.

The student is also eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below:

Sl. No.	Content
1	Programming Fundamentals of Python
2	Widely used Python Packages (including Libraries for Data Analytics & Machine Learning)
3	Data Visualization Package/Library
4	Problem Solving/ Implementation using Python (including usage of the libraries/ packages)
5	Fundamental Concepts of OOPs (Object Oriented Programming)
6	Structured Problem Solving using OOPs/Implementation of OOPs using Python Data Structures & Algorithms – Concepts
7	Implementation of Data Structures & Algorithms to solve Business Problems
8	Database Management Concepts and implementation using Python
9	NoSQL Database (MongoDB)
10	Database connectivity from Python environment (both RDBMS & NoSQL)
11	Advanced Topics – Programming Fundamentals

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

React Native

Duration: 30 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

React Native is a JavaScript framework for writing real, natively rendering mobile applications for iOS and Android. React Native exposes JavaScript interfaces for platform APIs, so your React Native apps can access platform features like the phone camera, or the user’s location. React Native is a must do course for developers who would like to develop mobile applications.

The training methodology involves a mix of teaching, demonstration, hands on problem solving and working on a project.

The student is eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below:

Sl. No.	Content
1	Introduction to mobile Apps
2	Introduction to Javascript
3	React JS
4	Forms
5	Introduction to React Native
6	Installation and tools
7	Basics and Elements
8	Navigation
9	User Input and Error Handling
10	Use of Firebase
11	Use of Camera
12	Configuration of Google map
13	Deployment (steps to generate file for Android or IOS)

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

Flutter

Duration: 30 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

Flutter is an app SDK for building high-performance, high-fidelity apps for iOS and Android from a single codebase. The goal is to enable developers to deliver high-performance apps that feel natural on different platforms. Flutter has emerged as a popular course for developers who would like to work on mobile applications development.

The training methodology involves a mix of teaching, demonstration, hands on problem solving and working on a project.

The student is eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below:

Sl. No.	Content
1	Introduction to mobile Apps (Flutter and its architecture)
2	Installation of IDE, tools, packages
3	Dart Technology
4	Widgets
5	States
6	Layouts
7	Screen and navigation
8	Views
9	SQLite
10	Use of Camera and storage
11	Access of map

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

Internet of Things (IoT)

Duration: 30 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

This course is offered in collaboration with Plumule Research, our partners in advanced IT courses. The training methodology involves a mix of teaching, demonstration, hands on problem solving and working on a project. On successful completion of the course or internships, the student is eligible for longer duration internships with Plumule Research.

The student is also eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below:

Sl. No.	Topic	Content
1	Introduction	IoT Eco System Components, Sensors, Micro Controllers, Gateways, Protocols, IoT Cloud, Industry Reference Architecture, Case Studies
2	Design of a simple IoT system	IoT Application Design, Physical Design, Logical Design, Network Design, Pilot Project 1: Arduino
3	Design of IoT cloud systems	Design of applications with ESP01: ESP8266 Serial wifi transceiver, Publishing sensor data on ThingSpeak, Simple trend analytics, Introduction to Azure & AWS Cloud, Pilot Project 2: Track & Trace
4	Advanced Topics	Raspberry Pi3, Installation & Setup, GPIO programming, Python Programming-Data Handling, Machine Learning, Neural Networks, CGI HTTP Server, PubNub: Publish & Subscribe on cloud, Pilot Project 3
5	Industry 4.0 Standards & Reference Models	RAMI 4.0, ISA-95, MoM, MES, NIST Cybersecurity Guidelines, Pilot to Production, Case Studies & Research
6	Data Analytics with IoT	Data Science for IoT, Frameworks for data analytics, Apache Hadoop, MapReduce Programming Model, Apache Oozie, Apache Spark

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

Artificial Intelligence and Machine Learning (AI&ML)

Duration: 30 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

The student is also eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below:

Sl. No.	Content
1	Introduction to AI and Machine Learning in the context of Data Driven Digital Transformation Role of Machine Learning in Modern AI Data Analytics as fundamentals behind modern statistical machine computing. Explorative and Inferential Data Analyses Descriptive Analytics Predictive Analytics Prescriptive Analytics
2	Python Programming to implement Data Analytics and Machine Learning
3	Details of Data Analytics Central Tendencies and their nuances in the context of Data Analyses Dispersion and their nuances in the context of Data Analyses Correlation and Basic Regression
4	Machine Learning using Python Supervised Learning and Unsupervised Learning CRISPDM – Cross Industry Standard Practice for Data Mining Data Engineering and Data Management for Machine Learning Widely used Machine Learning techniques Regression Decision Tree ANN (Artificial Neural Networks)

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

Industrial Robotics – Concepts, Simulation and Programming

Duration: 30 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

The student is also eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below:

Sl. No.	Topic	Content
1	Introduction	Concepts behind Robotics, Manufacturing 4.0, Reference Architectures, IoT, AI/ML, Cloud Computing.
2	Mathematical Models	Kinematics and Dynamics.
3	Planning & Control	Motion Planning, Motion Control and Force Control.
4	Advanced Topics	Sensor Integration, Path Simulation, Design of distributed component -based applications, Calibration & Controller, Control & Scheduling of Flexible Manufacturing Cells.
5	Industry 4.0 Reference Architectures	ISA-95, OPC-UA, RAMI 4.0, MOM 4.0
6	Implementation Case Studies – India & Global	Smart Manufacturing, Smart Logistics

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

Cloud Computing

Duration: 30 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

The student is also eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below:

Sl. No.	Topic	Content
1	Introduction	What is Cloud Computing, Concepts & Terminologies, Cloud Characteristics, Cloud Delivery Models, Comparison between the Models, Impact on the market, Case Studies
2	Anatomy of Cloud Delivery	Anatomy of Cloud Computing Virtualization Partitioning Isolation Encapsulation Storage Efficiency Security Disaster Recovery Resource Management Metering & Billing Case Study: VMWare
3	Introduction to Hypervisor	Type 1 Hypervisor Architecture Resource Management Products Type 2 Hypervisor Architecture Resource Management Products
4	Introduction to AWS	Creating an account Configuring Amazon Cloud Services Compute & Networking Storage & Content Delivery Deployment Management Analytics Elasticity Security Billing Application Programming Interfaces
5	Introduction to Azure	Compute & Networking Storage & Content Delivery Deployment Management Analytics Billing Application Programming Interfaces

Data Analytics

Duration: 30 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

The student is also eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below:

Sl. No.	Content
1	Introduction to Data Science & Data Analytics
2	Overview of Big Data in the context of Data Analytics/ Data Science/ Machine Learning
3	Essentials of Python programming for Data Analytics & Machine Learning
4	Data Analytics using Python
5	Time Series Analysis
6	Visual Analytics and Dashboards using Tableau
7	Data Preparation using Tableau
8	Creation of Charts and Graphs
9	Charts and Graphs Activities
10	Dashboard Activities
11	Assignments & Project Evaluation

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

Conventional IT Courses

C

Duration: 30 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

This course is meant for beginners as a primary programming language. The training methodology involves a mix of lecture, demonstration, hands on problem solving and working on a project.

The student is eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below:

Sl. No.	Content
1	Introduction and Getting Started with C with Tokens, Identifier/Variable Naming Conventions, Variable Initialization, Const, Literals, and Data Types
2	Input Output formats, Operators, Conditional Statements
3	Use of Goto, Break and Continue. Use of Looping.
4	Implementation of Arrays and Strings
5	Implementation of Structures and Unions
6	Pointers in C
7	Preprocessor Directives used in C
8	Functions & Command Line Arguments
9	File Handling in C
10	Graphics through C
11	Data Structure using C
12	Implementation of Algorithms using C
13	SQLite with C

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

Core Java

Duration: 30 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

This course is the first of the two courses on Java and it will help the students to learn the basics of the language before going into the advanced course. The training methodology involves a mix of teaching, demonstration, hands on problem solving and working on a project.

The student is eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below:

Sl. No.	Content
1	Java 9 New Features
2	Introduction to Java
3	Class and Object
4	Constructors
5	Static or class variables and methods
6	Some advanced class concepts
7	Packages in Java
8	Inheritance and its types
9	Abstract classes and interfaces
10	Exception handling in Java
11	Multithreading in Java
12	Generics in Java
13	Java collection framework
14	Basic I/O
15	Annotations used in Java
16	GUI Development with Swing in Java
17	Database Connectivity using Oracle

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

Advanced Java

Duration: 30 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

This course is the second of the two courses on Java and it will help the students to learn the complete power of the programming in Java. The training methodology involves a mix of teaching, demonstration, hands on problem solving and working on a project.

The student is eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below:

Sl. No.	Content
1	Web Development Concepts
2	HTML, CSS, Java script and JQuery
3	Introduction to JEE Architecture
4	Servlet Technology
5	Database using Servlet (Oracle 11g/ MySQL)
6	Request Dispatcher and Session Management in Servlet
7	Servlet Filter, Event and Listeners
8	JSP
9	Java Beans
10	Scopes and Attributes in Servlet and JSP
11	JSTL and JSP Expression Language
12	ORM tools
13	Hibernate Framework
14	Spring Framework

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

Android

Duration: 30 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

The student is eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below:

Sl. No.	Content
1	Installation procedure of android studio & Introduction to Android Programming
2	Overview of an Android Project
3	Android Components, View System, Layout
4	Styles and Themes
5	Notification, Intents and Intent Filters
6	Stored Procedure
7	SQLite Database
8	View Group and Adapter
9	Broadcast receivers
10	Services
11	Google Maps, Connectivity with Bluetooth
12	Connectivity with Firebase and network library, Introduction to Volley Firebase Cloud Messaging
13	Content Providers
14	Connectivity and Cloud

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

PHP with Laravel

Duration: 60 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

This course is meant for beginners as a primary programming language. The training methodology involves a mix of teaching, demonstration, hands on problem solving and working on a project.

The student is eligible for reference to the wide network of Constellation and partner clients across India who recruit fresh graduates.

The course content is given below:

Sl. No.	Content
1	Introduction to HTML 5 & CSS 3
2	Introduction to PHP 7, features of PHP
3	Configure PHP 7 (XAMPP/WAMP)
4	Use Variables and Expressions, Types of Operators
5	Use Conditional and Flow Control Statements
6	Use Functions
7	Create and use Arrays
8	Form Handling
9	MySQL Database
10	Use Cookies and Perform Session Management
11	Javascript, jQuery and Ajax
12	Basic understanding of Javascript
13	Understanding of DOM
14	Understanding MVC Architecture
15	Features of Laravel
16	Understanding Routers, Controllers and Model
17	Request, Cookies and Response through Laravel
18	ORM

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

Courses for Business Management Students

Online Quiz on Business Awareness

The Online Business Quiz is an offering created by Professor G Mohan.

Prof. G. Mohan is a Quiz Master who has conducted numerous quizzes in companies, colleges and clubs. He has begun conducting online business quizzes since 2018 and the offering has gained popularity among students of MBA and PGDM.

G. Mohan has been maintaining a Quiz Blog, http://indiabusinessquiz.com for the last 10 years. It has crossed 2.7 million hits. The site gets over 500 visitors everyday mainly college students, Business school students and quizzers. A number of working executives also use it to update themselves. Besides the blog, Prof G. Mohan posts daily quiz questions on Twitter and has over 3500 followers. He also shares his Weekly Business Quiz through broadcast channels on Whatsapp which is subscribed by over 1500 students.

Prof. G. Mohan has an Engineering degree from IT-BHU Varanasi (now IIT-BHU) and a Post Graduate Diploma in Management from Xavier Institute of Management, Bhubaneswar. He has 20 years of industry experience in MECON and Tata Consultancy Services. He has been part of the Interview panel for campus interviews on behalf of TCS and also as a panel member for admissions to MBA programmes at IIMs and other Business Schools. Since 2006, he has been a Professor of Information Technology at Administrative Staff College of India (ASCI), Hyderabad. He has moved out of ASCI from April 2019 to pursue his interests in training and consultancy as an independent professional.

Background and Need

Based on interactions with recruiters from Business School campuses as well as the senior faculty at select top business schools, it is felt that there is a need to make the students of the business schools ready for placement. There exists a gap between what the industry wants and what the business schools teach. One area of gap is poor business awareness among students. The current batches of students do not like to read long articles and books but prefer short nuggets of information presented to them in a digital form.

Prof. G. Mohan has conceptualised two offerings, Business Sector Analysis and Online Quiz on Business Awareness. Here we shall talk about Online Quiz on Business Awareness. You may look up the course on Business Sector Analysis under the trainings for MBA students. Both the courses are jointly offered by Prof. G Mohan and Constellation.

Objective

To create interest among students to follow news and events in business and management beyond the textbooks
To make acquisition of such knowledge interesting and entertaining through innovation in pedagogy
To prepare students to interact with people from industry during internships and placements

Offering

We have designed an online course for building business awareness for MBA students. This has been piloted successfully in two business schools since 2018-19. The core of this course is a series of business quizzes administered through Internet based on a mix of questions.

Based on news and current events, as well as some other concepts and trivia, we will create a question bank of 80-100 new questions every month. Besides these we have a question bank of over 3000 questions, collected over the years. We also have a network of quiz masters who would be contributing questions. These questions will include questions from various areas of management and business:

Business News and events – Indian
Business news and events – Global
Marketing and Advertising
Financial Awareness
Management terms and jargon including HR and IT
Start-ups/Entrepreneurship
Current affairs beyond business

These questions will be created in multiple formats like Multiple Choice Questions, True/False, Match the following, Fill in the Blanks etc. These questions will be loaded on to an online testing platform www.classmarker.com .

The course content can be customised based on the institute’s focus and standards. The online course should be ideally included as a part of the curriculum to bring about seriousness and bring about a meaningful improvement. The course would require a laptop with an internet connection.

Existing Clients

The Online Business Quiz in the current format was launched at BIMTECH, NOIDA for their PGDM students of the First Year in August 2018. From December 2018, this was included for the PG Diploma in Retail Management at BIMTECH, NOIDA. In the academic session 2019-20, the online business quiz has been included for both First Year and Second Year PGDM as well as Retail Management students.

A pilot of the Online Business Quiz was conducted in 2018-19 academic session at Praxis Business School, Kolkata. After receiving a positive feedback, the same was included as a regular course in the academic session 2019-20 for the PGDM students of both First year and Second Year.

Contact Us

Both individual students, professionals and institutes can contact us to discuss about the course and how to enrol for it.

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

Business Sector Analysis

The Business Sector Analysis is an offering created by Professor G Mohan.

Prof. G. Mohan is an industry professional and an academic with more than 30 years of experience.
He has an Engineering degree from IT-BHU Varanasi (now IIT-BHU) and a Post Graduate Diploma in Management from Xavier Institute of Management, Bhubaneswar. He has 20 years of industry experience in MECON and Tata Consultancy Services. He has been part of the Interview panel for campus interviews on behalf of TCS and also as a panel member for admissions to MBA programmes at IIMs and other Business Schools. Since 2006, he has been a Professor of Information Technology at Administrative Staff College of India (ASCI), Hyderabad. He has moved out of ASCI from April 2019 to pursue his interests in training and consultancy as an independent professional.

Prof. G. Mohan is also a Quiz Master who has conducted numerous quizzes in companies, colleges and clubs. He has begun conducting online business quizzes since 2018 and the offering has gained popularity among students of MBA and PGDM.

Background and Need

Prof. G. Mohan has conceptualised two offerings, Business Sector Analysis and Online Quiz on Business Awareness. Here we shall talk about Business Sector Analysis. You may look up the course on Online Quiz on Business Awareness under the trainings for MBA students. Both the courses are jointly offered by Prof. G Mohan and Constellation.

The idea of this offering is to provide the students appearing for select companies a deeper insight into the industry and competitive landscape of the company just a few days before the placement date. This will be provided by way of a webinar.

Objective

The objective of this workshop will be as follows:

Provide a deeper understanding of the industry in India as it stands today
Bringing some clarity in the pain points facing the industry
Insight into the job profile and career paths in the industry for fresh MBAs

The Institute can share the verticals of the companies that are expected to come for Placement and where the students would need deeper sectoral understanding.

To start with we can offer the following sectors:

Fast Moving Consumer Goods and Consumer Durables
IT and IT Enabled Services
Banking and Financial Services
Retail
Consulting

In addition to the above, if information about any other industries is available in advance, industry experts can be identified who can deliver the workshop.

Contact Us

Both individual students, professionals and institutes can contact us to discuss about the course and how to enrol for it.

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

Professional Courses

Advanced Microsoft Excel

Duration: 12 Hours, Conducted at Colleges, and Online.

The Advanced Microsoft Excel Course is very relevant for both colleges and the corporate. We have conducted this course in MBA colleges where students find it useful.

The Modules of the Course is given below:

Module	Description
Module 1	Overview of the Basics The module includes exploring of the user interface, working with the ribbon & backstage view, working with contextual tabs, using Excel galleries and customising the interface.
Module 2	Cell Reference The module includes understanding the concept, type of cell reference and appreciating mixed cell reference.
Module 3	Working with Formulas and Functions We shall start with understanding formulas and how to enter formulas. We shall next work with general and advance functions. We shall cover conditional expressions using IF, use different forms of IF, and using logical functions inside IF. We shall get into details of Date and Time Function, Text Functions and PMT Functions.
Module 4	Sorting and Filtering Data The module covers two aspects, sorting and filtering. We shall learn sorting lists, different options of sort, multiple-level sorting, and custom sorting. In the area of Filters, we shall work with simple filter, working with top/bottom records, working with date filter, using wild card in filter, text filter, limitation of custom filter and working with unique records in filter.
Module 5	Styles and Formatting This module will deal with cell styles, creating lists using Table, formatting the structure of a list, conditional formatting, working with different options of conditional formatting and using sing formula/function in formatting.
Module 6	VLOOKUP, HLOOKUP, INDEX and MATCH We shall learn how to find approximate or exact matches. We shall learn how to use MATCH function in VLOOKUP, limitation of VLOOKUP, reverse Vlookup & Nested Vlookup, VLOOKUP & IFERROR function, joining two VLOOKUP using CONCATENATE function, working with INDEX & MATCH function and understanding HLOOKUP function.
Module 7	Working with Range Names We shall cover defining, modifying and deleting range names.
Module 8	Data Validations The modules will cover specifying valid range of values for a cell, list of valid values for a cell and specifying custom validations based on formula for a cell.
Module 9	Advanced Charting We shall cover creating different types of charts in a spreadsheet. It will deal with animation, gridlines, layout, style, axis, axis scale, data series, title, legend, and data labels. It will also deal with adding data to different worksheets, moving a chart to another worksheet, combination charts, use of secondary axis, changing data series chart types, adding of trendline and dealing with sparkline.
Module 10	Pivot Tables The module covers creating and editing PivotTables from an existing worksheet, focus PivotTable data using filters and slicers, format PivotTables , creating a PivotTable with data from a text file, creating groups, creating Pivot charts, consolidating data from multiple sheets and files using Pivot tables, using external data sources and using data consolidation feature to consolidate data.
Module 11	What-If-Analysis We shall cover the techniques of What-If-Analysis like goal seek, using data tables and creating and editing scenarios.
Module 12	Protecting Worksheet Styles, Contents and Elements This module deals with building security in the worksheet and cells. It covers protecting the entire worksheet, locking cells, hiding cell formula, password for cell range and password for workbook.
Module 13	Automate Repetitive Tasks by Using Macros The module covers enabling and examining macros, creating and modifying macros and running macros.

Colleges and Institutes may contact us by filling in the form at For contacting us: https://constellationtnp.com/contact-us/ or you may call us.

Project Management and Microsoft Project

Duration: 12 Hours, Conducted at Colleges, and Online.

Project Management is the practice of initiating, planning, executing, controlling, and closing the work of a team to achieve specific goals and meet specific success criteria at the specified time. The objective of project management is to produce a specific set of deliverables which complies with the client’s objectives.

We have conducted Project Management training both for corporates as well as students. Our courses are guided by the Project Management Professional (PMP) course methodology of the Project Management Institute (PMI), USA. It consists of a mix of learning of the Project Management concepts and also working on the Microsoft Project software. The Microsoft Project software is an extremely popular tool in the industry for managing projects.

The curriculum of training is given below:

Sl. No.	Topic
1	What is Project Management? Project Management Concepts Overview – From PMI
2	Project Management Knowledge Areas Project Integration Management Project Scope Management Project Time Management Project Cost Management Project Quality Management Project HR Management Project Communications Management Project Risk Management Project Procurement Management
3	Guided Tour of Microsoft Project Project Management Techniques – Building Project Scope into the Project Plan, understanding project scheduling in the context of project management, handling changes – creating scope change documents, discussions on Project Charter
4	Working with Microsoft Project Creating a project plan, Use of calendar, Title and properties, Creating WBS and tasks, Understanding task dependencies, How do you determine task durations, Milestone tasks, Top down and bottom up planning, Scheduling a project, Linking of tasks to create a schedule, Providing milestone tasks, Scheduling of the plan, Generating the Gantt chart
5	Project Management Techniques – The project triangle – Time, Cost and Quality, Identifying the elements of cost – human resource, material, services, overheads, Procurement and its dependencies on time and cost, Subcontractor management Deming’s Quality Cycle – Plan, Do, Check, Act, Importance of Quality Documents Identifying and allocating human resources
6	Working with Microsoft Project Enter people resources in the system Set up cost resources Provide details through notes Assign work resources to tasks Assign cost resources to tasks Checking the overall plan – duration, work and cost
7	Project Management Techniques Management of Risks – planning, identification, analysis, response, monitoring and control Stakeholder engagement process – identify, assess needs, define actions, establish communication channels, gather feedback, monitor and review Summarising with Project integration Management Direct and manage project execution Importance of regular meetings Regular review of time, scope, cost and quality Be on top of risks, resources, subcontractors and procurements Communicate without fail Achieve proper project closure
8	Working with Microsoft Project Saving a baseline of the plan, Progress the tasks in multiple ways, Comparing progress to baseline, Customise Gantt chart view, timeline view and reports, Generate the critical path and analyse, Adoption of correction measures to keep plan in track

Colleges and Institutes may contact us by filling in the form at For contacting us: https://constellationtnp.com/contact-us/ or you may call us.

Data Analytics with R

Duration: 30 Hours, Conducted at Colleges, and Online. Can be offered as a training course or an internship.

This intensive training course helps students learn the practical aspects of the R programming language and apply them in Analytics cases. It is a hands-on type of course where the trainer discusses the theoretical aspect of the topic, demonstrates problem solving through coding and assists the students to work on the problems themselves.

The course is supplemented by many hands-on exercises which allow attendees to immediately apply their theoretical knowledge in practice. It is a popular course both for MBA and Engineering students who would like to learn a tool for analysing and solving Analytics problems.

This course is offered under the mentorship of our senior trainer Anindya Kumar Banerjee. Mr. Banerjee is a graduate in Science and has undergone a number of IT and Management courses. He has more than 25 years of experience in training experience both for students and working professionals.

The course content is given below:

Sl. No.	Content
1	Introduction to Data Analytics
2	Introduction to R Programming
3	Data Manipulation in R
4	Data Import Techniques in R
5	Exploratory Data Analysis
6	Data Visualization in R
7	Data Mining: Clustering Techniques
8	Data Mining: Association Rule Mining & Collaborative filtering
9	Linear and Logistic Regression
10	Anova and Sentiment Analysis
11	Data Mining: Decision Trees and Random Forest
12	Project Work

Both individual students, professionals and institutes can contact us to discuss about the course and how to enrol for it.

Complete the registration form to register for the course or the Contact form on our Contact Us page for any queries.

For registering for the course:

Registration Enquiry Form

For contacting us: https://constellationtnp.com/contact-us/

DC 9/16/1, 2nd Floor, Shastribagan Joramandir,

Baguiati, Kolkata – 700059

+91 8336807865
+91 8336807862

info@constellationtnp.com