Reference no: EM13780310
Objectives
1 - To become more familiar with building User Forms
2 - To create your own program.
3 - To get familiar with Power Point (other software must be approved)
4 - Practice presenting your work
Assignment:
1. Decided on a topic requiring a computer application that includes Excel programming features. Begin the layout and basic structure of the project in class today by laying out tables, equations, user input and output. Try to complete the brainstorming portion of this task today.
Your task is to create a Visual Basic Applications, VBA program that reads requested input values and displays the requested results in a user-friendly interface. You are required to include the following,
Worksheet 1 in Excel will provide an introductory statement about the program, illustrations, graphs, output data results and a button to initiate the macro.
The user will only interface with the VBA UserForm programming objects.
The program will not rely on Excel functions to produce results. All calculations shall be executed within the Visual Basic code.
Your program must incorporate Do Loops and If - Then - Else statements.
Tables will be permitted in worksheets for program referencing; however, they will be placed on worksheets other than the first sheet as required.
Name the worksheets appropriately.
Topics you may select for your program are listed below. Other thoughts may be submitted to instructor for consideration and approval prior to commencing with the assignment.
1. Horizontal alignment for roadway.
2. Vertical alignment for roadway.
3. Volume calculations by two methods.
4. Beam design program
5. Body-in-motion; distance, velocity and acceleration.
6. Statics of distributed forces; cables, beams, centers of mass.
7. Work - Energy and motion.
2. Develop a unit converter to convert both force and length from SI units to US customary units and vice versa.
Program Requirements:
Units to convert:
Force conversion units: Length conversion units:
SI - N and kN SI - mm, cm, m, and km
US - lbs and Kips US - in, ft and mile
The program should convert from any unit option in one system to any option in the other unit system.
For example, if you start with inches, the user should be able to convert this to mm, cm, m, or km.
A Do loop that allows the user to convert more than one value without having to rerun the program.
Userforms to collect the user's choices on what to convert. Userforms should contain (not all required in one userform):
|
Hawthorne effect-statistical reliability
: One reason a valid experiment may produce null results is.
|
|
Who are the key participants in these programs
: Write a 1,050-word paper comparing two juvenile diversion, intervention, or prevention programs operating in the state of Maryland. Who are the key participants in these programs
|
|
Used for assessing a companys external environment
: Managers must be able to diagnose both a company's external and internal environment to succeed in developing a successful strategy. Identify and discuss a concept or tool that can be used for assessing a company's external environment.
|
|
International businesspeople avoid relying on self-reference
: How can international businesspeople avoid relying on the self-reference criterion when dealing with people from other cultures? Does it make a difference if the business activity is conducted in the home or the host country?
|
|
Develop a unit converter to convert both force
: Decided on a topic requiring a computer application that includes Excel programming features. Begin the layout and basic structure of the project in class today by laying out tables, equations, user input and output. Try to complete the brainstorm..
|
|
Did the son and daughter act ethically towards each other
: Alonzo Marchetti, who owned a construction company, promised his son, Romo, that if Romo would manage the family business for their mutual benefit and would take care of him for the rest of his life, he would leave the family home to Romo. Did the..
|
|
Impact of vigorous enforcement of intellectual property
: Intellectual property is an important asset for most multinational companies. However, laws protecting intellectual property vary dramatically from country to country. What can multinational companies do to reduce piracy, counterfeiting and other int..
|
|
Which is more difficult to assess business skills
: Which is more difficult to assess, business skills or international skills? Why? Would it be best for an MNC to hire someone with business skills and train them in international skills or to hire someone with more international skills and teach them ..
|
|
Will mamet succeed in proving
: By June 2010, KAC had laid off about 9,000 employees. Mamet sued KAC for breach of the agreement to provide permanent employment to him. Will Mamet succeed in proving that KAC breached their agreement with him
|