CODE 61504 ACADEMIC YEAR 2017/2018 CREDITS 3 cfu anno 3 SCIENZE INTERNAZIONALI E DIPLOMATICHE 8768 (L-36) - 3 cfu anno 3 SCIENZE POLITICHE E DELL'AMMINISTRAZIONE 8776 (L-16) - 3 cfu anno 3 SCIENZE POLITICHE E DELL'AMMINISTRAZIONE 8776 (L-36) - SCIENTIFIC DISCIPLINARY SECTOR INF/01 LANGUAGE Italian TEACHING LOCATION SEMESTER 1° Semester SECTIONING Questo insegnamento è diviso nelle seguenti frazioni: A B 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 This is a hands-on course on the main office computer programs: word processing and spreadsheet applications. AIMS AND LEARNING OUTCOMES Learn to use word processing and spreadsheet systems, regardless of the specifics of the single application. Learn basic reference concepts for such applications Get acquainted with the use of office automation applications TEACHING METHODS The course will be delivered in blended mode, using online lessons and online exercises, self-assessment quizzes to help students focus the study and labs in attendance to facilitate the overcoming of the main practical difficulties in applying independently of the techniques learned SYLLABUS/CONTENT The course is divided into three macro-topics: a first part with general content, a second dedicated to word processing systems, and a third dedicated to spreadsheets. 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. 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) GIANNA REGGIO MARINA RIBAUDO LESSONS LESSONS START The first lesson will be held on the ...... Class schedule I.T. - BASIC COURSE A EXAMS EXAM DESCRIPTION Quiz consisting of multiple-choice questions Pretty printing of a text using a word processor, and elaboration of a spreadsheet following the given directions ASSESSMENT METHODS • Delivering the documents on EduOpen (when the support course is open) or directly on AulaWeb before the exam. • Quiz in attendance and discussion of the presented documents Exam schedule Data appello Orario Luogo Degree type Note 08/01/2018 09:30 GENOVA Orale 29/01/2018 09:30 GENOVA Orale 01/06/2018 09:30 GENOVA Orale 18/06/2018 09:30 GENOVA Orale 16/07/2018 09:30 GENOVA Orale 13/09/2018 09:30 GENOVA Orale FURTHER INFORMATION Communications concerning the course and examinations will mainly take place using AulaWeb or mail.