• 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
• Computer Fundamentals

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

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 Application 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: 

The full form of DCA is a Diploma in Computer Application. It is a one-year computer-based diploma or course. The course is intended to provide learners with basic, realistic and technological details pertaining to programming tools and applications which are used in our everyday lives. An intermediate or 12th class in any stream from a recognized board or university is the required qualification needed for this program

• Basic internet concepts
• Computer Fundamentals
• Introduction to programming
• Programming in C
• RDBMS & Data Management
• Multimedia
• Corel draw
• Tally ERP 9.0
• Photoshop

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

ALL TOOLS

PASSPRT SIZE PHOTO

TEMPLATE

BOARDER

1. Introduction to HTML

2. HTML Elements and Tags

3. Common HTML Tags

Paragraph:

Links:

4. Formatting Text

5. Creating Forms

1. Introduction to Typing

• What is Typing?
  • Typing is the process of inputting text into a computer or other device by pressing keys on a keyboard.
  • Key aspects of typing include speed, accuracy, and posture.
• Importance of Typing Skills:
  • Enhances productivity in work, education, and personal tasks.
  • A necessary skill for modern communication and job opportunities.

2. Getting Familiar with the Keyboard

• The QWERTY Layout:
  • The standard keyboard layout most commonly used in English-speaking countries.
  • Basic understanding of the different rows (top row, middle row, bottom row) and the home row.
• Home Row:
  • The middle row on the keyboard where your fingers should rest: ASDF (left hand) and JKL; (right hand).
• Fingers Placement:
  • Left hand: Fingers on A, S, D, F.
  • Right hand: Fingers on J, K, L, ;.

3. Proper Typing Posture

• Seated Position:
  • Sit up straight with both feet flat on the ground.
  • Keep your elbows bent at a right angle, wrists straight, and hands positioned over the home row.
• Hands and Fingers Positioning:
  • Use all fingers to type; each finger has specific keys to strike.
  • Avoid "hunting and pecking" with just one or two fingers.

4. Typing Techniques

• Touch Typing:

  • The goal of touch typing is to type without looking at the keyboard.
  • Start by memorizing the location of each letter on the keyboard, and use muscle memory to improve typing speed.

• Typing Speed and Accuracy:

  • Start slow, focusing on accuracy first. Speed will improve as you become more comfortable with the keyboard layout.
  • Use online typing tests to track progress.

• Use of Keyboard Shortcuts:

  • Common shortcuts include:
    • Ctrl + C (Copy),
    • Ctrl + V (Paste),
    • Ctrl + X (Cut),
    • Ctrl + Z (Undo).

5. Typing Drills for Beginners

• Starting with Simple Keys:

  • Practice typing letters from the home row (A, S, D, F, J, K, L, ;).
  • Gradually add the top and bottom rows to your practice as you get comfortable.

• Building Words and Sentences:

  • Practice typing simple words (e.g., “cat”, “dog”, “hello”).
  • Move on to typing short sentences (e.g., “The quick brown fox jumps over the lazy dog”).

• Timed Practice Sessions:

  • Set a timer for 1-5 minutes and type without looking at the keyboard.
  • Focus on typing as many words as possible while maintaining accuracy.

6. Typing Games and Online Resources

• Fun Typing Games:
  • Online typing games can make learning more enjoyable. Websites like TypingClub, Nitrotype, and TypeRacer offer interactive ways to practice typing skills.
• Typing Tests:
  • Online platforms like 10FastFingers, Keybr, and TypingTest allow you to test your typing speed and accuracy.

7. Improving Typing Speed

• Finger Exercises:
  • Practice using all fingers instead of just a few. Strengthen finger muscles with regular typing practice.
• Increase Duration:
  • Gradually increase your practice time to improve stamina.
• Avoid Looking at the Keyboard:
  • Focus on the screen, not your hands. Over time, you will naturally become more efficient at finding the correct keys.

8. Advanced Typing Skills

• Special Characters and Punctuation:
  • Practice typing special characters like !, @, #, $, &, and punctuation marks such as commas, periods, and question marks.
• Typing Numbers:
  • Practice typing numeric keys (1-9, 0) and the symbol keys above them.
• Typing Complex Sentences:
  • Try typing longer, more complex sentences with varied punctuation and capitalization.

9. Typing for Specific Purposes

• Business and Professional Typing:
  • Focus on typing emails, reports, or presentations quickly and accurately.
• Typing for Exams:
  • Practice typing exam-like questions with time limits to improve performance under pressure.

