Spreadsheet

Hello :D

The new topic is Spreadsheet. What are these ??

Spreadsheet is a program for processing number and calculations.
Every box is called a cell and cells are formed by gridelines. A cell may contain these Label- a title for a row or column, Value - number,  Formula - used for performing calculations. Cell reference is how a cell is identified

With spreadsheet I`m going to talk about Microsoft Office Excel. There is alot of options you can do
 with Excel. For example : Inserting new rows or colums, centereing headings, page set up ( paper orientantion, page margins, paper size etc ), Picking Decimal places and currency, Replicating cells, Using Formulas (example =C5*C9) , Functions (These include SUM - to add up, MIN - finding smallest value, MAX - finding largest value, Average - calculating the average value of a group of cells, COUNT - counts number of cells that contain a number) , Sorting -ascending or descending order.

This is a short video clip. I know maybe it is a bit complicated as there are more functions being used but it will give you an idea.

 

 

 

This is it for this topic ! I hope you got an idea on the uses of spreadsheet !!! :D

 

Bye bye

       Channy

Logic gates

Heyyyy !! Second time for today :)

Next topic isssssss....................... Logic gatessssss :)

What it this logic gate ??? These are small electronic decision-making hardware devices that are fed one or more inputs but give only one output.

This brings us to the truth table that is used to define the output of a logic gate or circuit for all possible combinations.

Logic gates there are 3 :

These are the 3 logic gates along with symbol and truth table

The AND gate and the OR gate can have more then 2 inputs

 

These 3 logic gates can be put together to form a logic circuit and using the truth table for each of the gate we can determinate the circuits truth table.

 

This is an example

 

 



This is it for now. If you have any questions or problems about this topic feel free to ask !! :D

 

Bye bye !! :)

Binary 3

Heyyy againn !!
So next we have c) The conversion between Binary to hexadecimal
(I know this is d on the previous post but this well help you for c )

I found this video. It is showing and explaining how you should do this type of conversion.

 

 

 

Next we have vice vesa. Where we are going to convert hexadecimal back into a binary digit.

 

Okay so I found this example, which I can explain with. Okay so what do we do first. 1) We split our hexadecimal number. For example in this case 5 and F. 2) Then we say what is 5 made of in binary sort of way. 3) Then we take F which is 15 and we do the same thing. 4) Last we put the numbers together and there you go You have your binary number :) Easy right ??

 

 

Last but not least we have the last 2 which don`t really need an explanion. These are decimal to hexadecimal and vice versa. We do these like this :

If a have a deciaml which I want it to be a hexadecimal number, I have to do these steps : I have to convert that number into a binary number and then convert it to a hexadeciaml that way. So we have to use what I explained before.

If a have a hexadecimal number this time to convert it to a decimal we have to do it like this : First you convert it to a binary number and then to a decimal number.

 

So now you even learned about conversions. Feel free to leave any questions for me to respond

 

Bye bye till next time !! :)

Chantelle

Binary 2

Long time no see....

I`m going to continue the topic we began last time before the activity.

Next we are going to talk about conversions between a) Binary to decimal
                                                                                          b) Decimal to binary
                                                                                          c) Hexadecimal to binary
                                                                                          d) Binary to hexadecimal
                                                                                          e) Decimal to hexadecimal
                                                                                          f) Hexadeciamal to decimal


A) Binary to decimal
                                                                                              

So as we see here the conversion between these 2 happen like that. The numbers were there is written decimal there are the
thing we did last time like 2 to the power of 7, 2 to the power of 6 etc..... Where there is 1 in the binary line, we add the the decimal up, where there is 0 we add the 0.

B) Decimal to Binary

This video will help you through it. It is extremely detailed and I have nothing to add to it.

 

 




This is it for now, not to make long posts so I won`t bore you. Very soon we`ll be discussing other conversions. Bye bye.....  

Activity

Heyyy !! Long time no see but I`ve been pretty busy !!!! :)



 


With the help of my teacher I found this activity that I think you guys will be interested in !!!! Check it out anf feel free to post any comments !!!!

http://www.bbc.co.uk/schools/gcsebitesize/ict/system/evaluation_act.shtml

On my computer the activity isn`t loading but hopefully on your does !!!! :( This activity is supposed to be about hardware and software. We talked about these subjects earlier.

Good luck !!! Bye bye :) 

Computer Logic !!! :D

Good morning everyone !!!! :D
Today I`m going to talk to you about..........
                                               Computer Logic

Let`s start of with something simple. Sooo the first thing of today it is the meaning of 2-state device or we can call it Bistable Device. The meaning is it is like a switch which can be only on and off.

 A clear example is a bulb. It can be only on or off so it is a Bistable Device. Illuminated or not Illuminated.

 

 

 

Computers are made up of also light switches but of course there are much more than 2. There is a wide range of devices. In computer we use transistors which has no mechanical or moving parts.

 

This can bring us to step nr 2 Binary. This is a number system which is a 2-state device.Only 1,0. A bit is a single digit from a binary number

 

 

 The number system we use everyday is called the decimal number system. Which are these 0,1,2,3,4,5,6,7,8,9

 

 

The more bits we have the more values we an represent. For example 3 bulbs can represent 000,001,010,011,100,101,110,111 and therefore 8 different values. So we can say it is 2 to the power of 3.

For 1 we say 2 to the power of 1 and so on..... An easy way is always 2 to the power of the bits we have, to find the values.

 

   That`s all for now not to make a very long post. If you want to know more wait for the next post which will be posted today or tomorrow or some days after. Feel free to post comments ;)

 

 Your friend,

         Chantelle xxx

 

Keyboard !!!

Heyyyyy Mee againn,
        Today it`s going to be about
                                    Special Purpose Keyboard

Three examples of these can be ~ Pressure Sensitve Keyboard
 

This can be expained better by this video that me and my friend Antonella found for you :

 

 

 

 

This is usually used in point-of-sale.

 

 

The next one is ~ Touch Sensitive keyboard 

 

 

Here is some information basic information : 

•  It’s a projected display, that can hook up to any Bluetooth enabled device, such as a PC, laptop, PDA etc.
• The QWERTY keyboard display is projected onto a non-reflective surface, and detects the exact location where you touch the keyboard, relaying the keystroke back to your computer.
• The keyboard is portable
• It will work in a standard-lit room, but I’m sure that it looks best with the lights turned down low. 

 



 The last one is ~ Colour-coded keyboards

 

This is short video with some pictures  in it :

 

 

 

 

 

 

 

 

 

Some other examples may be Keyboards with larger keys or keyboards for one handed or one fingered typist !!

 

 

That`s all for today hope you`ll find it interesting. If you have any questions, don`t be shy just comment me and I`ll be happy to respond !!!!!!!!!

 

Good night ,

       Chantelle