### UB Spreadsheets with Excel

Course Title Level Campus
UB Excel 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.

### Course Schedule and Topics

#### Week one: Basics

Monday Tuesday Wednesday Thursday Friday
Attendance. Introduction. Calculator ergonomics
Home keys
View
Clear
arithmetic ops
reciprocal
powers
roots

Not done 2003: pi
memory
transcendentals
inverse
base changes
Introduction to Excel Layout
Columns
Rows
Cells
Data entry
Arithmetic formulas
Sum function
Fill right
Dan Bricklin
VisiCalc
Copying functions

ZXCV: Undo, Cut, Copy, Paste
State Pop
Chuuk 52870
Kosrae 7354
Pohnpei 33372
Yap 11128
Quiz one

Charts
Column
Pie

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

Monday Tuesday Wednesday Thursday Friday
Layout and design considerations for Excel

Planning
Design
Label row
No blank rows
No blank columns
Students plan out address list
Reviewed quiz. Students entered address lists. Prepare master merge document using Microsoft Word, insert merge fields Perform merge. Learn to filter list. Be able to merge record range. Merge using filter options (query). Started if-then-else Quiz two. Conditional function: add a gender column and a comment that varies by gender. If then else. Inserted new column, entered 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
Mutunfunak46.37.1
Utwe61.810
Obtain best fit line. Add Trendline: Linear regression. Show equation. Predicting distance from time
Inverse functions: predicting time from distance
Non-linear functions. Population growth and baby growth
Age in months since conception Mass in kg
9 3.0
12 4.9
15 6.4
18 7.5
24 9.4
30 12.1
36 13.0
42 13.1
Midterm

#### Week Four: PowerPoint

Monday Tuesday Wednesday Thursday Friday
Reviewed Midterm Introduced PowerPoint Students work on resumé presentations: Cover, origins/beginnings, ed bg, ed goals, career goals, special skills, closure. Students present presentations Quiz

#### Week Five: PowerPoint With Graphs and Images. Databases: Access.

Monday Tuesday Wednesday Thursday Friday
Graphs Images Access: Tables Access: Queries Access: Forms

#### Week Six: Access and alternate forms of data storage and presentation

Monday
Access Reports
Tuesday
Wednesday

dleeling@comfsm.fmUBLee LingCOMFSM