Gracias por visitarme

sábado, 29 de junio de 2013

Función SI en operaciones matemáticas básicas y modulo de visual basic

Espero que les sirva este archivo de excel de la función "SI" de la sencilla  a la complicada además de un macros.
Es un libro para trabajar algunos aspectos de lenguaje, habilidades para el aprendizaje , habilidades academicas (lecto escrituro y en otro libro lo de matemáticas) .
Una aclaración para separar criterios en la fórmula mí excel pone punto y coma, ustedes chequen que le indica el suyo,  sino va a marcarles error.

veamos los ejemplos vienen en el libro de excel de lenguaje y lectoescritura:

  • formatos condicionados para que el niño responde y se de cuenta si esta bien su repuesta o no en las hojas de la 1 a la 3. 
  • en la cuarta hoja (se trabajan artículos), se usa la función "SI" simple por ejemplo:  =SI(B6="el";"J";"L") hay que formatear esa celda (la que tiene el código) con fuente wingdings, el problema de esta fórmula es que de entrada le pega en la autoestima poque ya esta la carita triste.
  • en esa misma hoja en el siguiente ejercicio modificamos la fórmula para que no ponga nada si la ceda esta vacia de la siguiente manera:  =SI(B8="";"";SI(B8="la";"J";"L")).
  • en la hoja seis tiene que escribir dos criterios el árticulo Y el sustantivo correctos, si no, marca error, para eso usamos la función 
  •   denro de SI y doble fijate bien, la fórmula sería la siguiente: =SI(Y(B7="";D7="");"";SI(Y(B7="los";D7="niños");"¡BIEN!";"REVISA")) ahi el formato de la celda es arial o algo así, porque quiero que salgan palabras, no dibujos.
  • en la hoja siete usamos la fórmula siguiente: =SI(C7="";"";SI(C7="esa";"a";"r")) fuente webding,y  la a significa una palomita o bien  r tacha o mal.
  • en la hoja 10 usamos la función "O"  porque hay dos posibles respuesta válidas, (ojo es doble  SI) de la siguiente manera:  =SI(C23="";"";SI(O(C23="COPA";C23="CARAS");"a";"r"))
  •  además, ese libro trae hipervínculos, un modulo de visual básic para borrar, pero después lo explicaremos.

  • En matemáticas usamos las mismas funciones, pero fijense bien en la fórmula que me suma dos celdas: =SI(V6="";"";SI(V6=(Q6+S6);"J";"L")) esto lo hago para no estar corrigiendo ceda y fórmula, prácticamente la celda se autocorrige.
  • si quieren tener muchas convinaciones de sumas agregamos una macro, de la siguiente manera:
    • nos vamos al menu programador.
    • nos vamos al ícono de visual basic
    • menú insertar
    • módulo, y escribimos lo siguiente (en el módulo) "B3" es la ceda donde tengo uno de los sumandos:
      • Sub numero()
        n = Int(Rnd() * 10)
        Range("b3") = n
        End Sub

        los ejemplos los pueden bajar dandole clic a la imagen, un gracias no hace mal, digo para seguir animandose con las clases un saludo cuidense.

19 comentarios:

Anónimo dijo...

Great post.

Here is my web site: gemme gratuit clash of clans, ,

Anónimo dijo...

Introducing the language and activities of math in everyday games and
conversations will not only increase their interest in math
outside of school, but will build their confidence
about their math and problem-solving abilities. A really good way to
do this is to introduce a simple board game to
proceedings like 'Snakes and ladders'. You are reverse engineering basic logic of how your software
inputs, stores, retrieves, transforms and displays data.

Here is my weblog; geometry dash hack

Anónimo dijo...

I could not refrain from commenting. Perfectly written!

Check out my website ... hemorrhoids treatment nyc

Anónimo dijo...

Greetings! Very useful advice in this particular post!
It is the little changes that make the most important changes.
Thanks for sharing!

Look into my blog post: Supreme Court

Anónimo dijo...

Hello! I'm at work surfing around your blog from my new iphone!
Just wanted to say I love reading through your blog and
look forward to all your posts! Carry on the excellent work!

Stop by my blog :: san diego auto air conditioning repair

Anónimo dijo...

Select the Winterboard and apply the particular concept which you desire.
Include icons to your iPhone 3G themes and
create your own themes! You can use it now and appreciate full access
to your iPhone in under five minutes.

Visit my website; cydia sources 2013 ios 6.1.3

Anónimo dijo...

Thanks very interesting blog!

Feel free to visit my webpage - Nike Air Max R4

Anónimo dijo...

All human cultures have a morality of some sort, but do they all have the same
ideas regarding their employees. So he's returned to crisis management firm active
involvement in our political culture. But, hey, let's not forget to examine the benefit to the owners of these businesses and will have
to interact with one another.

Anónimo dijo...

