T.Y.B.com question papers 2010 - Computer Systems and Applications

Wednesday, September 15, 2010

 T Y B com question paper of Mumbai University - April 2010

Computer Systems and Applications (Revised Syllabus)

Note: (1) All questions carry equal marks and are compulsory. (2) Attempt either Question No.4 on Visual Basic OR Question No.4 on C language. (3) From each question attempt any two sub questions i.e. a, b or a, c or b, c. (4) Figures to the right indicate maximum marks for a question.

Q. 1 A (I) State whether the following statements are true or false: Marks (4)

(1) In Data Communication the medium of transmission cannot be wireless.
(2) A single computer carries the entire task in distributed processing.
(3) An IP address contains a set of 4 numbers separated by dots.
(4) Dial-up connection provides fastest internet access.

(II) Answer the following in one or two lines:
(1) What is the use of a Switch in a network? (2) What is the full form of TCP/IP?
(3) What is an E-mail?
(4) Name any two Boolean search operators.

Q. 1 B Select the appropriate option from the following: Marks (4)

(1) A Network where individual computers or nodes share the processing and storage of data with the
    server is ------
    (a) Peer to Peer network     (b) Client Server based network
    (c) MTTP network     (d) None of these
(2) In  -----   topology all the nodes are connected with a single cable.
    (a) Bus     (b) Ring
    (c) Star     (d) None of these
(3) The protocol to fetch. E-mail from a remote mail-box into your computer is     _
    (a) POP     (b) SNTP
    (c) FTP     (d) HTTP
        (4) ____ allows user to search simultaneously on several search engines.
    (a) Server     (b) Meta Search Engine
    (c) Boolean Search     (d) None of these
(II) Give one difference between each of the following:
(1) LAN and MAN
(2) Bus and Ring Topologies

Q.1 (C) Marks(8)

(I) What is Domain Name System? What is its purpose?
(II) Explain any two wired transmission media.

Q.2 (A) (I) State whether the following statements are true or false: Marks (4)

(1) B2C refers to business selling goods to other business.
(2) Decryption means converting readable text into cipher text.
(3) In E-commerce Ubiquity refers to Universal Standards.
(4) On limitation of E-Commerce is lack of PC penetration.

(II) Answer in one line each of the following: Marks (4)

(1) What is the meaning of the term 'Portals' in E-Commerce?
(2) What is Encryption?
(3) What is the full form of P2P in E-Commerce?
(4) What is a Digital Signature?

(B) (I) Select the appropriate option from the following:  Marks (4)

(1) The Revenue model in E-Commerce where companies earn revenue by Publicizing product/services is called.
    (a) Sales Revenue     (b) Transaction Fee Revenue
    (c) Advertising Revenue     (d) Affiliate Revenue
(2) In E-commerce, to authenticate the sender of the message we use
    (a) Digital Signature     (b) Privacy Protocol
    (c) Digital Sending     (d) Digital Protocol
(3) It is a convention that all sites that use SSL connection while making a secure connection, use instead of HTTP.
(a) HTTPS (b) POP
(c) FTP (d) TCP/IP
(4) SSL stands for
(a) Single Socket Layer (b) Secure Sockets Layer
(c) Secure Standard Layer (d) Simple Sockets Layer.

(II) Give one difference between each of the following: Marks (4)

(1) B2C and C2C types of E-Commerce.
(2) Richness and Information density features of E-Commerce.
  
(C) (I) Explain Secure Electronic Transaction in E-Commerce.     Marks (4)
      (II) What are the limitations of E-Commerce?     Marks (4)

Q.(3) (A) (I) There exist a table called SALARY containing columns Employee number (ENO, Integer, Primary Key), Employee's name (ENAME, Character), gender (GENDER character, width 1) and BPA Y (basic pay, width 7 with two decimals).
(2) Write MySQL queries for the following:
(1) Display employees' number, gender and basic pay for all employees.
(2) Display employee number, employees' name, gender and 30% of basic pay as HRA for all employees.

(II) Explain the use of the MySQL functions: 
(1) LOWER ( )
(2) ABS ( )

(III) Write a MySQL statement to create a table named OFFICE containing information of the employees with the following columns,
Employee Number (EN, Integer, Primary key), Employee Name (ENAME, Character, variable width 20, should not be empty), gender (GENDER, Character, width 1, default value as "M") and date of joining (DOJ, Date).

