Clilstore Facebook WA Linkedin Email
Login

This is a Clilstore unit. You can link all words to dictionaries.

UNIT 4 CALC. ACTIVITY 2

 

CALC PRACTICA 2

LIBRE OFFICE CALC

ACTIVITY 2




IMPORTANT WARNING: THIS ACTIVITIES ONLY WILL BE ASSESSED IF THEY ARE CARRIED OUT IN YOUR PERSONAL TEMPLATE. DOWNLOAD YOUR TEMPLATE FROM MOODLE AND DON'T ALTER THE SHEETS hoja1, hoja2, hoja3 OR ANY OTHER IDENTIFICATION MARK IN YOUR TEMPLATE.



ACTIVITAT 2.1. ABSOLUTE AND RELATIVE REFERENCES TO CELL

Start LO Calc. Open your personal template and select the sheet 2.1 Planetes

We are going to study the differences between relative and absolute references. A reference to cell is a formula written in a cell which uses as operands the values contained in other cells. In the image below inserting the formula =J4 in L7 the contents of J4 will be copied to L7






In addition, we can use the cell extensor to propagate the contents of a cell to others. In the following image, the cell extensors is the black square in the down right corner of the cell, highlighted at the beginning of the red arrowand. Dragging it to the right of L4, its contents are propagated to the nearby right cells.





Notice that the propagated contents are not the formula =J4. You might expect to get the word 'Mercury' propagated to the nearby cells, but as you can see in the following image, that's not what happens.

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 2.1.1



To figure out better what's happening, we need to see the formula in the cells instead of their value. Select the menu Ferramentes | opcions | vista and then click in the box visualitza les fórmules




This action makes the cells show the formula instead of the values they represent. Notice that the action of dragging the cell extensors doesn't propagate J4 to the nearby cells. Instead the column number is increased in 1 in each cell where it is propagated resulting in the values J, K, L, M…..while the number of row (4) remains unchanged




The cell extensor can be dragged to up and down, producing a similar but different result:






 

 

There are three different types of references : relatives, absolutes and mixeds.



 

 

extending one cell to it's nearby cells means to write on it the formula referencing the cell at the same distanceFor example. In Q9, =O9 states a distance is (-2 col.,0 row.). extending it to Q10, we get the formula =O10, that is Q- 2. 10+0. .

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 2.1.2

 










Make 4 copies of the table solar systema, in different parts of the sheet 2,1 planetas, using the four type of references

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 2.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. Don't upload it to Moodle until you end the last activity

 

ACTIVITY 2.2. LEASING



In this activity we are going to make the amortization table of a vehicle purchased using a leasing. Use the sheet 2.2 Leasing








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 2.2.1

 

   

 

 

  • Tassa: interest rate

  • Nper: Loan duration in number of years

  • Va: Capital pending of payment

  • Vf: Final value(Optional)

  • tipo: Type of formula used to perform the calculation. In this case just write 1






IN CALC BY DEFAULT ALL REFERENCES ARE RELATIVE UNLESS WE USE THE ABSOLUTE REFERENCE MARKER $



A$1

Relative Reference to column. The column changes if extended horizontally
Absolute Reference to row: We stick to row 1 when the cell is extended





$A$1
Absolute Reference to Column: we stick to the column A when the cell is extended
Relative Reference to row. We stick to row 1 when the cell is extended




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 2.2.2

 



 

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 2.2.3

 

The accumulated capital (columna F) is the sum of amortized capital in each monthly payment. In F9 insert =F8+B9 and extend to F23

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 2.2.4



 

 

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

ACTIVITY 2.3. VIABILITY STUDY OF AN INVESTMENT

For this activiy use the sheet 2.3 estudio de viabilidad



A company is studying to purchase a robot to improve the production. The company can choose an alternative investments which my produce an estimated return of 9%. A financial analyst must study if the investment in arobot will be profitable in a period of 10 years. The company will decide to purchase the robot if it is more profitable than the other investment. After analyzing all available information the financial analyst comes to the following conclusions



 

Depreciation= Purchase price*0,10

 

Save the document. Save a version and call it 2.3.1

Sum of costs = Maintenance costs + Depreciation

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 2.3.2

 

Save your template and make a backup copy. Don't upload it to Moodle until you end the last activity




 



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

Clilstore

Short url:   https://clilstore.eu/cs/6292