|
| |
|
|
Network investigative activities in school instruction of spreadsheets
ŠIMANDL, Václav
The work is concerned with preparing exercises for the teaching of bulk data processing in the environment of a spreadsheet program. The exercises can be used in the lessons of ICT in the upper stage of the elementary school and in secondary schools. Presently a lot of exercises exist. These exercises are based on obsolete or uninteresting data or directly on artificial data. On the contrary there are few exercises which are based on up to date data or on data which the students entered. In the work there is an emphasis on the importance of creating exercises which are based on up to date data which is freely accessible on the Internet. For example geographical, economic or meteorological data. A software application which can download this data and transfer it into a suited format for further use in a spreadsheet program is a part of the work. We can note the benefit of using exercises, where data has been entered by the students of the class. A part of the work is a software solution which makes a survey possible for the teacher. The students answer the questions in the survey via a form. These answers are worked up into a table for further use in the lessons. An important part of the work is a set of methodical sheets. These sheets contain topics for exercises, which are specialized in bulk data processing. They show acceptable elaboration of downloaded or measured data and possible interpretation of the results. The main objective of the work is to show how and where to get up to date and attractive data for the teaching of bulk data processing and how to use it. The software and the methodical sheets should contribute to this.
|
|
|
Analysis of the cereal food products using mathematical modelling
Grygárková, Eva ; Jablonský, Josef (advisor) ; Škulavíková, Štěpánka (referee)
The bachelor thesis deals with nutritional values of cereal food products from three companies (Nestlé, Bona Vita and Emco). In the first part of the thesis linear programming models are described. The next chapter deals with the characteristics of the real situation in which Guideline Daily Amounts and nutritional values of specific cereal food products are set, and economic and mathematical model is formulated. The last part is devoted to numerical experiments. At first, the models are solved in MS Excel 2007 and then some of them are analysed in LINGO modelling system. The main aim of the thesis is to determine whether cereal food products are healthy and nutritious in terms of their nutritional values. The proposed models determine the individual portions of cereal food products consumed per day using the minimum costs that are spent for the purchase of the products.
|
|
|
System for computing distribution problems LP – Lingo/Excel interface
Lhoták, Petr ; Jablonský, Josef (advisor) ; Mynařík, Petr (referee)
This thesis deals with description of several distribution problems and their solutions. Distribution problems are the most typical problems of linear programming, which solves the optimalization of transportation of materials, people or goods. For this purpose I created an application, which combines two computer systems and makes computing of these problems easier. Concretely by combining of the systems LINGO and MS Excel through Visual Basic for Applications. Further in this work you will find solved examples of transportation problem, allocation problem, assignment problem and travelling salesman problem. You will also find the description of the main procedures of LINGO system and its connection to MS Excel through VBA. Last but not least there is brought up the programming solution of the application and its visual construction.
|
|
|
Stochastické modely a jejich řešení v MS Excel
Müller, Jan ; Kořenář, Václav (advisor) ; Pelikán, Jan (referee)
The aim of this thesis is to create an application in MS Excel, which would have been able to count on basic stock models, and Markov decision processes with alternatives. This issue is devoted to the first part of the work. This is the theory needed to understand the basic principles and method of calculation tasks. The second part describes the developed application that can be solved one-product and multiproduct deterministic stock models, stochastic stock models and Markov decision processes with alternatives, and changing valuation of the transition. The description is supplemented with graphic images directly from the application, which makes using applications easier to understand. The part of work is also CD with created application.
|
|
|
Using of VBA language in statistical analysis
Trávníček, Lukáš ; Řezanková, Hana (advisor) ; Vrabec, Michal (referee)
The main thesis aim is to introduce possibilities of MS Excel in data analysis and to point out to some strengths and weaknesses of MS Excel in data processing. I pay attention to tools which MS Excel contains by default as well as to statistical products which are not normally part of MS Excel. These products can be run in MS Excel environment as statistical add-ins for MS Excel. In the first case I focus on MS Excel tools as statistical functions, graphic analysis and statistical methods, in the other case on statistical products as XLStatistics, Analyse it, WinSTAT. In connection with the first mentioned statistical product I show some examples how to analyze and work with real data samples in product XLStatistics. The aim of this part is to show other way how to analyze data then in the others products or MS Excel itself. At the end of my thesis I programmed my own product Regxcel with the help of VBA language as the main contribution of my entire work. Product Regxcel provides solution in regression analysis for the six most common types of regression function. The main aim of this part is to point out to other possibility how to analyze data and solve some problems which users can face in regression analysis in MS Excel. I also try to show VBA language as big help in data processing in MS Excel. At the very end I presented all possibilities of Regxcel on real data sample. The product itself is part of attached CD
|
|
|
Stock models and their solution in MS Excel
Olejár, Filip ; Kořenář, Václav (advisor) ; Flusserová, Lenka (referee)
The goal of my thesis was to analize special stock models and to create a small aplication in MS Excel. Introduction is devoted to common description of stocks. The main part is focused on special stock models especialy on quantity rabate and model Q system. Application in MS excel is created for this models. In conclusion I verified application on fictive datas.
|
|
|
The Solving of Distribution Problems in MS Excel / LINGO
Bisová, Sára ; Jablonský, Josef (advisor) ; Skočdopolová, Veronika (referee)
The goal of this work is to explain the topic of distribution problems, special kind of linear programming problems, and also to show possibilities for solving them in some programming systems. For solving several types of distribution problems - transportation problem, container transportation problem, assignment problem, allocation problem and travelling salesman problem - I have created an application which connects MS Excel with programming language LINGO. This connection is realized by means of VBA - Visual Basic for Applications. There are described the main procedures and functions of LINGO and VBA including minute description of interconnection of these systems. Created application is illustrated on several small problems in the last part of work.
|
|
|
Sudoku - formulation of the problem and it 's solution
Novák, Jakub ; Jablonský, Josef (advisor) ; Zouhar, Jan (referee)
The purpose of this Bachelor thesis was to formulate sudoku problem and to create an application which was able to solve a real sudoku puzzles. First two chapters consist common information. First is about sudoku and second about linear programming. Third chaper is about formulation of the problem and it's mathematical model. In last chapter is written about creating of application which is separated into three parts. In first part there is enviroment of MS Excel which is going to be prepeared for inserting data and displaying of results. In second part is described created linear model in optimalization software MPL for Windows. The last part of creating of application contains object library OptiMax, which allows starting optimalization from MS Excel.
|
|
| |
guest ::
