DIGITAL LAB
Instructional goals
The course teaches students fundamental digital skills necessary for productive engaging with digital information. Through the course students will learn how to interact with online databases, how to use online databases or online forms to collect data, how to use spreadsheet software for data analysis, word processors for data reporting, and web technologies for online presentation. The course also introduces students to the foundations of web-based applications.
Intended learning outcomes
At the end of the course, students will be able to collect digital data from various online sources, import and analyze data in Excel, report the results of data analysis with Word, and disseminate data, reports and analysis on the web through a simple website they will learn how to build.
Course Contents
Collecting data performing query on specific digital platform. Using Google Form for collecting data. Analyzing a dataset using MS Excel. Using MS Word for describing analysis results. The fundamentals concept of Web-based application. Using Google site for configuring a personal web site, integrating some google applications (e.g. google forms) in the website.
Reference Books
Slides and other materials will be provided during the course using the official e-learning platform
Teaching Methods
During the course, every student will work on a personal project using her own laptop, implementing the data collection-analysis-reporting-presentation workflow, applying the concepts and using the tools introduced during class.
Assessment Method
Test based on Multiple choice
Thesis assignment criteria
Serious and motivation interest to study the topics of the course
Individual colloquium
Does the syllabus cover sustainability topics?
No, the course does not cover any sustainability topics.
Week 1 Contenuto sessioni on line e on campus
Course Introduction
Week 2 Contenuto sessioni on line e on campus
Using digital platform for retrieving data. How to perform a proper query. Some examples.
Week 3 Contenuto sessioni on line e on campus
Using Google Forms for collecting data. Designing and creating an online form using Google applications.
Week 4 Contenuto sessioni on line e on campus
Introduction to MS Excel. Basic functionalities and the use of formulas
Week 5 Contenuto sessioni on line e on campus
Analyzing data, creating diagrams and charts using MS Excel
Week 6 Contenuto sessioni on line e on campus
Introduction to the use of PIVOT table and charts on MS Excel
Week 7 Contenuto sessioni on line e on campus
Introduction to the fundamentals of MS Word. How to use table of contents, summary, revisions and comments.
Week 8 Contenuto sessioni on line e on campus
Creating a report of analysis using MS Word
Week 9 Contenuto sessioni on line e on campus
Introduction to web technologies, web-based applications, and content management systems
Week 10 Contenuto sessioni on line e on campus
Introduction to Google sites: how to set up a personal website
Week 11 Contenuto sessioni on line e on campus
Integrating Google tools in Google sites.
Week 12 Contenuto sessioni on line e on campus
Recap. Questions & Answers