| Course code |
09 82 1461 02 |
| ECTS credits |
5 |
| Course name in language of instruction |
Information Systems in Manufacturing |
| Course name in Polish |
Information Systems in Manufacturing (Systemy informatyczne w przemyśle wytwórczym) |
| Course name in English |
Information Systems in Manufacturing |
| Language of instruction |
English |
Form of classes
Teaching hours per semester |
|
Lecture |
Tutorials |
Laboratory |
Project |
Seminar |
Other |
E-learn. |
| Contact hours |
30 |
30 |
|
|
|
3 |
|
| Distance learning |
No |
No |
No |
No |
No |
No |
No |
| Weighted grades |
0.50 |
0.50 |
|
|
|
0 |
|
|
| Unit running the course |
Katedra Zarządzania Produkcją i Logistyki |
| Course coordinator |
dr inż. Jan Królikowski |
| Course instructors |
dr inż. Jan Królikowski |
| Prerequisites |
Proficiency in Propositional calculus, set theory, ability to count cardinality of sets, ability to determine trends using polynomials. |
| Course learning outcomes |
- Operating spreadsheets with a focus on production management
|
| Assessment methods |
Pre-competency tests; self-study tests; individual homework; final test
|
| Programme learning outcomes |
|
| Grading policies |
Successful completion of the course requires: 1. successful completion of the pre-competency tests 2. successful completion of 75% of the self-study tests 3. successful completion of 75% of the homework 4. successful completion of the final test (supervised test) |
| Course content |
1. literals, timeline, dates, complex numbers, big numbers;
2. sorting, operators;
3. arrays and array functions;
4. sentence logic and set logic
5. counting elements in a set - multiplicity theory; 6;
6. tables + numbers of elements in tables / conjunction and alternative / variants of solutions;
7. counting in non-normalized sets, statistical functions (group of eleven functions and others);
8. natural language queries. fragmenter(slicer). Text functions, date functions;
9. number-text conversion number-text-number-text-number;
10. running total + Gantt schedule;
11. pivot tables;
12. conditional formatting, VBA functions; 13;
13. VBA macros;
14. powerpivot package;
15. financial functions |
| Basic reference materials |
- Excel 2019 Bible by John Walkenbach, Michael Alexander, Richard Kusleika
|
| Other reference materials |
None |
Course workload
|
| Form of classes |
Teaching hours |
| Lecture |
30 |
| Tutorial |
30 |
| Other |
3 |
| Contact with the instructor outside of class |
1 |
| self study |
75 |
| SUM : |
139 |
|
| Comments |
|
| Updated on |
2022-03-04 10:03:12 |