** **

**Calculation
software and databases, created with Microsoft Excel**

__by David
Alderoty © 2012__

** **

__To contact the author use: David@TechForText.com
or__

__left click on the link below
for a website communication form.__

**Link for a Website Communication Form**

** **

** **

**This website describes the SOFTWARE and DATABASES I created with
Microsoft Excel, in the summer of 2012. **The
software is in the JavaScript and Microsoft Excel format, and it is on TEN
websites, which are linked to this webpage. The software I created with Excel is
UNLIKE conventional spreadsheets, and many of these devices function over the
Internet, in conventional web browsers, and they perform sets of mathematical
calculation simultaneously, such as the following:

** **This
software can be obtained free of charge from the following ten websites, or
from the download links on this webpage. (The download links and detailed
descriptions of the software are presented below the list of websites.)

** **

__Website-1) A Calculation Device That Functions as a Calculus Tutorial For
Integrals with the Hyperbolic Sine snd Cosine____: __**www.TechForText.com/Sinh-Cosh**

** **

__Website-2) A Calculation Device That Functions as a Calculus Tutorial For
Integrals with the Hyperbolic Tangent And Cotangent____: __**www.TechForText.com/Tanh-Coth**

** **

__Website-3) A Calculation Device That Functions as a Calculus Tutorial For
Integrals with the Hyperbolic Secant and Cosecant____: __**www.TechForText.com/Sech-Csch**

** **

__Website-4) A Calculation Device for Hyperbolic-Functions____: __**www.TechForText.com/Hyperbolic-Functions**

** **

__Website-5) A Calculation Device That Functions as a Calculus Tutorial
for Triple Integrals____ __**www.TechForText.com/Triple-Integrals**

** **

__Website-6) A Calculation Device That Functions as a Tutorial for Solving
Algebraic Equations that have Hyperbolic Functions____ __**www.TechForText.com/Algebra-with-Hyperbolic-Functions**

** **

__Website-7) A Calculation Device That Calculates The Average, and a Few
Other Statistical Calculations____ __**www.TechForText.com/Online-Table-for-Calculating-the-Average**

__Website-8) Databases with Calculation Devices____: __**www.TechForText.com/Calculating-Spreadsheet-Databases**

__Website-9) A Multiple Calculation Device with A Semi-Random Number
Generator____: __**www.TechForText.com/Multiple-Calculation-Software-with-A-Semi-Random-Number-Generator-Based-On-Time**

__Website-10) Simplified Discussion, on How Microsoft Excel Can Be Used As
A Programming Language____: __**www.TechForText.com/L**

__Website-1) A Calculation Device That
Functions as a Calculus Tutorial__

__For Integrals with the Hyperbolic Sine snd
Cosine__

**TITLE OF WEBSITE:**

__A
Software-Based Tutorial On Calculus,__

__With
The Hyperbolic Functions Sinh And Cosh__

** **

**If you want a printer
friendly JavaScript version**

__of
the software left click on this link__

** **

**Left click here to download (Excel versions) in a zipped
folder**

**Remove the software from the folder before you use it**

__1) DESCRIPTION:____
The calculation device on Website-1 is designed to function as a tutorial, for
students to practice solving integrals, with the hyperbolic sine and
cosine(sinh and cosh).__ The calculation device-tutorial functions as soon as
the user enters two numbers, in two white input boxes, on the top of the
calculation device. When this is done, the software generates, ten integral
problems involving hyperbolic functions, with the numbers the user entered.
The calculated results for each problem are only revealed after the student
attempts to solve the problem, by entering the numbers he or she calculated,
into the input box of the problem in question. If the student entered the correct
answer, a message in green type is displayed. If the student entered an
incorrect answer, the software displays an error message in red type.

This software also has a device that keeps track of the number of correct calculations the student entered in the tutorial. There are 10 problems generated by the software, and for each correct calculation entered by the student, the counting device displays 10%

This software has another interesting feature, which allows the user to control the number of decimal places used in the calculations. Specifically, on the upper section of the software, there is a white input box, and related text that indicate how many decimal places are going to be used for the calculations. The users can change these settings, by deleting the number in the input box, and entering a number that represents the number of decimal places they prefer.

On
the very bottom of the software, there is a box to enter comments, and a submit
button. When the submit button is pressed, the entire calculation device,
along with the calculated results, and the comments, are transmitted to my
e-mail (David Alderoty). In addition, each of the ten problems, has its own
box to enter comments, but the submit buttons are located only on the bottom of
the software.

For students that need additional mathematics instruction, I
provided links under each problem to access the Wolfram
Alpha computer. This is a useful Internet resource, which can provide
step-by-step solutions to mathematics problems.

** **

** **

__Website-2) A Calculation Device That
Functions as a Calculus Tutorial__

__For Integrals with the Hyperbolic Tangent
And Cotangent__

**TITLE OF WEBSITE:**

__A Software-Based
Tutorial on Calculus,__

__With The
Hyperbolic Tangent and Cotangent__

** **

** **

**If you want a printer
friendly JavaScript**

__version
of the software left click on this link__

** **

