CSCI 1300: Essential Computer Skills - Spring 2006 - 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

Helpful Links

Webopedia
Time


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
Helpdesk

MS Training

Semmes
Jungman

Tiger's Lair 

Blackboard
Sakai

TigerPaws

Trinity 

CompSci

  ITS 

Google 

Computer Setup

Tutorials

NOTES # TOPICS HANDS-ON READINGS/ASSIGNMENTS
1.12 1 Introduction to Course
Logon/Logoff
Password Management Site

Vidya Ananthanarayanan - New Tiger's Lair, Sakai, Set up Blog

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
1.17
1blog
2

Diane Graves, University Librarian: Copyright



Computer you use today will be yours for the course

2scavenge


 

TU library links on copyright

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)

Creative Commons (alternative to copyright)
Stock Exchange Photos (free photos)


 

1.19
2scavenge
 
3

Last Day to Register
End of Add/Drop

-----
How to Create Shortcuts to Folders and Change Icons

Jonathan Echols - Cdigix
 

3practice
3permissions
Blog Update

Blog Evaluation Checklist
Semagic

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

Text: Read and Master ch1 doing practice sections as needed
Read Chapter 4 - make Blog entry on your Word Processing Skills

 

1.24
3permissions
Blog Edit and Update
4 Joe Hatch - Maintaining Your Computer

 
4netdrives

Security and Maintenance Blog Update

-Computer Security
-Turn Off File Sharing

-Protect AIM Account
-Phishing, Email Scams, and Spoofing
-Ebay Spoof Email Tutorial

-Trojan Horses, Viruses, Worms, Spyware

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

-Crap Cleaner (removes temporary files)
Hard Drive -Clean and Defrag

-Spyware Basics - take the quiz

Tutorial on drawings and pictures in Word

Prepare for short Quiz on
Syllabus, Ethics, Computer Security and Maintenance for Quiz on Thursday, 1.26
(see links, above)
 

1.26
4netdrives
5 Short Quiz on
Syllabus, Ethics, Computer Security and Maintenance

ITS Tour:
Mike Roberts

5network
MS Word Drawing Tools

FYI - Phishing Example
FYI - Paypal Reply

Text: Read and Master ch 5(Formatting Documents) doing practice sections as needed

1.31
5network
6 Working with Windows

Working with Word

6winword
Operating System: Windows XP (link to Lawrenceville Press website)
Windows XP Basics (tips from Mrs. Belisle)
File Management Basics (saving files where you can find them and finding *lost* files)

Word Help (good reference)

Use Chapters 4 and 5 in your text as an additional reference

2.2
6winword
7 Word Extras
7wordextras
Security Videos and Quizzes important

Email from Joe Hatch

Citation Machine

RefWorks

2.7
7wordextras
8 Chris Nolan:
Internet Searches
8search
Searching the Internet (TU library)
Finding Information on Internet
Steps for Better Searching (advanced search on Google)
The Invisible Web
Evaluating Web Pages (Berkeley)

FYI: Live Journal Tour

Study for quiz on ITS tour, drawing tools, grades spreadsheet, Word, security videos

2.9
8
search
9 Benjamin Harris:
TU Library
Rescheduled
9evaluate
Short Quiz

Evaluating Websites

Managing Webmail

TILT

2.14
9evaluate
10 Benjamin Harris:
TU Library

Spreadsheet Examples

10spread
Text: Chapter 7: Using a Spreadsheet, pp207-222, 230-232

Assignments -

Practice: Grades - Parts 1-3 and Part 5. (beginning on p. 210 and continuing through the chapter.) Use the file named Grades.xls in the 10spread folder

Practice: Examples p. 218-219 (Use the file named Examples.xls in 10spread folder.) (To save time, see below)


Ms. Jungman's Animated Excel Tutorials

Tutorials created by Ruth Jungman for
teacher training at Alamo Heights ISD

2.16
10spread
11 Spreadsheet Examples
11balance
 
Homework from Text:
Personal Finances Worksheet (p. 251)
Mileage_log (p. 262-3)
Mileage_summary (p. 265-6)

Reading:Text: Chapter 9 - Creating Charts
2.21
11balance
12 Spreadsheets: Sorting, Filtering, Graphing & Formatting Charts
12filter
Homework from Text:
CONTINENTS
TEMPERATURE
Pizza Palace

