Fairhope High School - Mr. Tim Yahr
Fairhope High School - Mr. Tim Yahr

THURSDAY 10/3/19

Information is people.  Information is packages.  Information is products.  Information isn't just numbers.  Watched a VIDEO about UPS and all the information they must deal with getting packages from one place to another quickly.

 

Practiced getting data sorted and averaged for next week's test.

 

Practiced working with spreadsheet equations for next week's test.

INPUT -- OUTPUT -- CELL LOCATION

1.  Start each equation with an = sign.

2.  For exponents use shift 6 ^.

3.  For multiplication use shift 8 *.  REMEMBER to include implied multiplication.

4.  With larger division problems use parentheses for the numerator and denominator.

Use the data below in Google Sheets to find the indicated values.  The first answer is given to make sure you are heading the right direction.

 

Average Unit Cost for Sales Rep Kivell = 43.48

 

Average Number of Units for the West Region = 38.5

 

Average Total Sales for Desks = 566.67

 

Average Total Sales for Sales Rep Morgan = 462.59

Contexture Data Set
INFO contexture sales.xlsx
Microsoft Excel sheet [10.6 KB]
Spreadsheet #1 D3=G5^3
spreadsheet A 1.xlsx
Microsoft Excel sheet [22.1 KB]
Spreadsheet #8 C3=C6^2+4*C6-7
spreadsheet A 8.xlsx
Microsoft Excel sheet [27.2 KB]
Spreadsheet #10 E7=(-7*D4*G2)/(4*B6)
spreadsheet A 10.xlsx
Microsoft Excel sheet [26.1 KB]

TUE OCT 15 --->

CERT testing 9th & 11th

PRE ACT testing 10th

Start of 2nd Quarter

Click here to follow the directions to access student grades and other information.

Note:  You must log in twice each time you access information.

1st log in -- username   homeuser

                 password    homeuser1

2nd log in -- 

username and password that is provided on your student's INow Home Portal Login Slip - contact the school office in person for your username and password.

Click here to sign up for NOTIFY ME.

Print Print | Sitemap
© Timothy Yahr