(B) (I) There exists a table called WAGES containing columns Employee Id (EMP _10, Integer, primary key), Employee name (NAME, Character), Department name (DEPT, Character) and Basic pay (BASIC, width 7 with 2 decimal places).
Write MySQL statements for the following:
(1) Display Department name, number of employees in the department and total of the basic pay of the employees grouped departmentwise.     Marks (2)
(2) Display each department name & the minimum and maximum basic pay grouped departmentwise.

(II) There exists a table STUDENT, containing columns student's roll number (RNO, Integer, primary key), student's name (SNAME, Character), and date of birth (DOB, Date). There exists another table, EXAM containing columns roll number (RNO, primary key), class (CLASS, Character), total marks (TOT, Integer). Write MySQL statement to display the Roll number, Name, and total marks of the students whose total marks are 350 or more.  Marks (4)

(C) (I) There exists a table called EMP containing columns Employee name (ENAME, Character), date of birth (BOT, Date), address (ADDR, Character), Gender (GEN, Character) and Phone number (PHONE, integer)
Write MySQL statements for the following:  Marks (4)
(1) Display the structure of the table.
(2) Add a column called BONUS having width 7 with 2 decimals to the table.
(3) Rename the column BONUS as BON.
(4) Delete the table EMP.

(II) There exists a table called PAYEE containing columns Payee's identification (PAYEE_ID, Integer), Payee's name (NAME, Character) and Sales tax (STAX, width 7 with 2 decimal places). Write a MySQL sub query to display Payee's identification, Payee's name and Sales tax for those payees whose sales tax payment is above the average sales tax.     Marks (4)

Q. 4 (A) (I) State whether the following statements are true or false:     Marks (4)
(1) In Visual Basic a Form represents a Window.
(2) Visual Basic is a Procedural Language.
(3) Action associate with an object in Visual Basic is called its Method.
(4) The Visual Basic Project file is saved with extension .frm.

(II) (1) What is the purpose of the Tool Box in Visual Basic?
      (2) Name any two properties of the Text box in Visual Basic.

(B) (I) What is the difference between:
(1) Option Button and Check Box in Visual Basic.
(2) Combo Box and List Box in Visual Basic.

(II) Create a Visual Basic Project that will allow the user to enter a positive number and determine whether it is odd or even.   Marks (4)
  
(C) (I) What is the purpose of a Dialog Box Control in Visual Basic?    Marks (2)
      (II) Write a project to design a suitable foem to allow the conversion of currency from Indian Rupees to US dollars or Vice-Versa. The project should provide two option buttons asking the user to select either Indian Rupees to US dollar or US dollar to Indian Rupees. Allow the user to enter the amount and based on the selection convert the amount to the desired currency and display the result. Marks (6)

OR
Q.4 (A) (I) Give the difference between the following with reference to C Language:  Marks (4)
(1) scanf ( ) and gets ( ) 
(2) putchar ( ) and puts ( )

(II) Give the output of the following C-program?   Marks (4)
main ( )
(float a=-3517.276, b=48.99;
printf{"%+010.2f%-6.1f\n",a,b);
printf("%+08.1f%+-5.0f\n",a,b);}

(B) (I) Answer the following with reference to C Language:   Marks  (4)
(1) What is an escape sequence? Give an example.
(2) What are identifiers in C language? Give one example.
(II) Write a program in C Language to find and display the sum of 5 x 22 + 7 X 52 + 9 X 82 + ... + 23 X 29.2     Marks (4)

(C) (I) What is the difference between break and continue statement in C Language?  Marks (2)
      (II) Write a C program to input the invoice number (ino) and sales amount (sa) and print the invoice number, sales amount, Sales tax (st) and total amount (t) where the Sales tax is calculated on the sales as follows:    Marks (6)
    Sales              Sales Tax
    First 10,000          2%
    Next 25,000         4%
    Excess                5%

(5) (A) (I) Explain the terms Absolute cell reference and Relative cell reference in relation to Spreadsheets.    Marks (2)
    (II) Answer the following using Spreadsheet:    Marks (6)                
  






