Evaluate & Average

in continuation of our activity, we are asked to fill up some cells.

to find the Equivalent grade of the scores, we used
= the score /  the number of items * 100.

to find the average of the grades, we used the formula
=AVERAGE( the cells to be averaged )
or
= ( grade 1 + grade 2 + grade 3 + grade 4 ) / the number of grades

Addition in Excel

There are many ways to do an operation in Excel.

In addition:
1) you can simply type = in the cell where you want the result to be shown or in the formula bar, then the name/address of the cells to be added (which is found on the name box)

which has + in between, then press Enter.

2) type =SUM( in the cell where you want the result to be shown or in the formula bar, then highlight the cells you want to add or just type the name of the cells, then press Enter.

3) To Auto Sum, highlight the cells you want to add, then click the Auto Sum button, then the result will be shown after the last cell, but be sure that your highlighted cells are in the same row or column.


photos from:
google.com

Then...

Then, we moved to the Sheet2 of our first Workbook (Class Record).

There, we counted the population of the Males and Females, and its Total, of our section using this formula:

which Counts the Number of Cells in a Range that are not Empty.

We counted 19 males and 11 females which is 30 in total.

After that, we made a Pie Graph and a Column Graph for it.










Next, we are asked to know the Population by Provinces

And we counted:
4 from Albay, 2 from Cam. Norte, 18 from Cam. Sur, 0 from Catanduanes, 1 from Masbate, 3 from Sorsogon, and 2 from Outside Bicol which we graphed and showed us this:

And again (4 da 2nd tym), I thank JB for helping me in this activity.

Our First Activity

In our first activity...

We are asked to make a class record of 7 Emerald. We put all our names (in alphabetical order, some used the Sort button, but some did't because they already know the alphabetical order of our surnames). After that, we did everything we are asked to do, like merging cells (using the Merge & Center button), typing the text needed, and coloring the background of selected cells (using the Fill Color button).

Since some of our classmates don't have system units on their computer, I finished this activity with the help of JB (thanks JB).

Kami sa KumSay Wan

During Kumsay period, when we are already finished in what we are doing and still have time, I, with my seatmates, usually do something with Paint. Alec and Cedric make houses and they compete who among them made a more beautiful house. I, with Ailen, do abstract arts. While Nica, who is busy making story, sometimes makes fun of us.

MS Excel

After everything about MS Word, we are here now in Spreadsheets, esp. MS Excel.

To start our activities, we are asked to explore everything about MS Excel. We are also asked to find the end of the spreadsheet (which is the cell XFD1048576). We didn't knew what to do. Some of us just scrolled down and scrolled down and scrolled down. Some just pressed the Scroll Wheel and put the cursor on the bottom part of the screen and then on the right side. Some also pressed the down arrow key and right arrow key until the end. Everyone has their own way. but the simplest way, which Sir Tom taught us, is to press ctrl + down arrow key + right arrow key. We said to ourselves, "Oh. It's so simple. Why did I do like this? Why did I inflict myself?" anyway, what important is that I found the end.

photos from:
google.com

Parts of MS Word Interface

A. Quick Access Toolbar

 - small, customizable toolbar that exposes a set of Commands that are specified by the application or selected by the User.

B. Insertion pointer (cursor)

 - indicator used to show the position on a computer monitor or other display device that will respond to input or pointing device

C. Title bar

 - it is where you can see the file name of the document you are working on

D. View Ruler

 - this button shows or hides the vertical and horizontal rulers

E. Close (quit)

 - closes the document

F. Maximize

 - allows a user to enlarge a window to its maximum size

G. Minimize

 - collapses the screen so that only the dealing boxes and rate comparison window is in view.

H. Status Bar

 - information area typically found at the bottom of windows in a GUI

I. Document Information

J. Ethereal Void

K. Blank Page To Write On

 - where you do operations, type your document, etc.

L. Scroll Bar

M. View Buttons

N. Zoom 

O. Browse Buttons

photos from:

google.com

Short Cut Keys (MS Word 2010)

Key	Behavior
CTRL+SHIFT+A	converts the selected text to capital letters or vice versa
CTRL+SHIFT+F	Displays the Font dialog box.
CTRL+SHIFT+G	Displays the Word Count dialog box.
CTRL+SHIFT+S	Displays the Apply Styles task pane.
ALT+R	Displays the Review tab
ALT+CTRL+1	Apply Heading 1, Similarly ALT + CTRL + 2 will apply heading 2
CTRL+SHIFT+L	Applies Bullets
CTRL+SHIFT+F5	Bookmark
CTRL + B	Bold Text
CTRL + I	Italic Text
CTRL + U	Underline Text
CTRL+PAGE DOWN	Browse Next
CTRL+E	Navigate to the center Paragraph
CTRL+SHIFT+ENTER	Column Break
CTRL+SHIFT+C	Copy Format
ALT+SHIFT+F7	Dictionary
ALT+CTRL+S	Splits the Document
CTRL+SHIFT+D	Double Underline
CTRL+END	End of Document
END	End of line
CTRL+SHIFT+P	Font size select
SHIFT+F5 or ALT+CTRL+Z	Go Back to previous state
CTRL+SHIFT+.	Grow Font
CTRL+]	Grow Font one point
ALT+SHIFT+R	Header Footer Link
CTRL+K	Hyperlink
CTRL+M	Indentation
CTRL+J	Justifies Paragraph
ALT+F8	Inserts Macros
ALT+SHIFT+K	Mail Merge Check
F10	Menu Mode
ALT+F7	Moves to the Next Misspelling
CTRL+H	Replace
CTRL+P	Print
CTRL+SHIFT+F12	Also launches Print
ALT+SHIFT+BACKSPACE	Redo
F12	Save As
CTRL+SHIFT+K	Small Caps
CTRL+SHIFT+S	Style
SHIFT+F7	Thesaurus
ALT+SHIFT+T	Time Field
CTRL+SHIFT+M	Unindent

