Computer Science 1: 75% Completed

          This quarter, we've discovered another world and met a new friend- Excel. Now, we are expecting for WHOLE new amazing experiences in our last quarter.
          I'm glad to say that I already completed the 3rd Quarter of the school year as a Grade 7 student in Pisay. We've encountered a lot of things. We've faced new challenges. We've known each and every one better and gained more friends. In just a blink of an eye, it felt like Pisay isn't new to us anymore. Now that we have already adjusted in this place, the next challenge is how to maintain or improve our grades and the friendship that we built.

Computer Science 1: Tests

          Last year, we had a "written exam" about our previous lessons. I'm contented of having a score of 18 out of 25 items. I didn't have time to review because we were busy having the Press Work in The Bicol Scholar. A few questions were hard because they have formulas in them and there were no choices. Still, I survive.
          Last Tuesday, Jan. 13, we were surprised when Sir Tom announced that we will be having a practical exam at that very moment. Supposedly, the test will be on Jan. 20 but since the submission of grades become earlier, we had to take the test earlier, too. The test was just like an activity only that the time is limited. We had to finish it in 1 hour. I finished all except for no. 4 in Sheet 2. I didn't know how to do the task and since the deadline had a cut-off, I already submitted it. I could feel the "panghihinayang" since no. 4 worth 5 points. At least I made it before the cut-off!

Computer Science 1: Macros

          After all the the things that we've learned in Excel, it's time to put them all together in one workbook. But to make things easier and faster, we've met Macros. Instead of retyping over and over again, you will just click three keys and there you go, you're finish. That's what Macro is. Here are the steps on how to record a Macro by, truly yours, Kate:

1. Go to the View tab and find the Macros.
2. Click "Record Macro". Give it a name and choose one key for it. 
3. Click "Ok". Perform the task that you want to be repeated.
4. Stop recording. 
5. Use CTRL+SHIFT+(the key that you've chosen) to the cell where you want to apply the Macro.

Computer Science 1: Charts

          In Excel, there are 5 kinds of charts that were introduced to us.

• Column Chart is used to visually compare values across a few categories.
• Bar Chart has a similar use with the column chart only that the category texts are longer.
• Line Chart shows trends over time or categories.
• Area Chart shows trends over time or categories. Use it to highlight the magnitude of change over time.
• Pie Chart is used to show proportions of a whole. 

          We had an exciting activity about this. It was quite hard but very challenging. During these past few weeks, I've learned how to be careful in typing formulas and selecting cells.

Here is an example of a Column Chart showing the populations of some animals from Jan. to June. 

(c) Excel Easy

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?