Global College of Vocational Training
Syllabus
Certificate Course in Architectural Draughtsman
Course Code 304401
 Duration : 2 Years Full Time
 Entry Qualification : S.S.C. Pass
BACK
Elective –II
Computer Applications– 1st Year
(Subject Code – 90000022)
Detailed Syllabus :
 1.0. Introduction
1.1. Basic Computer and its structural theory
1.2. Input devices
1.3. Output devices
1.4. Storage devices
1.5. Computer types and their applications
1.6. Computer Software/Hardware
Practical  Detailed Syllabus
1.0. Computer basics
1.1. Identification of Keyboard, Printer, Monitor Scanner, Webcam, Microphone, Speaker
1.2. Sample collection of various type of storage devices, specifications and charts

2.0. Operating systems
2.1. Various types of Operating systems
2.2. Comparison between the different types of OS
2.3. Network Operating systems and their features
2.4. Microsoft Disk Operating System, its nature and history.
2.5. Unix, features, merits and demerits in using Unix as OS.
2.6. Microsoft Windows, development & growth of MS Windows, features, merits and demerits of MS
Windows.
2.7. MS Windows NT, features, merits & demerits
2.8. System requirements for various Operating Systems
2.9. Windows default icons and their applications
Practical
2.1. Practice of MS DOS commands
2.2. Installation of MS Windows
2.3. Practice on Add/Remove programs
2.4. Practice on My computer, Display properties, My documents, My Network places

3.0. Microsoft Word
3.1. Introduction to MS Office
3.2. MS Word applications
3.3 Creation of Document and file operations
3.4. Formatting features of document
3.5. Modification/ editing documents
3.6. Inserting images, files, tables, symbols and various attributes
3.7. Creating and formatting of tables
3.8. Mail merge
3.9. Page layout and design features
3.10. Spell & grammar check in documents
3.10. Print preview & printing of documents
3.11. Converting documents to PDF files.
Practical
3.0. Documentation
3.1. Create and save a document
3.2. Format the text with different font size,font styles
3.3. Setting up different page sizes,orientation.
3.4. Making various type of documents like Bio Data, letters, project reports
3.5. Printing of documents

4.0. Microsoft Excel
4.1. Introduction to Excel and its applications
4.2. Features of MS Excel
4.3. Outline of Worksheet & Workbook
4.4. Data types
4.5. Study of various menus of MS Excel
4.6. Creation of worksheet, editing worksheets, save,copy & deleting worksheets.
4.7. Functions of MS Excel
4.8. Formulas of MS Excel.
4.9. Types of charts, creation of data Charts, editing and insertion of charts.
4.10. Sort facility
4.11. Interconnecting Charts
4.12. Page setup, printing worksheets, charts… etc.
4.13. Converting Worksheets to PDF files.
Practical
4.0. Practice of Worksheets
4.1. Create and save worksheets
4.2. Editing the worksheets
4.3. Formatting worksheets
4.4. Insert charts
4.5. Making worksheets using formulas & functions
4.6. Making worksheets & printing with different formatting effects
4.7. Making worksheets with images, numbers and print them

5.0. MS Power point
5.1. General Introduction
5.2. Features & Applications of MS Power point
5.3. Creating Presentations
5.4. Study of different layouts and making presentations using different layouts
5.5. Using different animation effects.
5.6. Add Audio/Voice and visual effects to slides.
5.5. Filtration
5.6. Converting presentations to PDF files.
5.7. Inserting images, symbols to slides
Practical
5.0. Power Point practice
5.1. Create Slides of different types
5.2. Running presentations
5.3. Add slide transition effects and run slide show
5.4. Make presentations with audio/visual effects.
5.5. Printing PPT files
5.6. Making PDF format of PPT files

6.0. Networking & Internet Utilities
6.1. General Introduction of Computer Networking
6.2. Requirements/ Applications of Computer Networking
6.3. Layouts of Different Networks
6.4. Study of various Networking components
6.5. Limitations and merits of different topologies
6.6. Study of Server/client concept
6.7. Internet & its applications
6.8. Email and Chatting
6.9. Etrading concepts
6.10. Downloading files (Text and media files)
Practical
6.0. Networking practice
6.1. Identifying different network components
6.2. Collecting samples, charts, images of different networking components.
6.3. Installation of Network Interface card
6.4. Getting connected to Internet and accessing the internet
6.5. Creating personalized Email account
6.6. Chatting (Text and Voice chat)
6.7. Searching/surfing for the information in different sites.
6.8. Downloading

