COMPUTER SCIENCE LABORATORY M - Z
Academic Year 2023/2024 - Teacher: EVA SCIACCAExpected Learning Outcomes
The course aims to provide students with the basic digital skills for using computer systems, in particular word processing, spreadsheet, and CAD programs.
Course Structure
Lectures and laboratory exercises. Weekly reception to be arranged by email eva.sciacca@inaf.it
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
program planned and outlined in the syllabus.
Information for students with disabilities and/or DSA
To guarantee equal opportunities and in compliance with current laws, interested students can request a personal interview in order to plan any compensatory and/or dispensatory measures, based on the educational objectives and specific needs.
It is also possible to contact the CInAP (Centre for Active and Participated Inclusion - Services for Disabilities and/or DSA) professor of our Department, prof. Anna De Angelis.
Required Prerequisites
Basic knowledge of Windows operating system.
Attendance of Lessons
Mandatory
Detailed Course Content
Basic elements of Information Technology: encoding systems, representation of information. Hardware: CPU, bus, ports, memory, Internet connections. Software: Operating Systems: Windows. Application software.
Writing: Main Word Functions. Tables and drawings, print. Advanced features.
Spreadsheets: The main Excel functions. The references. Formulas, tables, data analysis, formatting and security, charts and print.
Main AutoCAD functions.
Textbook Information
- Raffaella Rossini. Microsoft Word 2013 pocket. Apogeo, 2013.
- Saverio Rubini. Microsoft Excel 2013 pocket. Apogeo, 2013.
- Luigi Santapaga, Matteo Trasi. Autocad 2015 pocket. Apogeo, 2014.
Course Planning
| Subjects | Text References | |
|---|---|---|
| 1 | Basic concepts of Information Technology and the Web | |
| 2 | Production of Documents and Reports: Word | Raffaella Rossini. Microsoft Word 2013 pocket. Apogeo, 2013. |
| 3 | Spreadsheets: main Excel functionalities | Saverio Rubini. Microsoft Excel 2013 pocket. Apogeo, 2013. |
| 4 | CAD drawing: Main functions of AutoCAD | Luigi Santapaga, Matteo Trasi. Autocad 2015 pocket. Apogeo, 2014. |
Learning Assessment
Learning Assessment Procedures
Practical test in the laboratory. Oral exam at the discretion of the professor
Not approved: Knowledge and understanding of the topic: Important deficiencies. Significant inaccuracies. Analysis and synthesis skills: Irrelevant. Frequent generalizations. Inability to synthesize. Use of references: Completely inappropriate
Approved: Knowledge and understanding of the main topics. Ability to create the exam test, with sufficient/excellent knowledge of the topics
Examples of frequently asked questions and / or exercises
Create a Word document with specific characteristics, Set up a spreadsheet, create a simple project in AutoCAD.