Dissertations / Theses: 'Spreadsheet application'

1

Kongdenfha, Woralak Computer Science &amp Engineering Faculty of Engineering UNSW. "Pattern-based data and application integration in service oriented architectures." Awarded By:University of New South Wales. Computer Science & Engineering, 2009. http://handle.unsw.edu.au/1959.4/42600.

Full text

Abstract:

The success of Web services comes from the benefits that it brings in reducing the cost and the time needed to develop data and applications by reusing them, and simplifying their integrations through standardization. However, standardization in Web services does not remove the need for adapters due to possible heterogeneity among service interface and protocol definitions. Moreover, the current service APIs are targeted toward professional programmers, but not accessible to a wider class of users without programming expertise, but would never the less like to build their own integrated applications. In this dissertation, we propose methods and tools to support both service developers and non-expert users in their data and application integration tasks. To support service developers, we propose a framework that enables rapid development of Web service adapters. We investigate particularly the problem of service adaptation focusing on business interface and protocol layers. Our study shows that many differences between business interfaces and protocols are recurring. We introduce mismatch patterns to capture these recurring differences and provide solutions to resolve them. We present the notion of adaptation aspects, which is based on the aspect-oriented programming paradigm, to enable rapid development and deployment of service adapters. We also present a comparative study between standalone and aspect-oriented adapters development. The study shows that the aspect-oriented approach is preferable in many cases, especially when adapters need to access internal states of services. The proposed approach is implemented in a prototype tool, which is used to illustrate how it simplifies adapters development through a case study. To support users without programming expertise, we propose a spreadsheet-based Web mashups development framework, which enables users to develop mashups in the popular spreadsheet environment. First, we provide a mechanism that makes structured data first class values of spreadsheet cells. Second, we propose a new component model that can be used to develop fairly sophisticated mashups, involving joining data sources and keeping spreadsheet data up to date. Third, to simplify mashup development, we provide a collection of spreadsheet-based mashup patterns that captures common Web data access and spreadsheet presentation functionalities. Users can reuse and customize these patterns to build spreadsheet-based Web mashups instead of developing them from scratch. Fourth, we enable users to manipulate structured data presented on spreadsheet in a drag-and-drop fashion. Finally, we have developed and tested a prototype tool to demonstrate the utility of the proposed framework.

APA, Harvard, Vancouver, ISO, and other styles

2

Cook, Glenn R. "Application of the Weibull distribution to the Cost Effectiveness Analysis Spreadsheet Model (CEAMOD) for the Aircraft Engine Component Improvement Program (CIP)." Thesis, Monterey, Calif. : Springfield, Va. : Naval Postgraduate School ; Available from National Technical Information Service, 1994. http://handle.dtic.mil/100.2/ADA294252.

Full text

Abstract:

Thesis (M.S. in Management) Naval Postgraduate School, December 1994.
Thesis advisor(s): Alan W. McMasters and Keebom Kang. "December 1994." Includes bibliographical references. Also available online.

APA, Harvard, Vancouver, ISO, and other styles

3

Steinfeld, Uwe H. "Draftsmans displays for contingency tables using a full-screen, scrollable APL2 spreadsheet input/output editor with application to the PERSEREC database of Special Background Investigation." Thesis, Monterey, California. Naval Postgraduate School, 1990. http://hdl.handle.net/10945/37552.

Full text

Abstract:

Approved for public release, distribution is unlimited.
A full-screen, scrollable spreadsheet-like editor written in the APL2 language is described for inputting, examining and outputting data. Mixed numeric and character arrays can be read into or read out to formatted DOS files (ASCII) or comma delimited DOS files. Alternatively a bulk mode input facility allows for rapid direct data entry, or data can be examined and edited cell-by-cell in the usual way. Columns, rows or blocks of data can be highlighted in a chosen color, shadowed, moved or copied. In addition APL functions entered on the command line can use the blocks as input or output. A facility for coding missing values is also provided. Major-to-minor (lexicographic) sorts can be performed on selected columns, and conditional or unconditional frequency tabulations and cross-tabulations of selected columns can be performed. Output is obtained as a new spreadsheet, or equivalently, as an APL2 matrix. In particular, two-way cross-tabulations of multiple columns are laid out in the spreadsheet like draftsman plots to facilitate investigation and explanation of multivariate categorical data. No numerical coding of the data is needed.

