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.