| Code |
15347
|
| Year |
1
|
| Semester |
S2
|
| ECTS Credits |
6
|
| Workload |
TP(60H)
|
| Scientific area |
Engenharia e Gestão Industrial
|
|
Entry requirements |
None in particular
|
|
Learning outcomes |
The curricular unit aims for the students to develop at an advanced level the most used computer tools in the office. Specifically, the aim is to provide students with skills in terms of using the most advanced Word processing tool and presentation software, preparing them to use spreadsheets as a decision-making support tool in companies, through computing capabilities, analysis of large amounts of data, simulations, modeling, and optimization. Furthermore, it also prepares students to use the MATLAB computing environment to create, analyze, and simulate models applied in various areas, such as industrial control or financial management.
|
|
Syllabus |
1. Advanced use of word processing tools (eg, tables, indexes, cross-references, section breaks, revision tools, headers, footers, mail merge).
2. Introduction to the MATLAB computing environment (e.g. Basic Functionalities, Basic Operations and Functions, Declarations, Expressions, and Variables, Recording a Session, Vectors and Arrays, Two-Point Notation, Vector and Dot Functions, 2D and 3D Graphics, Functions Maximum and Minimum, Command Line and Call Editing, Loops for, while, and if blocks, File Manipulation, Strings, Error Messages, Input, Output Formats).
3. Advanced use of computing tools (eg Basic Functionality, Absolute and Relative References, Data Validation, Forms, Conditional Formatting, Protection, Simple and Conditional Formatting, Functions, and Graphs).
4. Advanced use of presentation tools (e.g., Designing slides, Working with text, Images, graphics, and tables, structuring transitions and animations, audio, and video, Comments or notes).
|
|
Main Bibliography |
- Building Complex Documents: Using Microsoft Word 2007, 2010, and 2013, Mark Schiavone, 2014, Sycamore Technical Press
- Excel 2013: The Missing Manual, Matthew MacDonald, 2013, O'Reilly Media
- Excel Dashboards & Reports (2nd Edition), Michael Alexander, John Walkenbach, 2013, John Wiley & Sons
- Microsoft Excel 2013: Data Analysis and Business Modeling, Wayne L. Winston, 2014, Microsoft Press
- Centro de Formação do Office 365 - https://support.office.com/pt-pt/office-training-center
- Peres, P. (2011). Excel Avançado. Edições Sílabo.
- Sítio oficial do MATLAB - https://www.mathworks.com/
- Higham, D. J. & Higham, N. J. (2016). MATLAB Guide, Third Edition. SIAM.
- Morais, V. & Vieira, C. (2006). Matlab 7 & 6: curso completo. FCA – Editora.
- Ogata, K. (1997). Solução de problemas de engenharia de controle com MATLAB. Prentice Hall do Brasil.
|
|
Teaching Methodologies and Assessment Criteria |
The techniques, tools, and functionalities studied are introduced and immediately demonstrated through practical examples. The skills are then worked on with new applications proposed to the students. The assessment consists of four distinct moments (practical test assignments due in classes). In the evaluation process, four evaluation moments are carried out after each of the main points of the program:
- Assessment moment 1: 10% (Word)
- Assessment moment 2: 10% (PowerPoint)
- Assessment moment 3: 40% (Excel)
- Assessment moment 4: 40% (MATLAB)
Students who obtain a minimum Teaching-Learning Classification of 9.5 points will be exempted from the Exam(s).
To be granted “Attendance” and, therefore, the possibility of taking Exam(s), students must attend at least 60% of the classes taught throughout the academic semester and obtain a minimum Teaching-Learning Classification of 7 points (“Attendance”).
|
|
Language |
Portuguese. Tutorial support is available in English.
|