2023
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
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.
The evaluation is based on the continuous evaluation method and consists of the following elements: an examination, a group project and an oral presentation, with the weights of 60%, 30% and 10%, respectively.
The students that choose the evaluation by exam should attend a single exam with the weight of 100%.
The evaluation is based on the continuous evaluation method and consists of the following elements: an examination, a group project and an oral presentation, with the weights of 60%, 30% and 10%, respectively.
The students that choose the evaluation by exam should attend a single exam with the weight of 100%.