Spreadsheet Solution of Linear Systems
The solution of variety of complex linear systems in real-world problems n everyday life arise frequently in such areas like chemistry, traffic systems, electronics, electricity, marketing, accounting , finance , heat conduction, molecular diffusion, fluid mechanics, data regression, etc.
Arrays and array formula are popularly used in the solution of complex system of linear equations that you may not be able to do so easily with standard spreadsheet functions. The importance of spreadsheet arrays is explained by the fact that it is consistent and therefore ensures greater accuracy. You can also do a large amount of computations in a small space. This enables you to save time and also reduce a lot of memory used by your worksheet by replacing iterative formulas.
The foremost objective of this course is to provide the learner with how to do it tutorial on spreadsheet solution of a wide variety of applications of linear systems in real-world problems.
By the time you complete this course, you should be able to:
- express linear algebraical statement as a function of Excel executable expression
- perform array formula computations and matrix algebra operations using Excel
- express a real-world problem as a system of linear equations
- convert linear system equations into spreadsheet executable expressions
- apply Excel array, formula and functions in the solution of system of linear of equations
In order to fully benefit from this course, you should have
- access to a personal computer or a similar device.
- knowledge and skills in operating a personal computer or a similar device.
- light experience in the use of Microsoft Excel, especially areas that cover functions, name manager, cell range, and data entry.
- previous knowledge in basic concepts in Linear Algebra particularly matrix algebra operations, determinants, and inverse matrices.
The Call eAcademy courses do not award free certificates. A verified certificate is awarded only to learners who have successfully passed in assessment of registered paid certificate tracks. Your performance in quizzes and assignments at the of a course qualifies you to apply for a verified certificate of participation in the course.
- Lectures 18
- Quizzes 3
- Duration 50 hours
- Skill level All levels
- Language English
- Students 1
- Certificate No
- Assessments Yes
ARRAY AND SPREADSHEET BASICS
The section discusses the basic concept of arrays, importance of array, array constant, array range, how to enter and edit array formula, and how to calculate array results. It serves as a requisite module for subsequent lessons in spreadsheet application of matrices.
WORKING WITH MATRICES IN EXCEL
Matrices are used in many practical problems. More importantly, many computations can easily be performed by using matrices. In this section, you will learn how to enter and perform various operations of matrices in Excel application package. You will also learn about matrices and arrays and their application in solving linear equations. The knowledge and skills acquired are so important because you'll be
SYSTEM OF LINEAR EQUATIONS WITH EXCEL
In this section, you'll learn how to use Excel functions and some popular algorithms in Linear Algebra such as Cramer's rule and Invertibility to solve various examples of system of linear equations.
EXCEL SOLUTION OF LINEAR SYSTEMS
This section walks you through how to express real-world problems into system of linear equations, and how to convert these equations into Excel executable expressions.You'll learn how to use Excel functions to solve, with ease, some selected examples.
SUPPLEMENTARY EXERCISES IN LINEAR SYSTEMS
The concluding section of this course covers supplementary exercises in application of linear systems drawn from various departments of human endeavor. The learner must endeavor to solve these exercises in order to consolidate any knowledge and skills acquired in this course. The instructor might request you to submit solutions to some of theses exercises to demonstrate your competence in using Excel functions in solving systems of linear equations. Also, you may be required to submit these solutions as a requirement for a certificate of completion of this course.
The bibliography page is a list of works (such as books and articles) which were consulted in the preparation of this course. The man purpose of the bibliography entry is to acknowledge or give credit to authors whose works were consulted, although, there were no direct quotes from these sources. Another drive for this list is to make it easy for a learner to find out more about the topics in this course by exploring these sources.