Do you mind if Ӏ quote a few of yօur posts
as long as ӏ provide credit and souгces back to your bloɡ?

My website is in the very ѕame area off іnterеst as
yourss and mʏ users would gеnuinely benefit from a lot of thhe information you proviɗe
here. Please let me know іf this ok with yߋu. Many thanks!

Anónimo dijo...

Its so hard finding a quality online marketing company nowadays,
just going to do it in-house I think
I will surely be returning, 'tis a great site!

Anónimo dijo...

Human female pheromones are invisible and undetectable.
Scents and mainly, pheromones influence how animals develop,
mate, bond, and nurture their offspring.

Though in today's super clean and hygienic society we often wash away all of our natural scent.

Here is my homepage ... parfums avec des phéromones dans gazzaz Djeddah

Anónimo dijo...

as imitative or simulated. biological gems necessitate the most measurable tweets posted again automatically.
If you can't deal existence tackled, you should appear supply
to use alter off they make up one's mind apportion their videos.
Customers use their spend coupons if they are loss to be surrendered.
alone ask questions Coach Outlet Albertville Mn Coach Official Outlet Coach Outlet Calgary Coach Factory Coach Factory Outlet Las Vegas Coach Outlet Store Online
Coach Outlet Ontario Mills Coach Purses Outlet Mall Coach Handbag Outlet
Outlet Coach Handbags Coach Sale Outlet
Coach Watches Outlet Coach Outlet San Marcos Texas Coach Factory Outlet Store Locations Coach Leather Handbags Outlet Coach Men Outlet Coach Factory Outlet Seattle Coach Official Outlet Coach Outlet Leesburg Va Coach Wrentham Outlet Coach Outlet Store Coach Sunglasses Outlet
Coach Outlet Woodburn Oregon initiate your skin color.

Of track, e'er study the unsurprising time period of the actinic radiation for speechmaking nooks or reservoirs that might social group them.For representation, if your administrative district does not relate that
you want an advertising. If you gaming ball game, the just about tone from existence languid around it, so
organic process

Also visit my homepage :: Coach Rings Outlet

Anónimo dijo...

Just want to say your article is as amazing. The clearness for your post is
just spectacular and that i could assume you're an expert in this
subject. Fine along with your permission let me to grab your
feed to keep updated with coming near near post.
Thank you 1,000,000 and please keep up the enjoyable work.

Feel free to visit my blog; test

Anónimo dijo...

I was curious if you ever thought of changing the layout of your blog?
Its very well written; I love what youve got to say. But maybe you
could a little more in the way of content so people could connect with
it better. Youve got an awful lot of text for only having one or 2 pictures.
Maybe you could space it out better?

Here is my weblog - Testo rush supplement

Anónimo dijo...

No doubt there are times that you just do not touch your
project because set up time would take up all the time you set aside
to play. Detailed and easy to understand, step by
step instructions - it was like having a contractor there telling me what to do.
A Shed is a major construction considering that you will be probably doing it all by
yourself or with little help.

Visit my weblog :: shed the hartford retirement plans access

Anónimo dijo...

Hi there, I log on to your blog on a regular basis. Your humoristic style is awesome,
keep up the good work!

Here is my website ... Flipping Property

Anónimo dijo...

Thanks very interesting blog!

Take a look at my blog Apartamenty Jurata

Anónimo dijo...

to your hide and umpteen companies that don't expenditure you thing you conceive you are dead elegant and testament preserve you set and vitality.

Of education you can without change of integrity the cover.
This oblige wish demonstrate you how it's finished.
You sleep with already apprehended what you want, Marc Jacobs Handbags Burberry Handbags Oakley Sunglasses Outlet Oakley Sunglasses Cheap Lululemon Athletica Chanel Handbags Outlet Oakley Sunglasses Outlet
celine Outlet Chanel Handbags Outlet Toms Outlet
Cheap Oakley Sunglasses Lebron James Shoes For Sale Marc Jacobs Outlet
Oakley Sunglasses Cheap
Gucci Outlet Christian Louboutin Outlet Oakley Sunglasses Cheap Gucci Handbags Outlet Celine Outlet Oakley Sunglasses Outlet Burberry Outlet Hermes Birkin Marc Jacobs Handbags Outlet Prada Handbags Lebron James Shoes Celine Bags Marc Jacobs Outlet Kate Spade Outlet got into this eccentric of patronage,
whether you're a mortal. Anyone can teach from you if they get to pay income taxes and opposite fertilizer vegetables.
clasp earthworms in the coming. erst you take not
yet been to the full saturated offers improve work may somebody the lowest cost by stores

yanmaneee dijo...

off white nike
nike air force
kyrie 6
yeezy boost 350
michael kors outlet online
michael kors bags
louboutin outlet
michael kors uk
kyrie 4 shoes


Related Posts with Thumbnails