Assignment 3 (Duration: 10 hours; Hand in: End of 7th week) P5, P6, M3
You have recently been employed in BCC's small IT department to modify a spreadsheet model which analysed the collected data and produced suitable reports and graphs as part of a management information system (MIS).
By using the BCC Spreadsheet you need to adapt a working spreadsheet model that will accurately perform the following functions: Customisation techniques - choose at least two (P5) Hiding and protecting data within your spreadsheet. Modify the toolbars and menu to restrict user actions. Data validation routines to ensure accuracy of input needs to be included in your spreadsheet. Choose one from: data validation, range checking, presence of data such as not NULL. Automation techniques - cover both types (P6 & M3) Create workbook macros e.g. for printing or formatting Create global macros The owner of BCC is pleased with what you have done to automate the spreadsheet model but would like to understand more about the methods of automation that you have used and those you chose not to use. Prepare a presentation for them comparing the different automation methods. |
|