COMPUTER SCIENCE LABORATORY A - L
Academic Year 2023/2024 - Teacher: PAOLA MARIA LEANZAExpected Learning Outcomes
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:
- Knowledge and understanding: 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.
- Applying knowledge and understanding: to be able to manage the aforementioned knowledge in order to format texts, draw up tables and technical drawings, be able to effectively manage requests and choose best practices and customized solutions.
- Making judgements: know how to use procedural communications and technical instructions, know how to use IT tools to identify potentially useful solutions for a given application context, in real problems, to study and work, be aware of the potential and limits of using information technology.
- Communication skills: know how to communicate correctly and effectively using IT tools.
- Learning skills: know how to learn in groups or alone and be able to connect the topics covered in this discipline and in other disciplines.
Course Structure
INTERACTIVE LESSONS IN LABORATORY, in detail with:
- 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.
Required Prerequisites
The course has no specific prerequisites
Attendance of Lessons
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 FILE, 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 FILE, 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 edizione cartacea: 9788850333158.
2. Word 2021. Produrre documenti di testo puliti, eleganti e professionali. Collana POCKET di Edimatica. APOGEO, ottobre 2021. ISBN: 9788850335787. ISBN Ebook: 9788850319251.
3. Excel 2021. Conoscere e sfruttare la potenza dei fogli di calcolo. POCKET Edimatica. APOGEO, ottobre 2021. ISBN: 9788850335770. ISBN Ebook: 9788850319299.
4. PowerPoint 2021. Realizzare presentazioni chiare ed accattivanti. POCKET Edimatica. APOGEO, ottobre 2018. ISBN:9788850335800. ISBN Ebook: 97888503193
Course Planning
Subjects | Text References | |
---|---|---|
1 | AUTOCAD. Creation of Autocad interface, insertion of command tools, using of coordinate system, opening and saving of files. Using commands for drawing accuracy. | Testo 1: cap. 1-5 Exercises provided by the teacher. |
2 | AUTOCAD. The drawing and editing toolbar. | Testo 1: cap. 5,6,9,12 Exercises provided by the teacher. |
3 | AUTOCAD. Object and linetype properties manager. Insertion of objects from other dwg and images. Draw order, text style, and use of multiline text. Practical exercise: drafting a floor plan in CAD. | Testo 1: cap.8 |
4 | AUTOCAD. Practical exercise: drafting an elavation in CAD. | Exercises provided by the teacher. |
5 | AUTOCAD. Formatting of texts, insertion of dimensions and printing of graphic drawings. Practical exercise: drafting an elavation in CAD. | Testo 1: cap. 10,11,13. Exercises provided by the teacher. |
6 | AUTOCAD. Practical exercise: drafting a section in CAD. | Exercises provided by the teacher. |
7 | Word. Opening and saving files, setting up the document. Formatting styles. Inserting images, captions and cross-references and automatic summary. | Testo 2: cap. 1-8, 10-13 |
8 | WORD. Practical exercise: formatting a text in Word. | Exercises provided by the teacher. |
9 | Excel. Opening and saving files, using file manager, view menu, inserting data and formulas, and chart wizard, chart types (histogram, bar, line, pie, dispersion X Y). | Testo 3: cap. 1-8 |
10 | Excel: creation of a table and its graph in Excel. | Exercises provided by the teacher. |
11 | PowerPoint. Using the interface, creating a new presentation, inserting text, images, sound and video files, using tools for organizing and editing content, and creating templates, adding animations and transitions, printing and sharing. Practical exercise: creation of a presentation from a template. | Testo 4: cap. 1-9 |
Learning Assessment
Learning Assessment Procedures
Final practical exam in the computer, lasting 2 hours, on:
- Word: formatting a text in Word;
- Excel: creation of a table and its graph in Excel;
- CAD: drafting of a drawing (plan, elevation or section) on CAD.
During the course there are checks, two practical tests in progress, to ascertain the level of learning.
Verification of learning can also be carried out by online way if it will be necessary.
Evaluation criteria of the practical exam on the computer:
Each WORD, EXCEL AND CAD tests will be developed through a series of questions, if correct, will give a positive score to the candidate. No negative score will be awarded for incorrect and non-given questions.
The exam will be passed by the candidate if all three documents have an evaluation greater than or equal to 18/30.
Examples of frequently asked questions and / or exercises
Word formatting of the assigned text with setting of pages and columns, use of formatting styles, insertion of images and captions, creation of cross-references and automatic summary.
Drafting of a technical drawing (prospectus, plan or section) in Autocad, with the assigned measurements and use of layers, blocks and hatches, text and dimensions style.
Carrying out simple calculations with Excel by creating tables,