7.0. Project work
7.1. Understand the concept of making projects and preparing the project reports.
7.2. Preparation of a project using the software skills learned during the course.
Practical
7.0. Project Work
7.1. Making a working model/project using MS Excel/Power Point
7.2. Project Report
Elective –II  Computer Applications– 2nd year
(Subject Code – 90000022)
Theory / Practical
Detailed Syllabus :

1.0. Introduction MS Access
1.1. Objects of learning MS Access
1.2. Applications of MS Access
1.3. Database and Database Management System
1.4. Elements of Database Management System
1.5. Types of Data Bases & the merits & demerits
Practical
1.0. Study of overview of MS Access
1.1. Accessing MS Access and its menus to get familiar with it

2.0. Controlling Data Entry
2.1. Restrict Data Entry using field properties
2.2. Establish a pattern for entering field values
2.3. Create a list of values for a field
Practical
2.0. Creating Data Tables,Designing Fields and setting field properties

3.0. Joining Tables and creating Queries
3.1. Create Query joins
3.2. Join unrelated tables
3.3. Relate data within a table
3.4. Set Select Query properties
3.5. Create Parameter Queries
3.6. Create Action Queries
Practical
3.0. Creating Queries

4.0. Forms & Reports
4.1. Design a Form Layout
4.2. Enhance the appearance of a Form
4.3. Restrict Data entry in forms
4.4. Adding a command button to a Form
4.5. Create a Subform
4.6. Organize report information
4.7. Format the report
4.8. Set Report Control properties
4.9. Control Report pagination
4.10. Summarize Report information
4.11. Add a sub report to an existing report
4.12. Create a mailing label report
Practical
4.0. Practicing Forms and Reports
4.1. Creating different forms using different layouts
4.2. Data entry in to the forms
4.3. Creating different Reports using different layouts
4.4. Data formatting in to reports

5.0. Sharing data across applications
5.1. Import data in to Access
5.2. Export data from Access
5.3. Analyze Access data in Excel
5.4. Export Access data to a Text file
5.5. Merge Access data with a Word document
Practical
5.0. Practice:
5.1. Import Excel sheets in to Access
5.2. Import Tables in to Access
5.3. Export Access tables in to Excelformat
5.4 Export Access data to a Text file
5.5. Merging data

6.0. Study of Application packages
6.1. Introduction to application oriented software packages
6.2. Study of Railway reservation Package
6.3. Study of different modules and menus available in online Railway Reservation Package
6.4. Study of Banking packages
6.5. Study of Library Management packages
6.6. Study of Inventory control packages
6.7. Study of School Management Packages
Practical
6.0. Practice
6.1. Collection of different trial packages
6.2. Visiting Organizations to collect different formats and procedures used in the system
6.3. Creating forms and Reports for the different packages using appropriate data bases

7.0. Project work
7.1. Understand the concept of making projects and preparing the project reports.
7.2. Visiting different organizations to have an idea of different packages
7.3. Preparation of a project using the software skills learned during the course.
Practical
7.0. Project Work
7.1. Making a working model/project using MS Access
7.2. Project Report
Elective – II  Business Mathematics – 1st year
(Subject Code – 90000023)
Theory /Practical
Detailed Syllabus:

1.0. Logarithms
1.1. Introduction to logarithms
1.2. Laws of logarithm, characteristics and mantissa Practice:
1. At least 5 to 10 exercises per chapter
2. One home/class assignment per chapter

2.0. Sets, Relations and functions
2.1. Study of Relation, Function
2.2. Types of functions
2.3. Domain, Co – domain, Range of a function
2.4. Composite and Inverse functions
2.5. Graphs of functions

3.0. Complex Numbers
3.1. Definition of complex numbers
3.2. Line

4.0 Quadratic Equations
4.1 Nature of roots of Quadratic Equation
4.2 Sum and Product of roots of quadratic equations
4.3 Formation of Quadratic Equations
4.4 Symmetric functions of roots
4.5 Cubs roots unity

5.0. Determinants
5.1 Determinant of order three
5.2 Applications of Determinants

