28
HOMEWORK SET – 2
Introduction to Visual Basic Programming
1.
Write a visual basic program that has two buttons, one named “C to F” and the other named “F
to C”. The program will read the temperature from cell A1 (entered either in Centigrade or
Fahrenheit). When you press the appropriate button, the final answer will be displayed in A2.
Use this formula for the “C to F” button:
F = 1.8C+32.
2.
Identify the type of variables and develop Visual basic syntax to declare and initialize the
variables from some cells in column A and output them back into cells in column B.
The
variables to be declared are: Name, city, age, weight, height, no_of_kids, no_of_cars_owned.
The values are: John, Washington D C, 30, 176.8, 6.1, 8, 5. Example:
Dim Name as String
Name = cells (1,1), where cells(1,1) has “John”
‐‐
inputting step
Cells(1,2) = Name
‐‐‐
outputting step
3.
The cosine of an angle in radians can be approximated using the Maclaurin series as:
cosሺݔሻ ൌ
1 െ
௫
మ
ଶ!
௫
ర
ସ!
െ
௫
ల
!
⋯.
where
x
is in radians. Develop a general method (list the
steps) or a flowchart to compute cos(x) for any given angle in radians using 4 terms in the above
series. Write a program to compute the approximate value of the cosine using 2 terms, 3 terms,
and 4 terms. Use the code to estimate the approximate value of the cosine of 34 degrees. Also
compute the exact value using VBA’s internal library function for cosine (COS). Calculate the
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document
This is the end of the preview.
Sign up
to
access the rest of the document.
 Fall '09
 Clement
 Hyperbolic function, Text Problem, Visual Basic program

Click to edit the document details