LibreOffice Calc - Introduction

Today we are going to start working with a free spreadsheet: LibreOffice Calc

You already know how to use it, but this year we are going to improve our knowledge about it. When you have finished all the activities, you will have learn a lot of new possibilities that LibreOffice Calc offers.

LibreOffice is a free and open source office suite, you can go to the LibreOffice site and download it for free! There you will also find a lot of tutorials.

LibreOffice Calc - Activities 1, 2 and 3

Here you have the first three Calc activities. 

Click on the link to download a PDF file with the information to do the exercise.

     - In the first page of the PDF file you will find the exercise solved.

     - In the second page of the PDF file you will find the initial data to do the exercise.

Download:

- First activity

- Second activity

- Third activity

LibreOffice Calc - Activity 4 - Random numbers

Here you have the fourth Calc activity, about random numbers. 

You will learn also how to look for elements in a list.

Download:

- Fourth activity

LibreOffice Calc - Activity 5 - Conditional formatting

Now you are going to learn how to change the format of the cells automatically, by using the conditional formatting.

Download:

- Fifth activity

LibreOffice Calc - Activities 6, 7 and 8.

Here you have the next three activities.

Download:

- Sixth activity
         In the first page of the PDF file you will find the exercise solved.

         In the second page of the PDF file you will find the initial data to do the exercise.

- Seventh activity
- Eight activity

Hardware summary

Here you have the hardware summary that you have to study.
Remember that this is not the only thing that you have to study, you have to review all the activities or questionnaires that you have done, and take a look to the vocabulary too.

Download hardware summary

Descargar resumen de hardware

Computer Hardware in plain English

First Hardware Activity

 
Download the file Hardware pictures here.


You'll have to learn all the file's words and the spanish translations. You'll have to search for the best translation for them.

You have to create a new spreadsheet in Google Drive to save the words and the translations.


When you find a link to Youtube videos, you have to follow these instructions:

1. First, watch the videos.
2. Under the video link you'll find some words that are said on the video.
3. For each word: Write down the time (min:sec) when that word or expression it is said. Write also the more appropriate translation in spanish. 
 
    --> For instance:
    Video 1: Motherboard installation:
    Carefully (1:17): Con cuidado, etc.

These words will be also added to your vocabulary list.

You can also visit:

http://www.youtube.com/watch?v=qKb1tFkJBsU

http://www.youtube.com/watch?v=4eNTlwnnhss&feature=related

http://www.pecktechdesigns.com/Introduction/IntroductionToPeripheralsAndConnections.asp

 

Second hardware activity - Questions

Answer to the following questions related to the power supply and the motherboard. You can search on Internet to look for the answers.

Third Hardware Activity - Summary

Follow these steps:

- Create a new text file with the OpenOffice Writer
- Write in 2 or 3 lines, the function of the following hardware elements.
- Save it as "Third Hardware Activity"
- Upload it to your Google Drive account

The hardware elements are:

1. RAM

2. Power supply

3. Microprocessor

4. Chipset

5. Expansion cards (at least 3)

6. Motherboard

7. BIOS memory

8. CMOS RAM

9. Ports (the most used)

10. Hard disk drive

11. Solid State Drives (SSD): advantages and comparison to HDD

12. Input peripherals (make a list)

13. Output peripherals (make a list)

14. Input/Output peripherals

15. Optical memories (capacity comparison)

Fourth hardware activity - Questions

Fifth hardware activity - Questions