Sunday, October 25, 2009

POINTERS TO REVIEW for COMPUTER 2

Pointers to Review

Lecture: ICT

Types of Network
Network Components
Network Categories

Internet
-History
-Functions
-Components
-Protocols
-Domain Names
-Free Internet Services

Lab: Ms Excel-Spreadsheet Application

History of Spreadsheet
MS-Excel Parts 03/07 Version
Ms Excel Functions
String Functions
-Proper
-Upper
-Lower
-Trim
Numerical Functions
-Sum
-Product
-Quotient
Statistical Functions
-min
-max
-average
Logical Functions
-If
Count Functions
-count
-counta
-countblank
-countif
Date and Time Functions
-Today ()
-Now()

www.vertex42.com For Free Excel Templates
www.techonthenet.com For reference on Excel Functions
http://www.top-windows-tutorials.com/#




Topics For Individual Performance Task (All Topics) Photo Essay Tutorials


1. PC Basics
2. XP Basics
3. Vista Basics
4. Working With Files
5. Make Your PC Faster
6. How to Beat Viruses
7. Smart Internet Surfing

Deadline of Submission of Individual Performance Task

Section 20-November 5
Section 21-November 4
Section 22-November 4
Section 23-November 5
Section 24-November 5

Schedule of Long Test and Practical Exam
Section 20-November 4 WEDNESDAY 8:00 - 9:30 AM HS LABORATORY
Section 21-October 27 TUESDAY Regular Double Period
Section 22-October 28 WEDNESDAY Regular Double Period
Section 23-November 6 FRIDAY 10:00-11:30 AM
Section 24-November 5 Thursday 10:00-11:30 AM

Tuesday, September 29, 2009

"Ondoy"A Perfect Storm







"A perfect storm". After my regular church worship service last sunday,my adveturous blood rushed into my veins and told me to go to some place to see the adverse effects of the straight 14 hours of rainfall equivallent to 1 month of rain, I was illumined by the grim reality of what happened to our beloved school,though there are minimal damages,still it is enough for the school to suspend classes for 1 week because of these calmity...These photos reveal the awesome power of nature when it strikes back at us...we can do nothing but ask for forgiveness...Let us furthermore empower our will and persistence in living out our school thrust "Peace and Care for the Earth"....so this things may be avoided in the future...






Thursday, September 24, 2009

Excel Lessons for Second Year!

Spreadsheet-is a computer equivalent of a column pad paper.
consists of a grid made from columns and rows.
derived from the accounting file where business activities and transactions are kept track using large columnar pads called a “spreadsheet”

Spreadsheet Application Software-used to store data electronically
a better alternative to manually computing mathematical calculations and can be more accurate and time saving.

History of Excel
1978 VisiCalc (Visible Calculator)
- the 1st electronic calculator
- Daniel Bricklin (Father of electronic spreadsheet) and
Bob Frankston (co-creator) with
Daniel Flysra (founding associate editor of BYTE Magazine)

1979 Flystra joined Brikclin and Frankston in developing the VisiCalc.
- “ Personal Software”, a firm of Flystra began marketing VisiCalc
(later renamed VisiCorp)

- almost $1 Million copies of VisiCalc were sold

1980 Kapor (Product manager of VisiCalc) designed VisiPlot/
VisiTrend which he sold for $ 1 M

1982 Lotus 1-2-3 made it easier to use spreadsheets and it added
integrated charting, plotting and database capabilities.
Microsoft Excel was originally written for the 512 K Apple Macintosh in 1984-1985.

Excel was one of the first spreadsheets to use a graphical interface pull down menus and a point and click capability using a mouse.
Microsoft launched the Windows operating system in 1987.


What is spreadsheet?
Rows and columns of data.
Derived from the accounting file where business activities and transactions are kept track using large columnar pads.
Electronic Spreadsheet
- stores data electronically.
ADVANTAGE: It can automatically recalculate when changes are made to the data.

Ms-Excel
1.) Written and distributed by Microsoft for Windows and Apple Macintosh Operating System (OS).
2.) Is an electronic spreadsheet which allows users to manipulate numerical data with formulas and built-in functions
3.) One of the “most popular” micro-computer applications to date.
4.) The first spreadsheet program that allowed the user to define the appearance of spreadsheets (fonts, character attributers and cell appearance)
Advanteges of Excel
1.) Encoding, editing, and deleting data are easy.
2.) You can encode text, numbers, and formulas
3.) Numbers can be easily computed and analyzed.
4.) You can create graphs and charts on a given data.
5.) It can perform mathematical and statistical computations such as adding, averaging, conversion of numbers to trigonometric functions, logical comparisons, and financial calculations.
6.) It can also be used as a diary, calendar, and scheduler






































