2024
Topics in Numeric Tools
Name: Topics in Numeric Tools
Code: INF02315L
3 ECTS
Duration: 15 weeks/78 hours
Scientific Area:
Informatics
Teaching languages: Portuguese
Languages of tutoring support: Portuguese, English
Regime de Frequência: Presencial
Sustainable Development Goals
Learning Goals
The aim of this course is to give students basic knowledge on electronic spreadsheets. The topics covered include spreadsheet layout, formula creation, charting, report generation, and how to enhance a workbook and chart. This unit will also present spreadsheet database functions and business intelligence features.
At the end of this unit the students must achieve the following competences:
- Enter data
- Setup formulas
- Format spreadsheets in various aspects
- Create graphs
- Format data
- Understand how to use application software to analyze business cases and improve the efficiency of decision making
At the end of this unit the students must achieve the following competences:
- Enter data
- Setup formulas
- Format spreadsheets in various aspects
- Create graphs
- Format data
- Understand how to use application software to analyze business cases and improve the efficiency of decision making
Contents
1. Fundamentals of spreadsheet environment
1.1. Main features
1.2. Main areas of application
1.3. Spreadsheet organization
1.4. Data integration
1.5. Using applications help system
2. Worksheet organization
2.1. Worksheet, cell and range name management
2.2. Insert, move, copy, and delete cells, rows and columns
2.3. Cell and range reference
2.4. Range definition
3. Formulas and Functions
3.1. Operators and conditions
3.2. Formulas classes
3.3. Worksheet functions
3.4. Natural language formulas
3.5. Functions types
4. Charts
4.1. Creation
4.2. Formatting and modifying charts
4.3. Work with embedded charts
5. Business intelligence and PivotTables
5.1. Data analysis
5.2. Create, modify and format pivot table report
1.1. Main features
1.2. Main areas of application
1.3. Spreadsheet organization
1.4. Data integration
1.5. Using applications help system
2. Worksheet organization
2.1. Worksheet, cell and range name management
2.2. Insert, move, copy, and delete cells, rows and columns
2.3. Cell and range reference
2.4. Range definition
3. Formulas and Functions
3.1. Operators and conditions
3.2. Formulas classes
3.3. Worksheet functions
3.4. Natural language formulas
3.5. Functions types
4. Charts
4.1. Creation
4.2. Formatting and modifying charts
4.3. Work with embedded charts
5. Business intelligence and PivotTables
5.1. Data analysis
5.2. Create, modify and format pivot table report
Teaching Methods
The teaching of this unit will consist of lectures, tutorials, self-study and group work. The main concepts of the unit will be delivered during lectures or tutorials. Practical exercises on the concepts will be carried out during tutorials. It is expected that students will attempt the tutorial exercises prior to attending the classes.
Assessment
The evaluation consists on the method of continuous evaluation or in the method of evaluation by exam.
The continuous evaluation consists of 2 tests, each one with a weight of 50%.
The evaluation by exam consists of a single exam, with a weight of 100%.
The continuous evaluation consists of 2 tests, each one with a weight of 50%.
The evaluation by exam consists of a single exam, with a weight of 100%.
Teaching Staff
Certificações
