CSCI 1300: Essential Computer Skills - Fall 2005 - Lyn Belisle, Instructor

 lyn.belisle@trinity.edu

Office: Halsell 201G
 (
Map)

  http://www.cs.trinity.edu/
~jbelisle/cs130
0

8:30 Blog
11:20 Blog

Articles
Webopedia
 


Office Hours: 
TU 10:00-11:00, 2:00-4:00
TH 10:00-11:00, 2:00-4:00
or by appointment

Office Phone: 999-7426
Home Phone: 826-6860

Academic Calendar
 

Teaching Assistants:

Sara Hills 8:30
sara.hills@trinity.edu

lindsay goetz 11:20
lindsay.goetz@trinity.edu
(210) 733-939

Helpdesk
MS Training

Semmes
Jungman

Tiger's Lair 

Blackboard

TigerPaws

Trinity 

CompSci

  ITS 

Google 

Computer Setup

Tutorials

NOTES # TOPICS HANDS-ON READINGS/ASSIGNMENTS
8.25 1 Introduction to Course
Logon/Logoff
Password Management Site
Setting up a Blog on LiveJournal

LiveJournal FAQ

Choose computer for class on Tuesday

1blog
Syllabus
Course Outline

ITS - Student Resources

Code of Ethics for Computing
Code of Ethics for Electronic Mail and Voice Mail
8.30
1blog
2 Using Network Folders

Taking Screen Captures



Computer you use today will be yours for the course

2scavenge


 

-Computer Security
-Turn Off File Sharing
-Protect AIM Account
-Trojan Horses, Viruses, Worms, Spyware

-Identity Theft and Spyware (all pages)
-Identity Theft (.gov site for education)

-Ccleaner
Hard Drive -Clean and Defrag

Before Thursday's Class
Spyware Basics - take the quiz
 

9.1
2scavenge
 
3 Joe Hatch - Maintaining Your Computer:
Turn off Peer-to-Peer File Sharing
-Be Cautious with AIM and Email
-Back up Important Files
-Remove Temporary Files - Crapcleaner
-Remove Spyware - Ad-Aware SE
-Install Windows Updates - SP2
-Check Antivirus Software - Are file definitions updates current? Are viruses that are found being deleted? Other?
-Check for Program Updates - Office and others
-Hard Drive: Disk Cleanup and Disk Defragmenter
-----
How to Create Shortcuts to Folders and Change Icons

 
3setup
Blog Evaluation

Basic Computer Concepts (written for faculty - shows faculty network drives)
Student Network Drives
Lab: Desktop and My Documents

Prepare for Quiz on
Syllabus, Ethics, Computer Security and Maintenance for Quiz on Tuesday, 9.6
(see links, above)

9.6
3setup
4 Quiz 1

Using Microsoft Word to make drawings and diagrams

Folders and Permissions

4permissions
Easy Design Tips

The Drawing Toolbar

Tutorial on drawings and pictures in Word

9.8
4permissions
5 Stephen Perez - ITS Tour

Review Quiz 1

Setting Up Your Grades Spreadsheet

5network

Grades

Tour of Computer Facilities
9.13
5network
6 Diane Graves -  Copyright

Coates Library's Links on Copyright

6blogupdate

6spell

-Copyright Policy for Students Using TU Resources
-Ten Big Myths about Copyright Explained
-Friends of Active Copyright Education
-When Copying is OK: The "Fair Use" Rule
-Copyright Challenge (take the quiz online)- know answers
-Creative Commons (alternative to copyright)
-Stock Exchange Photos (free photos)
9.15
6blogupdate
7 Email and the Internet
6spell

7internet

-Web Mail Tutorial on Help menu
-Global Address Book in Web Mail
-Email attachments - sending and reading
-Email Folders (Web Mail and Outlook)
Check email spelling:
-Outlook
-Web Mail

Internet Basics Part 1, Part 2

Text: Know the material in Chapter 1, Microsoft Office Basics. Know the email material in Chapter 2, Using a Communications Application, beginning on page 35.

 

9.20
7internet
8 Formatting Pages with Microsoft Word
8flyer

Saving Pictures from the Internet
Using Office Clip Art
MS Clipart Copyright Info

-Word Help (good reference)
-
Operating System: Windows XP (link to Lawrenceville Press website)
Text: Ch 4, Ch 5, Ch 6 (175, 185, 189, 190, 191, 195)
9.22
8flyer
9 Chris Nolan - Information on Internet
MS Word Extras
9search
Drop Caps
Format Painter
Autocorrect
Citation Machine

-Searching the Internet (TU library)
-Finding Information on Internet
-Steps for Better Searching (advanced search on Google)
-The Invisible Web
-Evaluating Web Pages (Berkeley)

 

9.27
9search
10 Jonathan Echols - Cdigix
10spread
9.29
10spread
11 Benjamin Harris -TU library website
Spreadsheets, continued

 
11spreads:

