🔎 Type a Keyword in English to Find Relevant Training

👀 How to coordinate this training: 1. Explanation Go through why and when we need to resize the image. 2. Demonstrate Watch the video together or demonstrate how to resize an image using your own devices. 3. Exercise Each participant searches for a photo either online or from their own photos. The image from the network is first saved to your own device. Opening the image in an image editing program (e.g. Microsoft Photos tool) and minimising it. Instructions on how to reduce the size of the image together. Learners practice reducing the size of their own images on their own devices. Materials needed: Computer 💻 or Mobile phone 📲 How to reduce the file size of an image est. 45 min 💡 After this training: The learner knows how to change the file size of an image to a smaller size and understands why it is sometimes necessary. ✨ Digital skills training about resizing an image Windows 11 Video language 🇬🇧 iPhone Video language 🇬🇧 Tips💡 Why resizing an image is needed Practical use : Many online platforms (job portals, social media, applications) require smaller images for uploading. Storage : Large image files take up space on devices. Sharing : Smaller files are easier to send via email or messaging apps. Speed : Small images load faster in presentations or websites. Demonstration Tips for Trainers When showing learners how to resize images, keep these steps in mind: Start with a Live Example Open an image on your own device. Use a simple tool like Microsoft Photos , Preview (Mac) , or even Paint . Share your screen or use a projector so everyone can follow. Explain Two Methods of Making Images Smaller Resizing (dimensions) : Reducing the height and width (e.g., from 2000x1500 pixels to 800x600 pixels). Compressing (file size) : Keeping the same dimensions but reducing file size (useful for emailing). Demonstrate Step-by-Step (example in Microsoft Photos on Windows): Right-click the photo → Open with → Photos . Click the three dots (…) menu → Resize . Choose a preset (Small, Medium, Large) or Custom dimensions . Save the resized version. Practice Together Ask participants to open their chosen image. Guide them step by step. Encourage them to try different sizes and compare results. Show Before & After Compare original and resized images side by side. Highlight the change in file size (e.g., from 4MB to 500KB). Encourage Exploration Let learners try different tools if available on their devices. Mention online free tools (e.g., TinyPNG, ILoveIMG) but emphasise caution about privacy if using personal photos. Open Badge: Using and managing applications Discover how to use this training material together with other themes to help learners earn the Open Badge. Badges allow learners to demonstrate the skills they have gained and showcase their achievements. Learn more by clicking the button below. Read more about the Open Badge 👋🏽 Join the Community Ideas on how to create better training? Would you like to share how your training went? Join our community of digital skills trainers from the button below. Join discussions

