Quick Learn Automation

'****************************************************************** ' 'GETCELLVALUE ' 'PRECONDITIONS: ' --Excel workbook to be read is open and has focus. ' 'PARAMETERS: ' sheet - The name or index of the sheet to read from ' colnum - Column of the cell to read ' rownum - Row of the cell to reat ' 'RETURN VALUE : Contents of the designated cell. 'Created By : Jai '****************************************************************** Public Function GetCellValue(sheet, colnum, rownum) 'As String Dim Excel 'Get the Excel object Set Excel = GetObject(,"Excel.Application") GetCellValue = Excel.ActiveWorkbook.Worksheets(sheet).cells(rownum,colnum).Value Set Excel = Nothing End Fu

'Testsettings '-------------------------------- '=================================================== '' Function Name : Testsettings '' Created By : Jay '' Description : Configuring the Test settings ' Parameters :-- '' Created : 08 July 2008 '=================================================== Dim App 'As Application Set App = CreateObject("QuickTest.Application") App.Launch App.Visible = True App.Test.Settings.Launchers("Web").Active = False App.Test.Settings.Launchers("Web").Browser = "IE" App.Test.Settings.Launchers("Web").Address = "http://newtours.mercury.com " App.Test.Settings.Launchers("Web").CloseOnExit = True App.Test.Settings.Launchers("Windows Applications").Active = True App.Test.Settings.Launchers("Windows Applications").Applications.RemoveAll App.Test

'-------------------------------------------------------------------------' Method : CreateImageFromClipBoard' Author : Jai Purpose : It gets the clipboard image and convert as a image file.' Parameters: FileName - String, contains the BMP file name' iIndex - Integer, contains the Worksheet index' Returns : String. The replaced file name it gives.' Caller : - Nil' Calls : - Nil' ------------------------------------------------------------------------- Sub CreateImageFromClipBoard(sFileName) Dim wshShell,ShellReturnCode, sCmdExec Set WshShell = WScript.CreateObject("WScript.Shell") sCmdExec = "D:\autostuff\i_view32.exe /silent /clippaste /convert="& sFileName ShellReturnCode = WshShell.Run(sCmdExec, 1, True) End Sub

Risk analysis is an important discipline for assuring the safety, reliability and quality of products and processes. It is also an area subject to increasing regulatory pressures. In this article we discuss and compare the two most widely used tools for risk analysis. The design and manufacture of safe medical devices inherently includes risk reduction as a key objective. We would all agree that risk reduction is a desirable goal, but we may not understand the principles and tools for achieving this goal. The investigative and analysis activities at the core of risk reduction are generally referred to as "risk analysis" or "failure analysis." Structured engineering disciplines for failure analysis were developed as part of the United States space and defense efforts of the 1960s. From these beginnings, failure analysis as an engineering discipline has spread into the engineering design and development practices of general aerospace and high-tech industries of t

Performance Testing can be categorized as follows: - Benchmark Testing. Contention Testing. Performance profiling. Load Testing. Stress Testing. Volume Testing Configuration Testing Recovery Testing BENCHMARK TESTING It is a kind of performance testing that compares the performance of new target-of-test to existing software. It provides performance comparison for software, hardware, and systems. It is used to understand that how a new product will withstand in the competitive environment CONTENTION TESTING This test, a test that does a system can handle multiple demands of clients on the same resource. A resource could be data records, memory or something else which could be accessed by clients. It cause the application to fail by accessing same resource so that the underlying defects can be identified, analyzed, fixed, and prevented in the future PERFORMANCE PROFILING This is the kind of performance testing that verifies that a system must perform corr

In this module, you will learn: Installation/Un-Installation Testing. Factors to look for in Installation Testing. Types of Installation. Types of Licensing. Installation testing is any testing that takes place at a user's site with the actual hardware and software that will be part of the installed system configuration. The testing is accomplished through either actual or simulated use of the software being tested within the environment in which it is intended to function. Installation testing is often an overlooked component of testing. This type of testing is performed to ensure that all Install features and options function properly. It is also performed to verify that all necessary components of the application are, indeed, installed. Tests focused on ensuring the target-of-test installs as intended on different hardware or software configurations and under different conditions (such as insufficient disk space or power interrupt). This test is imple