APA, Harvard, Vancouver, ISO, and other styles

4

Torok, S. J., and M. W. Woolverton. "Spreadsheet Applications for Arizona Cotton Producers." College of Agriculture, University of Arizona (Tucson, AZ), 1985. http://hdl.handle.net/10150/204029.

Full text

APA, Harvard, Vancouver, ISO, and other styles

5

Chang, Kerry Shih-Ping. "A Spreadsheet Model for Using Web Services and Creating Data-Driven Applications." Research Showcase @ CMU, 2016. http://repository.cmu.edu/dissertations/769.

Full text

Abstract:

Web services have made many kinds of data and computing services available. However, to use web services often requires significant programming efforts and thus limits the people who can take advantage of them to only a small group of skilled programmers. In this dissertation, I will present a tool called Gneiss that extends the spreadsheet model to support four challenging aspects of using web services: programming two-way data communications with web services, creating interactive GUI applications that use web data sources, using hierarchical data, and using live streaming data. Gneiss contributes innovations in spreadsheet languages, spreadsheet user interfaces and interaction techniques to allow programming tasks that currently require writing complex, lengthy code to instead be done using familiar spreadsheet mechanisms. Spreadsheets are arguably the most successful and popular data tools among people of all programming levels. This work advances the use of spreadsheets to new domains and could benefit a wide range of users from professional programmers to end-user programmers.

APA, Harvard, Vancouver, ISO, and other styles

6

McDonald, Michael L. "Teaching microcomputer software applications (electronic spreadsheets) : guided practice vs. independent practice /." free to MU campus, to others for purchase, 1997. http://wwwlib.umi.com/cr/mo/fullcit?p9841173.

Full text

APA, Harvard, Vancouver, ISO, and other styles

7

Gabris, Patsy Lynette. "Spreadsheet instruction and their use for teaching mathematics in the business computer applications course in Virginia." Thesis, Virginia Tech, 1991. http://hdl.handle.net/10919/42150.

Full text

Abstract:

This study describes the use of spreadsheets in business computer applications (BCA) courses and identifies and evaluates the use of spreadsheets for emphasizing and teaching mathematics in BCA courses.

Survey instruments in the form of questionnaires were sent to all of the Virginia high schools with the BCA course to attain the BCA teachers' perceptions of spreadsheet use. Responses were received from 257 teachers, or 70% of the total assumed population.

Findings reveal that 95% of the Virginia BCA teachers include spreadsheet instruction in their BCA courses. The mean number of class periods used for spreadsheet instruction is 27; however, the standard deviation is relatively high. The basic mathematics operations received extensive emphasis. The more complex operations only some emphasis. Accounting and Payroll computation receive the most amount of spreadsheet instructional time.

Over half of the BCA teachers who teach spreadsheets include increasing their students' mathematics skills as one of the course objectives. At the same time, however, only 22% of the respondents evaluate their students' mathematics skills independently from spreadsheet application evaluation. Although this independent mathematics evaluation seldom occurs, 72% of the respondents believe that teaching spreadsheets enhances students' mathematics skills to some extent, and 42% believe that teaching spreadsheets enhances students' mathematics skills extensively.

Considering the amount of material to be taught in spreadsheet instruction, not enough of the BCA class time is devoted to spreadsheet instruction. Much spreadsheet instruction precedes emphasis on mathematics as part of the instruction. Also, considering that students emphasize in their learning what they are evaluated on, the importance the BCA teachers placed on mathematics appears to be minimal.

Master of Science

APA, Harvard, Vancouver, ISO, and other styles

8

McCutchen, Richard Matthew. "Object Spreadsheets : an end-user development tool for web applications backed by entity-relationship data." Thesis, Massachusetts Institute of Technology, 2016. http://hdl.handle.net/1721.1/105960.

Full text

Abstract:

Thesis: S.M., Massachusetts Institute of Technology, Department of Electrical Engineering and Computer Science, 2016.
This electronic version was submitted by the student author. The certified thesis is available in the Institute Archives and Special Collections.
Cataloged from student-submitted PDF version of thesis.
Includes bibliographical references (pages 69-72).
There is a growing demand for data-driven web applications that help automate organizational and business processes of low to medium complexity by letting users view and update structured data in controlled ways. We present Object Spreadsheets, an end-user development tool that combines a spreadsheet interface with a rich data model to help the process administrators build the logic for such applications themselves. Its all-in-one interface with immediate feedback has the potential to bring more complex tasks within reach of end-user developers, compared to existing approaches. Our data model is based on the structure of entity-relationship models and directly supports nested variable-size collections and object references, which are common in web applications but poorly accommodated by traditional spreadsheets. Object Spreadsheets has a formula language suited to the data model and supports stored procedures to specify the forms of updates that application users may make. Formulas can be used to assemble data in the exact structure in which it is to be shown in the application UI, simplifying the task of UI building; we intend for Object Spreadsheets to be integrated with a UI builder to provide a complete solution for application development. We describe our prototype implementation and several example applications we built to demonstrate the applicability of the tool.
by Richard Matthew McCutchen.
S.M.

APA, Harvard, Vancouver, ISO, and other styles

9

Carter, Arthur E. "Design and Application of Genetic Algorithms for the Multiple Traveling Salesperson Assignment Problem." Diss., Virginia Tech, 2003. http://hdl.handle.net/10919/27258.

Full text

Abstract:

The multiple traveling salesmen problem (MTSP) is an extension of the traveling salesman problem with many production and scheduling applications. The TSP has been well studied including methods of solving the problem with genetic algorithms. The MTSP has also been studied and solved with GAs in the form of the vehicle-scheduling problem. This work presents a new modeling methodology for setting up the MTSP to be solved using a GA. The advantages of the new model are compared to existing models both mathematically and experimentally. The model is also used to model and solve a multi line production problem in a spreadsheet environment. The new model proves itself to be an effective method to model the MTSP for solving with GAs. The concept of the MTSP is then used to model and solve with a GA the use of one salesman make many tours to visit all the cities instead of using one continuous trip to visit all the cities. While this problem uses only one salesman, it can be modeled as a MTSP and has many applications for people who must visit many cities on a number of short trips. The method used effectively creates a schedule while considering all required constraints.
Ph. D.

APA, Harvard, Vancouver, ISO, and other styles

10

MARQUES, Ernande. "MATEMATICA FINANCEIRA NO ENSINO ´ MEDIO ´ : capitaliza¸c~ao e amortiza¸c~ao com o uso de planilha eletr^onica." Universidade Federal do Maranhão, 2016. https://tedebc.ufma.br/jspui/handle/tede/tede/1965.

Full text

Abstract:

