The Final Quarter: Data Representation

               There are two types of data that are store within a computer:

• Original data or information is a data that is introduced to a computing system for the first time.
• Previously Stored data or information is the one that has already been processed by a computer and is being stored.

               The process of taking a visual image or audio recording and converting it to a binary form for the computer is called digitizing.
              
               The common basic technologies used for storing binary information are:

• Electronic (flashdrive)
• Magnetic (external/hard drive)
• Optical (CD/DVD)

             
               Bit is the smallest unit of data the computer uses. It can be used to represent two states of information. While a byte can represent 256 states of information. 8 bits are equal to 1 byte.
              
               The most important characteristics of storage devices are:

• Speed - consider the access time. The fastest one is the electronic device.
• Cost - The cheapest device is the optical one.
• Capacity - Magnetic device can hold the largest capacity.
• Type of Access affects the speed of device. There are two types. One is the sequential which is obtained by proceeding from the start until the designated area. The other is random access wherein you can go directly to the designated area.

               Information is moved about in bytes or multiple bytes called words which are the fundamental units of information.

The Final Quarter: Software

               The programs which tell the computer system what to do are software. They give instructions that the CPU will need to carry out. There are two types of software:

1. System Software manages, maintains and controls the resource of the computer. These are the programs that take control of the computer.

• System Management Program

          Operating System (OS) is a program that monitors and controls all input/output and processing activities within a computer system.    

• System Development Program

          Compilers are what software used to create software through programming.

2. Application Software is designed and created to perform specific personal, business, scientific processing tasks.

• General Purpose Program
• Application Specific Program     

Here are a few reminders from Sir Tom:

*Platform is defined by a processor and an operating system.
*Software created to run a specific platform won't run on other platforms.
*Microsoft Windows operating system + Intel compatible-processor = Wintel platform is what most personal computer users choose.
*You can't run modern systems on earlier platforms.
*Before choosing a platform, consider the availability of appropriate commercial application software for the platform and the compatibility of platform with existing hardware, software and expertise.

                      

The Final Quarter: Computer System & Hardware Specifications

               We immediately started our lesson for the last quarter after the periodical exam. These are the things that I've learned about Computer System and Hardware Specs:
               One that's able to take in inputs and produces outputs is the Computer System. It is made up of two components: the hardware and the software. Some examples of a hardware are the CPU, keyboard, mouse, memory and input/output devices. While the operating system and applications are examples of a software. A hardware can work even if it doesn't have a software because of the firmware which is always installed to it.
               Here are the kinds and subtypes of a computer:

(c) Sir Tom Secundo

              One that's really amazing is the super computer which NASA uses and Watson is an example.
              Hardware Specs or Hardware Specifications are the one that dictate the limits and maximum capability of a hardware/device depending on a given criteria or unit of measurement.
              System Requirement, obviously, requires the minimum hardware specs of a computer system so it will be able to run a particular computer software. 
             

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