A
B
C
D
E
F
G
H
I
1
NAME
ENG
HIN
ECO
BK
A/C
TAX
AVERAGE
RESULT
2
GUPTA
76
63
78
66
86
68


3
SURI
54
49
48
52
46
59


4
KHAN
72
69
66
78
75
81


5
JUDE
87
73
84
82
91
93


6
MINAZ
54
49
28
31
17
21


    
For the above spreadsheet write the steps to obtain the average, as the average of the best five sUbjects for each student and the result which is "PASS" when this average is 50 or more otherwise "FAIL".

(B) (I) Explain the use of the following functions in Spreadsheets
(1) PMT ( )
(2) SUMIF ( )
(II) Answer the following using Spreadsheet:    Marks (6)
In a worksheet, Names are entered in column A and corresponding Basic Pay is entered in column B for 30 persons, the first row contains the heading and the rest of the rows contain data. Write the steps to obtain in column C, D and E the HRA, DA and Total Pay where HRA is @ 20% of basic payor Rs. 5,000 whichever is less, and DA is 25% of basic pay wherever basic pay is less than 5000 otherwise it is 40% of basic pay.

(C) (I)    What is the difference between Sort and Filter options with reference to spreadsheets?          (II) Answer the following with reference to spreadsheets:    Marks (6)
A spreadsheet contains Roll no. and marks out of 100 in 4 subjects entered in columns A, B, C, D, E respectively in first 26 rows. The first row contains headings and subsequent rows contain data. Write the steps to find average and grade in column F and G respectively where Grade is to be assigned as follows:
Average Grade
75 or more A
60 or more and below 75 B
Below 50 C

Humor and advice

Monday, June 21, 2010

LECTURE: An art of transmitting Information from the notes of the lecturer to the notes of students without passing through the minds of either


So always try to understand the subject and its practical use / applications in real life which makes you real Bachelor of Commerce. 

TYBcom Exam Timetable 2010 - TYBcom Revised Timetable

Tuesday, March 2, 2010



TYBcom revised time table in short .(timings - 11 to 2)

9/4/10               Fri                   Account-I
10/4/10             Sat                  Account-II
12/4/10             Mon               Account-III
13/4/10             Tue                 Taxation
15/4/10             Thur                Economics
16/4/10             Fri                   MPP
19/4/10             Mon                Computer
 
 Detailed Time table is as follows
 
TYBCom written examination will be conducted as per following timetable

 1. Friday, April 09, 2010                   11:00 a.m to 02:00 p.m.



Financial Accounting & Auditing : Paper III- Old
Financial Accounting & Auditing : Paper III- Rev

Economics  Paper III

Business Management : Paper III- Management Organisation Development (OLD)

Business Management : Paper III- Management Organisation Development (REV)

Commerce: Paper III- International Business Relations

Quantitative Techniques : Paper III - Mathematical Methods.

Banking  Finance : Paper III- Introduction to Banking in India.


2.Saturday, April 10, 2010                  11:00 a.m to 02:00 p.m.


Financial Accounting : Paper IV - Audition and Cost Accounting.(Old)

Financial Accounting Auditing : Paper IV - Audition and Cost Accounting.(Rev)

Economics - Paper IV

Business Management : Paper IV Financial Management (OLD)

Business Management : Paper IV Financial Management (REV)
Commerce : Paper IV Management of Service Industry

Quantitative Techniques : Paper IV Statistical Methods.

Banking Finance : Paper IV Introduction to Financial Services.


3.Monday, April 12, 2010                   11:00 a.m to 02:00 p.m.


Financial Accounting Auditing : Paper V - Management Accounting etc.(Old)

Financial Accounting Auditing : Paper V - Management Accounting etc.(Rev)

Economics - Paper V
Business Management : Paper V- Marketing Management (OLD)


4. Monday, April 12, 2010                     11:00 a.m. to 02:00 p.m.


Business Management: Paper V-Marketing Management (REV)

Commerce: Paper V-Commercial Administration

Quantitative Techniques: Paper V- Operations Research, Quality Control & Reliability


Banking Finance: Paper V- Finance of Foreign Trade and Foreign Exchange



5.Tuesday, April 13, 2010                 11:00 a.m. to 01:30 p.m.

Applied Component Group : Paper VI/VII

Direct and Indirect Taxes (Old)

Direct and Indirect Taxes (Rev)




