How's the Finals

How’s The Finals

 Double the awesomeness of Computer Science 1 during the previous quarters that is how cool and

 Breathtaking 4th Quarter is. Those quizzes that seem to be math truly broke my mind. The focus of our topics for this 4^th quarter is all about the computer. All the sessions that we had were so helpful. I had thought lot of things and what’s more important is I have learned to be very careful with my choices and consider time management for the rest of my life. As a matter of fact I became a great crammer an irresponsible student for this quarter.

“I no longer expect, but I still hope”

Computer System

Computer System

 A computer system is one that is able to take a Set of inputs and process them and create a set of Outputs. This is done by a combination of Hardware and software. The absence of any of those two means makes no system, specifically computer system.

Software

Software

Any program that tells the computer system what to do is software. This provides instructions that the CPU needs to carry out. There are two types of software. It was so fascinating to know that there is especial type of software, the so called “compilers”. But there is a big question left to us by our teacher and I am willing to know,”what is used to install compilers?”

AI's Ancestor

I have thought from our class discussion that before AI was born it was a very long process. Artificial Intelligence is the 5^th Generation Computer. The first four are Vacuum Tubes, Transistor, Integrated Circuits and Microprocessors’ can’t believe that AI would also be self aware, it’s so amazing. 

Know What Makes Your Computer Busy

The computer undergoes different steps in a cycle for you to be able to save files and get files.This cycle is called machine cycle.A machine cycle, also called a processor cycle or a instruction cycle, is the basic operation performed by a central processing unit (CPU).For better understanding watch the video below

Binary Numbers & Convertion

11100011 00011010 01110110 11011011 11010101 01111000 10010011 10011110 11111000 01100001 01100011 11110101 11100101 11100001 10110101 01101010 01001100 01100011
01100011 11111111 00111111 11110101 01101010 00101011 11101101 10101010 01010000          

11100011 00011010 01110110 11011011 11010101 01111000 10010011 10011110 11111000 01100001 01100011 11110101 11100101 11100001 10110101 01101010 01001100 01100011
01100011 11111111 00111111 11110101 01101010 00101011 11101101 10101010 01010000            
                                                                                                                                                  01110110 11011011 11010101 01010011 00011010 01110110 11011011 11010101 01111000 10010011 10011110 11111000 01100001 01100011 11110101 11100101 11100001 10110101 01101010 01001100 01100011 11100011 00011010 01110110 11011011 11010101 01111000

10010011 10011110 11111000 01100001 01100011 11110101 11100101 11100001 10110101 01101010 01001100 01100011 1111Jus1  Kidd1ng0  111111 1  11010100 10101001 0101011
10101010 01010000 01100001 01100011 01100001 01100011 01100001 01100011 01100001

01100011 11111111 00111111 11110101 01101010 00101011  11101101 10101010 01010000       11110101 01101010 00101011 01100011 11111111 00111111  11101101 10101010 01010000    
01100111 01110101 00000001 01101011 01010100 01010100  01101010 11110000 00001010

11100011 00011010 01110110 11011011 11010101 01111000 10010011 10011110 11111000 01100001 01100011 11110101 11100101 11100001 10110101 01101010 01001100 01100011
01100011 11111111 00111111 11110101 01101010 00101011 11101101 10101010 01010000          

11100011 00011010 01110110 11011011 11010101 01111000 10010011 10011110 11111000 01100001 01100011 11110101 11100101 11100001 10110101 01101010 01001100 01100011
01100011 11111111 00111111 11110101 01101010 00101011 11101101 10101010 01010000            
                                                                                                                                                  01110110 11011011 11010101 01010011 00011010 01110110 11011011 11010101 01111000 10010011 10011110 11111000 01100001 01100011 11110101 11100101 11100001 10110101 01101010 01001100 01100011 11100011 00011010 01110110 11011011 11010101 01111000

