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.

Objectives:

1. Understand the importance and role that IT plays in organizations.

2. Attain proficiency in the essential functionalities of spreadsheets, including creation, formatting, and the use of basic formulas and functions.

3. Use spreadsheets in problem-solving.

4. Perform simple data analyses, such as sorting, filtering, and creating basic charts.

5. Create reports and be able to present conclusions.

Competencies:

1. Develop the ability to create well-structured and efficient spreadsheets for various purposes.

2. Develop the ability to solve problems using spreadsheet functionalities.

3. Know how to use the advanced features of spreadsheet 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.