Email Basics est. 60 - 90 min 💡 After this training: The learner is able to explain the different uses of email. 👀 How to coordinate this training: Things to note before this training If people don't have an account, reserve time to create one beforehand or schedule a time to do this together during the training. 1. Exercise Let's watch the video together or independently the video Alternatively, you can show what email looks like on your computer and phone by explaining main features: Login Inbox Different folders How to send an email 2. Discussion Let's discuss together how to use email: What or which service do you use for your email account? What different purposes do you use email for? What is easy about using email? What is difficult about using email? Exercise: Send an email Write an email and send it to the trainer. Subject: "Hello" or "Greeting" To: trainer's email Message: Hello, here is the test message you requested during the training. Regards, First name Last name Additional Exercise Add a CC or Bcc recipient to the message. Find out what these terms mean. https://youtu.be/ZnSfEklfo34?feature=shared Add an attachment to the message, such as a document or screenshot, or a CV if the learner has one. Ensure it doesn't include sensitive information such as a personal identity code. Create a signature for your email and add it to the message. Materials needed: Computer 💻 Mobile phone 📲 Email account ✉️ ✨ Digital skills training about emailing Gmail Video language 🇬🇧 It's a long video, so you can check for relevant sections or get inspiration on how to demonstrate in the course. Video list 🇬🇧 Playlist on Gmail by LearnFree Video🇫🇮 Kuinka käytetään sähköpostia - esimerkkinä Gmail (Smart Seniors) Microsoft Outlook Video language 🇬🇧 Materials in English 🇬🇧 Tutorial with videos and texts 🇬🇧 and available in more languages Outlook tutorial by Microsoft Presentation Slides and Notes for Presentation 🇬🇧 Learn to use email (Digidel) Email is one of the most important functions in today's society. Without e-mail, there are few places on the internet where you can register as a user or order goods. Here, there are two different courses - one for Gmail and one for Outlook. Please note that some contents are based in Norway, but you can use slides and notes to get some tips on demonstrating and explaining this topic. Materials in Finnish 🇫🇮 Video🇫🇮 Sähköpostin peruskäyttö (Osuvat Taidot) Plain Language Material 🇫🇮 Tervetuloa digitaloon! (KVS Foundation) Click "Siiryy taloon" -> Choose item 2 Plain Language Presentation Slides 🇫🇮 Sähköpostin perusteet, SelkoDigi-hanke (⁠SelkoDigi - opiskelumateriaalit) Plain Language Material 🇫🇮 Google-tilin luominen (⁠SelkoDigi - opiskelumateriaalit) Demonstration and exercise tips 💡 1. Creating an email address Go to Gmail or Outlook Trainer: Open a browser. Learners: Everyone goes to the browser and opens the site. Start the sign-up form Trainer: Click Create account → For myself . Learners: Fill in: First name Last name Username (close to real name, no spaces, avoid special letters; add numbers/dots if name taken). Create a password Trainer: “Password = at least 8 characters, with a mix of letters, numbers, or symbols.” Learners: Type password → Confirm password → Next. Tip: If “passwords don’t match,” retype slowly. Add details Learners: Enter birthday (month, day, year). Select gender. Add phone number (for account recovery). Optional: add another email for recovery. Agree to terms & finish Learners: Scroll down → click I agree . Trainer explains about email, it looks like username@XXX.com 2. Logging in & out Trainers: show In Inbox, click your profile (top right) → Sign out. Share about security concern: “ Always sign out on shared computers.” Learners: Practice signing out and back in twice (enter email + password, then Sign in ). Check also the mobile version: Make sure learners can access email from their mobile device as well. 3. Sending an email Start a new message Trainers: Click Compose and explain the components of writing an email. Learners: In To : type trainer’s address (written on board). In Subject : type “Test”. In message box: write short greeting (start with “Hi”, end with “Regards”). Click Send . Trainer action: Reply to each participant 4. Opening emails Trainer: Explain inbox list (bold = unread, numbers show new messages). Learners: Click trainer’s reply to open it. 5. Replying to emails Trainer: Explain how to reply to an email Learners: Open trainer's reply and type a short reply → Send . 6. Wrap-up Trainer: Go through the steps you did in this lesson to recap what we learned, such as creating an email address, logging in/out, sending, opening, and replying. Remind: Always sign out on shared devices. Encourage learners to use email regularly. You can share the training materials with learners via email. Quick Troubleshooting Username taken → add dot, number, or initial. Password not working → must be 8+ characters with mix; retype slowly. Can’t find Compose → look top-left. Email won’t send → check address spelling. Screen too small → zoom in (Ctrl/Cmd + +). Open Badge: Communication and services Discover how to use this training material together with other themes to help learners earn the Open Badge. Badges allow learners to demonstrate the skills they have gained and showcase their achievements. Learn more by clicking the button below. Read more about the Open Badge 👋🏽 Join the Community Ideas on how to create better training? Would you like to share how your training went? Join our community of digital skills trainers from the button below. Join discussions

