Home
Back
OR
Objective
: The first objective of the
course is to familiarize students with the innovation in information
technology and how it affects business. An understanding of the ground rules
of this technology will enable the students to appreciate the practical
details of E-commerce. The second
objective of this course is to provide an understanding of computers and
application of relevant software in management decision making.
Unit
- 1 Introduction of Excel 2000 (Getting started with Excel) : [1]
What is an electronic worksheet and its advantages [2] Starting excel and the
excel screen. [3] Entering value, text and formula, - Advantages of using
formula. [4] Saving a worksheet [5] Concept of cell, range, worksheet and work
book. [6] Changing column width for column and range of column. [7] Closing a
workbook file. [8] Creating a new workbook and Opening and existing workbook.
[9] Moving and copying data. [10] Doing and undoing action. [11] Inserting
column and row in worksheet. [12] Deleting column and row in worksheet. [13]
Getting help. [14] Formatting a worksheet, formatting numbers and other
numeric formats. [15] Drawing a border around cells. [16] Printing the
worksheet, Setting up pages and margins. [17] Defining header and footer.
Unit
- 2 Advanced features of Excel 2000 : [1]
Advanced print options. [2] Creating charts. [3] Using data and time [4]
Addressing mode. [5] Naming range. [6] Multiple worksheets in a workbook. [7]
Functions. - Average, Count, Max, Min, Stdev, Var. - Sum, Abs, Int, Log, Mod,
Rand, Round, Sqrt, Autosum. - FP and PV.- IF.
Unit
- 3 Database in a worksheet : [1]
Creating a database. [2] Sorting a database. [3] Maintaining a database. [4]
Querying the database. [5] Using Auto filter and advanced filter. [6] Copying
records to another location. [7] Using subtotals and grant total. [8] Using
database function. - DMAX, DAVERAGE, DCOUNT, DMAX, DMIN, DSTDEV, DSUM, DVAR.
Unit
- 4 Introduction to accounting packages : [1]
Starting tally 5.4. [2] Creating a company and Opening an existing company.
[3] Company features. [4] Group creation and Multiple group. [5] Single
Ledgers and Multiple ledgers. [6] Voucher entry purchase entry, sales entry,
receipt entry, payment entry, journal entry. [7] Financial statement. Basic
Textbook : 1. Personal
computer, windows 98 and Microsoft office 2000. Antani Hemag and Shah Keur,
TMH. Reference Books : 1. PC software for windows 98 made simple,
Taxali R.K. TMH. 2. Microsoft office 2000 8 in 1, Joe Habraken, PHI. 3.
Mastering Microsoft office 2000, D.P.Nagpal, wheeler publishing.
Objective
: To provide elementary exposure to a popular computer language and concept
of programming.
Unit
- 1 Introduction to programming : Concepts & design : [1]
Programming language. [2] The program development cycle. - Program design : -
Modular programming. - Pseudopodia. - Flowcharts. - Looping & Control
structure in flowcharts. [3] Coding and documenting a program. [4] Testing a
program. [5] Concept of GUI and event-driven programming. [6] Concept of Object
oriented programming.
Unit
- 2 An overview of C language : [1]
History of C language. [2] Structure of a C program. [3] The C character set.
[4] Data types. [5] Constant & Variables. [6] C keywords. [7] Type
modifiers. [8] Storage classes specifies. [9] Operators, expressions and
assignment statement. [10] Conversion specification. [11] Console I/O functions.
- Getchar (), putchar (), gets (), puts (), scanf (), pointf (). [12] Escape
sequences.
Unit
- 3 Control statement : [1] The
if statement [2] Nested if [3] Switch [4] Loop for loop. - The For loop - The
while loop - Do while loop - The break and continue statement. - The exit
statement - The go to statements
Unit
- 4 Arrays and functions : [A]
Arrays : [1] Single dimensional arrays. [2] Declaration, accessing, entering
data and reading data from an array. [3] Array initialization. [4] Array
elements in memory [5] Bounds checking. [6] Strings. [7] Two dimensional arrays.
- Initializing a two dimensional array. - Memory map of a dimensional array. [8]
Multi dimensional arrays. [B]
Functions : [1] General from of a function. [2] Why use functions. [3]
Functions with arguments. [4] Functions declarations and prototypes. - Call by
value - Call by reference [5] Scope rules of functions [6] Calling functions
with arrays. [7] argc and argv - arguments to main () [8] Concepts of library
functions - string functions.
Unit
- 5 Pointers : [1] The & and
* operators [2] Pointer assignments [3] Pointer arithmetic [4] Pointer
comparison [5] Dynamic memory allocation [6] Pointer v/s arrays. [7] Pointers to
pointers [8] Pointers to functions [9] Arrays of pointers. Unit
- 6 Structure, Union and File : [1]
Use & Basic of structure [2] Declaring a structure [3] Accessing structure
element [4] Structure & Function [5] Array of structure [6] Structure &
pointer [7] Use & basic unions [8] File handling in C unformatted &
formatted.
Basic
Textbooks : 1. Working with C,
Yashawant kanitkar, BPB.
Reference
Books : 1. C Programming, E
Balaguruswamy, TMH. 2. The spirit of 'C', Mulish cooper, Jaico publishing house.
3. C Programming with problem solving, Jones & Harrow, Dreamtech.
WEF
:
June 2002
( Proposed Syllabus of Vocational Computer Application(VCA) – S.Y.B.COM
. )
Topic :- Database Management System (DBMS) (FoxPro For Windows 2.6)
·
What Is Database And
DBMS? ·
Various Application For
DBMS
·
Introduction To FoxPro 2.6
·
Data And
Information
·
Field Record And
File
·
Various Field Available In FoxPro 2.6
·
Basic FoxPro
Command
·
Creating Database File And Adding Records In File
·
Modify Structure Of Database File ·
Searching Particular Record / Set Of Records
·
Replacing Field
Values
·
Editing / Deleting Records
·
Indexing And
Sorting
·
Labels And
Reports
·
Memory Variables
·
Operators
Logical
(And , Or ,
Not)
Relational ( = , > ,<
,Etc)
Arithmetic ( + ,- ,* Etc)
·
Functions
Database
Logical
Numeric
String
Date Conversion
·
Set Commands
Set
Alternate Set Ansi
Set
Bell Set
Carry
Set Confirm Set
Date Set Heading
Set Decimal
Set
Talk
Set
Deleted Set Device Set
Echo
Set Exact Set Clock
Set Index
Set
Printer
Set
Relation Set
Safety
Set Status Set
Fix Set
Century
Financial
Accounting System (FAS) (Tally 5.4)
·
What Is FAS?
·
Utility And Advantages Of FAS
·
Books Of Accounting
Cash Book
Journal
General
Ledger
Profit & Loss Account Balance
Sheet
·
Classification Of Account
·
Rules For Debit & Credit
suspe0