The Watch Window is a handy tool that allows you to monitor a cell or a range of cells as you are working in Excel. The watch window will stay on top and constantly update as you work. It is located in under the Formulas Tab and can be adjusted in it's height and width. when you are working with large amounts of data and want to be able to see something specific it is a good tool to work with.
A Pareto Analysis is an analytical technique used to find what few causes lead to the greatest number of problems. The analysis is based on the "80/20 Rule" which states that 80% of the problems are caused by 20% of the possible causes. In our example I will show you how to use it to determine which areas of the TEA M Rubric a faculty see as their greatest weakness. The 20% of the indicators they see as their greatest weakness would then be the areas to focus your teacher training on. For further study you can go to mindtools.com
Sparklines are charts contained within a single cell for a row of data. They create a unique visual analysis for each row of data rather than for the data as a whole. They can be formatted and re-sized to give that quick visual analysis I have mentioned over and over as part of your data analysis model. So in this video I will show you how to create, format, and use them to improve your data analysis .
Have you ever tried to get rid of a table but keep the data and did not know where to start? I have on a few occasions. So today I will show you how to take a table disappear while keeping the all important data. You may not use this often but if you ever need to, now you will know where to look.
If you have every download data from TVAAS then you will want to watch this video. What I am going to show you is how to take multiple rows of data for the same person and transpose (move from vertical to horizontal or vice versa) them so that you have a single row with multiple columns of data. Imagine downloading data and having 10 rows for each student and there are 500 students. You could copy and paste (transpose) and take forever doing it. Or, you could use this formula to automate the process. I got this formula from mrexcel.com where a user named Domenic posted it, and it is pure genius. The formula will take the data and tranpose it for you, taking what would have been a long day's work and turning it into about 10-20 min of work.
Today's video is a follow up to yesterday's blog on how to find the mean, median, and mode in Excel. In this video we look at how to find the distribution of scores and how to graph them for an easy visual analysis of the data.
In today's blog we do a math lesson and look at the difference in these three terms, how to calculate them in Excel, and when to use one over another. My information in the video on the terms themselves is from Laerd Statistics, and they have some excellent explanations of which measurement to use. I worked simply to show you how to write the formulas to find the data in Excel.
Macros are recorded tasks in Excel that can be run to do repetitive tasks. In our video we are going to create a macro that when we use the shortcut keys will automatically sort our spreadsheet by Last Name, First Name. This is very helpful when we have students that we need to add to the database. Instead of finding the correct row and then inserting a row and their data, we can put it at the bottom and then run the macro and it will do the task for us.
Today's video shows you how to freeze panes in Excel, the different ways to freeze them, and when you should choose each type. Freeze panes is a must for working with large amounts of data because it allows you to freeze rows and/or columns so they can always be seen.
Today our lesson begins with a problem, with some scores missing from our database the growth columns are no longer calculating. This poses a problem because we need to know the class growth average. To solve our problem we use the formula =iferror and nest our growth formula inside it. Doing so allows us to say if there is an error in the formula, then leave the cell blank. Then our growth column will average even if some scores are missing. Our problem is then solved.