Cal poly pomona

In this lesson we will discuss relational and logical operators. In most real-life situations, you perform different tasks based on the current set of conditions. For example, you will buy milk at the...

In this lesson, we will learn the difference between relative and absolute references in Excel. So far, when we have wanted to access the value stored in a cell, we simply type the address of that...

In this lesson, you will be introduced to the Excel workbook environment. In these tutorials we will be using Excel 2007 in the Windows 7 operating system, but the topics we will cover will apply to...

In this lesson, the topic of repetitive execution will be introduced. Perhaps the greatest feature of a computer is its ability to execute many repetitive statements very quickly. How long would it...

In this lesson, we will discuss If-Then-Else structures. When you want your program to execute certain statements if a test condition is True, and other statements if the test condition is False, you...

In this lesson, you will learn how to create custom dialogue boxes, which are often called UserForms. Most of the previous lessons have discussed concepts that are common to all computer languages....

In this example, we will call the same Sub procedure multiple times in a program. One of the great benefits of modular programming is that it allows you to reuse procedures as many times as you like....

In this lesson, we will discuss the difference between passing by reference and passing by value. In the past, when we have called Sub procedures, we have run the risk of accidentally overwriting the...

In this example, we will examine projectile motion A ball is thrown off the side of a 200 foot cliff with an initial speed, v0, of 100 feet per second at an angle, theta, 30 degrees relative to the...

In this lesson, we will discuss how to adjust the number of elements in an array using the ReDim statement. When we declare arrays using the Dim statement, a specific amount of memory is set aside to...