Can any one tell me the format/columns for writing test
scenarios in excel sheet?
- 4 Answers
- 12072 Views
- I also Faced
- E-Mail Answers
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 is test scenario, use case, and test case?
Explain number of production defects measure?
who preapares use case document? who preapares use functional point document? who preapares use test sceanario document?
How to test a website???
What are the categories of writing test cases?
How will be the communication between the testers and developers while found a bug?
When should testing start in a project? Why?
hi what is difference between sdlc and stlc.
IS Mutation testin and error seeding the same....if not can anyone tell me the difference???
Anyone tell me the test cases of Shopping Favorite
I Have 2 Yrs Experience in Manual I appiled in Job Portals still i m not getting any calls plz help me wat i need to do guide me please ?
How do we find Effectiveness of Test Cases..Thanks in advance...
Automation Testing 