10010011 10011110 11111000 01100001 01100011 11110101 11100101 11100001 10110101 01101010 01001100 01100011 11110111 10110110  111111 1  11010100 10101001 0101011
10101010 01010000 01100001 01100011 01100001 01100011 01100001 01100011 01100001

01100011 11111111 00111111 11110101 01101010 00101011  11101101 10101010 01010000       11110101 01101010 00101011 01100011 11111111 00111111  11101101 10101010 01010000    
01100111 01110101 00000001 01101011 01010100 01010100  01101010 11110000 00001010
.
.
.
.
  The binary number system is a numbering system that represents numeric values using two unique digits (0 and 1). Most computing devices use binary numbering to represent electronic circuit voltage state, (i.e., on/off switch), which considers 0 voltage input as off and 1 input as on. This is also known as the base-2 number system, or the binary numbering system. It is difficult for human to understand this kind of numbering system but it can be converted to hexadecimal and decimal.
 I've learned to convert binary to decimal(and vice versa) through the help of my tricky teacher.In fact he told us our class some history behind binary and what I love most is he thought us the short way on converting binary.
  Well you'll find binary numbering a  bit fun if you see the word "Just Kidding" in the zeroes and Ones above.

Simple Ways on Repairing Computer

Long ago I have trusted  ------------>   

But after knowing the basic ways for my PC to work properly I stopped using the computer troubleshooting.

Sharp eye and wide understanding are needed to be able to repair a not responding computer, a not working computer and a beep producing computer and other common computer problems. Here are some tips and tricks that can really help you.

#if your pc is not able to open

Check if all components of the affected computer system (the monitor, the CPU, the printer, etc.) are switched on and receiving power. If there is a power problem, try performing a Power Check.

Make sure that the cables and wire are firmly attached to the CPU and if loose, push them snugly into place.

#if your pc cannot connect to the internet

Make sure your router was turned on

Know is the server block you

Also consider the cables that connects you to the internet

There are other problems encountered by a computer and as I have learned a good way of repairing is to restore or restart your computer

#if your computer is not working and producing beeping sounds

               (This problem is most probably a CPU problem)

Then simply follow this link: Click this to continueClick This to continue

Tooth Brush = CPU ^_^

           How fascinating !After knowing the basic of computer parts we were task to assemble and disassemble the CPU!!!!! I feel like I am a young technician and with my Group mates it has been fun and easy for us.The CPU parts that we assembly includes ;

1. SATA CAbles

2. A small Battery

3.RAM

The awesome task was under time-pressure but still we work safe and fun.

Hello VirtualBox

 What if you can run a computer within a computer ,sound interesting right.Is that possible? Of course yes.This fact is have been a secret for me in the past 13 years here on Earth.

My laptop 's OS  is Windows 7   and I want to experience using an PC which Operating System (OS) is Window 8 or 8.1 or Ubuntu if possible.But to avoid mess up in  your PC ,there is  a virtual machine so there no need to worry. Virtual Box ,a virtual machine that  provides not physically existing as such but made by software to appear to do so.In that case you can freely install an OS ,provided that you have all the software and hardware requirements.

 A little bit effort ,but if you succeed to do so , your sweat will quenched.For Better understanding you may watch this Video below and treasure the Greatness of Virtual Box.

My First Last Day in Pisay

   Before the long summer, I would like to extend my gratitude and thanks to my cool teacher. Remember the day you thought us the simple cmd command on how to be able to see hidden files and delete it. Right after that afternoon my friend, Arlson Steven Ibias, gave me a flash drive with vbs file. We try to delete it but unfortunately we forgot what is needed. Few days later, my flash drive, which you demonstrate deleting the virus, after using it in to my laptop was again infected. With my eagerness to solve it took me 6 hours before I realize that I become addicted with cmd.  Computer Science makes me different. Now I am already playing computer games like DOTA and Counter Strike and in the other hand become better in using computer .Every quarter there are new knowledge and I treasure each of it. I could say that I taught so many things in this subject (computer Science).but this is just the beginning .See you next year!!!

