Bozeman Science
AP Biology Labs - part 1
Paul Andersen details the first 7 of 13 labs in the AP Biology Curriculum. The following topics are all covered: Artificial Selection, Hardy-Weinberg Equilibrium, Comparing DNA using BLAST, Diffusion and Osmosis, Photosynthesis,...
Bozeman Science
Population Modeling
Paul Andersen shows you how we can use a spreadsheet to model population changes. He begins with a brief discussion of populations and life cycles. He then shows you how you can model a single generation using a spreadsheet.
Bozeman Science
Student's t-test
In this video Paul Andersen explains how to run the student's t-test on a set of data. He starts by explaining conceptually how a t-value can be used to determine the statistical difference between two samples. He then shows you how to...
Bozeman Science
Standard Deviation
In this video Paul Andersen explains the importance of standard deviation. He starts with a discussion of normal distribution and how the standard deviation measures the average distance from the mean, or the "spread" of data. He then...
Bozeman Science
Standard Error
Paul Andersen shows you how to calculate the standard error of a data set. He starts by explaining the purpose of standard error in representing the precision of the data. The standard error is based on the standard deviation and the...
Bozeman Science
Graphing Data by Spreadsheet
Paul Andersen shows you how to graph data by hand. He explains the required elements of a scatter plot with a best fit line. He shows you how to properly scale and label the axes.
SciShow
From Optics to Spacewalks: Dr. Ellen Ochoa | Great Minds
Dr. Ellen Ochoa is incredible! She published over a dozen papers, co-filed three patents, and was a NASA engineer, all before becoming an astronaut and spending nearly a thousand hours in space.
Bozeman Science
A Beginner's Guide to Graphing Data
Paul Andersen explains how graphs are used to visually display data that is collected in experimentation. He describes five main types of graphs; line graph, scatter plot, bar graph, histogram and pie chart. He describes the important...
Bozeman Science
Practice 4 - Analyzing and Interpreting Data
Paul Andersen explains how scientists analyze and interpret data. Data can be organized in a table and displayed using a graph. Students should learn how to present and evaluate data.
Curated Video
Microsoft Project 2021 From Beginners to Advanced - Exercise 06-1
In this exercise demonstration, we will add resources to a plan, practice assigning resources to tasks, and identify and deal with any resource over-allocations. This clip is from the chapter "Resources" of the series "Microsoft Project...
Curated Video
Microsoft Project 2021 From Beginners to Advanced - Exercise 04-1
In this exercise demonstration, we will use the new business plan.xlsx file, create a blank project and save it, add tasks to a spreadsheet, mark milestone tasks, and create summaries and subtasks. This clip is from the chapter "Entering...
Curated Video
Microsoft Project 2021 From Beginners to Advanced - Exercise 05-1
In the exercise demonstration, we will create task dependencies based on information from a spreadsheet, practice adding lag and lead times, and use filters to show all milestone tasks. This clip is from the chapter "Dependencies and...
Curated Video
Microsoft Project 2021 From Beginners to Advanced - Switch Between Tables
This video covers switching between different tables in Project 2021, such as the Task table, Resource table, and Assignment table. Learn to customize tables, save custom tables, and switch between different tables quickly. This clip is...
Curated Video
Behavioral Design Patterns in C++ - Spreadsheet Application - I
In this video, we will be building a spreadsheet application using JavaScript. This clip is from the chapter "Strategy" of the series "Behavioral Design Patterns in C++".In this section, you will learn about the strategy pattern.
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Multidimensional Arrays
This video explains multidimensional arrays, which are made by adding a comma after the first number between round brackets of your array name, then adding another number. This clip is from the chapter "Arrays" of the series "The...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Cell Property
This video explains the Cell property used to reference the cells on your spreadsheets. This clip is from the chapter "Loops with VBA" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This section explains loops...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Subroutines
This video explains a subroutine, which is a piece of code that performs a specific task described in the code but does not return a result or value. This clip is from the chapter "Subs and Functions" of the series "The Ultimate Excel...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Arrays and Loop
This video explains how to store some numbers in an array and then use a loop to print the amount of cells in the spreadsheet. This clip is from the chapter "Arrays" of the series "The Ultimate Excel VBA Course - Learn and Master VBA...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - VBA Practice Conditional Operators
This video is a practice session on conditional operators where if a person scores 85 and above, we will want to grade an A along with changing the background color of the cell. This clip is from the chapter "VBA Conditional Statements"...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Other Excel VBA Variable Types
This video explains the other Excel VBA variable types such as As long, As Single, As Double, and As Currency. The difference between all these data types is how many digits they can hold. This clip is from the chapter "Mastering...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Multiply and Divide
This video explains how to multiply and divide in Excel VBA. This clip is from the chapter "Mastering Variables in VBA" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This video explains variables in VBA using...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Variable Practice
This video is a practice session on variables where you will declare the variable and store a value to it and read the string that was contained in it. This clip is from the chapter "Mastering Variables in VBA" of the series "The...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Add a Button to a Spreadsheet
This video explains how to place a button control on a spreadsheet. This clip is from the chapter "Introduction" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This section introduces you to the course and how...
Curated Video
The Ultimate Excel VBA Course - Learn and Master VBA Fast - Excel VBA Developer Toolbar
This video explains the Excel VBA developer toolbar and the various panels associated with it. This clip is from the chapter "Introduction" of the series "The Ultimate Excel VBA Course - Learn and Master VBA Fast".This section introduces...