6.Thursday, April 15, 2010                11:00 a.m. to 02:00 p.m.


Business Economics.: Paper III


7. Friday, April 16, 2010                       11:00 a.m. to 02:00 p.m.


Commerce : Paper III

Management and Production Planning.


8. Saturday, April 17, 2010                    11:00 a.m. to 01:30 p.m.


Applied Component Group : Paper VI/VII - Export Marketing


11:00 a.m. to 02:00 p.m.

Export Marketing


Vocational Subjects : Paper VI

Tourism and Travel Management - Emerging Concepts for Effective Tourism Development and Information,Communication and Automation (V)

Tax Procedures and Practice - Central Excise (V)

Advertising Sale Promotion & Sales Management-

Management of the Sales Force, Sales Promotion and Public Relations (V)

Computer Application Java Programming I , II

Foreign Trade Procedures and Practice

Shipping and Insurance  Foreign Trade Documentation (V)

Principles Practice of Insurance Property and Liability Insurance (V)


9. Monday, April 19, 2010                    11:00 a.m. to 01:30 p.m.


Applied Component Group : Paper VI/VII Business Insurance


11:00 a.m. to 02:00 p.m.


Computer Systems and Applications(Old)

Computer Systems and Applications(Rev)

Literature in English


10 Tuesday, April 20, 2010                    11:00 a.m. to 01:30 p.m.


Applied Component Group : Paper VI/VII - Labour Welfare Practice


11:00 a.m. to 02:00 p.m.

Labour Welfare Practice


Psychology of Human Behaviour at work


11. Tuesday, April 20, 2010                11:00a.m. to 02:00 p.m.


Vocational Subjects : Paper VII- Tourism and Travel Management Entrepreneurship

Development, Case Studies and Problems etc (VI)

Tax Procedures and Practice Entrepreneurship, Central Excise, Problem etc. (VI)

Advertising Sales Promotion and Sales Management Entrepreneurship Development,Case Studies etc (VI)


Computer Application E-Commerce/ Entrepreneurship Development

Foreign Trade Procedures and Practice- Entrepreneurship, Case Studies etc. (VI)

Principles and Practice of Insurance Entrepreneurship and Group Insurance and Retirement Benefit Scheme (VI)



12. Wednesday, April 21, 2010             11:00 a.m. to 01:30 p.m.


Applied Component Group : Paper VI/VII - Marketing Research


11:00 a.m. to 02:00 p.m.
Marketing Research



13. Thursday, April 22, 2010               11:00 a.m. to 01:30 p.m.


Applied Component Group : Paper VI/VII-Inventory Management and Cost Reduction Techniques

11:00 a.m. to 02:00 p.m.

Inventory Management and Cost Reduction Techniques


11:00 a.m. to 01:30 p.m.

Trade Unionism and Industrial Relations


11:00 a.m. to 01:30 p.m.

Investment Analysis Portfolio Management


11:00 a.m. to 02:00 p.m.

Investment Analysis Portfolio Management


11:00 a.m. to 01:30 p.m.

International Marketing


11:00 a.m. to 02:00 p.m.

International Marketing


11:00 a.m. to 01:30 p.m.

Regional Planning


11:00 a.m. to 02:00 p.m.

Regional Planning

11:00 a.m. to 02:00 p.m.
Literature in Hindi
Literature in Gujarati

Literature in Gujarat

Literature in French

Literature in German

Literature in Sindhi



14. Friday, April 23, 2010                   11:00 a.m. to 01:30 p.m.


Applied Component Group : Paper VI/VII - Banking Law  Practice


11:00 a.m. to 02:00 p.m.

Banking Law Practice


11:00 a.m. to 01:30 p.m.

Purchasing and Store Keeping


11:00 a.m. to 02:00 p.m.

Purchasing and Store Keeping


11:00 a.m. to 01:30 p.m.

Rural Marketing



Learn C programming - Addition of two numbers

Tuesday, February 16, 2010

Let us study a simple C program to add two numbers , input from keyboard and print the sum.


#include <stdio.h>
#include <conio.h>

