Portale di Ateneo - En.Unibs.it

Borrowed courses

INFORMATION TECHNOLOGY ELIGIBILITY

ECONOMIA E GESTIONE AZIENDALE

AMMINISTRAZIONE E CONTROLLO
INFORMATION TECHNOLOGY ELIGIBILITY

ECONOMIA E GESTIONE AZIENDALE

BUSINESS
INFORMATION TECHNOLOGY ELIGIBILITY

ECONOMIA E GESTIONE AZIENDALE

GESTIONE DEL TURISMO

Other Courses in the Curriculum

GESTIONE DELLE IMPRESE

Course year: 1

ELEMENTARY ENGLISH: BASIC NOTIONS

Student's own choice
ELEMENTARY MATHEMATICS: BASIC NOTIONS

Student's own choice
BUSINESS ADMINISTRATION

9 credits - Basic
ECONOMIC HISTORY

6 credits - Related/Supplementary
ENGLISH LANGUAGE

9 credits - Related/Supplementary
LINEAR ALGEBRA AND CALCULUS

9 credits - Basic
FINANCIAL ACCOUNTING (INTRODUCTORY AND INTERMEDIATE LEVEL)

9 credits - Characterising
INFORMATION TECHNOLOGY ELIGIBILITY

2 credits
MICROECONOMICS

9 credits - Basic
PRIVATE LAW

9 credits - Basic

Course year: 2

FINANCIAL AND ACTUARIAL CALCULUS

6 credits - Characterising
MACROECONOMICS

9 credits - Characterising
STATISTICS

9 credits - Characterising
BUSINESS MANAGEMENT

9 credits - Characterising
COMMERCIAL LAW

12 credits - Characterising
COST ACCOUNTING

9 credits - Characterising
PUBLIC LAW

6 credits - Basic

Course year: 3

FINAL TEST

4 credits - Language/Final Examination
INTERNSHIP

3 credits - For stages and internships
MARKETING

9 credits - Characterising
OPERATIONS RESEARCH

9 credits - Related/Supplementary
BUSINESS ORGANIZATION

6 credits - Characterising
FINANCIAL MARKETS AND ISTITUTIONS

9 credits - Characterising
INNOVATION AND OPERATIONS MANAGEMENT

6 credits - Characterising
COMPUTATIONAL METHODS

6 credits - Student's own choice
DATA ANALYSIS AND BIG DATA LAB

9 credits - Student's own choice
EMPIRICAL ECONOMICS

9 credits - Student's own choice
FINANCIAL ECONOMICS

6 credits - Student's own choice
PUBLIC AND INNOVATION ECONOMICS

9 credits - Student's own choice
ADMINISTRATION AND MANAGEMENT CONTROL OF TOURISM ENTERPRISES

6 credits - Student's own choice
FINANCIAL MANAGEMENT MODELS

9 credits - Student's own choice
FOUNDATIONS OF PUBLIC ECONOMICS

6 credits - Student's own choice
INTRODUCTION TO FINANCIAL MANAGEMENT

6 credits - Student's own choice
INTRODUCTION TO STATISTICAL INFERENCE

6 credits - Student's own choice
INVESTMENTS

9 credits - Student's own choice
LABOUR LAW

9 credits - Student's own choice
LINEAR ALGEBRA AND CALCULUS II

6 credits - Student's own choice
MANAGEMENT CONTROL

9 credits - Student's own choice
OPERATIONS MANAGEMENT

6 credits - Student's own choice
PROBLEM SOLVING FOR COMPUTER SCIENCE

6 credits - Student's own choice
PUBLIC ECONOMICS

9 credits - Student's own choice
STATISTICAL INFERENCE

9 credits - Student's own choice
BANKING

9 credits - Student's own choice
DECISION ANALYSIS FOR BUSINESS

6 credits - Student's own choice
ECONOMIC POLICY

9 credits - Student's own choice
ENVIRONMENTAL 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
PORTFOLIO CHOICES

6 credits - Student's own choice
PROFESSIONAL PRACTICE ISSUES IN ACCOUNTING

6 credits - Student's own choice
SPANISH LANGUAGE

6 credits - Student's own choice
STATISTICS FOR ECONOMICS AND DIGITAL FIRM

9 credits - Student's own choice
STRATEGY ANALYSIS

9 credits - Student's own choice
TOURISM MANAGEMENT

6 credits - Student's own choice

INFORMATION TECHNOLOGY ELIGIBILITY

Alphabetic division AD-EN-OZ

Course Sheet

Academic Year of enrolment:

2019/2020

Academic Year of provision:

2019/2020

Divisions:

A-D

Degree:

Bachelor's Degree Programme in BUSINESS ADMINISTRATION

Location:

BRESCIA

Disciplinary Sector:

Operational Research

Is part of:

INFORMATION TECHNOLOGY ELIGIBILITY

Grouping type:

Credits:

Programme Year:

Professor and Collaborators:

GUASTAROBA Gianfranco Professor

FIORANI CLAUDIO Collaborator

Cycle:

