3024.S10.HW2 - ISE 3024 Data Management for IEs Spring 2010...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
1 of 2 ISE 3024 Data Management for IEs Thursday, February 11 Spring 2010 Homework Assignment #2 DUE: Thursday, February 18 (at start of class) (8) 1. Consider again the workbook ITEMS.xlsx , from Problem 7 of Homework #1: You are developing an application, based upon this workbook, for the Materials and Planning department of your company. They need to generate a new inventory count worksheet (e.g., Week 16 ) every week, then fill in the quantity of each item on the worksheet. Additionally, they must be able to change the quantity of any item on any past inventory count worksheet, in case of errors. You have interviewed the intended users and they familiar with (but not proficient in) Excel. (a) What cells should be locked, and how should the worksheet be protected, for the Average Inventory worksheet? For each of the weekly inventory count worksheets? (b) You want to modify the application to be sure the user cannot accidentally erase or move any of the worksheets. How can you do this with Excel? (c) You also want to modify the application to be sure the user cannot close the
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

3024.S10.HW2 - ISE 3024 Data Management for IEs Spring 2010...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online