Portale di Ateneo - En.Unibs.it

Lesson 1 - Introduction to computer: overall architecture. Processor. Main memory. Mass storage. Peripherals.

Lesson 2 - The operating system: functionality and architecture. Multitasking. Memory management. File system. Drivers.

Lesson 3 - Application programs: open source software. The Office suite. Installing and updating software. System utilities.

Lesson 4 - Computer Threats. Trapdoors. Virus. Worms. Trojans. Structure of a virus. Antivirus. Signature and heuristics. Quarantine and disinfection. Phishing. Pharming.

Lesson 5 - Information and media. data representation. Information encoding. Character encoding: ASCII and UNICODE. Sound encoding. Sampling and quantization. Image encoding. Data compression. Video encoding

Lesson 6 - Word Processing. Advanced notions of page layout and document structure. Bulding a summary and a bibliography.

Lesson 7 - Introduction to the Spreadsheets. Relative and absolute references. Selection of one or more adjacent or non-adjacent cells. Entering numbers, dates or text.

Lesson 8 - Functions and formulas: basic concepts, common errors and use of some logical-mathematical functions. SOMMA, MIN, MAX, MEDIA, SE, CONTA.SE, SOMMA.SE, CERCA.VERT; STRINGA.ESTRAI, CONCATENA, MAIUSC e MINUSC functions.

Lesson 9 - Working with data. Sorting on one or more fields. Automatic and standard filters. Charts. Introduction to pivot tables.

Lesson 10 - Building a presentation. Introduction to PowerPoint. Guidelines.

Lesson 11 - Computer networks. The client-server paradigm. Web architecture. Network topology. Internet. DNS.

Lesson 12 - The Web. Hypertext. HTML. Http. URL. the browser. Static and dynamic pages. Cookies. Proxy.

Lesson 13 - Web 2.0. Web businesses: e-commerce, content and connectivity. Portals. Cloud computing. Mobile Internet.

Lesson 14 - Electronic security: SPID. Electronic invoice and digital signature. Certified e-mail. Digital preservation.

Lesson 15 - Information Retrieval. Surface and deep web. Information structured and non. Dynamic pages. Indexes. Directories open and closed. Bots. Spider. Coverage and Ranking.