A Unit of Health & Education Society (Regd.)

Sitemap Icon-search-2
webmail
without-naac-Smart-Object
  • Recognized Under Sec. 2(f) of UGC Act 1956,
  • Approved by AICTE, Ministry of Education, Govt. of India,
  • Affiliated to Guru Gobind Singh Indraprastha University.

Value added courses

INTRODUCTION

In the current era of transformation in Indian economy from manual to digital, from paper to paper less, from contact to contact less along with technology-based infrastructure, there is a massive requirement of trained graduates and professionals equipped with domain specific skill set. To cater this need, Tecnia Institute of Advanced Studies (TIAS) has introduced various value-added programmes across all the professional courses running under GGS Indraprastha University, Delhi. The value-added Programmes for MBA are strategically planned for the holistic development of learners. The courses have been aimed to create a platform for students to explore and realize their potential to the fullest capacity. For MBA Key NISM Modules have been introduced to enhance employability.

About NISM

  1. NISM stands for National Institute of Securities Market and is awarded by NISM – An education wing of SEBI, India.
  2. There are different modules for different segments of financial market.
  3. For MBA’s, Financial Market Module, Capital Market module, Equity derivative market module and Mutual Fund Modules are important from employment point of view.

PROCESS FLOW CHART

DMS-VAC-01 ADVANCE EXCEL Credits:2

Pre-Requisites​​

  1. Basic understanding of MS excel shall be added advantage.

Objectives​​

The objective of this course is to provide conceptual and Practical understanding of Excel and how to set up the chart function of Excel to represent numeric data in multiple formats. The course helps to understand Differentiate between formulas and functions in Excel. It helps to Access and manipulate data using the database functions of Excel. • Create simple & complex macros in Excel.

Learning Outcomes​​

At the end of the course, the students will be able to:

  1. Apply advanced formulas to lay data in readiness for analysis.
  2. Use advanced techniques for report visualizations.
  3. Leverage on various methodologies of summarizing data.
  4. Understand and apply basic principles of laying out Excel models for decision making.

Detail Contents

S.No. TOPIC DESCRIPTION DURATION
Overview of the Basics of Excel
  1. Customizing common options in Excel .
  2. Absolute and relative cells
  3. Protecting and un-protecting worksheets and cells
 (—)
Working with Functions
  1. Writing conditional expressions (using IF) .
  2. Using logical functions (AND, OR, NOT) .
  3. Using lookup and reference functions (VLOOKUP, HLOOKUP, MATCH, INDEX).
  4. VlookUP with Exact Match, Approximate Match.
  5. VlookUP with Tables, Dynamic Ranges .
  6. Nested VlookUP with Exact Match .
  7. Using VLookUP to consolidate Data from Multiple Sheets.
 (—)
Data Validations
  1. Designing the structure of a template.
  2. Using templates for standardization of worksheets.
 (—)
Working with Templates
  1. Specifying a valid range of values for a cell.
  2. Specifying a list of valid values for a cell.
  3. Specifying custom validations based on formula for a cell .
 (—)
Sorting and Filtering Data
  1. Sorting tables .
  2. Using multiple-level sorting.
  3. Using custom sorting .
  4. Filtering data for selected view (AutoFilter) .
  5. Using advanced filter options .
 (—)
Working with Reports
  1. Creating subtotals
  2. Multiple-level subtotals
 (—)
Creating Pivot tables
  1. Formatting and customizing Pivot tables
  2. Using advanced options of Pivot tables
  3. Pivot charts .
  4. Consolidating data from multiple sheets and files using Pivot tables .
  5. Using external data sources
  6. Using data consolidation feature to consolidate data
  7. Show Value As ( % of Row, % of Column, Running Total, Compare with Specific Field)
  8. Viewing Subtotal under Pivot
  9. Creating Slicers ( Version 2010 & Above)
 (—)
More Functions
  1. Date and time functions
  2. Text functions.
  3. Database functions .
  4. Power Functions (CountIf, CountIFS, SumIF, SumIfS) .
 (—)
Formatting
  1. Using auto formatting option for worksheets.
  2. Using conditional formatting option for rows, columns and cells .
 (—)