Homework: Complete grades, examples, and copy exercise from last class. Complete text ex. 7 p.251 (file: personal_finances in 11spreads folder)

Text: Chapter 7: entire chapter, Chapter 8: pp. 259-274

Good to Know:
Mrs. Jungman's
Excel Tutorial Movies

 

10.4
11spreads
12 Word: Create spreadsheet in word document (Insert Object)
Watermarks
Spreadsheets: Absolute and Relative Cell References,  Conditional Formatting
Merging Cells

Charts and Graphs in MS Excel

12graph>12homework
  • p. 262 mileage_log

  • p. 265 mileage_summary

  • p. 303 continents, part 1; part 2, p. 307

  • p. 311-317 temperature, part 1

Text:
Chapter 9 - Creating Charts
 

Microsoft Training:
Creating Charts

Quick Reference Card

10.6
12graph
13 Introduction to Image File Formats

Mid-term Review

 
13review

Homework:

Review for Midterm
Read Appendix B (Digital Images) in text (pp. 565-568)

Review:
  • Class Notes
  • Assignments in Shared Folders
  • Textbook Readings (Ch. 1-9)
 
10.11
13review
14 Mid-Term (partly hands-on)
Class work, hands-on assignments, reading assignments, text: Ch 1-9
   
10.13 15 Analyze midterm grades on spreadsheet
Linking Data Between Office Applications -
(Excel and PowerPoint)
15data

Homework:
Complete Power Point Presentation

Dynamic Links

Text: Chapter 14 (497-532)
Creating Presentations

10.18
15data
16 Hardware/software/operating systems

Ergonomics

16hardware
Binary Numbers
OSHA recommendations for healthy computing
Healthy computing from Microsoft
Self-evaluation checklist
Healthy Computing
10.20
16hardware
17 Animated Gifs in Photoshop

Power Point Design and Animation

Presentation in
17present
Text: Advanced Power Point Presentations (pp. 533-558)

Sound files

10.25
17present
18 Power Point Presentations and Critique

Photoshop Elements Techniques

18postcard
 
10.27 19

Cyber Crime Presentation Overview: Todd Corley, Steve Smith - FBI

11:20 Class meet in Chapman Auditorium

Blog Update on FBI Presentation
Photoshop Elements 3 Toolbar

Using Special Effects with Text in Photoshop Elements

Photoshop Elements Tips

Photocollage Basics

11.1
 
20 Postcard Practice

Presentations

18 postcard
Photoshop Elements 3 Toolbar

Using Special Effects with Text in Photoshop Elements

Photoshop Elements Tips

Photocollage Basics 

11.3
18postcard
21 Intro to Scanning images

Making a Photo Album Using Power Point

Intro to HTML

21scan
What is a Digital Image Anyway?

Text, pp. 549-551

Fun and Easy HTML Tutorial
HTML Help

 

11.8
21scan
22 Intro to HTML, continued:
Headings and Lists

Making a Web Banner for your Site

Intro to FrontPage
 

22colors
Web Design Basics

Kodak's Digital Picture Tips

Elements of Design for Web

 

11.10
22colors
 

23 Front Page

Imagemaps

 

23oneweb

FrontPage Tutorial
Removing Borders From Table

Working with Tables in FrontPage

Making Hyperlinks in FrontPage
 

11.15
23oneweb
24 PSE Photofix Tools

Navigation Tools and Setup

 

24myweb
Design 800 x 600
Working with Tables in FrontPage
 
11.17 25 Interactive Webpage Elements

Colors for the Web

  FrontPage Color from Images
Web page color codes
Color Picker
What is Color?
11.22
24myweb
26 Web Publish and Present
Class Eval Forms
26siteblog
Glossary of Internet Terms
How Internet Infrastructure Works Read the section about the Internet-topics listed at bottom of the web page up through Ports.
How TCP-IP Works

Website Notes (save to your folder if you like or use paper copy)

11.24 27 No class: THANKSGIVING

 
11.29
26siteblog
28 Intro to Access and Databases

Hands-on Exam

28database

Access 2003 Tutorial

Access introduction from Atomic Learning

Text: pp. 377-409

12.1
28database
29 Access: Mail Merge
29datamerge
If you have a conflict for the regularly scheduled final exam, email me ASAP with the name of the class that conflicts and I will put you on the make-up list
12.6 30 Website presentations, Review for Final
30finalblog
 

 

Final Exam: Thursday, Dec. 8, 2005, 6:30-7:30 PM
Make-Up Final Exam: Monday, Dec 12 only for students who are taking
Acct 1302 (1-2), Biol 2320 (1-2), Econ 1311 (all sections), Econ 1312 (all sections) or PLSI 1312 (all sections)
8:30 - 9:30 AM
RCC 319-320 - Upstairs in Laurie Auditorium