Kiến thức

EC12 INTERNATIONAL ECONOMICS AND FINANCIAL MARKETS-UniTS

Professor 

Zezlina Silvia

Period 
First semester

Credits 
3

Duration/Length 
30

Type of Learning Activity 
Other learning activities

Study Path 
[EC12+7+ – Ord. 2016] economics and financial markets

Mutuazione 
Mutuato: EC01 – 018EC – COMPUTER SCIENCE

Syllabus 

Teaching language 

English

Learning objectives 

GENERAL CONCEPTS OF INFORMATION TECHNOLOGY
Technical features of personal computers, hardware and software,
Bits and bytes
Central memory and mass storage
Central unit
Devices of input / output
Operating system and application programs
File
File system – how it is structured, how the stored information can be found
Interpreting information about files, folders and storage units
TEXT EDITOR
How to create, save, edit a text page
Formatting characters and paragraphs
Modify the page setup, print a page
SPREADSHEET
How to create, save, edit a spreadsheet
Working on multiple sheets
Insert different types of data
Constants, formulas, functions
Relative, mixed, absolute cell references
Select a cell or a set of adjacent and not adjacent cells
How to copy, cut, paste, delete and move data
Data, cell, sheet formatting
The basic functions of a spreadsheet
– Mathematics (SUM, SUMIF, ROUND, INT, MOD, etc.)
– Statistics (AVERAGE, MAX, MIN, COUNT, COUNTA, COUNTIF, COUNTBLANK …)
– Logic (IF, AND, OR, NOT)
– Text (CONCATENATE, RIGHT, LEFT, MID, etc.)
– Date and time (DATE, YEAR, MONTH, DAY, NOW, etc.)
– Informative (ISERR, ISERROR, ISNA, etc.)
Database analysis in Excel
– The area of the criteria (VLOOKUP, VLOOKUP)
– The database functions (DGET, DMAX, DMIN, DCOUNTA, DSUM, etc.)
Prints
– Print a worksheet or an entire file
– Print a part of the sheet
DATABASE
Database, relationships between data, the concept of primary key / index.
Creating Tables: data types and fields properties
– Define the primary key
– Change the table properties
– Change the fields properties
Creating Query
– Search, select and sort data using the common logical operators
– Use of multiple criteria in the query and create calculated fields
Creating Forms
Creating Reports
– Create and customize headers and footers
– Create a grouped or summary report

Prerequisites 

None

Contents 

GENERAL CONCEPTS OF INFORMATION TECHNOLOGY
Technical features of personal computers, hardware and software,
Bits and bytes
Central memory and mass storage
Central unit
Devices of input / output
Operating system and application programs
File
File system – how it is structured, how the stored information can be found
Interpreting information about files, folders and storage units
TEXT EDITOR
How to create, save, edit a text page
Formatting characters and paragraphs
Modify the page setup, print a page
SPREADSHEET
How to create, save, edit a spreadsheet
Working on multiple sheets
Insert different types of data
Constants, formulas, functions
Relative, mixed, absolute cell references
Select a cell or a set of adjacent and not adjacent cells
How to copy, cut, paste, delete and move data
Data, cell, sheet formatting
The basic functions of a spreadsheet
– Mathematics (SUM, SUMIF, ROUND, INT, MOD, etc.)
– Statistics (AVERAGE, MAX, MIN, COUNT, COUNTA, COUNTIF, COUNTBLANK …)
– Logic (IF, AND, OR, NOT)
– Text (CONCATENATE, RIGHT, LEFT, MID, etc.)
– Date and time (DATE, YEAR, MONTH, DAY, NOW, etc.)
– Informative (ISERR, ISERROR, ISNA, etc.)
Database analysis in Excel
– The area of the criteria (VLOOKUP, VLOOKUP)
– The database functions (DGET, DMAX, DMIN, DCOUNTA, DSUM, etc.)
Prints
– Print a worksheet or an entire file
– Print a part of the sheet
DATABASE
Database, relationships between data, the concept of primary key / index.
Creating Tables: data types and fields properties
– Define the primary key
– Change the table properties
– Change the fields properties
Creating Query
– Search, select and sort data using the common logical operators
– Use of multiple criteria in the query and create calculated fields
Creating Forms
Creating Reports
– Create and customize headers and footers
– Create a grouped or summary report

Teaching format 

Lectures (6 hours), practical (24 hours)

Extended Programme 

GENERAL CONCEPTS OF INFORMATION TECHNOLOGY
Technical features of personal computers, hardware and software,
Bits and bytes
Central memory and mass storage
Central unit
Devices of input / output
Operating system and application programs
File
File system – how it is structured, how the stored information can be found
Interpreting information about files, folders and storage units
TEXT EDITOR
How to create, save, edit a text page
Formatting characters and paragraphs
Modify the page setup, print a page
SPREADSHEET
How to create, save, edit a spreadsheet
Working on multiple sheets
Insert different types of data
Constants, formulas, functions
Relative, mixed, absolute cell references
Select a cell or a set of adjacent and not adjacent cells
How to copy, cut, paste, delete and move data
Data, cell, sheet formatting
The basic functions of a spreadsheet
– Mathematics (SUM, SUMIF, ROUND, INT, MOD, etc.)
– Statistics (AVERAGE, MAX, MIN, COUNT, COUNTA, COUNTIF, COUNTBLANK …)
– Logic (IF, AND, OR, NOT)
– Text (CONCATENATE, RIGHT, LEFT, MID, etc.)
– Date and time (DATE, YEAR, MONTH, DAY, NOW, etc.)
– Informative (ISERR, ISERROR, ISNA, etc.)
Database analysis in Excel
– The area of the criteria (VLOOKUP, VLOOKUP)
– The database functions (DGET, DMAX, DMIN, DCOUNTA, DSUM, etc.)
Prints
– Print a worksheet or an entire file
– Print a part of the sheet
DATABASE
Database, relationships between data, the concept of primary key / index.
Creating Tables: data types and fields properties
– Define the primary key
– Change the table properties
– Change the fields properties
Creating Query
– Search, select and sort data using the common logical operators
– Use of multiple criteria in the query and create calculated fields
Creating Forms
Creating Reports
– Create and customize headers and footers
– Create a grouped or summary report

End-of-course test 

The exam is done on PC and lasts an hour. It is carrying out an exercise with the spreadsheet, one with the database. It also needs to answer a series of multiple choice questions.

Other information 

Students in possession of the ECDL Certifications, can contact the student office for information on the possible acquisition of CFU of the course.

Texts/Books 

– Lecture notes
– Slides and notes provided by the teacher
– Marco Ferrero “Access 2007” ed. Apogeo.

Back to list of courses

Chuyên mục: Kiến thức

Related Articles

Trả lời

Email của bạn sẽ không được hiển thị công khai. Các trường bắt buộc được đánh dấu *

Check Also
Close
Back to top button