What If Analysis
  1. Goal Seek .
  2. Data Tables .
  3. Scenario Manager .
 (—)
Charts
  1. Using Charts .
  2. Formatting Charts .
  3. Using 3D Graphs .
  4. Using Bar and Line Chart together .
  5. Using Secondary Axis in Graphs .
  6. Sharing Charts with PowerPoint / MS Word, Dynamically.
  7. (Data Modified in Excel, Chart would automatically get updated).
 (—)

List of Suggested Books

  1. Microsoft Excel 2019 Bible: The Comprehensive Tutorial Resource.
  2. Excel 2019 ALL-IN-ONE for Dummies.
  3. Excel: Quickstart Guide from Beginner to Expert.
  4. Excel 2019: Pivot Table Data Crunching.
DMS-VAC-02 DIGITAL MARKETING Credits:4

Pre-Requisites​​

  1. Students should have knowledge of online marketing fundamentals and advertising via online media such as print, digital, internet marketing

Objectives​​

The main objective of this course to make participants understand the online business models and digital marketing methodology from the point of view of consumers, entrepreneurs. Moreover, the course aims at understanding the student’s different techniques of digital marketing so that they can utilize this technique to support organization’s marketing activities

Learning Outcomes​​

On successful completion of the course, the students will be able to:

  1. Different techniques of promotion on online platforms
  2. Internet marketing communication techniques
  3. Interpret the traditional marketing mix within the context of a changing and extended range of digital strategies and tactics.
  4. Comprehend the importance of conversion and working with digital relationship marketing

GGSIPU UNIVERSITY syllabus​​

No. PROGRAMME COURSE CODECOURSE COURSE TYPE CREDITS PDF
MBA MS 208Digital & Social Media Marketing Specialization: Marketing – Discipline Specific Electives 3
BBA BBA 304Digital Marketing Skill Enhancement 4

Detail Contents

S.No. TOPIC DESCRIPTION MODULE DURATION
Introduction Digital Marketing Evolution, Consumer Behavior, STP, E-Marketing Mix, Content of Digital Marketing Theory 5 Hr
Google My Business Introduction, Create business, Profile generation, creation of website, promotion, keyword selection Theory+Practical 5 Hr
Search Engine Optimization Introduction, On page SEO, Offpage SEO Theory+Practical 4 Hr
Content Writing Introduction, different forms of content writing skills Theory+Practical 1 Hr
Ads Marketing Facebook, Instagram, Google Ads Marketing Practical 5 Hr
Google Analytics Google Analytics, evaluating traffic, cost/ lead Theory+Practical 2 Hr
Blog/Videos Writing impactful blogs and video creation Theory+Practical 2 Hr
Website Building and Marketing WordPress, Shopify, HTML Theory+Practical 4 Hr
Website Building and Marketing WordPress, Shopify, HTML Theory+Practical 4 Hr
Freelancing/Job How to become a digital marketing freelancer and how to get jobs in the field of digital Marketing Theory 2 Hr
 

List of Suggested Books​​

  1. 1. Chaffey, D, Ellis-Chadwick, F, Johnston, K. and Mayer, R, (4th Ed.,2009) Internet Marketing: Strategy, Implementation and Practice, Third Edition, Pearson Education, New Delhi.
  2. Strauss, Judy and Frost, Raymond (6th Ed, 2011), E-Marketing, 5th Edition, PHI Learning, New Delhi.
  3. Roberts, M, L,.(3rd Ed, 2013) Internet Marketing, 1st Indian Edition, Cengage Learning, New Delhi
  4. Shainash G, and Jagdish N Sheth (1st Ed, 2008). Customer Relationship Management- A Strategic Perspective, Macmillan India Ltd
DMS-VAC-02 DIGITAL MARKETING Credits:4

Pre-Requisites​​

  1. Students should qualify basic level of digital marketing and must have the knowledge of marketing platforms for advertising via online media such as print, digital, internet marketing

Objectives​​

