Course Title  Level  Campus 

Calculations and mathematics using spreadsheets and databases  PreJuniors  Kosrae 
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.
Monday  Orientation  

Tuesday  Pretest  
Wednesday  Calculator • View • Clear • arithmetic ops • reciprocal • powers • roots • base changes •  
Thursday  Introduction 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

Monday  Review 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. 
Wednesday  If then else including isblank() 
Thursday  Choose function 
Friday  Quiz two. Conditional function: add a gender column and a comment that varies by gender. If then else. Insert new column, enter function. 
Monday  Tuesday  Wednesday  Thursday  Friday  

Data entry and cell formatting. Decimal places. (Utwe run
data 05 Jul 2003 16:56). XY Scatter graph.

Obtain best fit line. Add Trendline: Linear regression. Show equation. 
Predicting distance from time Inverse functions: predicting time from distance Biology lab regression. 
Nonlinear functions. Population growth and baby growth

Midterm 
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." 

Tuesday  Random number generator function to model sixsided 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. 
Wednesday  Continued to introduce statistical concepts: median, mean, standard deviation. 
Thursday  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. 
Friday  Quiz three 
Monday  Review quiz 

Tuesday  Creating subtotals. 
Wednesday  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. 
Thursday  Pivot tables 
Friday  Quiz four 
Monday  Graphing polynomials 

Tuesday  Review 
Wednesday  Final 