Skip to main content

Functional Testing Template - One that works

I have seen a lot of templates around for capturing functional testing test cases but I have not been happy with many of them - so I started an exercise to take the good aspects of many of them and come up with a testing template that works. I have been using this template for close to 6 months now and it is working very well so I decided to publish it so that others can benefit from it. I have published the template using Google Docs and have opened the template to changes. Before going any further lets first open the template.

Functional Testing Template


The key requirements for me were the following
  1. Easy to understand and use
  2. Should contain a status sheet that will give me the exact position of the testing phase
  3. Have clear definitions for everything such as severity, status and priority
  4. Come up with a consistent naming convention for the test cases
  5. Be able to organize the test cases
Let me start by explaining what the sheets in the template contain
  • Status - Gives an overall status of the application. There should be one row for each page/screen that is being tested.
  • Page 1 - Each page/screen in the application will have one sheet for all the test cases that are specific for that page.
  • Application - All the test cases that are application specific but not related to any one page in particular go in this sheet.
  • Test Data - Any test data that needs to be created for the test cases to run needs to be specified in this sheet.
  • Glossary - This sheet explains the meaning of all the severities, priorities, status, test case naming convention and so on.

Page Sheet

This sheet along with the application sheet are the most important sheets in this template. This sheet captures all the test cases related to the page being tested. For each page/screen in the application being tested we need to have one sheet in the excel sheet. This sheet is broken up according to what is being tested in the page. These sections are
  • Navigation - Test cases for all the links on this page that takes the user away from this page.
  • User Interface - look and feel - Test cases related to how the page should look and behave. What is the size and shape of the various controls, images and so on.
  • Dropdowns and Look Ups - Default values in any of the drop downs or lookup controls.
  • Functionality - Functionality of the page, hiding and showing of sections of the page
  • Error Handling - System errors - Test cases for system errors such as no DB connection or fatal errors.
  • Error Handling - Mandatory field checks - Test cases related to mandatory fields checking
  • Error Handling - Field type checks - Test cases related to values that can be given in fields such as checking for alphabets in a phone number, date validation, etc
  • Error Handling - Business Rules checks - Test cases related to business rules on a page such as checking if the username is already existing and so on.
If there are no test cases for a section then we just write "There are no test cases". This way we are ensuring that we are capturing all the test cases. Sometimes we may find that a page has something that is not covered but is specific to that page so we just add a new section. What we have attempted to do through this template is to come up with a process to make sure we capture all the test cases in a consistent and precise manner.

Application Sheet

In this sheet we capture all the test cases that are across the application. Here we have the following sections. When writing the page test cases we try to keep out test cases related to access and permissions. The reason is because this has to be tested at an application level.
  • Application Security - All test cases related to login and logout. Unauthorized access checks and so on.
  • Role Based Security - After the user logs in based on their role they can do and cannot do certain actions. This web page attempts to capture all the test cases related to this.
  • Transaction Based Security - Based on the action the user is doing they may be some some checking that needs to be done. Test cases related to this needs to be captured here.


Anonymous said…
Hi ,

I'm Rakesh from hyderabad working as a s/w tester. I want to learn more abt functional testing for different types of architectures. If u have test cases or any material which shows a directions for it please send me.
my email id is
Sudeep Dsouza said…
As far as I am aware it does not matter what kind of architecture you are developing on - in all the cases the functional testing is exactly the same. If you are doing white box testing then you will have to be aware of the architecture but in functional testing you mostly do black box testing and it really does not matter what the underlying architecture is.
Anonymous said…
Hi Sudeep

Thank you for sharing this information, I am unable to download or review the link to the spreadsheet, maybe you could help by posting a new one?

Great article by the way.

Sudeep Dsouza said…
@anonymous : Can you let me know what is the error you are getting when you click on the link.

Popular posts from this blog

Online Encumbrance Certificate in Andhra Pradesh

You can get an encumbrance certificate online in AP now. In order to get it you have to perform the following steps. Go to the website Click on Citizen Services -> encumbrance -> Search Click on Yes in the screen that appears Fill in the entries that appear in the search screen. You will have to get quite a few details in so it will help to have a copy of the registration document available with you. Once you finish entering all the details click on Submit. It will then go to a new page with the list of items that matched the search displayed. Click on the check box of the list of encumbrance certificates that are needed and click on submit. This will open a new popup window with the encumbrance certificate. You can then print this certificate. What is this useful for Anyone buying new property can go and verify the current owners of the property that is shown on this certificate in the column Name of PartiesExecutant(EX)&Claimants(CL) with the copy of

Cricket Grounds in Hyderabad

This is a repost of the article I published on the 10th of Jan, 2008 as I have added a new ground - Lahari Resorts. View Larger Map In this post I will try and update the list of cricket grounds that i know in Hyderabad. The grounds that I have listed till now are MCH Play ground, Ameerpet Francis (Do not have the contact number but go to the ground and ask for him). The charges are Rs. 1100 for the ground. They do not charge for anything more. You get the ground from 9:00 AM to 4:00PM. The ground is small. Welfare Center, Sanath Nagar Dhanraj Babu (+91 9394556356). The charges are Rs. 1100 for the ground. They charge you an additional Rs. 500 for the mat and Rs. 100 for cleaning and drawing lines and stuff. They are supposed to give you the ground from 9:00 AM to 4:00PM but what they do is that they pocket extra money from another team wanting to play and give the ground out to them for the remainder of the day assuming that you won't play for the whole day. So what happened th

Problogger guest post

Today my guest post appeared on . I wrote about 9 Tips to Start Blogging Successfully . Let me give you a bit of a background about where this article originated from. I have been blogging for close to 3 years now but I have been doing it seriously only for the last 2 months. I then analysed what were the things that I should have done in order to have become a successful blogger based on what I have noticed on the ones that have become successful. The final analysis of my study is what I put into that article and it is what I am trying to implement since the last 2 months. Reading the comments it was exhilarating to notice that some of the readers actually thought Darren was writing the post :-). It was also nice to notice that many readers agreed with my analysis and that strengthened my belief that what I have written if followed will work. How did I get to do a guest post on ? A little more than a week ago Darren invited bloggers to do guest pos