The main objective of this course is to make goals, plan campaigns, and reach customers. Understand what keeps customers engaged between attention and action Modify current business operations to provide a better online experience. Master the science of measuring performance versus plan. Grasp the Project management skills. Know how to continuously improve performance to increase ROI with data and analytics.to support organization’s marketing activities.

LEARNING Outcomes

On successful completion of the course, the students will be able to:

  1. Know different techniques of SEO
  2. Understand the target audience by using different tools
  3. Hands-on experience on different promotional techniques.
  4. Learn advanced promotional techniques by using different online marketing tools and channels.

GGSIPU UNIVERSITY syllabus​​

No. PROGRAMME COURSE CODECOURSE COURSE TYPE CREDITS PDF
MBA MS 208Digital & Social Media Marketing Specialization: Marketing – Discipline Specific Electives 3
BBA BBA 304Digital Marketing Skill Enhancement 4

Detail Contents

S.No. TOPIC DESCRIPTION MODULE CONTACT HR. [30 hr] PRACTICE HR. [130 hr]
Introduction Marketing foundation, Digital marketing Ecosystem, consumer behavior, online visibility strategy , online lead strategy, Digital Marketing Evolution, E-Marketing Mix, Content of Digital Marketing Theory 2 Hr 2 Hr
Online Visibility creation Designing skill, Graphic creation using CANVA , video creation skill, building a website, SEO-On-page , off-page and Technical, Local SEO, analytics and Reporting, Google Tag Manager, Social media Optimization – Facebook, twitter, Linkedin, Quora Theory+Practical 12 Hr 48 Hr
Lead Generation Landing page optimization, Google ads , Google ads search campaign, Display advertising, Video advertising, Quora ads social media marketing – Facebook, Instagram, Twitter, linkedin, snapchat, pinterest, Quora. Theory+Practical 4 Hr 30 Hr
Lead Nurturing What’s app marketing, E-mail Marketing, Remarketing, Inbound marketing. Theory+Practical 2 Hr 10 Hr
Artificial Intelligence Introduction to Chat GPT, Chat GPT for communication, using Chat GPT for career advancement. Theory+Practical 2 Hr 10 Hr
E-Commerce Mastery E-commerce Website creation, shopping ads Theory+Practical 3 Hr 10 Hr
Online Earning Methods Blogging & Affiliate, sign up for an affiliate program ,Instagram & Facebook Money making, Making money with youtube, Earning as a Freelancer Theory+Practical 2 Hr 12 Hr
Project Mgmt. Skills Introduction and project work. Theory+Practical 1 Hr 2 Hr
Role of soft skills in Digital marketing Soft skills (Leadership, time mgmt., team work, communication, creativity, self-mgmt. etc.) Theory+Practical 1 Hr 2 Hr
Interview process and preparation session Resume building, Group discussion, Mock interview Theory+Practical 1 Hr 4 Hr
 

List of Suggested Books​​

  1. The psychology of email marketing Influencing subscribers and driving engagement Author: Eleanor Blake Year: 2023
  2. Strauss, Judy and Frost, Raymond (6th Ed, 2011), E-Marketing, 5th Edition, PHI Learning, New Delhi.
  3. Chaffey, D, Ellis-Chadwick, F, Johnston, K. and Mayer, R, (4th Ed.,2009) Internet Marketing: Strategy, Implementation and Practice, Third Edition, Pearson Education, New Delhi.
  4. Shainash G, and Jagdish N Sheth (1st Ed, 2008). Customer Relationship Management- A Strategic Perspective, Macmillan India Ltd.
  5. The Art Of SEO: Mastering Search Engine Optimization by Eric Enge of Stone Temple Consulting, Stephan Spencer, and Jessie C. Stricchiola.
DMS-VAC-03 FINANCIAL LITERACY Credits:2

Pre-Requisites​​

  1. Awareness about basic accounting terms.
  2. Basic mathematical aptitude
  3. Exposure about Financial News

Objectives​​

The objective lays a foundation for learners to build strong money habits early on and avoid many of the mistakes that lead to lifelong money struggles.

Learning Outcomes​​

  1. To be able to understand external factors affecting financial decisions
  2. To be able to calcolate money management with accuracy
  3. To understand financial appraisal tools
  4. To be able to understand financial Market
  5. To be able to understand popolar and safe investment avenues available in the market.

