Software Engineering Commons^™

The Lookup Technique To Replace Nested-If Formulas In Spreadsheet Programming, Thomas A. Grossman Jr., O Ozluk, J Gustavson

Business Analytics and Information Systems

Spreadsheet programmers often implement contingent logic using a nested-IF formula even though this technique is difficult to test and audit and is believed to be risky. We interpret the programming of contingent logic in spreadsheets in the context of traditional computer programming. We investigate the “lookup technique” as an alternative to nested-IF formulas, describe its benefits for testing and auditing, and define its limitations. The lookup technique employs four distinct principles: 1) make logical tests visible; 2) make outcomes visible; 3) make logical structure visible; and 4) replace a multi-function nested-IF formula with a single-function lookup formula. It can be …

A Primer On Spreadsheet Analytics, Thomas A. Grossman Jr.

Business Analytics and Information Systems

This paper provides guidance to an analyst who wants to extract insight from a spreadsheet model. It discusses the terminology of spreadsheet analytics, how to prepare a spreadsheet model for analysis, and a hierarchy of analytical techniques. These techniques include sensitivity analysis, tornado charts, and backsolving (or goal-seeking). This paper presents native-Excel approaches for automating these techniques, and discusses add-ins that are even more efficient. Spreadsheet optimization and spreadsheet Monte Carlo simulation are briefly discussed. The paper concludes by calling for empirical research, and describing desired features spreadsheet sensitivity analysis and spreadsheet optimization add-ins.

Viewing Virtual Property Ownership Through The Lens Of Innovation, Ryan G. Vacca

Law Faculty Scholarship

Over the past several years scholars have wrestled with how property rights in items created in virtual worlds should be conceptualized. Regardless of how the property is conceptualized and what property theory best fits, most agree the law ought to recognize virtual property as property and vest someone with those rights.

Entrepreneurial Opportunities And Market Analysis Of The Information Technology And Software Development Sector Of Pakistan, Toshio Fujita, Hassan Tajuddin

Business Review

This study investigates the Information Technology and the Software Development sector of Pakistan. It discusses the reasons for the lack of trust in Pakistani IT companies and different problems faced by an entrepreneur starting an IT company in Pakistan. The data was analyzed by qualitative content analysis. The findings are discussed with reference to previous research, and implications for entrepreneurial setups are noted.

Source Code Protection For Applications Written In Microsoft Excel And Google Spreadsheet, Thomas A. Grossman Jr.

Business Analytics and Information Systems

Spreadsheets are used to develop application software that is distributed to users. Unfortunately, the users often have the ability to change the programming statements (“source code”) of the spreadsheet application. This causes a host of problems. By critically examining the suitability of spreadsheet computer programming languages for application development, six “application development features” are identified, with source code protection being the most important. We investigate the status of these features and discuss how they might be implemented in the dominant Microsoft Excel spreadsheet and in the new Google Spreadsheet. Although Google Spreadsheet currently provides no source code control, its web-centric …

Performance Analysis Of Security Aspects In Uml Models, Dorin Bogdan Petriu, Dorina C. Petriu, C Murray Woodside, Jing Xiu, Toqeer A. Israr, Geri Georg, Robert B. France, James M. Bieman, Siv Holde Houmb, Jan Jurjens

Faculty Research & Creative Activity

The focus of the paper is on the analysis of performance effects of different security solutions modeled as aspects in UML. Aspect oriented modeling (AOM) allows software designers to isolate and separately address solutions for crosscutting concerns, which are defined as distinct UML aspect models, then are composed with the primary UML model of the system under development. For performance analysis we use techniques developed previously in the PUMA project, which take as input UML models annotated with the standard UML Profile for Schedulability, Performance and Time (SPT), and transform them first into Core Scenario Model (CSM) and then into …

Best Practices For Implementing Agile Methods: A Guide For Department Of Defense Software Developers, Ann L. Fruhling, Alvin E. Tarrell

Information Systems and Quantitative Analysis Faculty Publications

