The diploma thesis describes selected new teaching methods using the Information Technology. In consideration of supporting the Informatics course at University of Economics, the options of future teaching methodology development are outlined. The creation of educational tutorials in form of screencasting is considered as the first development step, for which the methodology has been drawn up. It covers preparation, implementation and publishing of the tutorials. To test the methodology, supporting learning materials were worked out accordingly for the part of the course explaining Microsoft Excel 2007 application -- in form of the illustration of the problem solving process. The created tutorials were published on the special website and presented (not only) to students. Within 14-day testing period a large dataset was acquired to provide feedback both from tracking visitors' movements on the website and from e-questionnaires. The feedback was thoroughly analysed and the conclusions were used for the optimalization of the methodology which was finalized by this step and is disposable for authors of future educational tutorials.

The thesis focuses on the creation of an appropriate solution and specific processing of a problematic statement in controlling in a spreadsheet application and also its subsequent presentation, which is an integral part of controlling. Methods used are analysis and modeling. The aim of the thesis is to demonstrate the suitability of office productivity software (with focus on spreadsheet applications) for controlling analyses. The theoretical part focuses on presenting the functionality and usability of key office productivity software from MS Office including comparison with main competition in the field of spreadsheet applications and then in the practical part of the thesis these options are clearly demonstrated on specific business example of the company Václav Hrbek. Besides key constrains of usage of office productivity software are mentioned in the conclusion of the diploma thesis.

This diploma thesis focuses on the analysis of reporting in a selected department in a selected company and then develops a proposal for a new method of reporting in Microsoft Excel and Power BI. The analytical part is preceded by an extensive theoretical search, which deals with information management in the organization and the essence of reporting applications.

This Master’s thesis presents a design of models which are intended for evaluation of Braintrast’s suppliers. Based on the evaluation, there is selected the most optimal supplier according to parameters. The model uses fuzzy logic theory to support decision making. The solution is designed in programs MATLAB and MS Excel.

This master’s thesis deals with design of models which allows to evaluate different plastic windows suppliers. Suggested model uses fuzzy logic to evaluate suppliers and is used as a support for decision-making. With small modifications, the model can be also used repeatedly. The solution itself is designed by MATLAB and MS Excel programs.

This diploma thesis deals with the design of fuzzy model for decision among suppliers of the metallurgical material for the firm VÚEZ, a.s. Levice. It describes methods and processes of a model creating. The goal is to make a decision-making system that helps a firm to make decisions among suppliers more effective that will be usable in real world and is based on firm’s requests.

The thesis employs modern analysing and simulating methods. The thesis specifically deals with the practical use of fuzzy logic for selecting clients. The aim is to create a suitable system for listing submitted applications in a chronological order within a contributory company.

Denna rapport redogör för framtagandet av ett dimensioneringsverktyg med syfte att förenkla arbetet för konstruktörer gällande håltagningar i I-balkar av stål. Examensarbetet inom byggteknik om 15 hp utfördes under våren 2020 vid Uppsala Universitet. Arbetet utfördes med stöd av Byggprojekteringsavdelingen på WSP Uppsala där handledaren arbetade under arbetets gång. Idag finns det inga svenska regler för hur håltagningar i stålbalkar enklast beräknas och arbetet har därför utgått från Canadian Institute of Steel Constructions Handbook of Steel Construction. Verktyget har tagits fram i Excel för att vara användarvänligt och tillgängligt för de allra flesta. Verktyget kan användas för att beräkna stålbalkens tvärsnittsklass, bärförmåga, den reducerade bärförmågan när håltagning utförts samt hur långt det får vara mellan håltagningar.

The planning, development and updating of the construction project are key elements for leading a project to the finish line. A programme adapted to implementation is also required to obtain the best results. The two most common work programs for creating project schedules are Microsoft Excel and Microsoft Project. A project's tasks are identified and structured in a schedule, often called Gantt Schedule. It should give employees at the workplace an idea of the ongoing project's activities, as well as upcoming important events and deadlines. A timeschedule should also be able to pare for changes and allocate the project's resources evenly to prevent congestion. An effective schedule includes project start and finish dates, needed resources, and recurring tasks for updating and monitoring the project schedule. An assignment issued by BDX Företagen AB gave me the opportunity to create a template and instruction for facilitated work on the development and updating of project schedules in Microsoft Project. BDX is a construction company primarily active in northern Sweden. They carry out assignments for both private individuals and companies in land, road and infrastructure. They work daily on the creation of ongoing and upcoming projects and use Microsoft Excel as a planning program.  The background to the assignment of BDX is their efforts to improve work primarily on updating a project's schedule with the transition from Microsoft Excel to Microsoft Project. The template created contains the basic settings required for a good structure for a schedule. It also includes notes and shorter explanations of tools and features. BDX's focus on improvement around updating provided the premise that the template also contains recurring tasks, which means that they are scheduled continuously during the project. The usage instruction provides a more detailed description of the template, basic settings, and features.

Vibrations caused due to aerodynamic excitation may cause severe limitation to the performance of turbomachines. The force resulting from the non-uniform pressure distribution within the labyrinth cavity is identified as a major source of this excitation. In order to perform rotor dynamic evaluation of rotor-bearing-seal system, accurate prediction of this force is essential. A visual basic based front-end, for a labyrinth seal analysis program, has been designed herein. In order to accurately predict the excitation force, proper modeling of labyrinth leak path is important. Thus, the front-end developed herein incorporates a leak-path geometric diagram for visual analysis of labyrinth leak path and tooth location. Furthermore, to investigate influence of various operating conditions and gas properties on excitation force (effective cross-coupling stiffness), a parametric study is performed on both the eye seal and the balance piston labyrinth seal. / Master of Science