DEV SANSKRITI COLLEGE OF EDUCATION & TECHNOLOGY

                   Khapri, Dhamdha Road, Durg (C.G.),, Email – [email protected] Mobile: 982618962,

 

                    List  of Capacity Building and Skill Enhancement Courses to be conducted by the DSCET

 

             

S.No.

Name of the capability enhancement program

Name of Course

Starting From

1

Soft Skill’s

Personality Development

2016-17

2

Life Skill’s)

yoga

2016-17

3

ICT Computing Skill

LibreOffice Suite Calc

 

2016-17

 

 

                List of Add on  programs conducted by the college

 

S.No.

Name Of Programs

Starting From

1

MS- Office

2017-18

2

Tally

2017-18

3

G.S.T.

2017-18

 

 

 

 

                                      DEV SANSKRITI COLLEGE OF EDUCATION & TECHNOLOGY

                   Khapri, Dhamdha Road, Durg (C.G.),, Email – [email protected] Mobile: 982618962,

 

 

                                                                                                           Syallbus

                                                        MICROSOFT OFFICE

Unit   No

Topic Of the Unit

Theory Period

Practical Period

Total period

1

MS- WORD  - Creating, Editing, Saving and  printing   text document, font and paragraph formatting ,simple character formatting, insert tables ,smart  Art ,page breaks using list and styles, working with images ,using spelling and grammar check understanding document properties, mail merge

3

10

13

2

MS- Excle - Creating ,Editing, saving and printing spreadsheet working with function and formulas, modifying worksheets with color and auto formats graphically representing data: charts and graphs spreading data entry: using data forms, analyzing data: data menu sub Total, filtering data formatting Work Sheets

4

10

14

3

MS POWER POINT – Opening ,viewing, creating and printing slide applying Auto Layout Adding custom animation Using slide Transition graphically representing data: Charts and graphs Creating professional slides for presention

3

10

13

Total

 

10 Hours

30 Hours

40 Hours

 

 

 

 

 

                               DEV SANSKRITI COLLEGE OF EDUCATION & TECHNOLOGY

                   Khapri, Dhamdha Road, Durg (C.G.),, Email – [email protected] Mobile: 982618962,

 

 

 

                                                                                                          Syallbus

                                                   GOODS AND SERVICE TAX

Unit   No

Topic Of the Unit

Theory Period

Practical Period

Total period

1

INTRODUCTION TO GOOD AND SERVICE TAX

 Introduction Direct Tax and indirect Tax, stage of evolution of good & service tax, Subasuming of tax, constitutional background, structure of GST-CGST, SGST,benefits of implementing GST, GSTN-Structure ,Features and functions,  HSN code –SAC code, GST council and its structre, power and function of GST council

 

5

8

13

2

LEVY AND COLLECTION OF TAX TIME AND PLACE OF SUPPLY

Levy and collection tax, rates of GST,scope of supply composite and mixed supplies,E-Commerce Under GST Regine, liabilities to pay tax ,Place of supply, cascading effect of taxation , input Tax credit, benefits of  input tax credit, manner of claiming input Tax credit,input service distribution –recovery of credit, Reversal of credit

5

8

13

3

REGISTRATION AND PAYMENT OF TAX

Compulsary Registration ,deemed registration, GSTN and Its structure,payment of tax, interest,penalty, Tax deduction at  source,collection of Tax

5

7

12

4

ASSESSMENT AND AUDIT

Assessment Meaning ,types of Assessment,self assessment,provisional assessment, Audit,inspection of goods in movement liabilities, provisional attachment

5

7

12

Total

 

10 Hours

30 Hours

50 Hours

                                 

                                                                                                                                 

              

                                 DEV SANSKRITI COLLEGE OF EDUCATION & TECHNOLOGY

                 Khapri, Dhamdha Road, Durg (C.G.),, Email – [email protected] Mobile: 982618962,

                                                                                                                          

                                                                                                            Syallbus

                                                               Tally ERP.9

