Teaching Methodologies
The classes for this curricular unit are of a theoretical-practical nature.
The syllabus content is taught through the presentation of theory, followed by the demonstration of its application through practical
examples, and finally, students solve exercises on the topics covered.
To achieve this, slides, instructional videos, and spreadsheets with practical exercises are used.
In presenting any topic from the syllabus, the expository methodology is first employed, where the teacher solves exercises, followed by the
interrogative methodology in which students are encouraged to ask and answer questions about these exercises.
At a later stage, the active methodology is prioritized, with encouragement for students to independently solve exercises, complemented by
knowledge sharing among students.
Learning Results
The current technological society imposes constant competitiveness challenges, both in academia and in the workplace. In these contexts,
proficiency in Information and Communication Technologies is a determining factor in the preparation and selection of future graduates.
This curricular unit aims to equip students with skills in the use of Information Technologies, enabling them to solve various problems in the
field of Information Systems, as well as optimize tasks in this area.
The objectives for an IT student, from a user perspective, include:
O1 – performing a set of basic operations on a current operating system.
O2 – efficiently using Internet-based services.
O3 – performing operations in a spreadsheet at an intermediate level of proficiency.
Program
1. Brief Introduction to Using an Operating System
2. Introduction to Using Internet-Based Services
3. Spreadsheets
3.1. Concepts of Cell, Sheet, and Workbook
3.2. Cell Formatting
3.3. Basics of Formulas, Functions, Values, and Reference Types
3.4. Chart Creation and Formatting
3.5. Study of Commonly Used Functions
3.6. Identification of Different Error Types
3.8. Operations on Databases
Internship(s)
NAO
Bibliography
– MARQUES, Paulo e COSTA, Nuno, Fundamental do Excel 2013, Editora: FCA, 2014, ISBN: 978-972-722-800-3
– WALKENBACH, John, KUSLEIKA, Richard e ALEXANDER, Michael, Excel 2019 Bible: The comprehensive tutorial resource, Editor:
Willey, 2018, ISBN 9781119514763.