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 system will use simple formulae involved with the process of add and subtracting numbers. The new system will also involve formulae’s with more complicated functions like the, IF function and the average function. IF (logical_test, value_if_true, value_if_false) an example of an IF function would be if a number exceeds 60 then the statement will read false, if it is less than 60 the statement will read true.
The new system will also be formatted to make it easier for the user. An example of one of the formats the new system would have would be conditional formatting. Conditional formatting can be applied to a cell, so that if the value were below a certain number in that cell the colour of that number would change.
Data validation will be set on one of the sheets in the new system to ensure that only whole number can be enter in to the sheet, between a range of 1 to 9.
Test strategy
- Testing functions e.g. IF function.
- Test data validation
- Test menu buttons
Test plan
- Test signing in/out button
- Print out signing in/out sheet see if it meets user requirements
- Test duties button, add duties data then print out duties sheet
- Test briefing time button
- Test work performs button
- Test validation cells
- Test conditional format cells
- Test IF functions
Test data and expected outcome