tut2 

CSCI 1300: Essential
Computer Skills

Spring 2007

 

mouse
RSS

Coates
Library

Webopedia

Helpful
Links

MS Training

Helpdesk

Academic
Calendar

Tiger's Lair 

Blackboard

TigerPaws

Trinity 

CompSci

  ITS 

Google 

Computer Setup

Tutorials

NOTES # TOPICS HANDS-ON READINGS/ASSIGNMENTS
TR 1/11

 
1

Introduction to Course
Logon/Logoff
Password Management Site

Making a Weblog

Setting up a Blog on LiveJournal

LiveJournal FAQ

Choose computer for semester next class

1blog

Syllabus
Course Outline

ITS - Student Resources

Code of Ethics for Computing
Code of Ethics for Electronic Mail and Voice Mail

Academic Honor Code

Copyright Policy

Plagiarism

Computer Security

TU 1/16
1blog


 
2 Livejournal Updates

How to Create Shortcuts to Folders and Change Icons

Choose computer for semester - do not choose back row or last two rows closest to wall

2practice
2scavenge

General ITS Info:
Network Drives
and other important services

ITS FAQ

Lab: Desktop and My Documents

TR 1/18

 
3  

Using the MS Word Drawing Tools

Joe Hatch, ITS

3netdrives
Joe Hatch Blog Update
Tutorial on drawings and pictures in Word

Making Screen Captures:

Back up Important Files ... Don't open email attachments you aren't expecting even if they are from someone you know ... Turn off your file sharing ... Don't click on hyperlinks you aren't sure about ... Don't respond to pop-up solicitations ... Read the "terms of agreement" before downloading free programs ...

Protect Your Computer and Yourself  
Protect AIM Account

Turn Off File Sharing

Phishing, email scams

Spyware Basics - take the quiz

Trojan Horses, Viruses, Worms, Spyware

Identity Theft
 | How ID Theft Happens | Reduce Your Risk

Improve Your Computer's Performance 
CCleaner (removes temporary files)
Defragment Your Hard Drive

TU 1/23
 

2scavenge
3netdrives

Joe Hatch Blog Update
(all due 30 minutes before class)

4 Making Screen Captures

Diane Graves/Jason Hardin:
Copyright

4BlogCopyright

Ten Big Myths about Copyright Explained
Friends of Active Copyright Education
When Copying is OK: The "Fair Use" Rule

Trinity University's Copyright Policy
TU library links on copyright
Copyright FAQs from US Gov't.
Copyright Policy for Students Using TU Resources


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

Copyright Challenge (take the quiz online)

TR 1/25
4BlogCopyright


 
5 MS Word Advanced Drawing

Fred Zapata, Computer Network

5network
How Your Computer Connects to the Internet

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

 


TU 1/30
5network

 
6 Quiz 1, Tuesday, January 30. The quiz will cover everything we have done so far this semester, including hands-on assignments and practices in class, homework assignments, reading and information from all of our guest speakers.

MS Word Formatting Skills

 

6winword
 

Belisle's Easy Design Tips

MS Word:

Indentations and tables
Text boxes and layout
Insert and resize graphics
Format text in columns
Borders and text
Copy information from Internet to clipboard and insert in a table

Word Help (good reference)

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

TR 2/01
6winword
 
7 Quiz Review

MS Word Formatting Skills (Pt. 2)

Document Collaboration

7wordextras
Citation Machine


FYI - Translating in MS Word
TU 2/06
7wordextras
8 Benjamin Harris

Managing Email

8library
RefWorks

Before Pressing Send (GRASS test)
12 tips for email etiquette
Email Check List
Professional Email Video

Writing Effective Email

Text: Chapter 1-3

TR 2/08
8library
9 Chris Nolan

Effective Internet Searches

9search
Word: Autocorrect-signatures

Internet Help (TU library)
Advanced Google Search (Nolan)
The Invisible Web

Librarians' Index to the Internet
Infomine
Trinity Library lists

Web Research Evaluation Check List

Text: Chapter 7 - Spreadsheets

TU 2/13
9search
10 Introduction to Spreadsheets:
MS Excel
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 blank file named Grades.xls in the 10spread folder
Practice: Examples p. 218-219 Use the blank file named Examples.xls in 10spread folder.

Microsoft Excel Basics: Tutorial

