How can you report the defect using excel sheet?

Answer Posted / mukesh sharma

Bug List in excel sheet contains mentioned fields:

Bug ID : Unique no./name for future reference.
Description : Summary about bug/defect/error.
Raised in Build/ Release/ Version/ Sprint : The version no. of current build, in this build test engineers detected the bug.
Feature : The name of module / function / feature, in that area test engineers found the bug.
Test Case Name : The name of failed test case, in that case execution test engineer found this bug.
Status : Life cycle of the bug.
New : A new bug detected by a tester
Open : A bug that has been reviewed and verified as a true bug
Rejected : A bug that has been found not to be a bug
Assigned : A bug that has been verified by development and is now assigned to developers for fixing
Fixed : A bug that has been fixed and is ready for retesting
ReTest : A bug that has been fixed by developers, which is once again tested to be closed
ReOpen : A bug that has failed testing during ReTest
Closed : A bug that has successfully passed retesting
Deferred : A bug that has been mutually agreed to move to the next release or later releases.
Duplicate : If the bug is repeated twice or the two bugs mention the same concept of the bug, then the recent/latest bug status is changed to “duplicate“.
Not A Bug : If there is no change in the functionality of the application. Work as expected.
Severity : The seriousness of bug in terms of functionality.
High : Not able to continue testing with out resolving this bug (show stopper)
Medium : Able to continue remaining testing, but mandatory resolve.
Low : Able to continue remaining testing and may / may not to resolve.
Priority : Importance of bug to resolve in terms of customer (High, Medium, Low)
Detected By : Name of test engineer.
Assigned To : The name of responsible person at development side to receive this bug report.
Open Date : Date of bug found.
Closed Date : Date of bug fixed.
Verified in Build/ Release/ Version/ Sprint : The version no. of current build, in this build test engineers tested and verified the bug.
Testers Comments : Comments related to Bug Status, Severity, Priority, Suggestion to fix etc. Comments by testers.
Developers Comments : Comments by developers
Attachment : Screenshot or video Link.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Define cause effect graphing?

678


how to indentify memory leakages after the build

1627


After insert the record in front-end, how will you check the back end by manually? Please explain?

604


Is Anyone attended the manual testing interview with capgemini in recent past. please let me know the type of questions they can ask. Thanks

2875


Hi to all..Now am working at one company as Software tester..I have selected for Accenture via one consultancy.. They have told that joining date will be on 19 th july..But now they are postponed joining date..whether i can trust that or not?Can u plz tell??plzz..whether i can put my paper to releive or not? CAn u telll?

1615






If date field is a text field write test cases to validate it?

1944


Can anyone write test cases on google account creation page in the testing template format , urgent pls and explain if possible how to execute also

1579


What is test driver and test stub?

690


What is Snapshot Testing? When we need to do and who will involve in this process and also what is the output document of this testing

2402


how many meeting in realtime environment? what are they?plz explain?

1469


what is test case management?explain in brief.

1530


Suggest some book to learn more test case???

1352


If project wants to release in 3months what type of risk analysis you do in test plan?

700


What is the difference between three tier and two tier application?

659


What are differences between Testing in Uncontrolled Environment and Abnormal Environment?

2354