Description

Microsoft Excel Software Usage for Teaching Science and Engineering Curriculum Gurmukh Singh and Khalid Siddiqui Department of Computer and Information Sciences State University of New York at Fredonia Fredonia, NY 14063 singh@fredonia.edu CIT-08, Genesee Community College, Batavia

Transcripts

Microsoft Excel Software Usage for Teaching Science and Engineering Curriculum Gurmukh Singh and Khalid Siddiqui Department of Computer and Information Sciences State University of New York at Fredonia, NY 14063 singh@fredonia.edu CIT-08, Genesee Community College, Batavia May 27-29, 2008 CIT-08 Presentation by G. Singh & K. Siddiqui

Main Objectives of Presentation Use of Microsoft Software Excel 2003/2007 Software for showing school and college level educational programs in science and building for school students Microsoft Excel Software focused for college understudies in computational material science and material science instruction Computer science and bio-medicinal sciences Perform reenactments of a shot, for example, a rocket propelled from a plane to hit an objective on ground for physical science majors Rolling of nine bones with six surfaces in a gambling club diversion for software engineering majors CIT-08 Presentation by G. Singh & K. Siddiqui

Development and headway in rapid small scale PCs, for example, IBM and Mac based PCs Portable tablets as adaptable classroom devices to show undergrad science and designing educational modules Microcomputer machines utilize a few programming frameworks, for example, Excel, Access, Word, PowerPoint, Groove, InfoPath, OneNote, Outlook, Publisher, FrontPage and so forth. Item arranged processing dialects like C++, C#, Visual Basic (VB), Java Script, SQL and so forth. Such programming frameworks are widely utilized for undergrad, graduates educating in universities, exploratory labs, privately owned businesses, organizations and banks in world Why Microsoft Excel in College? CIT-08 Presentation by G. Singh & K. Siddiqui

Why Microsoft Excel 2007 in College? Appropriation of web advances in undergrad science and building educational program International/National meetings to upgrade and offer the information assembled with different instructors and analysts Use of Internet innovations to intuitively instruct in undergrad and graduate classroom setting or amid far off learning in virtual colleges, which is an exceptionally viable showing apparatus for the science and designing educational module CIT-08 Presentation by G. Singh & K. Siddiqui

Examples of Projectile Motion in Physics Launching of a voyage rocket from a plane to hit an adversary post Motion of a space transport or rocket from take off platform Firing a big guns shell to demolish a foe post Firing of a gun ball from a gun Hitting of a baseball with homerun stick Hitting a golf ball with golf club Firing of a slug from a weapon or gun Shooting of a bolt with a bow amid chasing Punting of a football amid ball game Kicking of a football amid commencement in ball game Study the shot movement in a material science lab CIT-08 Presentation by G. Singh & K. Siddiqui

Components of shot speed v ( x,y,t ), quickening a ( x,y,t ), vecor power F ( x,y,t ), r ( x , y,t ) position vector in two-dimensional space are : (1) (2) (3) (4) (5) 1. Hypothesis and Algorithm of Projectile Motion CIT-08 Presentation by G. Singh & K. Siddiqui

where x 0 , y 0 and v 0x , v 0y are beginning position arranges and starting segments of speed of shot along x - and y - bearings, individually. Eq. (4) and Eq. (5) are called kinematic comparisons of shot movement. We utilized these mathematical statements to reproduce the shot direction under activity of gravity with the least complex presumption of no air resistance and executed limit conditions for the present issue (i.e. a x = 0, a y = g = - 9.80 m/s 2 , v y = V, v 0y = V 0 , y = H , and y 0 = H 0 ), so that Eq. (4) and Eq. (5) could be composed as takes after along y - pivot Â V = V o + gt , H â = H o + V o t + 0.5gt 2 . (6) These comparisons will be utilized as a part of to mimic the shot movement to mimic its accurate speed V and definite stature H â at a given moment of time. Hypothesis and Algorithm of Projectile Motion (contd.) CIT-08 Presentation by G. Singh & K. Siddiqui

Fig. 1: Typical Excel 2007 Interface, Home Tab on CIT-08 Presentation by G. Singh & K. Siddiqui

