Current Semester
Spring 2009
YU Links
Prior Semesters
Fall 2008
Spring 2008
Fall 2007
Spring 2007
Fall 2006
Spring 2006
Fall 2005
Fall 2002 - Spring 2005

INF1030: Introduction to Information Technology - Homework Assignments

HW10

Create an Excel document that calculates your expected GPA for the courses that you are taking this semester. For each course you are taking, list the course name, number of credits for the course and the expected grade. For grades use a number from 0 through 4 where 4 is an A, 3 is a B, 2 is a C, 1 is a D and 0 is an F. Create a cell that uses a formula to calculate the total number of credits for all the courses. Use another formula in a different cell to calculate the GPA.

GPA is calculated as a weighted average. To calculate a GPA, multiply the grade for a course by the number of credits for that course. Do this for each course and add up the results. Then divide that sum by the total number of credits for the semester.

OF COURSE - the formula should not include actual numbers. Rather the formulas should include cell references to those cells that actually contain the grades and credit numbers. If you change the grade or number of credits for a course, the GPA should AUTOMATICALLY be recalculated.

Example:

Name Credits Grade
Speech34
Marketing43
Accounting52
Total Credits:12 
GPA:2.833

(this is because: 2.833 = (3*4 + 4*3 + 5*2)/(3+4+5)		 
HW9

Tic Tac Toe program - see handout

HW8

Create the following programs. To submit, zip up the folder for each project separately and submit each zip file to Angel.

  1. Chapter 4 - exercise 4
  2. Chapter 4 - exercise 11
HW7

This assignment was written on the board. The assignment was to calculate whether the boolean expressions on the board evaluated to TRUE or to FALSE. You did not have to submit this. We went over the answers in class.

HW6

Write a program that has 4 buttons that work in the following ways:

  • Button1 - MsgBox displays how many times user clicked Button1
  • Button2 - MsgBox displays how many times user clicked Button2
  • "Total Clicks" - MsgBox displays how many times user clicked both Button1 and Button2. Also shows a total number of clicks.
  • "Reset Counts" - Sets all the counts back to zero. (no message box is displayed).
HW5

Create the program that we wrote on the board last class. The program calculated the number of dollars, quarters, dimes, nickes and pennies that must be returned as change for a purchase.

Upload your finished program to Angel - remember to "zip up" (i.e. create a compressed folder) the entire folder for your project.

There is a good chance that you will need to modify this program for a future HW assignment.
HW4

Given the following code write what each of the following calls to MsgBox will display:

    Private Sub Button1_Click _
             (ByVal sender As System.Object, _
              ByVal e As System.EventArgs) _
                         Handles Button1.Click
        Dim x, y As Integer
        x = 18
        y = 4
        MsgBox(x / y)
        MsgBox(x Mod y)
        MsgBox(x \ y)
        MsgBox(Fix(x / 4) + Int(x / y))
        MsgBox(x \ y + x Mod y)
    End Sub
HW3

See Angel for directions
HW2

Questions on Hexadecimal - written on the board - submit handwritten answers.
HW1

Questions on Binary/Decimal - written on the board - submit handwritten answers.