College of Micronesia-FSM

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
Image of Calculator excel (12K)

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
Address list

MondayReview quiz. • Layout and design considerations for Excel
Planning • Design • Label row • No blank rows • No blank columns
Students entered address lists.
Tuesday Prepare master merge document using Microsoft Word. Insert merge fields. Perform merge.
WednesdayIf then else including isblank()
ThursdayChoose function
FridayQuiz 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

Linear regression of a run to Utwe babymass

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

MondayReviewed 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."
TuesdayRandom 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.
WednesdayContinued to introduce statistical concepts: median, mean, standard deviation.
ThursdayCreating 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.
FridayQuiz three

Week Five

MondayReview quiz
TuesdayCreating subtotals.
WednesdayLoaded 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.
ThursdayPivot tables
FridayQuiz four

Week Six

MondayGraphing polynomials
TuesdayReview
WednesdayFinal

UBLee LingCOMFSM