TR 2/15
10spread
11 Quiz 2:  Material covered from the beginning of the semester, including guest speakers

Spreadsheets, Continued

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

TU 2/20
11balance
12 Quiz 2, short review

Spreadsheets: Sorting, Filtering, Graphing & Formatting Charts

Intro to the Internet

12filter

p. 303 CONTINENTS, part 1;  p. 307 part 2

p. 332 COUNTRY STATISTICS

p. 288 ex. 2 Pizza Palace.xls (in 12filter)
p. 339 ex 11 Continuation of Pizza Palace.xls (pie chart)

Read Chapter 8 (Working with Functions and Organizing Data)

Internet Basics, Part 1

TR 2/22
12filter
13 Review of homework - spreadsheet, chart Q&A

Spreadsheets, continued

Internet Basics, Part 2

Introduction to Graphical Image Formats

13review

Homework:

Complete SeptHighs, QB Ratings

Review for Midterm, including Internet Basics, Part 1&2 and Graphical Image Formats

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

TU 2/27
 
14

Mid Term Exam

   
TR 3/1
13review
15 Analyze midterm grades on spreadsheet
Linking Data Between Office Applications -
(Excel and PowerPoint)
15data

Dynamic Links

Text: Chapter 14 (497-532) Creating Presentations

TU 3/6
15data
16 Bringing together graphics and presentations

Animating a GIF file in Photoshop Elements 3

Evaluating Vista

16animate
 
TR 3/8
16animate
17 Larry.Hechler@Trinity.edu
Hardware Technician Supervisor 

Information Technology Services

PowerPoint Methods, Tips, and Tricks:
PowerPoint: AutoContent Wizard, Design Template, from Scratch

Inserting Pictures into Slide Presentations

17slides

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)
Really Bad Power Point - and How to Avoid It

Sound files

   

Spring Break Mar. 10-18, Mid-Term Grades Due March 12

TU 3/20
17slides
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 

TR 3/22
19present
19 Power Point Presentations

Advanced Photoshop Techniques

Adobe Photoshop Elements and Web Graphics
Download site for Adobe Photoshop Elements 5:
http://www.adobe.com/downloads/

20postcard
Photoshop Collages

Downloading PSE 5 from Adobe

FYI - Ms. Dewey

TU 3/27
 
20 Advanced PhotoShop, Continued   Photoshop Collages

Downloading PSE 5 from Adobe

Opening a new file in PSE5

Fun PSE Tutorials
TR 3/29
20postcard
21 Scanning and resolution

Intro to HTML  

21scan

Image File Sizes

Image Size and Resolution

Scan Wizard 5 in IMS

Scan Using the HP Software in Halsell Lab

Scan Using Photoshop Elements in Halsell Lab

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

 

TU 4/3
21scan
22 Hexadecimal Colors

 

Front Page:

  • Navigation
  • Images
  • Tables
22webplan
FrontPage Tutorial

Key West Practice Site:

Making Hyperlinks in FrontPage

Hexadecimal Colors on the Web

Read: Web Colors Tutorial

TR 4/5
22webplan
23 Vidya Ananthanarayanan
Social Bookmarking/Software,
Podcasting, del.icio.us, RSS
23vidya
blog entry
http://office.microsoft.com/en-us/frontpage/FX100647001033.aspx
TU 4/10
23vidya
blog entry
24 Short Quiz, Front Page and HTML

Imagemaps

Evaluating Website Design (Cont'd)

Interactive and Extra Web Page Features

24imagemap
25myweb (create in class)

Resize and Resample in FP

Color and Emotion
Color Picker
What is Color?

Interactive Buttons and Other Web Techniques

An Artist's Web Site

TR 4/12
24imagemap
25 Fixing Photos

Work in Front Page

25working
Front Page FAQs
TU 4/17
25myweb
26 Publish and Present Websites

Course Evaluations CSCI-1300-1&3
(Thanks, TAs)

26webblog
 
TR 4/19
26webblog

 
27 Access and Databases
27access
Access 2003 Tutorial

Access introduction from Atomic Learning

Text: pp. 377-409

TU 4/24 28 Mail Merge
27access
28mailmerge
 
TR 4/26 29 Final Exam    
   

Reading Days April 30-May 1

   

Final Exams May 1-8

Sat 5.12   Commencement    
M 5.14   Grades Due