void main ( )
{ int a, b, sum;
clrscr( );
printf ("Enter two integer numbers");
scanf ("%d%d,&a,&b);
sum=a+b;
printf("\n The sum of two numbers is %d\n",sum);
getch( );
}

The first two lines with #include are called pre processor directives which loads two function libraries in memory. Because of which we can use functions like clrscr, printf , scanf in our program.

Third line is main function , which is must in any C program. void means the function will not return any value. If we do not write void , we have to add one line return (0) at the end of the program. Because in C every function must return a value.

Fourth line is declaration of variables a,b and 'sum' as integers. In C we must declare type of the variable before we can use it .

Fifth line is clear screen function which clears the previous screen i.e. any previous output on the screen is cleared .

Printf in sixth line displays message on screen to enter two numbers

Scanf in seventh line accepts two numbers from keyboard and assign these to variables a , b

The eighth line adds two variables a and b and assigns it value to variable 'sum'

Ninth line prints the value of sum on screen . The printf statement here uses format specifier %d here , we will study about this later.

The getch in tenth line holds the output screen till we press a key.

From the above program we can say that a general program in C will have

#include lines to include necessary library functions

void main ( )

Declaration and initialization of the variables required in the program

Data input statements

Processing or logic statements generating desired output

Statement to display output.

Please note that the all C keywords in program has to be in lower case because C is case sensitive language and any capital letter for commands/keywords gives error.

TYBcom time table 2010

Thursday, February 11, 2010

TYBcom Exam timetable has been revised and exams are starting from April 9, 2010
Please click here for new TYBcom Exam Timetable 2010


TYBcom exam time table for academic year 2009 - 2010 for Mumbai University ( Old X)

Thu, Apr 01, 2010 Account 1 - Financial Accounting
Business Management I - Management and Organization Development


Sat, Apr 03, 2010 Accounts 2 - Auditing and Cost Accounting
Business Management II - Financial Management


Mon, Apr 05, 2010 Accounts 3 - Management Accounting Etc. (Rev.)
Business Management III - Marketing Management

Tue, Apr 06, 2010 Direct and Indirect Taxation


Wed, Apr 07, 2010 Business Economics


Thu, Apr 08, 2010 MPP (Management and Production Planning)


Fri, Apr 09, 2010 Export Marketing


Sat, Apr 10, 2010 Computer Systems and Applications


Mon, Apr 12, 2010 Psychology of Human Behaviour at work


Tue, Apr 13, 2010 Marketing Research


Thu, Apr 15, 2010 International Marketing
Investment Analysis Portfolio Management


Fri, Apr 16, 2010 Rural Marketing


Sat, Apr 17, 2010 Entrepreneurship and M.S.S.I


Mon, Apr 19, 2010 Elements of Operation Research


Visit blogadda.com to discover Indian blogs

TYBCom Computer Syllabus - 2009-10

Friday, February 5, 2010

T.Y.B.Com Syllabus for Computer Systems and Applications from 2009 -2010

Unit I Data Communication , Networking and Internet

(a) Data Communications Components, Data representation, Distributed processing, ( Concepts only)

(b) Network Basics and Infrastructure
i. Definition, Types (LAN,MAN,WAN) Advantages,
II. Network Structures - Server Based, Client server, Peer to Peer.
III. Topologies - Star, Bus, Ring.
IV. Network Media, Wired and Wireless
v. Network Hardware: Hubs, Bridges, Switches, Routers
vi. Network Protocols - TCP/IP, OSI Model

(c) Internet
I Definition , Types of connections, Sharing internet connection,
II Services on r:et- WWW, Email- Blogs,
III IP addresses, Domain names, URLs.
IV Searching Directories, Search engines, Boolean search (AND, OR,NOT), Advanced search, Meta Search engines.
V Email-POP/SMTP accounts in Email, Different parts of an Email address. Receiving and sending emails with attachments by scanning attachments for viruses.

Unit II E-Commerce (18 lectures)

a) Definition of E-commerce
b) Features of E-commerce
c) Types of E-commerce (B2C,B2B,C2C,P2P)
d) Business Models in E-Commerce (Advertising, Subscription, Transaction Fee, Sales Revenue, Affiliate Revenue )
e) Major B2C models ( Portal, Etailer, Content Provider, Transaction Broker, Market Creator, Service provider, Community provider.
f) E-Commerce Security: Integrity, Non repudiation, Authenticity, Confidentiality, Privacy Availability.
g) Encryption; Definition, Digital signatures, SSL.
h) Payment Systems: Digital Cash, Online stored value, digital accumulating balance payment, Digital credit accounts, digital checking.
i) How an Online credit card transaction works. SET protocol.
j) Limitations of E-commerce.
k) M-commerce ( Definition and Features)

