Applications of Spreadsheets in Education


Book Description

"This e-book is devoted to the use of spreadsheets in the service of education in a broad spectrum of disciplines: science, mathematics, engineering, business, and general education. The effort is aimed at collecting the works of prominent researchers and "




Introductory Econometrics


Book Description

This highly accessible and innovative text with supporting web site uses Excel (R) to teach the core concepts of econometrics without advanced mathematics. It enables students to use Monte Carlo simulations in order to understand the data generating process and sampling distribution. Intelligent repetition of concrete examples effectively conveys the properties of the ordinary least squares (OLS) estimator and the nature of heteroskedasticity and autocorrelation. Coverage includes omitted variables, binary response models, basic time series, and simultaneous equations. The authors teach students how to construct their own real-world data sets drawn from the internet, which they can analyze with Excel (R) or with other econometric software. The accompanying web site with text support can be found at www.wabash.edu/econometrics.




Spreadsheet Models for Urban and Regional Analysis


Book Description

The book and accompanying disk use the capabilities of electronic spreasheet programs to provide 19 spreadsheet models that can be used for a wide range of urban and regional analysis and planning applications. The models have been developed for Lotus 1-2-3, Version 1.00, for the IBM personal computer and compatible systems and can be adapted for use with other spreadsheet programs.




Mechanics of Materials


Book Description

Mechanics of Materials: With Applications in Excel® covers the fundamentals of the mechanics of materials—or strength of materials—in a clear and easily understandable way. Each chapter explains the theory of the underlying principles and the applicable mathematical relations, offering examples that illustrate the application of the mathematical relations to physical situations. Then, homework problems—arranged from the simplest to the most demanding—are presented, along with a number of challenging review problems, to ensure comprehension of key concepts. What makes this book unique is that it also instills practical skills for developing Microsoft Excel applications to solve mechanics of materials problems using numerical techniques. Mechanics of Materials: With Applications in Excel® provides editable Excel spreadsheets representing all the examples featured in the text, PowerPoint lecture slides, multimedia simulations, graphics files, and a solutions manual with qualifying course adoption.




Economic and Business Analysis


Book Description

As we enter the 21st century, most students are familiar with microcomputers. They are adept in visually-oriented playing and learning, as evidenced by prevalent video games, music videos, and DVD movies. This book appeals to the modern day undergraduate and graduate students by using microcomputers, through innovative uses of spreadsheets and built-in spreadsheets equations and formulae. This microcomputer skill-intensive book covers major topics in both economic analysis and business analysis. Students will learn how to build complex spreadsheet layouts and perform high-level calculations and analysis intuitively in a non-threatening environment. To encourage students' active learning and critical thinking, they will be given hands-on practice by creating tables and graphs presented in the text and homework, and by changing the parameters to find the effects of the change instantly. At the same time, by acquainting themselves with the popular spreadsheet program, they will acquire more advanced job skills directly.




Beginning Excel, First Edition


Book Description

This is the first edition of a textbook written for a community college introductory course in spreadsheets utilizing Microsoft Excel; second edition available: https://openoregon.pressbooks.pub/beginningexcel19/. While the figures shown utilize Excel 2016, the textbook was written to be applicable to other versions of Excel as well. The book introduces new users to the basics of spreadsheets and is appropriate for students in any major who have not used Excel before.




Intermediate Microeconomics with Microsoft Excel


Book Description

This unique text uses Microsoft Excel® workbooks to instruct students. In addition to explaining fundamental concepts in microeconomic theory, readers acquire a great deal of sophisticated Excel skills and gain the practical mathematics needed to succeed in advanced courses. In addition to the innovative pedagogical approach, the book features explicitly repeated use of a single central methodology, the economic approach. Students learn how economists think and how to think like an economist. With concrete, numerical examples and novel, engaging applications, interest for readers remains high as live graphs and data respond to manipulation by the user. Finally, clear writing and active learning are features sure to appeal to modern practitioners and their students. The website accompanying the text is found at www.depauw.edu/learn/microexcel.




Computer Applications in Food Technology


Book Description

The Institute of Food Technologists (IFT) recently endorsed the use of computers in food science education. The minimum standards for degrees in food science, as suggested by IFT,"require the students to use computers in the solution of problems, the collection and analysis of data, the control processes, in addition to word processing."Because they are widely used in business, allow statistical and graphical of experimental data, and can mimic laboratory experimentation, spreadsheets provide an ideal tool for learning the important features of computers and programming. In addition, they are ideally suited for food science students, who usually do not have an extensive mathematical background.Drawing from the many courses he has taught at UC Davis, Dr. Singh covers the general basics of spreadsheets using examples specific to food science. He includes more than 50 solved problems drawn from key areas of food science, namely food microbiology, food chemistry, sensory evaluation, statistical quality control, and food engineering. Each problem is presented with the required equations and detailed steps necessary for programming the spreadsheet. Helpful hints in using the spreadsheets are also provided throughout the text.Key Features* The first book to integrate speadsheets in teaching food science and technology* Includes more than 50 solved examples of spreadsheet use in food science and engineering* Presents a step-by-step introduction to spreadsheet use* Provides a food composition database on a computer disk




Advanced Excel for Scientific Data Analysis


Book Description

This guide to Excel focuses on three areas--least squares, Fourier transformation, and digital simulation. It illustrates the techniques with detailed examples, many drawn from the scientific literature. It also includes and describes a number of sample macros and functions to facilitate common data analysis tasks. De Levie is affiliated with Bowdoin College. Annotation : 2004 Book News, Inc., Portland, OR (booknews.com).




Data Science in Education Using R


Book Description

Data Science in Education Using R is the go-to reference for learning data science in the education field. The book answers questions like: What does a data scientist in education do? How do I get started learning R, the popular open-source statistical programming language? And what does a data analysis project in education look like? If you’re just getting started with R in an education job, this is the book you’ll want with you. This book gets you started with R by teaching the building blocks of programming that you’ll use many times in your career. The book takes a "learn by doing" approach and offers eight analysis walkthroughs that show you a data analysis from start to finish, complete with code for you to practice with. The book finishes with how to get involved in the data science community and how to integrate data science in your education job. This book will be an essential resource for education professionals and researchers looking to increase their data analysis skills as part of their professional and academic development.