Unit   No

Topic Of the Unit

Theory Period

Practical Period

Total period

1.

BASIC OF ACCOUNTING

Fundamental Of Tally.ERP9, Getting Functional with Tally, Creating/Setting up Of Company In Tally

2

4

6

2.

ACCOUNTING MASTERS IN TALLY

F11: Features,F12: Features, setting up account Heads

2

4

6

3.

INVENTORY IN TALLY

Stock Group, stock, category, godown / location, units of measures, stock Items, creating inventory masters for national traders.

2

5

7

4.

VOUCHER ENTRY IN TALLY

Accountig, vouchers, Inventory Vouchers, Invoicing

2

4

6

5.

ADVANCE ACOUNTING IN TALLY

Bill wise details, Cost centers and cost categories, voucher class, and cost center, multiple currencies,interest calculation, budget and cost center

2

4

6

6.

ADVANCE INVENTORY IN TALLY

Order Processing, Batch Wise Details, bill of material, price Level and price list, Stock valuation

2

4

6

7.

GOODS AND SERVICE TAX

Introduction of Tax, Payment of tax, interest, penalty, tax deduction at source, collection of tax, tax invice, credit invoice

2

4

6

8.

PAYROLLACCOUNTING AND COMPLIANC

Configuring Payroll in tally, creating Payroll Masters, Processing payroll in tally, Accounting for employer PF contribution ,Accounting for Employer ESI contribution ,General Payroll reports

2

5

7

TOTAL

 

16

34

50

                                                                                                                         

             

                            DEV SANSKRITI COLLEGE OF EDUCATION & TECHNOLOGY

                   Khapri, Dhamdha Road, Durg (C.G.),, Email – [email protected] Mobile: 982618962,

 

 

                                                                                                          Syallbus

                                                   GOODS AND SERVICE TAX

Unit   No

Topic Of the Unit

Theory Period

Practical Period

Total period

1

INTRODUCTION TO GOOD AND SERVICE TAX

 Introduction Direct Tax and indirect Tax, stage of evolution of good & service tax, Subasuming of tax, constitutional background, structure of GST-CGST, SGST,benefits of implementing GST, GSTN-Structure ,Features and functions,  HSN code –SAC code, GST council and its structre, power and function of GST council

 

5

8

13

2

LEVY AND COLLECTION OF TAX TIME AND PLACE OF SUPPLY

Levy and collection tax, rates of GST,scope of supply composite and mixed supplies,E-Commerce Under GST Regine, liabilities to pay tax ,Place of supply, cascading effect of taxation , input Tax credit, benefits of  input tax credit, manner of claiming input Tax credit,input service distribution –recovery of credit, Reversal of credit

5

8

13

3

REGISTRATION AND PAYMENT OF TAX

Compulsary Registration ,deemed registration, GSTN and Its structure,payment of tax, interest,penalty, Tax deduction at  source,collection of Tax

5

7

12

4

ASSESSMENT AND AUDIT

Assessment Meaning ,types of Assessment,self assessment,provisional assessment, Audit,inspection of goods in movement liabilities, provisional attachment

5

7

12

Total

 

10 Hours

30 Hours

50 Hours

 

             

 

             DEV SANSKRITI COLLEGE OF EDUCATION & TECHNOLOGY

                Khapri, Dhamdha Road, Durg (C.G.),, Email – [email protected] Mobile: 982618962,

 

 

                                                                     Syallbus

                                                       Personatity Development

Unit   No

Topic Of the Unit

Theory Period

Practical Period

Total period

1.

Personality

Definition,Elements, Determinants

2

4

6

2.

Personal grooming

Personal Hygiene,social Effectiveness, business Etiquettes(power dressing)

2

4

6

3.

Body Language

Non- verbal communication, type of Body language, Function of body language, Role of body language.

2

5

7

4.

Art of Good communication

Verbal and Non verbal Communication, difference Between oral and written communication, importance of effective communication

2

4

6

5.

Team Behaviour

