5
DEFINITIONS To fully understand this topic it is essential that these terms have there common definition broadened: Program Software Engineering End-User Programming End-User Software Engineering

6
PROGRAM There are many different definitions for a program. According to Dictionary.com a program is “the precise sequence of instructions enabling a computer to solve a problem.” [14] According to the Computer Dictionary, a program is “a single, complete and more-or-less self- contained list of instructions, often stored in a single file.” [16] The definition we will be using is that a program is “a collection of specifications that may take variable inputs and that can be executed (or interpreted by a device with computational capabilities.” [5]

7
SOFTWARE ENGINEERING There are many definitions for Software Engineering. Therefore, the definition that we will be using is that of the IEEE (the Institute of Electrical and Electronics Engineers) which defines Software Engineering as… “the application of a systematic, disciplined, quantifiable approach to the development, operation, and maintenance of software; that is, the application of engineering to software” [3].

8
END-USER PROGRAMMING End-User  Anyone who uses a computer [5]. End-User Programmer  Programming done by anyone using a computer. End-User Programming  Programming to achieve the result of a program primarily for personal, rather than public use” [5].

9
END-USER SOFTWARE ENGINEERING (EUSE) The only way to properly define End-User Software Engineering is to note it is a form of Software Engineering  Because of this, end-user programmers face many of the same software engineering challenges. However, there are many differences that clearly separate EUSE from Professional Software Engineering.

10
HOW IS EUSE DIFFERENT FROM PROFESSIONAL SE Topic 2 of 5

11
Goal of Professional Engineer Seeking payment for developing and maintaining programs over time  In other words, the programs being developed are being created to make a task easier for someone else. NOT THEMSELVES. Goal of End-User Software Engineer Developing programs that support some goal that exists in there domain of expertise [5].  In other words, End-User Programmers develop program to make some task easier for THEMSELF. EUSE VS. PROFESSIONAL SE The main difference between End-User SE and Professional SE is their goals.

12
People who participate in EUSEActivity Performing SecretariesExcel Tables AccountantsExcel Tables TeachersExcel Tables ScientistsMATLAB Scripts It is obvious that many different people participate in EUSE. The only condition that must be met is that the intent of the programming must be that of accomplishing a PERSONAL GOAL. Even expert programmers can fall under this category. EUSE VS. PROFESSIONAL SE, CONTINUED

13
Intent is not the only difference between End-User Software Engineering and Professional Software Engineering. To fully separate these two we need to examining the actions taken during different phases of the software development lifecycle. The areas we will be focusing on are: Requirements Gathering Design and Specification Testing and Verification Debugging

14
Professional Software Engineers Perception of Requirements Gathering requirements is crucial to the success of the program. If not thorough it is almost impossible to build not only the system right, but the right system. Source of Requirements Customer Time spent T ons of time is spent in gathering requirements. End-User Software Engineers Perception of Requirements Requirements are not gathered, or recorded. They are more easily understood Source of Requirements Themselves Time Spent No time spent gathering requirements REQUIREMENTS GATHERING

15
Professional Software Engineers Perception of Design and Design Specification The purpose of design specifications is to specify the systems internal behavior. Also, allows you to determine what implementation constraints exist. Uses for Design Specifications Design specifications are used to lay out the implementation strategy for ensuring that the system metes all of the requirements. Done by assigning appropriate priorities to each requirement so that the highest priority requirements are taken care of before the low priority ones. End-User Software Engineers Perception of Design and Design Specification This phase is difficult for End-Users because they often are unable to translate their requirements into a working program. This is because they don’t have the training or experience Uses for Design Specification They often see little to no benefit to it. Once again, this is do to there lack of experience and training. Often come to realize what constraints exist on their programs’ implementations while they write it. DESIGN AND DESIGN SPECIFICATION

16
Professional Software Engineers Perception of Testing and Verification It is an essential part of the Software Development Lifecycle It is the way in which SE’s ensure the proper execution of the program. How is this implemented? JUnit tests, regression testing, embedded test cases, etc. By running these tests it helps in bug identification and in verifying proper execution of the program. End-User Software Engineers Perception of Testing and Verification Testing is intermingled with debugging, if it is done at all. How is it implemented? It is done by way of trial and error. Reason for this? The priorities of the end-user programmer frequently lead to overconfidence in their programs correctness. To no one’s surprise, studies show that in spite of high error rates in spreadsheets, the developers of the spreadsheets are carelessly confident about its correctness. TESTING AND VERIFICATION

17
Professional Software Engineering Perception of Debugging It is an essential activity to ensure requirements are being met. Time Spent Debugging Debugging is the most time consuming activity undergone. To be successful requires a high level of understanding of the code. It allows you to identify areas that could have caused the problem. End-User Software Engineering Perception of Debugging End-Users frequently prioritize their external goals over software reliability, they often rely on debugging strategies such as making code changes until it appears to work as expected. Time Spent Debugging Debugging may not even be possible for many end-users. This is because end-user programmers often lack accurate knowledge and understanding about their programs execution. Therefore the root-cause is very hard for them to conceive. DEBUGGING

19
IMPORTANCE OF FURTHER RESEARCH Increase in the number of end-users using EUSE to achieve personal goals comes an increase in the risk of an error This is a direct result of the lack of quality procedures. How bad can a bug in an End-Users program be?

20
EXAMPLE 1:MYSQL ERROR An employee working at a big bank firm is responsible, on a daily basis, for removing entries in the bank’s MySQL database that reference loans that have been sold to other banks. Noticing that all of the records that need to be removed have two things in common the employee begins to explore possible ways in which this process can be automated. After scouring the internet the employee discovers a bit of code that, based on the attached documentation, appears to be to complete the goal with only slight modification.

21
CODING SAMPLE BEFORE EDITING This is the sample code that the bank employee found on the internet.

22
CODING SAMPLE AFTER EDITING As you can see above, the bank employee has made the changes but has made one crucial mistake.

23
ERROR In MySQL the first line of this will execute because it is valid. It will terminate at the end of this line resulting the database table with the given name having all of its tables dropped.

24
EXAMPLE 2:BASH SCRIPT MISTAKE An experienced Linux user decides to change the organization of his/her pictures. To save time the user decides to write a script. The script is fairly simple, it moves into a directory and copies all of the files into another directory. After having copied all of the files, the script then deletes the folder.

25
BASH SCRIPT WRITTEN BY THE USER The above code has one crucial error.

26
ERROR The error is in the lack of error checking.

27
EXAMPLE 3:EXCEL ERROR An employee for a Texas oil and gas company is responsible for performing spreadsheet calculations to determine whether it is cost effective to acquire another company. After performing the operations it is determined that the acquisition would be very lucrative. Based on this determination, they went ahead with the acquisition. Soon afterwards it was discovered that this acquisition was a huge mistake. The company lost millions of dollars due to an error in the spreadsheet.

28
TOOLS THAT AID IN EUSE Topic 4 of 5

29
TOOLS There are many tools available whose main purpose is integrating software quality principles used by professional software engineers into end-user software engineering. The tools that will be discussed are: 1.Topes 2.What You See Is What You Test(WYSIWYT) 3.Whyline

30
TOPES What is topes?  Topes is a model and supporting system with the purpose of supporting validation and reuse of small, human readable data in programs created by end-users  More specifically, users define string-based data types which can then be used to verify the validity of both data and operations in the programming languages that store information as strings. By support the design of custom data types, end-user programmers are able to easily process and validate information. Topes is a model and supporting system with the purpose of supporting validation and reuse of small, human-readable data in programs created by end-user programmers’ [1]. More specifically, users define string-based data types which can then be used to verify the validity of both data and operations in programming languages that store information as strings [5]. By supporting the design of custom data types, end-user programmers are able to easily process and validate information [5].

31
TOPES, CONTINUED Users create a “tope” that describes the rules for recognizing and formatting a specific kind of data, such a birth date, phone numbers, etc and then associate a tope with spreadsheet cells, or other String fields. The values are then automatically checked and transformed at runtime. Studies have shown that end-users are capable of validating data more rapidly and precisely with Topes than with other existing tools.

32
WHAT YOU SEE IS WHAT YOU TEST(WYSIWYT) What is the purpose of WYSIWYT?  To help users test their spreadsheets while they are in the process of creating them, in an incremental and systematic fashion. How is this done?  At any point in the development process of the spreadsheet, the end-user can validate any value that he/she observes as accurate [1].  Each validation done by the end-user is processed, in the background, and used to measure the quality of the testing being done in terms of a test adequacy criterion that is based on data dependencies [5].  The measurements are then projected to the user by means of several different visual devices to assist in directing their testing activities [5].

33
WHAT YOU SEE IS WHAT YOU TEST, CONTINUED As shown above. You check the boxes to validate the data that you have entered as correct. Based on the a testing percentage is displayed.

34
WHYLINE What is Whyline?  Whyline is a debugging tool that allows the end-user programmer to ask a question of the type “Why did” and “Why didn’t” regarding outputs generated by their program.  The program chooses from a set of questions that are automatically generated by Whyline, through the use of static and dynamic analysis, and Whyline is then able to provide different answers in terms of the runtime events that could have caused the desired result.

35
Whyline was originally prototyped in the Alice Programming environment. Results of studies done measuring the amount of time users spent debugging using Whyline compared to those who did not use Whyline produced startling results. End-user programmers using Whyline where able to debug the same bug as end-user programmers not using Whyline in one eighth of the time [1]. Based on the results of this study it is not only clear that this tool has profound benefits to the end-user programmer, but that the benefits are in the form of higher software quality. WHYLINE, CONTINUED

36
CONCLUSION Topic 5 of 5

37
CONCLUSION The number of end-users participating in end-user software engineering is continuing to rapidly increase. As the number of end-users participating in EUSE increases so does the probability that an issue will occur resulting from lacking quality processes. If more research isn’t done into and awareness isn’t raised about tools like Topes, WYSIWYT, and Whyline then these risks will continue to go unchecked.