12.20.2013

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...

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 ^.^

10.13.2013

ComSci1 - 9

CSS

Sir Tom also taught us about CSS.

ComSci1 - 8

HTML

Sir Tom gave multiple activities about HTML. I managed to finish all of it on time.

ComSci1 - 7

Protocol

Sir Tom taught us all about Protocols. Here is some of the things he taught us.

In information technology, a protocol is the special set of rules that end points in a telecommunication connection use when they communicate. Protocols specify interactions between the communicating entities.

Protocols exist at several levels in a telecommunication connection. For example, there are protocols for the data interchange at the hardware device level and protocols for data interchange at the application program level. In the standard model known as Open Systems Interconnection (OSI), there are one or more protocols at each layer in the telecommunication exchange that both ends of the exchange must recognize and observe. Protocols are often described in an industry or international standard.

The TCP/IP Internet protocols, a common example, consist of:

Transmission Control Protocol (TCP), which uses a set of rules to exchange messages with other Internet points at the information packet level
Internet Protocol (IP), which uses a set of rules to send and receive messages at the Internet address level
Additional protocols that include the Hypertext Transfer Protocol (HTTP) and File Transfer Protocol (FTP), each with defined sets of rules to use with corresponding programs elsewhere on the Internet

There are many other Internet protocols, such as the Border Gateway Protocol (BGP) and the Dynamic Host Configuration Protocol (DHCP).

The word protocol comes from the Greek protocollon, meaning a leaf of paper glued to a manuscript volume that describes the contents.

Source: http://searchnetworking.techtarget.com/definition/protocol

PowerPoint

PowerPoint

Is the name of a proprietary commercial presentation program developed by Microsoft.

It was officially launched on May 22, 1990, as a part of the Microsoft Office suite, and runs on Microsoft Windows and Apple's Mac OS X operating system.

Source: http://en.wikipedia.org/wiki/Powerpoint

DNS

DNS

Is a hierarchical distributed naming system for computers, services, or any resource connected to the Internet or a private network.

It associates various information with domain names assigned to each of the participating entities.

Source: http://en.wikipedia.org/wiki/Domain_Name_System

Protocols

Protocols

Is a system of digital rules for message exchange within or between computers.

Must define the syntax, semantics, and synchronization of communication; the specified behavior is typically independent of how it is to be implemented.

Source: http://en.wikipedia.org/wiki/Communications_protocol

CSS

CSS

Is a style sheet language used for describing the presentation semantics (the look and formatting) of a document written in a markup language. Its most common application is to style web pages written in HTML and XHTML, but the language can also be applied to any kind of XML document, including plain XML, SVG and XUL.

Source: http://en.wikipedia.org/wiki/Cascading_Style_Sheets

HTML

HTML

Is the main markup language for creating web pages and other information that can be displayed in a web browser.

Is written in the form of HTML elements consisting of tags enclosed in angle brackets (like <html>), within the web page content.

Source: en.wikipedia.org/wiki/HTML

8.11.2013

ComSci1 - 6

Hands On

Hands on activities, for MS Word, were given to us after our lesons were taught. It's a little hard but I managed to finish all the activities in time.