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 |
Is thr any standard format for Test Case ID like... TC_applicationname_deveopername_date_modulenumber or else we can give any ID which is unique entire the application?? plz clear my doubt...
Use-cases can provide useful input into the design of black-box and state-based tests of OO software.is it true
What procedure you follow between gathering requirements and carried out testing?
hi what is difference between sdlc and stlc.
How do you go about testing a web application?
what is the critical defect in telecom domain?help me out from this prob its very urgent
Hi Friends.... anyone know who is giving coaching for CSTE exam in bangalore....pls inform me that would be helpful for me...Thankx in advance.
when we found problem occured in requirement while writing test case when communicate with client but they not accepting it is problem whether you continue further or not?
please make me understand what is client server and web application?
What is test design???
What is test data
Hi there!!! Im Varun...i've completed my B.Sc in 2013.now im woriking in pharmaceitical company.now i want to shift to IT field..for that ive learned Manual testing.now i want to put 1+ years fake..wat my doubt s can i manage as fresher or any problem???suggest me im confused????