Interactive Simulation of Projectile Motion Eq. (6) is utilized to reproduce shot movement utilizing Microsoft Excel 2007 [5]. A cell equation in Excel dependably begins with an equivalents sign (=), and subsequently the comparing cell recipes of Eq. (6) for reenactment of definite speed and tallness ought to be written in Excel spreadsheet as V = V o + g* A2 (7) H â = H o + V o *A2 + 0.5*g*A2^2 (8) where V o = 0 m/s and H o = 100 m is the estimation of starting speed and stature of the shot in y - heading, and A2 = dt = 0.0125 s speaks to the relative cell reference for an adjustment in time interim, dt , which is retained in Excel by something many refer to as â Defined Name â [5] and its worth may exist in an alternate cell, whose cell reference could be utilized as a part of Eq. (7) and Eq. (8) for the present reproduction work. CIT-08 Presentation by G. Singh & K. Siddiqui

Interactive Simulation of Projectile Motion We are delineating just the initial forty reproduced estimations of speed, V and registered stature, Hâ , of the shot in Table I. Additionally given in this Table is the precise tallness of the shot and % mistake in stature. The processed stature H is dependably somewhat not as much as that of the definite tallness H â. For 93% of the reproduced information focuses, the extent of percent slip between reenacted tallness and genuine eight is < 4.0%, which shows that the precision in figured estimations of shot stature is really great, which further demonstrates that the picked time interim dt = 0.0125 s very nearly fulfills the important and adequate state of differential analytics that in the point of confinement of tiny time interim, Î t â 0 for the shot movement. CIT-08 Presentation by G. Singh & K. Siddiqui

Table 1: Partial Results of Interactive Simulation CIT-08 Presentation by G. Singh & K. Siddiqui

Horizontal Range of Projectile Motion For 99% of the reproduced qualities, greatness of percent mistake between figured stature and real tallness is < 2.0%, which shows that the precision in processed estimations of shot tallness is really great. The extent of even range, R , of shot amid its season of flight t = 4.775, expecting a steady speed of plane, V plane = 500 miles/hour along x - hub, can be gotten from kinematic mathematical statement Eq. (4) by utilizing the beginning limit conditions, i.e., x = R , a x = 0, x 0 = 0 and v 0x = V plane : R = tV plane = 1067 m (9) R is the separation where the shot will hit an objective on the ground. In the present issue, R = 1.07 km, which can be expanded either by imparting so as to expand airplaneâs speed as for ground or some beginning push to the shot at dispatch time or by a mix of both. CIT-08 Presentation by G. Singh & K. Siddiqui

Fig. 2: A plot of shot tallness, H versus time, t CIT-08 Presentation by G. Singh & K. Siddiqui

Fig. 3: Two slide bars to change starting limit conditions 1 2 Two slider bars are utilized to perform reproductions with distinctive introductory speed V 0 of the shot and at an alternate beginning stature H 0 of the plane. Slide bar 1 speaks to the quick starting stature of the shot, though slide bar 2 demonstrates the introductory speed of the shot at dispatch time. The beginning stature, H 0 and introductory speed, V 0 of the shot can be expanded or diminished by tapping on right or left hand side bolt existing on every end of a slide bar. CIT-08 Presentation by G. Singh & K. Siddiqui

2. Intuitive Simulations of Nine Rolling Dice To mimic moving of nine craps in a gambling club amusement, we utilize most recent adaptation of Microsoft Excel 2007 and utilize an inherent pseudo number producing capacity, RAND( ), which can create fragmentary numbers somewhere around 0 and 1. As none of the characteristics of a bones has checked with zero a dab, one is ought to incorporate this while creating the arbitrary numbers. Cell recipe to make non-zero irregular numbers for the moving of nine bones ought to likewise incorporate a component of 6, which is reproduced by the capacity RAND( ) to consider the certainty of six countenances of a craps, and an element of solidarity is added to it to prohibit zero quality produced arbitrary numbers. The arbitrary numbers in this way created for nine moving shakers are given in Table 2 in its initial nine sections. CIT-08 Presentation by G. Singh & K. Siddiqui

Interactive Simulations of Nine Rolling Dice The arbitrary numbers along these lines created for nine moving bones are given in Table 2 in its initial nine segments. Segment ten demonstrates the whole of scores got for all the nine craps in one trial. Eleventh section speaks to the proportion of entirety score of every one of the nine ivories in one line to the greatest score among each of the 200 information values in segment ten of Table 2. In the event that one double taps any cell of created information, and afterward hits the ENTER key on the console, all reproduced irregular numbers for nine shakers will change momentarily and subsequently, the aggregate score in a solitary line standardized with the most extreme score of the tenth section information qualities will likewise change. CIT-08 Presentation by G. Singh & K. Siddiqui

Table 2: Simulated estimation of number of specks on the six countenances of every bones in moving