What Did I Learn

            Our topics for this quarter focused most in Spreadsheets for Data Analysis so we used Microsoft Excel to do different awesome things( ^_^ ) like, Solver, Multiplication Table, Macros, Grading Sheet, Charts and many different activities .The most challenging one for me is the Multiplication table, because it was introduce to use by our teacher in the same day it was thought to us. By writing only a 1 formula to a cell then  apply the same formula to 

other 99 cells to obtain an instant Multiplication         Table. More over this Quarter seems to be the       Shortest one but the the one I enjoy most.I hope that the 4th Quarter would be more Fun.

All About Third Quarter

 Since First Quarter until this 3rd Quarter Mr.Tomas Secundo's jokes never failed.I often get his smart jokes and this helps a lot for a happy person like me.His jokes are useful in Long Tests and helps me to remember the lesson easily. At least for short  time during / before or after a challenging practical seat work /exam  my brain has its time to relax.
 Except of those funny jokes , the other thing that I love in Computer Science 1 is..... the........
AIR CONDITIONED ROOM .
Because of this I should not miss the class Session and even be late . Hehehehe^_^

Only the Problem is if some body really don't feel Good.Especially if his stomach is full ."/

Functions and Formulas

  A formula is statement written by the user to be calculated. Formulas can be as simple or as complex as the user wants. A formula can contain values, references to cells, defined names, and functions.All formulas must start with the equals sign. =1+2+3

  A function is a piece of code designed to calculate specific values and are used inside formulas. Functions to sum values, calculate a trigonometric cosine, and to calculate the current time are built into excel. Additional functions can be defined using Visual Basic.

Functions are typed alongside parenthesizes, where in the arguments if any are listed in between. To use functions in a formula, for example

=COS(3.14) will return the calculated cosine. =NOW() returns the current time. =SUM(1+2+3) *2 will multiply the sum by 2

A function is a built-in operation, such as SUM(), AVERAGE(), etc. A formula (also known as an equation) is something that the user defines, and can use/refer to various functions in it. A formula starts with an = sign, such as =(D1+D2)/A$3. They are similar in that both return a result based on the calculations that each performs. The difference is that a function is a built-in calculation, while a formula is a user-defined calculation. A formula could just use a single function.

For example, if you enter =AVERAGE(A1:A56), that is a formula, using the AVERAGE function. If you enter =SUM(G4+A5) - 25 * MIN(B3:B6), that is a formula which uses both the SUM function and the MIN function, as well as standard mathematical operators (-, +, *).

 I have learned their difference through experience .Since for almost  2 months I have been using Microsoft Excel , I realized that there are really different ,in use and in structure.It is quite fun so I just enjoy it.

Spreadsheet for Data Analysis File

                

               Spreadsheets - What they are and how they work?

A spreadsheet is a computer program that turns your computer screen into a smart

piece of paper. It removes much of the grunt work associated with repetitive

calculations and lets you easily see the results of your work. We have chosen to

use spreadsheets in the physics labs, because they reduce the amount of time

needed to look at and understand the data taken in the labs. Traditionally

accountants have used spreadsheets to do bookkeeping and budgets, but they

make outstanding tools for scientists as well. With a spreadsheet, we can enter

raw data, manipulate it and plot it all with a few simple commands. They are

especially useful because of their built in ability to plot data.

 

              The Basics:

A spreadsheet consists of a collection of cells, like a big table. The cells are labeled

by their column and row location. For example A4 is in the first column, the fourth

cell down. A cell can contain a label (text), a number, or a formula. If you put text

in a cell, it will display the text.

.

Logical Operations

             Logical Operation and Function

The concept of logical operators is simple. They allow a program to make a decision based on multiple conditions. Each operand is considered a condition that can be evaluated to a true or false value. Then the value of the conditions is used to determine the overall value of the op1 operator op2 or !op1 grouping.

Here are some logical operations that I learned.

=AND( logical1, logical2, … )

=OR( logical1, logical2, … )

