COMPUTER SCIENCE LABORATORY A - L

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

Learning Objectives

THE COURSE AIMS AT ENABLING STUDENTS TO ACQUIRE THE SKILLS NEEDED TO WRITE AND EDIT A TEXT, CREATE SPREADSHEETS AND THE COURSE ENABLES STUDENTS TO LEARN THE BASIC FUNCTIONS OF A COMPUTER-AIDED DESIGN SOFTWARE FOR THE CREATION OF TECHNICAL DRAWINGS.

In particular, the student will be able to

  • Create, format, save and print a document.
  • Create and manage workbooks and worksheets, manage cells and ranges, tables, apply formulas and functions, create charts and objects.
  • Understand the basic concept of 2D computer aided design;
  • Create, manipulate and modify objects or elements;
  • Insert objects from other application know how to print them;
  • Create and manage Presentations, insert and format shapes and slides, create slide content, apply transitions and animations.

Course Structure

INTERACTIVE LESSONS IN LABORATORY,

  • Frontal partecipated lessons (or in remote mode): 7 hours;
  • Individual or cooperative learning exercises (or exercises carried out by the teacher in remote mode): 28 hours.

If teaching is given in a mixed formula or remotely, necessary changes may be introduced to what was previously stated in order to comply with the provided and reported syllabus.

Learning assessment may be done remotely if necessary.

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

AUTOCAD: THE TOOLBARS, THE MENU BAR, COMMAND LINE, THE STATUS BAR. LAYERS, THE CHOICE OF COLORS, LINE TYPES. OPEN AND SAVE A DRAWING. LINE AND POLYLINE. POLYGON, CIRCLE, AND ARC. THE OBJECT SNAP, ORTHO. THE COMMANDS OFFSET, CUT, COPY, MOVE, ROTATE, CIMA AND FILLET. DISPLAY (ZOOM, PAN, REDRAW, AND REGENERATE). PRINTING. GRAPHIC FORMATS.

WORD: OPENING AND CLOSING THE PROGRAM, FILE MANAGEMENT (NEW, OPEN, CLOSE, SAVE, SAVE AS), FIND AND REPLACE, TYPE OF PAGE VIEW, PRINT PREVIEW, CUSTOMIZE THE TOOLBAR, UNDO, COPY, PASTE, AND PASTE SPECIAL, CUT, INSERT (IMAGE, FORMULA, TABLES, FOOTNOTES, PAGE NUMBERS, SYMBOL), SELECT TEXT AND MOVE BLOCKS TO MOVE AND COPY, 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. SETTING THE DOCUMENT. PRINT. TABLES. DESIGN TOOLS. IMPORTING OBJECTS. GRAPHIC FORMATS.

EXCEL: OPENING AND CLOSING THE PROGRAM, FILE MANAGEMENT (NEW, OPEN, CLOSE, SAVE, SAVE AS), THE MENU VIEW, PAGE BREAK PREVIEW, CUSTOM TOOLBAR, DATA ENTRY, DATA TYPES, INSERTING FORMULAS, 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), THE SUM FUNCTION, THE FUNCTION MEDIA, DOCUMENT LAYOUT, AND PRINT SETTING. WIZARD OF THE GRAPH, CHART TYPES (BAR, LINE, PIE, SCATTER), COMPLEX GRAPHICS.

POWERPOINT: CREATE A NEW PRESENTATION FROM A TEMPLATE. MODIFY PRESENTATION THEMES, ADD NEW SLIDES TO A PRESENTATION, ADD AND EDIT TEXT, IMAGES, CLIPART, AND SHAPES TO SLIDES. ADD SOUND AND VIDEO TO A SLIDE PRESENTATION. INSERT AND MODIFY TABLES AND CHARTS. INSERT AND EDIT ANIMATIONS AND SLIDE TRANSITIONS. SAVE TO GET TO YOUR PRESENTATIONS FROM YOUR COMPUTER.


Textbook Information

1. Luigi Santapaga, Matteo Trasi. Autocad 2015 pocket. Apogeo, Giugno 2014. ISBN: 9788850333158.

2. Word 2019. Creare documenti di testo puliti ed eleganti. Collana POCKET di Edimatica. APOGEO, ottobre 2018. ISBN: 9788850334551.

3. Excel 2019. Conoscere e utilizzare i fogli di calcolo. POCKET Edimatica. APOGEO, ottobre 2018. ISBN: 9788850334537.

4.PowerPoint 2019. Creare presentazioni chiare ed efficaci. POCKET Edimatica. APOGEO, ottobre 2018. ISBN: 9788850334568.