Software in Industrial Engineering

Garant předmětu:

Martin Molhanec

Lecturer:

Martin Molhanec

Tutor:

Martin Molhanec

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 2023/2024:

	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	roomT2:C4-264 Molhanec M. 18:00–19:30 (lecture parallel1) Dejvice Laborator 264roomT2:C4-264 Molhanec M. 19:45–21:15 (lecture parallel1 parallel nr.1) Dejvice Laborator 264
Tue
Wed
Thu
Fri

Time-table for summer semester 2023/2024:

Time-table is not available yet

The course is a part of the following study plans:

• Doctoral studies, daily studies (compulsory elective course)
• Doctoral studies, combined studies (compulsory elective course)
• Doctoral studies, structured daily studies (compulsory elective course)
• Doctoral studies, structured combined studies (compulsory elective course)