Traditional plan-driven software development has been widely used in the government because it's considered to be less risky, more consistent, and structured. But there has been a shift from this approach to Agile methods which are more flexible, resulting in fast releases by working in an incremental fashion to adapt to the reality of the changing or unclear requirements.

This report describes the Agile software development philosophy, methods, and best practices in launching software design projects using the Agile approach. It is targeted to Defense Department software developers because they face broad challenges in creating enterprise-wide information systems, where Agile …

India’S Rise As A Software Power: Governmental Policy Factors, Tad Drozdowski, Hai Huynh, Brian Lininger, Yicheng Peng, Naruedom Sakulyong

Engineering and Technology Management Student Projects

The Indian government’s policies toward an open, global market, support of educational institutions, and enhancement of appropriate infrastructure helped enable their software industry to become critical components of India’s economic growth in the 1990s. The Technical, Organizational, and Personal perspective (T, O, and P) model is utilized to examine different affects that each perspective, inclusive of government policies, has on a socio-technical system (Software development in India). The Indian government has provided substantial economic liberalization to support their software industries, though continued reform is necessary to ensure that they remain a software superpower.

Implementation And Analysis Of Cmmi's Configuration Management Process Area; Applicable To "Defined" Level - 3, Ahmad Luqman

International Conference on Information and Communication Technologies

Enterprise Resource Planner (ERP) is a strategically important tool as integrated business application for long-term success in an increasingly competitive global market. This system requires the integration of data and business processes across the whole enterprise. In order to develop a good quality product there is a need of applying proper model. It becomes more costly in terms of training, appraisals, and improvement activities while applying multiple models that are not integrated within and across an organization. Where as Capability Maturity Model Integration is a set of integrated models that successfully addresses multiple disciplines and has integrated training support. Objective …

A Paradigm For Spreadsheet Engineering Methodologies, Thomas A. Grossman Jr., O Ozluk

Business Analytics and Information Systems

Spreadsheet engineering methodologies are diverse and sometimes contradictory. It is difficult for spreadsheet developers to identify a spreadsheet engineering methodology that is appropriate for their class of spreadsheet, with its unique combination of goals, type of problem, and available time and resources. There is a lack of well-organized, proven methodologies with known costs and benefits for well-defined spreadsheet classes. It is difficult to compare and critically evaluate methodologies. We present a paradigm for organizing and interpreting spreadsheet engineering recommendations. It systematically addresses the myriad choices made when developing a spreadsheet, and explicitly considers resource constraints and other development parameters. This …

Research Strategy And Scoping Survey On Spreadsheet Practices, Thomas A. Grossman Jr., O Ozluk

Business Analytics and Information Systems

We propose a research strategy for creating and deploying prescriptive recommendations for spreadsheet practice. Empirical data on usage can be used to create a taxonomy of spreadsheet classes. Within each class, existing practices and ideal practices can he combined into proposed best practices for deployment. As a first step we propose a scoping survey to gather non-anecdotal data on spreadsheet usage. The scoping survey will interview people who develop spreadsheets. We will investigate the determinants of spreadsheet importance, identify current industry practices, and document existing standards for creation and use of spreadsheets. The survey will provide insight into user attributes, …

Kiosk Kolej Kediaman Um, Permal Magadesh

Student Works (2000-2009)

Kiosk Kolej Kediaman UM adalah satu projek Latihan Ilmiah iaitu subjek yang wajib ambil oleh semua pelajar Fakulti Sains Komputer dan Teknologi Maklumat untuk menamatkan pengajian. Subjek ini terbahagi kepada dua iaitu Latihan llmiah I yang membawa 4 jam kredit berkisar tentang kajian dan pembangunan awal sistem manakala Latihan Ilmiah 2 yang membawa 5 jam kredit melaksanakan pengkodan dan pengujian dan melengkapkan sistem. Kiosk Kolej Kediaman UM dibangunkan dengan kerjasama daripada pihak Kolej Kediaman Kinabalu yang merupakan salah satu daripada 14 kolej kediaman yang terdapat di UM. Perancangan pembangunan Kiosk Kolej Kediarnan UM dibuat dengan teliti melalui 3 fasa pertama …