Types of Team , Team Role and Behaviour

2

4

6

6.

Group Discussion

Do’s and don’t

2

4

6

7.

Interview Preparation

Introduction, resume writing, dress Code, mock interview, how to be successful in an interview

2

4

6

 

                  

 

 

                                       

                                   DEV SANSKRITI COLLEGE OF EDUCATION & TECHNOLOGY

                       Khapri, Dhamdha Road, Durg (C.G.),, Email – [email protected] Mobile: 982618962,

 

 

                                                           SYLLABUS

LibreOffice Suite Calc

Introduction

LibreOffice Calc is the spreadsheet component of the LibreOffice Suite. It is the equivalent of Microsoft Excel in Microsoft Suite and has a number of unique features, including a system which automatically defines series of graphs, based on information available to the user .It is a free and open source software so it can be copied, re used and distributed free of cost.

Contents

[hide]

• 1 Introduction

• 2 Basic Level

• 3 Intermediate Level

• 4 Advanced Level

 

Basic Level

1. Promo of LibreOffice Suite • LibreOffice promo

• Features of LibreOffice

• Uses of LibreOffice

• LibreOffice formats

• LibreOffice tutorials in Spoken Tutorial

• Applications of LibreOffice

• LibreOffice tutorials in various languages

 

2. Introduction to LibreOffice Calc • What is Calc,Who should use Calc,What can be done using Calc.

• About spreadsheets,sheets and cells.

• Basic features – parts of main Calc window - Title & Menu Bar, Standard Toolbar, Formatting Toolbar, Formula Bar, Status Bar

  • What is a cell, row, column, Create new document, enter data in one cell, save in Calc( CSV and other formats),opening/closing document.
  • Save as ods, csv, xls, xlsx and export to PDF

 

  1. 3. Working with Cells • How to enter numbers,text,numbers as text,date and time in Calc.
  • How to use the Format Cells dialog box.

                • How to Navigate between cells and in between sheets. • How to select items in rows,columns and sheets.

                • Inserting and Deleting rows and columns Calc.

                • Inserting and Deleting Sheets in Calc.

                • Renaming Sheets.

                • Borders, Color, Formatting Text, Increasing Cell Size

                • Formatting multiple lines of text,numbers,fonts,cell borders,cell background

                • Automatic Wrapping and Using manual breaks

                • Merging cells, rows and columns, issues with using merge cells.

                • Shrinking text to fit the cell

                • Paste and paste special (values, transpose), pasting a spreadsheet into writer as a table

                • Introduction to Formulas – Sum, Average, basic formula (=a*b+c)

                • Subtotal

                • Different kinds of functions available in spreadsheet

                • Sorting by Columns

                • Filtering Data - Basics

                • Speed up using Fill tools and Selection lists.

                • Sharing content between sheets

                • Remove data,Replace data,Change part of a data.

                • Views options – Zoom option,Freezing and Splitting of screen, Page break view

                • Printing options and settings, header, footer

                • Print Margin

                 

 

4. Working with Sheets

5. Formatting Data

6. Basic Data Manipulation

7. Working with data

8. Viewing and printing a document

 

Intermediate Level

1. Using Charts and graphs in Calc • Creating,Editing and Formatting Charts

            • Types of charts

            • Resizing and moving of charts

2. Images and graphics in Calc • Inserting images in Calc

            • Modifying images

3. Advanced Formatting and Protection • Cell Protection

            • Ranges

            • Validity

 

4. Formulas and Functions • Creating formulas,operator types and referencing

            • Basic arithmetic and statistic functions - relative and fixed ($) referencing in a function

            • Rounding off numbers

            • If..else

            • Important string functions (left, right, middle, concatenate)

 

5. Linking Calc Data • Referencing other sheets and documents

            • Working with Hyperlinks

 

 

Advanced Level

1. Auto-formatting cells and sheets • How auto-formatting is done

            • Defining a new auto-format

            • Using themes and Conditional formatting

            • Hiding and showing data

 

