
Step 1: Find the Bug
π Test the software manually and identify a problem (e.g., clicking a button does nothing).
Step 2: Reproduce the Bug
π Try repeating the same steps to confirm that the issue happens consistently.
Step 3: Capture Details
π Take screenshots or videos to show whatβs wrong.
Step 4: Log the Bug in a Bug Tracking Tool
π Open a bug tracking tool (like JIRA, Bugzilla, or Trello) and fill in the details:
- Bug ID: A unique number assigned to the bug.
- Title: A short description of the issue (e.g., “Submit button not working”).
- Description: Step-by-step details to reproduce the bug.
- Severity & Priority: How serious the bug is (e.g., Critical, High, Medium, Low).
- Expected Result: What should happen.
- Actual Result: What actually happens.
- Attachments: Screenshots/videos.
Step 5: Assign & Track the Bug
π The bug is assigned to a developer for fixing. After fixing it, the tester rechecks it to ensure it’s resolved.
π Easy-to-Understand Diagram
mathematicaCopyEdit π Find Bug
β
π Reproduce Bug
β
πΈ Capture Details (Screenshots)
β
π Log Bug in Tracking Tool
β
π’ Assign to Developer
β
β
Recheck After Fix
Example of a Bug Report
| Field | Details |
|---|---|
| Bug ID (E.g. TC_001) with identification no: | TC_001 |
| Title | Steps to Reproduce: 1. Go to the checkout page 2. Fill in payment details 3. Click the “Submit” button Expected Result: Payment should process Actual Result: The button does nothing |
| Description | Steps to Reproduce: 1. Go to the checkout page 2. Fill in payment details 3. Click the “Submit” button Expected Result: Payment should process Actual Result: Button does nothing |
| Severity | High |
| Priority | Critical |
| Attachments | Screenshot of the issue |
| Assigned To | Raphael Wong |
Why Is Proper Bug Logging Important?
π Helps developers fix issues faster
π Prevents the same bug from happening again
π Improves software qualit
How to Log a Bug in Google Spreadsheet (Manual Testing)?
If you donβt have a bug-tracking tool like JIRA or Bugzilla, you can use Google Spreadsheet to log and track bugs in manual testing.
π Steps to Log a Bug in Google Spreadsheet
Step 1: Create a Google Spreadsheet
π Open Google Sheets and create a new sheet named “Bug Tracker”.
Step 2: Add Column Headers
π Set up the following columns:
| Bug ID | Title | Description | Steps to Reproduce | Expected Result | Actual Result | Severity | Priority | Status | Assigned To | Date Found | Attachments |
|---|
Step 3: Find and Reproduce the Bug
π Test the software manually, find a bug, and check if it happens repeatedly.
Step 4: Enter Bug Details in the Spreadsheet
π Fill in the details in the respective columns.
Step 5: Assign the Bug and Track the Status
π Assign the bug to a developer and update the Status column (e.g., Open, In Progress, Fixed, Retested, Closed).
π Easy-to-Understand Diagram
mathematicaCopyEdit π Find Bug
β
π Reproduce Bug
β
π Log in Google Spreadsheet
β
π’ Assign to Developer
β
β
Update Status After Fix
Example of a Bug Report in Google Spreadsheet
| Bug ID | Title | Description | Steps to Reproduce | Expected Result | Actual Result | Severity | Priority | Status | Assigned To | Date Found | Attachments |
|---|---|---|---|---|---|---|---|---|---|---|---|
| TC- 101 | Login button not working | User unable to log in | 1. Go to login page 2. Enter valid credentials 3. Click “Login” | User should log in | Nothing happens | High | Critical | Open | Dev Team | 2025-02-13 | Screenshot.png |
| TC_102 | Checkout page crashes | Payment page does not load | 1. Add items to cart 2. Click “Checkout” | Payment should be processed | Page crashes | Critical | High | In Progress | Dev Team | 2025-02-13 | Error_log.txt |
Why Use Google Spreadsheet for Bug Tracking?
β
Easy to use β No need for complex tools
β
Collaborative β Multiple testers can update in real-time
β
Free & Accessible β Works anywhere with an internet connection
β
Customizable β Can add more columns like Bug Type, Browser, OS
Using Google Spreadsheet makes bug tracking simple and efficient, helping teams fix issues faster and more effectively!