Everyday digital services in Estonia est. 45 min 💡 After this training: The learner is able to identify the methods of strong identification. The learner will acquire the skills to use e-services. The learner knows how to protect their personal information and privacy. 👀 How to coordinate this training: Discussion Let's discuss together about electronic identification: What is electronic identification? Where have learners encountered it, and do they know how to do it? Why is it needed? Discuss together about different e-services and its use: Which of these services have you used before? What do you use them for? Is it easy to navigate the services? What kind of challenges do you have with using the e-services or mobile applications? 2. Emphasize privacy & safety These services often contain very personal information. No one is required to show their own data during class. Use practice examples, trainer’s demo accounts, or screenshots instead of real logins. Demonstrate and go through the main features Pick one service to explore as a group. A. Watch the Video First (5–10 min) Pause where needed to check understanding. B. Go Step-by-Step Together Open the service's front page or use the video to demonstrate. Show how to: Log in (e.g. Bank ID or Mobile ID) Find benefit applications Check messages Materials needed: Computer 💻 Mobile phone 📲 👋🏽 Join the Community Ideas on how to create better training? Would you like to share how your training went? Join our community of digital skills trainers from the button below. Join discussions ✨ Digital skills training about strong electronic identification and e-services E-services for citizens Eesti.ee Strong electronic identification Video language 🇬🇧 Video language 🇬🇧 Video playlist 🇬🇧 SK ID Solutions smart-ID and mobiil-ID Video language 🇪🇪 with English subtitle 🇬🇧 Video playlist 🇬🇧 SK ID Solutions Link with explanations 🇬🇧 Estonian ID card (Tallinn Migration Centre) Mobiil-ID (Tallinn Migration Centre) Smart-ID (Tallinn Migration Centre) Crisis Management - Olevalmis Video language 🇪🇪 with English subtitles 🇬🇧 Website link 🇬🇧🇪🇪 Be smart, be prepared - be ready for a crisis! - Olevalmis.ee Health Portal Video language 🇬🇧 Tax and Customs Board Video language 🇬🇧 Open Badge: Communication and services Discover how to use this training material together with other themes to help learners earn the Open Badge. Badges allow learners to demonstrate the skills they have gained and showcase their achievements. Learn more by clicking the button below. Read more about Open Badge

Open Badge Path: Using and managing applications est. 4 hour 💡 After this training: The learner will gain the skills to use a mobile device. The learner knows how to choose and use spreadsheet applications. The learner is able to make spreadsheets and use calculation formulas in calculating data. The learner is able to choose and use word processing applications. The learner is able to create text documents in accordance with the standard. The learner knows how to change the file size of an image to a smaller size and understands why it is sometimes necessary. 👀 How to coordinate this training: 1. Learn the content of the Open Badge Badges provide a means for learners to demonstrate the skills they have acquired. Upon completion of the training, learners can earn badges to showcase their digital competencies, which may be helpful when applying for jobs or advancing in their careers. These badges can also be an inspiring way to acknowledge personal growth in the digital world.Learn more about digital skills badges on the Finnish Digital Agency's website: English Finnish Swedish 2. Plan the training content Check the list of training materials connected to the open badge questions. You can organize the training sessions by using the listed content and then reviewing the open badge questions together during the session, or assign them as homework.Make sure to reserve time for a break in the training. Introduce the badge to learners and reserve time for creating a profile Allocate time for learners to create Open Badge Passport accounts and learn how to handle badges. ✨ Open Badge path on r esponsible action www.digiuptoolbox.com Converting documents into digital format | ToolBox www.digiuptoolbox.com How to use spreadsheet applications | ToolBox www.digiuptoolbox.com How to use word processing applications | ToolBox www.digiuptoolbox.com How to reduce the file size of an image | ToolBox Digital skills badge (EN) Digital skills badge (FI) Digital skills badge (SV)

