Math Student Help

When rounding decimals, round up to the next digit in the sequence if the digit is equal to or greater than five. Round decimals to specific decimal places using tips from a math tutor in this free video on math skills.

Expert: Alex Martinez
Bio: Alex Martinez grew up in western Massachusetts and is currently a mechanical engineering student at the University of Massachusetts at Amherst. He’s set to graduate in 2009 with a Bachelor of Science.
Filmmaker: David Pakman

Duration : 0:1:28

(more…)

A mixed number is a number that contains both whole numbers and fractions. Change mixed numbers into decimals by creating a simple fraction and turning the fraction into a percentage with tips from a math teacher in this free video math lesson.

Expert: Steve Jones
Bio: Steve Jones is an experienced high school mathematics and science teacher.
Filmmaker: Paul Volniansky

Duration : 0:2:20

(more…)

Userforms make data entry moe intuitive. The coding for transfer of data from the userform to the Excel worksheet is easy to learn. The code for the ‘AddData’ button is reproducd here for your ready reference. For more details you can log on to familycomputerclub.com.

Dim eRow As Long
Dim ws As Worksheet
Set ws = Worksheets(”data”)

‘find first empty row in database
eRow = ws.Cells(Rows.Count, 1).End(xlUp).Offset(1, 0).Row

‘check for a name
If Trim(Me.txtName.Value) = “” Then
Me.txtPart.SetFocus
MsgBox “Please enter a name”
Exit Sub
End If

‘copy the data to the database
ws.Cells(eRow, 1).Value = Me.txtName.Value
ws.Cells(eRow, 2).Value = Me.txtSalary.Value
ws.Cells(eRow, 3).Value = Me.txtHRA.Value
ws.Cells(eRow, 4).Value = Me.txtPF.Value
ws.Cells(eRow,5).Value=Me.txtMed.Value
ws.Cells(eRow,6).Value=Me.txtPkg.Value

‘clear the data
Me.txtName.Value = “”
Me.txtSalary.Value = “”
Me.txtHRA.Value = “”
Me.txtPF.Value = “”
Me.txtMed.Value=”"
Me.txtPkg.Value = “”
Me.txtName.SetFocus

Duration : 0:3:21

(more…)

Write a decimal as a percent by multiplying the number by 100 and moving the decimal point two places to the right. Calculate percentages from fractions and decimals using tips from a math tutor in this free video on math skills.

Expert: Alex Martinez
Bio: Alex Martinez grew up in western Massachusetts and is currently a mechanical engineering student at the University of Massachusetts at Amherst. He’s set to graduate in 2009 with a Bachelor of Science.
Filmmaker: David Pakman

Duration : 0:1:39

(more…)