FD-DLM F-TEC Diploma in Digital Learning & MIS

(Training Duration: 288 Hours: 6 Months @ 2 Hours a day + 1 Month of Specialization)

This program is suitable for candidates who are looking for a professional program which can prepare them for employment opportunities in IT - ITES sector and all other sector where IT services or MIS work is needed. The program structure is designed in such a way that it gives in depth know how and skills to work on MS office along with specialised one month top up over and above 6 months of duration for Basic Analytics & MIS skills through Advance Excel. This is a dual certification program which lead to a Diploma from F-TEC and NSQF certification from NASSCOM & NSDC.

Module – 1

Microsoft Office Computer Applications

  • Documentation with MS-Word
  • Presentation with MS-Power Point
  • Database Management with MS-Access
  • MS-Outlook – An Introduction

Office Management & Office Procedures 

  • Office vs. Organization
  • Need of Effective Office Management
  • Skills, Roles & Responsibilities of an Office Administrator
  • Need for Effective Filing
  • Coordination, Planning & Organizing Meetings, Travels & In-House Events
  • Connecting through Skype & Team Viewer
  • Using Data Back-up Technology on Pen Drives, Hard Disks, CD/DVD, One Drive
  • How to connect to Printer & Printing/Scanning Information
  • Procuring Office Supplies

Effective Functional Communication Skills

  • Importance of Effective Communication
  • Verbal Communication – Smart Talk
  • Communicate Effectively – Over Telephone
  • Office & Business Correspondence
  • Write Right
  • Read Right

Module – 2

Microsoft Excel

  • MS Excel – An Introduction

VBA – an Introduction

  • What are VBA Macros
  • Need of VBA Macros
  • Benefit & Limitations of VBA Macro
  • Display of Developers Tab & VB Editor
  • Macro Recordings
  • Introduction to the Writing of Basic VBA codes
  • Working in the Visual Basic Editor
  • Saving Off Your Macro

VBA Macro Programming

  • Use of Decision Making Statements in Macro by using: If & Else Conditions, And /OR Conditions, Select-Case & Not Statements
  • Working with Loops & Range Objects: Introduction of Programming Concepts to write Excel Formulas in Programs

Types of Errors & How to Debug Errors VBA Macro Programming: Form Vs. Active X Controls & Advanced User Forms

  • Data Analysis
  • Charts from Multiple Data Sheets
  • Dashboard Reporting
  • MIS Reporting

Personality Plus

  • Personality Enhancement & Personal Effectiveness for Good Impression

Specialization in CRE – Automotive specific 

  • Introduction to Automotive Industry
  • Introduction to the Job Role – CRE
  • Customer Service
  • Health & Safety at Workplace
  • Work Readiness Skills – Automotive Sales Market

FD-MWD F-TEC Diploma in Graphic Designing & Media Development

This is a professional program suitable for candidates who are looking for employment opportunities in the area of Graphic Designing and Designing for APP and websites. This program equips the candidates in designing and improving the look and feel, functionality and visual appeal of the developed application. It covers a wide range of Web & Media Designing and Development tools. This program also emphasises on building mandatory soft skills. This is a dual certification program which leads to NASSCOM Certification besides Diploma by F-TEC.

Module – 1

Concepts of Graphic Designing, Understanding Colors Corel Draw 

  • Features of Corel Draw
  • Corel Draw Interface Tool Box
  • Selecting Objects
  • Creating Basic Shapes & Reshaping Objects
  • Organising objects
  • Applying Color Fills & Outlines
  • Mastering with Text Introduction Text Tool
  • Applying Effects
  • Different File Formats

Adobe Photoshop

  • Getting to know the Workplace
  • Basic Selection
  • Adjustment Panel
  • Understanding Various Tools
  • Basic Photoshop Correction
  • Layers & Masks
  • Correcting / Enhancing Digital Photographs
  • Type in Photoshop
  • Creating Vector Graphics in Photoshop

Adobe InDesign

  • Getting to know the Workplace
  • Manipulating Text
  • Developing Paragraph, Character & Object Styles
  • Placing, Managing & Editing Linked Graphics
  • Workflow Tips for Placing Graphics into InDesign
  • Placing Graphics within the Cells of a Table
  • Wrapping Text around a Graphic
  • Color & Transparency
  • Adding Interactivity

