VBA程式設計 — 儀器分析數據的程式設計
VBA programming for instrumental analysis
學期
111-2
學分
2
學分
當期課號
132202
永久課號
BEBL30001
開課單位
醫學生物技術暨檢驗學系
授課教師
蔡有光、廖辰中
校區
陽明
類別
選修
上課時間表
| 節 | 週五 |
|---|---|
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/11 and Office 2021 ready