Second four months

Hours of classroom activity:

Hours of individual study:

No specific skills and/or prior knowledge other than those required for enrolling in the Bachelor course

Educational Goals

The main goal of this course is to develop a knowledge aimed at managing information systems commonly applied in a business context.
D1 - KNOWLEDGE AND UNDERSTANDING
This course aims at providing the student with the basics knowledge and understanding on the use of software for individual productivity and office automation, with a particular focus on the most common applications of a spreadsheet in business contexts.
D2 - APPLYING KNOWLEDGE AND UNDERSTANDING
At the end of this course, the student must show the capability of applying the acquired knowledge in order to understand, evaluate and manage problems arising in various application areas of a company. The student must also show the capability of solving simple computing problems and problems related to information management.
D3 - MAKING JUDGEMENTS
At the end of this course, the student will be able to judge autonomously which tools and functions of the software analyzed are the most suitable to tackle a given problem.
D4 - COMMUNICATION SKILLS
At the end of this course, the student must show the capability of explaining, using the proper terminology, why a certain feature of the software analyzed should be chosen, and how it should be used to solve a given problem.
D5 - LEARNING SKILLS
At the end of this course, the student will be able to keep him/herself up-to-date and autonomously examine in-depth specific topics and applications arising in the context of basic information technology.

Content

The content of the course is divided into two parts.
The main part of the course is devoted to the practical use of a spreadsheet. This part provides a detailed description of the most common mathematical, logical, and search functions; the most common functions available for managing text and dates; the management of lists of data (sorting and filtering lists of data, the automatic computation of subtotals); the goal seek tool; creating and managing charts; and creating and managing pivot tables.
The second part is dedicated to the introduction of the foremost ICT tools and technologies employed in the business, in order to understand their potential and their limits, and be up-to-date on the recent trends arising in the ICT world.

Extended Syllabus

The detailed syllabus related to the first part of course is the following:
1. Relative and absolute references; selection of a cell, a range of cells adjacent or non-adjacent;
2. Entering numbers, dates, or text into a cell; use the autofill tool to copy or build data sets or formulas;
3. Using some logical-mathematical functions: basic concepts, common errors, and some common functions, including POWER, SUM, MIN, MAX, AVERAGE, IF, COUNTIF, SUMIF, VLOOKUP; functions MID, CONCATENATE, UPPER, and LOWER;
4. Using the goal seek tool;
5. Working with lists of data: sorting based on one or more fields, automatic and standard filters, subtotals;
6. Charts: types and their use, customization, and common errors;
7. Pivot tables: building a pivot table from a list, filters and charts.

The detailed syllabus related to the second part of course is the following:
1. Internet, WWW and safe online navigation;
2. what is a search engine, and its basic functioning;
3. Cloud Storage e Cloud collaboration;
4. the digital document: SPID, electronic invoice, digital signature, certified e-mail, digital preservation;
5. Copyright e software licenses.

Recommended Bibliography

For a detailed study, refer to the following textbook:
- Francesco Iannello; Excel for Business; CreateSpace Independent Publishing Platform; 2016; ISBN: 9781532723629.
Additional material: Slides, files and self-learning teaching material available at elearning.unibs.it.

Teaching Methods

The course will be provided through traditional classroom lectures and practical classes taking place in the computer labs. The lectures will be practical, with analysis of business-like examples. For the best effectiveness, we invite each student to bring his/her own laptop to the classroom, in order to run live examples and exercises under the supervision of the teacher. To this end, the student must make sure that a spreadsheet (Calc by Libre Office or Excel by Microsoft Office) is installed on his/her device, and that the working files made available on the course website have been downloaded.

Assessment Methods

The exam consists of an automated test provided as a quiz, to be carried out by using one of the computers available in the computer lab. The time available for the exam is 30 minutes. The test comprises 18 questions:
- 14 questions are in closed form, designed to measure the candidate's knowledge of the concepts listed in the program (12 are on the spreadsheet and 2 are on the second part of the course);
- and 4 questions are in an open form, designed to measure competence in spreadsheets, i.e., the practical ability to use some of the most relevant features.
The above questions have a different weight on the final mark, according to their difficulty. Based on the result of the test, the candidate may be declared “idoneo” (i.e., eligible) or “non idoneo” (i.e., not eligible).

Assessment:

Final judgement

Programme of Educational Activities

Start date of teaching period:

Monday, February 10, 2020

End date of teaching period:

Friday, May 22, 2020

Other Information

The course will be provided through classroom lectures and practical classes held in the computer lab.
In terms of the program and the examination procedure, there are not differences between attending and not attending students.
The exam is provided in Italian. Each student that desires to take the exam in English has to communicate his/her intention to the teacher at the moment of enrolling to the exam via Esse3.
Students enrolled in each trial are sorted alphabetically and divided into groups comprising 70 to 90 candidates each. These groups are then summoned sequentially, one every hour, starting from the time appointed for the beginning of the test. The division into groups is published one/two days before the exam on the related e-learning website, and then communicated via email to the students.