| Project Case Study - Online Survey Measurement Portal |
|
| Client had required a web application for a charitable association which provides funds to a set of 200 or more schools. Client administers survey to monitor the correct usage of funds on behalf of its sponsor. |
|
| Please fill up the form below and we will submit a proposal for your project. Alternatively, you can send
email to contact@optionm.net with the project
requirements. |
|
|
|
|
|
 |
| Project Description |
|
|
| Client was looking for a web application using Asp.Net (scripting done in VB.Net) and MS SQL Server on Windows 2003 server. CLIENT was working for a charitable association which provides funds to a set of 200 or more schools. CLIENT administers surveys to monitor the correct usage of funds on behalf of its client. This was currently done using EXCEL sheets exchanged over e-mail. CLIENT also anticipates such scenario with several clients in future and would like to develop a web application where the survey and validations can be provided as input and the responses can be aggregated in a web database both by reading off completed survey EXCEL sheets uploaded by clients as well as directly entered responses on the web interface as per the survey. FAR POINT SPREAD control has been proposed to create a look and feel similar to EXCEL on web interface. Query Filer was needed to download survey response either comprehensively or selectively. |
|
|
|
| Click here to submit your project requirements to Option Matrix, India. |
| Back to top |
 |
| Capability Analysis |
|
|
| This section provides the list of capabilities that the application was provide to various types of users of the application. The following types of users were considered in our design: |
| Administrator |
| Clients |
|
| In the following two sections, we have described the key capabilities that our application has provided to the two user types above. |
|
| Administrator Features |
| Upload a survey in a EXCEL workbook containing up to 256 worksheets, with first worksheet containing instructions and some or all other worksheets containing columnar or tabular formats for the user to enter responses for the survey. The cells must be unprotected and no cells should be merged. LIMITATION - Name of each worksheet must be a single word without spaces |
| The uploaded survey template was stored in three tables: |
| SURVEY |
| Survey ID |
| Survey Name |
| Date Created |
| Notes |
|
| WORKSHEET |
| Worksheet ID |
| Survey ID |
| Worksheet Name |
|
| STRUCTURE |
| Structure ID |
| Worksheet ID |
| Row Number |
| Column 1 |
| Column 2 |
| Column 256 |
|
|
| The uploaded survey can read off the database and displayed in edit mode in the web interface for any fine tuning as and if required. Updates was stored in database and can be exported back to a downloadable EXCEL sheet |
| Validations can be provided on the web interface for some or all of the cells in each worksheet. |
| Clients can be managed (add / edit / delete / view all) with attributes as Name, Address, Phone, e-mail, City, State, Country, User Name, Password and Notes |
| Clients can be assigned to surveys and this allocation can be edited. |
| Survey requests can be deleted and this was purge the response associated with that request from the web database. |
| Clients were notified by e-mail in case of a survey request or if a survey request was cancelled |
| Survey responses can be filtered (using checkboxes) by criteria such as Client Set, Worksheet Set and Column Set / Row Set by Worksheet. Query result was display on web interface and can be exported to a downloadable EXCEL sheet or Access MDB file. Comprehensive responses for a survey can be downloaded by using a "Select All" option. |
| LIMITATION - Only one survey was covered in a download file and administer must download separate files for each survey response set or for each query |
| SUGGESTION - Survey Template must be locked against editing after they was submitted / published for response to clients |
|
| Client side features |
| Clients can enter their user name and password to login |
| Client can edit their profile |
| Client can view list of survey requests and status |
| Clients can download the survey workbook |
| Clients can fill the survey workbook offline and upload file in web interface. The sheet data was read by the application and validated. Validation errors was display on screen and marked workbook with error summary was available for download |
| Corrected workbook can be uploaded again and response data was updated in database. |
| Survey workbook can also be filled online using the web interface and validation can be done at any stage by submitting the sheet to the server. Partial save and return later option was supported. |
| LIMITATION - Unlike a desktop application, validation error summary was displayed only when the full or partial response sheet was submitted to the server as doing a post back for each cell was cumbersome and irritating for a web user. Web Application has several other advantages over a desktop application and was hence the preferred option. |
|
|
|
| Click here to submit your project requirements to Option Matrix, India. |
| Back to top |
 |
| Technology Architecture |
|
|
| The OS was used in this application Window 2003 Server and RDBMS was MS SQL Server 2000 / 2003. Web Programming was done in ASP.Net using VB.Net for code behind. Farpoint Spread Web Control (Third Party) was used in web forms. Active X control was put in BIN folder to read and write into EXCEL sheets. |
|
|
|
| Back to top |
 |
