This master’s thesis deals with the design and realization of support software tool for production capacity planning in selected company. Functionality of the application will be designed according to theoretical findings (from the area of process management and business informatics) and analysis of business processes and user requirements. Final support tool should facilitate all management decisions regarding long-term planning of production and will be implemented in Microsoft Excel and Visual Basic for Applications.

Submitted by FERNANDA DA SILVA VON PORSTER (fdsvporster@univates.br) on 2016-11-30T18:06:35Z No. of bitstreams: 2 license_rdf: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5) 2016IomaradeAlbuquerqueMadeiraMartins.pdf: 3171751 bytes, checksum: 7f82be210e19e703640aa2b134bc0de8 (MD5) / Approved for entry into archive by Ana Paula Lisboa Monteiro (monteiro@univates.br) on 2016-12-07T13:23:14Z (GMT) No. of bitstreams: 2 license_rdf: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5) 2016IomaradeAlbuquerqueMadeiraMartins.pdf: 3171751 bytes, checksum: 7f82be210e19e703640aa2b134bc0de8 (MD5) / Made available in DSpace on 2016-12-07T13:23:14Z (GMT). No. of bitstreams: 2 license_rdf: 0 bytes, checksum: d41d8cd98f00b204e9800998ecf8427e (MD5) 2016IomaradeAlbuquerqueMadeiraMartins.pdf: 3171751 bytes, checksum: 7f82be210e19e703640aa2b134bc0de8 (MD5) Previous issue date: 2016-11 / A atividade docente desafia o professor a utilizar práticas pedagógicas diferenciadas que contribuam para o alcance da aprendizagem dos alunos. Por isso, este estudo de caso com abordagem qualitativa teve como objetivo geral verificar como a utilização de práticas pedagógicas diferenciadas contribuiu para a aprendizagem de conceitos como juros, empréstimos e amortização nas aulas de Matemática Financeira, no Curso de Ciências Contábeis. O embasamento teórico está alicerçado em Berbel (2011), a qual defende a utilização de metodologias que permitam ao aluno associar a teoria à prática, e em Gimenes (2013) que traz para a reflexão quais os limites e as possibilidades da aplicação de práticas pedagógicas diferenciadas na melhoria do aprendizado dos alunos. A pesquisa foi desenvolvida ao longo de 10 encontros, durante o segundo semestre de 2015, com 46 alunos do Instituto Maranhense de Ensino e Cultura – IMEC do Curso de Ciências Contábeis, nos 3º/4º períodos, na disciplina de Matemática Financeira. Como procedimentos técnicos de coleta de dados foram utilizados mapas conceituais, fotos, filmagens, relatórios e questionário. Os resultados mostraram que os alunos envolvidos neste estudo, de posse de diferentes instrumentos, entre os quais a calculadora financeira HP 12C, fazendo uso da função especial BEGIN, puderam constatar, enquanto consumidores conscientes, que nem todos os estabelecimentos comerciais visitados cumprem o que é divulgado nas propagandas. Houve, assim, uma elevação significativa e qualitativa do suporte conceitual da temática em estudo. Por meio dos relatos dos alunos, também foi possível constatar que a utilização da Planilha Eletrônica Microsoft Excel possibilitou a criação das mais diversas situações, propiciando um aprender diferenciado. Enfim, os resultados apontaram que, quando o aluno pratica os conteúdos desenvolvidos em sala de aula, a partir de práticas pedagógicas diferenciadas, pode passar a ser um indivíduo mais atento e consciente na instrumentalização e na compreensão dos juros aplicados no mercado. / The teaching activity challenges the teacher to employ different pedagogical practices that contribute to the achievement of students’ learning. Therefore, this case study aims to assess how the utilization of different pedagogical practices can contribute to learning of concepts such as interest, loans and depreciation in Financial Mathematics classes, in an Accounting Major. The theoretical basis is from Berbel (2011), which advocates the use of methodologies that allow students to associate theory to practice, and from Gimenes (2013), that considers the limitations and possibilities of the application of different pedagogical practices in improving students’ learning. This research was conducted over 10 meetings during the second half of 2015 with 46 third and fourth-semester Accounting students at Instituto Maranhense de Ensino e Cultura - IMEC in the course of Financial Mathematics. Conceptual maps, photos and footage, reports and questionnaires were used as data collection instruments. Results indicate that students who utilized different tools, among them the HP 12C financial calculator, using the BEGIN special function, could realize that not all shops visited by them in this study comply with what is disclosed in advertisements. Thus there was a significant qualitative and conceptual elevation of the support of the subject under study. Through the reports made by students, it was also established that the use of Excel spreadsheets enabled the simulation of various situations, providing a differentiated learning. Finally, results indicate that when students exercise the contents developed in the classroom, using differentiated pedagogical practices, they may become more aware and conscious in relation to the instrumentalization and understanding of interest applied on the market.

