Tuesday, January 27, 2015

Sample Test case format in Excel sheet

Starting of testing first time it is need to know how to write test case. Easy to use and Easy to Understand. Many organization now days started to use of  HP Quality center for test case writing Execution and complete testing process . Some organization use Opensource tools like Testlink , also some organization use basic approach is to use of Excel sheet. It's very simple way to start with testing. Here i am prescribing simple format of test case in Excel



Download Sample Test case format in Excel 


Below are the details of simple software test case format 

Project Name :-  Here logical have to write project name . 
Test Case ID :-   It's require to easily identify test case and providing unique id to each test case
Test Case Name :- Name of Test case
Test Priority:-  It's always good to give test case priority. So in case we need to run test cases only high level or priority base then it would be easy.
Product / Module Name:-  Here you can mention Product name or module name. Logically there may be many modules or application in project to test so its easy to categorize test case for specific module.
Description :- You can write detail description about test case and Functionality going to test
Prerequisite :- In every testing there may be some prerequisite need to be completed without it test cannot be performed. It's good to mention prerequisite in test case so executor can verify prerequisite before starting of execution of test case

This is all about header level of test case. Now we will see about detail test case columns 

Step number :- Logically it starts from number 1 its just a step number to identify each step
Test step :- Details about step 
Test data :- Test data is data which is required for testing . E.g- step is Enter user name then test data ill be username "ABCD"
Expected Result :-  Result expected after performing respected step
Actual result :-  Actual result received after performing respected step
Pass/ Fail :- It's status based on actual and expected result. status need to update
Defect ID :- If test case is fail then need to log defect  you can mention defect id here 
Notes :-   Here you can add notes 

48 Post a Comment:

Steve Hawks said...

The future of software testing is on positive note. It offers huge career prospects for talented professionals to be skilled software testers. Software testing training|Software training|Loadrunner Training in Chennai | Qtp training in Chennai

mythily mythu said...

Greens Technology's. the leading software Training & placement centre Chennai & (Adyar)
ibm-message-broker training in chennai

mythily mythu said...

Greens Technology's. the leading software Training & placement centre Chennai & (Adyar)
pega training in chennai

UMA MAHESWARI said...

Great job. Thanks...
informatica training in chennai

UMA MAHESWARI said...

• Need help with qtp? have a doubt in qtp? call me 8939925577 and refer software testing help website.
selenium training in chennai

Iqbal Dlk said...

very useful blogs.
hotels near us consulate chennai
hotels near apollo hospital chennai
hotels near uk embassy chennai
hotels near german consulate chennai
hotels near sankara nethralaya chennai
business class hotels in chennai

Iqbal Dlk said...

very nice and informative blog
java training in chennai
dot net training in chennai

John said...

I know selenium testing.I need a job in channai. could you help me with this?

1croreprojects said...


Thanks for sharing this valuable information.
java projects in chennai
dotnet projects in chennai
ns2 projects in chennai

Xplorant Seo said...

Wonderful blog.. Thanks for sharing informative blog.. its very useful to me..

iOS Training in Chennai

iqbal12 Dlk said...

very nice and informative blog
cloud computing projects chennai

Rasool Bevi said...

I really enjoyed while reading your article, the information you have delivered in this post was damn good. Keep sharing your post with efficient news.
Regards,
Software testing training|Software training|Software testing training in chennai

sunitha vishnu said...

This is excellent information. It is amazing and wonderful to visit your site.Thanks for sharing this information&its very useful to me...
Android training in chennai
Ios training in chennai

john stany said...

This article is very much helpful and i hope this will be an useful information for the needed one. Keep on updating these kinds of informative things...

Android App Development Company

Sharon Sandy said...

great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
web design Company
web development Company
web design Company in chennai
web development Company in chennai
web design Company in India
web development Company in India

john stany said...

Nice it seems to be good post... It will get readers engagement on the article since readers engagement plays an vital role in every blog.i am expecting more updated posts from your hands.
iOS App Development Company
iOS App Development Company

louis philip said...

I wondered upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I’ll be subscribing to your feed and I hope you post again soon.

Fitness SMS
Fitness Text
Salon SMS
Salon Text
Investor Relation SMS
Investor Relation Text

isabella jacob said...

it is really amazing...thanks for sharing....provide more useful information...
Mobile app development company

Jeanne said...

great and nice blog thanks sharing..I just want to say that all the information you have given here is awesome...Thank you very much for this one.
web design Company
web development Company
web design Company in chennai
web development Company in chennai
web design Company in India
web development Company in India

louis philip said...

This article is very much helpful and i hope this will be an useful information for the needed one. Keep on updating these kinds of informative things...
Texting API
Text message marketing
Digital Mobile Marketing
Sms API
Sms marketing

Tanika Co Valda said...

Very much useful article. Kindly keep blogging

Java Training in Chennai

Java Online Training India

suresh H said...

Pretty good post. I just stumbled upon your blog and wanted to say that I have really enjoyed reading your blog posts. Any way I'll be subscribing to your feed and Ihope you post again soon. Big thanks for the useful info.
AngularJS Training Institute in Chennai
AngularJS Cetification Training in Chennai
AWS Training in Chennai
AWS Devops Training in Chennai
DevOps Certification in Chennai
DevOPs Certification Training Institute in Chennai
Best AngularJS Training in Chennai
AngularJS Training in Chennai

Govind Raj said...

i am really happy to say it’s an interesting post to read . I learn new information from your article , you are doing a great job . Keep it up

PSD to Wordpress
wordpress website development

mithra R said...

I wish to show thanks to you just for bailing me out of this particular trouble.As a result of checking through the net and meeting techniques that were not productive, I thought my life was done.
Java Training Institute Bangalore

