Updated 08/12/04
MSDE CORE Learning Goals - Science 1. Goal 1: Skills and Processes 1. Expectation 4: The student will demonstrate that data analysis is a vital aspect of the process of scientific inquiry and communication 1. Indicator 6: The student will use spreadsheet, graphing, and database programs and probeware on computers and/or graphing calculators 2. Expectation 5: The student will use appropriate methods for communicating in writing and orally the processses and results of scientific investigation 1. Indicator 1: The student will demonstrate the ability to summarize scientific concepts, processes and data through written communications 2. Indicator 5: The student will use computers and/or graphing calculators to produce tables, graphs and spreadsheet calculations 2. Goal 4: Concepts of Chemistry 1. Expectation 2: The student will explain that all matter has structure and the structure serves as a basis for the properties of and the changes in matter 1. Indicator 2: The student will demonstrate that the arrangement and number of electrons determines the properties of an element and that these properties repeat in a periodic manner illustrated by their arrangement in the periodic table The Periodic Table program really consists of several kinds of files. The first set, called Properties in the Contents file, are the databases. Currently there are 21 databases available. Each of these is an executable file (.m) but they are really nothing more than lists. Each file has the same format - a few lines to explain the property and give the units, followed by 106 lines. Each line contains the name of the variable, the atomic number of the element and the value of the property. Here is the first part of the Density file: % Density.m creates Densities of solid elements (kg/m3) % 0 for those not available Density(1) = 76.0; Density(2) = 124.8; Density(3) = 534; Density(4) = 1847.7; Density(5) = 2340; Density(6) = 3513; Density(7) = 1026; Density(8) = 2000; Density(9) = 1516; Note that the first two lines are commented out (% signs tell MATLAB not to execute those lines). Then each line repeats the name of the property, followed by the atomic number in parentheses and then the value for the property. Thus "Density(2) = 124.8; means that the Density of Helium is 124.7 kg/m3. Some property values are unknown for some elements, and most files have a line which explains the value substituted for the unknown value. This is important, as all these databases must be the same length and must have some value in them. It is a simple matter to change data in these files. The files can be opened by any word processing program and edited, then saved as text files. If a teacher desired to change this file, they would edit the appropriate line, for example Density(2) = 133;, then save the file as a text file called dens.m, the original name of the file. If a teacher wants to create a new file, they can use an old file and the find/change option of the wordprocessor to change the property names. Then they would need to enter the values of the property. The following properties are avaiable: Property Property Name File name Abundance abund ab.m Atomic radius Atomicrad atomicr.m Boiling Point BoilingPt bpt.m Covalent Radius Covrad covr.m Discovery Date Date date.m Density Density dens.m Electron Affinity ElecAff elecaf.m Electronegativity ElecNeg elecneg.m (Pauling) Group Group group.m Heat of Formation hform hform.m Heat of Fusion hfus hfus.m Heat of Vaporization hvap hvap.m Ionic Radius IonRad ionrad.m Ionization Energy ionE ion.m Number of Isotopes Iso iso.m Melting Point MeltingPt mpt.m Nuclear Charge NucChrg nucchrg.m (Slater) Number of Radioactive RadIso radiso.m Isotopes Symbol Symbol symbol.m Thermal Conductivity TherCond thercon.m Atomic Weight AtomWt weight.m In addition to the property databases, there is a file noble.dat, which contains the data necessary to graph vertical lines at the end of each period on the table. This helps students to see periodicity in the properties. Initialization Routines There are two programs which muct be run to initialize the Periodic Table program. The program makeptab.m reads all the data files and saves them as ptable.mat. makeptab.m only needs to be run when there is a change in one of the databases or a new database has been added. makeptab.m must be edited to include the name of any new databases. ptable.mat is a binary file which cannot be directly read or edited. Likewise, maketab.m read tabrec.dat and creates tabrec.mat, another binary file which contains the data for drawing a periodic table. Again, this program only needs to be run once, unless there is a change to tabrec.dat. If the versions of tabrec.mat and ptable.mat are on the computer and are the current versions, the program initTab, loads these two files into the current memory. Thus the data is avaliable for the student. In summary, makeptab and maketab need to only be run once to establish the files ptable.mat and tabrec.mat. Once these two files are on the computer, the user only needs to run initTab. This will load the files and return a list of the variable names. The following programs each hold data of the listed type for the elements. Units (if known) are given in the text at the top of the file. These can be read directly, as they are text files. Functions The following "programs" are really functions which can be called for working with the periodic table data. These are invoked by simply typing the appropriate command in the command window. printp - draws the periodic table using thtabrec.mat file clickel - returns info about an element clicked - use this after printp surf2 - creates a 3d plot of the desired property This function has the format surf2(PropertyName, tabp); When first viewed, the axis running from left to right is period, the axis running from the left corner "into" the screen is group and the vertical axis is the property Programs, activities and Worksheets Teachers can choose to have their students work with the Periodic Table database using the commands of Matlab. Several sample worksheets and activities are included below to illustrate this approach. They may also choose to use one of the prewritten programs. These programs are