Logo ČVUT
CZECH TECHNICAL UNIVERSITY IN PRAGUE
STUDY PLANS
2020/2021

Software in Industrial Engineering

Login to KOS for course enrollment Display time-table
Code Completion Credits Range Language
XP13SID Z,ZK 4 2P+2C Czech
Lecturer:
Martin Molhanec (guarantor)
Tutor:
Martin Molhanec (guarantor)
Supervisor:
Department of Electrotechnology
Synopsis:

Introduction to using of IBM compatible personal computers, their architecture. Using of application programs for mathematics, graphics, text processing, database and CAD, examples of software systems. Introduction to user interface based on Microsoft Windows.

Requirements:

To get credits student has to attend a seminars, fulfil all semester themes and pass final course test. Additional information exists on web page of the course.

Syllabus of lectures:

1) Measured data formats: csv, fixed data. Other formats used for processing and archiving: xml, json. Structured and unstructured data. Data on the Internet and in the database. Text data.

2) Tools for processing csv and other data types. Batch data processing in Windows and Linux. Suitable scripting languages ​in Windows and Linux. Command line. Using pipe and redirection in Windows or Linux.

3) Data manipulation, data searching, data modification and filtering. SQL (base). Xpath (base). Data accuracy. Data cleaning.

4) Statistical data processing. Mean and average. Scattering, standard deviation. Population and selection. Correlation and covariation. Hypothesis testing. Normality tests. Anova (basis). Model calculation, least squares method.

5) Data visualization and interpretation. Scatter diagram, boxplot, bar chart. Histogram. Pie diagram. More 2D and 3D diagrams. Diagram creation diagrams to illustrate technological data. Axis Descriptions Color choice.

6) Excel and its use for data processing. Named areas. Array functions and constants. Tables. Nut. Pivot tables. Graphs with respect to statistical outputs. Add-Ins. VBA (foundation).

7) Matlab (Matlab basics should already be known from other subjects) and similar. Processing of csv data. Statistical toolbox. Database connection. Visualization with respect to statistical outputs.

8) Mathematica (basics should already be familiar with mathematics courses). Similar to Matlab, to discuss data processing, ie acquisition, filtering, statistics and appropriate visualization.

9) Python and Julia. Language basics. Data processing libraries. Use for data processing. Internet data and database access.

10) Python and Julia. More demanding construction. Working with matrices. Functional approach. Pandoc Library. Statistics and graphical outputs.

11) R system. Language basics. Work with data. Statistics. Graphical output.

12) Data interpretation. What can be deduced from the data. Regression, correlation, optimization, simulation.

13) Data presentation. Publishing data. Open access. Copyright.

14) Interfaces through which we get data.

Syllabus of tutorials:

1) Measured data formats: csv, fixed data. Other formats used for processing and archiving: xml, json. Structured and unstructured data. Data on the Internet and in the database. Text data.

2) Tools for processing csv and other data types. Batch data processing in Windows and Linux. Suitable scripting languages ​in Windows and Linux. Command line. Using pipe and redirection in Windows or Linux.

3) Data manipulation, data searching, data modification and filtering. SQL (base). Xpath (base). Data accuracy. Data cleaning.

4) Statistical data processing. Mean and average. Scattering, standard deviation. Population and selection. Correlation and covariation. Hypothesis testing. Normality tests. Anova (basis). Model calculation, least squares method.

5) Data visualization and interpretation. Scatter diagram, boxplot, bar chart. Histogram. Pie diagram. More 2D and 3D diagrams. Diagram creation diagrams to illustrate technological data. Axis Descriptions Color choice.

6) Excel and its use for data processing. Named areas. Array functions and constants. Tables. Nut. Pivot tables. Graphs with respect to statistical outputs. Add-Ins. VBA (foundation).

7) Matlab (Matlab basics should already be known from other subjects) and similar. Processing of csv data. Statistical toolbox. Database connection. Visualization with respect to statistical outputs.

8) Mathematica (basics should already be familiar with mathematics courses). Similar to Matlab, to discuss data processing, ie acquisition, filtering, statistics and appropriate visualization.

9) Python and Julia. Language basics. Data processing libraries. Use for data processing. Internet data and database access.

10) Python and Julia. More demanding construction. Working with matrices. Functional approach. Pandoc Library. Statistics and graphical outputs.

11) R system. Language basics. Work with data. Statistics. Graphical output.

12) Data interpretation. What can be deduced from the data. Regression, correlation, optimization, simulation.

13) Data presentation. Publishing data. Open access. Copyright.

14) Interfaces through which we get data.

Study Objective:

The aim of the study is to gain sufficient knowledge of working with a personal computer in engineering applications.

Students should be able to work independently on a personal computer and understand its principles.

The study is focused and the use of computer for work in technical fields.

Study materials:

[1] Paul Thurrott, Rafael Riviera, Windows 7 Secrets, Wiley 2009

[2] Katherine Murray, Microsoft office 2010 Plain & Simple, Microsoft Press 2010

[3] Roderick W. Smith, Linux in a Windows World, O'Reilly Media 2005

[4] Rand Morimoto et al., Windows Server 2008 R2 Unleashed, Sams 2010

Note:
Further information:
https://moodle.fel.cvut.cz/courses/XP13SID
Time-table for winter semester 2020/2021:
06:00–08:0008:00–10:0010:00–12:0012:00–14:0014:00–16:0016:00–18:0018:00–20:0020:00–22:0022:00–24:00
Mon
Tue
roomT2:C4-264
Molhanec M.
16:15–17:45
(lecture parallel1)
Dejvice
Laborator 264
roomT2:C4-264
Molhanec M.
18:00–19:30
(lecture parallel1
parallel nr.1)

Dejvice
Laborator 264
Fri
Thu
Fri
Time-table for summer semester 2020/2021:
Time-table is not available yet
The course is a part of the following study plans:
Data valid to 2020-09-22
For updated information see http://bilakniha.cvut.cz/en/predmet11850204.html