Computer Science 1: Quadratic Formula

          Our next lesson was about Solver. This time, we solve for the area, volume and hypotenuse of some particular shapes. The activity was really difficult especially the one with the quadratic formula. I had a hard time doing that. Luckily, I was able to do it with the help of some tutorials. I passed another challenge. Cheers to that!

Computer Science 1: Conditional Formatting

          Conditional Formatting enables you to highlight cells with a certain color or put icons, depending on the cell's value.

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

  

  An example using Conditional Formatting and the NESTED IF.

  
  

  
  

  
  

  
  

  
  

  
  

  
  

  
  

  Honestly, having that kind of activity above takes a lot of patience. You must also be very careful on typing so you would avoid mistakes and errors.

Computer Science 1: IF

          The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE. For example, the formula =IF(A1>10,"Over 10","10 or less") returns "Over 10" if A1 is greater than 10, and "10 or less" if A1 is less than or equal to 10.

Computer Science 1: Wait... A.N.O.?!

In Excel, you can use one of the three logical operations to construct formulas:

• AND works by performing multiple comparison tests that results to TRUE if all the tests are true, and FALSE if one or more of the tests are false.
• NOT is kind of confusing. But just remember that if the test is true, it means not true so it is FALSE. When the test is false, it means not false so it will be TRUE. (What?!)
• OR works in a very similar function with And. However, the Or function will return TRUE even if only one of the tests returns true.

works by performing multiple comparison tests and then returning TRUE if all of the tests were true, and FALSE if one or more of the tests were false - See more at: http://fiveminutelessons.com/learn-microsoft-excel/using-logical-operators-and-functions-excel#sthash.XxdKupMO.dpuf

works by performing multiple comparison tests and then returning TRUE if all of the tests were true, and FALSE if one or more of the tests were false - See more at: http://fiveminutelessons.com/learn-microsoft-excel/using-logical-operators-and-functions-excel#sthash.XxdKupMO.dpuf

works by performing multiple comparison tests and then returning TRUE if all of the tests were true, and FALSE if one or more of the tests were false - See more at: http://fiveminutelessons.com/learn-microsoft-excel/using-logical-operators-and-functions-excel#sthash.XxdKup

Computer Science 1: ExCELLS

          Our next lesson was about cell reference.We were taught some tips and techniques like how to use AutoFill, Paste Special and Ctrl +`. There are also three types of reference type. The first one is Relative which adjusts and changes when copied or when using AutoFill. In Absolute, dollar signs ($) are used to hold a row and/or column reference constant. The last one is mixed which is a combination of the relative and absolute type. After the discussion, we were challenged to make a multiplication table in Excel using the reference types as shortcut. It was quite difficult. Well, Sir Tom have never given us easy challenges!

Computer Science 1: Let's Talk About Math

          Say hello to ComSci and Math's children namely Function and Formula. Well, no surprise if Science and Math interact.

An example using the formula.

     
Let me introduce Formula. It is an expression which calculates the value of a cell. It always start with an equal sign. Some of the operators used are + (addition), - (subtraction), * (multiplication) and / (division).
     

An example using Function.

While Fuction is better known for being a predefined formula. But be careful when using this because one wrong type will lead to an error- the one with the #.

Examples of Error

 P.S. Don't be mistaken by the errors. They're not hashtags! ^_^v

Computer Science 1: Getting to Know...

          This quarter, we focused on Microsoft Excel. We had an introduction about this application and learned the basics. Sir Tom taught us its functions, its parts and some shortcuts to make tasks easier. For me, Excel is like a person you know but you never had a chance to talk to. You're not even friends, just plain acquaintances. Learning Excel is like simply knowing that person:))

          Yeah, we had Excel in 6th grade but we only tackled about its parts. Nothing more. This time, we've got a deeper meaning of it, a clear understanding of that person.
           After having an intro and knowing the basics, well, it's time to see if we have already learned. We had an activity and a quiz. Submitting the activity 42 minutes and 16 seconds earlier and getting a score of 8 out of 10 items aren't bad, are they?