Wednesday, September 23, 2009

Blogging Rubrics



Here is a guide for my second year students so they may know how are they going to be graded in thier Blogging experience!Remember this is going to be a Long Quiz and A Major Computer Lab Activty!Oh! as well as an Assigment!so better read on!Now!

Sunday, September 20, 2009

Lecture Lessons 2 ! Latest Internet Services

Thanks to Mr. Lee Lefever...my students got to know this internet services that would surely make thier Online World interactive,Fun and Useful!We will surely use these as Activities for my subject!

Blogging



Podcasting



RSS


Wikis



Social Bookmarking


Online Photosharing



How WWW Works?

]

Web Search Strategies

Lecture Lessons! A bonus for my students

Why not I post my lessons? Would you like that? a simple thanks you from my students may urge me to post more….
Lecture Lessons
Information and communication technologies in education deal with the use of Information and Communication Technologies (ICTs) within educational technology.
ICT as a Tool
The purpose of ICT in education is generally to familiarize students with the use and workings of computers, and related social and ethical issues.
Learning Tool
Entertainment Tool
Information Tool
Communication Tool
Productivity Tool

ICT in education can be broadly categorized in the following ways

• ICT as a subject (i.e., computer studies)
• ICT as a tool to support traditional subjects (i.e., computer-based learning, presentation, research)
• ICT as an administrative tool (i.e., education management information systems/EMIS)

source: ( wikepedia.org)



 NETWORK
 are multiple computers linked together to make simultaneous information sharing and exchange of multiple users.
 make it possible for its connected user to share tools resources and information.
 NETWORK SOFTWARE
 Consists of computer programs that interface with network users and permit the sharing of information such as files, graphics, video and resources such as printers and disks.
 NETWORK TERMS
 NETWORK SERVER
- a powerful computer whose sole purpose is to serve network clients
- control software and provide workstations with requested resources
 WORKSTATION
-any network computer that connects to and request resources from a network
 NETWORK TERMS
 HOSTS
- any computer that acts as an information source on a network.
 PEERS
- any computer sharing the same protocol layer with another computer.
- any computer which share resources security levels and user groups.
 NETWORK TERMS
 PROTOCOL
- refers to the specific standards governing the sending and receiving of data

 Network differ in the:
 number of connected computers
 distance between their users
 construction
 maintenance cost
 Network Architecture:
 The Client/ Server Relationship
 Peer – to – Peer Relationship:
 +Peers
 Terminal/Host Relationship:
 +Host
 3 BASIC NETWORK
CATEGORIES
LAN
MAN
WAN
 Local Area Network (LAN)
 collection of interconnected computers that can share data, applications, and resources, such as printers
 separated by distances of up to a few kilometers and are typically used in offices or across university campuses
 enables the fast and effective transfer of information within a group of users and reduces operational costs
 Metropolitan Area Network (MAN)
 large computer networks usually spanning a town or a city, they typically use optical fiber connections to link their sites
 for instance a university or college may have a MAN that joins together many of their local area networks (LANs) situated around site,then from their MAN they could have several wide area network (WAN) links to other universities or the Internet
 Wide Area Network (WAN)
 a computer network that is meant to cover a wide geographic area, usually over telephone lines, as compared to a local area network that operates in a single company or institution
 separated by longer distances, typically across the country or internationally, and they use specialized and expensive hardware and leased communications services
 NETWORK MEDIA
 UTP
 STP
 Coaxial cable
 Fiber optics
 NETWORK MEDIA
 any material that transport data in any way or form
 NETWORK MEDIA
 NETWORK HARDWARE
 NIC (Network Interface Card)
- A printed circuit board, an adapter that plugs into the computer’s motherboard
- Provides physical link between the computer and the network
- Its main function is to convert computer data into cable-transmittable data and provide a connection to network media
 NETWORK HARDWARE
 Network Hub
- It is where all PCs on a network are connected to by cabling
- Manages receiving and transmitting data from networked devices
- Allows data to flow on and off the network between printers, computers and other devices by sharing the lanes of traffic
 NETWORK HARDWARE
 Wireless Hubs