Course Content

S.No. TOPIC DESCRIPTION DURATION
Macroeconomics
  1. Economic policy: Monetary policy & fiscal policy
  2. Forms of taxation in India – Direct taxes Vs Indirect taxes
  3. Implication of taxes on Business and Economy (Inflation, interest rate & Exchange rate)
  4. Union budget:
    1. Integrated rights – Political right, social right, human right, economic right
    2. Fiscal deficit
    3. Economic growth – Industrial sector, Service sector and rural sector
 (6 Hr)
Financial mathematics through Excel
  1. Effective rate of return
  2. Compounding rate of Interest
  3. Time value of money
  4. Amortization schedole
 (7 Hr)
Business Decision
  1. Business and management
  2. Short term decision Vs long term decision
  3. IRR, BEP, Pay back period
  4. Corporate restructuring – Mergers and Acquisitions
 (5 Hr)
Financial Market
  1. Forms of financial market : Capital market and Money market
  2. Financial Instruments
  3. Players of Financial market
  4. Financial intermediaries
  5. Stock market and its indicators
 (6 Hr)
Mutual Fund
  1. Basic Concept and Organizational setup
  2. Types of Mutual fund scheme
  3. NAV and its measurement
  4. MF analysis
  5. Concept of ETF
 (6 Hr)
 

LIST OF SUGGESTED BOOKS​​

  1. The legacy of financial literacy: guiding my child to financial success by jyotinath ganguly
  2. Economic environment in india by Dr. Ravindra Kumar
  3. Financial Mathematics: a comprehensive treatment by giuseppe campolieti, Roman N. Makarov

WEBSITES FOR REFERENCE​​​​

DMS-VAC-04 NISM – MUTUAL FUND Credits:2

Pre-Requisites​​

  1. Awareness about basic financial terms.
  2. Awareness about Financial Products
  3. Exposure about Financial market

Objectives​​

The Objective of this course was having operational and conceptual knowledge of Mutual Fund to become employable in the organizations dealing in Mutual Fund segment, Also to crack NISM – Mutual Fund distributors Module exam organised by SEBI-NISM

About NISM​​

  1. NISM stands for National Institute of Securities Market and is awarded by NISM – An education wing of SEBI, India.
  2. There are different modules for different segments of financial market.
  3. For MBA’s, Financial Market Module, Capital Market module, Equity derivative market module and Mutual Fund Modules are important from employment point of view.

Learning Outcomes​​

  1. Have conceptual framework – functional, legal, and organisational aspect of Mutual Fund.
  2. By Passing NISM Mutual Fund Module students can become SEBI approved (Valid ARN) Mutual Fund Advisor.
  3. Become employable in Banking sector, broking houses etc

Course Structure

S.No. TOPIC DESCRIPTION DURATION
Concept and Role of a Mutual Fund
  1. Know the concept of securities markets and its role in the Indian Economy
  2. Understand the concept of mutual fund and compare and contrast with conventional investment avenues such as Bank Deposits, Post Office Deposits, Public Provident Fund.
  3. Understand the mutual fund industry and related concepts
  4. List the advantages and limitations of a mutual fund
  5. Understand the two plans or routes for investors to invest in a mutual fund
  6. Know about the different kind of investment options available to the investors
  7. Explain the role of new cadre of mutual fund distributors
 (5 Hr)
Fund Structure and Constituents
  1. Know the basic legal structure of mutual funds in India and understand their role
  2. Understand the role and support functions of service providers of mutual funds
  3. Understand the organisation structure of Asset Management Company
 (2 Hr)
Mutual Fund Products
  1. Understand the classification of mutual fund schemes
  2. Explain the categorization and definition of open-end mutual fund schemes
 (2 Hr)
Performance of Mutual Funds
  1. Understand the classification of mutual fund schemes
  2. Understand the concepts of Entry Load and Exit Load and their application in calculating the Net Asset Value (NAV)
  3. Understand the calculation of returns for an investor investing in mutual fund schemes
  4. Understand the concept of risk in a mutual fund investment
  5. Understand the measures of risk adjusted return
  6. Understand the concept of benchmark for some of the mutual fund schemes
 (4 Hr)
