Can any one tell me the format/columns for writing test
scenarios in excel sheet?
- 4 Answers
- 12069 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 |
How we will do Memory Testing? There is any tool to do that testing and to whome this testing to be performed?
I write the test cases in Excel Sheet. For Retesting how to maintain the excel sheet.? Hw to maintain the History?
what is UI testing
This is Raji.I am having 2 plus years of experience in Manual testing. I want to do a certificate course in Manual testing. Which certificate course would be better to do?.
what is fusion testing and impact analysis???
How will you determine if the architecture of any web site is of two tiers, three tiers or multi tier?
SAY YOUR PRODUCT PASSED THROUGH TESTING & UAT. NOW IT WENT TO PRODUCTION AT CLIENT LOCATION AND THEY FOUND ONE DEFECT IN IT. HOW THEY NEED TO PROCEED NOW? WILL THEY CONTACT U? OR WILL THEY CONTACT DEVELOPMENT TEAM?
what we have to read to gain knowledge in banking and financial domain(software testing) for 4+ experience
How to monitor test progress?
Can the system testing be done at any stage?
What is alpha testing?
what is the difference between Error,Defect,Bug,Failure
Automation Testing 
