Courses (Spring 2024)
Welcome to the class!
▶ STUDY
▶▶ ENJOY
▶▶▶ DEVELOP
★★★ 25148-01 and 25148-02 PRACTICAL COMPUTING (실용전산) [2 sections will be opened] ★★★
Tired of using Excel for basic tasks like adding and sorting data? Do you want to unlock the full potential of this powerful tool and use it to solve complex problems, analyse data and create stunning charts and graphs? Then this course is for you!
In this course, you will learn how to use Excel and Google Sheets to their full potential and tackle a variety of problems. You'll learn how to use advanced functions and formulas, analyse statistical data, create beautiful charts and graphs, and develop your own custom functions using the VBA programming language.
But that's not all! You'll also have the chance to study the mathematical modelling process and explore other mathematical methods that can be applied in Excel and Google Sheets. So don't miss this opportunity to become a computing expert and take your skills to the next level!
Objectives:
Transform Excel and Google Sheets from a simple data tool into a problem-solving powerhouse.
Master advanced Excel and Google Sheets functions and formulas to solve complex problems.
Use Excel and Google Sheets for sophisticated statistical analysis and data visualization.
Create professional-grade charts and graphs to clearly communicate your data.
Learn how to develop user-defined functions using VBA, the programming language of Excel.
Explore how ChatGPT and Google Bard can be used for computing and data visualization.
Explore the mathematical modeling process and other mathematical methods that can be applied in Excel.
Practical skills
Excel and Google Sheets functions.
Chat GPT & Google Bard AI chatbots (why do we need to learn these tools?).
Data visualization.
Various charts and a color wheel.
Trend lines (regression models).
Some useful freeware software mentioned in the syllabus.
★★★ 44351 SMART SYSTEM SIMULATION (스마트 시스템 시뮬레이션) ★★★
A smart system, often called an 'intelligent' system, is a modern technological solution that uses various sensors, data analytics and automation to enhance its capabilities and performance in real-time or over time. These systems gather information from their environment, use it intelligently, and decide and take action for achieving certain goals and optimising processes. Smart systems can be found in a wide range of applications and industries, including industrial automation, smart factories, energy management, smart cities, transportation, smart home systems, healthcare, environmental monitoring, agriculture, finance and retail. Smart system simulation refers to the process of using computer-based simulation to model, analyse and test the behaviour and performance of intelligent systems. This approach is particularly useful in the development and refinement of complex systems that incorporate elements of automation, data analysis, artificial intelligence and decision-making. Smart system simulation is particularly valuable when it is impractical, costly or risky to test a system directly in the real world.
[Translated by Papago]
종종 '지능형' 시스템이라고 불리는 스마트 시스템은 다양한 센서, 데이터 분석, 그리고 자동화를 사용하여 실시간 또는 시간에 걸쳐 기능과 성능을 향상시키는 현대적인 기술 솔루션입니다. 이러한 시스템은 환경에서 정보를 수집하고, 지능적으로 사용하며, 특정 목표 달성과 프로세스 최적화를 위해 결정하고 조치를 취합니다. 스마트 시스템은 산업 자동화, 스마트 공장, 에너지 관리, 스마트 도시, 교통, 스마트 홈 시스템, 의료, 환경 모니터링, 농업, 금융, 그리고 소매업과 같은 광범위한 응용 및 산업에서 찾을 수 있습니다. 스마트 시스템 시뮬레이션은 컴퓨터 기반 시뮬레이션을 사용하여 지능형 시스템의 행동과 성능을 모델링, 분석, 그리고 테스트하는 프로세스입니다. 이 접근 방식은 특히 자동화, 데이터 분석, 인공 지능, 그리고 의사 결정의 요소를 통합한 복잡한 시스템의 개발 및 개선에 유용합니다. 스마트 시스템 시뮬레이션은 시스템을 실제 세계에서 직접 테스트하는 것이 비현실적이거나 비용이 많이 들거나 위험한 경우에 특히 유용합니다.
Practical skills:
Flexsim (https://www.flexsim.com/)
Use various simulation software.
What are the Advantages of Enrolling in English Classes?
1. 포브스는 "영어를 유창하게 구사하는 근로자는 시간당 임금이 평균 34% 더 높고, 영어를 조금 하는 근로자는 영어를 전혀 하지 않는 근로자에 비해 13% 더 높다." 고 보도했습니다.
https://www.forbes.com/sites/davos/2010/05/28/it-pays-to-speak-english/?sh=1238a1b569bc
2. There are many free open access materials (books, useful websites, YouTube videos, free legal software etc.) available in English language.
ChatGPT & Google Bard AI chatbots