**Left click here to download the zipped
folder**

**Remove the software from the folder
before you use it**

** **

__2) DESCRIPTION: The software on website-2 is similar to the
above, except it is a calculation device and tutorial for integrals involving
the hyperbolic TANGENT
and COTANGENT____. __

** **

** **

__Website-3) A Calculation Device That
Functions as a Calculus Tutorial__

__For Integrals with the Hyperbolic Secant
and Cosecant__

**TITLE OF WEBSITE:**

__An Online
Computer Tutorial on Calculus, __

__For The
Hyperbolic Functions Sech and Csch__

** **

**If you want a printer friendly version of the**

**JavaScript tutorial, without the introductory**

**and instructional text, left click on these words****.**

** **

**Left click here to download a zipped
folder**__ with Excel versions.__

**Remove the software from the folder
before you use it**

** **

__3) DESCRIPTION: The software on website-3 is similar to the
above, except it is a calculation device and tutorial for integrals involving
the hyperbolic SECANT and
COSECANT.__

** **

** **

__Website-4) A Calculation Device for Hyperbolic-Functions__

**TITLE OF WEBSITE:**

__An Online
Calculation Device For Hyperbolic Functions,__

__And Related
Mathematical Concepts__

** **

**www.TechForText.com/Hyperbolic-Functions**

** **

**For a
printer friendly JavaScript version of the above without**

__introductory
and instructional text, left click on these words.__

** **

**Left click here to download the zipped
folder, with Excel versions.**

**Remove the software from the folder
before you use it**

** **

**4) DESCRIPTION:**
The software on website-4, is a calculation device for calculating the
HYPERBOLIC: sine, cosine, tangent, cotangent, secant, and cosecant. The calculations
take place, as soon as the user enters a number in a white input box, and
clicks with the mouse. Each of the six calculations are performed in two ways,
one is with the Microsoft Excel’s built-in functions, and the other is with the
conventional formulas used for the hyperbolic functions, which are based on **e** (e = 2.718281828459050).

On the very bottom of this calculation device, there is a box to enter comments, and a submit button. When the submit button is pressed, the entire calculation device, along with the calculated results, and the comments, are sent to my e-mail (David Alderoty).

** **

** **

__Website-5) A Calculation Device That
Functions as a __

__Calculus Tutorial for Triple Integrals __

**TITLE OF WEBSITE:**

__Online
JavaScript Calculation Software__

__For A Calculus
Tutorial On Triple Integrals__

** **

**www.TechForText.com/Triple-Integrals**

** **

**For a
printer friendly JavaScript version of the tutorial,**

__without
introductory text, left click on these words.__

** **

**Left click here to download a zipped folder, with
Excel versions.**

**Remove the software from the folder before you use it**

** **

**5) DESCRIPTION:** The
software on website-5 consists of a calculation device that functions as a
tutorial for triple integrals. When the user enters two numbers, in white
input boxes on top of the calculation device, an additional four values are
generated by the computer. With these numbers, the software generates ten math
problems in the form of triple integrals. When the user enters numbers he or
she calculated for a specific problem, the software checks the calculated
results, and displays a message indicating whether or not the user entered the
correct calculations. This software also has a device that keeps track of the
number of correct calculations the student entered in the tutorial. There are
10 problems in the software, and for each correct calculation, the counting
device displays 10%

The calculations performed by this software are normally concealed, until the user enters manually calculated results. However, if the user places an X in a green input box, on the top of the device, all the results calculated by the computer are displayed instantaneously.

This software has another interesting feature, which allows the user to control the number of decimal places used in the calculations. Specifically, on the upper section of the software, there is a white input box, and related text that indicate how many decimal places are going to be used for the calculations. The users can change these settings, by deleting the number in the input box, and replacing it with a number that represents their preferred number of decimal places.

On the very bottom of this calculation device, there is a box to enter comments, and a submit button. When the submit button is pressed, the entire calculation device, along with the calculated results, and the comments, are sent to my e-mail (David Alderoty).

** **

** **

__Website-6) A Calculation Device That
Functions as a Tutorial for__

__Solving Algebraic Equations with Hyperbolic
Functions__

**TITLE OF WEBSITE:**

__Online Tutorial
on Algebra with Hyperbolic Functions__

__In The Form of
JavaScript Calculation Software__

** **

**www.TechForText.com/Algebra-with-Hyperbolic-Functions**

**If
you want a printer friendly JavaScript version of this software,**

__without
the introductory text left click on these words__

** **

**Left click here to download a zipped folder, with
Excel versions.**

**Remove the software from the folder before you use it**

** **

**6) DESCRIPTION:** The
software on website-6 consists of a calculation device that functions as a
tutorial for algebra problems with hyperbolic functions. When the user enters
two numbers in the input boxes, a set of semi-random numbers are generated. The
software uses these numbers to generate ten algebra problems involving
hyperbolic functions. When this is done, the software instantly calculates the
answers to the ten algebra problems, and generates step-by-step solutions for
each of the problems. The calculated results and a step-by-step solution are
initially concealed from the user. When the user enters a manually calculated
result, into an input box for a specific problem, the software displays the
correct calculated result, and the step-by-step solution to the problem. If
the user entered the correct calculated result, a message in green type is
displayed. When an incorrect result is entered by the user a message in red
type is displayed. This software also has a device that keeps track of the
number of correct calculations the student entered in the tutorial. There are
10 problems in the software, and for each correct calculation, the counting
device displays 10%

