UB CA 100 Bridge Summer 2003

College of Micronesia-FSM

UB CA 100 Bridge Summer 2003

Course Title	Level	Campus
UB CA 100 Bridge	Post-Seniors	Kosrae

Course Description

The Upward Bound students have already studied Word and Excel. This course reviews their knowledge, covers the extant CA 100 outline, and goes beyond both the CA 100 outline and the material previously covered by the students.

Course Schedule and Topics

Week One: Internet and web page resumé

Monday	Tuesday
Re-introduction and attendance Introduction to Hardware keyboard mouse disk drives monitor CPU Printer ergonomics Home keys Use of Notepad or TextEdit TeXT format Starting up Typing New Open Save Save as Print Undo Cut Copy Paste Delete Select all Time/date Word Wrap Search Help Scrollbars Text advantages Start typing up resumé: Name address ed bg work bg education aspirations career aspirations	Use notepad to set up a basic web page resumé: <html> <head> <title>Your full name</title> <style type="text/css"> <!-- body {background:ghostwhite; color:darkorchid; font-family:georgia,serif} --> </style> </head> <body> <h1>Your full name</h1> <hr> <address>P.O. Box NNN<br> Kosrae FM 96941</address> <h2>Education</h2> <ul> <li>Diploma, Kosrae High School June 2003, Federated States of Micronesia</li> </ul> <h2>Experience</h2> <ul> <li><strong>[Dates, reverse chronology]:</strong> [Action verb if possible] [Work, volunteer, community, or leadership experience]</li> <li><strong>June 2003 - Present:</strong> Filed and organized documents for the clerk of the Kosrae Supreme Court as part of a Work Study program.</li> <li><strong>September 2001 - September 2002:</strong> Treasurer Tafunsak Etawi Srisrik choir, Tafunsak, Kosrae.</li> </ul> <h2>Educational Plans</h2> <p>Attend Wasatch Valley College and graduate with a bachelor's degree in genetic counseling.</p> <h2>Career Aspirations</h2> <p>Return to Kosrae to set up a <a href="http://www.nsgc.org/"> genetic counseling practice.</a></p> </body> </html> Remember to save as "yourfullname.html" without any spaces or punctuation marks. Attach to an email and email to dleeling@comfsm.fm Attachment instructions in class.

Monday

Tuesday

Re-introduction and attendance
Introduction to Hardware keyboard
mouse
disk drives
monitor
CPU
Printer
ergonomics
Home keys
Use of Notepad or TextEdit
TeXT format
Starting up
Typing
New
Open
Save
Save as
Print
Undo
Cut
Copy
Paste
Delete
Select all
Time/date
Word Wrap
Search
Help
Scrollbars
Text advantages
Start typing up resumé:
Name
address
ed bg
work bg
education aspirations
career aspirations

Use notepad to set up a basic web page resumé:

<html>
<head>
<title>Your full name</title>
<style type="text/css">

</style>
</head>
<body>
<h1>Your full name</h1>
<hr>
<address>P.O. Box NNN<br>
Kosrae FM 96941</address>
<h2>Education</h2>
<ul>
<li>Diploma, Kosrae High School June 2003, Federated States of Micronesia</li>
</ul>
<h2>Experience</h2>
<ul>
<li><strong>[Dates, reverse chronology]:</strong> [Action verb if possible] [Work, volunteer, community, or leadership experience]</li>
<li><strong>June 2003 - Present:</strong> Filed and organized documents for the clerk of the Kosrae Supreme Court as part of a Work Study program.</li>
<li><strong>September 2001 - September 2002:</strong> Treasurer Tafunsak Etawi Srisrik choir, Tafunsak, Kosrae.</li>
</ul>
<h2>Educational Plans</h2>
<p>Attend Wasatch Valley College and graduate with a bachelor's degree in genetic counseling.</p>
<h2>Career Aspirations</h2>
<p>Return to Kosrae to set up a <a href="http://www.nsgc.org/"> genetic counseling practice.</a></p>
</body>
</html>

Remember to save as "yourfullname.html" without any spaces or punctuation marks. Attach to an email and email to dleeling@comfsm.fm Attachment instructions in class.