(see notes page for locations)

2.23
12filter
13 CommissionReview
Review of homework - spreadsheet, chart Q&A
Look through Internet Basics
Introduction to Graphical Image Formats
13review

Homework:

Review for Midterm

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

 
2.28 14 Midterm Exam    
3.2 15 Analyze midterm grades on spreadsheet
Linking Data Between Office Applications -
(Excel and PowerPoint)
15data
Text: Chapter 14 (497-532) Creating Presentations
3.7
15data
 
16 Hardware/software/operating systems
16hardware
Binary Numbers

Hardware PowerPoint

Operating Systems PowerPoint

Computer Basics U. of Melborne

3.9
16hardware
17 PowerPoint: AutoContent Wizard, Design Template, from Scratch
Inserting Pictures into Slide Presentations
17slides
PPT Blog Update
Short Hardware Quiz

Text: Ch. 15
Microsoft Training (good PowerPoint tutorials on special topics, fyi)

Recommendations for Faculty on PowerPoint (presentation to TU Teaching and Learning Committee, also presented at EDUCAUSE Conference)
Ad Bus Critique (from a friend of Dr. Semmes’ in the creative advertising business)

Sound files

 

March 13-17: Spring Break; no classes (midterm grades due Mar.13)

3.21
17slides
PPT Blog Update

 
18 Advanced PowerPoint Techniques

Web Banners in Photoshop Elements (can also be used in PowerPoint)

18banner
19present
Making a Web Graphic with PSE and Layers

Photoshop Elements 3 Toolbar

Using Special Effects with Text in Photoshop Elements

Photoshop Elements Tips

Photocollage Basics 

3.23
18banner
19present
19
Last day an undergraduate student may withdraw from a course with a "W"
Vidya Ananthanarayanan - Podcasting

Power Point Presentations and Critique

2 Part blog update on presentations for homework
Podcasting Basics
3.28
Blog Updates
 
20 Power Point Presentations and Critique (continued)

Advanced Photoshop Techniques

Adobe Photoshop Elements and Web Graphics
Download site for Adobe Photoshop Elements 4:
http://www.adobe.com/products/photoshopelwin/main.html
(click Tryout under Download in left hand column)

20postcard
Photoshop Collages
3.30
20postcard
21 Scanning and resolution

Making an Album Automatically in PowerPoint

Intro to HTML

21scan

Getting Started with HTML
Fun and Easy HTML Tutorial
HTML Help
HTML Tags

4.4
21scan
22 Hexadecimal Colors

Fixing Photos

Front Page:

  • Navigation
  • Images
  • Tables

 

22links
FrontPage Tutorial

Key West Practice Site:

Making Hyperlinks in FrontPage

Hexadecimal Colors on the Web

Read: Web Colors Tutorial  

4.6
22links
23 Imagemaps in Front Page

Table Structure in Front Page

Evaluating Website Design

Planning you Website

23webplan
FYI - Accessibility Issues, Front Page, and the Internet
(WCAG - Web Content Accessibility Guidelines)

Imagemaps in Front Page

Table Properties in Front Page

MS Training: Creating a Website

4.11
23webplan
24 Short Quiz on HTML and Front Page

Evaluating Website Design (Cont'd)

Interactive and Extra Web Page Features


25myweb (create in class)

Resize and Resample in FP
Email Link

Color and Emotion fyi
Color Picker
What is Color? fyi

Interactive Buttons and Other Web Techniques

4.13

25myweb
25 Publish Websites to Internet

Website Presentations in Class

COURSE EVALUATION (Thanks, TAs)

26siteblog
 
4.18
26siteblog
26 Website Presentations in Class (continued if needed)

Access (Database) Introduction

27database
Access 2003 Tutorial

Access introduction from Atomic Learning

Text: pp. 377-409

4.20
27database
27 Access (Database) Continued

Hands-On test - all topics since midterm

28access
Filtering a Datasheet in Access 2003

Creating a Simple Query Using the Wizard

Relational Databases

 
4.25
28access
28 Mail Merge with Database

Review for Final

29datamerge
FinalStudy Folder
4.27
 
29 Final Exam    
5.1-5.2   Reading Days    
5.11 Grades Due for Degree Candidates (noon)