This worksheet is for use during the quiz on February 4, 2016. You may use a printed copy of this worksheet during that quiz and if you choose, you can take additional notes on the worksheet during the lecture before class. The worksheet will NOT be collected. You may NOT access a worksheet that is stored on your cell phone or laptop nor may you share worksheets.

For collection:

Nothing will be collected.

Review Preparationwhat was done with MS Excel in class AND do the Excel exercise in #14:

  1. Save file (txt) from web page
  2. Upload text file into Excel
  3. Save file as xls or xlsx
  4. How does one identify a particular cell in MS Excel?
  5. How does one identify a range of cells in MS Excel?
  6. Add Boarders
  7. Make header bold and yellow
  8. Make column bold and yellow
  9. Use formula AVERAGE
  10. Use formula SUM
  11. Goal Seek
  12. Using Small and Large
  13. IF YOU ARE HAVING TROUBLE WITH ANY OF THE ABOVE, COME SEE ME AT OFFICE HOURS ON 1/24/2016.
  14. Using Goal Seek, find the December sales that Greg and David must achieve in December to each bring their averages up by $100.

Greg’s December Sales:______

David’s December Sales:______

Reading:

  1. Read the article passed out in class and also available at
  2. Read Chapter 1 if you have not already done so
  3. Read Chapter 2 if you have not already done so

As there were no questions about the article above on last week’s quiz, there will be one or two on this week’s quiz.

Questions from Excel:

  1. Be able to explain what Goal Seek does in terms of input and output.
  2. Identify an expression that is equivalent to SMALL(B2:B10,3).
  3. Identify an expression that is equivalent to LARGE(B2:B10,4).
  4. How many cells are included in the range (B1:D4)

Questions from Chapter 1

  1. Make sure you know the terms at the end of the chapter.
  2. An organizations goals and objectives are determined by what?
  3. Organizational strategy begins with what?
  4. What is determined by the intensity of the 5 forces of Porter’s model?
  5. What are examples of barriers to entry in an industry?
  6. How is a support activity distinguished from a primary activity?
  7. What are specific examples of support activities?
  8. What determines profit margin?
  9. What are ways to increase profit margin?

Questions from Chapter 2

  1. Make sure you know the definitions at the end of the chapter.
  2. Make sure you know the summary of symbols used in BPMN diagrams.
  3. What is an example of a system decision involved in the registration process on Banner?
  4. What are examples of system and human actors involved in the process of checking a library out of Pius library?
  5. What is a synonym for a repository?
  6. Why is it important to document processes before designing and implementing a software system?
  7. How is a business process related to an information system?