Computer Applications for Management

It will be desirable for students to know the concept of a mathematical function, as well as some examples of mathematical functions.

This curricular unit will have a frequency regime that consists of 1 weekly theoretical and practical class of 2 hours.

The expository methodology will be used for the presentation of the concepts of the curricular unit, supported by practical experimentation through the accomplishment of exercises of application of the transmitted concepts, in the computers. Practical experimentation will seek to approach, whenever possible, the situations that students will encounter in their professional lives. In addition to the classes, students must develop complementary work, which will be indicated throughout the course.

Attendance to classes is not mandatory but is recommended.

This curricular unit aims to provide students with instrumental and conceptual skills in the field of spreadsheets that are particularly useful in the context of other curricular units, as well as in the subsequent effective and efficient exercise of their professional activity.

As specific objectives of this curricular unit, it is intended that students have a basic understanding of technologies and management information systems and the role they play in organizations, that they are able to use spreadsheets in solving problems, in dealing with data, creating reports, and exposing conclusions.

At the end of the course, students should have developed the ability to solve problems using spreadsheet applications, using advanced features of these tools.

1. Introduction to Information Systems

2. Microsoft Excel spreadsheet

2.1. basic features

2.2. study of functions

2.2.1. Introduction to formulas and functions

2.2.2. math functions

2.2.3. Query and reference functions

2.2.4. logic functions

2.2.5. Statistical and descriptive analysis functions

2.2.6. Date and time functions

2.2.7. Text and information functions

2.3. Graphics

2.4. Database

2.4.1. data sorting

2.4.2. data filters

2.4.3. PivotTables and PivotCharts

2.4.4. Import and Export

NAO

1. Tutoriais online de Microsoft Excel, disponíveis em https://digital.com/blog/excel-tutorials/. 

2. Bill Jelen (2022), “Mrexcel 2022”, HOLY MACRO! BOOKS. ebook 

3. Bill Jelen (2022), “Microsoft Excel 2019 Inside Out”, MICROSOFT PRESS, U.S.

4. John Walkenbach (2010), “Excel 2010 Bible”, John Wiley & Sons.