- designed for the home environment where running cabling is too expensive
- it works by converting network signals to radio frequencies and back to network signals at the receiving computer



 INTERNET
 It is a collection of computers throughout the world which are connected mostly using telephone lines for the purpose of sharing information.
 Functions of the Internet
 WWW (World Wide Web)

-one of the protocol that lets you link to many web sites on the WEB
Web page – the basic unit of WWW
- there are links to related
pages and other web sites
 E-MAIL (Electronic Mail)
- allows computer users locally and worldly to exchange messages
 TELNET
- a program that allows you to log into computers on the Internet and use online database, library catalogs, and chat services
 File Sharing (File Transfer Protocol)
- it is both a program and the method used to transfer files between computers
 E-MAIL
- it offers opportunity to people worldwide to communicate via e-mail
- individuals carry out active discussion organized around topic
 Instant Messaging- any computer program that send instant messages to another computer.
 Streaming Media- radio, news and any means of media accessible via internet
 Collaboration- sharing ideas knowledge and skills online
 Remote Access- allows a user to connect to another computer wherever they are
 Functions of the Internet
 Components of the Internet
 CHAT and INSTANT MESSENGING
CHAT – allows user on the Internet to communicate with each other by typing in real time
INSTANT MESSENGING – user on the
Web can contact another user currently logged in and type a conversation
 Major Protocols Accessible on the Web
 E-mail
- Simple Mail Transport Protocol (SMTP)
- distributes electronic messages and files to one or more electronic mailboxes
 Telnet
- Telnet Protocol
- facilitates login to a computer host to execute commands
 Major Protocols Accessible on the Web
 FTP
-File Transfer Protocol
- transfer text or binary files between an FTP server and client
 Usenet
- Network News Transfer Protocol (NNTP)
- distributes Usenet news articles derived from topical discussions on newsgroup
 Major Protocols Accessible on the Web
 HTTP
- HyperText Transfer Protocol
- transmit hypertext over networks
- the protocol of the WWW
 Voice over Internet Protocol (VoIP)
- allow users to place telephone call
over the Web
 What can we get from the Internet?
 E-mail
 Information
 Group discussion
 Entertainment
 On-Line Shopping
 Free Programs
 Retrieving documents on the Web: The URL
 URL
- stand for Uniform Resource Locator
- specifies the Internet address of a file stored on a host computer connected to the Internet
- every file has a unique URL
- translated into numeric address using the DNS
 Anatomy of a URL
 Structure of URL
Protocol: http
Host computer name: www
Second-level domain name: congress
Top-level domain name: gov
Directory name: leadership
Filename: index.htm
 Domain Name
 denotes the name of a specific Internet area controlled by a company, school or organization
 Top-Level Domain Names
 com – commercial enterprise
 edu – educational institution
 gov – government entity
 mil – military entity
 net – network access provider
 org – usually non-profit organizations

CLASSROOM Dos and Don'ts

Things you should "not" be doing inside the classroom


After years of teaching experience, I have made a list of Dos and Don'ts
of polite behavior in the classroom. . .

BEFORE YOU EVEN COME TO CLASS. . …. A simple checklist!

Personal Things -(Necessary for living)
Learning Materials -It should be with me!
Physical Appearance-Do i look like a student?

Before you go to my class

1. RELIEVE YOURSELF (Mag CR na)
2. TURN OFF YOUR CELL PHONE (Bawal pati yan)

Big NO NOs. . .
1. ASSUMING THAT PERFUME/COLOGNE IS A SUBSTITUTE FOR BATHING : "Not Controling your Odor/Fragrance"

2. DOING HOMEWORK FOR ANOTHER CLASS DURING THE Discussion

3. WORKING ON YOUR SOCIAL CALENDAR DURING Lessons

4. PICKING NOSES, SCABS, OR ACNE AND CHEWING FINGERS

“Aside from being socially unacceptable, they’re usually done with the writing hand”

5. ASKING, "DO WE NEED TO KNOW THIS FOR THE EXAM?"
(Sorry, you have to know everything!)

6. ACTING LIKE YOU HAVE SOMEWHERE BETTER TO BE

11. YAWNING WITH AN OPEN MOUTH

12. WATCHING THE CLOCK

13. SLEEPING IN CLASS

“ALL OF THE ABOVE ARE DISTRACTING AND OTHERS AND SHOULDN'T BE DONE IN POLITE SOCIETY ANYWAY. These things MAY DRAW MY WRATH, RANCOR, IRE, RAPIER WIT, ETC.”

