CODE 60031 ACADEMIC YEAR 2020/2021 CREDITS 5 cfu anno 2 ECONOMIA DELLE AZIENDE MARITTIME, LOGISTICA E TRASP. 8698 (L-18) - GENOVA 5 cfu anno 1 ECONOMIA AZIENDALE 8697 (L-18) - GENOVA 5 cfu anno 2 ECONOMIA AZIENDALE 8697 (L-18) - GENOVA 5 cfu anno 1 ECONOMIA DELLE AZIENDE MARITTIME, LOGISTICA E TRASP. 8698 (L-18) - GENOVA 5 cfu anno 1 ECONOMIA E COMMERCIO 8699 (L-33) - GENOVA 5 cfu anno 2 ECONOMIA E COMMERCIO 8699 (L-33) - GENOVA SCIENTIFIC DISCIPLINARY SECTOR INF/01 LANGUAGE Italian TEACHING LOCATION GENOVA SEMESTER Annual PREREQUISITES Propedeuticità in uscita Questo insegnamento è propedeutico per gli insegnamenti: Business Administration 8697 (coorte 2020/2021) DATA MANAGEMENT AND COMMUNICATION TECHNOLOGIES 105154 Maritime, Logistics and Transport Economics and Business 8698 (coorte 2020/2021) DATA MANAGEMENT AND COMMUNICATION TECHNOLOGIES 105154 TEACHING MATERIALS AULAWEB OVERVIEW This course aims to provide the basics of word processing and spreadsheets, distinguishing concepts from the demonstration of how they can be put into practice using a particular software system. For this purpose, the concepts are presented disregarding, as far as possible, how they are implemented by specific applications and examples of use are used in different applications to allow comparison and facilitate abstraction. AIMS AND CONTENT LEARNING OUTCOMES Applications of spreadsheet with reference to economic and financial problems. Writing texts with editing software. Presentations with dedicated software AIMS AND LEARNING OUTCOMES The main objective of the course is to provide students with the knowledge and professional skills related to the use of IT tools for economic, business, financial and quantitative applications. PREREQUISITES Familiarity with computer use coud help, but it is not required. TEACHING METHODS The course will be delivered using online lessons and online exercises, self-assessment quizzes to help students focus the study. Those material and activities will be available at any time from the beginning of the semester and the students will be able to participate at any time. Moreover, there will be synchronous labs, in which the teacher will interact with the students to facilitate the overcoming of the main practical difficulties in applying independently of the techniques learned. The course will be held remotely through the Teams (code c1oyrk4) and Aulaweb (https://2020.aulaweb.unige.it/course/view.php?id=3801) platforms. SYLLABUS/CONTENT The course is divided into four macro-topics: a first part with general content, a second dedicated to word processing systems, a third dedicated to spreadsheets, and a fourth dedicated to presentation programs. Each macro argument is in turn subdivided into arguments. General part: applications and operating system, differences and interactions Word processing: types of applications for word processing, basic concepts of word processing, character formatting and paragraphs; Tabs and alignment; lists and numbered lists; Formatting documents, margins, headers, and footers; tables; styles; templates; Inserting special content: images, figures, symbols and formulas Spreadsheets: Introduction to Spreadsheets; Inserting and formatting values (numbers, currencies, percentages, and dates); Operations and functions on values, relative and absolute references in Microsoft Excel and their use in formulas; Association of names to values or ranges; Automatic generation, import and export of data; Generation and manipulation of graphics; Sorting, focusing and filters. Pivot Presentation programs: presentation principles and techiniques; introduction to presentation programs; presentation structure; slide structure; animations RECOMMENDED READING/BIBLIOGRAPHY No textbook is required: the needed material will be freely available online. TEACHERS AND EXAM BOARD MAURA CERIOLI Ricevimento: On request by email Exam Board MAURA CERIOLI (President) GIOVANNI LONGHI ROBERTO ZUNINO MAURA CERIOLI (President) GIOVANNI LONGHI ROBERTO ZUNINO LESSONS Class schedule COMPUTER SCIENCE KNOWLEDGE AND SKILLS EXAMS EXAM DESCRIPTION A test consisting of multiple-choice questions delivered on a digital platform. The questions concern the basic concepts and, to a greater extent, the use of applications. To be able to answer, it is essential to have acquired a reasonable practical mastery of the same. ASSESSMENT METHODS The test questions are of two different types: • generic, or related to available functionalities and good practices of use of the applications • operational, or that require the use of applications during the examination to create or modify documents and thus be able to answer specific questions on the final status of the document The answers to the generic questions require less time and aim at verifying that the student has acquired sufficient knowledge of computer tools. Those for operational questions need more time, because they must carry out exercises to find the answers, and are intended to ascertain that the candidate knows how to use the applications in practice and did not limit their preparation to studying functionalities at a general level. Exam schedule Data appello Orario Luogo Degree type Note 15/01/2021 14:00 GENOVA Laboratorio 05/02/2021 14:00 GENOVA Laboratorio 05/05/2021 15:00 GENOVA Pratica 31/05/2021 14:00 GENOVA Pratica 15/06/2021 14:00 GENOVA Pratica 15/07/2021 14:00 GENOVA Pratica 07/09/2021 14:00 GENOVA Pratica FURTHER INFORMATION Communications concerning the course and examinations will mainly take place using AulaWeb or mail.