Course Title | Level | Campus |
---|---|---|
UB Excel | Pre-Juniors | Kosrae |
Course introduces students to spreadsheets using Microsoft Excel. Course also integrates arithmetic and algebraic concepts, reinforcing student knowledge of mathematics.
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
|
Quiz one Charts Column Pie |
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. |
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 |
Non-linear functions. Population growth and baby growth
|
Midterm |
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 |
Monday | Tuesday | Wednesday | Thursday | Friday |
---|---|---|---|---|
Graphs | Images | Access: Tables | Access: Queries | Access: Forms |
Monday | |
---|---|
Access Reports | |
Tuesday | |
Wednesday | |