Can any one tell me the format/columns for writing test
scenarios in excel sheet?
Answers were Sorted based on User's Feedback
Answer / avinash chava
Hello friend,
Here are the columns you need to have while
writing test cases anywhere.
1) TestCaseID
For this we will give some unique number
2) TestCase
Here we will write the condition to be tested
3) Description
Here we will write the steps how to test that
particular condition
4) Expected Result
What is the expected result of this
particular operation
5) Actual Result
What is the actual result while executing on
the build.
6) Status
What is status of this particular testcase.
Either it is PASS/FAIL
7) Priority
Here we will write the priority of that
particular test case. We will write Either High/Medium/Low.
All the fields are same even though you use an
excel sheet or any other management tool like quality center.
| Is This Answer Correct ? | 11 Yes | 5 No |
Might gone wrong in reading the question properly The
question is related to Test Scenario columns( template) not
Test case template.
Scenario template changes from company to company but
normally these are the minimum things which it should have
1. Test Scenario Identifier
2. Requirement Traceability Matrix
3. Test Scenario Summary
4. Test Scenarios
5. References
1. Test Scenario Identifier is an unique identifier to
recognize the Scenario.
2. Requirement Traceability Matrix:- Provide a reference to
the location of the matrix that specifies the traceability
of requirements for that scenario. Mapping requirement to
that scenario.
3.Test Scenario Summary:- Provides a summary description to
that summary
4. Test Scenario:- In-detail how this scenario should be
giving complete understand wht is this scenario is of.
5. The reference document which talks abt the scenario.
Now keeping this as list, testers creates n no. of test
cases for each and every scenario and the test case template
would be as defined in the above answer.
| Is This Answer Correct ? | 8 Yes | 3 No |
Answer / jocelyn - test manager
Venkatesh they are asking about test scenario format but not test case format. There is lot of difference between test case and test scenario . The one Avinash and venkatesh described are related to test case format but not test scenario.
Test cases comes from test scenario.It is like Test scenario is parent and childrens are test cases for those scenario. The second answer is related to test scenario which is right
| Is This Answer Correct ? | 4 Yes | 1 No |
Answer / venkatesh
Hi Friends..
This is the possible test case design
Test case ID
Test Case Description
Test Pre-requisite
Test Input
Expected Result
Actual Result
Status
Priority
Seviority
Comments
| Is This Answer Correct ? | 0 Yes | 7 No |
What are Templetes for Daily,Weekly,Monthly test reports(Test Execution report)?
What is Functional Testing?
Can anyone please give me the idea how does Requirement Tracebility Matrix, looks like ? or mail me at: ontesting@gmail.com
What disabilities are affect on software usability?
1. what is SDLC and TDLC ?
What is Asset testing?
how can we test an application to know the expiration period (i.e,below or equal to expiry-date it shud work and above it shud fail). [assume this s/w app'n validity period is 2months]
why sql injection is injected in manual testing?
Hello, what will be the example for Regression Testing?? Thanks, Gaurav.
what all the metrics to be checked for a document ?
how to write testcase for toaster?
test templet for GUI UNIT testing?