Tecnogramers

En esta actividad vamos a crear un juego interactivo. Consistirá en responder correctamente 9 preguntas, de manera que con cada acierto se revelará una parte de una gran imagen. En este caso haremos un cuestionario acerca de multiplicaciones sencillas. Puedes complicarlo lo que quieras. 1. Abrimos un nuevo archivo EXCEL. 2. Insertar la imagen de fondo. 3. Diseño de página > fondo. Inserta la imagen. La imagen aparecerá repetida una y otra vez. No te preocupes, lo solucionaremos después. 4. Cambia el ancho y la altura de las columnas y filas. Necesitamos que la imagen del juego quede dividida en 4 filas y 4 columnas, todas del mismo tamaño. 5. Lo siguiente que debemos realizar es ensanchar la columna E, puesto que es el lugar donde colocaremos las instrucciones del juego.   6. Añadir bordes en el rango A1:D4. Seleccionamos las celdas del juego > botón derecho > formato de celdas > borde. 7. Añadir color de relleno. Seleccionamos la tabla entera (esquina superior izquierd...

In the activity you will create an interactive game. There will be 9 questions and if the answers are correct, it will reveal a picture underneath. The picture we will use for this activity is the shown bellow. Save it to your folder. For this activity you will be creating an interactive game, challenging the gamers to answer multiplication facts. If they type in the correct answer a tile will reveal part of a picture. If they type in the incorrect answer the part of the picture will not be revealed. Open Microsoft Excel and select New. Insert a Background Picture: With your workbook open on the Page Layout tab, in the Page Setup group, click Background to open the Sheet Background dialog box. Navigate to the folder that contains the picture you saved above. Click Insert on the Sheet Background dialog box to place the picture on the page (spanish Diseño de página>Fondo). Your picture will appear tiled, repeating itself in the background like the one shown below. Don't worry abou...

Excel is a spreadsheet application in Microsoft Office which you can use to organize and analyze data. A spreadsheet is a grid of rows and columns which can be thought of as an electronic accounting ledger. You can enter data and perform numerical calculations on the spreadsheet.     4ºESOen - TICs - Excel spreadsheet activities (I) 4ºESOen - TICs - Excel spreadsheet activities (II) 4ºESOen - TICs - Excel spreadsheet activities (III) 4ºESOen - TICs - Excel spreadsheet activities (IV) 4ºESOen - TICs - Excel spreadsheet activities (V) 4ºESOen - TICs - Excel spreadsheet activities (VI) 4ºESOen - TICs - Excel spreadsheet activities (VII) 4ºESOen - TICs - Excel spreadsheet activities - Creating an interactive game

Master Yoda is opening a new school for young Jedi knights.  He must purchase the necessary equipment for the knights, pay for rent on a location, plus feed and house the young knights while they are in training.  These would all be his expenses .  In return, the Jedi “wanna be”s will pay Master Yoda money (tuition)  Your job will be to create a spreadsheet that will help Master Yoda know how many students he can take, how much to charge them, AND make some money! Set up your spread sheet to appear as the one below. Format cells B4-B9, B11, B13, and B15 for currency. In Cell B9, input the formula to determine the total expenses for each student. In Cell B11, type the following formula to figure the total tuition income: =B13*B12. In Cell B15, type the following formula: =B11-(B9*B12).  Be sure to include the ( ). Now the fun begins! Master Yoda isn’t sure how many students to accept OR how much to charge each student for the class.  You need to play around with different amounts in Cel...

Set up the initial spreadsheet with the following labels as shown below.  After inputting the label information, widen the columns as necessary.  You can also go to Format-columns-AutoFit, which will automatically widen column A as you type in your gifts.  Bold all labels in Row 1.  Put a solid line border UNDER the contents of Row 1.  Right align columns B through F. Go on-line and select four different gifts to give as Christmas or birthday presents. Use internet catalogs or web sites.  DO NOT SPEND ALL YOUR TIME SEARCHING FOR THE GIFT!   You need a brief description of the gift and the price of ONE item. Do not worry about the Shipping Column at this point. If you didn’t use AutoFit, widen column A as necessary.  An example appears below: Click and change columns B, D, E, and F to show dollar amounts. (Click on the dollar sign in the menu bar.)  Do NOT change Column C. If you are buying one of each item, put a 1 in the amount column. But if you are buying the same gift for two or m...

You are going on a “Back to School” shopping trip with your parents in Boise, Idaho. You will also be purchasing supplies for your brother and sister.  Your mother has asked you to prepare a spreadsheet of the expenses to help in budgeting for the trip. Type the following information into the spreadsheet file. You will need to widen columns A and B and bold row 1. Formatting Changes: Click on the B at the top of column B. Drag down through cell B8.  Center the contents of this column. Click in Cell C1 and drag through D8. Right-align these cells. Although there is currently no text in cells B9 –D11, right align these cells as well. Formatting Currency. Click the letter C at the top of column C and keep the mouse clicked while dragging to column D.  This process will select the complete contents of both columns. Click the currency button from the Formatting toolbar. This will format the numbers in columns C and D so that they will be displayed with a dollar sign and two decim...

Open Excel on your computer. Click on the “Start” button in the lower left of your computer; select “Programs” and click on “Excel.” This is a spreadsheet in Excel: The columns are labeled A through Z; the rows are numbered in order. The block at which a row and column intersect is called a cell and its address is defined by the letter of the column and the number of the row. On the above spreadsheet, cell A1 is outlined, or selected. This is the cell in which numeric data and or text can be entered. Across the top of the spreadsheet is a menu bar which you will utilize when necessary. This is the menu bar: In this activity you will learn how to enter text and data onto the spreadsheet, calculate an average of a data set, and create a bar graph representing the averages you will calculate. This activity focuses on the Christmas tree sales of three tree farms from December 10th through December 24th . Set up the spreadsheet! A few basic instructions will be needed before you begin. To e...