|
Data Integration into a CRM System
Pořízek, David ; Bartík, Vladimír (referee) ; Kolář, Dušan (advisor)
Práce se zabývá analýzou firemního CRM systému se zaměřením na integraci externích dat. Na základě výsledků práce je navržena aplikace, která zjednodušuje zpracování dat a zpřístupňuje ji běžným uživatelům z řad zákazníků firmy. Návrh aplikace vychází z existujících omezení a požadavků firmy. Aplikace je následně implementována tak, aby předešla většině chyb, které mohou nastat při přípravě a zpracování zdrojových dat.
|
|
Multiple Type Office Documents Diff
Varga, Tomáš ; Volf, Tomáš (referee) ; Chmelař, Petr (advisor)
This bachelor thesis deals with comparing different types of office documents. The aim of this thesis is to create a module into an existing application called mediadiff for comparing documents of the Open Office office suite, including text documents, presentations and spreadsheets. This thesis describes algorithms for comparing text and tree structures. Furthermore, there are described the best known office suites and Access to the content of their documents.
|
|
OLAP Interface in Spreadsheet Form
Kužela, Alois ; Kroulík, Jan (referee) ; Hruška, Tomáš (advisor)
This thesis envisages the possibilities of data transport from portal applications into spreadsheets. The main goal is to find out a solution to export data in suitable form for MS Excel application. The thesis also shows principles of the OLAP. It describes OLAP internal data model and shows the way, how data could be exported from a website into spreadsheets. It enlarges SYLK and XML file formats, which are suitable for data representation in MS Office Excel spreadsheet.
|
|
Collection of spreadsheet exercises designed for use in secondary schools
Kafka, Miloš ; Černochová, Miroslava (advisor) ; Leipert, Jiří (referee)
The aim of this thesis is to create a collection of tasks that would address the students of secondary schools, secondary vocational schools and grammar schools by using a spreadsheet. Collection of tasks will respond to the theoretical background, which is mainly based on the requirements for the knowledge and skills to work with spreadsheets in the curricula of the Czech and Slovak secondary schools and ECDL standards. Other theoretical bases are the analysis of learning tasks in the books, a survey among secondary school teachers, through which we discover how the spreadsheet is used and what tasks the students dealt with this application. Collection of tasks will offer a wide range of tasks of varying difficulty allowing cross-curricular use. Powered by TCPDF (www.tcpdf.org)
|
|
Collection of spreadsheet exercises designed for use in secondary schools
Kafka, Miloš ; Černochová, Miroslava (advisor) ; Leipert, Jiří (referee)
The aim of this thesis is to create a collection of tasks that would address the students of secondary schools, secondary vocational schools and grammar schools by using a spreadsheet. Collection of tasks will respond to the theoretical background, which is mainly based on the requirements for the knowledge and skills to work with spreadsheets in the curricula of the Czech and Slovak secondary schools and ECDL standards. Other theoretical bases are the analysis of learning tasks in the books, a survey among secondary school teachers, through which we discover how the spreadsheet is used and what tasks the students dealt with this application. Collection of tasks will offer a wide range of tasks of varying difficulty allowing cross-curricular use. Powered by TCPDF (www.tcpdf.org)
|
|
Certification programme ECDL - supporting study for public administration employees
Žák, Daniel ; Očenášek, Vladimír (advisor) ; Rysová, Hana (referee)
The theme of this bachelor is focused on the certification programme ECDL and its use for public public administration employees to test computer literacy, to increase labor productivity and saving time. The bachelor describes basic and advanced options and features in word processor and a spreadsheet of Microsoft Office Word and Excel version 2013. This bachelor is focused on certification programmes ECDL Core and ECDL Advanced. The first part contains a comparison of educational content from SharePoint, which is available to employees of the Office of Labour, with the requirements of knowledge, necessary for each version of the certification programme ECDL. The comparison should show if learning materials are consistent with the requirements of certification programmes ECDL Core and ECDL Advanced. In another part for employees who are interested in certification programme ECDL, are created selected illustrative examples by which it will be possible to try out certain requirements from ECDL Core and ECDL Advanced syllabus. Followed by testing of public administration employees in these selected illustrative examples, particularly at the contact office of the Labour Office for Prague 6 and 17. After testing is followed by a questionnaire on the usability of the ECDL certificate in public administration.
|
|
Testing of computer literacy
Procházka, Karel ; Očenášek, Vladimír (advisor) ; Kánská, Eva (referee)
The theme of this work is called "Testing of computer literacy". It is focused
on testing the issue of computer literacy and more specifically in the field of office suites Microsoft Office Word, Excel, PowerPoint and Access, version 2013. Testing is related
to the students of high schools, but created practical tasks can be further used for staff
in an operating company. The theoretical part describes computer literacy. It describes
the way how the computer literacy can be obtained, what is needed in the testing
and which methods are being examined. Great attention is also given to the topic of how information technology affects society and which programs the government of the Czech Republic applies to this area. The practical part deals with creating practical examples
and appreciation of prices when buying certificates. As the outcome of this thesis
are created practical examples which include working with documents, data, tables, images and the associated testing of students which evaluates their skills. A part of the testing
is a test, which verifies the required knowledge in the field of office packages, hardware, software and digital literacy.
|
|
Data Integration into a CRM System
Pořízek, David ; Bartík, Vladimír (referee) ; Kolář, Dušan (advisor)
Práce se zabývá analýzou firemního CRM systému se zaměřením na integraci externích dat. Na základě výsledků práce je navržena aplikace, která zjednodušuje zpracování dat a zpřístupňuje ji běžným uživatelům z řad zákazníků firmy. Návrh aplikace vychází z existujících omezení a požadavků firmy. Aplikace je následně implementována tak, aby předešla většině chyb, které mohou nastat při přípravě a zpracování zdrojových dat.
|
|
Multiple Type Office Documents Diff
Varga, Tomáš ; Volf, Tomáš (referee) ; Chmelař, Petr (advisor)
This bachelor thesis deals with comparing different types of office documents. The aim of this thesis is to create a module into an existing application called mediadiff for comparing documents of the Open Office office suite, including text documents, presentations and spreadsheets. This thesis describes algorithms for comparing text and tree structures. Furthermore, there are described the best known office suites and Access to the content of their documents.
|
|
OLAP Interface in Spreadsheet Form
Kužela, Alois ; Kroulík, Jan (referee) ; Hruška, Tomáš (advisor)
This thesis envisages the possibilities of data transport from portal applications into spreadsheets. The main goal is to find out a solution to export data in suitable form for MS Excel application. The thesis also shows principles of the OLAP. It describes OLAP internal data model and shows the way, how data could be exported from a website into spreadsheets. It enlarges SYLK and XML file formats, which are suitable for data representation in MS Office Excel spreadsheet.
|