• Computer Fundamentals
• Introduction to Graphic Designing
• Graphic Designing Software & Tools    
• Photoshop    
• Corel Draw    
• Typography    
• Image Layout & Effects    
• Vector Graphics for Designers    
• Shaping, Design & Illustration    
• Art & Visual Perception

Microsoft Excel Advance Features
 Menu Bars
o Formula
o Data
o Review
o View
 Project & Assignments
o GST Invoice & Bills
o Payroll
o Income Tax
o Mark sheet
o Basic Data Entry
o Salary Statement
 Advance Formulas & Functions
o Lookup, Vlookup, Hlookup
o Sumif, sumifs
o Counta, countif, countifs, countblank
o Concatenate
o Datedif, date, month, year, day, edate, eodate, time
o Lan, trim, repeat,
o Upper, lower, proper
o Mid, Left, Right
o Dmax, dmin, dsum, daverage, sumproduct
o If, ifs,
o And, or, true, false
o Pivot Table & Chart
o Whatif analysis, goalseek, data table
 Working with option
o Group, ungroup
o Print area
o Print Title
o Freeze panel
o Data validation
o Text to column
o Remove duplicate
o Consolidate
 Advance Shortcut

MS OFFICE

Ms. Office course trains students how to use MS Office applications use in office work such as creating
professional-quality documents; store, organize and analyze information; arithmetic operations and functions;
and create dynamic slide presentations with animation, narration, images, and much more, digitally and
effectively.
Ms. word
 Creating, editing, saving and printing text documents
 Font and paragraph formatting
 Simple character formatting
 Inserting tables, smart art, page breaks
 Using lists and styles
 Working with images
 Using Spelling and Grammar check
 Understanding document properties
 Mail Merge
Ms. Excel
 Spreadsheet basics
 Creating, editing, saving and printing spreadsheets
 Working with functions & formulas
 Modifying worksheets with color & autoformats
 Graphically representing data : Charts & Graphs
 Speeding data entry : Using Data Forms
 Analyzing data : Data Menu, Subtotal, Filtering Data
 Formatting worksheets
 Securing & Protecting spreadsheets
Ms. Power Point
 Opening, viewing, creating, and printing slides
 Applying auto layouts
 Adding custom animation
 Using slide transitions
 Graphically representing data : Charts & Graphs
 Creating Professional Slide for Presentation.
Internet
 Understanding how to search/Google
 bookmarking and Going to a specific website
 Copy and paste Internet content into your word file and emails
 Understanding social media platforms such as Facebook & Many more
 learn with best practices

TALLY.ERP9

The course is designed to aim at imparting a basic level appreciation programme for the common man. After completing the course the incumbent is able to the use the computer for basic purposes of preparing his personnel/business letters, viewing information on Internet (the web), sending mails, using internet banking services etc. This allows a common man or housewife to be also a part of computer users list by making them digitally literate. This would also aid the PC penetration program. This helps the small business communities, housewives to maintain their small account using the computers and enjoy in the world of Information Technology.

Introduction of Computer
Definition, History, Parts Introduction.
 Typing Master
English Typing Practice
 Microsoft Paint
Basic Drawing, Painting, Designing, Cartoons
 Microsoft Notepad
Text Writing, Notes Making, Typing
 Microsoft Office
Microsoft Word
Letter, Application, Documents, Designs, Resume, Report,
Invoice & Bills
Microsoft Excel
Calculations, Report, Mark sheet, Invoice & Bills, Data
Entry, Formula, Function
Microsoft Power Point
Audio, Video, Picture, Graphics, Animation, Colour,
Shapes, Presentations, Designs, Slides
 Internet
Searching, Downloading (Songs, Video, Movies,
Documents), Form Filling (School, College, Job), Email id,
Online Shopping, Ticket Booking (Train, Bus, Flight,
Movie), Money Transfer.
 Computer Tips & Tricks
Shortcuts, Folder Making, Deleting, Hiding, Wallpaper
Setting, Date Time, Copy Paste, Pen Drive, Printout,

The syllabus of the Advance Diploma in Computer Applications has various subjects such as Forms, databases, Photo editing software, Design Process, etc. The ADCA courses cover a wide range of topics and are divided into two semesters. This is a flexible course that aims to ensure that the students gain access to all the information they need. The semester-by-semester ADCA subject list is listed below:

Description: 

PGDCA full form is Post Graduate Diploma in Computer Application. PGDCA course duration is 1-year, and it focuses on providing students with advanced theoretical and development expertise in computer science and computer applications in the field of IT. PGDCA course fees ranges between INR 7,000 to 1,10,000. PGDCA Syllabus begins with the fundamentals of information technology and lays emphasis on discplines like programming, Java, Data structures, and more.

Description: 

It's a program that teaches the fundamentals of computer and information technology to the common man. The CCC certificate is provided by the National Institute of Electronics & Information Technology (NIELIT) and aims to expand the digital footprint in the country.

1. Introduction to computer 

2. Introduction to GUI Based Operating System

3. Elements of Word Processing

4. Spreadsheets

.5. Computer communication and Internet

6. WWW and web browsers

7. Communication and Collaboration

8. Making small presentations

Introduction to Digital Marketing    
SEO
Social Media Marketing    
Email Marketing
Content Marketing & Copywriting    
Affiliate Marketing
AdWords & PPC    
Google Analytics

• Business environment
• Management
• Marketing
• Financial management
• Business ethics
• Corporate social responsibility

Fundamental of computer

os (windows)

microsoft word

microsoft excel

microsoft power point

engish typing

hindi typing