Wednesday	Thursday	Friday
Adding images to web pages using paint or freefoto.com Integrating an image or drawing: Paint for drawings Toolbox Color box Custom colors Status bar Translations Attributes Draw opaque Key constraints on shapes: effect of shift key Images freefoto.com Frame and text flow around images Code snippet, image tag must be enclosed in paragraph container. (image in same folder at html file): <p> <img src="imagefilename.gif" alt="alternate text description" style="float:right"> </p> Remote image retrieval: <p> <img src="http://shark.comfsm.fm/ ~dleeling/ub/serlinda.jpg" alt="Miss Pohnpei 2002-2003"> </p>	Email Hotmail Yahoo COMFSM WebMail Email etiquette Chain letters Viruses Hoaxes Urban Legends Bank info hoaxes ALL CAPS Netiquette Flaming Chat acronyms The World Wide Web Google Kartoo Searchenginewatch Search engine show down Advanced search ops Trusted sources CNN Time EB Plagiarism Copyright Ownership Ease of detection https credit card debt issues know vendor! Amazon Barnes and Noble Roadrunnersports Walmart	Quiz. Make a page. Title: Kenye runs away! Background: Color: Font-family: Tahoma Header level one: Kenye Insetlang joins the circus! Image: http://shark.comfsm.fm/ ~dleeling/ub/kenye.jpg Paragraph: In late breaking news Kenye Insetlang has run off and joined the circus! She gave the following reasons for joining the circus. Bulleted list, unordered: For the adventure For the excitement For the thrills Hyperlink: http://www.comfsm.fm/ ~dleeling/pohnpei/family_may2003.html Post-quiz: story time.

Wednesday

Thursday

Friday

Adding images to web pages using paint or freefoto.com

Integrating an image or drawing:

Paint for drawings

Toolbox
Color box
Custom colors
Status bar
Translations
Attributes
Draw opaque
Key constraints on shapes: effect of shift key

Images
freefoto.com
Frame and text flow around images

Code snippet, image tag must be enclosed in paragraph container. (image in same folder at html file): <p>
<img src="imagefilename.gif" alt="alternate text description" style="float:right">
</p>

Remote image retrieval:

<p>
<img src="http://shark.comfsm.fm/ ~dleeling/ub/serlinda.jpg" alt="Miss Pohnpei 2002-2003">
</p>

Email

Hotmail
Yahoo
COMFSM WebMail
Email etiquette
Chain letters
Viruses
Hoaxes
Urban Legends
Bank info hoaxes
ALL CAPS
Netiquette
Flaming
Chat acronyms

The World Wide Web

Google
Kartoo
Searchenginewatch
Search engine show down
Advanced search ops
Trusted sources
CNN
Time
EB
Plagiarism
Copyright
Ownership
Ease of detection
https
credit card
debt issues
know vendor!
Amazon
Barnes and Noble
Roadrunnersports
Walmart

Quiz. Make a page.
Title: Kenye runs away! Background: Color: Font-family: Tahoma
Header level one: Kenye Insetlang joins the circus!
Image: http://shark.comfsm.fm/ ~dleeling/ub/kenye.jpg
Paragraph: In late breaking news Kenye Insetlang has run off and joined the circus! She gave the following reasons for joining the circus.
Bulleted list, unordered:

For the adventure
For the excitement
For the thrills

Hyperlink: http://www.comfsm.fm/ ~dleeling/pohnpei/family_may2003.html

Post-quiz: story time.

Week Two: Word Review

Monday
Use Microsoft NotePad to compose a story using HTML. Create the same story using Microsoft Word with an illustration. The story should be a local story. Use paint to add a picture appropriate to the story. The Princess Lupanmwet Lupanmwet. Nefalil, Utwa. Wife. Banana grower and magician. Usr, ut. Togosrai, Lelu people stole bananas. Lu took sand from Mutunpuk, went to Mutunlik and cast it upon the water. Sand bridge to Fukul. Invisible, took back bananas. Fled, visible on bridge. Lelu gave chase. Bridge collapse, people drown. At Leyot Lelu people closing in. At Puk Lu hides. Lelu people pass by. Lu follows. Lelu people wait at Taf beach and Finkol River head. Lu takes fuliohful (Sonneratia alba) from Mutunfunak, hid in it. Floated to Finpuksrusra, past Lelu people. Fuliohfohl now grows at Finpuksrusra. Lelu people failed to catch Lupanmwet.

Monday

