END OF 3RD QUARTER

Fortunately, I survived another grading period... 



And thankfully, 



CHRISTMAS BREAK IS HERE!!!!! =D

ComSci - 12

2nd Long Test..... 



Result??? 



It was at least better than the first one...

ComSci1 - 11

We had different activities (group and individual). The one I enjoyed most is the activity where we were told to make a game in MS Excel. It was a little hard but it was fun. Fortunately, I managed to pass it on time ^.^

ComSci1 - 10

1st Long Test..... 



Result??? 

NEVERMIND! T.T

Charts and Graphs in MS Excel

By following these steps you can add a chart/graph in your MS Excel

Instructions

• 1
  Type "Month" in cell A1, and type the months January through June in cell A2 through A7. In cell B1, type "Applications." For each month, increase the "Applications" by 100. In cell B2, type "100," in cell B3 type "200" and so on. The last month in the "Month" column should be in cell A7 and the last figure in the "Applications" column should be in cell B7.
• 2
  Place the cursor on a cell in the "Month" and "Applications" data table. If the cursor is not on an item in the table, the chart will not know where to access the data. Press the "Insert" tab. Click the down arrow under the "Column" option in the "Charts" panel.
• 3
  Click "Bar" from the "Charts" section, and then select the first column chart option under "3-D Bar." To change the bar graph to a pie chart, right-click the graph itself and select "Change Chart Type." Click "Pie" in the "Change Chart Type" dialog box and select the first option under the "Pie" row, then press "OK."
• 4
  Click the border of the chart and drag it to the desired location. You can change the size of the chart by grabbing a border of the chart and dragging it.

Source: http://www.ehow.com/how_8306611_create-charts-graphs-excel.html

Macros in MS Excel

An Excel macro is a recording of each command and action performed to complete a task. Macros are recorded in Visual Basic, a programming language.

• Macros can be run by custom buttons on the toolbar, the menu bar, from a shape, from another macro or from a triggered event.
• • A macro can automate a complex or often repeated task; this includes the entering, editing, moving and deleting of spreadsheet data. Macros created in one workbook can be copied to another.
  • Source: http://www.ehow.com/facts_5838320_ms-excel-macro_.html

Conditional Formulas in MS Excel

Create conditional formulas

Testing whether conditions are true or false and making logical comparisons between expressions are common to many tasks. You can use the AND, OR, NOT, and IF function to create conditional formulas.

The IF function uses the following arguments.

Formula with the IF function

 logical_test: The condition that you want to check.

 value_if_true: The value to return if the condition is true.

 value_if_false: The value to return if the condition is false.

Source: http://office.microsoft.com/en-us/excel-help/create-conditional-formulas-HP005251012.aspx

Microsoft Excel

|main topic for the 3rd quarter...|

=> is a spreadsheet application developed by Microsoft for Microsoft Windows and Mac OS. It features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. It has been a very widely applied spreadsheet for these platforms, especially since version 5 in 1993, and it has replaced Lotus 1-2-3 as the industry standard for spreadsheets. Excel forms part of Microsoft Office.

Source: hen.wikipedia.org/wiki/Microsoft_Excel

Start of the Second Semester: Third Grading Period

WAAAHHHHH!!!!! START OF A NEW HEADACHE! XD

BUT...

STILL EXCITED TO LEARN NEW LESSONS ^.^