Module 1: Basic Computer Concepts:-
- Introduction
- What is a Computer?
- Software and Hardware
- Hardware Components
- Hardware Accessories
- Operating System Software
- Software Applications
- Working with Computers
- Computer Terminology
- Starting and Stopping the Computer
- Using the Mouse
- Computer Tools & Utilities
- Disk Utilities
- Files & Directories
- Manipulating Files & Folders
- Working with the Windows Environment
- Internet
- Browsers, E-Mail Clients
Module 2: Word
- Introduction
- Introduction to MSWord
- Menus
- Shortcuts
- Document types
- Working with Documents
- Opening Files – New & Existing
- Saving Files
- Formatting page and Setting Margins
- Converting files to different formats
- Importing
- Exporting
- Sending files to others
- Editing text documents
- Inserting
- Deleting
- Cut, Copy, paste
- Undo, Redo
- Find, Search, Replace
- Using Tool bars, Ruler
- Using Icons
- Using help
- Formatting Documents
- Setting Font Styles
- Font selection – style, size, color etc.,
- Type face – Bold Italic, underline
- Case settings
- Highlighting
- Special symbols
- Setting Paragraph style
- Alignments
- Indents
- Line space
- Margins
- Bullets and Numbering
- Setting Page Style
- Formatting
- Border& Shading
- Columns
- Header & footer
- Setting Footnotes
- Inserting manual Page break, Column break and line break.
- Creating sections and frames
- Inserting Clip arts, pictures, and other files
- Anchoring & Wrapping
- Setting Document Styles
- Table of Contents
- Index
- Page Numbering, data &Time, Author etc.,
- Creating Master Documents
- Web page
- Creating Tables
- Table settings
- Borders
- Alignments
- Insertion, deletion
- Merging
- Splitting
- Sorting
- Formulas
- Drawing
- Inserting Pictures/Files etc.,
- Drawing Pictures
- Formatting &Editing pictures
- Grouping and ordering
- Rotating
- Tools
- Word Completion
- Spell Checks
- Macros
- Mail merge
- Templates
- Using Wizards
- Tracking Changes
- Security
Module 3: MS Excel
1 Introduction
- Spreadsheet & its Applications
- Opening spreadsheet
- Menus & Toolbars & icons
- Shortcuts
- Using help
- Shortcuts
2 Working with Spreadsheets
- Opening a File
- Saving Files
- Setting Margins
- Converting files to different formats
- Importing, Exporting and Sending files to others
- Spreadsheet addressing
- Rows, Columns & Cells,
- Referring cells and Selecting cells
- Entering and Editing Data
- Entering Data
- Cut, Copy, paste, Undo, Redo, Find, Search & Replace
- Filling continuous rows, columns
- Inserting – Data, cells, column, rows & sheets
- Manual breaks
- Computing data
- Setting Formula
- Finding total in a column or row
- Mathematical operations (Addition, Subtraction, Multiplication, Division, Exponentiation)
- Using other Formulas
3 Formatting Spreadsheets
- Formatting – Cell, row, column & Sheet
- Alignment, Font, Border &shading
- Highlighting values
- Hiding/Locking Cells
- Worksheet
- Sheet Name
- Rows& Columns Headers
- Row Height, Column Width
- Visibility – Row, Column, Sheet
- Security
- Formatting – worksheet
- Sheet Formatting & style – background, color , Borders & shading
- Anchoring objects
- Formatting layout for Graphics, Clipart etc.,
4 Working with sheets
- Sorting
- Filtering
- Validation
- Consolidation
- Subtotal
- Creating Charts
- Selecting charts
- Formatting charts, label, scaling etc.
5 Using Tools
- Error Checking
- Spell Checks
- Macros
- Formula Auditing
- Creating & using Templates
- Tracking Changes
- Customization
- Printing worksheet
Module 4th: MS Power Point
1 Introduction
- Opening new Presentation
- Different presentation templates
- Setting backgrounds
- Selecting presentation layouts
2 Creating a presentation
- Setting presentation style
- Adding Text to the presentation
- Formatting a presentation
- Adding style
- Color, gradient fills
- Arranging objects
- Adding Header & Footer
- Slide Background
- Slide layout
- Adding Graphics to the presentation
- Inserting pictures, movies, tables, etc into the presentation
- Drawing Pictures using Draw
2 Adding effects to the presentation
- Setting Animation & transition effect
- Adding audio and video
- Printing Handouts
- Generating standalone presentation viewer
Course content of tally prime
Chapter-1 Fundamentals of Accounting
- Introduction
- Accounting Terms
- Accounting Assumptions, Concepts and Principles
- Assumptions
- Concepts
- Principles
- Types of Accounts
- Golden Rules of Accounting
- Source Documents for Accounting
Chapter-2 Introduction, Downloading and Installation of Tally Prime
- Introduction to Tally Prime
- Downloading & Installation of Tally Prime
- Company Creation
- Shut a Company
- Select a Company
- Alter Company details
- Company Feature and Configurations
Chapter-3 Migration Tally. ERP 9 Data to Tally Prime Chart of Accounts Creating Inventory Master
- Migration Tally. ERP9 Data to Tally Prime
- Chart of Accounting
- Ledger Creation
- Group Creation
- Deletion of Ledger and Group
- Creating Inventory Master
- Creation of Stock Group
- Creation of Units of Measure
- Creation of Stock Item
- Creation of Godowns
- Stock Category
Chapter-4 Recording Accounting Vouchers with bill–wise details in Tally Prime
Chapter-5 Viewing MIS Report in Tally Prime.
Chapter-6 Enabling GST and Recording GST Transaction in Tally Prime
- Creation of Accounting Master
- Creation of inventory Master
Chapter-7 Enabling TDS and Recording TDS Transaction
- Creation of TDS Master and Recording / Transaction
Chapter-8 Order Processing and Recording of Inventory Vouchers
- Purchase Order Processing
- Sales Order Processing
Chapter-9 Activating Credit Limit and Exceeding the credit limit
- Activating the Credit Limit
- Exceeding the credit lim
Chapter-10 Banking feature
- Cheque Management & Printing
- Manual Bank Reconciliation
Chapter-11 Cost Center and Cost Categories
- Allocation of Expenses and Incomes Using Cost Categories
Chapter-12 Storage and Classification and inventory
- Recording of Stock Transfers with Godown Details
- Activating Batch –wish Details
- Price Level and Price Lists
Chapter-13 Backup and Restore of Company Data Export and Import of Data
- Back of Data
- Export and Import of Data
- Exporting or Data in other Available formats
Chapter-14 Enabling GST and Recording Advanced GST Transaction
- Creation of Accounting Master
- Creation of Inventory Master
- Recording GST Compliant Transactions
PHOTOSHOP
MODULE 1
- Basics
- General preferences
- Bitmap v/s vector, common file formats
- Interpolation, resolution and quality issues
- Import percentages (maximum)
- Viewing/opening documents, browsing
- Title bar info, new document specifications
- Color mode
MODULE 2
- Tools and Palettes
- Tool bar, variations
- Options bar (introduction)
- Most commonly used palettes
- Palette options
- Editing tools v/s vector tools
- Rulers, guides and grids
- Using control
MODULE 3
- Image
- Image sizes (handout)
- Image size vs.ss canvas size
- Cropping (and resizing), plus manual
- Image modes
- Basic retouching with clone, heal, patch tool
MODULE 4
- Color adjustment
- Basic tonal adjustment/enhancement
- Brightness/contrast: when to use levels (+ auto), shadow/highlight
MODULE 5
- Quality’ adjustment
- Dust and scratches, reduce noise
- Blur, Gaussian blur
- Sharpen/unshapen, and size issues
MODULE 6
- Transaction Control
- Transactions
- Command Classification
- Save points
- The SET TRANSACTION Command
MODULE 7
- Transformation
- Flipping, scaling, rotating, distorting, perspective
- Control options
- Free transform, straighten or tilt
MODULE 8
- Brushes
- Brush options and parameters
- Brush size and hardness
MODULE 9
- Selections
- Various tools, tool options
- Adding/subtracting
- Inversing, feathering, grow, smooth, expand, similar
- Moving, transforming
- Show/hide
- Pen tool specifics
- Shape tools, options
- Selecting a path, show/hide, active/inactive
- Saving, clipping
- Paths to selections
MODULE 10
- Layers
- Background v layer, creating layers
- Preserving data
- Re-arranging
- Hiding, locking/unlocking
- Naming, deleting
- Layer opacity
MODULE 11
- Type
- Rasterized vs. character, selecting and editing
- Formatting palettes
- Fill and stroke
- Type on a path
MODULE 12
- Workflow
- Automating contact sheets
- Automating batches
- Saving the workspace
- Navigation, using guides and info
MODULE 13
- Saving
- Save options, file formats for InDesign, web etc.
- Paths to Illustrator
- Keyboard shortcut
MODULE 14
- Project achievements:
- House ad/poster
- Web gallery
- Duotone photograph
- Repaired photograph
Corel Draw
Introduction
- Welcome to CorelDraw
- What’s new in CorelDraw
- Jumping Right Into CorelDraw X7
- Welcome to the Welcome Screen
- Touring the user interface
- Creating drawings
- Saving your masterpieces
- Working with Page and Layout
- Working with multiple pages
- Customizing the page layout
- Working with Guidelines and the Snap To Options
- Creating Objects
- Drawing shapes
- Polygon
- Stars
- Graph paper
- The Perfect Shapes Collection
- Lines and Curves
- Node editing using the shape Tool
- Transforming Objects
- Selecting/deleting objects
- Arranging objects
- Working with multiple objects
- Converting objects
- Locking objects
- Design Time Savers
- Cut, copy and paste
- Duplicating and cloning objects
- Using the Step and Repeat docker
- Undo/redo/repeat
- Working with symbols
- Working with Artistic Text
- Working with the Text Tool to create Artistic Text
- Fitting text a path
- The Character formatting docker
- Spelling and Quick correct
- Working with Paragraph Text
- Working with the Text Tool to create Paragraph Text
- The Paragraph formatting docker
- Linking paragraph text frames
- Working with columns
- Additional paragraph features
- Color Outlines and Fills
- Introducing color palettes
- Color filling options
- Color outline objects
- Using the Eyedropper and Paint bucket Tools
- Using the Smart fill Tools
- Layers and the Object Manager
- Working with layers
- Layer Properties
- Using the master layer
- Viewing Your Work
- View modes
- Preview modes
- Using the View Manager
- Using the Zoom Tool
- Find and Replace
- Find and replace objects
- Find and replace text
- Bitmaps
- Applying effects to a bitmap
- Using the Image Adjustment Lab
- Cropping bitmaps
- Converting vector objects to bitmaps
- Shaping Objects
- Shaping objects
- Power Clipping objects
- Adding envelopes
- Working the corners
- The Interactive Tools Flout
- Interactive Blend Tool
- Interactive Contour Tool
- Interactive Distortion Tool
- Interactive Drop Shadow Tool
- Interactive Extrude Tool
- Interactive transparency Tool
- Interactive Fill Tool
- More Special Effects
- Adding perspective