Project Detail

Description

i need help on simple VBA i just dont have the time to do it

Part 1 Algorithm design

a. Design an algorithm that will calculate the volume of a sphere. Select appropriate units
for the radius.
b. Design an algorithm that will convert a EIGHT digit BINARY number to decimal.
c. Design an algorithm that will randomly generate six different numbers. (Numbers should
be range from 1-49). You will need to check the numbers to see if they don’t repeat
themselves in the sequence. You will only discover this when you write the program. If
this is true you must then re-define your algorithm). Use the randomizing function in
VBA.
d. Design an algorithm that will count the number of vowels in a sentence. The sentence should be constructed from a maximum of no more than 10 words, ending with a full stop.


Part 2 Program structure and design.

a. Convert the algorithms in Part 1, to VBA computer programs . ALL outputs should be
shown in the correct units. Make the programs ‘user friendly’.
b. Ensure the program structure and design makes the program readable and makes the
process of debugging much easier.
c. Where possible use suitable comments to help in the understanding of the program
function.

Part 3 Program test and debug.

a. Use suitable test data to check the functionality of algorithms in Part 1 and the programs
in Part 2.
b. Comment on whether the programs work correctly and how you would change them if
any shortcomings have been identified.

Part 4 Overall content and structure

a. Completeness of report, including page numbers, contents page, correct use of headings
etc. All work referenced and conclusions provided where required. ALL sections
attempted.