Data Source Search Results

How To: Algebraically solve mixed quantities problems

In this video the instructor shows how to solve mixture problems using two variables. Usually in these kind of questions the problem statement goes like, if A costs $x for a pound and B costs $y for a pound, in what ratio should they be mixed such that one pound of the new mixture sells for $z a pound. So, in these kind of problems start with a box where you list down all the given data in the form of a table as shown in the video. Now denote the unknown quantity of A and B by two variables a...

How To: Use Excel chart basics

In this Excel basics video, the instructor talks about the basics of charts. There is an enormous difference in how you make charts between Microsoft Excel 2003 and 2007. In both the versions, to make charts the first thing you do is highlight the data cells in your workspace. Now use the toolbar and click on the charts button there. Now Excel automatically generates the charts based on the data and the column and row names. But there are various changes between the charts produced in the dif...

How To: Use the percentile formula in Statistics

In this tutorial the instructor explains the percentile formula. He says that the percentile formula is used to find the percentile rank of a data point in a group of data. He takes an example that consists of the lengths of puppies. Now he intends to find out the percentile rank of any puppy in the group. He shows that the formulate to compute a percentile rank of a particular puppy is rank R = 100 * (N< + (1/2)N= )/ Nt, where N< is the number of puppies whose length is less that the length ...

How To: Calculate the percentage of a number

This video presented by Cris Ippolite makes a comparison between flat files and relational databases made with FileMaker Pro 10. It starts by showing flat files, which programs like Microsoft Excel use. Flat files have a big disadvantage: they cannot communicate with other files, even those with related data. If you wish to make your job easier, you should use relational databases. With databases, the tables communicate between one another. Once you store an entry in a table, you can use it i...

How To: Delete Cookies from Your Browser

This video shows you how to easily delete cookies from your browser. First thing you have to do is open the web browser you usually use (the video shows how to delete cookies from Firefox) and go to the Options tab in the upper menu. Then choose the Clear Private Data or Clear Recent History item. In the pop-up window, check Cookies and Cache and then press the Clear Now button. The Clear Private Data/ Clear Recent History window also can be opened by pressing CTRL+SHIFT+DEL. That's it! Good ...

How To: Use flat files vs. relational databases with FileMaker

This video, presented by Cris Ippolite, makes a comparison between flat files and relational databases made with FileMaker Pro 10. It starts by showing that programs like Microsoft Excel uses, what in the databases circles, are called flat files. This flat files have a big disadvantage: it cannot communicate with other files even those have related data. So, instead of using those, if you want to ease your job, you should use relational databases. With databases, the tables communicate betwee...

How To: Set up the Internet for T-Mobile on an iPhone clone

Learn how to set up the Internet for T-Mobile on an iPhone clone. First you need to create a GPRS data account and a WAP profile for T mobile to bring up the service icon. Then click the data account button, then the GPRS button, then chose the correct account for you, change the APN to Link (all lower case). Before you finish this process make sure the user name and password fields are blank.

How To: Erase a CD-RW & Reuse It to Save Money

We know, we know: How many people actually burn stuff onto CDs these days? Well, while external hard drives that hold several terrabytes of data and flash drives have kind of replaced our reliance on CDs, every now and then they're good for quickly compiling a "Pop Hits of the '80s" CD for your girlfriend or simply for storing your illegal version of Microsoft Office.

How To: Use the DataPager & ListView controls in Visual Studio

Microsoft ASP.NET is a free technology that allows programmers to create dynamic web applications. ASP.NET can be used to create anything from small, personal websites through to large, enterprise-class web applications. All you need to get started with ASP.NET is the free .NET Framework and the free Visual Web Developer. Generally, the DataPager control is used with the ListView control. The ListView control is data driven. First create a ListView control and provide it some data. Next drop ...

How To: Pass info from one page to another with a query string

In this video tutorial, Chris Pels will show how information can be passed from one page to another using a query string. First, see how to construct a query string including variable names and values from information on a data entry form. Next, see how to access the query string information when the page is posted including how multiple query string variables are handled. As part of the server side processing of query string information, see how to implement validation for existence of query...

How to Hack Like a Pro: Getting Started with Metasploit

This is my first contribution in an ongoing series on detailing the best free, open source hacking and penetration tools available. My goal is to show you some of the quality tools that IT security experts are using every day in their jobs as network security and pen-testing professionals. There are hundreds of tools out there, but I will focus and those that meet four key criteria:

How To: Prevent Certain Apps from Using Cellular Data on Your iPhone to Stay Below Data Caps or Avoid Throttling

If you're on a cellular plan with a low data allotment, being thrifty with your data can help you avoid a higher bill. But even if you have an affordable unlimited plan from wireless carriers such as T-Mobile or Verizon, going over a certain amount of data may throttle your connection, leaving you with slow web speeds. One way to prevent hitting these thresholds is to keep certain apps in check.

Facebook 101: How to View, Delete & Disable Location History Data That's Been Collected on You

Facebook's shadiness when it comes to user privacy has never been much of a secret. The Cambridge Analytica scandal, however, has thrown the company and its practices into the limelight, with users taking their data more seriously than ever. If you're one of those users, you might want to check your "Location History" to see if and how Facebook's kept tabs on your whereabouts.

How To: Use basic functions in Excel (AVERAGE, COUNT, MIN/MAX)

This video shows us how to use the following functions in Excel: average, count, counta, min, max, and sum. First, start off by create a set of numbers to work with. After that, click on an empty cell that you want to use for the functions. To do an average, click on the functions button on the top right corner of the menu bar, you'll see a list of all the functions that are available. Select average, and then highlight all the numbers that you want to find the average of. Repeat the exact sa...

How To: Make a dynamic named range in Excel (left to right)

Teach Excel describes how to create a dynamically updating named range that goes from left to right using Excel. First, you define the named range by highlighting the cells containing numbers in a certain row. In the name box to the left of the formula bar, type the name of the data. In this example, the numbers correspond to sales, so type "sales." To check if the named range works, click on an empty cell and enter =sum(sales). That should return the sum of the highlighted cells. However, as...