10. Tracking Progress

• Regular Testing:

  • Use online tools to check how fast you are typing and how accurate you are. A good benchmark is aiming for around 40-60 words per minute (WPM) initially, then progressing to 80+ WPM as you improve.

• Keep Challenging Yourself:

  • Set a target typing speed and challenge yourself to improve each week. Keep a record of your progress to stay motivated.

Additional Resources

• Typing Software:
  • Programs like TypingMaster and KeyBlaze offer structured lessons and courses for improving typing skills.
• Books for Typing:
  • Books like "The Typing Book" provide detailed lessons and exercises.

1. Introduction to CorelDRAW

• What is CorelDRAW?
  • CorelDRAW is a vector graphics editor used for creating logos, illustrations, layouts, and digital artwork.
  • It is widely used for print media, web design, and digital illustrations.
• CorelDRAW Interface Overview:
  • Understanding the workspace layout: Tools, Properties Bar, Rulers, Palettes, and Dockers.
  • Introduction to the Menu Bar, Toolbox, Status Bar, and Property Bar.
  • Customizing the workspace to suit your preferences.

2. Basic Tools and Functions

• Creating New Documents:

  • How to set up a new document with correct dimensions and resolution for various projects (e.g., print or web design).

• Working with Basic Shapes:

  • Using basic drawing tools such as the Rectangle Tool, Ellipse Tool, Polygon Tool, and Freehand Tool.
  • Modifying shapes: resizing, rotating, and duplicating shapes.

• Understanding Vectors vs. Pixels:

  • The difference between vector and raster graphics, and how CorelDRAW’s vector-based design works.

3. Drawing and Editing Shapes

• Drawing with the Pen Tool:
  • Creating custom shapes using the Pen Tool and Bezier Tool.
  • Mastering the use of nodes and handles to control curves and angles.
• Editing Shapes:
  • Using the Shape Tool to edit existing shapes (e.g., curves, nodes, and line segments).
  • Introduction to Contour, Envelope, and Extrude effects.

4. Colors and Fills

• Working with Color:
  • Introduction to RGB and CMYK color modes.
  • Using Color Palettes and the Color Picker to choose colors.
• Fills and Strokes:
  • Adding solid fills, gradient fills, and texture fills to shapes.
  • Controlling the thickness and style of the shape’s outline (stroke).
• Gradients and Transparency:
  • Applying gradient fills to objects for depth and dimension.
  • Using the Transparency Tool for creating fading effects.

5. Text Tools and Typography

• Adding Text:
  • How to add Artistic Text and Paragraph Text to a design.
  • Modifying text size, font, and alignment.
• Working with Fonts:
  • Choosing and managing fonts in CorelDRAW.
  • Converting text to curves for unique effects and typography manipulation.
• Text Effects:
  • Applying Text on a Path, Text Effects, and WordArt.
  • Using Text Tool to create customized text designs.

6. Working with Layers and Objects

• Using Layers:

  • Organizing elements on different layers for better control.
  • How to lock, hide, and manage layers for complex designs.

• Grouping and Ungrouping Objects:

  • Grouping elements for easier manipulation.
  • Using Align, Distribute, and Arrange tools to properly position objects.

• PowerClip Tool:

  • Using the PowerClip tool to place objects inside other objects for creative effects.

7. Advanced Drawing Techniques

• Bezier and Pen Tool Advanced Techniques:
  • Creating complex curves and paths using the Pen Tool and Bezier Curves.
  • Mastering node editing to fine-tune vector paths and shapes.
• Tracing Images:
  • Using CorelDRAW’s Image Trace Tool to convert raster images (e.g., JPEG, PNG) into vector graphics.
  • Manual vs. automatic tracing techniques for different image complexities.

8. Effects and Filters

• Applying Effects:

  • Using the Effects Menu to add 3D effects, drop shadows, blurs, and distortions.

• Powerful Filters:

  • Introduction to using Artistic Filters for creating painterly or stylized effects on objects and text.

• Mesh Fill Tool:

  • Understanding and applying the Mesh Fill Tool for creating realistic gradients and shading in objects.

9. Exporting and Printing Designs

• Exporting Files:

  • How to export your design in different formats (e.g., PDF, PNG, JPEG, EPS).
  • Setting up export options for quality and size optimization (e.g., for web or printing).

• Preparing for Print:

  • How to prepare files for professional printing, including the use of crop marks, bleed, and resolution settings.
  • Exporting to CMYK for print production.

10. Project-Based Learning

