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

Assessment Process
The assessment process comprises two possibilities: Continuous Assessment (CA) or Exam Assessment (EA), which are detailed below:

CA) Continuous Assessment:

This assessment method consists of six evaluation moments:

a) Two practical exams will be conducted on the computer, each lasting 45 minutes, with the option to consult non-digitized materials. Students will be notified (in class and via NONIO) at least 2 weeks in advance regarding the subject(s) to be evaluated in the practical exams.

b) Four unannounced computer-based mini-tests will be administered, each with a maximum duration of 15 minutes and the option to consult. Admission conditions for continuous assessment: The requirement for remaining in this assessment method is an attendance rate of 85% in classes.

It should be noted that:

- The final grade in the continuous assessment method is the weighted average of the grades obtained in each of the practical exams and the 4 mini-tests. The weight of the practical exams is 30% and 45%, respectively, for the first and second, and the weight of the 4 mini-tests is 25%.

EA) Exam Assessment:

The exam assessment involves a practical exam, conducted on the computer, lasting 90 minutes, scored out of 20 points. This exam will take place in any of the regular exam periods and only allows the consultation of non-digitized materials.

In either of the presented options (CA or EA), approval in the course requires obtaining a minimum final grade of 10 points. No oral exams are conducted for course approval.

NAO