Submitted by Daniella Santos (daniella.santos@ufma.br) on 2017-10-17T13:51:42Z No. of bitstreams: 1 ErnandeMarques.pdf: 8075757 bytes, checksum: f0a34a0e482bb2f1721f4656cc4d01dd (MD5)
Made available in DSpace on 2017-10-17T13:51:42Z (GMT). No. of bitstreams: 1 ErnandeMarques.pdf: 8075757 bytes, checksum: f0a34a0e482bb2f1721f4656cc4d01dd (MD5) Previous issue date: 2016-07-28
The Financial Mathematics has a role of great importance for high school students, it is in this stage of life that many of these students enter the labor market and start using cash more often. However, it is clear that more contextualized intervention is necessary on this topic so that these students can take ownership of them. Given the above, the proposed contents in this research include the study of amount, interest, fees, inancing, loans and applications so that students can become familiar with these issues of financial mathematics and use them when needed, in their day to day. In order to enhance scientific knowledge and to provide basis to students in their academic careers, does not open up hand to show and use the formulas and relevant equations Financial Mathematics, becoming the LibrOffice Calc spreadsheet just a tool or means that facilitates, but does not replace the mathematical deductions. Therefore, the aim is always the development of skills relacionas reflection and criticism, in the examples of each topic, so that students are able to make informed decisions and responsible to situations which are required the use of Financial Mathematics.
A Matemática Financeira tem um papel de grande relevância para os alunos do Ensino Médio, pois é nesta etapa da vida que muitos desses alunos ingressam no mercado de trabalho e começam a utilizar o dinheiro com mais frequência. No entanto, percebe-se que é necessário uma intervenção mais contextualiza desses conteúdos para que esses alunos consigam se apropriar deles. Diante do exposto, os conteúdos propostos, nesta pesquisa, contemplam o estudo sobre montante, juros, taxas, financiamentos, empréstimos e aplicações, para que os alunos possam se familiarizar com estes assuntos de Matemática Financeira e utilizá-los, quando for necessário, em seu dia a dia. Com o intuito de reforçar o conhecimento científico e de oferecer base aos estudantes em suas trajetórias acadêmicas, não abre-se mão de mostrar e usar as fórmulas e equações pertinentes a Matemática Financeira, fazendo-se da planilha Calc do LibrOffice apenas uma ferramenta ou um meio que facilita, mas n~ao substitui as deduções matemática. Por isso, busca-se sempre o desenvolvimento de competências relacionas a reflexão e a critica, nos exemplos de cada tópico, para que os alunos sejam capazes de tomar decisões conscientes e responsáveis diante de situações nas quais sejam exigidas o uso da Matemática Financeira.

APA, Harvard, Vancouver, ISO, and other styles

11

Paditz, Ludwig. "Using ClassPad-technology in the education of students of electrical engineering (Fourier- and Laplace-Transformation)." Saechsische Landesbibliothek- Staats- und Universitaetsbibliothek Dresden, 2012. http://nbn-resolving.de/urn:nbn:de:bsz:14-qucosa-80814.

Full text

Abstract:

By the help of several examples the interactive work with the ClassPad330 is considered. The student can solve difficult exercises of practical applications step by step using the symbolic calculation and the graphic possibilities of the calculator. Sometimes several fields of mathematics are combined to solve a problem. Let us consider the ClassPad330 (with the actual operating system OS 03.03) and discuss on some new exercises in analysis, e.g. solving a linear differential equation by the help of the Laplace transformation and using the inverse Laplace transformation or considering the Fourier transformation in discrete time (the Fast Fourier Transformation FFT and the inverse FFT). We use the FFT- and IFFT-function to study periodic signals, if we only have a sequence generated by sampling the time signal. We know several ways to get a solution. The techniques for studying practical applications fall into the following three categories: analytic, graphic and numeric. We can use the Classpad software in the handheld or in the PC (ClassPad emulator version of the handheld).

APA, Harvard, Vancouver, ISO, and other styles

12

Paditz, Ludwig. "Using ClassPad-technology in the education of students of electricalengineering (Fourier- and Laplace-Transformation)." Proceedings of the tenth International Conference Models in Developing Mathematics Education. - Dresden : Hochschule für Technik und Wirtschaft, 2009. - S. 469 - 474, 2012. https://slub.qucosa.de/id/qucosa%3A1799.

Full text

Abstract:

By the help of several examples the interactive work with the ClassPad330 is considered. The student can solve difficult exercises of practical applications step by step using the symbolic calculation and the graphic possibilities of the calculator. Sometimes several fields of mathematics are combined to solve a problem. Let us consider the ClassPad330 (with the actual operating system OS 03.03) and discuss on some new exercises in analysis, e.g. solving a linear differential equation by the help of the Laplace transformation and using the inverse Laplace transformation or considering the Fourier transformation in discrete time (the Fast Fourier Transformation FFT and the inverse FFT). We use the FFT- and IFFT-function to study periodic signals, if we only have a sequence generated by sampling the time signal. We know several ways to get a solution. The techniques for studying practical applications fall into the following three categories: analytic, graphic and numeric. We can use the Classpad software in the handheld or in the PC (ClassPad emulator version of the handheld).

APA, Harvard, Vancouver, ISO, and other styles

