COMPUTER SCIENCE LABORATORY A - L
Academic Year 2024/2025 - Teacher: Gaetano STELLAExpected Learning Outcomes
Expected Learning Outcomes
THE COURSE ALLOWS STUDENTS TO ACQUIRE THE SKILLS NECESSARY FOR WRITING AND PROCESSING TEXTS, CREATING SPREADSHEETS AND ALLOWS STUDENTS TO LEARN THE MAIN FUNCTIONS OF A 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, present tables, apply formulas and functions, create graphs and objects; understand the basic concept of 2D computer auxiliary drawing; create, manipulate and modify objects or elements; insert objects from another application and print an elaborate; create and manage a presentation, insert and define the format of the slides and objects, create the content of the slides, apply the transition to the slides and the animation to the contents.
· Applied knowledge and understanding: manage the above knowledge by applying it to text formatting, table processing and drawing drafting, manage requests effectively, choosing best practices and personal solutions.
· Making judgments: knowing how to use procedural communications and technical instructions, knowing how to use IT tools to identify potentially useful solutions to a given application context in real problems, study and work, being aware of the potential and limits of the use of information Technology.
· Communication skills: knowing how to communicate correctly and effectively using IT tools.
Ability to learn: knowing how to learn independently or in a group and being able to connect topics covered during the course and with 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
Attendance of Lessons
Detailed Course Content
Fundamentals of computer science: information representation, numbering systems, computer architecture, notes on operating systems.
AutoCAD: toolbars, menu bar, command line, status bar. Layer, choice of colors, line types. Open and save a drawing. Lines and polylines. Polygons, circles and arc. Object snap, ortho mode. Offset, cut, copy, move, rotate, chamfer and fillet commands. Visualization (zoom, pan, redraw and regenerate). Press. Graphic formats.
Word: open and close program, file management (new, open, close, save, save as), find and replace, page view types, print preview, toolbar customization, undo, copy, paste and paste special, size, insert (image, formula, tables, notes, page numbers, symbol), text selection, text formatting (bold, italic, underline, small caps, font, font size, superscript and subscript, line spacing, alignment and justification, hyphenation, format painter, tabs, bulleted lists). Models. Styles. Headers and footers. Spelling and grammar check. Document setup. Press. Tables. Object import. Formats
graphs.
Excel: open and close program, file management (new, open, close, save, save as), view menu, page break preview, toolbar customization, data entry, data types, selection (cells, rows, columns , non-contiguous areas), resize, 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, graphs, document setup, print setup.
PowerPoint: create a new presentation from a template, change the theme of a presentation, add slides to the presentation, add and edit text, images, clipart and shapes to slides. Insert and modify tables and graphs, insert and modify animations and define the slide transition mode. Save the presentation.
Goal 4: Ensure quality, equitable and inclusive education and promote lifelong learning opportunities for all
· Target 4.4: By 2030, substantially increase the number of young people and adults who have the necessary skills, including technical and vocational skills, for employment, decent jobs and entrepreneurial capacity
· Target 4.6: By 2030, ensure that all young people and a substantial proportion of adults, men and women, achieve literacy and numeracy skills
Modality:
· Lesson
· Vector Drawing Laboratory
· Office Automation Laboratory
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 Libro: 9788850335787. ISBN Ebook: 9788850319251.
3. Excel 2021. Conoscere e sfruttare la potenza dei fogli di calcolo. POCKET Edimatica. APOGEO, ottobre 2021. ISBN Libro: 9788850335770. ISBN Ebook: 9788850319299.
4. PowerPoint 2021. Realizzare presentazioni chiare ed accattivanti. POCKET Edimatica. APOGEO, ottobre 2018. ISBN Libro:9788850335800. ISBN Ebook: 9788850319305.
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 elevation in CAD. | Exercises provided by the teacher. |
| 5 | AUTOCAD. Formatting of texts, insertion of dimensions and printing of graphic drawings. Practical exercise: drafting an elevation 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. Opening and saving files, setting up the document. Formatting styles. Inserting images, captions and cross-references and automatic summary. | 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
A final practical test on the computer, lasting 2 hours, on:
1. Word document: formatting of a text in Word;
2. Excel processing: creation of a table and its graph in Excel;
3. CAD drawing: drafting of a drawing (plan, elevation or section) on CAD.
During the course there are checks, two ongoing tests, to ascertain the level of learning.
The verification of learning can also be carried out electronically, should the conditions require it.
Evaluation criteria of the practical test on the computer:
Each WORD, EXCEL AND CAD work will be developed with a series of questions whose correct completion 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 if the threshold of 18/30 is exceeded in all three projects.
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, formatting cells, applying formulas, and graphing the given or computed values.