- Unit Testing Template For Etl File Free
- Testing Template For Electronic Health Record
- Etl Testing Tutorial
Every day I keep on getting several requests for Test Case Template. And I'm surprised that many testers are still documenting test cases with Word docs or Excel files.
Etl Requirements Template Pretty Etl Mapping Document Template. Etl Requirements Template Pretty Etl Mapping Document Template Photos Example ETL Testing or Data Warehouse Testing Tutorial ETL Testing or Datawarehouse Testing: Ultimate Guide.
Most of them prefer excel spreadsheets because they can easily group test cases by test types and most importantly they can easily get test metrics with Excel formulas. But I’m sure that as the volume of your tests goes on increasing, you will find it extremely difficult to manage.
If you are not using any test case management tool, then I would strongly recommend you to use an open-source tool to manage and execute your test cases.
Test case formats may vary from one organization to another. But using a standard test case format for writing test cases is one step closer to set up a testing process for your project.
It also minimizes ad-hoc testing that is done without proper test case documentation. But even if you use standard templates, you need to set up test cases writing, review & approve, test execution and most importantly test report preparation process, etc by using manual methods.
Also if you have a process to review the test cases by the business team, then you must format these test cases in a template that is agreed by both the parties.
Recommended Tools:
Before continuing to the test case writing process, we recommend downloading these test case management tools. This will ease your test plan and test cases writing process mentioned in this tutorial.
#1) TestRail
=> Download TestRail Test Case Management Tool
#2) TestMonitor
TestMonitor – Top-level online Test Management. Revolutionary easy.
TestMonitor is an end-to-end test management tool for every organization. A simple, intuitive approach to testing. Whether you’re implementing enterprise software, need QA, building a quality app or just need a helping hand in your test project, TestMonitor has you covered.
=> Visit TestMonitor Website
Here is how to make this manual test case management process a bit easier with the help of simple testing templates.
Note:I've listed the maximum number of fields related to a test case. But it is advised to use only those fields which are used by your team. Also, if you think any field used by your team is missing from this list, then feel free to add it to your customized template.
What You Will Learn:
Standard Fields of a Sample Test Case Template
There are certain standard fields to be considered while preparing a Test case template.
Several standard fields of a sample Test Case template are listed below.
Test case ID: Unique ID is required for each test case. Follow some convention to indicate the types of the test. E.g. ‘TC_UI_1' indicating ‘user interface test case #1'.
Test priority (Low/Medium/High): This is very useful while test execution. Test priority for business rules and functional test cases can be medium or higher whereas minor user interface cases can be of a low priority. Test priority should always be set by the reviewer.
Module Name: Mention the name of the main module or the sub-module.
Test Designed By: Name of the Tester.
Test Designed Date: Date when it was written.
Test Executed By: Name of the Tester who executed this test. To be filled only after test execution.
Unit Testing Template For Etl File Free
Test Execution Date: Date when the test was executed.
Test Title/Name: Test case title. E.g. verify login page with a valid username and password.
Test Summary/Description: Describe the test objective in brief.
Pre-conditions: Any prerequisite that must be fulfilled before the execution of this test case. List all the pre-conditions in order to execute this test case successfully.
Dependencies: Mention any dependencies on the other test cases or test requirement.
Test Steps: List all the test execution steps in detail. Write test steps in the order in which they should be executed. Make sure to provide as many details as you can. Tip – In order to manage a test case efficiently with a lesser number of fields use this field to describe the test conditions, test data and user roles for running the test.
Test Data: Use of test data as an input for this test case. You can provide different data sets with exact values to be used as an input.
Expected Result: What should be the system output after test execution? Describe the expected result in detail including message/error that should be displayed on the screen.
Post-condition: What should be the state of the system after executing this test case?
Actual result: Actual test result should be filled after test execution. Describe the system behavior after test execution.
Status (Pass/Fail): If actual result is not as per the expected result, then mark this test as failed. Otherwise, update it as passed.
Notes/Comments/Questions: If there are some special conditions to support the above fields, which can’t be described above or if there are any questions related to expected or actual results then mention them here.
Add the following fields if necessary:
Defect ID/Link: If the test status is failed, then include the link to the defect log or mention the defect number.
Test Type/Keywords: This field can be used to classify the tests based on test types. E.g.functional, usability, business rules etc.
Requirements: Requirements for which this test case is being written for. Preferably the exact section number of the requirement doc.
Attachments/References: This field is useful for complex test scenario in order to explain the test steps or expected result using a Visio diagram as a reference. Provide the link or location to the actual path of the diagram or document.
Automation? (Yes/No): Whether this test case is automated or not. It is useful to track the automation status when test cases are automated.
With the help of above fields, I've prepared an example test case template for your reference.
Download Test Case Template with Example (Format #1)
– Test case DOC file template and
– Test case Excel file template
Also, here you can refer few more articles on writing effective test cases. Use these test writing guidelines and the above template to write and manage the test cases effectively on your project.
Sample Test Cases:
Tutorial #1:180+ Sample Test Cases for Web and Desktop Applications
Tutorial #2:100+ Ready-to-Execute Test Scenarios (Checklist)
One More Test Case Format (#2)
Undoubtedly, the test cases will differ depending upon the functionality of the software that it is intended for. However, given below is a template which you can always use for documenting the test cases without bothering about what your application is doing.
Sample Test Cases
Based on the above template, below is an Example that showcases the concept in a much understandable way.
Let's assume that you are testing the login functionality of any web application, say Facebook.
Below are the Test Cases for the same:
Testing Template For Electronic Health Record
=> Download the above test case format with example data
Test Case Example for Manual Testing
Below given is an Example of a live project that demonstrates how all the above-listed tips and tricks are actually implemented.
[Note: Click on any image for an enlarged view]
Conclusion
Personally, I prefer to use a test case management tool. You can start with an open source tool. It will be a good addition to your efforts to set up the testing process and meanwhile, it will also save a lot of time instead of manually maintaining these documents.
We have also seen test case templates and a few examples using very good, quality documentation. Hope this article would have been helpful to you.
Etl Testing Tutorial
We would be glad to know your thoughts, comments/suggestion about this article.
PREV Tutorial | NEXT Tutorial
Comments are closed.