I.T. - BASIC COURSE

I.T. - BASIC COURSE

_
iten
Code
61504
ACADEMIC YEAR
2019/2020
CREDITS
3 credits during the 3nd year of 8768 International and Diplomatic Sciences (L-36) GENOVA

3 credits during the 3nd year of 8776 POLITICAL SCIENCE AND ADMINISTRATION (L-36) GENOVA

3 credits during the 3nd year of 8776 POLITICAL SCIENCE AND ADMINISTRATION (L-16) GENOVA

SCIENTIFIC DISCIPLINARY SECTOR
INF/01
LANGUAGE
Italian
TEACHING LOCATION
GENOVA (International and Diplomatic Sciences)
semester
1° Semester
Teaching materials

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

PREREQUISITES

Familiarity with computer use coud help, but it is not required.

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

Ricevimento: On request by email

Exam Board

MAURA CERIOLI (President)

MARINA RIBAUDO

GIANNA REGGIO

LESSONS

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

LESSONS START

The first lesson will be held on Monday September 16th

ORARI

L'orario di tutti gli insegnamenti è consultabile su EasyAcademy.

Vedi anche:

I.T. - BASIC COURSE

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

Date Time Location Type Notes
19/06/2020 14:30 GENOVA Orale
13/07/2020 09:00 GENOVA Orale
11/09/2020 09:00 GENOVA Orale

FURTHER INFORMATION

Communications concerning the course and examinations will mainly take place using AulaWeb or mail.