Databases and Lists with Calculation Mechanisms
Created by David Alderoty © 2011, David@TechForText.com
To contact the author use the above email address or
left click on these words for a website communication form.
This website provides free of charge, 14 databases and 9 lists with various types of calculation mechanisms, such as for statistics, algebra, calculus, etc. The databases and 9 lists are located on 14 websites that contain over 22,000 words of information and instructions. This webpage provides links to the 14 websites, as well as direct links to most of the databases and lists, with brief descriptions on each device. (If you want definitions and other information about these devices left click on these words.) I created all of the above, including this website, in a four or five month period, from March to August, 2011. To access the devices, or for additional information, scroll down and browse through the headings and subheadings, or go to the table of contents of this website, by left clicking on these words.
Website Links and Download Links for the Databases, and Lists
NOTE: The 14 DATABASES and 9 LISTS are available in one or more of the following: JavaScript, Microsoft Excel 2003, Excel 2007-2010, and OpenOffice Calc. The JavaScript devices, function online directly from the Internet, but the Excel and OpenOffice Calc devices must be downloaded first and use with a computer that has Microsoft Windows. To open or download a device left click on a blue link. The main websites have additional links and download options.
WEBSITE 1) and The One‑Year Appointment Book Generator
This device is comprised of a LIST of formulas, and its website is located at: www.TechForText.com/AppointmentBookGenerator The One‑Year Appointment Book Generator is a practical device that generates an appointment book with 368 dates, as soon as the user enters a start date, and left clicks with the mouse. The headings and the time intervals displayed on the 368 dates can be changed from one central location to fit the personal needs of the user.
The 368 page Appointment Book Generator is available in Microsoft Excel 2003, Microsoft Excel, 2007-2010, and OpenOffice Calc. If you want the One-Year Appointment Book Generator, in all the formats mentioned above, in a single zip folder, left click on these words. The files should be removed from the zipped folder before they are used.
The main website for the Appointment Book Generator has a hyperlinked table of contents, and over 4000 words explaining some of the techniques I used to create this device. The one-year appointment book required over 10,500 formulas to create. The formulas are very simple, but this project is extremely complex, because of the large number of highly complex links between the 10,500 formulas. If you want to download a Microsoft Excel document that displays each formula and its exact location in the Appointment Book Generator, left click on these words. Note: this document looks almost identical to the One-Year Appointment Book Generator, when it opens, but if you scroll down you will see over 10,500 formulas, which are displayed on 368 pages.
WEBSITE 2) The Averaging Calculator and Averaging‑Database
The Averaging Calculator calculates the average of a LIST of numbers, with a without names, entered by the user. The Averaging‑Database performs the same calculations, but is classified as a DATABASE. If you want a printer friendly online version of the Averaging‑Calculator left click on these words The main website for Averaging Calculator and Averaging‑Database is: www.TechForText.com/AveragingCalculatorAndDatabase This website contains over 6000 words, about the Averaging Calculator, and a series of experiments I used to overcome technical limitations of software I was using to create the JavaScript version of this device. The website also has a hyperlinked table of contents.
WEBSITE 3) Correlation‑Calculator
This device performs calculations on two LISTs of numbers, with or without names, entered by the user, to determine the degree of correlation between the two lists. (That is it calculates the correlation coefficient for two data sets.) The website for this device is: www.TechForText.com/Correlation-Calculator This website is very small, and it only contains the Correlation‑Calculator in the JavaScript online format.
WEBSITE 4) Mathematics‑Problem‑Generators
This website www.TechForText.com/Mathematics-Problem-Generators has information about six calculation devices I created that are designed to generate mathematics exercises, to help students practice solving math problems. However, the main focus of this website is on one of these devices, which is the Basic Algebraic Equation Generator. This device is comprised of a LIST of 12 calculation mechanisms, that receive numbers from the same set of input boxes. A printer friendly version of this device is located at www.TechForText.com/Algebraic-Equation-Generator
You can download five versions of the Basic Algebraic Equation Generator, in one zipped folder, for Microsoft Excel 2003, Excel 2007-2010, OpenOffice Calc, and JavaScript, by left clicking on these words. These file should be removed from the zip folder, before you use them.
The following set of files is similar to the above, but they have an additional feature, called the Random Number Generator. You can download five versions of the Basic Algebraic Equation Generator, with the Random Number Generator, in one zipped folder, for Microsoft Excel 2003, Excel 2007-2010, OpenOffice Calc, and JavaScript, by left clicking on these words. These file should be removed from the zip folder, before you use them. You can open an online JavaScript version of the Basic Algebraic Equation Generator, with the Random Number Generator, by left clicking on the following link: www.TechForText.com/Mathematics-Problem-Generators/1
WEBSITE 5) The Basic Integral Calculus Generator
This device is comprised of a LIST of 12 calculation devices that receive numbers from the same set of input boxes, and its website is www.TechForText.com/IntegralCalculusGenerator This website contains over 4000 words, on the Basic Integral Calculus Generator. The Integral Calculus Generator is a practical device, designed to help students practice solving basic integrals. For an online printer friendly version of the Basic‑Integral‑Calculus Generator left click on the following link www.TechForText.com/IntegralCalculusGenerator/1
You can download the above in a number of formats, in one zipped folder, by left clicking on these words. This includes file formats for Microsoft Excel 2003, Excel 2007-2010, OpenOffice Calc , and JavaScript versions. These file should be removed from the zip folder, before you use them.
WEBSITE 6) The Trig‑Integral‑Calculus‑Generator
This device is comprised of a LIST of 12 calculation devices that receive numbers from the same set of input boxes, and its website is www.TechForText.com/Trig-Integral-Calculus-Generator The Trig‑Integral‑Calculus‑Generator is a practical device, designed to help students practice solving trigonometric integrals involving sine and cosine. For an online printer friendly version of the Trig‑Integral‑Calculus‑Generator left click on: www.TechForText.com/Trig-Integral-Calculus-Generator/1 This is a practical device, designed to help students practice solving integrals with sine and cosine. If you want the above for Microsoft Excel 2003 left click on these words.
If you want the above for Microsoft Excel 2007-2010, left click on these words.
If you want the above for OpenOffice Calc, left click on these words.
If you want the above in JavaScript, left click on these words.
All of the above files are in a zipped folder, and they should be removed from the folder, before you use them. For instructions, additional information and links go to the main website for this device: www.TechForText.com/Trig-Integral-Calculus-Generator
WEBSITE 7) The Tangent‑Cotangent‑Integral-Calculus‑Generator
This device is comprised of a LIST of 12 calculation devices that receive numbers from the same set of input boxes, and its website is www.TechForText.com/Tangent-Cotangent-Integral-Calculus
This is a practical device, designed to help students practice solving integrals with tangent and cotangent. For an online printer friendly version of the Tangent-Cotangent-Integral-Calculus-Generator left click on: www.TechForText.com/Tangent-Cotangent-Integral-Calculus/1
If you want the above in one zipped folder, for Microsoft Excel 2003, Excel 2007-2010, OpenOffice Calc, and JavaScript left click on these words. These file should be removed from the zip folder, before you use them. For instructions, and additional information and links go to the main website for this device.
WEBSITE 8) The Secant‑Cosecant‑Integral‑Calculus‑Generator
This device is comprised of a LIST of 12 calculation devices that receive numbers from the same set of input boxes, and its website is www.TechForText.com/Secant-Cosecant-Integral-Calculus
This is a practical device, designed to help students practice solving integrals with secant and cosecant. For an online printer friendly version of the Tangent-Cotangent-Integral-Calculus-Generator left click on: www.TechForText.com/Tangent-Cotangent-Integral-Calculus/1
If you want the above in one zipped folder, for Microsoft Excel 2003, Excel 2007-2010, OpenOffice Calc, and JavaScript versions, left click on these words. These file should be removed from the zip folder, before you use them. For instructions, and additional information and links go to the main website for this device.
WEBSITE 9) The Double‑Integral‑Calculus‑Generator
This device is comprised of a LIST of 12 calculation devices that receive numbers from the same set of input boxes, and its website is www.TechForText.com/Double-Integral-Calculus-Generator This is a practical device, designed to help students practice solving double integrals. For an online printer friendly version of the Double-Integral-Calculus-Generator left click on: www.TechForText.com/Double-Integral-Calculus-Generator/1
You can download six versions of the Double-Integral-Calculus-Generator, in one zipped folder, for Microsoft Excel 2003, Excel 2007-2010, OpenOffice Calc, and JavaScript, by left clicking on these words. These file should be removed from the zip folder, before you use them. For instructions, and additional information and links go to the main website for this device.
WEBSITE 10) Calculating‑Databases Website with 12 Excel Databases
This website www.TechForText.com/Calculating-Databases has 12 Excel databases with an alphabetizing function, and some type of a calculation mechanism, such as for statistical calculations. To download the Excel databases, and for additional information go to the main website, which is listed above. This website contains over 4500 words of descriptive text and instructions, and it has a hyperlinked table of contents. All the Excel databases from this website are in two file formats, one for Microsoft Excel 2003, and the other for Excel 2007-2010. There are two additional databases link to this website, (Averaging‑Database from WEBSITE 2, and the Database Scientific Calculator, from WEBSITE 14)
The following 4 websites have JavaScript databases that function online. The websites and the calculation devices they contain can be accessed through links on the Calculating-Databases Website, as well as the links listed below.
WEBSITE 11) The online JavaScript Average‑Score‑Database‑Calculator
This website is very small, www.TechForText.com/Average-Score-Database-Calculator, and it contains a calculation device that calculates an average score, and an individual score, based on percent of the average, when a set of names or labels are entered with scores. The individual scores are calculated with the following formula, by the mechanism in the software.
100%(Individual Score/Average)= %of Average Score
The above formula is the same as: 100 multiplied by, the individual score divided by the average score. The above formula is applied to each score entered. The formula converts each score into a percentage based on the average, such that an average score is 100%, a score below averages less than 100%, and a score above average is greater than 100%. This is similar to the way IQ scores are represented.
WEBSITE 12) The Online JavaScript Maximum‑Score‑Database‑Calculator
This website is very small, www.TechForText.com/Maximum-Score-Database-Calculator and it contains a calculation device that calculates individual scores, by comparing each score with the maximum score, in terms of percent, when a set of names or labels are entered with scores. To do this, the software uses the following formula:
100%( Individual Score/Maximum Score)= % of Maximum Score
The above formula is the same as: 100 multiplied by, the individual score divided by the maximum score. With this formula, the maximum score is always 100%, and any score that is less than the maximum will be less than 100%.
WEBSITE 13)The Online JavaScript Score‑Database‑Calculator
This website is very small, www.TechForText.com/Score-Database-Calculator and it contains a calculation device that calculates individual scores, in terms of a percent of a standard score. The user enters a score that is to be used as a standard score. The software uses the following formula for the calculations:
100%( Individual Score/ Standard Score) = % of Standard Score
The above formula is the same as: 100 multiplied by, the individual score divided by the Standard Score. With this formula, any score that is above the standard score will be greater than 100%, and any score that is below the standard score will be less than 100%. Any score equal to the standard score is 100%.
WEBSITE 14) The Database Scientific Calculator
The Database-Scientific-Calculator is a multifunction calculation device, with three built-in databases, for mathematical functions, for instructional text, and for equivalent spreadsheet formulas. The website for this device is www.TechForText.com/Database-Scientific-Calculator For an online printer friendly version of the Database-Scientific-Calculator left click on the following link: www.TechForText.com/Database-Scientific-Calculator/1 The Database-Scientific-Calculator is also available for download, in Microsoft Excel 2003, Excel 2007-2010, OpenOffice Calc, and JavaScript formats, by left clicking on the following link. You can download all of the above, in one zip folder, by left clicking on these words. The file should be removed from the zip folder before they are used.
The Database-Scientific-Calculator can perform all of the following calculations: addition; subtraction; multiplication; division; logarithms with any base, including e; hyperbolic and trigonometric calculations, for sine, cosine, tangent, cotangent, secant, and cosecant, with angles in degrees or radians. It also has built-in formulas to calculate the perimeter and area of a circle, the surface area and volume of a sphere. The Database-Scientific-Calculator has 50 functions, but 14 are experimental. These functions provide a utility similar to a scientific calculator. However, I created the Database-Scientific-Calculator, primarily as an experiment, TO DEMONSTRATE A NEW TYPE OF CALCULATION DEVICE.
The Database-Scientific-Calculator has three built-in databases that operate as a single unit, for mathematical operations, to display equivalent spreadsheet formulas, and to display instructions and general information. The three databases are concealed from the user, but the search box and the results of the search are visible to the user.
On the surface, the Database-Scientific-Calculator does not appear to be any better than a $75 handheld scientific calculator. However, if we examine the details there are very significant differences between a conventional scientific calculator, and the Database-Scientific-Calculator. A calculation device such as the Database-Scientific-Calculator can be designed and built with thousands of functions, and tens of thousands of words of instructional material for the user. The calculation devices built with this design concept can perform highly complex calculations with Mega formulas. Devices such as the Database-Scientific-Calculator can be designed and built to perform computations with letters and text, but I did not test this extensively. There is no doubt that it can retrieve text stored in its database, in response to a word, symbol, a sentence, or a question.
A conventional scientific calculator, or any other device that I know of cannot do all of the above, in one operation. (Perform a calculation with a function retrieved from its database, display instructions related to the calculation for the user, and display an equivalent spreadsheet formula for the calculation.)
If you want to go to the top of the website, left click on these words.
Definitions and other Information for the Databases and Lists
As the terminology is used on this website, a database is a device for storing records, with a retrieval mechanism to assist in accessing specific records. (A record is a set of related data or information, such as an individual's name, address, and phone number. Medical records are another example, which traditionally are filed in a hard copy format, but can be filed in a database.) The retrieval mechanism in most of the Excel databases, provided through this website, consists of an alphabetizing mechanism, which can arrange data alphabetically, from A to Z or from Z to A. Some of the databases provided from this website have a search mechanism, which is similar to a simple search engine. That is the name you are looking for is entered in the search box, and the record associated with the name is retrieved and displayed. The JavaScript databases have this function. Three of the Excel databases have both of the above.
All of the databases provided through this website have some type of built-in calculation mechanism that I created. This can range from devices that simply count the number of blank spaces and the number of entries in a database, to relatively complex calculation mechanisms that perform various types of statistical calculations.
As the terminology is used here, a list is a set of records, arranged in columns, which can consist of text, formulas, numbers, calculation devices, or any type of data that can be recognized, by either humans or the computer. The databases provided by this website are essentially lists with retrieval mechanisms.) The calculation mechanisms in the lists vary widely, depending on the purpose of the device.
This concept can be somewhat confusing, so I will provide the lists available from this website as examples. The One-Year Appointment Book Generator, is a list of formulas that generate 368 dates, on 368 pages, to create an appointment book that is useful for 368 days. The Averaging Calculator is a device that stores one list consisting of numbers, or numbers and names, and it calculates the average number. The Correlation-Calculator, is a device that stores two list with s consisting of numbers, or numbers and names, and performs calculations to determine the degree of correlation between the two lists. The following six devices each have a list of 12 calculation devices, for generating 12 mathematics exercises, to help students practice mathematics.
· Basic Algebraic Equation Generator
· The Basic Integral Calculus Generator
· The Trig‑Integral‑Calculus‑Generator
· The Tangent‑Cotangent‑Integral-Calculus‑Generator
· The Secant-Cosecant-Integral-Calculus-Generator
· The Double-Integral-Calculus-Generator
Most of the devices provided through this website have practical applications. For example, six of the devices I created are designed to help students practice solving: algebra problems, single integrals, trigonometric integrals, and double integrals. Another device generates one-year appointment books that have many practical uses. A number of the devices I created serve as online calculation devices, such as to calculate averages, and the correlation coefficient of two data sets. The Excel databases I created come in a number of varieties, and they have many practical uses, ranging from storing contact information, to calculating classroom grades based on test scores.
Reusable Template Format for Devices in Microsoft Excel and Openoffice Calc
All the devices from this website, in the Microsoft Excel and OpenOffice Calc formats, are in a reusable template format. That is each time you left click on the template it generates a new device. The templates are NOT consumed by continuous use, and you can produce a limitless number of devices from one template. The devices that are produced from the template of course require Microsoft Excel or OpenOffice Calc, but they can function without the original template.
When you left click on a template to create a new device you must save the resulting device with a new filename. Choose a filename that will help you and others easily identify the device.
If you want to go to the top of the website, left click on these words.
Design Concepts and Services Offered by the Author
Design Concept to Maximize User‑Friendliness: For the Website and For The Databases and Lists
I designed the calculating databases and lists, and this website in a way that would maximize efficiency and ease-of-use. The calculating databases and lists have instructions placed next to related input cells, and it is laid out with a simple structure, with large fonts. The website similarly has large fonts, with a relatively simple structure, and clearly written instructions.
The website is on one long webpage. This provides the convenience of scrolling down or up, from one section to another, and it avoids the unnecessary complexity of pull-down menus, and links to go from one page to another. However, I provided a hyperlink table of contents as an alternative way of navigating the website, located on the bottom of this webpage.
I structured each sentence with the goal of minimizing confusion, and maximizing comprehension, for users with varying levels of technical knowledge. In this regard, perfection is never possible, because users come from diverse technical, cultural, and linguistic backgrounds.
I provided many headings and subheadings throughout this text. This allows the user to easily skip material that they find difficult, or uninteresting. The headings and subheadings are also displayed in the table of contents.
Services Offered by the Author David Alderoty
I design and build user-friendly software based calculation devices for arithmetic, accounting, currency exchange rates, algebra, trigonometry, correlations, calculus, and databases with built-in calculation devices. I also create attractive online calculation devices for websites. I generally make these devices in the Microsoft Excel, OpenOffice.org, and the JavaScript formats, but I can work with other spreadsheet formats besides the above. I also create web communication forms in JavaScript for websites. This includes forms with built-in calculation devices.
I write instructions for the devices I build. I can also write instructions for software and computer devices created by others. In addition, I can write advertising for your websites, products and services.
For a list of websites with calculation devices that I created, left click on these words, or go to the following website: www.TechForText.com/Math For a list of all the services I offer see www.TechForText.com For a list of all my websites see www.David100.com My resume is online at: www.David100.com/R
I can provide the services mentioned above on a fee-for-service basis, or possibly based on temporary or permanent employment. If you are interested in my services, and want additional contact information or more data on the services I offer, you can email me at David@TechForText.com or use a website communication form, by left clicking on these words.
I am located in the USA, New York City. If you are a great distance from my locality or are in another country, this is not important. I can provide the above services worldwide, because the software and the writing services I offer can be delivered through the Internet to any locality, providing there are no governmental restrictions.
If you want to go to the top of the website, left click on these words.
SCROLL DOWN FOR THE TABLE OF CONTENTS OF THIS WEBSITE
Introduction to The Hyperlink Table of Contents of this Website
This website is more or less laid out like a book, but it is on one long webpage. You can scroll up or down to go from one topic to another. However, if you want to examine all the sections and subsections of this website, use the hyperlink table of contents, below this paragraph. To go to any section or subsection of this website you can left click on the blue words that relate to the material you want to read. The subsections are in uppercase letters.
If you want to go to the top of the website, left click on these words.
Table of Contents of this Website Contents
Website Links and Download Links for the Databases, and Lists
WEBSITE 1) and The One‑Year Appointment Book Generator
WEBSITE 2) The Averaging Calculator and Averaging‑Database
WEBSITE 3) Correlation‑Calculator
WEBSITE 4) Mathematics‑Problem‑Generators
WEBSITE 5) The Basic Integral Calculus Generator
WEBSITE 6) The Trig‑Integral‑Calculus‑Generator
WEBSITE 7) The Tangent‑Cotangent‑Integral-Calculus‑Generator
WEBSITE 8) The Secant‑Cosecant‑Integral‑Calculus‑Generator
WEBSITE 9) The Double‑Integral‑Calculus‑Generator
WEBSITE 10) Calculating‑Databases Website with 12 Excel Databases
WEBSITE 11) The online JavaScript Average‑Score‑Database‑Calculator
WEBSITE 12) The Online JavaScript Maximum‑Score‑Database‑Calculator
WEBSITE 13)The Online JavaScript Score‑Database‑Calculator
WEBSITE 14) The Database Scientific Calculator
Definitions and other Information for the Databases and Lists
Reusable Template Format for Devices in Microsoft Excel and Openoffice Calc
Design Concepts and Services Offered by the Author
Design Concept to Maximize User‑Friendliness: For the Website and For The Databases and Lists
Services Offered by the Author David Alderoty
Introduction to The Hyperlink Table of Contents of this Website