The calculations performed by this software are normally concealed, until the user enters manually calculated results. However, if the user places an X in a green input box, on top of the calculation device, all the results calculated by the computer are displayed instantaneously.

This software has another interesting feature, which allows the user to control the number of decimal places used in the calculations. Specifically, on the upper section of the software, there is a white input box, and related text that indicate how many decimal places are going to be used for the calculations. Users can change these settings, by changing the number in the input box.

On the very bottom of this calculation device, there is a box to enter comments, and a submit button. When the submit button is pressed, the entire calculation device, along with the calculated results, and the comments, are transmitted to my e-mail (David Alderoty). In addition, each of the ten problems, has its own box to enter comments, but the submit buttons are located only on the bottom of the software.

** **

** **

__Website-7) A Calculation Device That
Calculates__

__The Average, and a Few Other Statistical
Calculations__

**TITLE OF WEBSITE:**

__Online Table for
Calculating the Average__

** **

**www.TechForText.com/Online-Table-for-Calculating-the-Average**

** **

**If
you want a printer friendly JavaScript version of this software,**

__without
the introductory text left click on these words__

** **

**7) DESCRIPTION:** The
software on website-7 consists of a JavaScript online calculation device, which
calculates the average when a set of numbers (or scores) are entered in column
C. It also calculates three other components that relate to each individual
score, which are displayed in three columns D, E, and F. This software can
handle up to 40 numbers (or scores), and it has a print button, so users can
print their calculated results.

** **

** **

__Website-8) Databases with Calculation Devices__

**TITLE OF WEBSITE:**

__Calculating-Spreadsheet-Databases__

__Created with Microsoft
Excel__

** **

**www.TechForText.com/Calculating-Spreadsheet-Databases**

**8) DESCRIPTION:** Website-8
has a total of 20 downloadable databases, and the website contains over 5500
words, and it has its own hyperlinked table of contents. __The databases do
not contain any data. They are designed for individuals, businesses, and
organizations who want to store their own information in their own database.__
The databases require Microsoft Excel 2003, 2007 or 2010, or later versions,
and they can be obtained for free, by downloading from the website listed
above.

All of the databases on website-8 have some type of calculation mechanism, such as to count the number of entries, or to perform statistical calculations. These databases also have the Microsoft Excel alphabetizing device installed, on the very top of each column. With this device you can alphabetize anything in the column, from A to Z, or from Z to A. The alphabetizing device also has a search mechanism.

Six of these databases I design specifically for multiple lines of text. Nine of the databases have calculation mechanisms that perform various types of statistical calculations. In addition, I created five databases that are designed to hold hyperlinks to various types of digital media, such as websites, videos, Microsoft Word documents, Excel spreadsheets, PDF files, etc.

** **

** **

__Website-9) A Multiple Calculation Device
with__

__A Semi-Random Number Generator __

**TITLE OF WEBSITE:**

__Multiple
Calculation Software, with a__

__Semi-Random
Number Generator, Based on Time__

** **

**www.TechForText.com/Multiple-Calculation-Software-with-A-Semi-Random-Number-Generator-Based-On-Time**

** **

**If
you want a printer friendly, JavaScript version of this software,**

__without
the text on the website, left click on these words.__

** **

**Download link for a zipped folder,**

**with Excel versions of the software.**

**Remove the files from the folder,
before you use them.**

** **

**9) DESCRIPTION:** The
software on website-9 is
a very unusual device, and it
is about 30 pages in length,
without the website. With the website it is 37 pages. It has a semi-random
number generator that uses __the computer’s clock __and a series of formulas
I created, to generate sets of random numbers. The random numbers are
transmitted within the software, to ten calculation devices, that carry out
OVER 60 calculation simultaneously, involving algebra, trigonometry, calculus,
and geometric calculations for a circle and rectangle.

This software demonstrates how Microsoft Excel can be used as a computer language, to create complex software. The spreadsheet formulas and the related connections are displayed in the first section of the software, using black lines to show the data transfer from input boxes, and from one formula to another. The second and third sections of the software display only the spreadsheet formulas, and calculated results.

** **

** **

__Website-10) Simplified Discussion, on How
Microsoft__

__Excel Can Be Used As A Programming Language__

**TITLE OF WEBSITE:**

**Microsoft Excel
as a Programming Language,**

**To Create
Databases and Complex Calculation Devices**

** **

**10) DESCRIPTION:** Website-10
provides a concise and simplified discussion, on HOW MICROSOFT EXCEL CAN BE
USED AS A PROGRAMMING LANGUAGE, to create complex software-based calculation
devices, and databases with calculation mechanisms. On website 10, most of the
software mentioned above, are used as examples to demonstrate the utility of
creating software with Excel.