CMPS 273, Fall 2006, Assignment 4, Excel s1

CMPS 173, Fall 2008, Assignment 18, Final Exam (550 points)

  1. Fun data that we need: (25)
  2. Name,
  3. W number
  4. Favorite Christmas movie

Part 1: Excel (120 points)

Use Excel to answer the following questions. Use Blackboard to send me your program when you are complete.

  1. Make a plot of the equation Y = x2 + 5x (20)
  2. Start the X values at –10, end them at 10
  3. Use the X/Y Scatter chart to graphically display the data, make sure to include a chart title and label the x and y axis.
  4. Create a millimeters to inches conversion table. (20)
  5. Start the table at 0 millimeters and end it at 100 millimeters, go in increments of 20 millimeters.
  6. Use the equation: inches = millimeters/25.4
  7. Make a pie chart with the following data (label it): (10)

Weekly Food Intake of My Cat
Item / Ounces
Cat food / 70
Bugs / 10
Pieces of the couch / 20
Wife’s Jewelry / 5
His Hair / 20
My Eyebrows / 5
  1. You took two versions of a quiz that will be averaged together. Given that you scored a 22 on version 1 and 99 on version two, answer the following questions: (20)
  2. What it the average score of the two versions of the quiz?
  3. Using a weighted average, what is the average if the second quiz is worth 85%.
  4. Using the following precipitation data taken from measurements at a WKIKME weather station in New Orleans, answer the questions below. (50)

November. January

0 0

1 0

1.5 0

1 0

0 0

0 0

0 .1

0 .1

.5 .5

0 1

.1 2

0 6

0 1

0 1

0 .5

0 0

0 0

.1 0

1 0

2 0

2 1

2.3 6

1 1

1 1

0 .5

0 .1

.1 .1

0 .1

0 0

0 0

  1. Which month has more rain on a daily average?
  2. Make a line plot of the precipiation for each month.
  3. Find the following statistical measures for each data set:
  4. Median
  5. Mode/Modes
  6. In which month is the precipitation more consistently around the average precipitation for that month?
  7. What is your proof?
  8. What are the outliers in:
  9. November?
  10. January?

Part 2: Fundamentals of Computing (130 points)

  1. Work the following math problems (10)
  1. (24 * 16) / (1240 * 42) =
  1. 3.141592650 * 2-1 * 2 =
  1. 111 =
  1. What are the steps you do in order to take the inverse of a binary number (what are the steps in the 2’s complement process). (10)
  1. Convert the following hexadecimal numbers to decimal. (20)
  2. 10a
  1. 10
  1. 30
  1. Convert the following unsigned binary numbers to hex and then to decimal. (40)
  2. 1100
  1. 0010 1001
  1. 0001 0001 1010
  1. Using 4 bit 2’s complement binary numbers count from -8 to 7. (10)
  1. Work the following 5 bit two’s complement math problems. (40)
  2. 00111 + 01000
  1. 01100 – 00101
  1. 00001 - 11111
  1. 11111 + 01011
  1. 01001 – 00111

Part 3: Computer System Basics (165 points)

  1. Given the circuit below: (30)

  1. Write an equation for X.
  1. If A = 1, B = 0 and C = 1, what is X?
  1. If A = 1, B = 1, and C = 1, what is X?
  1. Given that we are using EVEN parity with 4 data bits, fill in the blanks in the table. (15)

Parity Bit / Data Bits
1 / 0 / 0 / 0
0 / 1 / 0 / 0
1 / 0 / 1 / 0
  1. What is the difference between error checking that uses parity bits and error checking that uses a checksum. (10)
  1. Draw circuits for the following equations: (30)
  2. X = NOT((A OR B) OR (NOT(A AND C)))
  1. X = (A AND B) OR (NOT (C AND D))
  1. X = NOT(NOT(A) OR NOT(B))
  1. Define the following: (20)
  2. Bit
  1. Byte
  1. What are the 4 types of functions that a CPU can execute? (20)
  1. Given that A = 0; B = 0; and C = 1, find the value of X in the following equations: (20)
  1. X = NOT(A AND B) AND C
  1. X = (A AND B) AND (NOT(C))
  1. X = NOT((A OR B) AND (NOT(C)))
  1. If computer A sends the data in the table below to computer B: (20)
  2. Which packets need to be resent?
  1. What is the error free percentage of data transmitted?

Packet # / 1 / 2 / 3 / 4 / 5 / 6 / 7 / 8 / 9 / 10
8 / 12 / 8 / 14 / 2 / 3 / 88 / 7 / 18 / 60
10 / 19 / 13 / 9 / 1 / 1 / 12 / 11 / 43 / 46
checksum / 18 / 31 / 21 / 23 / 21 / 13 / 100 / 18 / 62 / 106

Part 4: Programming in BASIC (110 points)

  1. Write an IF statement that prints out the number x it is between 40 and 50, if the number is not in this range print a message to the user letting them know the number is out of range. (20)
  1. What is the purpose of the DO …… LOOP UNTIL statement? (10)
  1. How is the DO …… LOOP UNTIL statement different from the FOR …NEXT statement? (10)
  1. Write a series of statements that calculates the average of the cubes of the numbers between 10 and 50. (30)
  1. Write a piece of code that uses a loop to: (40)
  2. Requests a number from the user
  3. Tells the user what number they entered.
  4. Prints out the cube of that number.
  5. Stops asking for numbers if the user enters a number that is not in the 0 to 100 range.
  6. Tells the user how many numbers they entered.

2