25148 – Practical Computing (실용전산)

데이터를 추가하고 정렬하는 일이나 간단한 계산기와 같은 기본적인 작업에 전자 스프레드시트를 사용하는 것에 싫증이 나셨나요? 이 강력한 도구의 잠재력을 최대한 발휘하여 복잡한 문제를 해결하고, 데이터를 분석하고, 놀라운 차트와 그래프를 만드는 데 사용하고 싶으신가요? 그렇다면 이 과정은 여러분을 위한 것입니다.

이 과정에서는 엑셀, 구글 스프레드시트, 다양한 AI 챗봇 및 기타 프리웨어 소프트웨어(총 20여 개 도구)를 활용하여 다양한 문제를 해결하는 방법을 배웁니다. 고급 기능 및 공식 사용법, 통계 데이터 분석, 아름다운 차트 및 그래프 생성, VBA 프로그래밍 언어를 사용한 사용자 정의 기능 개발 방법을 배울 수 있습니다.

뿐만 아니라 수학적 모델링 과정도 공부하고 전자 스프레드시트에서 사용될 수 있는 다른 수학적 방법도 탐구할 기회가 주어집니다. 전자 스프레드시트 전문가가 되어 여러분의 기술을 한 단계 더 발전시킬 수 있는 이번 기회를 놓치지 마세요! 

Tired of using electronic spreadsheets for basic tasks like adding and sorting data or a simple calculator? Do you want to unlock the full potential of these powerful tools and use them 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, Google Spreadsheets, various AI chatbots and other freeware software (around 20 tools in total) 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 used in electronic spreadsheets. So don't miss this opportunity to become an electronic spreadsheet expert and take your skills to the next level!

Objectives:

• Learn how to use various AI chatbots (ChatGPT, Google Bard, etc.).

• Transform spreadsheets from a simple data tool into a problem-solving powerhouse

• Master advanced functions and formulas to solve complex problems

• Use spreadsheets for sophisticated data analysis and visualisation

• Create professional-quality charts and graphs to communicate your data clearly

• Learn to develop custom functions using VBA, Excel's programming language

• Explore the mathematical modelling process and other mathematical techniques that can be created in spreadsheets

• Consultations on request on Monday (by appointment via the EDWARD system).

• I'm happy to arrange times to meet individually in Zoom. Just let me know! 

• Q&A during classes.

• Answering questions on Facebook (I am here).

• Answering questions by e-mail.

• Be punctual: Being late to class disrupts the learning environment for yourself and your classmates. Please make an effort to arrive at class on time and be considerate of your fellow students.

• Keep your phone on silent: Turn off the sound and vibration on your phone and put it away during class. 

• Get permission to leave class: If you need to leave class early or absent yourself, ask the professor first. This helps ensure you don't miss any important information or disrupt the class.

• Stay awake and engaged: Do your best to stay awake and focused during class. If you find it difficult to stay awake, try sitting up front or finding ways to engage with the material.

• Ask questions: If you have questions or need clarification on a topic, don't hesitate to ask. This is a great way to ensure that you understand the material and can actively participate in class discussions.

• Be considerate of your classmates: Avoid distracting or annoying your classmates, such as talking during lectures or playing games on your phone. Be respectful of their right to learn and concentrate.

• Seek help if you have problems with the attendance app: If you are having trouble with the attendance app or any other technical problems, don't hesitate to reach out to your department or college office for help.

• Certificates of absence: To ensure that your certificate of absence is properly recorded and accounted for, please submit it only through the EDWARD system. 

• Homework submission: To ensure that your homework is properly submitted and graded, please use the CTL system. 

• Attendance: 10%

• Assignments: 20%

• Midterm exam: 30%

• Final exam: 40%

• Learned engineering terms (glossary) will be helpful for your future international cooperation. This might be very useful to you to become more successful in the future as languages play an essential role in the collaboration between countries and companies. As we all know, South Korea is an export-oriented country. Knowledge of English and other UN's official languages will strengthen you as a specialist.

• It can be used to understand curve modeling better in a Computer-Aided Design (CAD) course.

• Excel can be useful for managing and analyzing data in various fields, including business, finance, marketing, and science.

• It can be used to create professional-looking charts, graphs, and tables to visualize and communicate data.

• Students proficient in Excel may have an advantage in job searches, as it is a commonly used tool in many industries.

• Excel can be used in statistical analysis and data visualization, which can be helpful for students pursuing careers in data science, machine learning, and artificial intelligence.

• It can be helpful to project management, as it can be used to create Gantt charts and track project progress.

• Excel can be a valuable tool for planning and budgeting, as it can create financial models and forecast future performance.

• It will help you improve your IQ (future jobs will need two crucial qualities: intelligence and creativity).

Mathematics and Computing | 수학과 컴퓨터

1. Scilab | https://www.scilab.org/ 

2. OCTAVE | https://www.gnu.org/software/octave/ 

3. GeoGebra | https://www.geogebra.org/  | Online GeoGebra | GeoGebra 3D Calculator

Electronic Spreadsheets | 스프레드시트

1. 스프레드시트 | https://www.google.com/sheets/about/ 

2. AirTable | https://airtable.com/ 

3. Zoho | https://www.zoho.com/sheet/ 

4. VisiCalc | Download

5. 1-2-3 Lotus | Download

1. Complete list | https://support.office.com/en-us/article/excel-functions-by-category-5f91f4e9-7b42-46d2-9bd1-63f26a86c0eb 

2. https://www.excelfunctions.net/excel-functions-list.html 

3. https://corporatefinanceinstitute.com/resources/excel/functions/ 

4. https://exceljet.net/formulas 

5. https://exceljet.net/excel-functions 

6. https://bettersolutions.com/excel/functions/complete-list.htm 

7. https://www.techonthenet.com/excel/formulas/index.php 

8.  Excel functions (with live examples and videos) | https://trumpexcel.com/excel-functions/