Adobe Illustrator

  • Navigating Illustrator
  • Draw Basic Shapes
  • Draw Objects
  • Create Vector Images, then Edit those vector images quickly & easily
  • Add Color to your Work
  • Use Blends, Gradients & Patterns
  • Create Symbols to place into your work to save time
  • Create Layers & Masks
  • Add Text to your Documents and even to your Objects & Shapes
  • Create Drawings, Business Cards, Brochures, etc. using Adobe Illustrator

Effective Functional Communication Skills

  • Importance of Effective Communication
  • Verbal Communication – Smart Talk
  • Communicate Effectively – Over Telephone
  • Office & Business Correspondence
  • Write Right
  • Read Right

Module – 2

Web Designing with Dreamweaver

  • Customizing Your Dreamweaver Workspace
  • Switching and Splitting Views
  • Working with Panels
  • Using the Property Inspector
  • Creating a Page Layout
  • Dreamweaver Templates
  • Working with Links
  • HTML Formatting Using Colors & Graphics
  • Working with Tables
  • Creating Forms
  • Web Page Creation
  • Define a Local Site

HTML

  • HTML Tags, Elements & Attributes
  • Graphics in HTML
  • Connecting Web Pages
  • Lists, Tables, Frames & Forms
  • Style Sheets
  • Audio & Video in HTML

CSS

  • Role of CSS in Web Designing
  • Different type of CSS
  • CSS Selectors
  • CSS Properties

JavaScript

  • Introduction to the Scripting Language – JavaScript
  • JavaScript Fundamentals
  • Events & Objects
  • Window, Frame & Form Object

Maintaining a healthy, safe & secure working environment, Manage work to meet requirements, Providing information in standard templates & Personality Plus 

  • Personality Enhancement & Personal Effectiveness for Good Impression

FD-AFM F-TEC Diploma in Accounting & Finance Management

Whether the candidate enrolled is new to accounts management or has some prior experience, this program helps develop a fundamental understanding of accounting principles. This program helps the learner to learn essential skills on MS Excel required to handle financial data. It equip the learner with in – depth practical skills as an Accountant. It provides working knowledge on Tally ERP 9. This program also emphasises on building mandatory soft skills. This is a F-TEC Certified program which leads to F-TEC Diploma.

Module – 1

Manual Accounting

  • Commonly Accepted Accounting Principles
  • Book Keeping

MS Excel

  • Introduction to MS-Excel Interface
  • Navigating Around in an Excel Spreadsheet
  • Working on Simple Calculations
  • Functions; Organize & Process Statistical, Mathematical, Financial & Logical Data
  • Link Worksheets

Using Data Tab; Organize, Analyze & Present Data for various purposes

  • Sorting
  • Filtering
  • Grouping
  • Sub-Totalling
  • Consolidate

Perform “what-if” & Data Analysis for Developing Financial, Marketing & Plans

  • Scenario
  • Goal Seek
  • Data Table

Tools & Techniques to Process & Enhance the Usefulness of Data

  • Data Validation
  • Conditional Formatting
  • Using PivotTable for Tabulating & Managing Data
  • Translating Data Analysis into Meaningful Charts & Graphs
  • Sheet Protection
  • Printing Techniques

Functional Communication

  • Understand the Importance of Effective Communication
  • Verbal Communication – Smart Talk
  • Communicate effectively Over Telephone
  • Write Right – Thumb Rules
  • Office & Business Correspondence

Module – 2

Computerized Accounting Using Tally ERP 9 Basic Concept of Tally ERP9

  • Creation, Modification, Deletion, – Company Group & Ledgers.
  • Company Merging & Splitting

Banking Process in Tally ERP9

  • Cash & Bank Transaction in Tally

Working in Tally

  • Handle Different Types of Vouchers & Recording of Transactions
  • Inventory Management – Create & Maintain Inventories
  • Maintain Bills/Invoice Details & Track Receivables & Payables
  • Create & Maintain Cross-Centres & Budget
  • Understand & Apply Funds Flow & Cash Flow Statements
  • Ratio Analysis & Compute Commonly Used Ratios
  • Analyze Financial Statements
  • Maintain Data Accuracy, Consistency & Backups

Personality Plus

  • Personality Enhancement & Personal Effectiveness for Good Impressions