Information Technolgy

Information Technolgy

1. excel

   • buscar V
     • =BUSCARV(valor_buscado,matríz_buscar_en,indicador_columnas(ordenado))
     • funciones
       • examina un valor en una columna y encuentra su valor correspondiente en la misma fila de otra columna
       • buscar un valor en una primera columna de una matriz
         • una vez localizado nos muestra dentro de la misma fila el valor que contiene la columna que deseamos obtener
   • condicionales
     • =SI(prueba_lógica,(valor_si_verdadero),(valor_si_falso))
     • funciones
       • aplicar de manera selectiva un formato a las celdas de acuerdo a su contenido
       • se aplicará de manera automática sobre la celda después de evaluar el cumplimiento de la regla de formato condicional
   • fltros
     • muestran ciertos datos de una lista
   • blas dinamicas
     • resumir grandes volumenes de datos

2. networks

   • Links multiple computer systems and enables them to share data and resources
     • tyes
       • WAN
         • long-distance transmission
         • Internet is the largest
       • LAN
         • limited geographic area
         • it uses
           • Uses cables
           • radio waves
           • infrared signals
       • PAN
         • personal
         • a range of 32 feet
         • wireless
       • MAN
         • designed for a city
         • Larger than a LAN, smaller than a WAN
       • CAN
         • Several LANs located in various locations
         • Use devices such as
           • switches
           • hubs
           • routers
     • definitions
       • node
         • Any device connected to a network
       • Logical address
         • each node on the network
       • Physical address
         • Unique numeric address
       • Network interface card (NIC)
         • provides a connection between the computer and the network
       • hub
         • join computers in a network
       • switch
         • connect many devices to a network with cables
       • router
         • connect networks
       • WAP
         • receives and transmit radio signals
       • server
         • device that manages network sources
       • modem
         • send and receive data
       • fiber-optic cable
         • the faster one
         • carries data
       • extensor de rango
         • extender la red
     • topologies
       • Peer-to-Peer
         • Does not require a network operating system
         • Share files without a file server
         • no more than 10 computers
       • Client/Server
         • requests to be sent to the server
         • Wired or wireless connections
         • Made up of one or more file servers and clients
       • LAN´s
         • ring
           • for 1 floor or company
           • data travels around a ring
         • star
           • office buildings
         • Bus
           • one node per time
           • for small offices or homes