• Practical Projects:
  • Logo Design: Create a simple logo using shapes, text, and color.
  • Brochure Design: Design a professional brochure with multiple pages and layouts.
  • Banner Design: Create a large-format banner using vector illustrations and text effects.
• Combining Tools:
  • Work on projects that combine several tools and techniques you’ve learned: drawing, text, effects, and more.

11. Advanced Features (Optional)

• Using the Interactive Tools:

  • Mastering Interactive Tools like Interactive Gradient, Interactive Contour, and Interactive Blend for efficient design workflows.

• Customizing CorelDRAW:

  • Learn how to create custom toolbars, shortcuts, and workspaces for a more efficient design experience.

• Creating Web Graphics:

  • Design web-based graphics (like buttons, icons, and banners) optimized for screen display.

12. CorelDRAW Shortcuts and Tips

• Productivity Tips:
  • Keyboard shortcuts and time-saving techniques to increase efficiency.
  • Using the Pick Tool for quick selection and editing.
• CorelDRAW Hacks:
  • Hidden features and tricks that can improve your design workflow.

Additional Resources

• CorelDRAW Community:
  • Join CorelDRAW user forums and communities to stay updated on tips, tutorials, and trends.
• Online Tutorials and Courses:
  • Recommended websites like CorelDRAW’s official site, YouTube tutorials, and Udemy for in-depth video lessons.

1. Introduction to Artificial Intelligence

• What is AI?

  • Understanding AI as a branch of computer science that deals with creating machines capable of intelligent behavior.
  • Overview of the history and evolution of AI.
  • Types of AI:
    • Narrow AI (weak AI) vs. General AI (strong AI).
    • Artificial Superintelligence (ASI) and its theoretical implications.

• Applications of AI:

  • AI in real-world applications like healthcare, finance, robotics, autonomous vehicles, entertainment, and customer service.

2. Fundamental Concepts in AI

• Machine Learning (ML):

  • Introduction to machine learning and how it fits within AI.
  • Types of ML: Supervised learning, unsupervised learning, and reinforcement learning.

• Deep Learning:

  • Overview of deep learning and neural networks.
  • How deep learning models like Convolutional Neural Networks (CNNs) and Recurrent Neural Networks (RNNs) work.

• Natural Language Processing (NLP):

  • How AI understands, processes, and generates human language.
  • Applications of NLP in chatbots, voice assistants, and language translation.

3. Mathematical Foundations of AI

• Linear Algebra:

  • Vectors, matrices, and operations essential for AI algorithms.
  • How linear algebra is used in AI tasks like image processing and data manipulation.

• Probability and Statistics:

  • Basic concepts in probability, Bayes’ theorem, and how they are applied to decision-making in AI.
  • Understanding distributions, hypothesis testing, and statistical modeling in machine learning.

• Calculus:

  • Introduction to differentiation and integration in the context of optimization in AI (e.g., gradient descent).

• Optimization Algorithms:

  • Understanding how optimization works in AI models, focusing on gradient descent and other optimization techniques.

4. Machine Learning Algorithms

• Supervised Learning:

  • Introduction to classification and regression tasks.
  • Common algorithms: Linear regression, logistic regression, decision trees, k-nearest neighbors (KNN), and support vector machines (SVM).

• Unsupervised Learning:

  • Clustering and association tasks.
  • Algorithms like K-means, hierarchical clustering, and principal component analysis (PCA).

• Reinforcement Learning:

  • Understanding how agents learn through rewards and punishments.
  • Key concepts: exploration vs. exploitation, Markov Decision Processes (MDP), Q-learning, and policy gradients.

5. Neural Networks and Deep Learning

• Introduction to Neural Networks:

  • Structure of a neural network: neurons, layers, weights, and biases.
  • Activation functions like sigmoid, ReLU, and softmax.

• Training Neural Networks:

  • The backpropagation algorithm and how weights are updated during training.
  • Understanding overfitting and underfitting and techniques like regularization to mitigate these issues.

• Convolutional Neural Networks (CNNs):

  • How CNNs are used for image processing and computer vision tasks.
  • Layers of CNN: Convolutional layers, pooling layers, and fully connected layers.

• Recurrent Neural Networks (RNNs):

  • RNNs and their applications in sequential data, like time series and language processing.
  • Long Short-Term Memory (LSTM) and Gated Recurrent Units (GRUs) for addressing vanishing gradient problems in RNNs.

6. Natural Language Processing (NLP)

• Text Representation:

  • How text data is represented in AI, including bag-of-words, TF-IDF, and word embeddings (e.g., Word2Vec, GloVe).

