lunes, 10 de octubre de 2016

technology 3rd year project 1. what´s the problem?

Vocabulary 

Download the list of vocabulary . You have to translate and study.














IN THE WORKSHOP                                   OBJECT ANALYSIS theory and exercise

 (apuntes y actividades tomadas del libro de tecnología ·3º Ed.Donostiarra)

PROJECT 1 REVIEW.  repaso de la unidad 1. download here

Test project 1 will be on 8th November 
 TEST PROYECTO 1 SERÁ EL
 MARTES 8 DE NOVIEMBRE

EXCEL 1  EXCEL 2     

PREPARING THE REPORT DOCUMENTS: Creating the budget



BUDGET
description
quantity 
unit cost
total cost
motor
1
         4,00 €
            
     4,00 €
12 connection clamp
4
0,6

rocker switch
2
0,96

double two-way switch(3positions)
3
0,8

No push switch
4
0,4

resistors,100 W, 220 ohms
2
0,2

amber LED
2
0,45

red LED
2
0,45

100 g of tin
1
5,8

 limit switch
1
1,2



total cost of project


TIPS: 
  1. adjust the cells to the lenght of the titles by double-clicking on one of the lines that separate two columns.
  2. to write down the euro symbol, select all the items and right click and select FORMATO DE CELDAS,NÚMERO tab, choose MONEDA, it will appear 0.96 € .
  3. to calculate the cost of the items: Go to cell D2 and enter the formula = B2*C2. Press intro
  4. we will use the fill handle to enter the other formulas. Click on cell D2.You will notice a small black square in the lower right corner of the cell. Click on the square (fill handle) and drag it to cell D11. Excel will copy the formula to all the cells and automatically give you the cost of all the items in the budget.
  5. in cell D13, type the formula = suma(D2:D11) press intro.

No hay comentarios:

Publicar un comentario