IT IS O.K. TO. . .
USE YOUR INTELLECT
QUESTION WHAT YOU ARE BEING TOLD
INTERRUPT TO ASK A PERTINENT QUESTION
INTERRUPT TO MAKE AN INTERESTING COMMENT
QUIETLY DRINK IN CLASS (Non-alcoholic beverages only, please!!!)

“A CLASS IS NOT SO LARGE THAT YOU CAN BECOME INVISIBLE, SO WATCH YOUR BODY LANGUAGE. SCOWLING, SLOUCHING, SLEEPING, YAWNING, OR OTHER OVERT EXPRESSIONS OF BOREDOM MAY DRAW ATTENTION; DON'T BE SURPRISED IF YOUR TEACHER ASK WHAT THE PROBLEM IS!”

I am currently looking to fill in the rest of the No No's list! If anyone has a good image or is willing to pose for one, just add a comment here!

Thank You For Reading!
Keep the comments coming!



for a more vivid explanation go to:
(source:) http://www.longwood.edu/staff/hardinds/Courses/Etiquette%20Illustrated/EtiquIll.htm

What's up with me?I'm into Photography!









"Passion for Creativity, figment of imagination and reality" Photography has illumined my eyes to the wonders and madness of the world. The beauty of God’s creation worth capturing both in my memory and through my newfound hobby.
I was inspired to become a newbie travel photographer after seeing the great outdoors and wild wilderness in most my Adventures in Baler Aurora, Gabaldon Nueva Ecija and all near provinces within my place here in Rizal, I’ve learn photography through self study and experimentation with a small digital point and shoot and through my first digital SLR. My style revolves around capturing touching landscapes, brilliant city life, work related photo essays and journals usually through normal to long exposures, through it I also would like to raise awareness and urge conservation of fragile ecosystem we have and celebration of My Life in general...
Enjoy and See the beauty of God in You….


Gear: Nikon D90 |18-105mm DX G ED VR| Tripod| Timer Remote Switch

Wanna see more of My Art? check this out! http://giancarlosaulo.multiply.com/

Hello New Blogger! This one is for you! ( for the Old Bloggers too!)

Blogging has been around the corner for quite some time already and people have been engaging in using this technology to express oneself to the World!

Whether they just like to try it out or maybe some people “forced” them to make one because it’s a school activity or something…hehehehe! But nevertheless we should all learn how to do it right! Blogging can be synonymous to “News writing” .Even when they say its “Personal” News writing, it does not give us the freedom to just make it the “unprofessional way” Let us all “try” our best and give a little effort to at least make it pleasing, proper and fun to readers and potential followers! “This is what social media is all about!? Isn’t it?
These are several reminders that would make us better writers at school at of course in blogging!

Very Basic Checklist (Sana Kayanin mo)
1. Check your Grammar! (duh! kailangan pa bang I memorize yan?)
2. Active instead of Passive Writing! (research something on these Please!)
3. Unnecessary adjectives and adverbs (Avoid “OA” terms but its ok when needed)
4. Subject-verb agreement “English Subject Yaan!”
5. Proper use of Prepositions
6. Avoid “legalese” (“unless you’re a lawyer”)
7. NO “redundancies” “Paulit-ulit na words”
8. Review of misused words/phrases

Here are some Guide Questions that you should consider before hitting that “Publish Button” or this could be a guide for your Writing “Blogging” Style…

1.What kind of information must be relayed to the mark audience? What is your real message?
2. Is your article meant to give a full discussion of the issues concerned, or is it simply meant to give a puzzler or essential information?
3. Are all arguments necessary to be included in your article? , or would it be better to just focus on particular angles?
4.Who are the target audience? Do they belong to the upper, middle or lower social class? What other demographic information must be also kept in mind?

Basic Questions about your Blogging Style
Does the target audience have a favored form of piece of writing based on past understanding? Would they be open to a new form of style, if ever? If the answer is yes, would they be able to comprehend the intended message through this new form?

Blogging Style Format Cheklist
Writers Design – “look and feel” (depend on what type of writer you are)
The Layout of Your Post (Introduction, Body, Conclusion)
Presence of necessary elements (
Arrangement of elements
Length of article
Your Grammar
Your Diction
Here are some things to remember about making the “content” of your post.
It should be sensitive to target audience! (it should be fun for them)
It should give the overall message
Relevant to other information provided
Valuable for the target readers or “followers”

Hope This Helps! Happy Blogging !

Followers