| Tangible Benefits |
|
|
| Admin has able to edit the uploaded survey database and display in edit mode in the web interface for ant fine tuning as and if required. Update has stored in database & exported back to a downloadable EXCEL sheet |
| Application feature Survey workbook has also been filled online using the web interface and validation has been done at any stage by submitting the sheet to the server. Partial save and return later option has supported. |
|
|
|
|
| Click here to submit your project requirements to Option Matrix, India. |
| Back to top |
|
| Option Matrix Featured Case Studies |
|
| Option Matrix Whitepapers |
|
|
|
|
| Portal for Multi-location Hospital |
| The client was a healthcare provider (multi-location hospital) for the local resident patients having sleeping disorders. Option Matrix's scope of consulting was for their Seattle, |
|
|
|
| Health Fitness Portal |
| Client was establishing a Health Fitness Center at California established in June 2006 by a team of local Antelope Valley residents. It was offered full complement of new and innovative |
|
|
|
| Sleep Disorders Hospital Application |
| This project was the company service portal of "Client" for patients suffering from sleep disorders. It was information about the company, key personnel, HIPPA privacy, education resources, |
|
|
|
| Batteries Ecommerce Portal |
| The objective was to design an e-commerce website for Client to display their catalog of batteries online and collect orders which was forwarded by e-mail to be serviced by a third |
|
|
|
| Spices & Herbs Ecommerce Website |
| The overall purpose of this project was to develop an intuitive and professional spice and herbal ecommerce web site. This web site was accessed by site visitors, members (retail consumers), |
|
|
|
| Portal for Web Design Firm |
| The client, a web design firm located in USA. It positions itself as an idea company and offers services such as website design / development coupled with creative marketing, Internet |
|
|
|
| Dynamic Content Portal |
| The overall purpose of the project was to redesign a database driven dynamic version of the existing site including migration of existing content on the site to the new site design and |
|
|
|
| Networking Systems Ecommerce |
| The USA Based client was one of the leading provider of used and Refurbished Cisco Systems, Extreme Networks, Juniper and Foundry equipment. The client has the experience |
|
|
|
| 3rd Party Order Fulfillment |
| This project envisages provision of e-commerce for people in continent B countries who cannot do such transactions in normal course with US based online retailers as shipments |
|
|
|
| Multi-lingual Recruiting Portal |
| This project was for building a specialized job portal for Tourism Schools in Austria. This institutions offer training that enables college students or graduates to get trained for jobs in hotels, |
|
|
|
| Corporate Web Portal |
| The client was focused on providing process control solutions to the manufacturing and related industries. Established in 1989, this Client was a BSI-certified ISO 9001:2000 |
|
|
|
| Business Community Portal |
| The overall purpose of this project was to extend the features of existing business community web application meant for New Platform of projects for Team Formation and Expertise Management |
|
|
|
| Online Generic Store Portal |
| This project was intended to be a generic store front that was customized for several clients in the future. The intended objective was to build once and deploy for several clients with easy customization. |
|
|
|
| CMS Portal |
| The overall purpose of the project was to redesign a database driven dynamic version of the existing site including migration of existing content on the site to the new site design |
|
|
|
| HR Marketplace |
| This project has focused on development for Human Resources professionals who was seeking quality, unbiased information necessary to make educated buying decisions while keeping |
|
|
|
| Portal for IT Infrastructure Provider |
| An existing company of the client was looking for development of this project with redevelop the company profile and informational website and requires a graphic redesign along |
|
|
|
| Portal for Online Cosmetics Store |
| This project Development was focused on a pre-launch splash page that would capture email addresses to be used to communicate with consumer & Send confirmation email |
|
|
|
| Online Shipment Tracking |
| Development of this application was taken up to enable the customers to track the status of their shipments for a third party logistics provider and analyze all the information. |
|
|
|
| Online Survey Measurement Portal |
| Client had required a web application for a charitable association which provides funds to a set up 200 or more schools. Client administers survey to monitor the correct usage of funds |
|
|
|
| Performance Measurement Portal |
| The overall purpose of this system was to enable a company's document & its business strategy along with critical success factors and define an information bank with key |
|
|
|
| Case Studies A - Z Index |
| We have Provided a full history of our project Case Studies across all Technologies, Services and Industries. |
|
|
|
|
|
|
|
|
| Healthcare Introduction |
| Healthcare is something that everyone needs but not something that everyone has access to. It's quite true that in theory everyone is able to get some type of healthcare. |
|
|
|
| Philosophy of Healthcare |
| The philosophy of healthcare is the study of the ethics, processes, and people which constitute the maintenance of health for human beings. For the most part however, the philosophy |
|
|
|
| Health Insurance |
| The purpose of health insurance is to help people cover their health care costs. Health care costs include doctor visits, hospital stays, surgery, procedures, tests, home care, and other |
|
|
|
| Healthcare Informatics |
| A field of study concerned with the broad range of issues in the management and use of biomedical information, including medical computing and the study of the nature of medical |
|
|
|
| Planning an ASP.NET Web Site |
| This walkthrough gives you an introduction to the Web development features of Microsoft Visual Web Developer Express Edition and Microsoft Visual Studio 2008.Before you create |
|
|
|
| ASP.NET Application Life Cycle |
| Within ASP.NET, several processing steps must occur for an ASP.NET application to be initialized and process requests. Additionally, ASP.NET is only one piece of the Web server |
|
|
|
| ASP.NET-Data Access and Storage |
| Web applications commonly access data sources for storage and retrieval of dynamic data. You can write code to access data using classes from the System.Data namespace |
|
|
|
| Securing ASP.NET Web Sites |
| Security is a very important aspect of ASP.NET Web applications. The topics in this section provide background information about security issues that occur in Web applications. |
|
|
|
| ASP.NET Performance |
| To build ASP.NET applications that meet your performance objectives, you need to understand the places where bottlenecks typically occur, the causes of the bottlenecks, and the steps to take |
|
|
|
| Migrating & Converting .NET Apps |
| Benefits of migrating your application, including greater separation of code from markup, reserved application folders, and flexible deployment options. The benefits of migrating are |
|
|
|
| Comparison of Java & .NET Platforms |
| This is a comparison of the .NET/Mono and Java/Classpath platforms, excluding their associated programming languages, but including such topics as their history, runtime environments |
|
|
|
| Upgrading to Microsoft .NET |
| Microsoft Visual Basic .NET offers remarkable power and flexibility, with richer object models for data, forms, transactions, and more. But must upgrade applications before |
|
|
|
| Silverlight - Development with .NET |
| Microsoft Silverlight is a cross-browser, cross-platform implementation of the .NET Framework for building and delivering the next generation of media experiences and rich interactive |
|
|
|
| AJAX With .NET Framework |
| ASP.NET AJAX is a free framework for quickly creating efficient and interactive Web applications that work across all popular browsers. The following Contents in this section provide |
|
|
|
| New Features in .NET & Web Dev.. |
| Visual Web Developer is the best development tool for building dynamic, data driven web applications with .NET Framework. As detailed below contents, and demonstrated |
|
|
|
| ASP.NET Web Sites Development |
| The topics cover information that pertains to the application or site as a whole, such as the file structure of an ASP.NET Web site, the lifecycle of an application, ways to create a consistent |
|
|
|
| .NET Framework 3.5 |
| While a basic knowledge of the .NET Framework is assumed, this description focuses on the technologies added in the .NET Framework 3.0 and 3.5. The goal is to make clear what |
|
|
|
| .NET Web Application Projects |
| This article describes Web application projects and offers information on when you might choose a Web application project. The Web application projects model was designed |
|
|
|
| .NET Enterprise Services & COM+1.5 |
| This article discusses about Microsoft .NET Enterprise Services and its use of COM middle tier services. It introduces new COM 1.5 features as well as design guidelines to take full |
|
|
|
| Improve ASP.Net Performance |
| This article provides common issues, design guidelines, and coding techniques to improve the performance of ASP.NET Web Application and controls. Building high-performance ASP.NET |
|
|
|
| Whitepapers A - Z Index |
| We have Provided a comprehensive listing of our Whitepapers and Resources across a variety of topics within our focus areas. |
|
|
|
|
|
|
| www.who.int |
| WHO is the directing and coordinating authority for health within the United Nations system. It is responsible for |
|
|
|
| www.thelancet.com |
| UK medical journal. Online version allows only limited access to articles unless you subscribe. Discussion forum available. |
|
|
|
| www.eldis.org |
| Welcome to the Eldis website. Our aim is to share the best in development policy, practice and research. |
|
|
|
| www.ehponline.org |
| Environmental Health Perspectives (EHP) is a monthly journal of peer-reviewed research and news on the impact of the |
|
| | | | | | | |
