This is a Clilstore unit. You can .

CALC PRACTICA 1

ACTIVITY 1

ACTIVITY 1.1 TWO NUMBERS BASIC ARITHMETICAL OPERATIONS WITHOUT RESULT CHECKING

The goal of the activity is to make a sheet where a person can work out the result of several two integer operations.

1. Start L.O. Calc. Open your personal template. You must carry out the activity in the sheet 1,1 SUMAS

2. Select the area C4:G4 writing C4:G4 in the names box (marked in the following image), and press the key Enter

3. Click in the menu Format | Fila | Alçada. A new window will pop up allowing you to define the row height in mm. Set 10mm or 1cm.
4. Align to the center the range of cells C4:G4. Use the align to the center button shown below. In addtition set the following settings

• Font size: 14

• Font type: DejaVu Sans,

5. Write in C4 a number between 0 and 9. To write in a cell you must select the cell and write the number. You can also use the input line in the formula tool bar, and click in the accept button

6. Write in D4 the character '+ '.
7. Write in E4 a number between 0 and 9.
8. Write in F4 the character '=' .
9. Write in G4 one of these two formulas (both are equivalent) =SUMA(C4;E4) or =C4+E4.
10. Change the background color in G4 to gray 20% (select Format | Cel·la | pestaña fons)

Save the document using the save button or Archivo | guardar. Never use Save as (archivo |  guardar como ) otherwise the versions will be lost.

Save a version and call it 1.1.1

11. Protect G4 (select  Format | Cel·la | pestaña Protecció de cel·la). It is advisable to protect the cells containing formulas to prevent the user to delete or modify them accidentally. We are going to disable edition in all the cells except those where the users will input data: C4 and E4

1. To select both C4 and E4, click in C4, then press the key Ctrl and click in E4.

2. Select Format | Cel·les (the Atributs de la cel·la, a window will pop up)

3. Select the tab Protecció de cel·les and uncheck the check box Protegit, (by default It is checked). Click in the button D'acord

4. Select Ferramentes | Protegeix el document | Full. In the window Protegeix el full, to protect the sheet click in D'acord. It is possible to block the protection with a password but we are not using this option. Setting the Protegeix el full, will disable the edition of all cells in a sheet, where the protegit checkbox is marked. Remember that we have just unchecked this box in C4, E4 in the previous step.

12. Check out if the activity works fine. You must be able to modify the cells C4 and E4 and the result of adding this two numbers must appear in G4
13.
We are going to repeat the procedure for the substraction of two numbers. Disable the sheet protection, disable the checkbox protegido for C5 and G5, write the formula =C5-E5 in G5, Protect the sheet again

Save the document using the save button or Archivo | guardar. Never use Save as (archivo |  guardar como ) otherwise the previous versions in your document will be lost. Save a version and call it 1.1.2

14. Repeat the procedure with multiplication (operator *) and division (opeator /).

15.Repeat in the row 8 the procedure with the mod function, which calculates the remainder in a integer division. The format of this function is MOD(Divdend;Divisor). For example =MOD(C8;E8). If your Libre Office is set to Spanish this function has the name RESIDUO(Divdendo;Divisor)
16.Repeat in the row 9 the procedure with the function POTENCIA, which calculates the result of elevating a base number to an exponent. This function format is POTENCIA(Base;Exponent). In the case of G9 the formula must be =POTENCIA(C9;E9)
17. Protect again the document. Edition in all cells except C4:C9 and E4:E9 must be disabled

Finally, we must hide the border lines of the cells grid using the menu option Eines | Opcions | OpenOffice.org calc | Visualitza, and unchecking the box Línies de la graella in the panel Línies.

Save the document using the save button or Archivo | guardar. Never use Save as (archivo |  guardar como ) otherwise the previous versions in your document will be lost. Save a version and call it 1.1.3

MAKE A BACKUP COPY OF YOUR ACTIVITIES FILE. Open the file browser Nautilus using LLocs | inici. Open your calc activities folder. Select your Calc activities file and copy it (ctrl+c) and paste it (ctrl+v) in the same folder. This will create a perfect safety copy of your activities file, keeping in it the versions. Carry on working with the original file.

ACTIVITY 1.2. TWO NUMBERS BASIC ARITHMETICAL OPERATIONS WITH RESULT CHECKING. IF Function

This activity is similar to the activity 1.1. The user now must write the result of the operation in the column G. In the column I an If function will be used to assess if the user's answer is correct

1.  Duplicate the sheet 1.1 and call it 1.2

• Select the sheet 1.1

• Put the cursor on the sheet tab and open the contextual menu. Select the option mover/copiar hoja

• Select copy

• Select before sheet 1.3

• Name it 1.2

• Disable sheet protection using herramientas | proteger documento | hoja

• Delete the contents of the cells G4:G9

2. In I4 write : =SI (G4=SUMA(C4;E4);"BÉ";"NO")

3. Format I4:

