The address has been copied.
Please paste it where you want to use it.
Article 1 (Purpose)
The purpose of these Terms and Conditions shall be that the customer (hereinafter referred to as "Member") using all member information services (hereinafter referred to as "Service") provided by the K-MOOC (hereinafter referred to as the "Site") operated by the National Institute for Lifelong Education (hereinafter referred to as NILE) and the 'Site' specify the terms and procedures and other necessary matters regarding the use of the 'Services'.
Article 2 (Effect and Change of Terms)
1. This Agreement will be effective when the Member clicks the "Agree" button in response to the question "Do you agree with the Terms?"
2. The 'Site' may change these Terms and Conditions, and the modified Terms will be announced to 'Member's for 7 days prior to the effective date and will be effective on the applicable date'
3. If 'Member' does not agree to the modified terms, 'Member' may stop using the 'Service' and withdraw. If 'Member' continues to use the 'Services' after the terms have been changed, the 'Member' shall be deemed to have agreed to the terms of this Agreement.
Article 3 (Regulations other than the Terms and Conditions)
When any matters not specified in these Terms and Conditions are specified in relevant laws and regulations, they shall be governed by the relevant laws and regulations.
Chapter 2 Membership sign-up and Service UsageArticle 4 (Usage Contract)
Use of the 'Service' is permitted only if the 'homepage' is permitted and the 'Member' agrees to the Terms and Conditions.
Article 5 (Application for Use)
1. In order to use this service, you must record your information on the form prescribed by 'this site'.
2. The user information shown on the subscription form is considered actual data. Users who do not enter real information will not be legally protected.
Article 6 (Approval of Use Application)
1. The 'Site' approves the use of 'Service's when 'Member' makes a complete application by writing all matters correctly. However, the following cases are an exception.
① If the application is made using someone else's name
② If you have filed a false application for the membership application form
③ If you applied for the purpose of hindering social well-being, order or morals
④ If you interfere with another person's use of the site services or take actions such ass tealing the information
⑤ If you do the acts prohibited by laws and regulations and the terms from using the site
⑥ If you do not have enough membership requirements set by the site
2. The information that the member enters is shown below. In addition to the information below, the 'Site' may require the 'Member' to enter additional information.
- Required items: Email, real name, ID, password, country, gender, year of birth
- Optional items: Place of residence, the highest level of education, purpose of enrollment
Article 7 (Change of Contract Items and Information Retention/Use Period)
1. The 'Member', if changes are made to the information entered when applying for 'Service', must correct it online.
2. From the moment you register as a 'member', the 'site' can hold and use the information of 'member'.
3. From the moment the 'Member' leaves the site, the information of the 'Member' will not be available on the site. However, in order to protect personal information, the 'Site' may retain the information of the 'Member' for 20 days from the moment when membership is withdrawn.
Article 8 (Collection of Personal Information by Cookies)
1. The 'Site' sends cookies to the user's personal computer to provide specialized services for each user.
2. In order for the user to be able to use it conveniently with one login, he or she must accept cookies.
3. Cookies are used to identify the characteristics of users who visit the 'site'.
4. Users can selectively accept cookies by adjusting options in the web browser. If you refuse to accept cookies, you will not be able to use the services that require log-in.
Chapter 3 Cancellation of ContractArticle 9 (Cancellation of Contract)
1. 'Member' may initiate complaints about the processing of member information through online.
2. When a 'member' wishes to terminate the service use contract, he or she may request the termination of the contract by e-mail with his or her name, ID, date of birth, or you must apply for withdrawal in 'membership withdrawal' menu of member information correction.
Article 10 (Disqualification)
In the event of the following reasons, the 'Site' may cancel the use contract without any prior notice or terminate the service use by determining a period.
1. If you missed the 'Basic Information' in Article 6 (2)
2. If you register with false contents when you apply for membership
3. If you have stolen someone's ID and password
4. If you infringe the intellectual property rights of the site, other members or third parties
5. If you do the act of harming social well-being and order, public morals
6. In the event of an act that damages or causes disadvantage to others' honor
Chapter 4 ResponsibilityArticle 11 (The Obligations of the 'Site')
1. In order to facilitate the use of the sites affiliated with the 'Site', the 'Site' may share the information of the 'Member' with the affiliated sites, and for the purpose of sharing, the 'Site' can send cookies to the computer of 'Member'.
2. The 'Site' does not disclose or distribute the personal information of 'Member' which is known by 'Service' provision to a third party without the consent of the user. However, the following exceptions apply.
① If there are special regulations in laws such as Act on Financial Real Name Transaction and Confidentiality, Use and Protection of Credit Information, Basic Law of Telecommunications, Telecommunications Business Act, Local Tax Act, Consumer Protection Act, Bank of Korea Act and Criminal Procedure Act
② When necessary for statistical writing / academic research or market research, if it is provided in an unidentifiable form for a specific individual
③ The 'Site' may use all or part of the information of 'Member' as statistical data related to the business'
④ The 'Site' strives to ensure that the 'Service' operates consistently and reliably. If the 'Service' is interrupted for any unavoidable reason, we will do our best to repair and recover it without delay. However, in case of natural disasters, emergencies, periodic system inspections and the necessity of 'NILE', we may stop or suspend the service temporarily.
Article 12 (Consent on the Use of 'Member' Information)
1. NILE operates various websites in addition to this site. NILE collects member's information for the purpose of providing services of the main site and various subsites operated by NILE, and can use the collected information of members.
2. The 'Site' may be affiliated with various education related associations and business operators for the quality of their services and may share their membership information. In such case, the 'Site' shall disclose the partnership, purpose, and contents to the Terms in this Article and shall be provided to the Affiliates after the consent of 'Member' is obtained.'
3. The consent of the 'Member' under the provisions of this Article shall be effected by clicking the button for subscribing to the information service provided in the Terms and Conditions and the entry screen of member enrollment information.
Article 13 (Obligations of Member)
1. 'Member's are responsible for the management of their ID and password.
2. 'Member' shall not assign, give, loan his or her ID to another person or allow others to use it.
3. If your ID is used improperly, the 'Member' must notify it to NILE.
4. "Member" can not use the data registered in the post to conduct sales activities.
5. 'Member' must receive a notice mail from the "Site".
Article 14 (Member Posts)
1. Posts include all writings made by members on the various boards of the 'Site'.
2. Any loss or problem arising out of the information posted by members and Q&A is solely the responsibility of the member, and the 'site' is not responsible for it unless it is the intention of the 'site'.
3. In the event of any claims, lawsuits, or any other disputes against the 'site' arising out of any third party due to the member' s posting, the member shall bear the cost of the settlement and process the dispute for the site, In the event that the 'Site' compensates the third party or damages occur to the 'Site', the member shall compensate the 'Site'.
4. The 'Site' shall delete member's post without prior notice in the event that the post of the 'Member' fall under any of the following: However, the 'site' does not have any obligation to inspect or censor the post.
① If you defame a third party by slander
② In case of contents that hinder public order or good morals
③ In case of infringement of copyright of the 'Site' or copyright of third party etc.
④ When the posting period stipulated in the 'Site is exceed
⑤ In case of a commercial post, a money-making advertisement, a good luck letter, etc.
⑥ In case of not meeting the purpose of site opening
⑦ When other applicable laws and regulations are violated
5. The 'Site' can process, sell, publish, etc. using the posts registered by 'Member's.'
Chapter 5 Information ProvisionArticle 15 (Information Provision)
The 'Site' may transmit the necessary information or advertisement to 'Member' by e-mail or letter mail. If 'Member' dose not want this, the 'Member' can refuse the information from the subscription application menu and the member information modification menu. However, we may send a notice mail of the 'Site' of Article 13 (5) to the member who has refused to receive the information.
Chapter 6 Exemption from Responsibility and IndemnificationArticle 16 (Responsibility)
1. The 'Site' shall not be liable for any damages incurred to the 'Member' in connection with the use of the 'Service' unless there is intent or gross negligence of the 'Site'.
2. The 'Site' does not endorse or warrant the appropriateness, accuracy, timeliness, credibility of information, products, services, software, graphics, voice and video related to the use of the 'Service'.
Article 17 (Exemption from Responsibility)
'NILE' will not be held responsible for any problems occurred to 'Member if disruption of service is due to natural disasters or unavoidable circumstances.
Article 18 (Competent Court)
The court shall be the court having jurisdiction over the location of the "NILE" or the court under the civil procedure law of the Republic of Korea.
The laws of the Republic of Korea shall apply to the interpretation and application of these Terms and the settlement of any dispute relating to these Terms and Conditions.
CCL is a free-use license that allows others to use their creations freely under certain conditions.
Attribution (Author Display)
It is an essential provision included in the license that the author must be indicated, such as the author's name and source.
Noncommercial
The work is not available for profit. It means that in order to use for profit, a separate contract is required.
No Derivative Works
It means that it is prohibited to change the work or to produce secondary works using the work.
Share Alike (Allow to change the same conditions)
It means that secondary works should be allowed to be produced, but the same license as the original works should be applied to secondary works.
Author Indication (CC BY)
You must mark the author's name, title of the work, and source.
Author Indication-Non-Profit (CC BY-NC)
If you reveal the author, you can use it freely, but you cannot use it for profit.
Author Indication-No Change (CC BY-ND)
If you reveal the author, you can use it freely, but you have to use it as it is without any changes.
Author Indication-Allow to change the same conditions (CC BY-SA)
If you reveal the author, you can freely use it and change the work, but the same license as the one applied to the original work should be applied to the secondary work.
Author Indication-Non-Profit-Allow to change the same conditions (CC BY-NC-SA)
It can be used if the author is identified, and the work can be changed, but it cannot be used for profit, and the same license as the original work must be applied to the secondary work.
Author Indication-Non-Profit-No Change (CC BY-NC-ND)
If you reveal the author, you can use it freely, but it cannot be used for profit and must be used as it is without change.
Field ETC (ETC)
Operating Institute Operating Institute 충북보건과학대학교 Go to the operating agency Opens new window
Week Week 8 Week
Course Registration Period Course Registration Period 26.09.01 ~ 26.12.18
Phone Number Phone Number 043-210-8692
Difficulty Difficulty -
Certificate Certificate Issuance
Learning recognition time Learning recognition time 15Hour 00Minute (09Hour 47Minute)
Course Duration Course Duration 26.09.01 ~ 26.12.18
Subtitle language -
Course language 한국어(ko)
비전공자도 쉽게 이해할 수 있도록 파이썬 기본 문법을 학습한다.
엑셀 파일을 처리할 수 있는 openpyxl 라이브러리를 학습한다.
실제 업무에 즉시 적용할 수 있도록 다양한 예제를 기반으로 학습한다.
주차 | 주차명(주제) | 차시 | 차시명(학습내용) | 평가방법 |
1 | 파이썬개론 | 1-1 | 파이썬 개발환경 구축 | 퀴즈(3) |
1-2 | 파이썬에서 제공하는 변수 개념 파악 숫자 자료형, 산술연산자 등 실습 | 퀴즈(3) | ||
1-3 | 불리언 자료형, 비교/논리 연산자 등 실습 | 퀴즈(3) | ||
2 | 파이썬 문법-1 | 1-1 | 문자열 자료형, 연산, 다양한 메서드에 대한 실습 | 퀴즈(3) |
1-2 | 리스트 자료형, 연산, 다양한 메서드에 대한 실습 | 퀴즈(3) | ||
1-3 | 튜플 자료형, 연산, 다양한 메서드에 대한 실습 | 퀴즈(3) | ||
3 | 파이썬 문법-2 | 1-1 | 조건문 if문 사용법 및 실습 | 퀴즈(3) |
1-2 | 반복문 for 문 사용법 및 실습 | 퀴즈(3) | ||
1-3 | 반복문 if문과 for문 중첩 사용 실습 2중 for 문 실습 | 퀴즈(3) | ||
4 | 파이썬 문법-3 | 1-1 | 반복문 - enumerate함수 실습 | 퀴즈(3) |
1-2 | 반복문 컴프리헨션 사용하지 않는 방법 실습 컴프리헨션 사용하는 방법 실습 | 퀴즈(3) | ||
1-3 | 반복문 while 문 사용법 및 실습 if문과 while문 중첩 사용 실습 | 퀴즈(3) | ||
5 | 업무 자동화의 개념 | 1-1 | 업무자동화(RPA)란? openpyxl 라이브러리 사용법 실습 엑셀 시트의 특정 셀에 데이터 입력하기 실습 | 퀴즈(3) |
1-2 | 저장된 엑셀 파일 불러오기 실습 엑셀 시트의 특정 셀 데이터 불러오기 실습 | 퀴즈(3) | ||
1-3 | 엑셀 시트의 특정 셀 범위 데이터 불러오기 실습 | 퀴즈(3) | ||
6 | 엑셀 자동화 | 1-1 | 파이썬으로 1개의 엑셀 파일에서 전체 데이터 추출하여 저장하는 방법 실습 | 퀴즈(3) |
1-2 | 파이썬으로 1개의 엑셀 파일에서 전체 데이터 추출하여 저장하는 좀 더 효율적인 방법 실습 | 퀴즈(3) | ||
1-3 | 파이썬으로 특정 폴더 밑에 엑셀 파일들의 전체 데이터 추출하여 저장하기 실습 | 퀴즈(3) | ||
7 | 엑셀 자동화 | 1-1 | 파이썬으로 통합한 엑셀 파일에서 제품별 시트 분리하여 저장하기 실습 여러 시트를 가지고 있는 파일에서 시트 이름별로 파일 저장하기 실습 | 퀴즈(3) |
1-2 | 파이썬으로 통합한 엑셀 파일에서 제품별 판매 합계 내기 실습 | 퀴즈(3) | ||
1-3 | 파이썬으로 통합한 엑셀 파일에서 필요한 일부분만 추출하여 저장하기 | 퀴즈(3) | ||
8 | 형성평가 | 1-1 | 형성평가 | 온라인 형성평가 |
1-2 |
|
| ||
1-3 |
|
|
Field ETC (ETC)
Difficulty Difficulty -
Operating Institute 충북보건과학대학교 Go to the operating agencyOpens new window
Certificate Certificate Issuance
Week Week 8 Week
Learning recognition time Learning recognition time 15Hour 00Minute (09Hour 47Minute)
Course Registration Period Course Registration Period 26.09.01 ~ 26.12.18
Course Duration Course Duration 26.09.01 ~ 26.12.18
Phone Number Phone Number 043-210-8692
Subtitle language -
Course language 한국어(ko)