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
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
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
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