The most popular Black box testing techniques are :- Equivalence Partitioning. Boundary Value Analysis. Cause-Effect Graphing. Error-Guessing. Equivalence Partitioning : -A software testing technique that involves identifying a small set of representative input values that invoke as many different input conditions as possible. It is a black box testing technique that divides the input domain of a program into classes of data from which test cases can be derived. Equivalence classes may be defined according to the following guidelines. If an input condition specifies a range, one valid and two invalid equivalence classes are defined. If an input condition requires a specific value, one valid and two invalid equivalence classes are defined. If an input condition specifies a member of set, one valid and one invalid equivalence classes are defined. If an input condition is Boolean, one valid and one

Black Box Testing also known as Behavioral testing is a software testing technique whereby the internal workings of the item being tested are not known by the tester. For example , when black box testing is applied to software engineering, the tester would only know the "legal" inputs and what the expected outputs should be, but not how the program actually arrives at those outputs. It is because of this that black box testing can be considered testing with respect to the specifications, no other knowledge of the program is necessary For example , in a black box test on software design the tester only knows the inputs and what the expected outcomes should be and not how the program arrives at those outputs. The tester does not ever examine the programming code and does not need any further knowledge of the program other than its specifications. Black Box testing attempts to find errors in the following cate

Software Testing is one of the important phases in SDLC because of the following reasons: - • Its helps to verify that all the software requirements are implemented correctly or not. • Identifying defects and ensuring they are addressed before software deployment. Because if any defect will found after deployment and force to fixed it, than the correction cost will much higher than the cost of it fixed it at earlier stage of development. • Effective testing is demonstrates that software-testing function appear to be working according to specification, that behavioral and performance requirement appear to have been met. • Whenever any system is developed in different components, its helps to verify the proper integration/interaction of each component to rest of the system. • Data collection as testing is conducted provide a good indication of software reliability and some indication of software quality as a whole.

Testing is the process of testing the functionality and correctness of software by executing it and it assesses or measures the software quality which according to Philip Crosby is defined as “Conformance to Requirements”. If a software product is of high quality, it will meet the customer’s needs. The customer will feel that the product is excellent and according to his requirements. Joseph Juran distinguishes between Customer Satisfiers and Dissatisfiers as key dimensions of quality: – Customer Satisfiers • the right features • adequate instruction – Dissatisfiers • unreliable • hard to use • too slow • incompatible with the customer’s equipment DIMENSIONS OF QUALITY The Quality dimensions described by McCall represent one of the number of suggested “Checklists” for Software Quality. Every area of the program cannot be tested fully against a list of quality d

VERIFICATION & VALIDATION Verification is the process of confirming that software meets its specification. It involves reviews and meetings to evaluate documents, plans, code, requirements, and specifications. This can be done with checklists, issues lists, walkthroughs, and inspection meetings.. Validation is the process of confirming that it meets the user’s requirements. Validation typically involves actual testing and takes place after verifications are completed. For Example: - The Hubble space telescope was launched into the orbit around the earth, and it uses the large mirror to magnify the objects. Extreme precision and accuracy was the major concern for the construction of the mirror, but actually testing the mirror was not feasible. Therefore, the only means to check it was to carefully measure all its attributes and compare the measurements with the specifications. After the measurements, as soon as it was launched, the images it returned was out of focus. The reason for

VERIFICATION & VALIDATION Verification is the process of confirming that software meets its specification. It involves reviews and meetings to evaluate documents, plans, code, requirements, and specifications. This can be done with checklists, issues lists, walkthroughs, and inspection meetings.. Validation is the process of confirming that it meets the user’s requirements. Validation typically involves actual testing and takes place after verifications are completed. For Example: - The Hubble space telescope was launched into the orbit around the earth, and it uses the large mirror to magnify the objects. Extreme precision and accuracy was the major concern for the construction of the mirror, but actually testing the mirror was not feasible. Therefore, the only means to check it was to carefully measure all its attributes and compare the measurements with the specifications. After the measurements, as soon as it was launched, the images it returned was out of focus. The reason for