Let's make a Game

Saan?? Sa Microsoft Excel.. :)

     Sa nakaraang third quarter namen sa kum say medyo kakaiba hindi lang naman sa puro first time pero akalain mo sa excel basics na naituro sa amin nakagawa kami ng simple game gamit ang conditional formatting at macro. Masaya talaga kahit simple lang kasi parang achievement nanaman sa buhay.
Macro at conditional formatting best partners dito.
Nagsisimula ang lahat ng bagay sa maliit.

Macro: Making Your Life Easier

         Kasi nga shortcut ng isang maikli o mahabang proseso na dapt gagawin mo sa excel. Akalain moh just press the designated shortcut in a split seconds magic will happen.

(AWESOME)

         Nirerecord niya yung bawat hakbang na gagawin mo sa excel, sa una lang naman dapat maraming gawin pero pag recorded na siya, effortless na pare. :) 

What IF??

            The IF function returns one value if a condition you specify evaluates to TRUE, and another value if that condition evaluates to FALSE. For example, the formula =IF(A1>10,"Over 10","10 or less") returns "Over 10" if A1 is greater than 10, and "10 or less" if A1 is less than or equal to 10.

                

Syntax

IF(logical_test, [value_if_true], [value_if_false])

The IF function syntax has the following arguments:

• logical_test    Required. Any value or expression that can be evaluated to TRUE or FALSE. For example, A10=100 is a logical expression; if the value in cell A10 is equal to 100, the expression evaluates to TRUE. Otherwise, the expression evaluates to FALSE. This argument can use any comparison calculation operator.
• value_if_true    Optional. The value that you want to be returned if the logical_test argument evaluates to TRUE. For example, if the value of this argument is the text string "Within budget" and the logical_testargument evaluates to TRUE, the IF function returns the text "Within budget." If logical_test evaluates to TRUE and the value_if_true argument is omitted (that is, there is only a comma following the logical_testargument), the IF function returns 0 (zero). To display the word TRUE, use the logical value TRUE for thevalue_if_true argument.
• value_if_false    Optional. The value that you want to be returned if the logical_test argument evaluates to FALSE. For example, if the value of this argument is the text string "Over budget" and the logical_testargument evaluates to FALSE, the IF function returns the text "Over budget." If logical_test evaluates to FALSE and the value_if_false argument is omitted, (that is, there is no comma following the value_if_trueargument), the IF function returns the logical value FALSE. If logical_test evaluates to FALSE and the value of the value_if_false argument is blank (that is, there is only a comma following the value_if_true argument), the IF function returns the value 0 (zero).

Remarks

• Up to 64 IF functions can be nested as value_if_true and value_if_false arguments to construct more elaborate tests. (See Example 3 for a sample of nested IF functions.) Alternatively, to test many conditions, consider using the LOOKUP, VLOOKUP, HLOOKUP, or CHOOSE functions. (See Example 4 for a sample of theLOOKUP function.)
• If any of the arguments to IF are arrays, every element of the array is evaluated when the IF statement is carried out.
• Excel provides additional functions that can be used to analyze your data based on a condition. For example, to count the number of occurrences of a string of text or a number within a range of cells, use the COUNTIF or theCOUNTIFS worksheet functions. To calculate a sum based on a string of text or a number within a range, use the SUMIF or the SUMIFS worksheet functions.

Error!Error!Error!

What are the common errors you'll get?

Examples:

Error	Meaning
#DIV/0!	Trying to divide by 0
#N/A!	A formula or a function inside a formula cannot find the referenced data.
#NAME?	Text in the formula is not recognized.
#NULL!	A space was used in formulas that reference multiple ranges; a comma separates range references.
#NUM!	A formula has invalid numeric data for the type of operation.
#REF!	A reference is invalid.
#VALUE!	The wrong type of operand or function argument is used.

Just try to understand this in case you might encounter these errors.

A little conversation when committing errors.

Me: what?? anyare??

seatmate: haha

me: nu problema??

First Time Pare

Halos lahat ng natututan ko sa kum say feeling ko "first time" lahat ehh..

Lalo na Excel...

Sa una mahirap,minsan OP,minsan kopya kopya lang...pero habang tumatagal EXCELlent ka na pala..

(hihihihi, nagjoke)

Ung una blanko,..


And turns to this..!!

(di ko yan gawa)

Magic diba... :)

Conditional Formatting- make your own rules!

You can use something called Conditional Formatting in your Excel spreadsheets. Conditional Formatting allows you to change the appearance of a cell, depending on certain conditions. What we'll do is to colour the Overall Averages on our Student Exam spreadsheet, depending on the grade. Here's the spreadsheet we'll be working on.

