4. Open Source Office Software
Training provided by
- Open Minds
- ACDC
Category(ies) of solution(s) studied
- Office - Internet (Office suite, email, browsing)
- Education, Training
Presentation
This module is designed to meet the needs of staff and trainers working or collaborating with socio-cultural organisations interested in the use of free office software .
It is a structured training program for free software, including free software web browsers involves covering various aspects of the browser's web usage, customization, and security .
It is a structured training program for free software, including free software web browsers involves covering various aspects of the browser's web usage, customization, and security .
Training objectives
Be able to master free software office tools that meet the needs of cultural associations and other similar organizations
Reason for module
The use of open source software offers office tool solutions that reduce startup costs, faster project start-ups , faster iterations, more flexible software development processes, robust community support, and easier license management, without being contractually tied to working with a single vendor.
These tools offer viable alternatives to proprietary office software while promoting transparency and collaboration
The choice to use open source software depends on individual or organizational needs, values, and goals. Many users appreciate the flexibility, transparency, and economic benefits of free software, while others may prioritize the specific support or features offered by proprietary alternatives.
These tools offer viable alternatives to proprietary office software while promoting transparency and collaboration
The choice to use open source software depends on individual or organizational needs, values, and goals. Many users appreciate the flexibility, transparency, and economic benefits of free software, while others may prioritize the specific support or features offered by proprietary alternatives.
Target audience
1. Teaching and active staff of socio-cultural and associative structures
2. Those responsible for the formation of these structures
3. Training of operators in this sector
2. Those responsible for the formation of these structures
3. Training of operators in this sector
Summary of module content
Unit 1 - Introduce different office tool solutions with pros and cons providing teachers with multiple options depending on their digital infrastructure
Module 1: Introduction to LibreOffice
Module 2: LibreOffice Writer (Word Processor) Module 3: LibreOffice Calc (Spreadsheets) Module 4: LibreOffice Impress (Presentations) Module 5: Additional LibreOffice Applications Module 6: LibreOffice Advanced Topics
Module 7: Web Browsers (Mozilla Firefox) Module 8: Using Firefox
Module 9: Web Security and Safe Browsing Module 10: Installing and Using the Persepolis Download Manager
Module 11: ClamAV Antivirus Software
Unit 2 - Assessment
Module 12: Final Exam and Certification
Module 1: Introduction to LibreOffice
Module 2: LibreOffice Writer (Word Processor) Module 3: LibreOffice Calc (Spreadsheets) Module 4: LibreOffice Impress (Presentations) Module 5: Additional LibreOffice Applications Module 6: LibreOffice Advanced Topics
Module 7: Web Browsers (Mozilla Firefox) Module 8: Using Firefox
Module 9: Web Security and Safe Browsing Module 10: Installing and Using the Persepolis Download Manager
Module 11: ClamAV Antivirus Software
Unit 2 - Assessment
Module 12: Final Exam and Certification
Number of sequences
A dozen sequences
Type of training face to face, online
- En ligneOn lineOn lineEn líneaOn line
- En présentielFace-to-faceCara a caraPresencialfață în față
Is training free or chargeable?
GratuiteFreeGratisGratuïtGratuit
Possible formats (face-to-face, online)
Online training (a dozen modules)
Face-to-face training action over 3 days
Webinar from online training
Combined face-to-face – webinar
Face-to-face training action over 3 days
Webinar from online training
Combined face-to-face – webinar
Learning outcomes - Key skills
Learning open source office software can provide individuals with a range of key skills and abilities that are valuable in both personal and professional contexts:
- LiteracyDigital Literacy
- Word processing skills
- Mastery of spreadsheet applications such as LibreOffice Calc allows users to manage data efficiently, including organizing, analyzing, and presenting it in tables and graphs
- Presentation Capabilities
- Document collaboration (users develop skills in remote teamwork and document sharing and editing)
- Users learn how to efficiently search, evaluate, and retrieve information from the web, improving their search skills
Equivalent key competencies Digcomp
- Learning free software encourages adaptability, as users become more comfortable switching between different software tools and platforms
- Understanding and using open source software tools can lead to cost savings, which is an essential skill for individuals and organizations looking to optimize their budgets
- Users gain an understanding of open source principles, including the importance of transparency, collaboration, and software freedom, which can extend to other areas of technology.
Prerequisites - Requirements
The training does not require any particular knowledge of the languages and techniques of the Internet.
Participant selection procedures and criteria
This training is intended and open to anyone wishing to improve their digital literacy skills and more particularly to educational staff and training actors of socio-cultural and associative structures, their beneficiaries, members, volunteers and partners who want to acquire skills to acquire knowledge and skills to make them evolve.
Teaching aids
Documentation, online resource materials, guides, tutorials, technical glossaries and links
Videos, quizzes, multiple choice questions, exercises, evaluations
Cooperative tools (discussion list, live chat, website)
Videos, quizzes, multiple choice questions, exercises, evaluations
Cooperative tools (discussion list, live chat, website)
Learner support, follow-up and assessment
Quizzes and feedback interviews
Teaching method
Interactive teaching using examples and practical exercises Focuses on practice, collaboration and exchange to facilitate the acquisition and application of new skills.
1. Training-Action: real-life situations leading to the acquisition of skills that are directly exploited
2. Alternation of theoretical, participatory and practical sequences
3. Exchange of knowledge and practices between participants
4. Group dynamics: active listening and collective intelligence
1. Training-Action: real-life situations leading to the acquisition of skills that are directly exploited
2. Alternation of theoretical, participatory and practical sequences
3. Exchange of knowledge and practices between participants
4. Group dynamics: active listening and collective intelligence
Type of training
Webinar-style online distance learning using MOOCs-like approaches
1. Courses, workshops, presentations, conferences
2. Trainee groupings, work meetings and workshops
- Open to all free of charge
- Form: texts, videos, online documents, exercises, self-assessment
- Exchange tools: video-conferencing, emails, discussion lists, messaging, forum, wiki, pad,
1. Courses, workshops, presentations, conferences
2. Trainee groupings, work meetings and workshops
Training schedule - Sequencing - day by day
1. face-to-face days + introduction, completion and online exercises
Day 1
Module 1: Introduction to LibreOffice
1. Reception and orientation
Overview of the training program. Presentation of the trainer and the participants.
Set expectations and learning objectives.
2. Understanding LibreOffice
What is LibreOffice ?
Brief history and its open source nature.
Advantages and benefits of using LibreOffice.
3. Installer LibreOffice
Downloading and installing LibreOffice on different systems
Initial installation and configuration.
Module 2: LibreOffice Writer (word processor)
1. Getting started with Writer Launch of Writer and its interface.
Create, open, and save documents.
2. Text formatting
Basic text formatting (font, size, style, color). Paragraph formatting (alignment, indentation, spacing).
Bullets and numbering.
3. Working with styles Understanding styles and their importance. Create and edit styles.
Apply styles for consistent formatting of documents.
4. Tables and Figures
Create and format tables. Insert and format images and shapes. Text wrapping and positioning.
5. Advanced features
Headers, footers, and page numbering. Sections and page styles.
Track changes and comments for collaborative editing.
Module 3: LibreOffice Calc (spreadsheets)
1. Introduction to Calc
Launch of Calc and its interface.
Create, open, and save spreadsheets.
2. Data entry and formatting Data entry and editing.
Basic cell formatting (number, alignment, font). Cell styles and cell protection.
3. Formulas and Functions Understanding cell references. Creation and editing of formulas.
Common functions (SUM, MEAN, SI, VSEARCH).
4. Charts and graphs
Creating and customizing graphics.
Added data labels and trend lines. Chart types and formatting options.
5. Data analysis tools
Pivot tables and data consolidation. Scenario manager for what, if analysis.
Module 4: LibreOffice Impress (Presentations)
2. .1. Getting started with Impress Launch of Impress and its interface. Create a new layout.
Work with slides and layouts.
1. Slide design and content
Formatting backgrounds and slide templates. Insert text, images, and multimedia elements.
Slide transitions and animations.
2. Main slides and templates
Create and edit master slides.
Use templates for a consistent presentation design.
3. Slideshow and delivery Run a presentation.
Presenter and slideshow display settings. Tips for an effective presentation
Day 2
Module 5: Additional LibreOffice Applications
1. LibreOffice Draw (vector graphics) Introduction to drawing.
Create vector graphics and diagrams. Work with shapes, connectors, and layers.
2. LibreOffice Database Introduction to Base.
Creation and management of databases. Creation of forms and reports.
Module 6: Advanced Topics
1. Collaborative work
Use LibreOffice Online for real-time collaboration. Document sharing through cloud services.
2. Advanced features and tips Merge and mail merge and data sources. Macros and automation.
Customization and extensions. Module 7: Web Browsers Understanding Web Browsers
1. What is a web browser? Why choose Mozilla Firefox?
2. Installing and updating Firefox
Download and install Firefox on different operating systems.
Make sure the browser is up to date. Module 8: Using Firefox
1. Launch and navigate in Firefox Opening Firefox and its interface. Navigating the browser window.
Keyboard shortcuts for efficient navigation.
2. Web Browsing
3. Adjusting browser settings and preferences. Change themes and appearances.
4. Extensions and add-ons Installing and managing Firefox extensions.
Popular extensions for productivity, privacy, and security.
5. Search Engine Preferences
Setting your default search engine. Adding and managing search engines.
6. Privacy and security settings
Configuring privacy settings for Tracking Protection.
Management of cookies, cache and browser data. Module 9: Web Security and Safe Browsing
1. Online Safety
Recognize secure websites (HTTPS). Identify phishing and malicious websites.
Using Firefox Monitor for data breach alerts.
2. Password Management
Using Firefox Lockwise for password management. Best practices for creating and storing passwords securely.
3. Browser Security Features
An overview of Firefox's security features, such as sandboxing and automatic updates.
Importance of keeping Firefox up to date
Day 3
Module 10: Installing and Using the Persepolis Download Manager
1. Understand the purpose and benefits of Persepolis.
2. Installation of Persepolis
Download and install Persepolis on different operating systems .
Initial installation and configuration.
3. Launch of Persepolis
Opening of Persepolis and its user interface. Navigate the main menu and toolbar.
4. File Upload
Launch single and multiple file uploads. Monitoring of progress and download speeds. Pause, resume, and cancel downloads.
5. Managing the download queue Organizing the download queue. Setting download priorities.
Configure download options (location, file renaming, etc.)
Module 11: ClamAV Antivirus Software
1. What is antivirus software and why is it a must
?
Introduction to ClamAV and its open source nature.
2. Installing ClamAV
Download and install ClamAV on different operating systems.
Initial installation and configuration.
3. Basic use of ClamAV
1. Command Line Interface (CLI)
Introduction to the ClamAV CLI . Scan files, directories, and drives.
Understand analytics reports.
2. Updated definitions
Virus database and signature update. Schedule automatic updates.
3. Quarantine and cleaning
Infected file management: quarantine and cleanup. Configuring quarantine settings
Module 12: Final Exam and Certification
12.1. Examination and Q&A Summary of the key topics of each module.
Respond to questions and challenges from participants.
12.2 Evaluation and Certification
Day 1
Module 1: Introduction to LibreOffice
1. Reception and orientation
Overview of the training program. Presentation of the trainer and the participants.
Set expectations and learning objectives.
2. Understanding LibreOffice
What is LibreOffice ?
Brief history and its open source nature.
Advantages and benefits of using LibreOffice.
3. Installer LibreOffice
Downloading and installing LibreOffice on different systems
Initial installation and configuration.
Module 2: LibreOffice Writer (word processor)
1. Getting started with Writer Launch of Writer and its interface.
Create, open, and save documents.
2. Text formatting
Basic text formatting (font, size, style, color). Paragraph formatting (alignment, indentation, spacing).
Bullets and numbering.
3. Working with styles Understanding styles and their importance. Create and edit styles.
Apply styles for consistent formatting of documents.
4. Tables and Figures
Create and format tables. Insert and format images and shapes. Text wrapping and positioning.
5. Advanced features
Headers, footers, and page numbering. Sections and page styles.
Track changes and comments for collaborative editing.
Module 3: LibreOffice Calc (spreadsheets)
1. Introduction to Calc
Launch of Calc and its interface.
Create, open, and save spreadsheets.
2. Data entry and formatting Data entry and editing.
Basic cell formatting (number, alignment, font). Cell styles and cell protection.
3. Formulas and Functions Understanding cell references. Creation and editing of formulas.
Common functions (SUM, MEAN, SI, VSEARCH).
4. Charts and graphs
Creating and customizing graphics.
Added data labels and trend lines. Chart types and formatting options.
5. Data analysis tools
Pivot tables and data consolidation. Scenario manager for what, if analysis.
Module 4: LibreOffice Impress (Presentations)
2. .1. Getting started with Impress Launch of Impress and its interface. Create a new layout.
Work with slides and layouts.
1. Slide design and content
Formatting backgrounds and slide templates. Insert text, images, and multimedia elements.
Slide transitions and animations.
2. Main slides and templates
Create and edit master slides.
Use templates for a consistent presentation design.
3. Slideshow and delivery Run a presentation.
Presenter and slideshow display settings. Tips for an effective presentation
Day 2
Module 5: Additional LibreOffice Applications
1. LibreOffice Draw (vector graphics) Introduction to drawing.
Create vector graphics and diagrams. Work with shapes, connectors, and layers.
2. LibreOffice Database Introduction to Base.
Creation and management of databases. Creation of forms and reports.
Module 6: Advanced Topics
1. Collaborative work
Use LibreOffice Online for real-time collaboration. Document sharing through cloud services.
2. Advanced features and tips Merge and mail merge and data sources. Macros and automation.
Customization and extensions. Module 7: Web Browsers Understanding Web Browsers
1. What is a web browser? Why choose Mozilla Firefox?
2. Installing and updating Firefox
Download and install Firefox on different operating systems.
Make sure the browser is up to date. Module 8: Using Firefox
1. Launch and navigate in Firefox Opening Firefox and its interface. Navigating the browser window.
Keyboard shortcuts for efficient navigation.
2. Web Browsing
3. Adjusting browser settings and preferences. Change themes and appearances.
4. Extensions and add-ons Installing and managing Firefox extensions.
Popular extensions for productivity, privacy, and security.
5. Search Engine Preferences
Setting your default search engine. Adding and managing search engines.
6. Privacy and security settings
Configuring privacy settings for Tracking Protection.
Management of cookies, cache and browser data. Module 9: Web Security and Safe Browsing
1. Online Safety
Recognize secure websites (HTTPS). Identify phishing and malicious websites.
Using Firefox Monitor for data breach alerts.
2. Password Management
Using Firefox Lockwise for password management. Best practices for creating and storing passwords securely.
3. Browser Security Features
An overview of Firefox's security features, such as sandboxing and automatic updates.
Importance of keeping Firefox up to date
Day 3
Module 10: Installing and Using the Persepolis Download Manager
1. Understand the purpose and benefits of Persepolis.
2. Installation of Persepolis
Download and install Persepolis on different operating systems .
Initial installation and configuration.
3. Launch of Persepolis
Opening of Persepolis and its user interface. Navigate the main menu and toolbar.
4. File Upload
Launch single and multiple file uploads. Monitoring of progress and download speeds. Pause, resume, and cancel downloads.
5. Managing the download queue Organizing the download queue. Setting download priorities.
Configure download options (location, file renaming, etc.)
Module 11: ClamAV Antivirus Software
1. What is antivirus software and why is it a must
?
Introduction to ClamAV and its open source nature.
2. Installing ClamAV
Download and install ClamAV on different operating systems.
Initial installation and configuration.
3. Basic use of ClamAV
1. Command Line Interface (CLI)
Introduction to the ClamAV CLI . Scan files, directories, and drives.
Understand analytics reports.
2. Updated definitions
Virus database and signature update. Schedule automatic updates.
3. Quarantine and cleaning
Infected file management: quarantine and cleanup. Configuring quarantine settings
Module 12: Final Exam and Certification
12.1. Examination and Q&A Summary of the key topics of each module.
Respond to questions and challenges from participants.
12.2 Evaluation and Certification
Additional information - Why free and open source digital technology?
1. LibreOffice
Here are some of the advantages of LibreOffice over other office suites:
1. No licensing fees. LibreOffice is free and can be used and distributed for free by anyone. Many features available as paid add-ons in other office suites (such as PDF export) are free with LibreOffice. There are no hidden fees, now or in the future.
2. Open source. You can distribute, copy, and modify the software as much as you want, in accordance with LibreOffice Open Source licenses.
3. Cross-platform. LibreOffice runs on multiple hardware architectures and operating systems, such as Microsoft Windows, Mac OS X, and Linux.
4. Extensive language support. LibreOffice's user interface, including spelling, hyphenation, and thesaurus dictionaries, is available in more than 100 languages and dialects. LibreOffice also supports Complex Text Layout (CTL) and Right-to-Left (RTL) languages (such as Urdu, Hebrew, and Arabic).
5. Consistent user interface. All components have a similar appearance, making them easy to use and master.
6. Integration. LibreOffice's components are well integrated with each other. – All components share a common spell checker and other tools, which are used consistently throughout the suite. For example, the drawing tools available in Writer are also found in Calc, with similar but improved versions in Impress and Draw. – You don't need to know which application was used to create a particular file. For example, you can open a Draw file from Writer.
7. Granularity. Usually, if you change one option, it affects all components. However, LibreOffice options can be set at the component level or even at the document level.
8. File compatibility. In addition to its native Open Document formats, LibreOffice includes support for opening and saving files in many popular formats, including Microsoft Office, HTML, XML, Word Perfect, Lotus 1-2-3, and PDF.
1. (OrganizationfortheAdvancement of Structured Information Standards). These files can easily be unzipped and read by any text editor, and their frame is opened and published.
2. You have a voice. Enhancements, software fixes, and release dates are determined by the community. You can join the community and influence the course of the product you use.
Main Libre Office tools:
-Word processing
-Calc-spreadsheet
-Printing- presentations
-Draw - diagrams
-Database-database
1. Mathematics - formula editor
2. Charts for charting
1. Firefox open source web browser
Firefox is an open-source web browser developed by the Mozilla Foundation and its subsidiary, Mozilla Corporation and is one of the best open-source web browsers. It is available for Windows, Mac OS X, Linux, and other operating systems Advantages:
1. Lightweight on memory usage /Firefox made a major update in 2017 that reduced the browser's memory consumption, thus speeding it up for several tasks.
2. Better default privacy settings/Mozilla, the creator of Firefox, has a reputation for caring about user privacy . This is reflected in Firefox's stricter default security settings, which are designed to keep user data secure .
3. More customization options/Firefox gives you more customization options than other browsers, including the ability to move features and install themes that change the look of the browser. You can also customize the toolbars and overflow menu by adding the options you use the most and placing them where you want them.
4. https mode only for security/A new feature recently introduced by Firefox is HTTPS only mode. When this option is enabled, your web experience is more
1. Mozilla continues to improve browser speed/Mozilla continues to improve the speed and performance of Firefox. This focus on user experience is another reason to switch to Firefox as your default browser.
2. Firefox is a browser that is well supported by several operating systems, including those for mobile devices. There is a version of Firefox for iOS and Android. You can log in across your devices and sync your settings, favorites, and more for a consistent experience wherever you browse.
3. Blocking Online Trackers/Every move we make online today is tracked by some type of cookie. From Google to individual websites and advertisers, our digital footprints can be collected across multiple organizations.
2. Dowload Manager Persépolis
Training on Persepolis Download Manager, a free and open-source download manager, can help users understand its features and make the most of its capabilities.
Persepolis Download Manager is available for Windows, macOS, and Linux, and it's free to use.
It's also worth mentioning that Persepolis is updated frequently. In combination with robust features, this makes it a very reliable open-source download manager.
-offers multi-segment downloading,
- Scheduling downloads,
- download queue,
- Pause or resume downloads.
3. ClamAV Antivirus
Training on ClamAV, an open-source antivirus software, can help individuals and organizations protect their systems from malware threats.
Clam AV is an open-source antivirus software designed to detect and remove malware from computers and servers. It uses a combination of signature-based detection, heuristics, and machine learning to identify and classify potential threats.
Clam AV is widely used by individuals, businesses, and businesses
Here are some of the advantages of LibreOffice over other office suites:
1. No licensing fees. LibreOffice is free and can be used and distributed for free by anyone. Many features available as paid add-ons in other office suites (such as PDF export) are free with LibreOffice. There are no hidden fees, now or in the future.
2. Open source. You can distribute, copy, and modify the software as much as you want, in accordance with LibreOffice Open Source licenses.
3. Cross-platform. LibreOffice runs on multiple hardware architectures and operating systems, such as Microsoft Windows, Mac OS X, and Linux.
4. Extensive language support. LibreOffice's user interface, including spelling, hyphenation, and thesaurus dictionaries, is available in more than 100 languages and dialects. LibreOffice also supports Complex Text Layout (CTL) and Right-to-Left (RTL) languages (such as Urdu, Hebrew, and Arabic).
5. Consistent user interface. All components have a similar appearance, making them easy to use and master.
6. Integration. LibreOffice's components are well integrated with each other. – All components share a common spell checker and other tools, which are used consistently throughout the suite. For example, the drawing tools available in Writer are also found in Calc, with similar but improved versions in Impress and Draw. – You don't need to know which application was used to create a particular file. For example, you can open a Draw file from Writer.
7. Granularity. Usually, if you change one option, it affects all components. However, LibreOffice options can be set at the component level or even at the document level.
8. File compatibility. In addition to its native Open Document formats, LibreOffice includes support for opening and saving files in many popular formats, including Microsoft Office, HTML, XML, Word Perfect, Lotus 1-2-3, and PDF.
1. (OrganizationfortheAdvancement of Structured Information Standards). These files can easily be unzipped and read by any text editor, and their frame is opened and published.
2. You have a voice. Enhancements, software fixes, and release dates are determined by the community. You can join the community and influence the course of the product you use.
Main Libre Office tools:
-Word processing
-Calc-spreadsheet
-Printing- presentations
-Draw - diagrams
-Database-database
1. Mathematics - formula editor
2. Charts for charting
1. Firefox open source web browser
Firefox is an open-source web browser developed by the Mozilla Foundation and its subsidiary, Mozilla Corporation and is one of the best open-source web browsers. It is available for Windows, Mac OS X, Linux, and other operating systems Advantages:
1. Lightweight on memory usage /Firefox made a major update in 2017 that reduced the browser's memory consumption, thus speeding it up for several tasks.
2. Better default privacy settings/Mozilla, the creator of Firefox, has a reputation for caring about user privacy . This is reflected in Firefox's stricter default security settings, which are designed to keep user data secure .
3. More customization options/Firefox gives you more customization options than other browsers, including the ability to move features and install themes that change the look of the browser. You can also customize the toolbars and overflow menu by adding the options you use the most and placing them where you want them.
4. https mode only for security/A new feature recently introduced by Firefox is HTTPS only mode. When this option is enabled, your web experience is more
1. Mozilla continues to improve browser speed/Mozilla continues to improve the speed and performance of Firefox. This focus on user experience is another reason to switch to Firefox as your default browser.
2. Firefox is a browser that is well supported by several operating systems, including those for mobile devices. There is a version of Firefox for iOS and Android. You can log in across your devices and sync your settings, favorites, and more for a consistent experience wherever you browse.
3. Blocking Online Trackers/Every move we make online today is tracked by some type of cookie. From Google to individual websites and advertisers, our digital footprints can be collected across multiple organizations.
2. Dowload Manager Persépolis
Training on Persepolis Download Manager, a free and open-source download manager, can help users understand its features and make the most of its capabilities.
Persepolis Download Manager is available for Windows, macOS, and Linux, and it's free to use.
It's also worth mentioning that Persepolis is updated frequently. In combination with robust features, this makes it a very reliable open-source download manager.
-offers multi-segment downloading,
- Scheduling downloads,
- download queue,
- Pause or resume downloads.
3. ClamAV Antivirus
Training on ClamAV, an open-source antivirus software, can help individuals and organizations protect their systems from malware threats.
Clam AV is an open-source antivirus software designed to detect and remove malware from computers and servers. It uses a combination of signature-based detection, heuristics, and machine learning to identify and classify potential threats.
Clam AV is widely used by individuals, businesses, and businesses
LibreOffice
Firefox
Persepolis
ClamAV
Firefox
Persepolis
ClamAV
Other solutions presented and discussed
Nextcloud
Framasoft
Moodle
Framasoft
Moodle
Sheet language
en
Created by
ACDC