To see the other types of publications on this topic, follow the link: Electronic spreadsheets.
Dissertations / Theses on the topic 'Electronic spreadsheets'
Create a spot-on reference in APA, MLA, Chicago, Harvard, and other styles
Consult the top 48 dissertations / theses for your research on the topic 'Electronic spreadsheets.'
Next to every source in the list of references, there is an 'Add to bibliography' button. Press on it, and we will generate automatically the bibliographic reference to the chosen work in the citation style you need: APA, MLA, Harvard, Chicago, Vancouver, etc.
You can also download the full text of the academic publication as pdf and read online its abstract whenever available in the metadata.
Browse dissertations / theses on a wide variety of disciplines and organise your bibliography correctly.
1
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
2
Whitmer, Brian C. "Improving Spreadsheets for Complex Problems." Diss., CLICK HERE for online access, 2008. http://contentdm.lib.byu.edu/ETD/image/etd2361.pdf.
Full text
3
Morris, David K. "Financial management information systems : the use of electronic spreadsheets in budgeting/." Thesis, Monterey, Calif. : Springfield, Va. : Naval Postgraduate School ; Available from National Technical Information Service, 1995. http://handle.dtic.mil/100.2/ADA302581.
Full text
4
Yan, Chi-yuen. "Using spreadsheet as mindtool in studying economics : a case study /." Hong Kong : University of Hong Kong, 2002. http://sunzi.lib.hku.hk/hkuto/record.jsp?
Full text
5
Kenyon, Mitchell Alan William. "The value of spreadsheet programs to planners." Thesis, University of British Columbia, 1988. http://hdl.handle.net/2429/28088.
Full textAbstract:
According to Brail, a planning professor at Rutgers University,
it is abundantly clear that the electronic spreadsheet is the single most important computer tool available to the practicing planner, (working paper, 1985,1)
What is the value, measured in increased productivity, of spreadsheet programs to planners? Spreadsheet programs, referred to simply as spreadsheets, are an enhanced version of the paper spreadsheet. Paper spreadsheets are tabular forms commonly used by bookkeepers and accountants. Spreadsheets perform computations that would be tedious and perhaps impossible on a paper spreadsheet.
A number of factors influence the value of spreadsheets to planners. This thesis discuses three factors in detail: the capabilities of spreadsheets, the utility of the planning models whose computations sometimes involve spreadsheets, and the savings in development time by employing spreadsheet templates.
Assessing the capabilities of spreadsheets requires clarifying the concept of spreadsheets and describing their general applications. Clarifying the concept includes defining spreadsheet terms such as worksheet, functions, macros, and templates', depicting the evolution of spreadsheets; highlighting differences between spreadsheet packages; and noting the limitations of spreadsheets. Describing the general applications involves discussing the three major uses of spreadsheets: table production, numerical analysis, and the testing of "what if scenarios.
Evaluating the utility of the planning models whose computations sometimes involve spreadsheets requires two steps. The first step establishes the relationship between models and spreadsheets in data analysis for planning. The second step examines the advantages and disadvantages of the planning models.
Determining the savings in development time by employing templates involves three steps. The first step constructs criteria by which to evaluate the structure of a template for accuracy and ease of use. The second step examines how well available templates fit the planning model discussed. The third step evaluates the structure of each of the templates using the criteria constructed.
Five chapters compose the body of the thesis. The first chapter explains the concept of the spreadsheet. The second chapter illustrates the general applications of spreadsheets, determines the role of spreadsheets in data analysis for planning, and develops criteria by which to evaluate a template's structure. Each of the last three chapters demonstrates the potential of spreadsheets to planners by describing and evaluating planning models and spreadsheet templates.
There are many factors influencing the value of spreadsheets to planners not covered in this thesis which may prove grounds for further research. The thesis ignores the affect the planner's access to computers and programs, knowledge of computers, and attitude towards computers has on the value of spreadsheets. Furthermore, the thesis does not establish the relative worth of spreadsheets in comparison to other possible tools for performing the computation of a planning model.
Therefore, this thesis is unable to confirm Brail's claim that spreadsheets are the most important computer tool. Nevertheless, this thesis provides reasons for Brail's enthusiasm towards spreadsheets.Applied Science, Faculty of
Community and Regional Planning (SCARP), School of
Graduate
6
Dandolu, Rajesekhar R. "Excel Sheet Based Semantic Email." TopSCHOLAR®, 2004. http://digitalcommons.wku.edu/theses/1101.
Full textAbstract:
EXCEL SHEET BASED SEMANTIC EMAIL Rajesekhar R, Dandolu December 10, 2004. 47 Pages Directed by: Dr. Guangming Xing Department of Computer Science Western Kentucky University The Semantic Web is an extension of the current web in which information is given well-defined meaning, better enabling computers and people to work in cooperation. The Semantic Web envisions a portion of the World-Wide Web in which the underlying data is machine understandable and can thus be exploited for improved querying, aggregation, and interaction. Excel Sheet Based Semantic Email is a type of Semantic Web application, which deals with the understanding of emails received and performing corresponding actions according to the schema specified in the email. The user can compose an email structure and specify all the semantic actions and necessary information related to a particular schema. The emails received are processed according to the schema format to which they belong and corresponding semantic actions are taken. In this project, Semantic Email is implemented by encoding the information in Excel Sheets. It could be reengineered to support heterogeneous semantic actions based on the particular application. The project can be enhanced providing a web interface, apart from the email system that is currently used as the way of communication. The clients can directly use the web page,
7
Good, Joyce A. "A modified train-the-trainer professional development program designed to deliver spreadsheet skills to elementary teachers and students." Access to citation, abstract and download form provided by ProQuest Information and Learning Company; downloadable PDF file, 136 p, 2007. http://proquest.umi.com/pqdweb?did=1397911771&sid=14&Fmt=2&clientId=8331&RQT=309&VName=PQD.
Full text
8
Davidson, Conda. "Comparative analysis of teaching methods and learning styles in a high school computer spreadsheet unit /." free to MU campus, to others for purchase, 2000. http://wwwlib.umi.com/cr/mo/fullcit?p9974620.
Full text
9
Schrock, Eric V. "A PHIGS-based spreadsheet for conceptual design." Thesis, This resource online, 1991. http://scholar.lib.vt.edu/theses/available/etd-10242009-020217/.
Full text
10
Hall, Maria Jean. "The A.D.E. taxonomy of spreadsheet application development." Thesis, Edith Cowan University, Research Online, Perth, Western Australia, 1992. https://ro.ecu.edu.au/theses/1696.
Full textAbstract:
Spreadsheets are a major application in end-user computing, one of the fastest growing areas of computing. Studies have shown that 30% of spreadsheet applications contain errors. As major decisions are often made with the assistance of spreadsheets, the control of spreadsheet applications is a matter of concern to enduser developers, managers, EDP auditors and computer professionals.
The application of appropriate controls to the spreadsheet development process requires prior categorisation of the spreadsheet application. The special-purpose A.D.E. (Application, Development, Environment) taxonomy of spreadsheet application development was evolved by mathematical taxonomic methods to categorise spreadsheet development projects to facilitate their management and control.
11
Tan, Meifang. "An online interactive spreadsheet approach to data analysis and manipulation." [Gainesville, Fla.] : University of Florida, 2002. http://purl.fcla.edu/fcla/etd/UFE0000614.
Full text
12
Calder, Nigel Stuart. "Processing mathematical thinking through digital pedagogical media the spreadsheet /." The University of Waikato, 2008. http://hdl.handle.net/10289/2662.
Full textAbstract:
Abstract This study is concerned with the ways mathematical understanding emerges when mathematical phenomena are encountered through digital pedagogical media, the spreadsheet, in particular. Central to this, was an examination of the affordances digital technologies offer, and how the affordances associated with investigating mathematical tasks in the spreadsheet environment, shaped the learning trajectories of the participants. Two categories of participating students were involved, ten-year-old primary school pupils, and pre-service teachers. An eclectic approach to data collection, including qualitative and quantitative methods, was initially undertaken, but as my research perspective evolved, a moderate hermeneutic frame emerged as the most productive way in which to examine the research questions. A hermeneutic process transformed the research methodology, as well as the manner in which the data were interpreted. The initial analysis and evolving methodology not only informed this transition to a moderate hermeneutic lens, they were constitutive of the ongoing research perspectives and their associated interpretations. The data, and some that was subsequently collected, were then reconsidered from this modified position. The findings indicated that engaging mathematical tasks through the pedagogical medium of the spreadsheet, influenced the nature of the investigative process in particular ways. As a consequence, the interpretations of the interactions, and the understandings this evoked, also differed. The students created and made connections between alternative models of the situations, while the visual, tabular structuring of the environment, in conjunction with its propensity to instantly manage large amounts of output accurately, facilitated their observation of patterns. They frequently investigated the visual nature of these patterns, and used visual referents in their interpretations and explanations. It also allowed them to pose and test their informal conjectures and generalisations in non-threatening circumstances, to reset investigative sub-goals easily, hence fostering risk taking in their approach. At times, the learning trajectory evolved in unexpected ways, and the data illustrated various alternative ways in which unexpected, visual output stimulated discussion and extended the boundaries of, or reorganised, their interaction and mathematical thinking. An examination of the visual perturbations, and other elements of learning as hermeneutic processes also revealed alternative understandings and explanations. Viewing the data and the research process through hermeneutic filters enhanced the connectivity between the emergence of individual mathematical understanding, and the cultural formation of mathematics. It permitted consideration of the ways this process influences the evolution of mathematics education research. While interpretive approaches are inevitably imbued with the researcher perspective in the analysis of what gets noticed, the research gave fresh insights into the ways learning emerges through digital pedagogical media, and the potential of this engagement to change the nature of mathematics education.
13
殷志遠 and Chi-yuen Yan. "Using spreadsheet as mindtool in studying economics: a case study." Thesis, The University of Hong Kong (Pokfulam, Hong Kong), 2002. http://hub.hku.hk/bib/B31256521.
Full text
14
Funnell, Lynette. "A classroom-based investigation into the potential of the computer spreadsheet as a learning tool within the secondary school mathematics curriculum." Thesis, Rhodes University, 1992. http://hdl.handle.net/10962/d1003329.
Full textAbstract:
The influence of modern technology on education is becoming more noticeable and has implications for the curriculum and the teaching methods of mathematics. The microcomputer can be used effectively as a powerful teaching and learning aid within the mathematics classroom. This study considers the role of the computer as an aid to teachers and pupils in the teaching and learning of mathematics and shows it as having great potential. At present relatively few schools in South Africa are using the computer as a teaching aid in the mathematics classroom. The researcher proposes that some reasons are a shortage of suitable programs, the fact that few teachers have adequate skills in educative uses of the computer and most teachers are not skilled in programming techniques. Based on this assessment of the problem, spreadsheet programs related to some mathematics lessons, together with teaching notes and pupils' material have been developed. Besides describing the potential of the computer in mathematics, this study outlines the development of three spreadsheet packages and suitable teaching methodologies used for each package, and assesses an action research investigation undertaken by the researcher, teachers and pupils when using these spreadsheet packages in six classes. The findings of the investigation are most encouraging. The overall conclusion is that computer spreadsheet packages can assist the teacher in making the learning of mathematics more effective, more interesting and more enjoyable.
15
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 textAbstract:
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
16
Benn, Kenneth Robert Andrew. "A classroom-based investigation into the potential of a computer-mediated criterion-referenced test as an evaluation instrument for the assessment of primary end user spreadsheet skills." Thesis, Rhodes University, 1994. http://hdl.handle.net/10962/d1003328.
Full textAbstract:
The demand for innovative end users of information technology is increasing along with the proliferation of computer equipment within the workplace. This has resulted in increasing demands being made upon educational institutions responsible for the education of computer end users. The demands placed upon the teachers are particularly high. Large class groups and limited physical resources make the task especially difficult. One of the most time consuming, yet important, tasks is that of student evaluation. To effectively assess the practical work of information technology students requires intensive study of the storage media upon which the students'efforts have been saved. The purpose of this study was to assess the suitability of criterion-referenced testing techniques applied to the evaluation of end user computing students. Objective questions were administered to the students using Question Mark, a computer-managed test delivery system which enabled quick and efficient management of scoring and data manipulation for empirical analysis. The study was limited to the classroom situation and the assessment of primary spreadsheet skills. In order to operate within these boundaries, empirical techniques were used which enabled the timeous analysis of the students' test results. The findings of this study proved to be encouraging. Computer-mediated criterion-referenced testing techniques were found to be sufficiently reliable for classroom practice when used to assess primary spreadsheet skills. The validation of the assessment technique proved to be problematic because of the constraints imposed by normal classroom practice as well as the lack of an established methodology for evaluating spreadsheet skills. However, sufficient evidence was obtained to warrant further research aimed at assessing the use of computer-mediated criterion-referenced tests to evaluate information technology end user learning in situations beyond the boundaries of the classroom, such as a national certification examination.
17
Simone, James Nicholas. "NP user interface modeling." Diss., Online access via UMI:, 2009.
Find full text
18
Ntsohi, Mamosa M. E. "Investigating teaching and learning of Grade 9 Algebra through excel spreadsheets : a mixed-methods case study for Lesotho." Thesis, Stellenbosch : Stellenbosch University, 2013. http://hdl.handle.net/10019.1/85657.
Full textAbstract:
Thesis (PhD)-- Stellenbosch University, 2013.ENGLISH ABSTRACT: The teaching and learning of algebra in the middle school grades in Lesotho is dominated by the mechanistic approach where learners are drilled on procedures for solving certain types of problems in algebra, without making any connection to the experience learners had with arithmetic. This is one of the sources of learners’ difficulties in mathematics. Research indicates that use of spreadsheets such as Excel has a potential of bridging the gap between arithmetic and algebra and thus enhancing the teaching and learning of algebra, making it meaningful to the learners. The study sought to answer the question: How do Grade 9 learners in Lesotho experience teaching and learning of algebra through Excel spreadsheets? The research commenced with a literature review that was followed by the empirical study. The theories of instrumental genesis and instrumental orchestration were identified as the framework for the investigation. Instrumental genesis is the process in which learners develop facility with the artifact as they use it towards achieving lesson objectives; technical (conceptual, mechanical) and personal (attitudes, behavior and preferred learning styles) aspects of learners’ experiences were identified. Instrumental orchestration is the steering of learners’ instrumental genesis by the teacher and the manner in which this process is carried out, depends on the teacher’s Technological Pedagogical Content Knowledge (TPCK). The research was a multi-case study following a mixed-methods approach, where both qualitative and quantitative methods were used. The empirical study was conducted in two schools in Lesotho. In each school, fifteen learners volunteered participation. The investigation was done through classroom teaching by me as the researcher. The focus was on what challenges learners encountered and how they benefited from their “spreadsheets algebra” learning experience. Data were collected through classroom observations where field notes were recorded and an observation schedule was used by the researcher and the Assistant Observer respectively. A questionnaire was also administered to all learner participants after the whole teaching period. Six learners, representative of high, medium and low performances in class, were also interviewed with a goal of finding out their experiences. The Assistant Observer was also interviewed to reduce the bias that may result from to the researcher studying her own practice The study found that learners experiences with learning algebra through spreadsheets, comprised of both challenges and benefits. The challenges encountered by learners could be classified into those that were school-based and those that were instruction-based. The school-based challenges related to inadequate physical structures and lack of well-functioning equipment in the computer laboratories. Instruction-based challenges encountered by learners were both technical and personal. Technical challenges related to the physical manipulation of the artifact and the lack of understanding of concepts involved, where the spreadsheets meet the algebra. Personal challenges related to learners’ attitude and behavior towards use of spreadsheets for algebra teaching and learning. While school authorities could address some of the challenges, it was found that both the teacher and learners could initiate strategies that could be used to overcome the instruction-based challenges. Teaching strategies such as “technical-demo”, “explain-the-screen”, “discuss-the–screen”, “link-screen-board” and “spot-and-show” (building on learners’ responses), and the general organization of classroom environment were helpful in orchestrating algebra learning within the spreadsheets. It was also found that use of spreadsheets had both cognitive and affective values for the learners. Even though use of spreadsheets may benefit both teachers and learners in algebra teaching and learning, implementation of the practice would require critical considerations in terms of teacher preparation and infra-structural improvements in the schools.
AFRIKAANSE OPSOMMING: Die onderrig en leer van algebra in die middelbare skoolgrade in Lesotho word oorheers deur die meganiese benadering waarvolgens leerders gedril word in prosedures om oplossings vir sekere tipe algebraprobleme te vind en die ervaring wat leerders in rekenkunde opgedoen het, nie daarmee in verband gebring word nie. Dit is een van die oorsake waarom leerders met wiskunde sukkel. Navorsing toon dat die gebruik van sigblaaie soos Excel moontlik die gaping tussen rekenkunde en algebra kan oorbrug, en dat die onderrig en leer van algebra daardeur kan verbeter, wat dit sinvol vir leerders sal maak. Die studie was daarop gemik om ’n antwoord op die volgende vraag te vind: Hoe ervaar graad 9-leerders in Lesotho die onderrig en leer van algebra deur middel van Excel-sigblaaie? Die navorsing het met ’n literatuuroorsig begin en is deur ’n empiriese studie opgevolg. Die teorieë instrumentele genese en instrumentele orkestrasie is uitgewys as die raamwerk vir die ondersoek. Instrumentele genese is die proses waarvolgens leerders bedrewenheid in die produk ontwikkel namate hulle dit gebruik om lesdoelstellings te bereik; tegniese (konseptuele, meganiese) en persoonlike (ingesteldheid, gedrag en voorkeurleerstyle) aspekte van leerders se ervarings is geïdentifiseer. Instrumentele orkestrasie is die stuur van leerders se instrumentele genese deur die onderwyser; en die wyse waarop hierdie proses uitgevoer word, hang van die onderwyser se Tegnologiese Pedagogiese Inhoudskennis (TPCK) af. Die navorsing het ’n meervoudige gevallestudie gebruik en ’n gemengde metodebenadering is gevolg, terwyl beide kwalitatiewe en kwantitatiewe metodes gebruik is. Die empiriese studie is in twee skole in Lesotho uitgevoer. Vyftien leerlinge uit elke skool het vrywillig deelgeneem. Die ondersoek is by wyse van klaskameronderrig deur my as die navorser gedoen. Daar is gefokus op die uitdagings wat leerders teëgekom het en hoe hulle by die “sigbladalgebra”-leerervaring gebaat het. Data is aan die hand van klaskamerwaarnemings versamel, waar veldnotas afgeneem is en ’n waarnemingskedule onderskeidelik deur die navorser en die assistentwaarnemer gebruik is. ’n Vraelys is na die volle onderrigtydperk by al die leerderdeelnemers afgeneem. Onderhoude is gevoer met ses leerders, wat hoë, medium en lae prestasies in die klaskamer verteenwoordig, met die doel om hulle ervarings te bekom. ’n Onderhoud is ook met die Assistentwaarnemer gevoer om vooroordeel, deurdat die navorser moontlik haar eie praktyk kon bestudeer, te verminder. Die studie het bevind dat leerders se ervarings met die leer van algebra deur middel van sigblaaie uitdagings sowel as voordele inhou. Die uitdagings wat leerders teëgekom het, kan onderskeidelik as skoolgebaseerde uitdagings en onderrig-gebaseerde uitdagings geklassifiseer word. Die skoolgebaseerde uitdagings hou verband met onvoldoende fisiese strukture en ’n gebrek aan behoorlik funksionerende toerusting in die rekenaarlaboratoriums. Die onderrig-gebaseerde uitdagings vir leerders is beide tegnies en persoonlik. Tegniese uitdagings hou verband met die fisiese manipulering van die produk en ’n gebrek aan begrip ten opsigte van die betrokke konsepte, naamlik waar die verband tussen die sigblaaie en algebra bestaan. Persoonlike uitdagings hou verband met leerders se ingesteldheid en gedrag rakende die gebruik van sigblaaie by die onderrig en leer van algebra. Alhoewel die skoolowerhede bepaalde uitdagings kan aanspreek, is daar bevind dat onderwysers sowel as leerders strategieë kan aanvoor om onderrig-gebaseerde uitdagings te oorkom. Onderrigstrategieë soos “tegniese demo”, “verduidelik die skerm”, “bespreek die skerm”, “koppel-skerm-bord” en “vind-en-wys” (wat op leerders se reaksie voortbou), asook die algemene organisasie van die klaskameromgewing, dra tot die orkestrasie van algebraonderrig met die sigblaaie by. Daar is ook bevind dat die gebruik van sigblaaie kognitiewe sowel as affektiewe waarde vir die leerders inhou. Selfs al sou onderwysers en leerders voordeel uit die gebruik van sigblaaie in die onderrig en leer van algebra kon trek, sou die implementering van die praktyk kritiese oorwegings moet geniet ten opsigte van onderwyservoorbereiding en infrastruktuurverbetering by die skole.
19
Bernardo, Ivelize Rocha 1982. "Explicitação de esquema orientada a contexto para promover interoperabilidade semântica." [s.n.], 2012. http://repositorio.unicamp.br/jspui/handle/REPOSIP/275680.
Full textAbstract:
Orientador: André SantanchèDissertação (mestrado) - Universidade Estadual de Campinas, Instituto de Computação
Made available in DSpace on 2018-08-21T20:20:46Z (GMT). No. of bitstreams: 1 Bernardo_IvelizeRocha_M.pdf: 1642753 bytes, checksum: 79818a62ab275ff01db056b803beb9b6 (MD5) Previous issue date: 2012
Resumo: A flexibilidade proporcionada por planilhas eletrônicas possibilita sua customização seguindo modelos mentais de seus autores e as tornam sistemas populares de gerenciamento de dados. Gradativamente tem crescido a necessidade de se integrar e articular dados de diferentes planilhas e, para que máquinas possam auxiliar neste processo, o desafio é como interpretar automaticamente o seu esquema implícito, que é dirigido à interpretação humana. Alguns trabalhos propõem o mapeamento do conteúdo das planilhas para padrões abertos de interoperabilidade, principalmente aqueles da Web Semântica. A principal limitação destes trabalhos consiste no pressuposto de que é possível reconhecer e explicitar os esquemas e a semântica das planilhas automaticamente, independentemente do seu domínio. Este trabalho se diferencia por considerar o contexto e o domínio em que foram concebidas as planilhas essenciais para se traçar o conjunto de práticas compartilhadas pela comunidade em questão, que estabelece padrões de construção a serem reconhecidos automaticamente por nosso sistema, em um processo de extração de dados e explicitação de esquemas. Nossa proposta envolve uma estratégia para caracterização de padrões de construção associados a modelos conceituais de autores na construção de planilhas, que é resultado de uma ampla pesquisa de práticas compartilhadas por autores de planilhas no domínio de uso da Biologia. Neste documento apresentamos o resultado de um experimento prático envolvendo tal sistema, no qual integramos os dados de centenas de planilhas eletrônicas disponíveis na Web. Tal integração foi possível pela capacidade única de nossa abordagem de reconhecer a natureza da planilha analisada dentro de seu contexto de criação
Abstract: The flexibility provided by spreadsheets allows their customization following mental models of their authors and makes them popular data management systems. Gradually there is a growing need of integrating and join data from different spreadsheets and, to enable machines assistance in this process, the challenge is how to automatically interpret their implicit schema, which is addressed to human interpretation. In this sense, some related works propose mapping spreadsheets contents to open interoperability standards, mainly Semantic Web standards. The main limitation of such proposals is the assumption that it is possible to recognize and make explicit the schema and the semantics of spreadsheets automatically apart from their domain. This work differs by assuming the essential role of the context and the domain in which the spreadsheet was conceived to delineate shared practices of the community, which establishes building patterns to be automatically recognized by our system, in data extraction process and schema recognition. Our proposal involves a strategy to characterize building patterns related to conceptual models of authors in spreadsheets building process, which results from an extensive research of practices shared among authors of spreadsheets in the Biology usage domain. In this document we present a result of a practical experiment involving such a system, in which we integrated data from hundreds of spreadsheets available on the Web. This integration was possible due to a unique ability of our approach of recognizing the spreadsheet nature analyzed inside its creation context
Mestrado
Ciência da Computação
Mestra em Ciência da Computação
20
Mogilka, Marcelo. "O uso da planilha eletrônica no estudo das funções e equações polinomiais." Universidade Federal da Paraíba, 2016. http://tede.biblioteca.ufpb.br:8080/handle/tede/9465.
Full textAbstract:
Submitted by ANA KARLA PEREIRA RODRIGUES (anakarla_@hotmail.com) on 2017-09-08T13:29:12Z
No. of bitstreams: 1
arquivototal.pdf: 8624212 bytes, checksum: 8123f6eb13506d5865b46a957bfa1ae6 (MD5)Approved for entry into archive by ANA KARLA PEREIRA RODRIGUES (anakarla_@hotmail.com) on 2017-09-08T13:51:23Z (GMT) No. of bitstreams: 1 arquivototal.pdf: 8624212 bytes, checksum: 8123f6eb13506d5865b46a957bfa1ae6 (MD5)
Made available in DSpace on 2017-09-08T13:51:23Z (GMT). No. of bitstreams: 1 arquivototal.pdf: 8624212 bytes, checksum: 8123f6eb13506d5865b46a957bfa1ae6 (MD5) Previous issue date: 2016-07-22
Coordenação de Aperfeiçoamento de Pessoal de Nível Superior - CAPES
The use of technologies as teaching tool is a reality experienced by a significant portion of the student body in Brazil. However, there is still considerable demand for educational projects involving the teaching of mathematics with the technologies offered by computer programs. This work will address - through the Delta Project the usage of electronic spreadsheets as a tool for analysis and resolution of func- tional and polynomial equations, establishing links between the mathematical and computational knowledge.
A utilização das tecnologias como ferramentas didaticas ja é uma realidade vivida por uma parte significativa do alunado no Brasil. No entanto, o ritmo vertiginoso do avanço dessas tecnologias não é acompanhado pela devida adaptação e aplicação a realidade das escolas e, sobretudo, a realidade dos alunos. Diante deste descom- passo faz-se necessário ampliar as ofertas de trabalhos acadêmicos que utilizem as tecnologias oferecidas na forma de aplicativos, softwares ou programas específicos da area de educação, para auxiliar o professor na difícil tarefa de ensinar a matema- tica. Essa dissertação pretende contribuir exatamente nesse sentido. Através de um projeto didatico aplicado em sala de aula - o Projeto Delta - que tem como prin- cipal objetivo ampliar e aprofundar os conceitos de função quadratica, resolução de equações polinomiais, divisão de polinômios e cálculo de áreas e volumes de sólidos geométricos utilizando para tanto a planilha eletrônica como ferramenta didática e link entre os saberes das áreas de matemática e programação. Por meio de exemplos práticos da utilização da planilha eletrônica na criação de programas pelos alunos que participaram do Projeto Delta, e da devida fundamentação teórica, esse tra- balho acadêmico pretende mostrar que no processo de criar programas na planilha eletrônica para auxiliar a resolução de problemas matemáticos o aluno tem como subproduto positivo um aprofundamento do entendimento desses saberes matema- ticos e, mais ainda, uma postura analítica e protagonista diante dos conhecimentos dessa matéria em oposição a postura passiva e pouco reflexiva que, infelizmente, ainda é assumida por grande parte dos nossos alunos.
21
Duda, Rodrigo. "MATEMÁTICA FINANCEIRA E PLANILHAS ELETRÔNICAS: UMA ABORDAGEM COM A INCORPORAÇÃO DE RECURSOS COMPUTACIONAIS." UNIVERSIDADE ESTADUAL DE PONTA GROSSA, 2014. http://tede2.uepg.br/jspui/handle/prefix/1522.
Full textAbstract:
Made available in DSpace on 2017-07-21T20:56:32Z (GMT). No. of bitstreams: 1
Rodrigo Duda.pdf: 3245133 bytes, checksum: 15c17194349c83759b9a18c4b36749a0 (MD5)
Previous issue date: 2014-02-24This paper has as its goal to propose a new alternative approach to the progressions and financial math teaching, with the incorporation of technological resources. Financial math is a theme of great relevance, since it is a field of direct application of various mathematical concepts studied throughout school education. One of the concepts that used is the study of geometric and arithmetic progressions. In order to study those, an approach based on recurrence relations is proposed. Due to the relevance of financial math in the student’s school formation, it is analyzed the ways the frequencies in which the theme is addressed in the High School National Exam and in the selection processes of the Ponta Grossa State University. With the goal of stimulating the algebraic manipulation and understanding of the financial math formulas variables, it is proposed the incorporation of the technological resources, in particular, of electronic spreadsheets, in classes about the theme. Through the tool, it is proposed the viability of financial math simulators in the classroom, seeking the diversification of activities. It is also contemplated the development of an app that operates under the Android Platform, seeking portability and sharing of the simulators that can be built in the classroom.
Este trabalho tem por objetivo propor uma abordagem alternativa para o ensino de progressões e matemática financeira, com a incorporação de recursos tecnológicos. A matemática financeira é um tema de grande relevância, uma vez que é um campo de aplicação direta de vários conceitos matemáticos estudados ao longo da educação escolar. Um dos conceitos utilizados é o estudo de progressões aritméticas e geométricas. Para o estudo destes, propomos a abordagem por meio da resolução de relações de recorrência. Devido à relevância da matemática financeira na formação escolar do aluno, analisamos as diferentes formas e frequência com que a temática é abordada no Exame Nacional do Ensino Médio e nos processos seletivos da Universidade Estadual de Ponta Grossa. Com o objetivo de estimular a manipulação algébrica e a compreensão das variáveis das fórmulas de matemática financeira, propomos a incorporação de recursos tecnológicos, em particular, das planilhas eletrônicas, nas aulas sobre o tema. Por meio dessa ferramenta, propomos a viabilização da construção de simuladores de matemática financeira em sala de aula, visando a diversificação das atividades. Contemplamos também a elaboração de um aplicativo para dispositivos móveis que operam com a plataforma Android, visando a portabilidade e compartilhamento dos simuladores que podem ser construídos em sala de aula.
22
Pires, Sandra. "Matemática financeira para o Ensino Médio." reponame:Repositório Institucional da UFABC, 2014.
Find full textAbstract:
Orientador: Prof. Dr. Antonio Cândido FaleirosDissertação (mestrado) - Universidade Federal do ABC, Programa de Pós-Graduação em Mestrado Profissional em Matemática em Rede Nacional, 2014.
O objetivo deste trabalho é associar o estudo da matemática financeira com os conteúdos matemáticos que a embasam, tais como funções e sequências numéricas, em especial as progressões geométricas, ressaltando que a relação desses conteúdos articulados com situações reais do cotidiano muito contribui para que a matemática financeira seja um elemento de motivação para o ensino da Matemática, e que essa motivação possa ser desenvolvida ao longo do ensino médio. Nossa proposta é uma abordagem conceitual e prática para o tema, levando em conta os princípios básicos da matemática financeira: fatores de correção e deslocamento de quantias ao longo do tempo. Utilizamos aqui métodos de cálculo algébrico nas resoluções de problemas financeiros com destaque para os logaritmos e o método iterativo. Também utilizamos ferramentas tecnológicas como as planilhas eletrônicas e a calculadora financeira HP 12C, enfatizando a possibilidade do trabalho com vários tipos de resoluções de modo que uma justifica e confirma a necessidade de conhecimento da outra. A articulação de conteúdos matemáticos, a contextualização do tema, bem como a utilização de recursos tecnológicos no ensino da matemática financeira são fatores de relevante importância no ensino da matemática. Espera-se que este trabalho possa ser útil aos professores interessados em desenvolver o tema com seus alunos. Pensamos que a aprendizagem da matemática financeira não pode ser tratada sem a devida conceituação e contextualização ou deixada de lado, pois o estudante que possui conhecimentos financeiros poderá ser, no futuro, um consumidor mais prudente e um cidadão com vida financeira estável
The aim of this work is to associate the study of financial mathematics to the mathematical content that lies behind it such as functions and numerical sequences, in particular the geometric progressions, stressing that the relationship of these articulated content with real-world situations greatly contributes to turn financial mathematics in an element of motivation for the teaching of mathematics, and that this motivation can be developed throughout high school. Our proposal is to approach the subject both in a conceptual and practical way, taking into account the basic principles of financial mathematics: factors of correction and flow of amounts over time. We have used methods of algebraic calculation in resolutions of financial problems especially the logarithms and the iterative method. We also use technological tools such as spreadsheets and the HP 12C Financial Calculator, emphasizing the possibility of working with various resolution methods so that the use of one justifies and confirms the need for knowledge of the other. The articulation of mathematical content, the context of the subject and the use of technological resources in teaching financial mathematics are factors of great importance in the mathematics education. It is hoped that this work can be useful to teachers interested in developing the topic with their students. We believe that the learning of financial mathematics should not be treated without proper conceptualization and contextualization or put aside, because the student who has financial expertise may be, in the future, a more cautious consumer and a citizen with a more stable financial life.
23
Miles, David B. L. "A User-Centric Tabular Multi-Column Sorting Interface For Intact Transposition Of Columnar Data." Diss., CLICK HERE for online access, 2006. http://contentdm.lib.byu.edu/ETD/image/etd1160.pdf.
Full text
24
Cheema, John Singh. "Fallbeispiele zum Reverse Engineering im Passagierflugzeugentwurf." Bachelorarbeit, Aircraft Design and Systems Group (AERO), Department of Automotive and Aeronautical Engineering, Hamburg University of Applied Sciences, 2019. http://d-nb.info/1204245053.
Full textAbstract:
Zweck - In dieser Bachelorarbeit werden die öffentlich nicht zugänglichen Technologieparameter von Passagierflugzeugen näherungsweise bestimmt. Das sind maximaler Auftriebsbeiwert bei Start und Landung, maximale Gleitzahl und spezifischer Kraftstoffverbrauch im Reiseflug. Folgende Flugzeuge werden paarweise untersucht und verglichen: A340-300 und IL-96-300, Boeing 727-200 Advanced und TU-154M, Fokker 100 und MD-82, A319-100 und An-72. --- Methodik - Die Berechnung erfolgt mit dem Excel-basierten Werkzeug "Passenger Jet Reverse Engineering" (PJRE). Grundlage der Berechnung ist die aus dem Flugzeugentwurf bekannte Dimensionierung mit dem Entwurfsdiagramm. Für die ausgewählten Passagierflugzeuge werden die erforderlichen Eingangsparameter recherchiert. Die zunächst unbekannten Technologieparameter werden dann mit PRJE sowohl ermittelt als auch verifiziert. --- Ergebnisse - Die Ergebnisse aus dem Reverse Engineering stimmen recht gut überein mit den Werten aus der Verifikation. Lediglich die Werte der maximalen Gleitzahl im Reiseflug sind berechnet aus der Verifikation oft deutlich höher als berechnet aus dem Reverse Engineering. Der spezifische Kraftstoffverbrauch im Reiseflug hat sich über die Jahrzehnte der Flugzeugentwicklung stark verringert. --- Bedeutung für die Praxis - Durch die Konkurrenzsituation der Flugzeughersteller können viele Flugzeugparameter nicht öffentlich zur Verfügung gestellt werden. Die Anwendung von PJRE zeigt, wie diese Parameter trotzdem näherungsweise ermittelt werden können. --- Soziale Bedeutung - Eine detaillierte Diskussion über Flugkosten, Ticketpreise und die Umweltverträglichkeit des Flugverkehrs setzt detaillierte Kenntnisse über die Flugzeuge voraus. Durch ein Reverse Engineering können Verbraucher diese Diskussion mit der Industrie auf Augenhöhe führen. --- Originalität / Wert - Nach der Entwicklung von PJRE wird die Methode hier zum ersten Mal angewandt.
25
Morais, Sílvia Cristina Dorneles de. "“EXCEL: uma alternativa para o ensino de probabilidade e estatística”." Universidade Federal de Goiás, 2016. http://repositorio.bc.ufg.br/tede/handle/tede/6381.
Full textAbstract:
Submitted by Cássia Santos (cassia.bcufg@gmail.com) on 2016-10-11T10:31:41Z
No. of bitstreams: 2
Dissertação - Silvia Cristina Dorneles de Morais - 2016.pdf: 2108011 bytes, checksum: 4f95066b3d4fd9191a716470ccfbdfb4 (MD5)
license_rdf: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5)Approved for entry into archive by Luciana Ferreira (lucgeral@gmail.com) on 2016-10-11T11:40:43Z (GMT) No. of bitstreams: 2 Dissertação - Silvia Cristina Dorneles de Morais - 2016.pdf: 2108011 bytes, checksum: 4f95066b3d4fd9191a716470ccfbdfb4 (MD5) license_rdf: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5)
Made available in DSpace on 2016-10-11T11:40:43Z (GMT). No. of bitstreams: 2 Dissertação - Silvia Cristina Dorneles de Morais - 2016.pdf: 2108011 bytes, checksum: 4f95066b3d4fd9191a716470ccfbdfb4 (MD5) license_rdf: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5) Previous issue date: 2016-09-30
Coordenação de Aperfeiçoamento de Pessoal de Nível Superior - CAPES
In that work was realized a short analysis of challenges of Maths' education in the High School, in special probability and statistics, that refer to adequation of new technologys availables, distinguishing the difficults found to insert computationals resources in the classroom's every day. We emphasize the using electronics spreadsheets, in that case, Excel like a tool good to learn probability and statistic, searching to balance work's teacher to objectives presents in the Nationals Curriculums Parameters (NCP) and in the new National Common Base Curricular (NCBC), which is in the final process of elaboration. By a research with IFG's teachers, we notice that, although having access to informatics laboratories adequated to education, almost teachers do not use them. Before this situation noticed, we propose some simple activities created with the objective to connective theory from didatics books with the use of electronics spreadsheets, trying to contribute for critical formation of students.
Nesse trabalho foi realizada uma breve análise dos desafios do ensino da matemática no Ensino Médio, em especial da probabilidade e estatística, no que se refere à adequação às novas tecnologias disponíveis, salientando as dificuldades encontradas ao inserir recursos computacionais no cotidiano da sala de aula. Enfatizamos a utilização de planilhas eletrônicas, nesse caso do Excel, como uma ferramenta benéfica ao ensino de probabilidade e estatística na busca de adequar o trabalho docente aos objetivos propostos nos Parâmetros Curriculares Nacionais (PCN's) e na nova Base Nacional Curricular Comum (BNCC), que se encontra em fase final de elaboração. Através de um questionário aplicado junto a professores do IFG, constatamos que, mesmo tendo acesso a laboratórios de informática adequados ao ensino, a maioria dos professores não faz uso dos mesmos. Diante da situação vivenciada propomos algumas atividades simples, elaboradas com o objetivo de aliar a teoria estudada nos livros didáticos e a utilização de planilhas eletrônicas, procurando assim contribuir para uma formação crítica dos alunos.
26
Caers, Brecht. "Conditions for Passenger Aircraft Minimum Fuel Consumption, Direct Operating Costs and Environmental Impact." Master's thesis, Aircraft Design and Systems Group (AERO), Department of Automotive and Aeronautical Engineering, Hamburg University of Applied Sciences, 2019. http://d-nb.info/1204494622.
Full textAbstract:
Purpose - Find optimal flight and design parameters for three objectives: minimum fuel consumption, Direct Operating Costs (DOC), and environmental impact of a passenger jet aircraft. ---
Approach - Combining multiple models (this includes aerodynamics, specific fuel consumption, DOC, and equivalent CO2 mass) into one generic model. In this combined model, each objective's importance is determined by a weighting factor. Additionally, the possibility of further optimizing this model by altering an aircraft's wing loading is analyzed. ---
Research limitations - Most models use estimating equations based on first principles and statistical data. ---
Practical implications - The optimal cruise altitude and speed for a specific objective can be approximated for any passenger jet aircraft. ---
Social implications - By using a simple approach, the discussion of optimizing aircraft opens up to a level where everyone can participate. ---
Value - To find a general answer on how to optimize aviation, operational and design-wise, by using a simple approach.
27
Lucht, Dennis. "Überprüfung einer einfachen Kopfrechenmethode zur Umrechnung der Fluggeschwindigkeit von CAS in TAS." Aircraft Design and Systems Group (AERO), Department of Automotive and Aeronautical Engineering, Hamburg University of Applied Sciences, 2019. http://d-nb.info/1205624120.
Full textAbstract:
Zweck - Von Piloten werden u.a. die sogenannten "Manual Flying Skills" gefordert. Dabei muss der Pilot in der Lage sein (ohne Autopiloten) nach grundlegenden Instrumenten zu fliegen. Dafür sind neben Geschick auch Faustformeln erforderlich. Die Faustformeln müssen dafür verlässlich sein. Der Inhalt dieser Arbeit beschäftigt sich exemplarisch mit einer Faustformel zur Umrechnung der kalibrierten Fluggeschwindigkeit (Calibrated Airspeed, CAS) in die wahre Fluggeschwindigkeit (True Airspeed, TAS). --- Methodik - In Excel und Matlab werden die Ergebnisse aus den Berechnungen der Faustformel mit dem Ergebnis einer exakten Berechnungsweise anhand flugmechanischer Formeln verglichen. Dabei wird die Flughöhe und Fluggeschwindigkeit variiert. Es werden die Abweichungen ermittelt und in Diagrammen zwei- und dreidimensional visualisiert. --- Ergebnisse - Die zu prüfende Faustformel liefert in dem für Sie vorgesehen Anwendungsbereich hinreichend genaue Ergebnisse mit Abweichungen unter 5 %. Dabei nehmen die Abweichung zu, umso weiter die Parameter (Höhe und Geschwindigkeit) von typischen Reiseflugbedingungen entfernt sind. --- Bedeutung in der Praxis - Piloten können bedenkenlos auf die in dieser Arbeit geprüfte Faustformel zurückgreifen und kommen so mit überschaubarem Kopfrechenaufwand auf relativ genaue Ergebnisse. --- Wert - Diese Arbeit zeigt, wie mit mäßigem Zeitaufwand in Excel eine Faustformel über einen gesamten Bereich geprüft werden kann. Das Vorgehen kann auf weitere Faustformeln übertragen werden, sodass sich ein Pilot sein "Kniebrett" mit verifizierten Faustformeln füllen kann.
28
De, Grave Emiel. "Reverse Engineering of Passenger Jets - Classified Design Parameters." Master's thesis, Aircraft Design and Systems Group (AERO), Department of Automotive and Aeronautical Engineering, Hamburg University of Applied Sciences, 2017. http://d-nb.info/1204457298.
Full textAbstract:
This thesis explains how the classified design parameters of existing passenger jets can be determined. The classified design parameters are; the maximum lift coefficient for landing and take-off, the maximum aerodynamic efficiency and the specific fuel consumption. The entire concept is based on the preliminary sizing of jet powered civil aeroplanes. This preliminary sizing is explained in detail because it is the foundation of the final result. The preliminary sizing is combined using reverse engineering which is not a strict method. Therefore, only the basics are explained. By applying reverse engineering on the preliminary sizing and aiming for the classified design parameters as output, formulas are derived to calculate the maximum lift coefficients, the maximum aerodynamic efficiency and the specific fuel consumption. The goal is to calculate these parameters, using only aircraft specifications that are made public by the manufacturer. The calculations are complex with mutual relations, iterative processes and optimizations. Therefore, it is interesting to integrate everything in a tool. The tool is built in Microsoft Excel and explained in detail adding operating instructions. The program is executed for miscellaneous aeroplanes, supported with the necessary comments. Investigated aeroplanes are: Caravelle 10B (Sud-Aviation), Boeing 707-320C, BAe 146-200 (British Aerospance), A320-200 (Airbus), "The Rebel" (based on A320), Boeing SUGAR High, Boeing 747-400, Blended Wing Body VELA 2 (VELA) and Dassault Falcon 8X.
29
Mobarak, Barbara Ann. "The development of a computer literacy curriculum for California charter schools." CSUSB ScholarWorks, 2004. https://scholarworks.lib.csusb.edu/etd-project/2683.
Full textAbstract:
To develop leaders for the 21st century, schools must be able to prepare students to meet the high academic, technical and workforce challenges. Charter schools are increasingly attempting to meet these challenges by educating students through innovative means and by creating effectual educational programs that are more conducive to the needs of the student. This document provides a computer literacy curriculum, which will facilitate student learning of computer literacy skills.
30
Rothermel, Karen J. "Empirical studies of a WYSIWYT testing methodology." Thesis, 2000. http://hdl.handle.net/1957/33208.
Full textAbstract:
Is it possible to achieve some of the benefits of formal testing within the informal
programming conventions of the spreadsheet paradigm? We investigate
an approach that attempts to do so via the development of a testing methodology
for this paradigm. The "What You See Is What You Test" (WYSIWYT)
methodology for testing spreadsheets supplements the automatic immediate visual
feedback about values with automatic immediate visual feedback about
"testedness". In this thesis, we present empirical data about the methodology's
effectiveness resulting from two controlled experiments. The first experiment
provided interesting but inconclusive results which spurred us to consider ways
to improve the design of our experiment. We used the Cognitive Walkthrough
method to evaluate and improve our design and readministered the experiment.
Our results from the redesigned experiment show that the use of the methodology
was associated with significant improvement in testing effectiveness and
efficiency, even with no training on the theory of testing or test adequacy that
the model implements.Graduation date: 2000
31
Cao, Mingming. "Automatic test case generation for spreadsheets." Thesis, 2000. http://hdl.handle.net/1957/32777.
Full textAbstract:
Test case generation in software testing is a process of developing a set of
test data that satisfies a particular test adequacy criterion. It is desirable to
automate this process since doing it manually is not only technically difficult
but also tedious and time-consuming. Although there has been considerable
research in automatic test case generation directed at imperative languages, we
find no research exists addressing the problem for spreadsheet languages. This
problem is particularly important for spreadsheet languages, since spreadsheet
languages are widely used by end users and most of them lack testing backgrounds.
To address this need, in this thesis, we present an automatic test
case generation methodology for spreadsheet languages. Based on an analysis
of the differences between imperative languages and spreadsheet languages, we
developed our methodology by properly adapting existing test case generation
techniques for imperative languages. Our methodology is integrated with a
previously developed methodology for testing spreadsheets, and supports incremental
automatic test case generation and visual feedback. We have conducted
a family of empirical studies to assess the effectiveness and the efficiency of
the essential techniques underlying our methodology. The results of our studies
show that the test cases generated by our methodology can exercise a large percentage
of a spreadsheet under test. The results also provide insights into the
tradeoffs between two test case generation techniques for spreadsheet languages.Graduation date: 2001
32
Asavametha, Atipol. "Detecting bad smells in spreadsheets." Thesis, 2012. http://hdl.handle.net/1957/30672.
Full textAbstract:
Spreadsheets are a widely used end-user programming tool. Field audits have found that 80-90% of spreadsheets created by end users contain textual and formula errors in spreadsheets. Such errors may have severe negative consequences for users in terms of productivity, credibility, or profits. To solve the problem of spreadsheet errors, researchers have presented manual and automatic error detection. Manual error detection is both tedious and time-consuming, while automatic error detection is limited to only finding some formula error categories such as formula reference errors. Both approaches do not provide the optimum result in error detection.
We have tested a new error detection approach by detecting bad smells in spreadsheets, which is an indication that an error might be present. Originally developed for object-oriented programming, examples include the large class, and the lazy class. We have adapted the concept of bad smells to spreadsheets. Each bad smell detector might indicate an issue in the spreadsheet, but the indication is not definitive, since the user must examine the spreadsheet and make a final judgment about whether an error is actually present. We evaluated 11 bad smell detectors by analyzing the true positives against the false positives. The result shows that six detectors can highlight some error categories, such as categorical errors and typographical errors.Graduation date: 2013
33
Fisher, Marc Randall. "Helping end users create and manage test cases in the WYSIWYT methodology." Thesis, 2002. http://hdl.handle.net/1957/28615.
Full textAbstract:
Previous work has developed the What You See Is What You Test (WYSIWYT)
methodology for testing spreadsheets. This methodology has been shown
to help end users test, debug, and modify spreadsheets. To date, however, this
system has provided no support for creating, reusing, and managing test cases,
a process that can be tedious and time-consuming. To alleviate this, we have
developed automated test case generation and test reuse methodologies for the
WYSIWYT methodology. For test case generation, we have prototyped two
techniques, and performed a study to assess the effectiveness and efficiency of
these techniques. The results of this study show that we can efficiently exercise
a large percentage of a spreadsheet under test. We also implemented a test reuse
methodology and performed a study that shows that we are able to find a relatively
small subset of test cases to reuse after a modification to a spreadsheet,
and that these test cases re-establish much of the coverage lost by modifications
made to the spreadsheet.Graduation date: 2003
34
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
35
Reichwein, James. "An integrated testing and fault localization methodology for spreadsheet languages /." 2000. http://hdl.handle.net/1957/11819.
Full text
36
Sheretov, Andrei. "A methodology for testing spreadsheet grids." Thesis, 2000. http://hdl.handle.net/1957/33373.
Full textAbstract:
Although there has been research into ways to design spreadsheet systems to
improve the processes of creating new spreadsheets and of understanding
existing ones, little attention has been given to helping users of these
environments test their spreadsheets. To help address this need, we introduce
two visual approaches to testing large grids in spreadsheet systems. The first
approach is a straightforward extension of a visual testing methodology we
previously developed for individual cells (and hence is termed the Straightforward
approach), and serves as a useful baseline with which to compare the second
approach. The second approach, termed the Region Representative approach,
contributes scalability by overcoming the inefficiency of the Straightforward
approach.
Prototypes of both approaches have been tightly integrated into Forms/3,
a research spreadsheet language, and communication with the user happens
solely through the use of checkbox devices and coloring mechanisms. The intent
of this work is to bring to end users at least some of the benefits of formalized
notions of testing, without requiring knowledge of testing beyond a naive level.Graduation date: 2000
37
Takaki, Steven T. "Self-efficacy, confidence, and overconfidence as contributing factors to spreadsheet development errors." Thesis, 2005. http://hdl.handle.net/10125/11346.
Full textAbstract:
Mode of access: World Wide Web.Thesis (Ph. D.)--University of Hawaii at Manoa, 2005.
Spreadsheet programs are widely used in business and government. Unfortunately, there is strong evidence that many spreadsheets contain errors. In spite of the importance of spreadsheets in decision-making, studies have shown consistently that end-user spreadsheet developers rarely test their models thoroughly after development in the manner that professional programmers test software. One contributing factor to both error rates and the lack of post development testing may be that spreadsheet developers are overconfident in the correctness of their spreadsheets. Overconfidence is a widespread human tendency, and it has been demonstrated among spreadsheet developers. When people are overconfident, their "stopping rules" for error detection during and after development may be premature, causing them to stop checking before they should. This may contribute to the number of errors. At the same time, a research construct that appears to be closely related is self-efficacy, which has been shown that high self-efficacy is positively related to computer task performance, including spreadsheet performance (although not specifically to error reduction performance). The findings from this research concluded that people with high self-efficacy and high confidence make fewer errors than those with low self-efficacy and high confidence. Also, a "think-aloud" protocol analysis of a subset of subjects observed a lack of system design and analysis effort and a minimal amount of testing during the development of spreadsheet tasks.
Includes bibliographical references (leaves 96-103).
Electronic reproduction.
Also available by subscription via World Wide Web
ix, 135 leaves, bound .ill 29 cm
38
Gottfried, Herkimer John. "Graphical definitions : expanding spreadsheet languages through direct manipulation and gestures." Thesis, 1996. http://hdl.handle.net/1957/34287.
Full textAbstract:
Until now, attempts to extend the one-way constraint evaluation model of the
spreadsheet paradigm to support complex objects, such as colored circles or user-defined
types, have led to approaches featuring either a direct way of creating objects
graphically or strong compatibility with the spreadsheet paradigm, but not both. This
inability to conveniently go beyond numbers and strings without straying outside the
spreadsheet paradigm has been a limiting factor in the applicability of spreadsheets. In
this thesis we present a technique that removes this limitation, allowing complex objects
to be programmed directly--and in a manner that fits seamlessly within the spreadsheet
paradigm--using direct manipulation and gestures. We also present the results of an
empirical study which suggests that programmers can use this technique to program
complex objects faster and with fewer errors. The graphical definitions technique not
only expands the applicability of spreadsheet languages, it also adds to their support for
exploratory programming and to their scalability.Graduation date: 1997
39
Prabhakararao, Shreenivasarao. "Strategies and behaviors of end-user programmers with interactive fault localization." Thesis, 2003. http://hdl.handle.net/1957/31594.
Full textAbstract:
End-user programmers are writing an unprecedented number of programs, due in large
part to the significant effort put forth to bring programming power to end users.
Unfortunately, this effort has not been supplemented by a comparable effort to increase
the correctness of these often faulty programs. To address this need, we have been
working towards bringing fault localization techniques to end users. In order to understand
how end users are affected by and interact with such techniques, we conducted a
think-aloud study, examining the interactive, human-centric ties between end-user
debugging and a fault localization technique for the spreadsheet paradigm. Our results
provide insights into the contributions such techniques can make to an interactive end-user
debugging process.Graduation date: 2004
40
Percey, Ralph. "Spreadsheet activities for a data management unit : a teacher's resource using Microsoft Excel /." 2000.
Find full text
41
Halbleib, Michael D. "Using advanced spreadsheet features for agricultural GIS applications." Thesis, 2001. http://hdl.handle.net/1957/31441.
Full textAbstract:
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
42
"The design and implementation of computer-based spreadsheets for teaching and learning data handling in mathematics and mathematical literacy." Thesis, 2010. http://hdl.handle.net/10210/3259.
Full textAbstract:
M.Ed.The computer technology can be used as a complementary tool for teaching as well as a learning tool. Whilst not having the same level of computer use as the developed countries, South Africa is increasingly becoming a society of technology users; therefore, one prime goal of education would be to develop a basic knowledge of the structure and operating principle behind the use of computers in teaching and learning. This study was conducted at a selected public secondary school in Johannesburg West District, Gauteng Province. It focuses on the design and implementation of Data Handling lesson through computer-based spreadsheets for Grade 10 learners. The design type of this study is qualitative design experiment method with a small component of quantitative approach. This method is regarded as an educational intervention developed as a way of carrying out formative research to test and refine educational designs on the principles derived from earlier research. The method addressed the curricular content (Data Handling) in the classroom as well as PowerPoint, Microsoft Word and Spreadsheets software design. The design framework is derived from design principles generated from instructional system design theory and constructivist perspective. Design principles are used as a framework for the analysis of the learners’ and teacher’s experiences of a Data Handling lesson through computer-based spreadsheets. Data was collected through observation, interviews and assessment activities Findings suggested that the use of computer-based spreadsheets in teaching and learning had contributed positive effect towards the learning of Data Handling. Both teacher and her learners identified the positive experiences of fun and interest in using computer-based spreadsheets in teaching and learning.
43
Brown, Darren. "Generalizing WYSIWYT for use in the screen transition paradigm." Thesis, 2003. http://hdl.handle.net/1957/32493.
Full textAbstract:
How can rigorous forms of testing be supported in a way that is both compatible
with the visual aspect of visual programming languages, and usable by the
audiences using those languages - even when the audience has no background
in software engineering? Visual programs are likely to contain at least some
errors, and supporting a visual form of testing would give users a way to spot
those errors early in the program's life. In previous work, we have developed
a visual testing methodology known as WYSIWYT, for use in visual spreadsheet
languages, and in this work, we show formally that this methodology can
be generalized to screen transition diagrams. The algorithms and accompanying
proof of the coverage equivalence that they ensure provide the mechanisms
needed for the screen transition paradigm to incorporate WYSIWYT testing
for both professional and end-user programming audiences.Graduation date: 2004
Best scan available for figures. Original is blurry.
44
Oosthuizen, Sophia Gertruida. "Die gebruik van sigblaaie om die effektiewe leer van wiskunde te bevorder." Thesis, 2012. http://hdl.handle.net/10210/6184.
Full textAbstract:
M.Ed.The objective of this study was to explore the possibilities of applying and using the computer in the Mathematics classroom. The effectiveness of the various possibilities of this application was of particular importance, as the main motivation for the use of the computer as educational aid in the Mathematics classroom was to promote learning effectively and to transform learners from passive to active participators in the learning environment. A literary study was assigned to a broad discussion of three learning theorems. The behaviourist, information processing and constructivist learning theories were weighed up against one another. The distinguishing characteristics of each one, as well as implications thereof on the effective learning of Mathematics, were analysed. The nature of mathematical knowledge serves ultimately as criteria for effective learning. A list of criteria and guidelines, which the learning situation had to meet, in order to promote effective learning in Mathematics, was presented before the computer could be considered as an alternative teaching strategy. In the course of the study, there was regular reference to the computer as a tutor. Varius advantages and disadantages of computer aided instruction (CAI) in the Mathematics classroom were discussed thoroughly. Four types of CAI approaches were seen as alternatives to traditional teaching methods. Each of these approaches was weighed up against the suggested/recommended list of criteria which the learning situation should meet in order to promote effective learning. As an alternative to these approaches, the possibilities of application software were considered. This study focused particularly on the possibilities of the use of spreadsheets in the Mathematics classroom. Various advantages and disadvantages of the implementation of spreadsheets in the Mathematics classroom were discussed thoroughly. During an empirical study, a lesson unit, implementing spreadsheets as teaching aid, was put to the test and its value assessed. The success of this lesson unit was evaluated according to a West. In conclusion, it can be assumed that constructivist learning theory principles served as a foundation for this study which effectively promoted learning. The learners were constructively active, on the computer, and were guided in their construction of knowledge with the assistance of inductive questions and observation of the spreadsheet generated graphs. In a group situation, the learners supported one another and the teacher acted merely as facilitator. By using spreadsheets in the Mathematics classroom as an alternative to the traditional CAI material, learning could be effectively promoted as the progression of lesson aspects and phases depended on the foundation of constructivism.
45
Summet, Jay W. "End-user assertions : propagating their implications." Thesis, 2001. http://hdl.handle.net/1957/30003.
Full textAbstract:
Spreadsheet languages are the most commonly used end-user programming paradigm, yet
spreadsheets commonly contain errors. Research shows that a significant number of
spreadsheets (20%-40%) created by end users contain errors. In an attempt to reduce this
error rate, this work presents an assertion propagation system for an end-user spreadsheet
programming language, along with proofs of correctness, and complexity analysis. In
addition to the traditional benefits of assertions (dynamic error checking and the
documentation of programmer assumptions) this system deductively propagates the
implications of assertions. This propagation adds two benefits, the cross-checking of
program logic, and additional immediate visual feedback about the range of behavior of
the program code for the end-user.Graduation date: 2002
46
Ren, Bing. "Extensions to the WYSIWYT methodology." Thesis, 2001. http://hdl.handle.net/1957/29932.
Full textAbstract:
Researchers in the Forms/3 group have previously developed the WYSIWYT
methodology, exploring a way of systematically testing spreadsheet languages. The previous
work presented the WYSIWYT methodology for individual spreadsheet cells, and later
partially extended it to large grids in which some cells share the same formula. The Forms/3
spreadsheet language supports not only operations of individual cells but also some advanced
programming features such as homogeneous grids, recursive programs, and user-defined
abstract data types. Therefore, it is important for the testing methodology to support even
these more powerful features of the language, not just the "easy parts". In this document, we
present extensions to the WYSIWYT methodology for these advanced features. We optimized
the visual aspects of testing spreadsheet grids and collected experimental information about
scalability. We also developed two possible ways the WYSIWYT methodology could be
extended to accommodate recursion in terms of their testing theoretic aspects, implementation
strategies, algorithms and time complexities. Since the ultimate goal is to help the people
using these languages, we also conducted an empirical study and used its results to inform our
choice as to which of these two approaches to adopt. Finally, we developed an approach of
testing user-defined abstract data types; here we present design, implementation issues,
algorithms and time complexities.Graduation date: 2002
47
Neufeld, Jerold Dean. "Electronic spreadsheet model for comparing conservation plans for Doniphan County, Kansas." 1988. http://hdl.handle.net/2097/22199.
Full text
48
Beckwith, Laura A. "Reasoning about many-to-many requirement relationships in spreadsheet grids." Thesis, 2002. http://hdl.handle.net/1957/32374.
Full textAbstract:
Traditionally, research into end-user programming has focused on how to
make programming more accessible to end users. However, few researchers
have considered providing end users with devices to help improve the
reliability of the programs they create. To help improve the reliability of
spreadsheets created by end users, we are working to allow users to
communicate the purpose and other underlying information about their
spreadsheets using a form of requirement specifications we call "guards."
Guards were initially designed for individual cells but, for large spreadsheets,
with replicated/shared formulas across groups of rows or columns, guards can
only be practical if users can enter them across these groups of rows or
columns. The problem is, this introduces many-to-many relationships, at the
intersection of rows and columns with guards. It is not clear how the system
should reason and communicate about many-to-many relationships in a way
that will make sense to end users. In this thesis, we present the human-centric
design rationale for our approach to how the system should reason about such
many-to-many relationships. The design decisions are presented with their
reasons gleaned from two design-time models--Cognitive Dimensions and
Attention Investment--and from the users themselves in a small think-aloud
study.Graduation date: 2003