• Open up your Student Exam spreadsheet (You did complete it, didn't you?)
• Highlight the cells with Overall Grades, which should be cells B11 to I11

The Overall Averages range from 44 to 85. We'll colour each grade, depending on a scale. A different colour will apply to the following grades:

• 50 and below
• 51 to 60
• 61 to 70
• 71 to 80
• 81 and above

So five different bands, and a colour for each. To set the Conditional Formatting in Excel, do the following:

• With your Overall Averages highlighted, click on the Home menu at the top of Excel
• Locate the Styles panel, and the Conditional Formatting item:

The Conditional Formatting menu gives you various options. The easiest one is the Colour Scales option. Select one of these and Excel will colour the cell backgrounds for you:

That's not quite what we're looking for, though. We'd like to choose our own values. So click onMore Rules, from the Colour Scales submenu. You'll see the following rather complex dialogue box:

The one we want is the second option, Format only cells that contain. This will allow us to set up our values. When you click this option, the dialogue box changes to this:

The part we're interested in is the bottom part, under the heading Edit the Rule Description. It says Cell Value and Between, in the drop down boxes. These are the ones we want. We only need to type a value for the two boxes that are currently blank in the image above. We can then click the Format button to choose a colour.

So type 0 in the first box and 50 in the second one:

Then click the Format button. You'll get another dialogue box popping up. This is just the Format Cells one though. You've met this before. Click on the Fill tab and choose a colour. Click OK and you should see something like this under Edit the Rule Description:

The Preview is showing the colour we picked. So we've said, "If the Cell Value is between 0 and 50 then colour the cell Red".

Click OK on this dialogue box to get back to Excel. You should find that one of the cells has turned red. To format the rest of the cells, click on Conditional Formatting on the Styles panel again. From the menu, click on Manage Rules:

You'll get yet another complex dialogue box popping up! This one:

Our first rule is already there - Cell Value Between. The only thing we're doing here is adding New Rules, similar to the one we've just set up. Click the New Rule button then. You'll see the exact same dialogue boxes you used to set up the first rule. Set a new colour for the next scores - 51 to 60. Choose a colour, and keep clicking OK until you get back to the Rules Manager dialogue box. It should now look something like this one:

We now have to colours in our range. Do the rest of the scores, choosing a colour for each. The scores are these, remember:

• 50 and below
• 51 to 60
• 61 to 70
• 71 to 80
• 81 and above

When you've done them all, your dialogue box should have five colours:

The colours above are entirely arbitrary, and you don't have to select the same ones we did. The point is to have a different colour for each range of scores. But click OK when you're done. Your Overall Averages will then look something like this:

Formatting your spreadsheet in this way allows you to see at a glance relevant information. In the spreadsheet above, it's obvious who's failing - just look for the red cells!

Just see this (http://www.homeandlearn.co.uk/excel2007/excel2007s6p2.html)

MATH sa COM SCI??

Weeehh?

Yeah check niyo ms excel niyo... :)
Sa aming mga tinalakay gumamit kami ng ibat ibang formula..

Para makabuo ng formula, kailangan ang mga sumusunod:

*Equal Sign ( = ) +
*Mathematical Operators

• Subtraction - minus sign ( - )
• Addition - plus sign ( + )
• Division - forward slash ( / )
• Multiplication - asterisk (* )
• Exponentiation - caret (^ )

It is as Easy as that...

EXCELlent has been CHOP CHOP

EXCELLLL...

Ito ang main topic namen sa third quarter..

Makikita sa larawan ang mga parte ng excellll

What annoys me...

These are the guys that finished their work with all their best at super early submission pa. (medyo lang)

Masakit kapag kinumpara mo sa kanila, maganda na nga 5 minutes earlier pa.

Haaaaaayyy... masakit din ang past

yung makita mo sila relax na relax tapos makita mo sarili mo pawis na pawis

hahahahaha

5 minutes left

Everybody shouts aaaahh!!Clicks raging,eyes burning, ouch everybody is cramming!!

That's a fact inside the com lab during practical activities. This can't be erased its normal to us,i mean to all of us. 

After the class.... 

ohw like all of us crying.

So sad.

Ano nga ba mga nangyare?

Ayun medyo cramming sa paghahabol na matapos lahat ng activities. Panu naman puro practical pero ashtig more use sa computer at bonding with the net.

Halos parang turo-gawa ang naging sistema ng buong quarter. Mas pinagtuonan yung pratical para mas maraming maabsorb na lessons.

Napasa ko naman lahat ng requirements kaya feeling free na din.

Second Quarter

Para sa akin ang bilis nito matapos. Kaya nakakabitin yung meetings namen sa Com Lab.

Kulang yung bonding with sir tom.
Kulang yung cramming.
Kulang yung fun.
Kulang yung lamig na galing sa aircon. :(

Haayyy...Meh 6 years pa #tiwala lang.

Teka Teka Panu na si HTML?

<html>
<body>
<p1>
si HTML ay si Hyper Text Markup Language  para siya sa paggawa ng mga web page at iba pang mga impormasyong maaaring ilagay sa web browser.(translated from Wikipedia hihi)Sa madaling salita isang dakot na tags ang ilalagay mo. Pero at least may alam ka na kung panu gumawa katulad ko jege. Kung ikukumpara mo ang facebook malayo pa ang aming gawa.Pero ayos lang at least may nagawa din akong
maayos.
</p1>
<p2>
Magkapatid nga pala sila ni CSS. Palagi silang nagtutulungan para makagawa ng isang webpage.
</p2>
</body>
</html

CSS nga ba?

CSS stands for C A S C A D I N G   S T Y L E   S H E E T haba diba. Ito yung mas nagpapaganda ng HTML based na ginawa mo. 

Nasa pangalan na ang function nito kung alam mo yung full kumbaga ito yung nagpapakulay sa HTML kung wala siya wala din ang HTML? ganun?

hindi what I mean is malungkot si HTML dahil simple lang ang buhay niya.

GANUN yun.

Powerpoint is not just powerpoint

Powerpoint is just for making slides not presentation. You are the one who makes the presentation.
(ika nga ni Sir Tom)

Maraming paraan para masabing isa itong "good presentation"

as i can remember just keep calm and ask the moodle (jege)

seryoso na talaga

dapat:

SIMPLE at MAGANDA

So why NETIQUETTE?

Rules are not only in the physical world but also in the virtual world that is why these so called netiquette was formed. This word came from the word etiquette which means code of manners and net for the internet.

This is much really to be observed because there are not seen much in the modern world.

Ginawa ata to for more nosebleed. Hehe

The core RULEs of NETIQUETTE

Everything has its PROTOCOL

In life there are rules that should be followed. Look at everything, everything in this world has rules. In computers there rules but they call it protocol (para ashtig!). As I can understand uto yung bahala sa lahat ng may kinalaman sa communication sa mga computers(medyo nosebled). Basta madami.

NGANGA

     Ekspresyong hindi maaalis kapag namamangha sa mga magic ni sir sa computer niya. Kaya bilib na bilib kami sa kanya. Ito yung feeling na first time mo yung makita. Nakakatawa nga bilang layout artist marami pa pala akong kakaining bigas. Hindi pa pala sapat ang aking kaalaman para maging isang huwarang layout artist. (hahaha...taas ng pangarap)

Word, Word, Word

                Sa aming pagpapatuloy sa com sci ngayon ko lang nalaman na marami pa pala akong hindi alam sa MS Word. Ngayong Agosto 13, 2012 meron nanaman akong natutunan na kakaiba. "MAIL MERGE" ang aming lesson. Sa pamamagitan nito konte na lang ang guguguling oras sa pagpeprint ng mga dokumento especially kapag marami ang padadalhan. 

Mata at Tenga??? HUH??

        

     Dalawang bagay na kelangang kelangan mo sa loob ng com lab. Kelangan mo ang talas ng iyong mata at tenga para hindi ka mawala sa iyong landas. Tiyak isang pagkakamali lang ay bawas grade na agad. Naexperience ko na yan kaya ngayon ingat na ingat na ako. Nauso na rin sakin yung tanung tanung din sa katabi pag may time kasi minsan hindi na inuulit ni sir ang mga instructions na ibinigay niya. Kung ako sainyo hasain niyo na yan habang maaga pa.

CRAMMING?

credits to: GOOGLE IMAGES

    Yes CRAMMING ang salitang kadalasang maririnig mo sa loob ng com lab. Palaging hindi yan mawawala lalo na kapag may hands-on activities. Himala na lang kapag hindi mo yan narinig sa buong period ng Com. Sci. Tinatawag na nga namin ang aming sarili na "master crammers" dahil maging sa ibang subject ganun din ang aming klase. Kaya sa tingin magiging memorable ang bawat sandali sa loob ng com lab.

ORAS

          Oras isa mga mahalagang elemento kapag nasa loob ka ng computer laboratory. Kailangan mo maging mabilis sa paggawa para makamit mo ang deadline na hinihingi ni sir. Dapat palagi kang focus sa paggawa para hindi ka rin maiwan at maging maganda ang kalalabasan nito. Dapat din marunong kang maghati ng oras para hindi ka magcramming. (hahahahaha!)

Text vs GUI Base Navigation

Command Prompt

        First time ko gumamit nito kaya confused pa ako kaya follow lang ako ng follow sa instructions  ni sir. So far maganda naman yung kinalabasan nung test. Sabi ko nga parang magic nga habang naghahands on kami . Sa tingin ko mas maganda siya gamitin kapag alam mo lahat ng commands. Less effort na rin kapag gamit mo to.

Is MOODLE a MODIFIED DOODLE?

 

      Sa taas ay makikita niyo ay isang doodle art at yan ang unang pumasok sa isip ko nung narinig ko ang moodle. Yun pala ay parang isa tong facebook na exclusive lamang para sa mga pisayano. Maganda ito dahil maaari ka nang makapag-aral ng mga lessons niyo gamit ang internet. Ibang-iba pala ito sa iniisip ko kaya natatawa ako sa sarili ko.