Overview of a new system

Authors Avatar

Choice of Software

The software I have chosen to implement the new system is excel. I have chosen spreadsheets excel because of it ability:

  • To enter a number, formula or text into any cell
  • For formulae and other data can be copied into groups of cells.
  • To create macros, which are a series of command crated by the user that the spreadsheet would perform automatically.
  • To protect worksheets so users cannot accidentally destroy formulae or headings.
  • To customise menus and toolbars
  • To format so it is clear to the user where to enter data.

System overview

The new system would work in two ways the first way is as templates. The templates will be for entering data then worksheets can be printed out. The second way in which the spreadsheet would be used is to show data on performance of workers.

Join now!

The new system will have a central menu sheet. This sheet will act as the front sheet and be selected automatically using an autoexec macro, when the spreadsheet is loaded. The menu will have five buttons that will lead to five main sheets, in the spreadsheet system.

An example of some of the labels I would use would be the days of the week e.g. Monday, Tuesday etc, names and signing in/out. These labels will be placed at the head of its column. The type of data I would be entering would be mainly numbers.

The new ...

This is a preview of the whole essay