Applied informatics

In theoretical practical classes the lecture and inquisitive method is used throughout the presentation of different concepts and several exercises are solved. The students carry out a practical work in group, involving mainly application of studied subjects.

In tutorial classes, a methodology of self-learning and communication skills is followed as well as assisting the students by answering theoretical questions, problem solving and guidance of practical work.

1. Objectives: to understand the functioning of a spreadsheet, and the potential for their application to solving real problems from different fields of knowledge covered during the course.

2. Generic skills: understanding and knowledge application; conducting of judgment and decision making; communication; self-learning;

3. Specific skills: to identify key operational features of Microsoft Excel related to storage, organization and data analysis, and presentation of results; to build, interpret and solve real problems (simple), including making “what if” analysis; to instruct Microsoft Excel to automatically perform tasks normally performed manually through user defined functions or through macro recording, in a programming environment; to develop and program simple analysis.

1. Microsoft Excel fundamentals:

–      Basic concepts: interface; editing and formatting data;

–      Formulas and functions: statistics and math functions, date and time, text, research, information and referral;

–      Information Organization: constructing tables; group, summarize, sort and filter data;

–      Charts and graphics;

–      Advanced data analysis: scenarios and goal seeking; summarize and analyze large amounts of data through pivot tables and pivot charts; extract information from a web page (web query).

2. Introduction to Visual Basic for Applications (VBA) and Excel macros

–      How VBA works with Excel; security issues;

–      Programing concepts: Sub and Function procedures, operators, control and loop structures, data structures;

–      Communicating with the users.

• - Teste Prático - 100.0%

• - Teste Prático - 100.0%

NAO