Portale di Ateneo - En.Unibs.it

Borrowed courses

INFORMATION TECHNOLOGY ELIGIBILITY

ECONOMIA

PERCORSO GENERALE IN ECONOMIA

Other Courses of the Study Programme

Course year: 1

BUSINESS ADMINISTRATION - 9 credits - Basic
ECONOMIC HISTORY - 6 credits - Related/Supplementary
ELEMENTARY ENGLISH: BASIC NOTIONS - Student's own choice
ELEMENTARY MATHEMATICS: BASIC NOTIONS - Student's own choice
ENGLISH LANGUAGE - 9 credits - Related/Supplementary
FINANCIAL ACCOUNTING (INTRODUCTORY AND INTERMEDIATE LEVEL) - 9 credits - Characterising
INFORMATION TECHNOLOGY ELIGIBILITY - 2 credits
LINEAR ALGEBRA AND CALCULUS - 9 credits - Basic
MICROECONOMICS - 9 credits - Basic
PRIVATE LAW - 9 credits - Basic

Course year: 2

COMMERCIAL LAW
Attendance grouping
12 credits - Raggruppamento di frequenza
ECONOMIC POLICY - 9 credits - Characterising
FINANCIAL AND ACTUARIAL CALCULUS - 6 credits - Characterising
FINANCIAL MARKETS AND ISTITUTIONS - 9 credits - Characterising
MACROECONOMICS - 9 credits - Characterising
PUBLIC LAW - 6 credits - Related/Supplementary
STATISTICS - 9 credits - Characterising

Course year: 3

ADMINISTRATION AND MANAGEMENT CONTROL OF TOURISM ENTERPRISES - 6 credits - Student's own choice
BANKING - 9 credits - Characterising
BUSINESS MANAGEMENT - 9 credits - Student's own choice
BUSINESS ORGANISATION - 6 credits - Student's own choice
BUSINESS ORGANIZATION - 6 credits - Student's own choice
CO-OPERATIVE FIRMS BUSINESS MANAGEMENT - 6 credits - Student's own choice
COST ACCOUNTING - 9 credits - Student's own choice
DECISION ANALYSIS FOR BUSINESS - 6 credits - Student's own choice
ECONOMIC SOCIOLOGY - 9 credits - Student's own choice
EMPIRICAL ECONOMICS - 9 credits - Student's own choice
ENVIRONMENTAL ECONOMICS - 6 credits - Student's own choice
FINAL TEST - 4 credits - Language/Final Examination
FINANCIAL MANAGEMENT MODELS - 9 credits - Student's own choice
FOUNDATIONS OF PUBLIC ECONOMICS - 6 credits - Student's own choice
FRENCH LANGUAGE - 6 credits - Student's own choice
GEOGRAPHY AND SOCIOLOGY OF TOURISM
Attendance grouping
9 credits - Raggruppamento di frequenza
GERMAN LANGUAGE - 6 credits - Student's own choice
HERITAGE AND TOURISM POLICY - 9 credits - Student's own choice
HISTORY OF ECONOMIC THOUGHT - 9 credits - Student's own choice
INNOVATION AND OPERATIONS MANAGEMENT - 6 credits - Student's own choice
INTERNSHIP - 3 credits - For stages and internships
INTRODUCTION TO FINANCIAL MANAGEMENT - 6 credits - Characterising
INVESTMENTS - 9 credits - Characterising
LABOUR ECONOMICS - 9 credits - Student's own choice
LABOUR LAW - 9 credits - Student's own choice
MANAGEMENT CONTROL - 9 credits - Student's own choice
MARKETING - 9 credits - Student's own choice
OPERATIONS MANAGEMENT - 6 credits - Student's own choice
OPERATIONS RESEARCH - 9 credits - Student's own choice
PORTFOLIO CHOICES - 6 credits - Characterising
PROBLEM SOLVING FOR COMPUTER SCIENCE - 6 credits - Student's own choice
PROFESSIONAL PRACTICE ISSUES IN ACCOUNTING - 6 credits - Student's own choice
PUBLIC ECONOMICS - 9 credits - Student's own choice
PUBLIC ECONOMICS - 9 credits - Student's own choice
SOCIOLOGY OF ORGANIZATION - 6 credits - Student's own choice
SPANISH LANGUAGE - 6 credits - Student's own choice
STATISTICAL INFERENCE - 9 credits - Characterising
STRATEGY ANALYSIS - 9 credits - Student's own choice
TOURISM MANAGEMENT - 6 credits - Student's own choice

