|
|
|
||
Last update: ROZ215 (20.11.2012)
|
|
||
Last update: Straka Petr Ing. Ph.D. (25.04.2017)
Students will know: Use of advanced functions of MS Excel. Solve more difficult problem using MS Excel. |
|
||
Last update: ROZ215 (26.09.2013)
R: Internal educational materials A: Barilla J, Simr P.: Microsoft Excel pro techniky a inženýry, Computer Press, 2008, ISBN 978-80-251-2421-5 |
|
||
Last update: ROZ215 (26.09.2013)
Straka P.: Technical Calculations on PC. Presentations for downloading on teacher's website |
|
||
Last update: Straka Petr Ing. Ph.D. (25.04.2017)
1. Introduction - using of MS Excel in technical calculations 2. Application exercises 3. Graph creation for presentation purpose, typographic rules, Import to MS Word and Power Point 4. Data import and processing (filtration, creation of histogram, etc.) 5. Application exercises 6. Optimization, non-linear equations (Solver) 7. Application exercises 8. Curve fitting (Function Solver) 9. Application exercises 10. Numerical integration 11. Application exercises 12. Application exercises 13. Application exercises 14. Credit test |
|
||
Last update: Straka Petr Ing. Ph.D. (13.08.2013)
Application of Computer Techniques or Applications of Computer Science |
Teaching methods | ||||
Activity | Credits | Hours | ||
Příprava na zkoušku a její absolvování | 2 | 56 | ||
Účast na seminářích | 2 | 56 | ||
4 / 4 | 112 / 112 |
Coursework assessment | |
Form | Significance |
Continuous assessment of study performance and course -credit tests | 100 |