UNIT III - Database and SQL (18 lectures) (6 practicals)

l) Introduction to Databases, Relational and Non relational database systems.SQL as a Non-procedural Language. Views of data.

2) SQL Basics: statements ( Schema Statements, Data statements, Transaction statements , names (table & column names), data types (Char, Varchar, Text, Mediumtext, Longtext, Smallint, Bigint, Boolean, Decimal, Float, Double, Date, DateTime, TimeStamp, Year, Time,Creating datatabase,Inserting data,Updating data, Deleting data,expressions,built in
functions,missing data (NULL and NOT NULL,DEFAULT values),CREATE,USE,ALTER (Add,Remove,Change columns),RENAME, SHOW,DESCRIBE (CREATE TABLE,COLUMNS,STATUS and DATABASES only) and DROP (TABLE,COLUMN, DATABASES statments), PRIMARY KEY,FOREIGN KEY (One and more columns) , Simple Validity checking using CONSTRAINTS

3)Simple queries: The SELECT statement (From, Where, Group By, Having, Order B, Distinct, Filtering Data by using conditions. Simple and complex conditions using logical, arithmetic and relational operators (=, !=, <;>, <>, AND,OR, NOT, LIKE, BETWEEN )

4) Multi-table queries: Simple joins ( INNER JOIN), SQL considerations for multi table queries (table aliases, qualified column names, all column selections, self joins).

5) Nested Queries (Only upto two levels) : using sub queries, sub query search conditions, sub queries & joins, nested sub queries, correlated sub queries, sub queries in the HAVING clause.

Simple Transaction illustrating START,COMMIT, and ROLLBACK.

UNIT IV Introduction to C Programming (18 lectures) (6 practicals)

1) Introduction :
C character set
Reserved words
Identifiers
C data types
C type modifiers
Constants
Variables
Expressions
Operators (Unary , Binary, Relational, Logical)
C assignment statements
Operator Precedence
Concept of header files (stdio.h, math.h, conio.h only)

2) Simple programming concepts :
Form of a C program, printf() (%d,%f,%c,%s,%lf,%ld), scanf(), gets(), getchar(), puts(), putchar(), getch(), putch(), pow(), sqr(), clrscr(), storage class specifiers , Preprocessor directive #include<>


3) Control Statements:
If else , for, while , do while , switch , break , continue .

4) Arrays :
Concept of one dimensional array (character and integer ) , sorting of numbers , printing array of numbers.


OR

Unit IV Visual Basic (18 Lectures) (6 practicals)

a) Introduction to Visual Basic, Introduction Graphical User Interface (GUI) , Programming Language (procedural, Object Oriented, Event Driven), Writing VB projects, The Visual Basic Environment, Finding and fixing errors [Chapter 1 of 19]

b) Introduction to VB Controls: Textboxes, Frames, Check Boxes, Option Buttons, Images, Setting a Border & Styles, The Shape Control, The line Control, Working with multiple controls and their properties, Designing the User Interface, Keyboard access keys, Default &. Cancel property, tab order, Coding for controls using Text, Caption, Value propelty and SetFocus method [Chapter 2 of 19]

c) Variables, Constants, and Calculations
Variable and Constant, Data Types (Boolean, Byte, String, Integer, Currency, Single, Double, Date), Naming rules/conventions, Constants (Named & intrinsic), Declaring variables, Scope ofvariabies, Val Function; Arithmetic Operations, Formatting Data. [Chapter 3 of 19]

d) Decision and Condition
Condition, Comparing numeric variables and constants, Comparing Strings, Comparing Text property of text box, Compound Conditions (And, Or, Not)
If Statement, If .then-else Statement, Nested If Statements, LCase and UCase function, Using If statements with Option Buttons & Check Boxes
MsgBox (Message Box) statement Input Validation: IsNumeric function.
Planning the project. [Chapter 4 of 19]