👀 How to coordinate this training: 1. Explain and demonstrate or watch the video Basic functions of the application: To translate a text into another language For example, to translate a Finnish text into your native language Applications like Google Translate, Deep L, and Microsoft Translator can be downloaded to your phone from the App Store or Google Play. You can also use them with a web browser. 2. Discussion Discuss the following topics together: Have you used the application before? Do you use other applications for translations? How does translation work? Go through the features of translating via text, audio, websites and camera functions. 3. Exercise Download the app if learners do not have one. They can also use any translation application that learners would like to use. Materials needed: Computer 💻 Mobile phone 📲 Some sentences or links for demonstration Translation Apps est. 30 min 💡 After this training: The learner will know how to use automatic translation apps. ✨ Digital skills training about Google Translation Apps Google Translate Video language 🇫🇮 Video language 🇬🇧 Step-by-Step Demonstration Guide 1. Introduce the apps Describe Google Translate, DeepL, and Microsoft Translator. Show where to find and install them via App Store or Google Play. 2. Demonstrate installation Walk through downloading an app on a phone or opening a site in a browser. 3. Translate written text Choose “From: language of your choice” and “To: Your Native Language.” Paste or type a sentence. Listen to the translated version 4. Demonstrate website translation (via Google Translate) Open Google Translate Paste a website URL (e.g., https://yle.fi ) into the left box Select the target language Click the translated link on the right — it opens the full website in the chosen language 5. Translate entire webpage directly in the browser Open a webpage in a browser like Google Chrome Right-click anywhere on the page Select “Translate to [Language]” from the menu The whole page will automatically be translated You can also click the Google Translate icon in the address bar if it appears This method is very useful for quick browsing in your preferred language 6. Optional features Demonstrate speaking, handwriting, or camera input in mobile apps Try translating a restaurant menu, sign, or document using the camera 👋🏽 Join the Community Ideas on how to create better training? Would you like to share how your training went? Join our community of digital skills trainers from the button below. Join discussions

Getting familiar with computers est. 2 -3 hours 💡 After this training: The learner can identify and select the appropriate device (e.g. computer, tablet, phone). The learner can identify and name the parts of a computer. The learner can use the most common digital devices, their basic functions, and adjust settings. The learner will be able to check whether they are connected to a wireless or wired network. 👀 How to coordinate this training: You can plan a training session based on the suggested content below. You can provide training by following the list in order or selecting and choosing relevant parts. ✨ Training materials on getting started with computers www.digiuptoolbox.com Get acquainted with different devices | ToolBox www.digiuptoolbox.com Get to know the vocabulary and basic functions of a computer | ToolBox www.digiuptoolbox.com Which network are you connected to? | ToolBox

How to create a CV est. 90 - 120 mins 💡 After this training: The learner understands the purpose and basic structure of a CV. The learner can identify what makes a good CV. The learner can reflect on their own skills, experiences, and goals. The learner knows how to make a CV. 👀 How to coordinate this training: Introduction to CV You can use various methods to introduce CV. Option 1: Intro Discussion Questions Why do you think employers ask for a CV? Imagine you are an employer and you receive 100 CVs. What do you look for first? Have you ever sent a CV before? How did you feel about it? What do you think makes a CV stand out in a positive way? What mistakes do you think could harm a CV? Do you think everyone should have the same CV for every job, or should it change depending on the role? Why? Option 2: Walk through CV sections: Contact info Summary / Profile Work experience Education Skills Option 3: Show sample CVs (strong vs. weak). You can search online for examples. Group activity : Divide into small groups; each group analyzes one CV section and suggests improvements. 2. Individual Self-Reflection Exercise Ask learners to write down answers on word processor of their choice to the following questions: Questions : Who are you? What are you doing now? (at school, at work, at home?) What kind of person are you? (e.g., friendly, proactive, courageous) What can you do – what are you good at? What jobs have you done? What kind of work would you like to do? What are you like as an employee? In which areas would you like to develop? (What do you want to learn?) What does work mean to you? What goals do you have when you think about the future? Finally, what would you like to say? Demonstration How to create a CV using: Word (with templates) Google Docs (with résumé templates) Canva (for design-oriented options) Walk through replacing template text with personal information. Exercise Participants start creating their own CVs in class using their self-reflection answers. The trainer gives support and feedback while circulating. Option: In-class : learners work directly in Word/Docs/Canva. Homework : learners draft or finalize their CV and submit for feedback. Materials needed: Computer 💻 Flipchart or whiteboard 📊 Account for word-processor applications and or Canva 👋🏽 Join the Community Ideas on how to create better training? Would you like to share how your training went? Join our community of digital skills trainers from the button below. Join discussions ✨ Digital skills training about creating and writing a CV Trainer Tips: Introducing CV 1. Start with a relatable hook Ask: “Imagine you are an employer. You get 100 CVs for one job. How long do you think you look at each CV?” Explain: “This means our CV must make a quick, clear impression.” Tip : Use a short story, e.g., “I once saw a CV where the person forgot to put their phone number… guess what happened?” → This helps participants connect personally. 2. Define the CV simply A CV is not just a list of jobs → it is your personal marketing tool. The goal is to show your strengths, experience, and potential in a clear and structured way. 3. Highlight why it matters Employers often decide who to interview based only on the CV. A good CV shows: Professionalism (clear, mistake-free, well-structured) Relevance (skills and experience linked to the job ad) Personality (short profile/summary to stand out) Finland 🇫🇮 Materials Video 🇫🇮 Millainen on hyvä CV? 📝 Katso vinkit toimivan ansioluettelon tekemiseen 🙌 (Duunivinkit) Plain language material 🇫🇮 ⁠Ansioluettelo Wordilla (SelkoDigi - opiskelumateriaalit) Exercise list 🇫🇮 Kirjoitusharjoitus (Helsingin työväenopisto) Slides 🇫🇮 Opetusmateriaali (Helsingin työväenopisto) CV template on Google Docs 🇫🇮 CV pohja (Helsingin työväenopisto) Tips Website 🇫🇮 CV-pohja: Näin teet tyylikkään ansioluettelon helposti – Duunitori Website 🇫🇮 Vinkkejä työnhakuun - Työnhaku - Työmarkkinatori Website 🇬🇧 Tips for finding a job - Searching for work - Job Market Finland Website 🇫🇮 Työhakemus ja CV , 🇬🇧 Job application and CV (Info Finland), available in more languages Estonia 🇪🇪 Video language 🇪🇪with English subtitles 🇬🇧 Tips Website link 🇬🇧 : Tips for job applicants | Töötukassa Europass 🇪🇺 Video language 🇬🇧 Step-by-step: How to make a CV in Word or Google Docs 📝 1. Open the Program Word : Go to your computer and open Microsoft Word . Google Docs : Open your web browser, go to docs.google.com , and log in with your Google account. 2. Start a New Document Word : Click on New to start a new document. Google Docs : Click the Blank document (+) or choose from the Template Gallery . 3. Choose a Template Word : Look through the ready-made templates. Click on a CV template you like, then press Create . Google Docs : From the Template Gallery , select a Résumé template you like. 4. Add Your Own Information Click on the text in the template and replace it with your own details. Make sure to include: Your name Contact information (email, phone number) Work experience Education Skills 5. Add Your Photo (Optional) Word : Click Insert > Pictures and choose your photo. Google Docs : Click Insert > Image and upload your photo. 6. Save Your Work Word : Click File > Save As → choose where to save (Desktop, Documents, etc.), and give it a clear name like YourName_CV.docx . Google Docs : Google Docs saves automatically. To keep a copy on your computer, click File > Download > Microsoft Word (.docx). 7. Check and Edit Adjust the design or style so it fits your personality and the job. Use spell check: Word : Review > Spelling & Grammar . Google Docs : Tools > Spelling and grammar > Spelling and grammar check . If possible, ask a friend to review your CV and give feedback. 8. Save as PDF (Final Version) Word : Click File > Save As → Choose file type PDF . Google Docs : Click File > Download > PDF Document (.pdf) . Step-by-step: How to Make a CV in Canva 📝 1. Open Canva Go to www.canva.com in your browser. Log in (create a free account if you don’t have one). 2. Search for CV Templates In the search bar, type “CV” or “Resume” . You will see many ready-made designs. 3. Choose a Template Browse the templates and click on one you like. Press Customize this template to start editing. 4. Add Your Own Information Click on the text in the template and replace it with your details. Make sure to include: Your name Contact information (email, phone number) Work experience Education Skills 💡 Tip: You can move, delete, or resize text boxes to make the CV fit your needs. 5. Add Your Photo (Optional) Click Uploads > Upload files and choose your photo. Drag and drop the photo into the photo frame on the template. 6. Customize the Design Change colors, fonts, and layout to match your style. Keep it clear and professional (avoid too many decorations). 7. Save Your Work Canva saves automatically online. To download, click Share > Download . 8. Download as PDF Choose File type: PDF Print (best quality). Name your file clearly, e.g., YourName_CV.pdf . Save it on your computer or phone. Resources Video 🇬🇧 How to Make Resume and CV in Canva - Tutorial

Netiquette est. 60 mins Netiquette est. 60 mins 💡 After this training: The learner knows about online etiquette (netiquette). 👀 How to coordinate this training: 1. Watch the video together Discussion in a whole group, in a pair or in a small group After the video, let's discuss together: What do you think are good online manners? What things should you take into account when using the internet? What can't be published without permission? What kind of messages about another person are not allowed to be published? How should you participate in an online discussion? What should be done and what should not be done? Have you encountered bullying online? Or seen it? Materials needed: Pen & Paper 🖌️ Computer 💻 ✨ Digital skills training about netiquette Video language 🇬🇧 Material in Finnish Video 🇫🇮 Netiketti (Osuvat Taidot) Plain Language Material 🇫🇮 Nettietiketti Internetin käyttäytymissäännöt selkokielellä (Petri Ilmonen / Oppimateriaalikeskus Opike) Open Badge: Responsible action Discover how to use this training material together with other themes to help learners earn the Open Badge. Badges allow learners to demonstrate the skills they have gained and showcase their achievements. Learn more by clicking the button below. Read more about the Open Badge 👋🏽 Join the Community Ideas on how to create better training? Would you like to share how your training went? Join our community of digital skills trainers from the button below. Join discussions

How to use spreadsheet applications est. 90min 💡 After this training: The learner knows how to choose and use spreadsheet applications. The learner is able to make spreadsheets and use calculation formulas in calculating data. 👀 How to coordinate this training: 1. Demonstrate and explain Watch the video, or you can demonstrate the spreadsheet applications of your choice using the list of features, which help you plan how to explain them step-by-step. 2. Discussion questions and check everyone's answers together. Discuss the following topics together: Have you used a spreadsheet application before? What have you used it for? For what purpose can it be used? 3. Exercise Check the instructions below, or here is a short explanation. 1) Select one (1) spreadsheet application and open a new document. 2) Create a spreadsheet in accordance with the model and instructions. 3) Save the spreadsheet document on your device or cloud service. 4. Additional exercise Use a cloud service like Google Drive or OneDrive, create a folder, and move the document to it. Share the document with the trainer. Watch the video on how to use Google Drive or Beginner's Guide to OneDrive for Windows demonstrate it on your computer. Materials needed: Computer 💻 Mobile phone 📲 Account for a spreadsheet application ✨ Digital skills training about using spreadsheet applications Microsoft Excel Video language 🇬🇧 Materials in Finnish 🇫🇮 Video 🇫🇮 Excelin perusteet (Osuvat taidot) Plain language material 🇫🇮 Excel-harjoitus O365 (SelkoDigi) Google Sheets Video language 🇬🇧 Plain language material 🇫🇮 Tervetuloa digitaloon! (KVS Foundation) Basic Excel Vocabulary 📑 Term Simple Explanation Spreadsheet A file made up of rows and columns used to organize and analyze data. Workbook The entire Excel file that can contain one or more spreadsheets (worksheets). Worksheet A single page or tab within a workbook. Cell A single box where a row and column meet; where data is entered. Row A horizontal line of cells, numbered on the left side (e.g., Row 1, Row 2). Column A vertical line of cells, labeled with letters at the top (e.g., Column A, B, C). Cell Reference The name of a cell based on its column and row (e.g., A1 = column A and row 1). Range A group of selected cells (e.g., A1:A5 = cells from A1 to A5). Formula A calculation written in a cell, starting with = (e.g., =SUM(A1:A5)). Function A built-in command in Excel to do specific tasks (e.g., SUM, AVERAGE, COUNT). Vocabulary-related materials in Finnish Excel Vocabulary WordWall Game 🇫🇮 Excel - Yhdistä sanat - Tehtävä (Selko Digi) Excel Vocabulary list 🇫🇮 Excel-Suomi-Englanti -sanakirja (FutuEdu) List of features for demonstrations 📄 Basic Spreadsheet Management New spreadsheet Demonstrate how to create a new spreadsheet from the main dashboard or File menu. Save & Save As Show the difference between “Save” and “Save As” and when to use each one. Open existing spreadsheet Walk through accessing and opening a saved spreadsheet. Basic Cell Input Typing and editing in cells Show how to click a cell, enter data, and press Enter or Tab to move. Deleting content from a cell Demonstrate using Backspace/Delete to remove data. Undo/Redo changes Use the Undo and Redo buttons in the toolbar to fix mistakes. Core Formatting Tools Change text size and font Highlight a cell or range, then modify font and size from the toolbar. Apply bold, italics, underline Show how to use formatting icons for emphasis. Cell alignment (left, center, right) Demonstrate aligning text using alignment tools. Organizing Your Sheet Using simple formulas (SUM, AVERAGE) Show how to type basic formulas like =SUM(A1:A5). Sorting and filtering data Demonstrate how to sort columns alphabetically/numerically and apply filters. Creating basic tables or borders Use borders or table formats to make data more readable. Naming and Saving Files Renaming spreadsheet clearly Walk through how to rename the spreadsheet for easy identification. Saving progress often Emphasize saving frequently while working (or auto-save feature if available). Closing the spreadsheet properly Show how to safely close the file and exit the application. Instructions for the exercise Choose a spreadsheet application and open a new worksheet. Type texts and numbers to the worksheet according to the model above. Boldface texts according to the model. To the total row add borders according to the model. To the E-column calculate the total for each badge. Use formulas. To the row 9 calculate the total for january, february, march and total columns. Use formulas. Boldface numbers in both the Total row and the Total column. Save the spreadsheet to your own device or on a cloud service. Return your spreadsheet according to badge application´s instructions either as a file or as a link. Task description for using and managing spreadsheet applications (TIEKE) Open Badge: Using and managing application Discover how to use this training material together with other themes to help learners earn the Open Badge. Badges allow learners to demonstrate the skills they have gained and showcase their achievements. Learn more by clicking the button below. Read more about the Open Badge 👋🏽 Join the Community Ideas on how to create better training? Would you like to share how your training went? Join our community of digital skills trainers from the button below. Join discussions

Sending a PDF attachment by email est. 45 min 💡 After this training: The learner knows how to send a file as an email attachment. The learner is able to convert a file into PDF format. 👀 How to coordinate this training: 1. Go through various ways If needed, explain what a PDF file is and when this format can be used and is good to use. 2. Exercise Option 1: Convert a Word processing file like Microsoft Word or Google Docs to PDF and attach it to an email message. Option 2: Scan a document with the phone and turn it into a PDF. Scan documents with your phone. Let's try it together: Google Drive application , Microsoft Lens application , iPhone's Notes application .. Save the documents on your phone. 3. Exercise continues Send an email to the trainer with an attachment. Make sure the document doesn't include any sensitive or personal information. Materials needed: Mobile phone 📲 Computer 💻 👋🏽 Join the Community Ideas on how to create better training? Would you like to share how your training went? Join our community of digital skills trainers from the button below. Join discussions ✨ Digital skills training about creating and sending PDF files video language 🇬🇧 video language 🇬🇧 Link 🇫🇮 Näin skannaat kuitit ja tärkeät paperit talteen puhelimella (Yle DigiTreenit) Demonstration Tips Option 1: Convert a Word File (Word/Google Docs) to PDF & Email Demonstration Steps: Open the document in Microsoft Word or Google Docs. Show them the menu bar. Select “Save as PDF” (Word: File → Save As → PDF ; Google Docs: File → Download → PDF ). Demonstrate clicking and saving the file. Locate the saved PDF on your computer or Google Drive. Point out the .pdf file extension. Open email (e.g., Gmail, Outlook). Start a new message Click “Attach file” (paperclip icon) . Select the PDF you just saved. Send the email with the PDF attached. Trainer Tip: Send it to yourself first and show participants how it appears in your inbox. Option 2: Scan a document with a phone Preparation: Have a simple one-page document ready (e.g., flyer, form, or handwritten note). Demonstration Apps: Google Drive (Android/iPhone) Microsoft Lens (Android/iPhone) Notes app (iPhone) Demonstration Steps: Open the app (show participants where to find it on the phone). Example: In Google Drive, tap the “+” button → Scan . Point the camera at the paper and take a picture. Show how the app automatically crops and adjusts the image. Save as PDF in the app. Google Drive: Saves directly to your Drive. Microsoft Lens: Choose “PDF” and save. iPhone Notes: Tap “Save” → Share → Save to Files as PDF. Locate the PDF file on your phone. Demonstrate where it’s stored (Drive, Files app, etc.). Optional: Show how to attach it to an email or WhatsApp message. Trainer tip : Let participants practice scanning their own paper during the session. Save & share Save the document on the phone (in Files app, Drive, or OneDrive). Explain why it’s important to remember where it’s saved. Show sharing options : Email, WhatsApp, Google Drive link. Demonstrate pressing “Share” → choosing an app.

👀 How to coordinate this training: Discussion: Why storage matters Start with a group discussion: What happens when your email or cloud storage is full? How does it affect your ability to send or receive emails or upload files? Which types of files or emails usually take up the most space? Summarise: When storage is full, your account may stop receiving emails, syncing files, or backing up photos. Cleaning the space helps everything work smoothly and safely. Demonstration: How to check your storage space Show learners step by step how to see their current storage and how much free space is left. Email (examples): Gmail: Scroll to the bottom of the inbox or open Google One → Storage → View details. Outlook: Go to Settings → General → Storage. Cloud (examples): Google Drive: On the left-hand side, select Storage to see how much space is used. OneDrive: Click the gear icon → Settings → OneDrive storage . Explain: Most accounts come with a limited free storage plan (e.g., 15 GB in Google, 5 GB in Microsoft). Discussion: What and why we clean Talk together about: What can safely be deleted (old downloads, duplicate files, spam, large attachments). What should be kept (documents, receipts, work files, official messages). Why regular cleaning helps: Keeps your account working normally Makes it easier to find important files Improves device performance and data security Demonstration: How to clean safely Walk through simple cleaning steps while learners follow along: Email cleanup: Delete large or old emails (search “has:attachment” in Gmail). Empty Spam and Trash folders. Unsubscribe from newsletters you don’t read. Cloud cleanup: Sort files by size and delete the biggest ones you no longer need. Remove duplicates or outdated files. Empty the Trash or Recycle bin in your cloud storage. What to be careful with Explain what learners should not delete and why: Check before deleting shared files—others might still need them. Back up important files on a USB stick or external drive before cleaning. Empty the Trash only after you are sure everything unnecessary is gone. Materials needed: Computer 💻 or Mobile phone 📲 How to clean up cloud service and email storage est. 60 min 💡 After this training: The learner knows how to check how much storage space is available in their email and cloud accounts. The learner understands why it’s important to clean digital storage regularly. The learner can safely delete unnecessary files, emails, and attachments without losing important information. ✨ Digital skills training about managing storage Email video language 🇬🇧 Video language 🇫🇮 Cloud Video language 🇬🇧 👋🏽 Join the Community Ideas on how to create better training? Would you like to share how your training went? Join our community of digital skills trainers from the button below. Join discussions