One More Quarter To Go!

It is almost time to say goodbye.. but no, there is still another quarter. :) I had so many memorable experiences and time-worthy lessons from classes in Computer Science this quarter. I also had so much fun in blog-typing! 

The best is yet to come and I do really hope that the last will be a special one. =)

Until next time! ;)

We are RECORDING ARTISTS

Not literally like those... super professional, high-pitched people with great voices. What I mean is, recording MACROS. Yes, you are right, macros. We are recording artists because we record macros. Get it? Haha. That wasn't funny actually. :/ P.S. I wasn't joking either.

Moving on, macros is the thing that repeats every move you make from the time that you start recording until the time that you stop it. We are using a code for every macros that we record (e.g. Ctrl+Shift+P). 

Seriously, it is so cool! We get a chance to repeat a series of movements using short codes.

#FerdinandMACROS
^ (c) Sir Tom Secundo

Charts

We all know that charts give us comparisons between different elements, or help us visualize it's differences. With the use of MS Excel, we can do those things with simpe steps.

My experience with charts is that not at all times, you think that you selected the correct cells needed for the chart. sometimes, we need to use another table or deselect other rows or columns. The format of the charts should also be great. The ideas and elements shall be presentable, and the chart should easily be interpreted. 

Here's a video on how to :)))

what IF?

IF returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE.

My experience with IF is that we should always have the correct comparison methods and correct conditions. If not so, results may have a different outcome. So, always be careful :D

Conditional Formatting

 Conditional Formatting is to apply unique cell formatting  based on a certain condition.

Highlight Rules
 • Top/Bottom Rules 
 • Data Bars 
 • Color Scales 
 • Icon Sets 
 • Add your new rule! 

Adding New Rule   - add a formula that contains a condition and add new formatting. Ex: =A1=“PASSED”  this formula will result to TRUE or FALSE If that formula is true, the format to be set will be applied to the cell 

On a personal note, conditional formatting can help us in making our works easier since it is the one who arranges the identification based on the formula that we gave to it. 

This is an example of a grading sheet using CONDITIONAL FORMATTING and NESTED IF

Video tutorial about formulas

Dealing with the formulas is kind of tricky because you should always have the correct sequence of numbers and symbols. But if you get it already, it is a lot easier. Practice never fails us to be closer to perfect. :)

AND OR NOT?!

There are three logical operations. They are AND, OR, and NOT. They justify the difference true and false in different ways according to what they are made to do.

AND: When one is true and the other is also true, the result is true. When one is false and the other is true, it is still false and when both are false, it is false.

OR: When one is true and the other is also true, the result is true. When one is false and the other is true, it is still true and when both are false, it is false.

NOT: the opposite of true is false and the opposite of false is true.

Formulas

We always have thought that computer science are basically applications of computers… and science only, right? But we were wrong. We can also actually find my SARCASTICALLY favorite subject, Mathematics. Hooray! -_-

Formula

 –an expression used to perform calculations

– begin with an equal (=) sign

– Composed of operands and operators

– May contain constants, cell references, ranges, and grouping symbols.

For example,

=150*.5

=A1+A2

Mr. and MS EXCEL

Now, before I teach you anything else, I will introduce to all of you the basics. ;)

• An Excel file is called a workbook. 

• Worksheet is the page you work on which is made up of grid cells.

• Cell/Selected Cell is where you type data/formulae into. Cells are arranged in numbered rows and lettered columns. You have to select a cell to add data to it data/formulae can also be typed into the formula bar. 

• Column/Row Heading: Use the column/row headings to identify a cells position on the worksheet i.e. A12, B6. Click heading buttons to select a whole column/row of cells 

•  Name Box: Holds a cell’s selected reference number – it’s position on the worksheet.

                                 To understand more, just look at the photo below :3

parts of excel

The Start of the Third Quarter

I finally got this chance to share with you all of the knowledge and ideas that I learned from our one of a kind teacher, Sir Tom. =)

So, yes. Basically, this quarter was all about Microsoft Excel. During my past years, I had nothing much of an experience with Excel. That is why it seems like I only knew the basic tasks on that software. I never actually had any idea with macros… and other quite complicated stuff in there. With the great amount of knowledge (maybe xD) that we got from our coolest teacher, I think that I can share some with all of you. You know, maybe as a late Christmas gift? or... an early Valentine's gift? :)