Management Information Systems I

There is no need for knowledge other than that obtained in secondary education.

The methodology used is expository, for the presentation of the concepts of the curricular unit, supported by practical experimentation through the realization 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 classes, students must develop complementary work, which will be indicated throughout the course unit.

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.8. Query and reference functions

2.2.7. logic functions

2.2.3. Statistical and descriptive analysis functions

2.2.6. Date and time functions

2.2.9. Text and information functions

2.3. Graphics

2.4. Database

2.4.1. data sorting

2.4.2. data filters

2.4.3. Subtotals

NAO

1. Katherine Smith, Smith Murphy and Lawrence Smith (2002), “Microsoft Excel for Accounting: The First Course”, Prentice Hall. 
2. Bill Jelen (2010), “Microsoft Excel 2010 in Depth”, QUE. 
3. John Walkenbach (2010), “Excel 2010 Bible”, John Wiley & Sons.