|
|
|
|
|
|
|
Ã¥³»¿ë |
|
ÀÌ Ã¥ÀÇ Æ¯Â¡
¨ç MOS ÇÕ°Ý¿¡ ÃÖÀûÈµÈ ±¸¼º: MOS´Â °á°ú°¡ ¾Æ´Ñ °¢ Áß°£ °úÁ¤ üũ¸¦ ÅëÇØ Á¡¼ö ºÎ¿© °á°ú°¡ °°¾Æµµ °¢ ´Ü°è°¡ Ʋ¸®¸é °¨Á¡ 󸮵ȴÙ. ÀÌ Ã¥Àº ÀÌ·± MOS ½ÃÇè¿¡ ÃÖÀûÈµÇ°Ô ±¸¼ºµÇ¾î ÀÖ´Ù.
¨è ¿¹Á¦¼Ò½º ´Ù¿î·Îµå : ÇѺû¹Ìµð¾î_http://www.hanb.co.kr/exam/1849
´ÙÀ½ Ä«Æä_http://cafe.daum.net/mcascall
°øºÎÇÏ°í ´ÙÀ½ ³¯ ½ÃÇ躸´Â 1¹Ú 2ÀÏ ½Ã¸®Áî
MOS(Microsoft Office Specialist)´Â Microsoft »çÀÇ MS ¿ÀÇǽº 2007 Á¦Ç°¿¡ ´ëÇÑ »ç¿ë ¹× È°¿ë ´É·ÂÀ» Æò°¡ÇÏ´Â ±¹Á¦ °øÀÎ ÀÚ°ÝÁõÀÌ´Ù. ÄÄÇ»Å͸¦ ÀÌ¿ëÇØ ¿¢¼¿ ÇÁ·Î±×·¥À» Á÷Á¢ »ç¿ë, Á¶ÀÛÇÒ ¼ö ÀÖ´ÂÁö¸¦ Æò°¡ÇÑ´Ù. ÀÌ Ã¥Àº ¿¢¼¿ °íÀ¯ ±â´É°ú MOS ÃâÁ¦ ¹®Á¦¸¦ µû¶óÇϱâ Çü½ÄÀ¸·Î ½Ç½ÀÇÏ¸é¼ ÀÍÈú ¼ö ÀÖ°Ô ±¸¼ºÇÏ¿´´Ù. ÀÌ Ã¥À¸·Î ÇÏ·ç 3½Ã°£¾¿ ÀÏÁÖÀϸ¸ Á¦´ë·Î °øºÎÇϸé MOS ½ÃÇè¿¡ ÀÀ½ÃÇÒ ¼ö ÀÖ´Â ¼öÁØ¿¡ ½±°Ô À̸¦ ¼ö ÀÖÀ» °ÍÀÌ´Ù. |
|
¸ñÂ÷ |
|
Part0. ¿¢¼¿ 2007 ½ÃÀÛÇϱâ
¿¢¼¿ ȸéÀÇ ±âº» ±¸¼º
Section01. ¿¢¼¿ 2007 ½ÃÀÛÇϱâ
Part1. ¼ö½Ä°ú ±âº» ÇÔ¼ö
Section01. ¼ö½Ä°ú ¼¿ ÂüÁ¶
Section02. À̸§ Á¤ÀÇ
Section03. ±âº» ÇÔ¼ö¿Í 3Â÷¿ø ÂüÁ¶
Section04. ÅؽºÆ® ÇÔ¼ö ? LEFT, RIGHT, MID, CONCATENATE
Section05. ³¯Â¥ ¹× ½Ã°£ ÇÔ¼ö ? YEAR, MONTH, DAY, HOUR, MINUTE, SECOND, DATE, TIME
Section06. ³í¸® ÇÔ¼ö ? IF, AND, OR, IFERROR
½ÇÀü! ´Ü¿ø Á¤¸® ¹®Á¦
Part2. °í±Þ ÇÔ¼ö
Section01. Åë°è ÇÔ¼ö, ¼öÇÐ/»ï°¢ ÇÔ¼ö ? COUNT, COUNTA, COUNTBLANK, COUNTIF, COUNTIFS, AVERAGEIF, AVERAGEIFS, SUMIF, SUMIFS
Section02. ã±â/ÂüÁ¶ ÇÔ¼ö ? VLOOKUP, HLOOKUP
Section03. ¼ö½Ä ºÐ¼®
½ÇÀü! ´Ü¿ø Á¤¸® ¹®Á¦
Part3. ¸ÅÅ©·Î
Section01. ¸ÅÅ©·Î ±â·Ï ¹× ½ÇÇà
Section02. ¸ÅÅ©·Î º¸¾È ¼³Á¤ ¹× ¹®¼ ÀúÀå
Section03. ¸ÅÅ©·Î °ü¸®
Section04. ¸ÅÅ©·Î ¼Ò½º ÄÚµå ÆíÁý
Section05. »ç¿ëÀÚ Á¤ÀÇ ÇÔ¼ö
½ÇÀü! ´Ü¿ø Á¤¸® ¹®Á¦
Part4. ¿ÜºÎ µ¥ÀÌÅÍ
Section01. µ¥ÀÌÅÍ À¯È¿¼º °Ë»ç
Section02. ¾ç½Ä ÄÁÆ®·Ñ µµ±¸
Section03. ¿ÜºÎ µ¥ÀÌÅÍ °¡Á®¿À±â
Section04. ¿ÜºÎ µ¥ÀÌÅÍ ¿¬°áÇϱâ
Section05. XML µ¥ÀÌÅÍ
½ÇÀü! ´Ü¿ø Á¤¸® ¹®Á¦
Part5. µ¥ÀÌÅÍ °ü¸®
Section01. µ¥ÀÌÅÍ Ç¥
Section02. µ¥ÀÌÅÍ ÅëÇÕ
Section03. ¼½Ä ¹Ù²Ù±â ¹× ¼±ÅÃ
Section04. °í±Þ ÇÊÅÍ
Section05. ½ÃÆ® µ¥ÀÌÅÍ º¸È£
½ÇÀü! ´Ü¿ø Á¤¸® ¹®Á¦
Part6. µ¥ÀÌÅÍ ¿ä¾à ¹× ºÐ¼®
Section01. Â÷Æ® »ðÀÔ ¹× ÆíÁý
Section02. Çǹþ Å×À̺í ÀÛ¼º ¹× ÆíÁý
Section03. Çǹþ Â÷Æ® ÀÛ¼º ¹× ÆíÁý
½ÇÀü! ´Ü¿ø Á¤¸® ¹®Á¦
½ÃÇè ´ëºñ ¹®Á¦
½ÃÇè ´ëºñ ¹®Á¦Ç®ÀÌ |
|
|
|
ÀúÀÚ
|
|
ÀÌÁöÀ±
¼¿ï¿©´ë, CHAÀÇ°úÇдëÇÐ, µ¿¼¿ï´ë, Àå·Îȸ½ÅÇдë, ´ö¼º¿©´ë, Áß¾Ó´ë, ÆòÅôë, ¼¿ï±âµ¶´ë °ÀÇ
º¸À¯ ÀÚ°ÝÁõ MS(Micrsft ffice Specialist) MCAS(Micrsft Certified Applicatin Specialist) MS RI(Micrsft ffice Specialist Registered Instructr) MUS(Micrsft ffice User Specialist) CISA(Certified Infrmatin Systems Auditr) CCNA(Cisc Certified Netwrk Assciate) SCJP(Sun Certified Java Prgrammer) Á¤º¸Ã³¸®±â»ç / ÀÎÅÍ³Ý Á¤º¸°Ë»ö»ç / ÀüÀÚ»ó°Å·¡ °ü¸®»ç / ¸®´ª½º ¸¶½ºÅÍ / ¹«¼±ÀÎÅÍ³Ý °ü¸®»ç / À¥ ÆäÀÌÁö Àü¹®°¡ / ¿öµåÇÁ·Î¼¼¼
|
EXCEL 2002 CORE | ÀÌÁöÀ± | µµ¼ÃâÆÇ È«¸ª(È«¸ª°úÇÐÃâÆÇ»ç)
EXCEL 2007 ºñ¹Ð³ëÆ® | ÀÌÁöÀ± | ÁöÇʹ̵ð¾î
È¥ÀÚ¼ °øºÎÇÏ´Â MCAS POWER POINT 2007 ºñ¹Ð³ëÆ® | ÀÌÁöÀ± | ÁöÄÚ»çÀ̾ð½º
MOS Word 2007 Expert | ÀÌÁöÀ± | ÇѺû¾ÆÄ«µ¥¹Ì
MOS PowerPoint 2007 | ÀÌÁöÀ± | ÇѺû¾ÆÄ«µ¥¹Ì
|
|
±è¼±Èñ
¼¿ï¿©´ë, Àå·Îȸ½ÅÇдë, µ¿±¹´ë °ÀÇ. Àú¼·Î´Â Power Point 2007 ºñ¹Ð³ëÆ®°¡ ÀÖ½À´Ï´Ù.
|
È¥ÀÚ¼ °øºÎÇÏ´Â MCAS POWER POINT 2007 ºñ¹Ð³ëÆ® | ±è¼±Èñ | ÁöÄÚ»çÀ̾ð½º
MOS PowerPoint 2007 | ±è¼±Èñ | ÇѺû¾ÆÄ«µ¥¹Ì
|
|
ÀÌÁöÀ±
Çö ¼¿ï¿©ÀÚ´ëÇб³ ±³¾ç±³À°ºÎ ±³¾çÀü»ê ±³¼ö. ¼¿ï¿©´ë, Áß¾Ó´ë, Àå·Îȸ½ÅÇдë, µ¿¼¿ï´ë, ÆòÅôë, ¼¿ï±âµ¶´ë¿¡¼ °ÀÇ
|
EXCEL 2002 CORE | ÀÌÁöÀ± | µµ¼ÃâÆÇ È«¸ª(È«¸ª°úÇÐÃâÆÇ»ç)
MICROSOFT OFFICE SPECIALIST WORD 2002 CORE(MOS MASRER GUIDE) | ÀÌÁöÀ± | µµ¼ÃâÆÇ È«¸ª(È«¸ª°úÇÐÃâÆÇ»ç)
È¥ÀÚ¼ °øºÎÇÏ´Â MCAS POWER POINT 2007 ºñ¹Ð³ëÆ® | ÀÌÁöÀ± | ÁöÄÚ»çÀ̾ð½º
MOS Word 2007 Expert | ÀÌÁöÀ± | ÇѺû¾ÆÄ«µ¥¹Ì
MOS PowerPoint 2007 | ÀÌÁöÀ± | ÇѺû¾ÆÄ«µ¥¹Ì
|
|
±è¼±Èñ
|
|
|
|
|
|
|
|
Ãâ°í¾È³» |
|
|
Ãâ°í¶õ ÀÎÅÍÆÄÅ© ¹°·ùâ°í¿¡¼ µµ¼°¡ Æ÷ÀåµÇ¾î ³ª°¡´Â ½ÃÁ¡À» ¸»Çϸç, ½ÇÁ¦ °í°´´Ô²²¼ ¼ö·ÉÇϽô ½Ã°£Àº »óÇ°Áغñ¿Ï·áÇØ Ãâ°íÇÑ ³¯Â¥ + Åùè»ç ¹è¼ÛÀÏÀÔ´Ï´Ù. |
|
ÀÎÅÍÆÄÅ© µµ¼´Â ¸ðµç »óÇ°ÀÇ Àç°í°¡ ÃæÁ·ÇÒ ½Ã¿¡ ÀÏ°ý Ãâ°í¸¦ ÇÕ´Ï´Ù. |
|
ÀϺΠÀç°í¿¡ ´ëÇÑ Ãâ°í°¡ ÇÊ¿äÇÒ ½Ã¿¡´Â ´ã´çÀÚ¿¡°Ô Á÷Á¢ ¿¬¶ôÇϽðųª, °í°´¼¾ÅÍ(°í°´¼¾ÅÍ(1577-2555)·Î ¿¬¶ôÁֽñ⠹ٶø´Ï´Ù. |
|
¹è¼Ûºñ ¾È³» |
|
|
ÀÎÅÍÆÄÅ© µµ¼ ´ë·®±¸¸Å´Â ¹è¼Û·á°¡ ¹«·áÀÔ´Ï´Ù. |
|
´Ü, 1°³ÀÇ »óÇ°À» ´Ù¼öÀÇ ¹è¼ÛÁö·Î ÀÏ°ý ¹ß¼Û½Ã¿¡´Â 1°³ÀÇ ¹è¼ÛÁö´ç 2,000¿øÀÇ ¹è¼Ûºñ°¡ ºÎ°úµË´Ï´Ù. |
¾Ë¾ÆµÎ¼¼¿ä! |
|
|
°í°´´Ô²²¼ ÁÖ¹®ÇϽŠµµ¼¶óµµ µµ¸Å»ó ¹× ÃâÆÇ»ç »çÁ¤¿¡ µû¶ó Ç°Àý/ÀýÆÇ µîÀÇ »çÀ¯·Î Ãë¼ÒµÉ ¼ö ÀÖ½À´Ï´Ù. |
|
Åùè»ç ¹è¼ÛÀÏÀÎ ¼¿ï ¹× ¼öµµ±ÇÀº 1~2ÀÏ, Áö¹æÀº 2~3ÀÏ, µµ¼, »ê°£, ±ººÎ´ë´Â 3ÀÏ ÀÌ»óÀÇ ½Ã°£ÀÌ ¼Ò¿äµË´Ï´Ù.
(´Ü, Åä/ÀÏ¿äÀÏ Á¦¿Ü) |
|
|
|
|
ÀÎÅÍÆÄÅ©µµ¼´Â °í°´´ÔÀÇ ´Ü¼ø º¯½É¿¡ ÀÇÇÑ ±³È¯°ú ¹ÝÇ°¿¡ µå´Â ºñ¿ëÀº °í°´´ÔÀÌ ÁöºÒÄÉ µË´Ï´Ù.
´Ü, »óÇ°À̳ª ¼ºñ½º ÀÚüÀÇ ÇÏÀÚ·Î ÀÎÇÑ ±³È¯ ¹× ¹ÝÇ°Àº ¹«·á·Î ¹ÝÇ° µË´Ï´Ù.
±³È¯/¹ÝÇ°/º¸ÁõÁ¶°Ç ¹× Ç°Áúº¸Áõ ±âÁØÀº ¼ÒºñÀڱ⺻¹ý¿¡ µû¸¥ ¼ÒºñÀÚ ºÐÀï ÇØ°á ±âÁØ¿¡ µû¶ó ÇÇÇظ¦ º¸»ó ¹ÞÀ» ¼ö ÀÖ½À´Ï´Ù.
Á¤È®ÇÑ È¯ºÒ ¹æ¹ý ¹× ȯºÒÀÌ Áö¿¬µÉ °æ¿ì 1:1¹®ÀÇ °Ô½ÃÆÇ ¶Ç´Â °í°´¼¾ÅÍ(1577-2555)·Î ¿¬¶ô Áֽñ⠹ٶø´Ï´Ù.
¼ÒºñÀÚ ÇÇÇغ¸»óÀÇ ºÐÀïó¸® µî¿¡ °üÇÑ »çÇ×Àº ¼ÒºñÀÚºÐÀïÇØ°á±âÁØ(°øÁ¤°Å·¡À§¿øȸ °í½Ã)¿¡ µû¶ó ºñÇØ º¸»ó ¹ÞÀ» ¼ö ÀÖ½À´Ï´Ù.
|
±³È¯ ¹× ¹ÝÇ°ÀÌ °¡´ÉÇÑ °æ¿ì |
|
|
»óÇ°À» °ø±Þ ¹ÞÀ¸½Å ³¯·ÎºÎÅÍ 7ÀÏÀ̳» °¡´ÉÇÕ´Ï´Ù. |
|
°ø±Þ¹ÞÀ¸½Å »óÇ°ÀÇ ³»¿ëÀÌ Ç¥½Ã, ±¤°í ³»¿ë°ú ´Ù¸£°Å³ª ´Ù¸£°Ô ÀÌÇàµÈ °æ¿ì¿¡´Â °ø±Þ¹ÞÀº ³¯·ÎºÎÅÍ 3°³¿ùÀ̳», ±×»ç½ÇÀ» ¾Ë°Ô µÈ ³¯ ¶Ç´Â ¾Ë ¼ö ÀÖ¾ú´ø ³¯·ÎºÎÅÍ 30ÀÏÀ̳» °¡´ÉÇÕ´Ï´Ù. |
|
»óÇ°¿¡ ¾Æ¹«·± ÇÏÀÚ°¡ ¾ø´Â °æ¿ì ¼ÒºñÀÚÀÇ °í°´º¯½É¿¡ ÀÇÇÑ ±³È¯Àº »óÇ°ÀÇ Æ÷Àå»óÅ µîÀÌ ÀüÇô ¼Õ»óµÇÁö ¾ÊÀº °æ¿ì¿¡ ÇÑÇÏ¿© °¡´ÉÇÕ´Ï´Ù.
|
|
|
|
±³È¯ ¹× ¹ÝÇ°ÀÌ ºÒ°¡´ÉÇÑ °æ¿ì |
|
|
|
°í°´´ÔÀÇ Ã¥ÀÓ ÀÖ´Â »çÀ¯·Î »óÇ° µîÀÌ ¸ê½Ç ¶Ç´Â ÈÑ¼ÕµÈ °æ¿ì´Â ºÒ°¡´ÉÇÕ´Ï´Ù. (´Ü, »óÇ°ÀÇ ³»¿ëÀ» È®ÀÎÇϱâ À§ÇÏ¿© Æ÷Àå µîÀ» ÈѼÕÇÑ °æ¿ì´Â Á¦¿Ü) |
|
½Ã°£ÀÌ Áö³²¿¡ µû¶ó ÀçÆǸŰ¡ °ï¶õÇÒ Á¤µµ·Î ¹°Ç°ÀÇ °¡Ä¡°¡ ¶³¾îÁø °æ¿ì´Â ºÒ°¡´ÉÇÕ´Ï´Ù. |
|
Æ÷Àå °³ºÀµÇ¾î »óÇ° °¡Ä¡°¡ ÈÑ¼ÕµÈ °æ¿ì´Â ºÒ°¡´ÉÇÕ´Ï´Ù. |
|
|
´Ù¹è¼ÛÁöÀÇ °æ¿ì ¹ÝÇ° ȯºÒ |
|
|
|
´Ù¹è¼ÛÁöÀÇ °æ¿ì ´Ù¸¥ Áö¿ªÀÇ ¹ÝÇ°À» µ¿½Ã¿¡ ÁøÇàÇÒ ¼ö ¾ø½À´Ï´Ù. |
|
1°³ Áö¿ªÀÇ ¹ÝÇ°ÀÌ ¿Ï·áµÈ ÈÄ ´Ù¸¥ Áö¿ª ¹ÝÇ°À» ÁøÇàÇÒ ¼ö ÀÖÀ¸¹Ç·Î, ÀÌÁ¡ ¾çÇØÇØ Áֽñ⠹ٶø´Ï´Ù. |
|
|
|
|
|
|