Base Knowledge
Undefined.
Teaching Methodologies
Classes will be taught in a theoretical-practical regime, using computers and digital tools.
Student-centered teaching and learning, provision of teaching materials in advance, development of activities and classes almost entirely aimed at applying concepts, with a fundamentally interactive dynamic.
This methodology allows the monitoring, knowledge and regular awareness of the syllabus covered each week, promoting discussion, involvement and collaboration of everyone in the learning process.
Learning Results
Information Technology and, in this domain, computer applications have an increasingly predominant role in most activities and areas of knowledge.
Thus, the main objectives of this course, UC, focus on the acquisition of knowledge in the field of Information Technologies, from the user’s perspective.
It is also the objective of this UC, to sensitize students to the importance of computer applications and, in particular, the Microsoft Excel spreadsheet; highlighting its importance in solving concrete problems, organizing and processing data, calculating, building reports and presenting conclusions.
It is intended that the monitoring of the teaching component of the UC allows the acquisition of a set of skills/aptitudes that allow to streamline and monetize work on the spreadsheet and enhance its application in different domains of knowledge.
Program
1.Computer System of Coimbra Business School | CBS
1.1. Description and characterization of the main resources available
1.2. Google Drive: Potentials and Limitations. Uploading and Downloading Information on Google Drive.
Online Editing and File Sharing in Google Drive
1.3. Construction of Online Surveys (Google Forms)
2. Microsoft Excel Spreadsheet
2.1. Elementary concepts
2.1.1. The application interface
2.1.2. Inputting and editing data, the various types of data
2.1.3. Operations with Cells, Rows, Columns, and Spreadsheets
2.1.4. Cell formatting, custom formatting
2.1.5. Create and use custom datasets and lists
2.1.6. Absolute, relative and mixed reference concepts. Creating and Manipulating Names
2.1.7. Syntax of formulas, operators and error values
2.1.8. Print Setup/Customization
2.2. Study of functions
2.2.1. Statistics Functions
2.2.2. Math and Trigonometry Functions
2.2.3. Logic Functions
2.2.4. Search and Reference Functions
2.2.5. Date and Time Functions
2.2.6. Text Functions
2.2.7. Information Functions
2.3. Graphics
2.3.1. Creating and customizing graphics
2.4. Data Validation
2.4.1. Fundamental Concepts
2.4.2. Data validation applied to concrete problems.
2.4.3. Definition and parameterization of validation, input message and output message (error message) in
the context of different criteria (stop criteria, warning and information).
2.5. Conditional formatting
2.5.1. Predefined rules
2.5.2. Create and edit new rules
2.6. Data Management and Organization
2.6.1. General Concepts of Data Structures
2.6.2. Systematic Data Ordering
2.6.3. Automatic Filters
Curricular Unit Teachers
Internship(s)
NAO
Bibliography
Fundamental Bibliography:
[1] Luís Silva Rodrigues | UTILIZAÇÃO DO EXCEL PARA ECONOMIA & GESTÃO, ISBN: 978-972-722-775-4, FCA–Editora Informática, 2016
[2] Paulo Capela Marques | Nuno Costa, FUNDAMENTAL DO EXCEL 2013, ISBN: 978-972-722-800-3, FCA–Editora Informática, 2014
Complementary Bibliography:
[3] Adelaide Carvalho, CÁLCULOS ELEMENTARES COM EXCEL – 65 EXERCÍCIOS, ISBN: 978-972-722-873-7, FCA–Editora Informática, 2017
[4] Adelaide Carvalho, GRÁFICOS COM EXCEL, ISBN: 978-972-722-876-8, FCA –Editora Informática, 2017
[5] Microsoft Excel online tutorials, available at https://digital.com/blog/excel-tutorials/