Adv. DCA with Data Analytics

1.My Business Card

• Document (Page Setup), Size of Business Card
• Tools (Selection, Direct Selection , Shape Tool(Rectangle, Ellipse, Polygon)
• Shapes Property Fill Color & Outline Color
• File Menu New, Open, Save, Save as, Exit

2.Typography

• Tools Gradient, Text Tool & its properties, Type on Path Tool
• Object Menu Arrange, Group, Ungroup, Lock, Unlock
• Place Image

3.Magazine Cover

• Tools Text tool, Gradient Tool
• Layout Menu Ruler Guides, Create Guides, Layout Adjustment
• Object Menu Effects

4.Stylish Brochure Template

• Tools Frame Tool (Ellipse, Rectangle, Polygon), Eye Dropper, Pen, Pencil, Eraser, Line
• Object Menu Corner Options, Pathfinder"
• Layout Menu Columns, Ruler Guides, Create Guides, Layout Adjustment

5.Books & News Paper Publishing

• Layout Menu Add Page, Go to Page, Edit In Story, Auto flow
• Page Pallete Insert Page Number, Master Page
• Type Menu Drop Cap, Bullets & Numbering, Alignments

6.Indexing

• Type Menu Character, Paragraph, Table & Object style
• Layout Menu Table Of Contents

7.Design & Database Fusion-Merging

• Window Menu Data Merge
• File Menu Export

8.Mail and Print

• Types of Printing
• File Menu Export, Print

1.Layering - Backbone Of Picture /Photo

• Intro Photoshop, Application of Photoshop
• Difference Between Image & Layer
• Color Foreground & Background
• Tools Move, Marquee, Zoom, Hand
• File Menu New, Open, Save

2.Play With Background

• Tools Pencil tool , sharpen , smudge , dodge
  ,burn , sponge , Lasso, Magic Wand, Crop, Slice
• Layer pallete new, duplicate,delete,
• Image menu color balance, hue & saturation

3.Masking (Amazing creativity)

• Tools Brush tool
• Layer Menu Layer Mask, Vector Mask, Clipping Mask
• Filter Menu Effects

4.Movie Poster Making

• Gradient ,eraser , paint, bucket, eye dropper
• Layer menu layer style ,merge visible, merge down, flattern 

5.Wedding Album

• Tools  Pattern Stamp, History Brush, Art History Brush
• Layer Menu Masking

6.Logo Creation

• Tools Text and its Parts
• Image Menu modes (RGB, CYMK ,Grayscale)
• Shape Tools Custom Shape Tool, Other Shapes

7.Day to Night Conversion , Water Ripple

• Tools Pen, Path Selection, Direct Selection
• Edit Menu Define Brush
• View Menu Ruler

8.Retouching Image

• Tools Healing Brush, Patch, Clone Stamp, History Brush, Smudge
• Layer Pallate Blending Modes

9.Light & Glow

• Filter Menu Extract, Liquefier, Distort, Stylize, Artistic Gallery
• Layer Pallate Blending Modes

10.Animated Photo & Waterfall

• Layer Pallete Adjustment Layer
• Image Menu Adjustment
• Window Menu Animation (Frames , Timeline)

11.Web Layout/Thumbnail

• Filter Menu Vanishing Point
• Edit Menu Free Transform

12.Passport Size Photos

• File Menu Automate (Batch Create Droplet, Conditional Mode Change, Fit Image, Photo Merge, Crop & Straighten Photo, Picture Package, Contact sheet II Action)
• Layer Menu Smart Object

13.2D Painting

• Image Menu Adjustment Options
• Layer Menu Blending Options

1. Introduction to Canva

• Overview of Canva and its features
• Setting up a Canva account
• Navigating the Canva dashboard

2. Social Media Graphics

• Designing social media posts for Facebook, Instagram, Twitter, and LinkedIn
• Creating social media stories and ads
• Using Canva's social media templates and design tools

3.Presentations

• Creating engaging presentations for work, school, or personal projects
• Using Canva's presentation templates and design tools
• Adding text, images, and graphics to presentations

4.Infographics

• Visualizing data and information with Canva's infographic templates
• Designing and customizing infographics
• Using charts, graphs, and icons in infographics

5.Posters, Flyers, and Brochures

• Designing eye-catching posters for events, promotions, or advertising
• Creating flyers for events, businesses, or services
• Designing tri-fold or bi-fold brochures for marketing materials

6.Business Cards and Branding Materials

• Creating professional business cards with Canva's templates and design tools
• Developing brand guidelines, logos, and visual identities
• Designing letterheads, envelopes, and other branding materials

7.Videos and Animations

• Creating short videos or animations using Canva's video editing tools
• Adding text, images, and graphics to videos
•  Exporting and sharing videos

8.Invitations and Advanced Topics

• Creating invitations for events, parties, or weddings
• Using advanced Canva features like custom fonts, illustrations, and animations

1.Masking

• Intro of Illustrator, Document (page Setup)
• Tools Selection Tool, Direct Selection Tools, Shape Tool(Rectangle, Rounded Rectangle, Ellipse, Polygon), Bloat Tool, Warp Tool
• Shape Property Fill Color & Outline Color
• Clipping Mask

2.Logo Creation

• Tools Gradient, Pen Twirl, Pucker, Scalop , Crystalize, Wrinkle, Group Selection, Magic Wand, Lasso
• Object Menu Arrange Group, Ungroup, Lock, Unlock, Hide, Show
• File Menu Place Image

3.Create Your Own Pattern / Now Your Creativity

• Tools Text & Its Part, Line Segment, Arc, Spiral, Polar Grid, Rectangle Grid,
• Symbol & Its Part, Shape Bulider tool ,object menu :Blend

4.Floral Vector

• Tools Brush, Pencil, Smooth, Path Eraser, Rotate, Reflect
• Object Menu Blend Option
• Effects Menu Distort & Transaction
• Window Menu Align, Gradient, New Brush

5.Social Media Post

• Tools Scale, Shear Text tool, Gradient tool
• Object Menu Clipping Mask
• Effects Menu Photoshop Effects

6.Boucher /Flyer Designing

• Tools Shapes, Pen tool, Gradient
• Type Menu (Font, Recent Fonts, Size, Glyphs, Area Type options, Type on a path, Create Outlines, Find Fonts, Change Case
• Object Menu Clipping Mask
• View Menu Ruler Guide

7.3D Fun

• Effects Menu 3D > Extrude And Bevel
• Tools Eraser, Hand, Zoom, Star, Flare
• Edit Menu Copy, Paste in Front, Paste in Back , Key board shortcuts

8.Beautiful Flower pot With Symbol

• Object Menu Expand & Expand Appearance
• Effects Menu 3D > Revolve
• Tools Shapes, Pen Tool, Star, Flare

9.Funny Hairy Text (Effect)

• Effect Menu Distort and Transaction, Pathfinder
• Object Menu Blend Options

10.Portrait (Vector Art)

• Tools Pen tool, Pencil Tool
• Object Menu Live Trace
• Effects Menu Illustrator Effects, Convert To Shape, Distort & Transform, Stylize

11.Landscape ( Scenery)

• Effects Menu Photoshop Effects( Noise , Flim Grain ,Grain, etc)
• Tools:- pen tool , Brush Tool
• Object Menu :- Path , Offset Path

12.Mandala Art (Graphics)

• Window Menu Pathfinder, Swatches, Transform, Transparency, Creating Symbols
  Brush Pallete & Creating Brush,

13.Smart Features

• Window Menu  Align, Appearance & Creating Texture Using Appearance, Graphic Style, etc

14.Car Parking ( Smart Features)

• Theory - Revision (Assignment Solve)
• Practical Day - Written Test

1.Learn Web Development 

• HTML Basic Intro and Version
• Elements & Tags , Types of elements(Empty and Container)
• Basic HTML element, Hgroup
• Element(H1 to H6)

2.Styles your webpage

• Using Font Element & Its Attributes
• Styles Element (B,I,U,SUB,SUP,EM,MARK)
• Paragraph Element ,Contents Editable
• Center Element, BR element

3.News Section/Digital Showroom

• Image Element, Image Placeholder, Image Map
• Quotation Element (q , bdo , abbr, address)
• Marquee Element

4.Landing Site/Linking 

• Types of Linking : (Local, Interrnal, External, Download, Mail)
• Anchor Element and its Atributes

5.Count The Points

• Order List , Unorder List, Nested List
• Definition List

6.Result Declaration

• Table Element
  Its Components (TR, TH, TD)
  Its Attributes
• Rows &column Merge, Caption Element

7.Framing

• Frameset Element
  Frameset Rows, Frameset Cols, Frame Src ,
• Iframe Element

8.Video/Audio Gallery

• Use Video Element And Audio Element

9.Enquiry Form/Lead Generation

• Form Element
• Input Element And Its Type
  (Text, Radio, Checkbox, Number, range, Email, Password, Button, Submit, Reset, Image, File, Color, Date, Time, Date time-Local, Search)

10.Banking Form/KYC Form

• Form Element
• Advance Attribute of  Input Element (Autocomplete, Autofocus, Tab index, Required, Size, Step)
• Advance Form Element (Select, Text area, Field set, Legend) 

1.Dynamic Site

• CSS Introduction
• Types Of CSS
  (Inline CSS , Embedded CSS, Link/External CSS)

2.Blocks Creation

• DIV Element, Span Element , Margin, Padding, ID & Class

3.Background Magic

• Background Effects
• Background Properties
• Gradient Background
• Linear, Radial, Angular, Diagonal, Repeating
• Browser Supports Key

4.Customize Text

• Formatting Text Font Properties
• Text Properties Text-Overflow, Word-Break, Word-Wrap, Columns
• Border Effects Style, Width, Color

5.Designer List/Chart Library

• Modified List & Tables
  List Properties, Table Properties
• Shadow Effect Box-shadow, Text-Shadow
• Round Corners
• Div, Button etc 

6.Menu Bars/Google Map

• Creating Menu Bar, Anchor Properties, Transition Effects
• Hover Effect Text, Image

7.Timeline/Animated Webpage

• Animation/Transition
• 2D Animation And 3D Animation

1.Introduction Of  WordPress

• WordPress intro 
• Xmapp Intro
• Apace , SQL , Localhost 
• PHP,  my admin

2.Log-in Directory Interface

• Dashboard 
• Front end , Backend Appearance
• Theme , Site Identity

3.Menu/Page Creation 

• Page (Simple)
• ADD,
• Edit
• Delete
• Menu Location

4.Plugins

• About Plugins
• Download , Activate
• Elementor 
• (Text, Inner Section, Button Video , Heading ,Image)

5.Plugins(Form)

• Contact From , Short Code
• WP-from
• Gravity Form
• Formidable From
• Ninja From

6.Plugins(Gallery)

• Envira Gallery
• Nextgen Gallery
• Photo Gallery By Loweb
• Lightbox 
• Divi Gallery Extended

7.Widgets & Posts

• Widgets 
• Main, Secondary Post
• Add , Delete , Edit 
• Category
• Tags

8.Roles and Capabilities Of User

• Administrator , Super Admin 
• Author , Editor 
• Subscriber 
• Add Plugins 
• Easy Collage Plugins

9.Comments And Appearanc

• Comment 
• Moderate & Unmoderated 
• Hide Comments Appearance
• Style.CSS , 404 Template 

10.Website Completion

• Revision

11.Google Sites 

• Intro Of Google Sheet 
• Creation a Website

12.Advance In Google Sheet 

• Page Creation

13.Google Site With Google Other App

• Docs, Sheets , Sliders , Form

Introduction to Filmora

• Overview of Filmora: Features and capabilities
• Installing Filmora: System requirements, download, and installation process
• Interface tour: Understanding the workspace, panels, and tool

Getting Started

• Creating a New Project
• Importing Media: Video, audio, and image files
• Organizing Media: Managing files within the software

Basic Editing Techniques

• Cutting, trimming, and splitting clips
• Adding Transitions: Applying transitions between clips
• Adding Text: Titles, subtitles, and captions
• Working with Audio: Adjusting volume, adding music, and sound effects

Advanced Editing Techniques

• Green Screen (Chroma Key): Removing background from footage
• Picture in Picture: Overlaying multiple videos
• Speed Control: Slow motion and fast-forward effects
• Color Correction: Adjusting brightness, contrast, and color balance

Effects and Filters

• Applying Filters: Presets and custom filters
• Adding Motion Graphics: Animated elements and overlays
• Using Effects: Special effects and visual enhancements
• Working with Layers: Overlaying multiple tracks

Exporting and Sharing

• Exporting Options: Formats, resolutions, and settings
• Rendering Process: Understanding the export process
• Uploading to Social Media: Sharing videos on platforms like YouTube, Facebook, and Instagram

Advanced Features (Optional)

• Audio Editing: Advanced audio manipulation techniques
• Keyframing: Creating animated movements and effects
• Advanced Transitions: Custom transitions and effects
• 3D LUTs: Applying color grading presets

Project Examples and Case Studies

• Step-by-step walkthroughs of editing projects
• Analysis of professional edits using Filmora
• Final Project
• Applying skills learned throughout the course to create a complete video project

• Introduction to Advanced Excel
• Data Cleaning & Formatting Techniques
• Conditional Formatting & Data Validation
• Advanced Formulas & Functions
• Logical, Text, IF, (XLOOKUP, HLOOKUP etc.)
• Pivot Tables & Pivot Charts
• Charts & Graphs for Data Visualization
• Macros & Automation
• What-If Analysis & Scenario Manager
• Protecting & Securing Excel Files
• Dashboard Creation & Final Project

• Introduction to Power BI
• Power BI Interface & Data Importing
• Data Transformation with Power Query
• Data Modeling & Relationships
• Introduction to DAX
• Advanced DAX Functions
• Data Visualization
• Advanced Charts & Custom Visuals
• Filters, Slicers, and Drill Through
• Power BI Dashboard Creation
• Power BI Security & Performance Optimization
• Power BI & Excel Integration
• Final Project & Q&A Session

• Introduction to Python & Installation
• Writing First Program & Data Types
• Strings & String Formatting
• Lists, Tuples, Dictionaries & Set
• Loops & Control Flow Statements
• List & Tuple Methods, Comprehensions
• Dictionary & String Methods
• Functions, Lambda, Map, Filter
• Modules, Datetime, Iterators & Generators
• Introduction to Statistics
• Measures of Dispersion, Probability, NumPy
• OOPs Concepts
• File Handling & Exception Handling
• Logging, Debugging & SQL Connection
• Introduction to NumPy
• Introduction to Pandas
• Data Visualization
• Python Project Discussion

• Introduction to SQL & RDBMS Concepts
• SQL Data Types & Foundation of T-SQL
• Basic SQL Commands (CREATE, ALTER, DROP, etc.)
• SQL Operations (Arithmetic, Comparison, Logical)
• Data Manipulation (INSERT, SELECT, UPDATE)
• SQL Constraints (Primary Key, Foreign Key)
• SQL Clauses (WHERE, ORDER BY, GROUP BY)
• SQL Joins (INNER, LEFT, RIGHT, FULL, SELF)
• Subqueries
• Using EXISTS & Correlated Subqueries
• System-Defined Functions (COUNT, SUM, MAX)
• User-Defined Functions
• Indexes (Simple View, Complex Views)
• Stored Procedures, Altering, Dropping
• Transactions (Commit, Rollback, Savepoint)
• Using Sequences & Auto Increment
• Triggers & Auto-Generated Tables
• Final Project & Real-World SQL Applications