Programming Tools and Fundamentals of Data Processing

Course guarantor:

Petr Písařík

Lecturer:

Petr Písařík

Tutor:

Petr Písařík

Supervisor:

Department of Natural Sciences

Synopsis:

The course is focused on the practical mastery of such software tools, which the student will use not only during their studies, but especially will use these tools and instruments in practice. The course aims to get acquainted with modern software and focuses on office applications, processing and visualization of experimental data and graphic presentation. Selected topics of the course are aligned with the syllabus of the internationally recognized concept of testing computer knowledge and skills ECDL (European Computer Driving License).

Requirements:

Attendance at seminars in min. range 80%

Successful completion and submission of all assigned tasks

Syllabus of lectures:

1. Basic applications - MS Office and OpenOffice I: word processing and editing 1

2. Basic applications - MS Office and OpenOffice I: word processing and editing 2

3. Basic applications - MS Office and OpenOffice II: spreadsheets 1

4. Basic applications - MS Office and OpenOffice II: spreadsheets 2

5. Basic applications - MS Office and OpenOffice III: presentation

6. Basic applications in the MS Windows environment: processing of image and technical documentation

7. Samples of tasks and credit

Syllabus of tutorials:

1. Basic applications - MS Office and OpenOffice I: word processing and editing 1

2. Basic applications - MS Office and OpenOffice I: word processing and editing 2

3. Basic applications - MS Office and OpenOffice II: spreadsheets 1

4. Basic applications - MS Office and OpenOffice II: spreadsheets 2

5. Basic applications - MS Office and OpenOffice III: presentation

6. Basic applications in the MS Windows environment: processing of image and technical documentation

7. Samples of tasks and credit

Study Objective:

To get acquainted with modern software, gain basic experience with office applications, processing and visualization of experimental data and creating a graphic presentation.

Study materials:

[1] LAMBERT, J. Microsoft Office 2019 Step by Step. 1st ed. Microsoft Press,U.S. 2018. ISBN 9781509305872.

[2] WILSON, K. Exploring Microsoft Office : The Illustrated, Practical Guide to Using Office and Microsoft 365. 1st ed. Elluminet Press 2020. ISNB 9781913151362.

[3] KENNEDY, J. Complete ECDL 5. 1st ed. Gill Education 2008. ISBN 9780717139842.

Note:

Time-table for winter semester 2024/2025:

	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
Wed	roomKL:B-435 Písařík P. 16:00–16:50 ODD WEEK (lecture parallel1) Kladno FBMI roomKL:B-435 Písařík P. 17:00–17:50 ODD WEEK (lecture parallel1 parallel nr.1) Kladno FBMI roomKL:B-435 Písařík P. 19:00–19:50 ODD WEEK (lecture parallel2 parallel nr.2) Kladno FBMI roomKL:B-435 Písařík P. 16:00–16:50 EVEN WEEK (lecture parallel3) Kladno FBMI roomKL:B-435 Písařík P. 17:00–17:50 EVEN WEEK (lecture parallel3 parallel nr.3) Kladno FBMI roomKL:B-435 Písařík P. 19:00–19:50 EVEN WEEK (lecture parallel4 parallel nr.4) Kladno FBMI roomKL:B-435 Písařík P. 18:00–18:50 ODD WEEK (lecture parallel2) Kladno FBMI roomKL:B-435 Písařík P. 18:00–18:50 EVEN WEEK (lecture parallel4) Kladno FBMI
Thu
Fri

Time-table for summer semester 2024/2025:

Time-table is not available yet

The course is a part of the following study plans:

• Optics and Optometry (compulsory course)