INFORMATION TECHNOLOGY ELIGIBILITY

Single discipline educational activity

Course Sheet

Academic Year of enrolment:

2017/2018

Academic Year of provision:

2017/2018

Degree:

Bachelor's Degree Programme in BANKING AND FINANCE

Disciplinary Sector:

Operational Research

Language:

Italian

Grouping type:

Credits:

Programme Year:

Professor and Collaborators:

FONTANA DARIO Collaborator

VINDIGNI Michele Professor

Cycle:

First four months

Hours of classroom activity:

Hours of individual study:

None

Educational Goals

Develop knowledge aimed at managing information systems commonly applied in business contexts. In particular, acquire and consolidate basic knowledge in data processing using spreadsheets and in using the web intelligently and safely.

Content

Spreadsheets: arithmetic and logic functions, sorting and filtering lists, automatic calculation of subtotals, the VLOOKUP function, the goal seek tool, charts, and pivot tables.

Syllabus:

1. Relative and absolute references, select a cell, range of cells adjacent or non-adjacent

2. Entering numbers, dates, or text in a cell, use the autofill tool to copy or build data sets or formulas

3. Using some logical-mathematical functions: IF, SUM, COUNTIF, SUMIF, VLOOKUP, subtotals; functions MID and CONCATENATE

4. Using lists: sorting on one or more fields, automatic and standard filters, subtotals

5. Using goal seek feature

6. Charts: types and their use, common mistakes

7. Pivot tables: building a pivot table from a list, filters and charts

Extended Syllabus

1. Relative and absolute references, select a cell, range of cells adjacent or non-adjacent

2. Entering numbers, dates, or text in a cell, use the autofill tool to copy or build data sets or formulas

3. Using some logical-mathematical functions: IF, SUM, COUNTIF, SUMIF, VLOOKUP, subtotals; functions MID and CONCATENATE

4. Using lists: sorting on one or more fields, automatic and standard filters, subtotals

5. Using goal seek feature

6. Charts: types and their use, common mistakes

7. Pivot tables: building a pivot table from a list, filters and charts

Recommended Bibliography

Slides, files and video uploaded in the course site. For consultation:
- Francesco Iannello, Excel for Business, CreateSpace Independent Publishing Platform, 2016, ISBN 1532723628.

Methods of Provision

Conventional

Teaching Methods

Classroom lectures and exercises in the computer lab. The classes will be practical, with analysis of concrete examples. For greater effectiveness, we invite every student in the classroom to bring his/her own laptop, to perform live examples and exercises. To this end, the student must make sure that on his/her device a spreadsheet (Calc Libre Office Excel or Microsoft Office) is installed and the working files made available prior to the lessons have been downloaded.

Assessment Methods

The “idoneità” is achieved through an automated test to be carried out in computer lab. The test, lasting 30 minutes, consists of 18 questions, split into 14 questions in closed form, designed to measure the candidate's knowledge of the concepts listed in the program, and 4 questions in an open form, designed to measure competence in spreadsheets, i.e., the ability to actual use of some features relevant. Based on the result of the test, the candidate may be declared “idoneo” or “non idoneo”.

Assessment:

Final judgement

Programme of Educational Activities

Start date of teaching period:

Monday, September 11, 2017

End date of teaching period:

Friday, December 15, 2017

Other Information

The examination methods are the same for attending students and not
attending students.

Students enrolled in each trial are sorted alphabetically and divided into groups of 50 to 80 candidates each; the groups are then invited sequentially, at a distance of one hour each, starting from the time appointed for the beginning of the test.