e) Menus, Sub-Procedures and Sub-functions, Defining / Creating and Modifying a Menu, Using common dialog box, Creating a new sub-procedure, Passing Variables to Procedures, Passing Argument ByVal or ByRef, Writing a Function Procedure
[Chapter 5 of 19]

f) Lists, Loops and Printing
LisfBoxes and Combo Boxes
Do/ Loops, For/Next loops
Functions: MsgBox with multiple buttons, Strings
Sending information to the printer using Printer.Print, Printer.NewPage, Printer.EndDoc methods. [Chapter 7 of 19]


Unit V Spreadsheet (18 lectures) ( 6 practicals)

a) Creating and Navigating worksheets and adding information to worksheets

i. Types of data, entering different types of data such as texts, numbers, dates,functions.

ii. Quick ways to add data Auto complete, Autocorrect, Auto fill, Auto fit. Undo an Redo.

iii. Moving data, contiguous and non contiguous selections. Selecting with keyboard.
Cut-Copy Paste. Adding and moving columns or rows. Inserting columns and rows.

iv. Find and replace values. Spell check.

v. Formatting Cells, Numbers, dates, times, Font, Colors, borders, fills.

b) Multiple spreadsheets
I. Creating and Using templates
II. Creating and Linking Multiple Spreadsheets.
III. Adding, removing, hiding and renaming worksheets.
IV. Add headers /Footers to a Workbook. Page breaks, previews.
V. Creating formulas, inserting functions, cell references, Absolute, Relative ( within a worksheet, other worksheets and other workbooks), logical operators.
VI. Creating and using named ranges

c) Functions
i. Financial functions: FV ,PV ,PMT,PPMT,IPMT,NPER,RATE,NPV,IRR
ii. Database Functions LOOKUP,VLOOKUP,HLOOKUP
iii Conditional Logic functions.IF,COUNTIF,SUMIF
iv. Mathematical and statistical functions.
ROUND,ROUNDDOWN,ROUNDUP,CEILING ,FLOOR,INT,MAX,MIN,MOD,SQRT,
v. ABS,AVERAGE
vi. String functions LEFT,RIGHT,MID,LEN,UPPER,LOWER,PROPER,TRIM,
vii. Date functions.
TODAY,NOW,DATE,TIME,DAY,MONTH,YEAR, WEEKDAY,DAYS360

d) Data Analysis
i. Sorting, filter with customized condition, subtotal
ii. The Graphical representation of data
iii. Pivot Tables - Building Pivot Tables, Pivot Table regions, Rearranging Pivot Table.

Difference between Getchar( ),Getch( ) ,Getche( )

Sunday, January 31, 2010

What is difference between Getchar( ) , Getch ( ) , Getche ( ) ?

Getchar ( ) - It will accept a character from keyboard , displays immediately while typing and we need to press Enter key for proceeding.

Getch ( ) - It just accepts a keystroke and never displays it and proceeds further. Normally we use it at the end of the main ( ).

Getche ( ) - It will accept a character from keyboard , displays it immediately and does not wait for Enter key to be pressed for proceeding.

C character set, Keywords, Identifiers

C character set :-
The valid characters for C are alphabets ( A-Z, a-z) , numbers (0 - 9) and special symbols .

Reserved words ( Keywords) :-
Keywords are the words whose meaning has already been known to the C compiler. They are also called instructions. e.g. int , return
They are reserved words and can not be used as variable names.
There are 32 keywords available in C.

Identifiers
:-
Identifiers are the names you supply for variable types, functions and labels in your program.You can not use keywords as identifiers.

What is programming ?

Saturday, January 30, 2010

Let us first understand what is programming .

A program is a steps taken to perform a task or job.

A real life example will be we program our selves to come from home to college.

We have planning in our mind as when we will get up , then in how much time we will get ready, then at what time we should catch bus or train etc. We have a order of sequence for the steps we perform

i.e. we do not sit in the bus and then start brushing our teeth.

Now let us take example of addition of two numbers 22 and 33 with help of a calculator.

Our steps or program will be as follows

1. Enter 22
2. Press '+' key
3. Enter 33
4. Press '=' key
5. See the result on screen.

Similarly we can write logical steps to perform a task in computer language and execute it to get the desired result.

It will be important to understand that logical steps to perform a task remains same even if computer language changes . The only thing changes from language to language is there commands and syntax.