COMPUTER SCIENCE LABORATORY M - Z

Academic Year 2021/2022 - 1° Year
Teaching Staff: Luca Leonardi
Credit Value: 3
Course Language: Italian
Taught classes: 7 hours
Exercise: 28 hours
Term / Semester:

Learning Objectives

The aim of the course is to provide a set of skills needed to the use of a computer, network resources and some applications to write and edit texts, create spreadsheets, create a presentation, and create technical drawings.
At the end of the course the student will be able to:
• Use the main functions offered by a computer and identify its components.
• Create, format, save and print a document.
• Create and manage workbooks and spreadsheets.
• Create and manage a presentation.
• Use AutoCAD.


Course Structure

Frontal lectures: 7 hours
Lab exercises: 28 hours
Should teaching be carried out in mixed mode or remotely, it may be necessary to introduce changes with respect to previous statements, in line with the programme planned and outlined in the syllabus.
As a guarantee of equal opportunities and in compliance with current laws, interested students can ask for a personal interview in order to plan any compensatory and/or dispensatory measures, based on their specific needs and on teaching objectives of the discipline. It is also possible to ask the departmental contacts of CInAP (Center for Active and Participatory Integration - Services for Disabilities and/or DSAs), in the persons of professors Giovanna Tropea Garzia and Anna De Angelis.


Detailed Course Content

Fundamentals of Computer Science: information representation, numbering systems, computer architecture, hints on operating systems.
AutoCAD: toolbars, menu bar, command line, status bar. Layers, choice of colors, line types. Open and save a drawing. Lines and polylines. Polygon, circle, and arc. Object snap, ortho. Commands offset, cut, copy, move, rotate, cima and fillet. Display (zoom, pan, redraw and regenerate). Print. Graphic formats.
Word: opening and closing the program, file management (new, open, close, save, save as), find and replace, types of page view, print preview, customize the toolbar, undo, copy, paste and paste special, cut, insert (image, formula, tables, footnotes, page numbers, symbol), text selection, text formatting (bold, italic, underlined, capital letters, font, font size, superscript and subscript, line spacing, alignment and justification, hyphenation, copy format, tabs, bullets). Models. Styles. Headers and footers. Check spelling and grammar. Document settings. Print. Tables. Import objects. Graphic formats.
Excel: opening and closing the program, file management (new, open, close, save, save as), menu view, page break preview, customize the toolbar, data entry, data types, selection (cells, rows, columns , non-contiguous areas), change size, align text in a cell, copy, move, delete, find and replace, sort data, references (absolute, relative and mixed), autofill, lock non-input cells, formulas, functions, charts, document layout, print setting.
PowerPoint: create a new presentation from a template, modify the presentation theme, add slides to the presentation, add and edit text, images, clipart and shapes to slides. Add and modify tables and charts, insert and edit animations and slide transitions. Save the presentation.


Textbook Information

1. Mario R. Storchi. Nuova ECDL – Modulo 1: Concetti di base del computer. Edizioni Manna, 2013. ISBN 9788887752366.
2. Luigi Santapaga, Matteo Trasi. Autocad 2015 pocket. Apogeo, Giugno 2014. ISBN edizione cartacea: 9788850333158.
3. Word 2019. Creare documenti di testo puliti ed eleganti. Collana POCKET di Edimatica. APOGEO, ottobre 2018. ISBN edizione cartacea: 9788850334551.
4. Excel 2019. Conoscere e utilizzare i fogli di calcolo. POCKET Edimatica. APOGEO, ottobre 2018. ISBN edizione cartacea: 9788850334537.
5. PowerPoint 2019. Creare presentazioni chiare ed efficaci. POCKET Edimatica. APOGEO, ottobre 2018. ISBN edizione cartacea: 9788850334568.