Wednesday, July 23, 2008

FOR PCO FIRST YEAR

Good afternoon class...

What you gonna do is to solve the given problem below...

A. Convert Hexadecimal to Binary Nos.

1. AAFEDF9090


2. EEBCA232


3. ABCDEF234


4. BCAEF9856


5. FFFEEDEF234



B. Convert Binary to Hexadecimal Nos.


1. 1111100001000100


2. 111100000101101


3. 1111111111111000101


4. 10101010101010


5. 10111100011100



C. Convert binary to decimal Nos.


1. 111100001


2. 1001001


3. 01001001


4. 1001111


5. 111111100


D. Convert Decimal to Binary Nos.


1. 1000000


2. 1200


3. 620


4. 3500


5. 36000



E. Addition of Octal Nos.

1. 7777234 + 1234456


2. 3456765 + 5667775


3. 67676545672 + 77777654323


4. 1234567453 + 3456765545



F. Subtraction of Octal Nos.


1. 7654676553 - 376377664



2. 100000067 - 32345677



3. 765432547-176555667


4. 657356423657-327666633777


Good Luck!!!!

------------------------------------------------------------------------------------------------

Wednesday, July 9, 2008

IT O1 Students

Hi, good afternoon , kindly answer the following questions below.

A.

1. What is a folder?
2. How will you:
a. rename a folder
b. delete a folder
c. save data in a folder
3. What are the settings that you can change if you right click the desktop and click properties?
4. How will you correctly turn on and off the computer?
5. How will you check if the hard drive can handle and save data or not?
6. What is bit?
7. Compare and contrast byte from bit?
8. What are the four major number system? Describe them?
9. What is word?
10. How many bytes in 32 bits?

B. Convert the following: (Bytes and Bits)

Item Byte Bits
1. Computer
2. Information
3. Technology
4. Programming
5. IT Pro
6. CTech
7. PCO
8. Instructions
9. System
10. Lap Top

C. Compute the following:

a. Addittion

1 0 1 0 1 0 1 1
1 0 1 1 1 1 0 0


1 1 1 0 1 0 1 1
1 1 1 1 1 1 0 0


1 1 1 0 1 1 1 1
1 0 1 1 1 1 0 1


1 1 1 1 1 1 1 1
1 1 1 1 1 1 1 1


b. Subtraction

1 0 1 0 1 0 1 1
0 0 1 1 1 1 0 0


1 0 1 0 1 0 1 0
0 0 1 1 1 1 0 1


1 1 1 0 1 1 1 1
0 0 1 1 1 1 0 1


1 0 0 0 0 0 0 0
0 0 0 1 1 1 1 1


Note: Opening your notes is highly recommended if and only if you want a Zero score.

Gud afternoon

What you do now is to:

1. Visit a web site that sells any cellphones
2. use any search engine to download inspirational quote
3. Add your visited sites at your bookmarks
4. send an e-mail message, entitled "akong_midterm", CC to your classmate, and BCC to prince_cancer1981@yahoo.com.ph. attached the downloaded quote to your message.
5. Reply any message that you have received, CC to my e-mail address.
6. Make sure to add comment to this blog.

Monday, July 7, 2008

IT 01


Computer System

"In order to make a computer work, information needs to be converted into a format that can be understood by the computer.”

Understanding a computer’s basic data units such as binary numbers, bits, bytes, words, etc. and their conversions from and to octal, decimal, and hexadecimal digits
Understanding basic concepts of computer internal data representation, focusing on numeric data, character codes etc

Some Terminology


Data representation unit and processing unit


1. Binary Digits (Bits)


Two levels of status in computer’s electronic circuits
Whether the electric current passes through it or not
Whether the voltage is high or low
1 digit of the binary system represented by "1" or "0"
Smallest unit that represents data inside the computer
1 bit can represent 2 values of data, "0" or "1"
2 bits can represent 4 different values
"00", "01", "10", "11"


Bit representation


2. Bytes
A byte is a unit that represents with 8 bits 1 character or number, 1 byte = 8 bits
E.g. "00000000", "00000010", etc.
1 bit can be represented in 2 ways, i.e. combination of 8 bit patterns into 1 byte enables the representation of 28 = 256 types of information
Using a 1-byte word, 256 different characters can be represented – sufficient for most Western character sets
However, the number of kanji (Chinese characters) amounts to thousands of different characters, hence a 1-byte word system is insufficient
Two bytes are connected to obtain 16 bits, 216 = 65,536
A 2-byte word

3. Word
The smallest unit that represents data inside a computer
Increase operation speed


4. Number systems
Binary system is used to simplify the structure of electronic circuits that make up a computer
Hexadecimal number is a numeric value represented by 16 numerals from "0" to "15" to ease the representation of binary numbers for humans – computers are capable of only using binary numbers


Numeric Systems
Also known as Base Systems or Radix Systems
Available digits:


Decimal system (base 10)
0, 1, 2, 3, 4, 5, 6, 7, 8, 9


Binary system (base 2)
0, 1


Octal system (base 8)
0, 1, 2, 3, 4, 5, 6, 7


Hexadecimal (base 16)
0, 1, 2, 3, 4, 5, 6, 7, 8, 9, A, B, C, D, E, F
where A=10,B=11,C=12,D=13,E=14,F=15


Addition and subtraction of binary numbers


Addition
0 + 0 = 0 (or 010)
0 + 1 = 1 (or 110)
1 + 0 = 1 (or 110)
1 + 1 = 10 (or 210)


Subtraction
0 – 0 = 0
0 – 1 = -1
1 – 0 = 1
1 – 1 = 0


4. Addition and subtraction of hexadecimal numbers


Addition
Performed starting at the lowest (first from the right) digit
A carry to the upper digit is performed when the result is higher than 16


Subtraction
Performed starting at the lowest (first from the right) digit
A borrow from the upper digit is performed when the result is negative

First column from right
D + 7 = (In the decimal system: 13 + 7 = 20) = 16 (carried 1) + 4
The sum of the first column is 4 and 1 is carried to the second column.
Second column from right
1 + 8 + 1 = (In the decimal system: 10) = A
Carried from the first column
Third column from right
A + B = (In the decimal system: 10 + 11 = 21) = 16 (carried 1) + 5The sum of the third column is 5 and 1 is carried to the fourth column.
The result is (15A4)16.

Hexadecimal Subtraction
First column from right
Since 3 – 4 = –1, a borrow is performed from D in the second digit (D becomes C).
16 (borrowed 1) + 3 – 4 = F (In the decimal system: 19 – 4 = 15)
Second column from right
C – 7 = 5 (In the decimal system: 12 – 7 = 5)
Third column
6 – 1 = 5
The result is (55F)16.

Saturday, July 5, 2008

Sunday PCO

Good Afternoon
Answer all the questions below and just follow the instructions.


Identify the given statements below.

1. is not very intelligent devices, but they handle instructions flawlessly and fast.
2. a series of very simple computer instructions carefully organized to complete complex tasks.
3. a computer component that user can touch.
4. used to increase user’s productivity.
5. case that contains the memory, hard disk and processor.
6. stores instructions waiting to be executed.
7. holds data, instructions and information for future use example hard disk, cd/dvd.
8. device that displays result.
9. device that accept data.
10. can be known also as users.

Test II. True or False. Write False if the statement is true otherwise write your school’s name.

1. User is anyone who uses and communicates with a computer.
2. A Floppy disk has much greater capacity than hard disk.
3. RAM stands for Random Aces Memory
4. CPU stands for Central Process Unit
5. ROM stands for Read Only Memory

Test III. Devices Identification. Complete the Table below.







































Test IV. Essay. (5pts. Each)

How computers affect the Labor force in a company?
Do you agree with this statement? “Computer Literacy is vital to success in today’s world.” Why?

3. Discuss the figure below.



















Test V: Write the corresponding year for the following events.

1. The First computer virus was spread out.
2. Time magazine named computer as machine of the year
3. e-commerce booms.
4. Microsoft introduces office 2000
5. flat panel LCD monitors overtake bulky CRT monitors.
6. introduced the abacus in china
7. DVD replace CD
8. Hewlett Packard announce the first laser jet printer

For CP and OM Sunday Only....

Good Morning.... I want you to answer the following questions without looking or opening your notes and handouts.

1. how important is the Mail Merge document?
2. Briefly discuss the steps of creating table of contents?
3. How to insert caption and Cross Reference?
4. What are the objects that can be inserted in an Office Application? how to insert them?
5. how to install the printer driver?
6. Discuss circular reference by giving example?
7. What is formula? give example of a function that can be use in a formula?
8. 3 types of chart that can plot two dimenstional table?
9. Is it possible to create documents in MSword without worrying the format? Name two ways? 10. How can you standardized the settings of an Office Application(Word, Excel and powerpoint)?

Note: This is a review, so as much as possible don't open your notes. Just try your best to answer those questions above . After you post your comment, i will let you inform your score.

Thursday, July 3, 2008

DBMS ACTIVITY

Hi, OM , it’s nice to be with you all…

Here’s your activity.

Create 2 tables, namely tableInfo and tablewage

Fields are:

TABLEINFO

Field name (data type)

Id (text)

Fname (text)

Lname (text)

Mname (text)

Position (text)

Picture (Ole Object)

Address (text)

TABLEWAGE

Field name (data type)

Id (text)

HoursWorked (number)

RateHour (number)

Basic (number)

Deduction (number)

Grosspay (number)

Out of the TableWage and TableInfo create your Query named QueryWage. The criteria for your query is : Grosspay is greater than 1000.

Lastly Create a form of your QueryWage. Save your work and e-mail a message to me and attached your database.

Good luck..