Test Plan For Unit 5 Assignment BC

Kwame Aidoo

Test plan for my model

Test Test Expected outcome Actual outcome Test
No description passed?
1 Average The total average Yes
calculation for the rows in the
quadrat should be
calculated.

2 Entering The data entered in Yes
percentage %herbs, %scrub
and %bare ground
should
automatically
convert to
percentages.
3 Deteriorating The should be a Yes.
row that changes Green
colour to let you when
know if a quadrat is %herbs >
deteriorating from 80% and
the data entered. red when
%herbs <
20.
4 Count per There should be a Yes
quadrat species formula that
counts the number
of ticks found in a
quadrat.

,5 Entering ticks There should be a Yes
data validation on
the cells that will
allow only tick to
be entered.



6 Sum per The should be a Yes
quadrat formula that
counts the number
of ticks of a
desirable species in
all the quadrats.




7 Conditional There should be a Yes
formatting for conditional
rich and not formatting in a row
rich quadrats that will change
colour to let you
know if the quadrat
is rich or not.

, 8 Data validation There should be a Yes
for the tick message box
when an undefined
character is
entered in place of
the tick.


9 Data validation There should be a Yes
for the top cells message box when
(height and an undefined
percentages) character is
entered in place of
numbers.



10 Graph The graph should Yes
be able to record
the data entered.