Mutual Funds Taxation
  1. Understand the different types of taxes associated with mutual fund schemes
  2. Select different schemes of mutual funds based on their tax implication
 (2 Hr)
Investment Services
  1. Describe the mutual fund investment plans
  2. Understand the systematic transaction processes
  3. Describe the contents and periodicity of Statement of Account (SoA) and Consolidated Account
 (2 Hr)
Investment Services
  1. Describe the mutual fund investment plans
  2. Understand the systematic transaction processes
  3. Describe the contents and periodicity of Statement of Account (SoA) and Consolidated Account Statement (CAS) to the investor
  4. Explain the process for nomination and pledge
  5. List investor services and facilities offered by AMCs
 (4 Hr)
Asset Classes
  1. Understand the objective behind investing in different asset classes through mutual funds
 (2 Hr)
Financial Planning Concepts
  1. Understand the basics of Financial Planning.
  2. Relate financial planning to financial goals and the time horizon for their achievement
  3. Relate Financial Goals with Investment Requirements
 (2 Hr)
Helping Investors with Financial Planning
  1. Understand the steps of financial planning
  2. Know various stages of Life Cycle and investment needs
  3. Know various stages of Wealth Cycle and investment needs
  4. Understand the importance of risk profiling
  5. Understand financial planning with the help of model portfolios
  6. Understand the important parameters for selecting mutual fund schemes
  7. Understand taxation and liquidity aspects while selecting growth and dividend option within a mutual fund scheme
  8. Identify the sources of data to track mutual fund performance
 (5 Hr)
 

LIST OFSUGGESTED BOOKS​​

  1. Study Material prepared by NISM for NISM – Mutual Fund Module

WEBSITES FOR REFERENCE​​​​

DMS-VAC-05 NISM – DERIVATIVE MODULE Credits:2

Pre-Requisites​​

  1. Awareness about basic financial terms.
  2. Awareness about Financial Products
  3. Exposure about Financial market

Objectives​​

The Objective of this course was having operational and conceptual knowledge of Equity Derivatives segment, also to crack NISM – Equity Derivatives Module exam organised by SEBI-NISM

About NISM​​

  1. NISM stands for National Institute of Securities Market and is awarded by NISM – An education wing of SEBI, India.
  2. There are different modules for different segments of financial market.
  3. For MBA’s, Financial Market Module, Capital Market module, Equity derivative market module and Mutual Fund Modules are important from employment point of view.

Learning Outcomes​​

From this Course Students

  1. Have conceptual framework – Functional and Conceptual knowledge of Derivative Market Module.
  2. By Passing NISM Equity derivative Module students can become dealer for derivative segment
  3. Become employable in Banking sector, broking houses etc

Course Structure

S.No. TOPIC DESCRIPTION DURATION
Session 1
  1. What are Derivatives?
  2. Forwards, Futures, & Options
  3. Call and put options
  4. American/European Options
  5. Stock/Index Future and options
  6. Margin, MTM and settlement
  7. Determination of option prices
  8. Market lot size of contracts
  9. Intrinsic value and time value
  10. In/At/Out of the money options
 (—)
Session 2
  1. Long Hedge/Short Hedge
  2. Difference between Square off and Exercise
  3. Straddle/Strangle
  4. Important concepts of derivatives
 (—)
Session 3
  1. Practice questions to understand the concepts
 (—)
Session 4
  1. Paper trading on Futures and Options
 (6 Hr)
 

LIST OF SUGGESTED BOOKS​​

  1. Study Material prepared by NISM for NISM – Derivative Module

WEBSITES FOR REFERENCE​​​​

ADMISSION QUERY
Facebook Instagram Flickr Linkedin Youtube

Courses

Our Visitor

136037

Student Support

Links

Get In Touch

Follow Us

Facebook Instagram Flickr Linkedin Youtube
Mandatory Disclosure
All Right Reseverd © Tecnia Institute of Advanced Studies
Skip to content