• NLP Techniques:

  • Sentiment analysis, named entity recognition (NER), and part-of-speech tagging.
  • Techniques like transformers and attention mechanisms (e.g., BERT, GPT).

• Speech Recognition and Generation:

  • How AI systems understand and generate human speech.
  • Tools and technologies like speech-to-text and text-to-speech (TTS).

7. AI Ethics and Safety

• Ethical Considerations:

  • The implications of AI on privacy, security, and data ownership.
  • Bias and fairness in AI algorithms and the importance of diverse datasets.

• AI Safety:

  • Concerns about the risks of autonomous systems, such as self-driving cars and drones.
  • The importance of explainability and interpretability in AI models.

• AI Regulation:

  • Laws and guidelines surrounding AI research, data use, and deployment.
  • The role of government and organizations in ensuring responsible AI development.

8. AI Tools and Frameworks

• Popular AI Libraries:

  • Introduction to libraries like TensorFlow, Keras, PyTorch, and Scikit-learn for building and training machine learning models.
  • How to implement basic algorithms using these libraries.

• Data Handling and Preprocessing:

  • Techniques for cleaning, transforming, and visualizing data using tools like Pandas, NumPy, and Matplotlib.
  • Data augmentation, feature engineering, and scaling.

9. AI in Practice: Projects

• Hands-on Projects:
  • Image Classification using CNNs and datasets like MNIST or CIFAR-10.
  • Spam Email Classifier using NLP techniques.
  • Reinforcement Learning with an AI agent in a game environment (e.g., OpenAI Gym).
• Model Evaluation and Tuning:
  • How to evaluate model performance using metrics like accuracy, precision, recall, F1-score, and confusion matrix.
  • Hyperparameter tuning using techniques like grid search and random search.

10. Future of AI

• Emerging Trends:
  • Exploring topics like AI in robotics, AI for healthcare, autonomous vehicles, and AI in creative fields (e.g., art generation).
• AI and Society:
  • The future of AI in society, its impact on jobs, and the potential for AI to solve complex global challenges.

11. AI Certification and Career Paths

• AI Career Opportunities:
  • Exploring job roles in AI such as Data Scientist, Machine Learning Engineer, AI Researcher, and AI Developer.
• Certifications:
  • Information on popular AI certifications such as Google AI, Microsoft Azure AI, and IBM AI.

Additional Resources

• Online Platforms:

  • Websites and platforms like Coursera, edX, Kaggle, and Udacity for additional resources, tutorials, and hands-on practice.

• Books and Papers:

  • Recommended reading: "Hands-On Machine Learning with Scikit-Learn, Keras, and TensorFlow" by Aurélien Géron and "Deep Learning" by Ian Goodfellow.

ADVANCED EXCEL + TALLY PRIME WITH GST

? Course Overview

This course is designed to help you master Microsoft Excel automation using VBA (Visual Basic for Applications). You will learn how to automate repetitive tasks, build custom tools, and enhance Excel’s capabilities for professional use.

? Course Objectives

By the end of this course, you will be able to:

• Automate tasks in Excel efficiently
• Create and edit macros
• Speed up data processing and reporting
• Develop user-friendly tools and dashboards

? Course Modules

1. Introduction to VBA

• What is VBA and how it works
• Using the Developer Tab in Excel
• Introduction to Macro Recorder

2. Programming Basics

• Variables and Data Types
• Conditional Statements (If, Else)
• Loops (For, While)

3. Working with Excel Objects

• Workbook, Worksheet, and Range
• Working with cells and data
• Formatting using VBA

4. Macros & Automation

• Recording and modifying macros
• Automating repetitive tasks
• Assigning macros to buttons and shortcuts

5. User Forms & Controls

• Creating input forms
• Using buttons, textboxes, and controls
• Building interactive tools

6. Advanced VBA Concepts

• Error handling
• Functions and procedures
• File automation

7. Real-Time Projects

• Automated report generation
• Data cleaning tools
• Dashboard automation

? Course Duration

• 4 to 6 Weeks (Flexible schedule)

? Mode of Training

• Online / Offline classes
• Practical-based training
• Live projects and assignments

? Who Can Join?

• Students
• Working professionals
• Accountants / Data analysts
• Beginners with basic Excel knowledge

? Career Benefits

• Increased productivity and efficiency
• Strong data handling skills
• Opportunities in MIS, Data Analysis, and Automation roles

? Certification

A certificate will be provided upon course completion.