Ce projet de recherche visait l'élaboration d'une série d'activités combinant l'utilisation de la technologie à l'aide du logiciel Excel et l'initiation aux relations linéaires. Les quatre parties de l'expérimentation ont été spécialement conçues afin d'introduire la notion de relations linéaires en troisième secondaire tout en portant une attention particulière à l'étude graduelle des variations de paramètres. Ainsi, dans les trois premières parties, la variation des paramètres est discrète tandis que pour la quatrième partie, la variation des paramètres est plutôt continue. Les différentes activités se distinguent surtout par leur approche « contextualisée » (la situation du taxi principalement et la piscine qu'on vide et qu'on remplit d'eau) et par l'apport significatif de la technologie dans l'apprentissage des concepts associés. De plus, les activités ont été bâties de façon à ce que les différents modes de représentation (graphique, table de valeurs et équation) soient présents sur le logiciel et que ces derniers aident réellement l'élève dans ses apprentissages. De plus, Goldenberg (1988) mentionne que la mise en évidence dans le graphique de quelques points de même abscisse aiderait à la visualisation d'une translation verticale dans le cas d'une variation de l'ordonnée à l'origine. Contrairement à l'hypothèse de Goldenberg, cette mise en évidence lors de notre expérimentation ne semble pas avoir aidé les quatre élèves à observer une translation verticale, mais plutôt une translation oblique et une réflexion. Dans un autre ordre d'idée, nous avons observé que la présence de la technologie semble avoir aidé les élèves ayant réalisé l'expérimentation à déduire l'effet dans le graphique de la variation des paramètres dans le graphique d'une fonction linéaire. ______________________________________________________________________________ MOTS-CLÉS DE L’AUTEUR : Technologie, Relation linéaire, Enseignement mathématique, Variation paramètre, Transformation géométrique.

Hösten 2018 inrättas det en ny version av läroplanen från 2011 med mer fokus på programmering. Syftet med denna litteraturstudie är att sammanställa forskningslitteraturens resultat om olika programmeringsspråks lämplighet för högstadiets matematikundervisning, samt lämpliga matematikområden. Frågeställningarna jämför tre programmeringsspråk med avseende på deras lämplighet och för- och nackdelar i matematikundervisningen. Programmeringsspråken, som jämförs, är Scratch, Python och VBA (Visual Basics of Application, programmering i Microsofts kalkylprogram Excel). Litteraturstudiens resultat visar att Scratch och Python anses vara lämpliga för nybörjare och är utvecklade för att de ska vara lätta att lära sig och förstå medan VBA är det programmeringsspråk som är utvecklat för att utföra matematiska beräkningar med. Programmeringsspråken kan användas i matematikundervisningen på likvärdiga sätt och i de flesta matematikområdena beroende på elevernas kompetens och lärarens val av uppgifter och tillvägagångssätt. Vidare är det möjligt att eleverna kan bli mer motiverade till att lära sig matematik om de har tillgång till digitala hjälpmedel eller programmering inom matematikundervisningen

The aim of this study was to investigate the role Excel could play in influencing Mathematics and Mathematical literacy learners’ interpretation of functions and their attitude towards Mathematics. I used a Mathematical Graphical Diagnostic (MGD) test, an attitude questionnaire, a reflective questionnaire and semi-structured interviews as instruments. The MGD test and the attitude questionnaire were given to 72 volunteer grade 11 learners at a former Model C school in Port Elizabeth, in the Eastern Cape. This group included 50 pure Mathematics learners and 22 Mathematical literacy learners. From this group, a smaller group of 10 learners further took part in the rest of the study were they went through an intervention were Excel was used as a teaching tool, covering concepts concerning functions. This group included 6 pure Mathematics and 4 Mathematical literacy learners. The 10 learners then re-wrote the MDG test and refilled the attitude questionnaire after the intervention. A reflective questionnaire was administered to the 10 learners after the intervention, with 5 learners from the 10 undergoing interviews in order to meet the objectives of the study. The administration of the MDG test and attitude questionnaire, interviews and reflective questionnaire enabled me to explore the relationship between learner performance and their attitude towards Mathematics as a subject, as well as the comparing the attitudes and performances between pure Mathematics and Mathematical Literacy learners. The study followed a qualitative research design, with an element of quantitative research. The qualitative data yielded findings that revealed the effectiveness of using Excel in teaching functions while the quantitative data revealed the difference in attitude and ability between pure Mathematics and Mathematical Literacy leaners. The findings of the study revealed that Excel played a major role in improving pure Mathematics learners’ results but not those of the Mathematical Literacy learners. The study also showed that technology does not necessarily impact on learners’ attitudes positively.

The main topic of this thesis is design and implementation of decision support systems in the environment of Microsoft Excel and Microsoft Access by a programmer or advanced user. The thesis provides basic theory regarding principles and the history of decision support systems. The thesis explains technologies that are the backbone of Microsoft Office suite and applies these technologies to create set of "best practices" for designing and programming decision support systems and demonstrates this set with two sample implementatios. Both implementations are compared, advantages and disadvantages of each are shown.

The presented diploma thesis deals with the evaluation of suppliers for the company Ferrit using fuzzy logic. The main part of the diploma thesis deals with the creation of proposals for the solution of the evaluation of suppliers of a selected company. Decision models are created in Microsoft Excel and MATLAB. The comparison of the results of both proposed models is the content of the part of the work.

The master‘s thesis is focused on the design and creation of an application for administration of lunch orders. The thesis includes a theoretical basis, analysis of the current situation and design of the application for orders administration. The application is created with regard to user requirements and its purpose is to increase work efficiency.

This master thesis deals with the use of fuzzy logic to evaluate the quality customers of the company TILL Ltd. The evaluation is done using Microsoft EXCEL and MathWorks MATLAB, using the main attributes and characteristics of customers. The thesis results are clear and functional fuzzy models that can be used to effectively evaluate potential and existing customers.

The diploma thesis deals with the design of models for evaluation of suppliers and their possible risks for a retail food business. Supplier risk is evaluated using fuzzy logic. Models are created in Microsoft Excel and MATLAB. At the beginning of the thesis is the problem defined in the theoretical framework, which is followed by the analytical and practical part of the thesis with proposals for solution of the problem.