=NOT( logical)Source: my awesome brain =)

Cell Reference

Cell Reference

MS Excel Cell and Range

This allows an easier access on the Excel to perform different things .Below are some basic knowledge that our  cool teacher thought to us.

• A7 – single cell

• A7,A14 – cell A7 and cell A14

• A7:A14 – range from A7 to A14 (same col)

• A7:Z7 – range from A7 to Z7 (same row)

• A7:Z17 – range from columns A to Z and    rows 10 through 20Some cool tips and techniques

• Autofill

• Paste Special

• Ctrl + ` Reference Types

• Relative - automatically changes when the

formula is copied down a column or

across a row

• Absolute - cell reference is fixed, doesn’t

change when copied to other cells.

• Uses $ sign like: $A$1

• Mixed - has either an absolute column and

a relative row, or an absolute row and a

relative column

• Like A$1 or $A1 Referencing from other the sheet

• Same file

– Manual selection

– Use a formula

• Ex: Sheet2!A1

• Different file

– Manual selection

– Use a formula

• Ex: [File2.xlsx]Sheet1!$A$1

• Absolute by default

Conditional Formating

Conditional formatting in Excel enables you to highlight cells with a certain color, depending on the cell's value. We mostly used the Highlight Cell Rules which helps you to understand the file easier. To highlight cell here are the following steps.

   Highlight Cells Rules

1.   Select the range A1:A10.

2.   On the Home tab, click Conditional Formatting, Highlight Cells Rules, and Greater Than...

3.   Enter the value 80 and select a formatting style.

4.   Click OK.

Result. Excel highlights the cells that are greater than 80.

5.   Change the value of cell A1 to 81.

Result. Excel changes the format of cell A1 automatically.

There are more rules in conditional Formatting like Top/Bottom Rules, Data Bars, Color Scales, and Icon Sets. All of this is really awesome and fun to use but the most exciting one is Creating New Rule! I tried making my own rule and I can say that I enjoyed it

Charts

 

    As I have learned  Charts are use to represent values and reality that provides enough information to show the reality.Before I am use to call this as a graph in math but I learned a different name of it in Computer Science 1.There are different type of charts there are

      

•          Column charts ( also known as bar graph)

This is used when you want to  show data changes over a period of time or for illustrating comparisons among items.

•    Bar Charts

almost same as the fist one,they only differ in the way their axis was named.

•     Line Charts

I use this to display continuous data over time,set against a common scale,and are therefore ideal for showing trends in data at equal intervals.For example if you will be comparing the money earned by 3 different movies in their 1st three days,Line chart will help you

•     Pie charts    

   Generally used to show percentage or proportional data and usually the percentage represented by each category is provided next to the corresponding slice of pie. Pie charts are good for displaying data for around 6 categories or fewer.

•          Area Charts

  An area chart or area graph displays graphically quantitive data. It is based on the line chart. The area between axis and line are commonly emphasized with colors, textures and hatchings. Commonly one compares with an area chart two or more quantities.

      

Macros

     A Macro instruction is a line of computer program coding that results in one or more lines of program coding in the target programming language, sets variables for use by other statements, etc.. In the mid - 1950 s , when assembly language programming was commonly used to write programs for digital computers, the use of macro instructions was initiated for two main purposes: to reduce the amount of program coding that had to be written by generating several assembly language statements from one macro instruction and to enforce program writing standards, e.g. specifying input/output commands in standard ways.

      I am so grateful that I learn how to use Macro.Macro makes working with Microsoft programs

 easier and happier.I have learned that if  I am going to edit many things with same changes  I will click "record macro" under developer in the ribbon.Then when I'm done, I will just click the the square near the word "Ready".After that my macro is ready to us.

Thanks to Sir

Thank you Sir for being a kind teacher.You though us well and I really improved.Just keep on being cool .You inspires me a lot.Thank you so much ^_^  .            

                                                                                                                     Jmperial

                                                                     JEROME C.IMPERIAL