Chapter 3: What-If Analysis, Charting, And Working With Large Worksheets This Microsoft® Excel® 365 text is developed to provide students with the basic skills on working with Excel 365. This book covers six chapters. Each chapter will be provided with the “Start File” and “Complete File”. The “Start File” will contain the data learners need to work with such chapter. Then, the learner will follow the demonstration in the slides/screenshot to learn the concepts covered in such chapter. Once the learner finish such chapter, the “Start File” will resemble the “Complete File.” It is highly recommended that the learner practice with the project in each chapter 2-3 times. During the last practice, the learner should not need to consult the demonstration anymore. If the learner still need to look at the demonstration as a reference, it is an indication that additional practices are needed. This book uses all Microsoft Excel screenshots under fair use. If you plan to redistribute our book, please consider whether your use is also fair use.

Chapter 4: Mortgage and Amortization This Microsoft® Excel® 365 text is developed to provide students with the basic skills on working with Excel 365. This book covers six chapters. Each chapter will be provided with the “Start File” and “Complete File”. The “Start File” will contain the data learners need to work with such chapter. Then, the learner will follow the demonstration in the slides/screenshot to learn the concepts covered in such chapter. Once the learner finish such chapter, the “Start File” will resemble the “Complete File.” It is highly recommended that the learner practice with the project in each chapter 2-3 times. During the last practice, the learner should not need to consult the demonstration anymore. If the learner still need to look at the demonstration as a reference, it is an indication that additional practices are needed. This book uses all Microsoft Excel screenshots under fair use. If you plan to redistribute our book, please consider whether your use is also fair use.

Chapter 5: Formulas and Graphical Charts This Microsoft® Excel® 365 text is developed to provide students with the basic skills on working with Excel 365. This book covers six chapters. Each chapter will be provided with the “Start File” and “Complete File”. The “Start File” will contain the data learners need to work with such chapter. Then, the learner will follow the demonstration in the slides/screenshot to learn the concepts covered in such chapter. Once the learner finish such chapter, the “Start File” will resemble the “Complete File.” It is highly recommended that the learner practice with the project in each chapter 2-3 times. During the last practice, the learner should not need to consult the demonstration anymore. If the learner still need to look at the demonstration as a reference, it is an indication that additional practices are needed. This book uses all Microsoft Excel screenshots under fair use. If you plan to redistribute our book, please consider whether your use is also fair use.

Chapter 6: Vlookup and Conditional Formatting This Microsoft® Excel® 365 text is developed to provide students with the basic skills on working with Excel 365. This book covers six chapters. Each chapter will be provided with the “Start File” and “Complete File”. The “Start File” will contain the data learners need to work with such chapter. Then, the learner will follow the demonstration in the slides/screenshot to learn the concepts covered in such chapter. Once the learner finish such chapter, the “Start File” will resemble the “Complete File.” It is highly recommended that the learner practice with the project in each chapter 2-3 times. During the last practice, the learner should not need to consult the demonstration anymore. If the learner still need to look at the demonstration as a reference, it is an indication that additional practices are needed. This book uses all Microsoft Excel screenshots under fair use. If you plan to redistribute our book, please consider whether your use is also fair use.

This report shares the results of an OER Gap Analysis completed by the Institute for the Study of Knowledge Management in Education (ISKME) for the Texas Higher Education Coordinating Board (THECB). The analysis identified free, openly licensed full courses and textbooks for 25 highly transferable, high-enrollment courses required for two-year or four-year degree paths in high-wage/high-demand fields. Most courses selected for the scan are also Texas Core Curriculum courses. Texas high-wage/high-demand fields were identified using data from the Texas Workforce Commission and included nursing, business, accounting, computer science, engineering, and health administration. The following courses needed for multiple degree paths in these fields were selected for the scan:Science: Anatomy and Physiology I and II; Biology I; Chemistry I; Physics IMath: College Algebra; Elementary Statistical Methods; Pre-Calculus; Calculus I; Calculus IISocial Sciences: Texas Government; Federal Government; General Psychology; Introduction to Sociology; Principles of Macroeconomics, Principles of MicroeconomicsHumanities: US History I and II; Introduction to Ethics; Introduction to Philosophy; Public Speaking; Composition I; Composition IIBusiness: Business Computer Applications; Principles of Finance