The Management Informatics course unit connects two distinct areas of knowledge, Informatics and Management. In this curricular unit, word processing tools, such as Microsoft Word, and spreadsheets, such as Microsoft Excel, among others, in open source format, will be used.
Learning objectives and expected outcomes 1. Context and application domains of spreadsheets. 2. Microsoft Excel features and interface. 3. Topics related to data entry, formatting, validation and data import. 4. Management of spreadsheets. 5. Writing formulas and using functions. 6. Data analysis tools. 7. Creation and manipulation of dynamic tables and graphs. 8. Task automation through macros. 9. Creating simple applications in VBA. 10. Acquisition of specialized knowledge on the management of organizations for their phases of planning, organization, direction and control and an integrated information system in the context of decision-making on the "shop floor" 11. Acquisition of theoretical and fundamental knowledge in database technologies 12. Acquisition of comprehensive knowledge about the new challenges arising from digital transformation (Big Data, Internet of Things, Virtual Reality, Augmented Reality, Artificial Intelligence and Machine Learning)
Skills to develop 1. Use computer applications and the Internet in preparing documents and organizing work 2. Use and contribute to selecting the most appropriate computer applications in the preparation of documents and in the organization of work 3. Demonstrate planning and organization skills 4. Demonstrate a capacity for permanent updating, both at a technical and technological level 5. Demonstrate the ability to create organized work environments and in the strictest respect for industrial discipline 6. Adapt to the evolution of technologies and materials
Programme
1. Features of word processors; 1.1. Open Source Word processors 1.2. Microsoft Word 1.2.1. Text Effects and automating tasks; 1.2.2. Inserting special characters and formulas 1.2.3. Margins; 1.2.4. Tabs; 1.2.5. Automatic bullets and numbering; 1.2.6. Envelopes; 1.2.7. Text in columns; 1.2.8. Breaks; 1.2.9. Construction of indices; 1.2.10. Charts and graphs; 1.2.11. Models; 1.2.12. Merge; 1.2.13. Bookmarks and hyperlinks; 1.2.14. Building bibliographies
2. Features of spreadsheets; 2.1. Spreadsheets Open Source 2.2. Microsoft Excel 2.2.1. Editing and manipulation of cells 2.2.2. Page Setup and Print 2.2.3. Formulas and functions 2.2.3.1. Introduction to Formulas and Functions 2.2.3.2. Mathematical functions 2.2.3.3. Statistical functions 2.2.3.4. Financial functions 2.2.3.5. Date and Time functions 2.2.3.6. logical functions 2.2.3.7. Search and reference functions 2.2.3.8. Text and information functions 2.2.3.9. Database functions
Demonstration of the syllabus coherence with the curricular unit's learning objectives
In this curricular unit, content will be taught that allow the student to master the tools, word processor and spreadsheet, of the Microsoft productivity package, as well as concepts associated with digital transformation. In this sense, the unit will begin with introductory concepts of the productivity package, starting by approaching the word processing tool, exploring all its advanced potential. Later, we will approach the spreadsheet tool, exploring, in the same way, all its advanced potentialities that will respond to Objectives 1 to 12.
Marques, P. , & Costa, N. ;Fundamental do Excel 2013, FCA, 2014
Rodrigues, L.;Utilização do Excel para Economia & Gestão, FCA, 2016
Carvalho, A.;Excel para Gestão, FCA, 2017
Learning Methods
The methodology to be used will include expository, demonstrative and experimentation strategies. The multimedia presentations will support the most expository part of the contents. The most practical part of the subject will be mainly dedicated to carrying out activities to apply the contents taught, here the teacher assumes the role of tutor, remembering concepts and functionalities, helping and encouraging students to refine and improve their performance.
During the classes, students will always be encouraged to have a proactive stance of critical participation, about the exposed contents and to present current issues for debate.
Assessment Components
Avaliação apenas com exame final
Assessment Components
Description
Type
Time (hours)
Conclusion Date
Attendance (estimated)
Lessons
30
Individual assessment
Teste/Exame
3
Individual study
Study
74
Total:
107
Continuous Assessment
Two individual written tests, each weighing 35% of the final grade.
Two mini-tests on the e-learning platform, with a global weighting of 30% of the final grade.
Under the terms of the General Regulation: a) The students' attendance in classes will be recorded and, if the number of absences per student exceeds 30% of the total number of lessons scheduled for each course unit, the student will be automatically transferred to the final evaluation (regular season). b) In the written tests and other assessment elements mentioned, it is necessary to obtain a minimum grade of 7.5 (seven point five) points. c) If the student misses a test or receives a grade lower than 7.5 points in the tests or in another assessment element mentioned in the previous number, the student will be automatically transferred to the final evaluation (regular season). d) If the student misses or obtains less than 7.5 in the second written test, held in the same date of the final exam in the regular season, they may apply for further evaluation in the Appeal season. e) All written academic work provided for in the assessment (reports, case studies, etc.) must be submitted to the Turnitin database, available on the ISAG E-Learning platform, with a similarity rate up to 30% acceptable.
Final Exam
Final exam: 100%
Demonstration of the coherence between the teaching methodologies and the learning outcomes
The teaching methodology assumes theoretical-practical characteristics appropriate to the nature of the subjects taught and the objectives of the curricular unit. The spirit of reflection and discovery in students is encouraged as a way of truly obtaining qualifications, both in terms of the assimilation of theoretical knowledge and in terms of the ability to apply it to practical situations. In this way, the defined objectives will be achieved, both in terms of understanding the concepts and in terms of the ability to apply them in practice.