Code for printing the grade of a studente on Excel sheet using VBA

Private Sub CommandClicking_Click()
Dim m As Integer
Dim g As String
Randomize Timer
m = Int(Rnd * 100)
Cells(10, 1).Value = m
If m < 35 And m >= 0 Then
g = "F"
Cells(11, 1).Value = g
ElseIf m < 55 And m >= 35 Then
g = "E"
Cells(11, 1).Value = g
ElseIf m < 65 And m >= 55 Then
g = "D"
Cells(11, 1).Value = g
ElseIf m < 75 And m >= 65 Then
g = "B"
Cells(11, 1).Value = g
ElseIf mark < 90 And mark >= 75 Then
g = "A"
Cells(11, 1).Value = g
ElseIf mark < 100 And mark >= 90 Then
grade = "A*"
Cells(11, 1).Value = g
End If
End Sub

Comments

Inter-Organizational Value Chain

The value chain of a company is part of over all value chain. The over all competitive advantage of an organization is not just dependent on the quality and efficiency of the company and quality of products but also upon the that of its suppliers and wholesalers and retailers it may use. The analysis of overall supply chain is called the value system. Different parts of the value chain 1. Supplier 2. Firm 3. Channel 4 . Buyer

Advantages and Disadvantages of EIS Advantages of EIS Easy for upper-level executives to use, extensive computer experience is not required in operations Provides timely delivery of company summary information Information that is provided is better understood Filters data for management Improves to tracking information Offers efficiency to decision makers Disadvantages of EIS System dependent Limited functionality, by design Information overload for some managers Benefits hard to quantify High implementation costs System may become slow, large, and hard to manage Need good internal processes for data management May lead to less reliable and less secure data

System Analysis and Design (SAD)

Introduction to System Analysis and Design (SAD) System are created to solve Problems. One can think of the systemsapproch as an organised way of dealing with a problem. In this dynamic world , the subject system analysis and design, mainly deals with the software development activities. This post include:- What is System? What are diffrent Phases of System Development Life Cycle? What are the component of system analysis? What are the component of system designing? What is System? A collection of components that work together to realize some objectives forms a system. Basically there are three major components in every system, namely input, processing and output. In a system the different components are connected with each other and they are interdependent. For example, human body represents a complete natural system. We are also bound by many national systems such as political system, economic system, educational system and so forth. The objective of the system demands tha...

Shruti Speak's

Search This Blog