2. Sharing and Reviewing • Recording Changes

            • Adding comments to changes

            • Accepting/Rejecting changes

            • Header and footer

 

3. Macro in Calc • Using macro recorder

            • Writing own functions in macro

            • Editing a macro,playing a macro, deleting a macro

 

4. Working with Styles • Types of Styles

            • Modifying Styles

            • Creating new styles

 

5. Data manipulation • Convert text to columns

 

                • Convert columns to txt

                • Creating scenarios

                • Changing scenarios

                • Working with scenarios using navigator

                • Multiple operations in rows and columns

                • Data source

                • Data pilot dialog

                • Working with the results of data pilot.

                • Filters

 

 

6. Data Analysis

7. Data Pilot

                • How to select items in rows,columns and sheets.

                • Inserting and Deleting rows and columns Calc.

                • Inserting and Deleting Sheets in Calc.

                • Renaming Sheets.

                • Borders, Color, Formatting Text, Increasing Cell Size

                • Formatting multiple lines of text,numbers,fonts,cell borders,cell background

                • Automatic Wrapping and Using manual breaks

                • Merging cells, rows and columns, issues with using merge cells.

                • Shrinking text to fit the cell

                • Paste and paste special (values, transpose), pasting a spreadsheet into writer as a table

                • Introduction to Formulas – Sum, Average, basic formula (=a*b+c)

                • Subtotal

                • Different kinds of functions available in spreadsheet

                • Sorting by Columns

                • Filtering Data - Basics

                • Speed up using Fill tools and Selection lists.

                • Sharing content between sheets

                • Remove data,Replace data,Change part of a data.

                • Views options – Zoom option,Freezing and Splitting of screen, Page break view

                • Printing options and settings, header, footer

                • Print Margin

                 

 

4. Working with Sheets

5. Formatting Data

6. Basic Data Manipulation

7. Working with data

8. Viewing and printing a document

 

Intermediate Level

  • 1. Using Charts and graphs in Calc • Creating,Editing and Formatting Charts
  • • Types of charts
  • • Resizing and moving of charts
  •  
  • 2. Images and graphics in Calc • Inserting images in Calc
  • • Modifying images
  •  

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

            

                           DEV SANSKRITI COLLEGE OF EDUCATION & TECHNOLOGY

             Khapri, Dhamdha Road, Durg (C.G.),, Email – [email protected] Mobile: 982618962,

                                                          

                                                           SYLLABUS

                                                             YOGA

 

UNIT -1

Patanjali Yog Sutra

i) Definition and meaning of yoga.

ii) Types of vritties.

iii) Different ways to achieve Raj Yog.

iv) Disturbance inYogic Practices.

 

UNIT –II

 

Swatmaram Hatha Pradipika.

i) Asanas.

ii) Pranayama

iii) Kriyas.

iv) Nadanusandhan

 

UNIT –III

 

LIST OF YOGIC PRACTICES

ASANA PRANAYAMA KRIYA

 

1. Shirsh Asana 1. Anulome-vilome Any two Kirya from the

followings:-

2. Vipratakarani 2. Ujjai 1. Neti

3. Hal Asana 3. Bhastrika 2. Dhauthi

4. Bhujang Asana 4. Shitali 3. Tratak

5. Ardh-Shalbh Asana 5. Sitkari 4. Nauli

6. Vakra Asana 6. Suryabhedan 5. Kapalbhati

7. Ardha Matasyaendrasana 7. Bhramri

8. Paschimottan Asana

9. Vajra Asana

10. Supta Vajra Asana

11. Yoga Mudra

12. Nauka Asana

13. Bak Asana

14. Mayur Asana

15. Ustra Asana

16. Vriksh Asana

17. Padma Asana

18. Trikon Asana

19. Sarvang Asana

20. Manduk Asana

21. Pavan Muket

22. Chakra Asana

23. Pad-hast Asana

24. Katichakra Asana.

25. Surya Namaskar