vijay antony said...

I feel really happy to have seen your webpage and look forward to so many more entertaining times reading here. Thanks once more for all the details.

Java Training Institute Bangalore

Best Java Training Institute Chennai

kanaga seo said...

Nice article Thanks for sharing this article Wonderful information from this website Thanks !!!

Embedded training in chennai | Embedded training centre in chennai | Embedded system training in chennai | PLC Training institute in chennai | IEEE final year projects in chennai | VLSI training institute in chennai

kavitha Wiztech said...

Thank you a lot for providing individuals with a very spectacular possibility to read critical reviews from this site...

Embedded training in chennai | Embedded training centre in chennai | Embedded system training in chennai | PLC Training institute in chennai | IEEE final year projects in chennai | VLSI training institute in chennai

sobiga J said...

Thank you for this Useful Blog!
BE mini project center in Chennai | Phd project center in chennai

Veni said...

Excellent Article!
Thanks for sharing that wonderful useful information,given contecn was very excellent and easily observe all provided information.

Final Year Bca Project Centres Chennai | Final Year Bsc Project Centres Chennai.

Ram priya said...

Very nice post here and thanks for it .I always like and such a super contents of these post.Excellent and very cool idea and great content of different kinds of the valuable information's.

Data Science Training in Chennai
Data science training in bangalore
Data science online training
Data science training in pune
Data science training in kalyan nagar
Data science training in Bangalore
Data science training in tambaram

nivatha said...

Nice post. By reading your blog, i get inspired and this provides some useful information. Thank you for posting this exclusive post for our vision. 
Devops training in Chennai
Devops training in Bangalore
Devops training in Pune
Devops Online training
Devops training in Pune
Devops training in Bangalore
Devops training in tambaram

Nila shri said...

Read all the information that i've given in above article. It'll give u the whole idea about it.
AWS training in Chennai
selenium training in Chennai

nivatha said...

Thanks for the good words! Really appreciated. Great post. I’ve been commenting a lot on a few blogs recently, but I hadn’t thought about my approach until you brought it up. 
Data Science Training in Chennai
Data science training in bangalore
Data science online training
Data science training in pune
Data science training in kalyan nagar

suresh ravi said...

Existing without the answers to the difficulties you’ve sorted out through this guide is a critical case, as well as the kind which could have badly affected my entire career if I had not discovered your website.


ccna training in chennai



ccna training in bangalore


ccna training in pune

amilu B said...

Were a gaggle of volunteers as well as starting off a brand new gumption within a community. Your blog furnished us precious details to be effective on. You've got completed any amazing work!
java training in chennai | java training in bangalore

java online training | java training in pune

selenium training in chennai

selenium training in bangalore

genga g said...
This comment has been removed by the author.
genga g said...

Excellent blog, I wish to share your post with my folks circle. It’s really helped me a lot, so keep sharing post like this

angularjs Training in chennai
angularjs Training in chennai

angularjs-Training in tambaram

angularjs-Training in sholinganallur

Deepika Analy said...

This is an awesome post.Really very informative and creative contents. These concept is a good way to enhance the knowledge.

iOS Training in Chennai
Android Training in Chennai
Mobile Apps Training in Chennai

thulasi ragini said...

Greetings. I know this is somewhat off-topic, but I was wondering if you knew where I could get a captcha plugin for my comment form? I’m using the same blog platform like yours, and I’m having difficulty finding one? Thanks a lot.

Amazon Web Services Training in Tambaram, Chennai|Best AWS Training in Tambaram, Chennai

Amazon Online Training


AWS Training in JayaNagar | Amazon Web Services Training in jayaNagar



AWS Training in Rajaji Nagar | Amazon Web Services Training in Rajaji Nagar


Amazon Web Services Training in Pune | Best AWS Training in Pune

AWS Online Training | Online AWS Certification Course - Gangboard

mouni yoga said...

I would really like to read some personal experiences like the way, you've explained through the above article. I'm glad for your achievements and would probably like to see much more in the near future. Thanks for share.
python online training
python training course in chennai
python training in jayanagar

sarah blossom1234567 said...

The knowledge of technology you have been sharing thorough this post is very much helpful to develop new idea. here by i also want to share this.
Devops Training in pune

sarah blossom1234567 said...

Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
Devops Training in pune

Rohini .R said...

It is amazing and wonderful to visit your site.Thanks for sharing this information,this is useful to me...


Selenium online Training | Selenium Training in Pune | Selenium Training in Bangalore

amala jst said...

A very nice guide. I will definitely follow these tips. Thank you for sharing such detailed article. I am learning a lot from you.

rpa training in electronic-city | rpa training in btm | rpa training in marathahalli | rpa training in pune

sathya shri said...

Your good knowledge and kindness in playing with all the pieces were very useful. I don’t know what I would have done if I had not encountered such a step like this.
angularjs Training in electronic-city

angularjs online Training

angularjs Training in marathahalli

angularjs interview questions and answers

angularjs Training in bangalore

angularjs Training in bangalore

sathya shri said...

I believe there are many more pleasurable opportunities ahead for individuals that looked at your site.

angularjs interview questions and answers

angularjs Training in bangalore

angularjs Training in bangalore

angularjs Training in chennai

automation anywhere online Training

Safety Professionals said...

Your very own commitment to getting the message throughout came to be rather powerful and have consistently enabled employees just like me to arrive at their desired goals.
iosh course in chennai

Pavel Co Ebele said...

Great Article
Dot Net Based Projects for Final Year Students
FInal Year Project Centers in Chennai


JavaScript Training in Chennai
JavaScript Training in Chennai

Post a Comment