6.0. Trigonometric ratios
1.1. Angles & its measurements
1.2. Trigonometric ratios
1.3. Relation between degree and radian.
1.4. Fundamental identities.
1.5. Examples based on Fundamental Identities
1.6. Trigonometric ratios of sum and difference of two angles
1.7. Factorization formulae
1.8. Inverse trigonometric functions
1.9. Properties of a Triangle

7.0. Plane Coordinate Geometry
7.1. Locus
7.2. Line

8.0 Partition values and measure of dispersion
8.1 Partition values
8.2 Measures of Dispersion

9.0. Moments Skewness Kurtosis
9.1 Moments
9.2. Skewness
9.3 Kurtosis

10.0. Bivariate frequency distribution and correlation
10.1.Bivariate frequency distribution
10.2 Bivariate Correlation
10.3 Rank correlation

11.0. Permutations and Combinations
11.1 Factorial notation
11.2 Principle of counting
11.3 Permutations
11.4 Combinations

12.0. Probability
12.1 Types of Event
12.2 Addition Theorem
12.3 Conditional Probability

13.0. Random Variable and Probability Distribution
13.1 Definition and Types of Random variable
13.2 Probability Distribution of random variable
13.4. Risk and uncertainty

14.0. Commercial Arithmetic
14.1 Commission Brokerage
14.2 Discount
14.3 Insurance
Elective – II  Business Mathematics – 2nd Year
(Subject Code – 90000023)
Theory/ Practical
1.Mathematical Logic
1.1 Statements and logical connectives
1.2 Statement pattern and logical equivalence
1.3 Venn Diagram
2. Matrices
2.1 Definition and Types matrices
2.2 Algebra Matrices
2.3 Inverse of a Matrix
2.4 Solution of Equations
3. Limit and Continuity
3.1 Definition
3.2 Algebra of limits
3.3 Application of Standard limits
3.4 Continuity of a function at a point
4. Differentiation
4.1 definition of Derivative
4.2 Derivative from first principles
4.3 Rules of Differentiation
4.4 Derivative of composite functions
4.5Derivative of Inverse functions
4.6 Logarithmic Differentiate
4.7 Derivates of Implicit functions
4.8 Derivatives of Parametric functions.
4.9 Second order derivatives
5. Application of Derivatives
5.1 Increasing and Decreasing functions
5.2 maxima and Minima
5.3 Approximation and Error
6. Integration
6.1 Definition of an integral
6.2 Integral of standard functions
6.3 Rules of Integration
6.4 Methods of Integrations Integration by parts
6.5 Definite Integrals
7. Differential Equations
7.1 Definition
7.2 Formation of Differential Equations
7.3 Solution of first order and first degree differential equations
7.4 Applications of Differential equations
1.Theory of Attributes
1.1 Introduction Notation and class frequencies
1.2 Consistency of data
1.3 independence of Attributes
1.4 Association of Attributes
8. Regression Analysis
8.1 Introduction
8.2. Data and information
8.3. Tabulation of data
8.4. Graphs and diagrams, scatter diagrams, histograms, bar charts…etc
8.5 Equation of lines of regression
8.6 Regression coefficient and its properties
9. Numerical Methods
9.1 Finite differences
9.2 Interpolation with equal intervals
9.3 Interpolation with unequal intervals
9.4 Numerical integration
10. Discrete Probability Distribution
10.1 Binomial Theorem
10.2 Binomial Distribution
10.3 Poisson Distribution
11. Management Mathematics
11.1 linear programming problem
11.2 Assignment problem
11.3 Sequencing
12. Demography
12.1 Introduction, definition, Uses of vital statistics
12.2 Measurements of Mortality
12.3 Life tables
13. Index Number
13.1 Introduction
13.2 Definition and Notations of index numbers
13.3 Types of index number
13.4 Construction of index number
13.5 cost of living index number
13.6 Uses of cost of living index number
14.0. Spread sheets
14.1. Introduction to spread sheets
14.2. Features and functions of spread sheet softwares
14.3. Use and limitations of spread sheet softwares in business
14.4. Apply spread sheet software to the manual work of chartered management accountant.
Practice:
1. Using spread sheet package
2. Entering data in to Spread sheet
3. Making graphs the selected data using Spread sheet packages
4. Using functions and formulas
5. Making accounts using Spread sheet packages