### Calculations and mathematics using spreadsheets and databases

Course Title Level Campus
Calculations and mathematics using spreadsheets and databases Pre-Juniors Kosrae

### Course Description

Course introduces students to spreadsheets using Microsoft Excel. Course also integrates arithmetic and algebraic concepts, reinforcing student knowledge of mathematics. The course will also look at Access as a means of storing data.

### Course Schedule and Topics

#### Week one: Basics

MondayOrientation
TuesdayPretest
WednesdayCalculator • View • Clear • arithmetic ops • reciprocal • powers • roots • base changes •
ThursdayIntroduction to Excel Layout • Columns • Rows • Cells • Address system • Data entry • Arithmetic formulas • Address based formulas • Sum function • Fill right •
Friday Dan Bricklin
VisiCalc
Copying functions

ZXCV: Undo, Cut, Copy, Paste
StatePop
Chuuk53595
Kosrae7686
Pohnpei34486
Yap11241
Quiz one • Charts • Column • Pie •

#### Week Two: Mail merges and list work

Monday Review quiz. • Layout and design considerations for Excel Planning • Design • Label row • No blank rows • No blank columns Students entered address lists. Prepare master merge document using Microsoft Word. Insert merge fields. Perform merge. If then else including isblank() Choose function Quiz two. Conditional function: add a gender column and a comment that varies by gender. If then else. Insert new column, enter function.

#### Week three: XY Charts, working with numbers, linear regressions

Monday Tuesday Wednesday Thursday Friday
Data entry and cell formatting. Decimal places. (Utwe run data 05 Jul 2003 16:56). XY Scatter graph.
LocationTime/minDistance/km
Piyuul00
Malem River11.41.8
Inland Road294.6
Mutunfunak46.37.1
Utwe61.810

Piyuul00
Sansrik19.42.85
Tofol32.76.45
Lelu Jxn59.88.65
Bridge80.911.58
Inkoye88.212.62
Tafunsak107.515.45

Piyuul00
Malem river11.11.826
C13615.72.557
Yewak river24.03.903
Piyuul30.55.113
Obtain best fit line. Add Trendline: Linear regression. Show equation. Predicting distance from time
Inverse functions: predicting time from distance Biology lab regression.
Non-linear functions. Population growth and baby growth
Age in months since conception Mass in kg
93.0
124.9
156.4
187.5
249.4
3012.1
3613.0
4213.1
6014.5
Midterm

#### Week four 2005: Probabilities, Statistics, Frequencies, Histograms

Monday Reviewed midterm Introduced the random number generator. =int(rand()*2+1) to model the flipping of a coin. =choose(A1,"heads","tails") in cell A2 to make "concrete the model." Random number generator function to model six-sided dice =int(rand()*6+1). Modeling one die, two dice. The sum of two dice. 216 pairs of dice. Introduced statistical concepts of min, max, range, count, and mode. Continued to introduce statistical concepts: median, mean, standard deviation. Creating a histogram. Using the possible dice outcomes (2 to 12) for bins, and the frequency function to automatically results. Creating a column chart with a gap width of zero. Quiz three

#### Week Five

Monday Review quiz Creating subtotals. Loaded entrance.xls. [This effort required the whole period. Some could download the file, but many had to have the file transfered from a USB key.] End of period: running subtotals on the entrance file. Pivot tables Quiz four

#### Week Six

Monday Graphing polynomials Review Final