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:
- adjust the cells to the lenght of the titles by double-clicking on one of the lines that separate two columns.
- 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 € .
- to calculate the cost of the items: Go to cell D2 and enter the formula = B2*C2. Press intro
- 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.
- in cell D13, type the formula = suma(D2:D11) press intro.
No hay comentarios:
Publicar un comentario