VBA程式設計 — 儀器分析數據的程式設計
VBA programming for instrumental analysis
學期
112-2
學分
2
學分
當期課號
132904
永久課號
LSBM30001
開課單位
生化暨分子生物研究所
授課教師
蔡有光、廖辰中
校區
陽明
類別
選修
上課時間表
| 節 | 週五 |
|---|---|
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
週次計畫
| 週次 | 主題 |
|---|---|
| 第 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 週 | 民族掃墓節 |
| 第 8 週 | How can I write text files with the needed info? |
| 第 9 週 | How can I read data from instruments? |
| 第 10 週 | How can I compare two data sets? |
| 第 11 週 | How can I save my data in text files? |
| 第 12 週 | How can I simulate ion clusters - Cn, Hn, Nn databases |
| 第 13 週 | How can I simulate ion clusters - On databases |
| 第 14 週 | How can I simulate ion clusters - Sn databases |
| 第 15 週 | How can I simulate ion clusters - Peak merging algorithm |
| 第 16 週 | Exercises |
| 第 17 週 | Exercise |
| 第 18 週 | Exercise |