13

Goo, Justin M. W. "The effect of negative feedback on confidence calibration and error reduction in spreadsheet development." 2002. http://proquest.umi.com/pqdweb?index=0&did=727403601&SrchMode=1&sid=5&Fmt=2&VInst=PROD&VType=PQD&RQT=309&VName=PQD&TS=1179198165&clientId=23440.

Full text

APA, Harvard, Vancouver, ISO, and other styles

14

Hsiao, Chia-wei, and 蕭嘉偉. "The Development and Application of a Spreadsheet Integrated Mathematical Literacy Dynamic Assessment." Thesis, 2012. http://ndltd.ncl.edu.tw/handle/58772787066967150598.

Full text

Abstract:

博士
國立臺南大學
教育學系測驗統計博士班
100
The purpose of this study was to investigate the characteristics of students below level 2 on mathematical literacy assessment. The computerized basic mathematical literacy assessment and the spreadsheet integrated mathematical literacy intervention tasks were composed as a dynamic assessment system. Students worked on the tasks collaboratively. The number of relevant variables and the degree of complexity for problem situations were increased sequent to scaffold students’ learning progress. The issues included were the validity of the computerized basic mathematical literacy assessment (CBMLA), the intervention effect, and the correlation of growth slopes between formative and objective assessments. Eight hundred and seventy 8th graders of Tainan were selected as the norm sample for CBMLA. The PISA released items were converted and the flash interactive items were developed to form CBMLA. Fifty-eight 8th graders of Tainan were included as the experiment and control sample of this study. Half of them were assigned to the experiment group, and the other half were in the control group. The intervention period lasted for ten weeks. The main findings were summarized as followings: 1. The average of IRT difficulty parameter b is .41 of the CBMLA. The average discrimination D is .43. The internal consistency indices α of four form were between .71 to .85. The index of inter-rater consistency were between .96 to 1. The Pearson correlation coefficients of the assessment and school mathematics and language grades were .582 and .576, respectively. The correlation coefficient pattern was similar to the PISA 2009 and the basic competence test (Bctest) in Taiwan. 2. The mathematical literacy of 8th graders of Tainan were similar to OECD 15-year-old students. The boys’ mathematical literacy average was slightly lower than girls’, but there was not significant differences. The standard deviation of boys’ mathematical literacy was larger than the girls’. The pattern of gender difference in Tainan was similar to the results of Taiwan PISA 2009. 3. The students below level 2 on CBMLA can read familiar situations or routine mathematical description of the problem. They were able to apply the formula provided by the item, and they could also use the basic statistics information from charts to solve the problem. But they could not identify the pattern of graph and numbers. They had some barriers to convert the text into mathematical equations. 4. The slope of mathematical literacy of experimental group was significantly higher than the slop of control group. Experiment group students Increased 35 points between two assessments. The treatment group can explain about 6% growth variance. Based upon the results, some suggestions for further development and application of dynamic assessment on mathematical literacy were provided.

APA, Harvard, Vancouver, ISO, and other styles

15

Halbleib, Michael D. "Using advanced spreadsheet features for agricultural GIS applications." Thesis, 2001. http://hdl.handle.net/1957/31441.

Full text

Abstract:

A GIS analysis procedure was developed to explore relationships between imagery, yield data, soil information, and other assessments of a field or orchard. A set of conversion utilities, a spreadsheet, and an inexpensive shape file viewer were used to manipulate, plot, and display data. Specific features described include procedures used to: 1) display automated yield monitoring and aerial imagery data as surface maps for visual analysis, 2) generate maps from gridded soil sampling schemes that display either the collected soil data values or management information derived from further manipulation of the sample values, 3) evaluate relationships among data layers such as yield monitor, imagery, and soil data, 4) conduct an upper boundary line evaluation of potential yield-limiting factors. The analysis process is demonstrated on wheat, meadowfoam, and hazelnut data, from crops grown in Oregon.
Graduation date: 2002

APA, Harvard, Vancouver, ISO, and other styles

Dissertations / Theses on the topic 'Spreadsheet application'

Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles