ScienceCube
Home > Education Information > MBL using Excel
 
 
 
We explain the way of use of MBL using Excel. Also you can do more various MBL experiment using Excel VBA (Visual Basic Application). If you use Excel-VBA, then you can make experiment files that are properly programmed to contents and use them.
 
  The practical utilization technology of MBL experiment using Excel
 
If you click the following subjects, you can see the detail contents. You can use the powerful and various worksheet function and graph function of Excel in ICT experiment education. Also, the source of Excel VBE program is open to everyone, so he/she can program easily.

No

The subject of utilization technique of Excel MBL (Advanced)

Detail description

1

[VBE] Using Excel-VBA

 Excel macro using VBE, Checking security level

2

[VBE] Doing an experiment of event with entry


Data can be recorded only when events occurs
(Example : Ohm's Law while increasing the number of batteries)
 

The below subject is the way of practical use of Excel for scientific experiment.

No

The subject of utilization technique of Excel MBL (General)

Detail description

1

Collecting data wile experiment

Collecting data in real time in Excel

2

Doing an experiment with changing the data format

Displaying the cell after changing the format of it(type, size, font, color)

3

Doing an experiment with real time graph

Doing experiment making the data appeared on the graph automatically in the middle of experiment using chart wizard
 

4

Doing an experiment with real time X-Y graph


Doing an experiment with X-Y graph of which X axis is not time but other physical quantities
 

5

Doing experiments simultaneously with three kinds of subjects


We can do an experiment with 2~3 experiment subjects simultaneously and measure three different physical quantities in a subject.
 

6

Doing several times of experiments


Moving and copying the cell of sheet, and saving the experiment data in other worksheet

7

Doing experiment applying formular reference

Doing experiment applying formular to the cell of worksheet

8

Applying formular to data and Analyzing them

Doing experiment and analyzing applying formular to the cell of worksheet

9

Making experiment files of worksheet for students


After defining a real time graph or formular analysis in the worksheet in advance using chart wizard and saving it as a file, students can do experiment even though they don't know how to use Excel
 

10


Analyzing the results from several times of experiments in a graph
 

Displaying the results from several times of experiments in a graph and analyzing them using chart wizard

11

Real time comparison experiment


Doing comparative experiment by several repeated experiment in real time on the previous experiment graph