• Background color: whatever color you like, but must be a light color. Use . In the format toolbar

• Use the button to give a color to the text (whatever color, but dark enough to be readable)

• Font size: 14

• Font type: DejaVu sans

• Alignment of text to the center

4. Align the text in the cells vertically. Select the range C4:I4. Click in the menu Format | Cel·les, Select the tab Alineació. Set center for both horizontal and vertical

5. Now the cells that must be unprotected are G4:G9 ( select them and click in Format | cel·la | solapa protecció cel·la) and uncheck the box protegit)

The formula in I4 means that if the result of adding C4 and E4 equals the contents of the cell G4 it will write “bé” in the cell I4. Otherwise it will write “no”

Notice that the three parameters are encompassed between brackets and are separated by semicolons

6. Check if the activity works properly. Insert numbers in the column C4 and E4. Write the expected result in G4 and check if I4 show 'bé', or 'no' depending on the correct assessment of the operation

Save the document using the save button or Archivo | guardar. Never use Save as (archivo |  guardar como ) otherwise the previous versions in your document will be lost. Save a version and call it 1.2.1

7. Complete the activity inserting in I5:I9 the function 'SI' needed to assess the rest of operations

Save the document using the save button or Archivo | guardar. Never use Save as (archivo |  guardar como ) otherwise the previous versions in your document will be lost.Save a version and call it 1.2.2

MAKE A BACKUP COPY OF YOUR ACTIVITIES FILE. Open the file browser Nautilus using LLocs | inici. Open your calc activities folder. Select your Calc activities file and copy it (ctrl+c) and paste it (ctrl+v) in the same folder. This will create a perfect safety copy of your activities file, keeping in it the versions. Carry on working with the original file.

ACTIVITY1.3

In this activity we are going to use the function SI in order to make optional the operator to apply. The user will write the two integer numbers in C and E, and the operator to apply in D. The function SI will calculate the result in G depending on the operator inserted

1. Activate the sheet 1.3

2. Replicate the sheet shown in the image below. The goal is to allow the user to choose between the operators '+' and '-' . If in D4 the user writes '+' a function SI will write C4 + E4 in G4. If he writes '-', in G4 the function will write C4 – E4 in G4.

Save the document using the save button or Archivo | guardar. Never use Save as (archivo |  guardar como ) otherwise the previous versions in your document will be lost. Save a version and call it 1.3.1

Repeat the procedure in the row 7 for multiplication and division

Save the document using the save button or Archivo | guardar. Never use Save as (archivo |  guardar como ) otherwise the previous versions in your document will be lost.Save a version and call it 1.3.2

MAKE A BACKUP COPY OF YOUR ACTIVITIES FILE. Open the file browser Nautilus using LLocs | inici. Open your calc activities folder. Select your Calc activities file and copy it (ctrl+c) and paste it (ctrl+v) in the same folder. This will create a perfect safety copy of your activities file, keeping in it the versions. Carry on working with the original file.

ACTIVITY1.4 NESTED FUNCTIONS

In this activity we are going to improve the results of the activity 3, allowing the user to choose one operation among several: +, -, x, /, Mod, ^

• Activate the sheet 1.4 and replicate in the sheet the elements seen in the image below

The function SI allows to carry out only two actions, one if the condition is true and other if it is false. But it is possible to nest several SI functions in order to provide more options. Look at the formula in the image

• =SI(CONDITION=1, ACTION1,SI(CONDITION=2; ACTION2; ACTION3 ))

• If the condition=1, then the operation executed is ACTION1. If not, what is executed is a second function Si, in which there will be two new options CONDITION= 2, or condition = anything else. In this simple way we've got three different condional actions. To get more conditional actions, just add more nested SI functions.

The meaning of this formula is :

• IF D4 is '+' then G4=C4+E4,

• IF D4 is not + then:

•  If D4 is '-' then G4=C4+E4,

•  if D4 is not '-'

• if D4 is 'x' then G4=C4*E4,

• if D4 is not 'x' then D4=0

The formula shown above allows to choose between three operators (+.-*). Increase the number of nested functions SI, so that the user can choose among the rest of operations. You must add:

• / for division

• % for the remainder of division(funció MOD),

• ^ for power.

• Finally if the user enters any other operator the last SI function must show the text 'operació no vàlida' en la cel·la.

Save the document using the save button or Archivo | guardar. Never use Save as (archivo |  guardar como ) otherwise the previous versions in your document will be lost.Save a version and call it 1.4.1

MAKE A BACKUP COPY OF YOUR ACTIVITIES FILE. Open the file browser Nautilus using LLocs | inici. Open your calc activities folder. Select your Calc activities file and copy it (ctrl+c) and paste it (ctrl+v) in the same folder. This will create a perfect safety copy of your activities file, keeping in it the versions. Carry on working with the original file.

Don't upload it to Moodle until you end the last activity

Short url:   http://multidict.net/cs/6275