How can you report the defect using excel sheet?

Answer Posted / nag

5. Test Reporting:
During level ?1 & level ?2,
test execution, test engineers are reporting miss matches in
between test case expected values and build actual values as
defect report to development team.
In this test reporting, development people are receiving
defect report from testing team in a standard format. This
format followed by every test engineer in test execution to
report defects.

IEEE-829 Defect Report Format:

1. Defect ID: Unique no./name for future reference.

2. Description: Summary about defect.

3. Build Version: The version no. of current build, in this
build test engineers detected this defect.

4. Feature: The name of module / function, in that area test
engineers found this defect.

5. Test Case Name: The name of failed test case, in that
case execution test engineer found this defect.

6. Status: New reporting first time, Re-open Re-reporting.

7. Re-producible: Yes Defect appears every time in test
case execution, No Defect appears rarely in test case
execution.

8. If Yes: Attach test procedure.

9. If No: Attach snapshot and strong reasons.

10. Severity: The seriousness of defect in terms of
functionality.

High  Not able to continue testing
with out resolving this defect (show stopper)

Medium  Able to continue remaining
testing, but mandatory resolve.

Low  Able to continue remaining testing and May
/ May not to resolve.
11. Priority: Importance of defect to resolve in terms of
customer (High, Medium, Low)

12. Detected by: Name of test engineer.

13. Assigned To: The name of responsible person at
development side to receive this defect report.

14. Suggested Fix (Optional): Reasons to accept and resolve
this defect.


Resolution Type:
After receiving defect report from testing team, the
responsible development people are conducting review meeting
and sending resolution type to the responsible testing team.
There are 12 types of resolutions, they are

1. Enhancement: The reported defect is rejected, because
this defect related to future requirements of the customer.

2. Duplicate: The reported defect is rejected, because this
defect raised due to limitations of hardware devices.

3. Hardware Limitations: The reported defect is rejected,
because this defect raised due to limitations of hardware
devices.

4. Software Limitations: The reported defect is rejected,
because this defect is raised due to limitations Software
Technologies (Ms-Access).

5. Not Applicable: The reported defect is rejected because
these defects have improper meaning.

6. Functions as Designed: The reported defect is rejected,
because the coding is correct w.r.p.t design documents.

7. Need More Information: The reported defect is not
accepted / not rejected but the developers are requiring
more information about the defect to understand.

8. Not Re-producible: The reported defect is not accepted &
not rejected, but the developers are requiring correct
procedure to reproduce that defect.

9. No Plan To Fix It: The reported defect is not accepted &
not rejected, but the development people are requiring some
extra time.

10. Open: The reported defect is accepted & the development
people are ready to resolve through changes in coding.

11. Deferred: The reported defect is accepted, but postponed
to future release, due to low severity & low priority.

12. User Direction: The reported defect is accepted, but
developers are providing some valid information about that
defect to customer site people, through our application
build screens.

Is This Answer Correct ?    8 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is neutral test case?

1800


please give information about ERP Projects and how V-model use in project

2361


Define cause effect graphing?

672


What is remedy testing,expalim that and how can use that

1222


What is an end-to-end testing?

607






Tell me some Adhoc testing scenarios of ebay (online auction product)?

3376


IN SQL SERVER 2005, With out using Query, hw can u break down USER NAME & PASSWORD to enter the software.

1713


Do write a separate test case for regression testing? If it is yes, explain how to write the test case?

711


Hi friends I am kranti completed my IT diploma in 2005 & after that complete my software testing course. Now I am working in small software form as software tester. I have 2 + year experience in manual testing. Now I wan to change company. Plz told me is there any effect that I can not have any degree although I have 2 + experience ?

1522


Difference between Stakeholder and Relevant Stakeholder?

1588


What is the difference between action & script ?

1895


What are the cases why parameterization is necessary when load testing the Web server and the database server?

1681


In manual testing, what are stubs and drivers?

657


What r all the security problems u r facing & the measures taken to solve.

1822


Can any body tell me in real time how cookies testing is done. And please tell me the steps.And for cookies testing test cases is needed.

1597