College of Micronesia-FSM

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
Image of Calculator Population spreadsheet

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
Address system
Data entry
Arithmetic formulas
Address based 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
Address list

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

Linear regression of a run to Utwe Baby mass growth

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

genospread (28K)

Monday
Access Reports
Tuesday
leeling (27K)
Wednesday
  leelinggeno (22K)
dleeling@comfsm.fm • UB • Lee Ling • COMFSM