Test Cases on HIS Ops Inventory Managment System
Categories of Tests
- Excel Integration Tests
- Graph Rendering Tests
- UI Functional Tests (Buttons, Reports)
- Error Handling & Edge Cases
- Performance & Stability Tests


Test 1:
Excel Integration Tests
Test ID
Test Scenario
Expected Result
Pass/Fail
EXL-01
Open Excel File when clicking "Total Items"
Excel file opens successfully
✅ Pass
EXL-02
Open Excel File when clicking "Low Stock"
Excel file opens successfully
✅ Pass
EXL-03
Open Excel File when clicking "Recently Added"
Excel file opens successfully
✅ Pass
EXL-04
Excel file is missing from system
Displays Error: Excel file not found message
✅ Pass
EXL-05
Excel application is not installed
Displays Failed to open Excel error
✅ Pass
EXL-06
Excel file contains negative numbers in Column 7
Graph should display correctly with negative values ignored or flagged
✅ Pass
EXL-07
Excel file contains zero values in Column 7
Graph should correctly show zero counts
✅ Pass
EXL-08
Excel file contains text in Column 7 instead of numbers
Application should handle invalid values gracefully (ignore or show an error)
✅ Pass

Test 2:
Graph Rendering Tests
Test ID
Test Scenario
Expected Result
Pass/Fail
GPH-01
Click "Generate Report" button
Bar Chart displays with Total Items, Low Stock, and Recently Added
✅ Pass
GPH-02
Negative values in Excel data
Graph should ignore negative values
✅ Pass
GPH-03
All zero values in Excel data
Graph should correctly show zero bars
✅ Pass
GPH-04
Large dataset with over 10,000 rows
Application should not crash, graph should scale properly
✅ Pass
GPH-05
Resize the program window after graph is displayed
Graph should resize dynamically and not distort
✅ Pass

Test 3:
UI Functional Tests (Buttons, Reports)
Test ID
Test Scenario
Expected Result
Pass/Fail
UI-01
Click "Total Items" button
Opens Excel and highlights relevant section
✅ Pass
UI-02
Click "Low Stock" button
Opens Excel and highlights relevant section
✅ Pass
UI-03
Click "Recently Added" button
Opens Excel and highlights relevant section
✅ Pass
UI-04
Click "Generate Report" button
Generates bar graph with updated numbers
✅ Pass
UI-05
Click "Generate Report" twice
Graph updates dynamically, does not duplicate results
✅ Pass
UI-06
Click rapidly on buttons (stress test)
Application does not crash, responds correctly
✅ Pass

Test 4:
Error Handling & Edge Cases
Test ID
Test Scenario
Expected Result
Pass/Fail
ERR-01
Attempt to load missing background image
Shows error message instead of crashing
✅ Pass
ERR-02
Click on an action button while Excel is not installed
Shows "Excel Not Found" error
✅ Pass
ERR-03
Enter text in numerical slots of Excel
Application ignores or flags invalid data
✅ Pass
ERR-04
User inputs special characters in Excel
Application ignores or flags invalid data
✅ Pass
ERR-05
Close the program while generating a report
Application closes cleanly without freezing
✅ Pass

Test 5:
Performance & Stability Tests
Test ID
Test Scenario
Expected Result
Pass/Fail
PERF-01
Open and close the application 10 times in a row
No crashes, functions correctly
✅ Pass
PERF-02
Open Excel, generate report, close Excel, repeat multiple times
No memory leaks, functions correctly
✅ Pass
PERF-03
Simultaneously click multiple buttons
Program remains stable, processes requests sequentially
✅ Pass