INF1020: Management Information Systems - Homework Assignments

1. Read Chapter 5 (Internet and LAN Technology) from the "Computer Concepts" book. Complete the reading by Monday March 27, 2006.

2. Complete the following assignment. Hand in your answers to the questions on a sheet of paper. Each answer should contain a single formula (you don't have to actually create the spreadsheet to hand in). We will review the answer in class on the day it is due. I will therefore not accept late submissions.

3. Bring your Office 2003 books to class

The midterm will contain two parts. In the first part you will NOT be allowed to use the computers. You will be asked general questions from ALL of the material.

When you finish the first part you will hand it in and then be allowed to use your computers for the 2nd part. On the second part you will be asked to create Excel formulas as well as to demonstrate your proficiency with other parts of the program.

Topics on midterm: (note Excel questions will appear on both the "online" and "offline" parts of the test).

• 10 - 15 points: Information from the following:
• Powerpoint presentations from yrosenthal.com
• : "Basic Windows Terms"
• "Windows Explorer"
• Office 2003 book chapters
• Essential Computer Concepts
• Exploring the Basics of Microsoft Windows XP
• Managing Your Files
• Computer Concepts book
• Chapter 4: File Management, Virus Protection and Backup

• 85 - 90 points: Info from the following:
• Powerpoint presentations from yrosenthal.com
• "Excel Formulas" - You are responsible for everything from this presentation, except for the AND, OR and NOT functions.
• Office 2003 book chapters
• Excel: Tutorial 1
• Excel: Tutorial 2
• Excel: Tutorial 3
• (The midterm will NOT cover Excel Tutorial 4)

Do all of the yellow highlighted sections from Tutorial 2 in the Office 2003 book. Hand in a printout of the formulas (I do not want a printout of the values). Make sure that the printout includes gridlines, column and row headings and is printed on exactly one piece of paper.

Finish Tutorial 1 from the Office 2003 book if you have not finished it in class. You must hand in two printouts. (1) a printout of the formulas (2) a printout of the values. Make sure that both printouts include gridlines, column and row headings and are printed on exactly one piece of paper each. (see the the Excel menu choice "File | Page Setup")

An Excel workbook contains the following two worksheets.

Cell D4 and D5 contain the following formulas:

Cell D4:      =Sheet2!B2+A1*SUM(Sheet1!A2:C3,3:3)

Cell D5:      =AVERAGE(SUM(A1:C3),Sheet2!A1:C3)*3

For each formula, show the steps, line by line, that Excel used to come up with the value. Write out your answer on paper and hand it in.

The following spreadsheet

Has the following formula in cell A5 (you can also see the formula in the formula bar in the image above):

     =C2+A1*SUM(AVERAGE(B1/4+3*A2,C3),7)+MAX(MIN(A1,A2),MIN(B1,B2))

Show the steps, line by line, that Excel used to come up with the value of 167.5 displayed in the image. Write out your answer on paper and hand it in. In the future you will be doing all assignments on the computer and submitting them via the Angel system. I will show you how to do that in class.