VBA程式設計 — 儀器分析數據的程式設計
VBA programming for instrumental analysis
學期
110-2
學分
0
學分
當期課號
D176
永久課號
B0536
開課單位
醫學生物技術暨檢驗學系
授課教師
廖辰中、蔡有光
校區
陽明
類別
選修
上課時間表
| 節 | 週五 |
|---|---|
3 10:10–11:00 | VBA程式設計 — 儀器分析數據的程式設計 YL404（陽明） 2 節連堂 |
4 11:10–12:00 |
* 根據陽明交大上課時間表所列
概述
How to process text information How to write data in text file How to process numbers
先修科目
教師未提供此項資料
備註
無備註
教學方式
To introduce basic computer programming to biologists who need to deal with large amount of information in their research; To help the users to understand the information produced by instruments
評分方式
Homework 90% Attendance 10%
課程大綱
教師未提供此項資料
週次計畫
| 週次 | 主題 |
|---|---|
| 第 1 週 | Where can I find Microsoft Excel VBA? |
| 第 2 週 | How can I get a text line from the text file? |
| 第 3 週 | How can I get numbers and strings from the text line? |
| 第 4 週 | How can I get paragraphs from several lines? |
| 第 5 週 | How can I remove unwanted info from the lines |
| 第 6 週 | How can I read large amount of the text information? |
| 第 7 週 | How can I write text files with the needed info? |
| 第 8 週 | How can I read data from instruments? |
| 第 9 週 | How can I compare two data sets? |
| 第 10 週 | How can I save my data in text files? |
| 第 11 週 | How can I construct causation databases from the literature? - Principle |
| 第 12 週 | How can I find a causation item in the paragraph? |
| 第 13 週 | How can I find causation items in the entire paper? |
| 第 14 週 | How can I construct causation databases from the literature? - Practice |
| 第 15 週 | How can I produce a molecular model using causation database? |
| 第 16 週 | Exercise |
| 第 17 週 | Exercise |
| 第 18 週 | Exercise |
教科書
Please bring your own laptop with Windows 10 and Office 2019 ready
Office Hours
- 地點
- 教師未提供此項資料
- 時間
- 教師未提供此項資料
- 聯絡方式
- 教師未提供此項資料