SOURCE:

www.addictivetips.com

Netiquette

Share Expert Knowledge

Photos From:

ASCII

The American Standard Code for Information Interchange (ASCII, pronunciation: /ˈæski/ ASS-kee;) is a character-encoding scheme originally based on the English alphabet. ASCII codes represent text in computers, communications equipment, and other devices that use text. Most modern character-encoding schemes are based on ASCII, though they support many additional characters.
ASCII developed from telegraphic codes. Its first commercial use was as a seven-bit teleprinter code promoted by Bell data services. Work on the ASCII standard began on October 6, 1960, with the first meeting of the American Standards Association's (ASA) X3.2 subcommittee. The first edition of the standard was published during 1963, a major revision during 1967, and the most recent update during 1986. Compared to earlier telegraph codes, the proposed Bell code and ASCII were both ordered for more convenient sorting (i.e., alphabetization) of lists and added features for devices other than teleprinters.
ASCII includes definitions for 128 characters: 33 are non-printing control characters (many now obsolete) that affect how text and space is processed and 95 printable characters, including the space (which is considered an invisible graphic).
The IANA prefers the name US-ASCII to avoid ambiguity. ASCII was the most commonly used character encoding on the World Wide Web until December 2007, when it was surpassed by UTF-8.



Source:
en.wikipedia.org

CYBER CRIME PREVENTION ACT OF 2012

We cannot deny that the purpose of Sen. Edgardo Angara is essential when he summarized the Cyber crime Prevention Act of 2012. In the time when many Filipino citizens use internet and social media in trade, communication and sharing news to different parts of the world, they need to have a law that would protect their rights in using the internet. We cannot deny that in the development of the technology and  the use of the internet  there are bad people that use this to take advantage and deceit others. Social media is also used to discredit a person who is nothing against him. Canard will easily spread which can make a situation worse.

The world became small because of the technology, communication between families and friends in different parts of the world and obtaining information became easier.

But, the affiliation of using this useful technology is the security of the rights of every user. So it is right to have a law that would make sure the safety of using this technology.

There is a law passed. It is right for us to be happy because our beloved leader have thought of having this such a law. But why do people get angry instead of being happy?

It is because the law that must protect the citizen is the law that is used by the government to overcome our right/freedom of expression. "Likes" in Facebook and "tweets" in Twitter are can be used to send a person in jail. This law will give the government the right to open our private accounts and use this against us. It is right to punish all people who will use the internet in dishonoring others but  it seems like freedom of expression, especially if it is about the things that will affect the society, is forbidden in this law.

making a webpage through notepad

Our first exercise is creating a webpage through notepad but we will just copy what our teacher has made in notepad. It was not that easy but not that difficult also because you must be careful in copying. If you miss any single letter in an HTML tag, there would be something wrong with your webpage. I was very amazed about what appears in my screen when I look at my webpage.

But in our practical test, we did the total opposite of our exercise. Our teacher showed us a webpage and we will create the same webpage too. It was too hard especially when you don't memorize the HTML tags and their uses.

I wish I would pass Comp Sci this quarter....

Computer Science 1

(c)google.com

.Computer Science is a field of science that deals with the development and design of computer systems.

At first, I thought that Computer Science was a very hard subject. I always get low scores, usually lower than passing.

But because of our very inspiring teacher, Sir Tom, I was able to understand our lessons/topics and pass the subject.

Thank you Sir Tom! =)