COMPUTER SKILLS LAB
Instructional goals
The Computer Skills Lab provides first-year Business Administration students with practical digital competencies in two complementary areas: AI literacy and advanced spreadsheet-based data analysis.
The first part of the course introduces the fundamental concepts, techniques and applications of Artificial Intelligence, with a strong emphasis on the effective, critical and responsible use of generative AI tools in academic and professional contexts.
The second part develops advanced Microsoft Excel skills, focusing on formulas and PivotTable-based data analysis for business-oriented tasks.
The course adopts a hands-on, lab-based approach that includes directly use of AI tools and Excel on realistic exercises and case studies.
Intended learning outcomes
Upon successful completion of the course, students will be able to:
- explain what Artificial Intelligence is and distinguish its main subfields (machine learning, deep learning, natural language processing, generative AI);
- describe the historical evolution of AI and the main technological milestones that led to current tools;
- understand, at an introductory level, the main families of algorithms: supervised and unsupervised learning, neural networks and language models;
- identify relevant applications of AI in business, individual productivity, creativity and data analysis;
- critically assess the ethical, social and regulatory implications of AI, including bias, privacy, governance, reliability of outputs and responsible use;
- carry out AI-assisted web research with appropriate source validation and produce reliable syntheses;
- understand the notion of agentic AI, its opportunities, limits and risks;
- build advanced Excel workbooks using logical, lookup, text, date/time and dynamic array functions;
- analyze datasets using PivotTables and produce clear, well-structured data summaries and reports.
Course Contents
The course is organized into two parts.
Part I - AI Literacy: fundamental concepts of Artificial Intelligence and its main subfields (machine learning, deep learning, natural language processing, generative AI); historical evolution of AI; main techniques and families of algorithms (supervised and unsupervised learning, neural networks, language models), presented with an introductory and applied perspective; applications of AI in business, individual productivity, creativity and data analysis; ethical, social and regulatory implications of AI (bias, privacy, governance, reliability of outputs, responsible use); AI-assisted web research, source validation and synthesis; integration of AI into productivity tools (Excel, Word, PowerPoint); generation of multimedia content (images, video, audio) and multimodal analysis of visual content; introduction to agentic AI, from reactive chatbots to task-oriented systems.
Part II - Advanced Excel: advanced formulas (logical, lookup and reference, text, date/time, dynamic arrays); structured tables, data cleaning and conditional formatting; PivotTables and slicers; an integrated data-analysis case combining the techniques learned.
Reference Books
Lecture slides, lab worksheets, tutorials and datasets provided by the instructor on the course web page constitute the main reference material and are sufficient for exam preparation.
Teaching Methods
The course adopts a lab-based teaching approach combining interactive lectures with hands-on activities. Each session includes guided exercises, carried out individually or in small groups, using AI tools and Microsoft Excel on realistic, business-oriented datasets and scenarios. Live demonstrations, class discussion of results and the analysis of real-world cases complement the practical work. Students are required to bring their own laptop to class.
Assessment Method
Attending students: the final grade is determined by a mid-term written exam (1/3 of the final grade), covering the AI literacy part of the course, and a final written exam (2/3 of the final grade), covering all of the topics.
Non-attending students: the assessment consists of a single final written exam covering the entire course program (100% of the final grade).
Written exams may include multiple-choice questions and practical exercises (e.g., interpretation of AI outputs, prompt design, Excel formulas and PivotTable scenarios).
Thesis assignment criteria
Final assignments are allocated on the basis of the student's interest in the course topics (AI literacy, generative and agentic AI, data analysis with spreadsheets), the consistency of the proposed topic with the course contents, and the student's overall academic record. Students interested in a final assignment are invited to contact the instructor with a short written proposal.
Week 1
Introduction to Artificial Intelligence: what AI is (and is not); main subfields: machine learning, deep learning, natural language processing and generative AI; overview of the course organization, lab tools and assessment methods.
Week 2
Historical evolution of AI: key technological milestones from symbolic AI to machine learning and deep learning; the developments that led to the diffusion of today's generative AI tools.
Week 3
Main techniques and families of algorithms: supervised and unsupervised learning, neural networks and language models, presented with an introductory and application-oriented approach.
Week 4
Applications of AI in professional and industry contexts: business use cases, individual productivity, creativity and data analysis; discussion of real-world examples.
Week 5
Ethical, social and regulatory implications of AI: bias, privacy, governance, reliability of outputs and responsible use of AI tools; overview of the European regulatory framework (EU AI Act).
Week 6
Hands-on lab on generative AI: question answering, text classification, summarization and writing support; design of effective prompts; AI-assisted web research, validation of sources and production of reliable syntheses.
Week 7
AI in productivity tools: integration of AI assistants in Excel, Word and PowerPoint; examples of data-analysis automation, formula generation, document formatting and presentation creation.
Week 8
Lab on multimedia content generation with AI (images, video, audio): style definition, storyboard construction and content design; multimodal analysis: using AI to interpret images, charts and diagrams, with exercises on information extraction and critical reading of visual data. Introduction to agentic AI: from reactive chatbots to task-oriented systems capable of planning, using external tools and executing sequences of actions; opportunities, limits and risks.
Week 9
Advanced Excel I - formulas: logical functions (IF, IFS, AND, OR), lookup and reference functions (XLOOKUP, INDEX/MATCH), text functions and error handling.
Week 10
Advanced Excel II - dynamic arrays and data preparation: dynamic array functions (FILTER, SORT, UNIQUE, SEQUENCE), date/time functions, structured tables, data cleaning, data validation and conditional formatting.
Week 11
Advanced Excel III - PivotTables: building and configuring PivotTables; grouping, calculated fields, slicers and PivotCharts for interactive reporting.
Week 12
Advanced Excel IV - integrated data-analysis case: from raw data to an analytical report combining advanced formulas, PivotTables and charts; course wrap-up and final exam preparation.