COMPUTER SCIENCE LABORATORY M - Z

THE COURSE AIMS AT ENABLING STUDENTS TO ACQUIRE THE SKILLS NEEDED TO USE THE PERSONAL COMPUTER, WRITE AND EDIT A TEXT, CREATE SPREADSHEETS, SEND EMAIL, USE THE NETWORK RESOURCES AND THE INTERNET. IN ADDITION, 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

• Identify different types of computers as well as their main hardware components;
• Identify the main types of storage media and programme applications;
• Define the term software and distinguish between the main types of software like: operating systems, applications;
• Identify the main types of integrated and external equipment like: printers, screens, scanners, keyboards, mouse/trackpad, webcam, speakers, microphone;
• Identify common input/output ports;
• Work effectively on the computer using Desktop, icons, setting;
• Identify files and folders and recognise common file types;
• Understand the Internet and the World Wide Web and the importance of evaluating information on the World Wide Web;
• Understand what a Web browser is, use the web browser and manage browser settings and Internet service provide (ISP);
• Understand the structure of an email address and be able to create, send, and receive email and understand the security risks involved;
• 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, 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.

PRINCIPLES OF COMPUTER OPERATIONS: BITS AND BYTES, THE BINARY SYSTEM. ARCHITECTURE OF THE COMPUTER: CENTRAL PROCESSING UNIT, EVOLUTION OF MICROPROCESSORS, MEMORY, OTHER TYPES OF MEMORY (CACHE, BUFFERS, VIRTUAL MEMORY), STORAGE DEVICES, EXPANSION SLOTS, AND COMMUNICATION PORTS, INPUT DEVICES AND OUTPUT DEVICES.

COMPUTER NETWORKS AND INTERNET: LAN, INTERNET PROTOCOLS (HTTP, FTP, POP3, SMTP), THE ISDN AND ADSL.

WINDOWS: STARTING AND STOPPING OF THE SYSTEM, MANAGING WINDOWS, RUN AND FIND FILES, CONTROL PANEL, EXPLORER, COPY, DELETE AND FILE SHARING, GUIDANCE, CREATE SHORTCUTS, ACCESSORIES, PRINT MANAGEMENT.

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

1. Mario R. Storchi. Nuova ECDL – Modulo 1: Concetti di base del computer. Edizioni Manna, 2013.

2. Luigi Santapaga, Matteo Trasi. Autocad 2015 pocket. Apogeo, 2014.

3. Raffaella Rossini. Microsoft Word 2010 pocket. Apogeo, 2010.

4. Saverio Rubini. Microsoft Excel 2010 pocket. Apogeo, 2010.