Use Microsoft NotePad to compose a story using HTML. Create the same story using Microsoft Word with an illustration. The story should be a local story. Use paint to add a picture appropriate to the story.

The Princess

Lupanmwet
Lupanmwet. Nefalil, Utwa. Wife. Banana grower and magician. Usr, ut. Togosrai, Lelu people stole bananas. Lu took sand from Mutunpuk, went to Mutunlik and cast it upon the water. Sand bridge to Fukul. Invisible, took back bananas. Fled, visible on bridge. Lelu gave chase. Bridge collapse, people drown. At Leyot Lelu people closing in. At Puk Lu hides. Lelu people pass by. Lu follows. Lelu people wait at Taf beach and Finkol River head. Lu takes fuliohful (Sonneratia alba) from Mutunfunak, hid in it. Floated to Finpuksrusra, past Lelu people. Fuliohfohl now grows at Finpuksrusra. Lelu people failed to catch Lupanmwet.

Tuesday	Wednesday	Thursday
Files and file sizes: Size issues Stone Song Text TXT 2834 Stone Song Rich Text RTF 3366 Stone Song Web Page HTML 3933 Stone Song Word DOC 22016 View menu Toolbars Ruler Spellcheck Thesaurus Indentation First line indents Hanging indents Font family Serif sans-serif Cursive fantasy monospace Font size Font style: italic Font weight: bold Font decoration: underline Font color Text align	Introduction to Word Advanced Editing Properties Overtype Insert Find Replace Different first page Creating a cover page Horizontal centering Vertical centering View menu Normal Page layout Toolbars Block indents Spacing Bulleted lists Numbered lists Creating an outline in standard academic format Breaks Soft return/word wrap Hard return/paragraph Line feed (shift-enter) Soft page break Hard page break (control-enter) Numbering pages	Header Footer Advanced table formatting Merging cells Borders, backgrounds, font colors, and highlighting. Insert menu symbols fields eq doc info Microsoft Publisher once over very lightly. Prepare a basic certificate. Work in pairs.

Friday
Quiz two For what types of projects is Microsoft Publisher best used? What are the conditions under which you can use an image on the Internet? How should large blocks of text be handled in Microsoft Powerpoint? What are some guidelines to font choices and some font problems to watch out for in Powerpoint? Create a perfect square in Paint with a border Red=192 Green=0 Blue=192 and center Red=255 Green=128 and Blue=0 Microsoft Powerpoint presentation start. Worked individually. Include name, origins, early years, educational background, special achievements, educational goals, intended College, major, and career aspirations. Plus: If a college were to ask you why they should accept you, what would you say you would bring as person to that institution that is unique. Present to class.

Friday

Quiz two

For what types of projects is Microsoft Publisher best used?
What are the conditions under which you can use an image on the Internet?
How should large blocks of text be handled in Microsoft Powerpoint?
What are some guidelines to font choices and some font problems to watch out for in Powerpoint?
Create a perfect square in Paint with a border Red=192 Green=0 Blue=192 and center Red=255 Green=128 and Blue=0

Microsoft Powerpoint presentation start. Worked individually. Include name, origins, early years, educational background, special achievements, educational goals, intended College, major, and career aspirations. Plus: If a college were to ask you why they should accept you, what would you say you would bring as person to that institution that is unique. Present to class.

Week Three: Excel

Monday	Tuesday	Wednesday	Thursday	Friday
PowerPoint presentations.	Excel Data Entry & Functions More functions If Then and Frequency Charts Data entry and cell formatting. Decimal places. (Population) Functions Min Max Mode Average Median Stdev	Form letters	Subtotals Pivot tables Advanced decision making functions	Midterm

Week Four: Excel:, XY Charts, working with numbers, linear regressions

Monday	Tuesday	Wednesday	Thursday	Friday
XY Scatter graph and best fit line Predicting distance from time Inverse functions: predicting time from distance	Nonlinear regression: baby growth	Forms	Reports	Quiz

Week Five: Access

Monday	Tuesday	Wednesday	Thursday	Friday
Tables	Queries	Forms	Reports	Quiz

Week Six:

Monday	Tuesday	Wednesday	Thursday	Friday
Tables	Queries	Forms	Reports	Mail merges. Quiz.

Week Six: Specialized software and closure

Monday	Tuesday	Wednesday	Thursday	Friday
Genograms	TBD	Wrap up and review	Finals	Finals