Such a Random Quarter

Aw man, another segment of the school year has just passed.

Why does time have to fly so FAST??!!

Well I have been taught a lot this quarter, there have been stuff that I thought I knew but didn't.

And I can therefore say that this was an EXCELlent quarter 

hehehe. I had a load of fun and I guess my performance was pretty good.

PLUS I got the chance to ask Sir Tom two Random Questions a day.

See how much fun that is? haha

Then i guess this is goodbye fellas, 'til the next chapter of my Journey!

Oh and NEVER FORGET

2nd and Final Test

This time our Long Test was a Practical.

It was easy for me because it was just about charts and macros.

So let's take a look at what I did,

Charts portion

Well since the macros portion was just a set of commands, it's a blank page, awwwww

Macros

This is our final topic for the quarter...

I know.... oh well

At first all of us had no idea what macros was, I honestly thought it was really complicated but fortunately it wasn't

Macros is used to create your own shortcuts in for something that you often do in excel. Instead of doing your 'ritual' all over again, with macros you'll just press a few keys and your work is done.

First Long Test

I actually had some difficulty in answering the test, 

but luckily I passed. 

Let's say the passing score is 15/25 

I got 17/25.

A Close call right?

#soclose #rollerblading #fail #lol

Quizzes? Oh Man...

Hold on there, there's nothing to worry.

I passed all of them!

And we had a total of only 2 quizzes this first half of the second semester. I got 8/10 on the first then 7/10 on the second.

Lab Exercises and Activities

Well I guess Computer Science isn't fun if there aren't practical exams or hands-on activities.

Sooo we had a lot of them this Quarter.

Hell yeah! right? Well here are Sneak peeks of my outputs...

 

Data Representation

First thing that comes to mind? 

CHARTS!

Well this was actually maybe the easiest topic but it was fun at the same time.

here's a link for you to learn more:

Excel 2010 : Charts Getting Started

Conditional Formatting

It is applying unique cell formatting based on a certain condition.

Our 2nd lab exercise

By applying conditional formatting to your data, you can quickly identify variances in a range of values with a quick glance.

Cell Reference

A cell reference refers to a cell or a range of cells on a worksheet and can be used in a formula so that Microsoft Office Excel can find the values or data that you want that formula to calculate.

In one or several formulas, you can use a cell reference to refer to:

• Data from one cell on the worksheet.
• Data that is contained in different areas of a worksheet.
• Data in cells on other worksheets in the same workbook.

For example:

This Formula:                      Refers to:

=C2                                            Cell C2

=Asset-Liability                          The cells named Asset
                                            and Liability

{=Week1+Week2}                            The cell ranges named
                                            Week1 and Week2

=Sheet2!B2                                Cell B2 on Sheet2

Source: http://office.microsoft.com

AND, OR, NOT

So the Logical Operators...

If you would want to learn AND master them, OR maybe it's just a requirement for you to learn them, 

check out this awesome link :

Logical Operations and Functions

WHAT??? You say i'm forgetting something?

Let's see.....oh now I remember, AND is NOT pronounced as the conjunction, it's said as somewhat like 'und'

IF

IF Function

Returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE

You will know more about this topic IF you check out this video:

hahahaha GOT IT???

Functions

Functions are predefined formulas.

Examples of this are:

1. PRODUCT function - used to find the product (multiplication)
2. AVERAGE function - find the average
3. COUNTA function - count the cells which aren't empty  as well as the number of arguments that contain values.

E R R O R !

Functions do not always work out perfectly...

These errors will show up if you do something wrong:

1. #N/A - data not found
2. #DIV/0! - occurs when a formula tries to divide by zero
3. #NULL! - occurs when the two or more cell references are not separated correctly in a formula
4. #REF! - An invalid cell reference error message occurs when a spreadsheet formula contains incorrect cell references
5. #NAME! -  error occurs when Excel does not recognize text in a formula
6. #### - column isn't wide enough to display the value
7. #NUM! -  pass an invalid argument to a function 
8. #VALUE! - a formula has the wrong type of argument

Formulas

FORMULAS?

A Misunderstanding folks!

Not THAT kind of formula, remember we are talking about Excel here?

The formula i'm saying is used to perform calculations in Excel.

Note: It always starts off with an equal (=) sign

Example:

=4*5 (will result to 20)

=B1+B2 (will result to sum of the values in selected cells)

Note: (+) for addition
(-) for subtraction

(*) for multiplication

(/) for division

A funny thing when we were discussing this topic is that there's this Operator in excel that we couldn't figure out how it's pronounced or even spelled...
the AMPERSAND (&)

Data Analysis

 You can enter almost any value in a cell in Excel.

Now the stuff you enter is classified as DATA.

And of course there are these things called DATA TYPES---standardized representations for particular types of data.

There are various Data Types you can put into a workbook:

  

Currency

 

Date and Time

                                                 

Boolean Logic

Numbers and Text

Set It Off

Okay, so since we are mainly going to talk about MS Excel

we had to know what an Excel file is or what its composed of.
An Excel file is called a WORKBOOK. A WORKSHEET is the page you work on which is basically made up of cells.

Aside from that based from what I remember,we first discussed on its parts:


Then  some shortcut keys:

Alt + Enter = Start a new line in the same cell
Ctrl + ; = Insert current date
Ctrl + Enter = Fill selected cell range with current entry


It was just a simple and easy start for the 3rd Quarter...

Next Chapter...

NOOO....not that kind of next chapter, I meant the next chapter to my Computer science journey. And why you ask?

It's the beginning of another Quarter!

Yep, and we are already tackling about MS Excel. All of the topics will be related to Excel :

• Logical Operation
• Data Analysis
• Solver 
• Macros
• Cell Reference 
• IF
• Conditional Formatting 

But I can say the fun doesn't end there, of course more experiences will be coming and more jokes will be discovered...