25148 – Practical Computing (실용전산)

이 과정은 다양한 기능을 사용하여 소프트웨어 MS Excel 에서 차트를 묘사 할 뿐만 아니라 데이터를 만드는데 중점을 두고 공학/기술 문제를 해결하고 실제적인 컴퓨터프로그램 기술을 개발하는 것을 목표로 하고 있다.

Are you tired of using Excel for basic tasks like adding and sorting data? Do you want to unleash the full potential of this powerful tool and use it to solve complex problems, analyze data, and create stunning charts and graphs? Then this course is for you!

In this course, you will learn how to use Excel to its full potential and tackle various problems. You'll learn to use advanced functions and formulas, analyze statistical data, create beautiful charts and graphs, and develop your own user-defined functions using VBA programming language.

But that's not all! You'll also have the chance to study the mathematical modeling process and explore other mathematical methods that can be applied in Excel. So don't miss out on this opportunity to become an Excel expert and take your skills to the next level!

Objectives:

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

• Master advanced functions and formulas to solve complex problems

• Use Excel 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 the mathematical modeling process and other mathematical methods that can be applied in Excel

• 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: 20%

• Assignments: 10%

• 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/