Syllabus:
CGS 1100: Introduction to Computers
3 credits-e-Learning
Fall 2003 Section: 17510
SITE: Brandon
Campus Orientation
DAY/TIME: live
chat/email/threaded discussions online-Monday
HCC Course Description:
This course is a general
introduction to information processing with modern computer systems. Basic hardware and software concepts are
covered. Topics include data representation, the central processing unit,
media, operating systems, file organization, and programming languages. This is
a lecture/discussion course, but includes projects and "hands-on"
applications. Designed for the student who wishes to acquire a general
understanding of computer hardware and software.
PREREQUISITES: None required
This
course may be used for the general education
compute requirement for AA degrees. Keyboarding skill highly suggested, e-Learning
students must have Internet access and email skills.
Course Objectives: (HCC Course Outline
Model)
The student will be able to:
- Recognize the prevalent input devices and associated media. (5.02-5.15)
- Recognize the prevalent output devices and associated media.(6.01-6.27)
- Recognize the prevalent secondary storage devices and associated
media.(7.02-7.28)
- Name the significant people responsible for the development of
electronic data processing.(1.50-1.63) [Special Feature: Timeline 2004]
- Name the three generations of computers and the hardware and
software associated with each. (1.50-1.63 plus 1.05-1.07 and 1.12-1.15)
- Name the three functions of any data processing unit. (1.22)
- Define word processing and compare and contrast it with data
processing. (3.07-3.10) {Option: Office XP Section 1.1-4.5}
- Compare and contrast hardware and software. (1.05-1.07) and
(1.12-1.15)
- Define computer assisted instruction. (CAI). (3.28, 15.15, 13.22)
- Define electronic fund transfer (EFT). (9.13)
- Define and give examples of optical character recognition (OCR).
(5.26-5.27)
- Define and show relationships between fields, records, and files. (10.05-10.06,
10.06-10.10, 10.08)
- Describe the common types of processing: control break reporting,
selecting summarizing, and classifying.
- List and explain the common computer codes (EBCDIC and ASCII). (10.05,
4.14, 4.14) also add ANSI (13.20)
- Explain how the control unit and the arithmetic/logic unit work. (4.06,
4.06)
- Define RAM (Random Access Memory) and ROM (Read Only Memory).
(4.16, 4.17-4.19; 4.20)
- Compare and contrast batch processing and transaction oriented
processing. (14.14, 14.14-14.15)
- Compare and contrast intelligent terminals and dumb terminals. (5.30)
- Define POS (Point of Sale) system. (5.30)
- Compare and contrast sequential access and random access and tell
which media have which access. (7.24, 7.24-Direct Access)
- List and define the components of a data communications system. (1.07,
9.24-9.25; 9.02)
- List the primary data communication channels. (9.03-9.04,
9.31-9.32)
- Define and give advantage of COM (Computer Output Microfilm. (7.28,
7.28-7.29)
- Describe various line configurations in a data communications
system.(9.32)
- Define multiprogramming. [multiprocessing or multitasking] (8.10)
- Define a database and query language. (10.16, 10.22, 10.23, 13.13)
- Define distributed data processing. (10.24)
- List and explain the phases in a system analysis and design. (12.02-12.03)
plus Chapter 12 also Project Management
- Define a computer program. (13.02)
- Explain the steps necessary in developing a program. (13.24)
- Compare and contrast flow charts and pseudocodes.
(13.30, 13.32)
- List and explain the three primary control structures. (13.28)
- List the most widely used higher level languages and give the types
of applications each is primarily used for.(13.06-13.23) [Logical 13.32 vs Syntax 13.34]
- Define a compiler. (13.05) [interpreter 13.05]
- Define an operating system. (1.13-1.14; 8.02-8.27)
- Define virtual storage. [primary vs
Secondary Storage 7.04-7.05]
- Participate in "hands-on" application programs on a
microcomputer.
Spreadsheet [excel](1.14,
3.12); Database [Access] (3.15, 10.03
plus Chapter 10); Presentation [Power Point] (3.16); Desktop Publishing
[Publisher] (3.21); multimedia [ToolBook or HyperStudio]
Required Textbooks:
|
|
Gary B. Shelly, Thomas J. Cashman, Misty E. Vermaat
|
|
|
|
|
|
|
Description
The most cutting-edge comprehensive computer concepts book
is here! The Shelly Cashman Series introduces you to
the latest edition of their best seller, Discovering Computers 2004: A Gateway
to Information. This is not your average book update, it’s a total revision!
Completely updated internal design and layout, major content changes and
additions, new features, more student assessment, superior student Web site,
and unparalleled teaching resources - making this book the best choice for your
computer concepts class
TABLE OF CONTENTS:
- Chapter 1: Introduction to Computers
Feature 1: Timeline 2004 - Chapter 2: The Internet and World Wide Web
Feature 2: Guide to World Wide Web Sites and Searching Techniques - Chapter 3: Application Software
- Chapter 4: The Components of the System Unit
- Chapter 5: Input
Feature 3: PDA Application Software - Chapter 6: Output
Feature 4: Digital Imaging and Video Technology - Chapter 7: Storage
- Chapter 8: Operating Systems and Utility
Programs
Feature 5: Buyer’s Guide 2004 - Chapter 9: Communications and Networks
Feature 6: A World Without Wires - Chapter 10: Database Management
Feature 7: E-Commerce 2004 - Chapter 11: Computers and Society, Security,
Privacy, and Ethics
- Chapter 12: Information System Development
- Chapter 13: Programming Languages and Program
Development
- Chapter 14:
- Chapter 15: Computer Careers and Certification
Feature 8: Trends 2004 - Appendix A: Making Use of the Web
- Appendix B: Coding Schemes and Number Systems
- Appendix C: Computer Acronyms
Link to: http://www.course.com/catalog/product.cfm?category=Computer%20Concepts&subcategory=Computer%20Concepts&isbn=0-7895-6704-0
for more information and downloads.
Web Sites:
Discovering Computers
2004:
http://www.scsite.com/dc2004/index.cfm?action=homeflash
Discovering Computers 2003 (last year):
http://www.scsite.com/dc2003/index.cfm?fuseaction=main&chap=1&module=learn
Course Technology Web
Site: http://www.course.com
Shelly Cashman Series:
http://www.scseries.com
Connect to : http://www.scsite.com/dc2003/index.cfm?fuseaction=main&chap=1&module=learn
to play Computer Genius Game and other on-line chapter exercises.
CGS 1100 students complete this game for each chapter
each week for credit.
CGS 1100 students will complete one practice quiz for
each chapter each week or online quizzes prepared by the instructor.
Optional Textbook:
I suggest students who have very minimal MicroSoft Office computer skills invest in the optional text in the bookstore and/or use online tutorials to help them learn: Word, Excel, Access, and/or Power Point and/or seek help in the Brandon Computer Lab: BTECH 203:
|
THE ADVANTAGE SERIES: Authors: Sarah Hutchinson-Clifford Glen Coulthard |
|
|
|
|
|
ISBN:
0-07-247262-6 Overview Table of Contents
|
Instructor: John T. Taylor
Office: Brandon BACA 210a
Office Phone: 253-7824; Message 253-7808
Cell
Phone: 361-4379 after
Office Hours (tentative):
MTWR 8:45-9:30
;12:15-1:00
MW 2:15-4:00; T 3:30-4:30
; M 6:00-7:00
For
current hours Link to site: http://www.hccfl.edu/faculty/john_taylor/office/office.html
Attendance:
Students not
attending the mandatory orientation class meeting (unless prior
arrangement is made with the instructor) are subject to “WNA” final grades for
"No Show".
Students absent should consult the weekly group emails or the the
course calendar at:
http://www.hcc.cc.fl.us/faculty/john_taylor/cgs1100/00calendarSum03.html
Access to Student
Emails/ Web Site Menu:
http://www.hcc.cc.fl.us/faculty/john_taylor/cgs1100/00email.html
the file name begins with 00atd followed by the
term: Sum03 for spanned Summer 2003, F03 for Fall 2003, and S04 for Spring
2004 then the extention .html
Synchronous Attendance:
The instructor may
hold biweekly sessions on the Internet via WebCT
whiteboard or the Interwise teaching platform. The
outline of the session will be sent via group email at least two days prior to
the session. These sessions will be in the evening slot on Wednesday or
Thursday nights after
Phone/Email Network:
http://www.hcc.cc.fl.us/faculty/john_taylor/cgs1100/summer03/00atdSum03.html
links to John
Taylor’s e-Learning students Summer 2003.
log-on to WebCT account
My
WebCT
Your WebCT
ID will be the first initial of your
first name and the first initial
of your last name, combined with your seven digit Student ID number (NOT Your SS#) for example:
John Taylor's user name would be jt1234567
Important Note:
Your initials are case sensitive and must be in lower case.
Your password is your six
digit birthday. For example if you were born on
E-MAIL :
jtaylor@masterlinx.net
and jtaylor@hccfl.edu and jtaylorcgs1100@yahoo.com
(Each student must have an E-mail address to
communicate in the course. Tutorial 2 pages 2.25-2.28 of the text covers email
basics. Free Emails may be obtained from HCC Brandon’s Webmaster Certification
Program. Those that do not have emails on the first day will be issued a free
email after orientation. You may also send email to jtaylor@hccbrandon.net with your
requested user name and password. Students will be issued an account : username@hccbrandon.net. Students
access: http://mail.hccbrandon.net/ to use this email. This web site has form
mail similar to Yahoo and Hotmail except
it contains no ads and is much faster.
Hotmail
[http://www.hotmail.com], MailExcite [www.mailexcite.com], Yahoo [www.mail.yahoo.com, Bigfoot
[www,bigfoot.com], or all other search engines and many web sites such as
Disney.com. Students with a private ISP without form mail access (remote site
access) must also get a free email and configure the form mail to secure emails
from the private ISP. However, Earthlink, Road Runner, and AOL has remote form
mail which may be accessed from HCC’s
classrooms or other remote sites.
E-Mail assignments
to:
John Taylor’s students must send three copies of all emails:
jtaylorcgs1100@yahoo.com and jtaylor@masterlinx.net
and jtaylor@hccfl.edu
Subjects of
emails must describe briefly the assignments being submitted and begin with: 00E:.by the e-learning students. For example: 00E: first email would be
the subject of the first email for the distance learning students.
Getting Started (Your ISP
and Email):
Sometimes the hardest
part of the course for some of the students is to gain access to the Internet
at home. Students must have access to
the Internet to complete the course. Free access is available at the public
libraries and all HCC computer labs.
However, e-Learning’s purpose is to allow the student to complete
his/her work from a distance, which the majority of the time is from the
student’s home. Most of the class members already have an Internet Service
Provider (ISP) at their home.
If you do not have access to the Internet, it
is suggested that you do not contract for an ISP that requires longer than a
one year agreement. Purchasing an ISP contract is like buying a cell phone
contract. Be careful. There are great deals out there. For example:
695online.com is a new ISP out of Daytona Beach that offers access at $6.95 per
month with local dialup. Many people are enticed by the free trial AOL deal.
AOL is good for the beginners but over priced at $23+ per month. Your
instructor’s ISP has a range of services available from their very cheap $5 per
month dialup access with no email to their most expensive family plan at $18
per month which allows six logon accounts (family and friends) with two simultaneous
users, 12 email accounts, and 25 meg of web space. Your instructor has one of
his six dialups reserved for student emergency use at no charge on a short term
basis.
When you are shopping
for an ISP, you need to find information such as:
- The monthly base fee and whether it is
unlimited access or a specific number of hours it provides.
- The hourly rate for time used over the
monthly base amount.
- Whether the telephone access number is
local or long distance.
- Which specific Internet services are included.
- What software is included.
- What user-support services are
available.
- Can you access the ISP when traveling.
Directions to set up your modem through My
Computer and Dial-Up Networking can be access through HELP. You need several things to setup the ISP: a
local dial-up phone number, your log-on user name, your log-on user pass word,
your incoming email server address and your outgoing email server address.
After being on the
Internet, students may want to have a faster connection. These services start
at $34.95 and up. Dialup access via phone is limited to 53 kbs at the very best
connection. Cable and DSL are at least twice as fast and is described in
Tutorial 1. This is the reason the
instructor recommends no long term contracts so that faster options are
available at a later time.
HCC does not allow dialup
access to the Internet. Also HCC does not assign student SMTP regular E-Mail
accounts like USF.
Therefore, each
campus student should obtain an Internet email access either through hccbrandon.net, Hotmail, MailExcite,
or Yahoo or (all are free) or a private provider (up to $23/month). By the
second week of the course the student must have an ISP and an email address.
Students receive the 50 points
by emailing the instructor at jtaylorcgs1100@yahoo.com
and jtaylor10@hccbrandon.net with cc’s to jtaylor@hccfl.edu and jtaylor@masterlinx.net with a short
message as to whether this is the student's first email or a description of the
student's past email experience. Subject of the first email is: 00e: first email.
By the end of the
second week, the instructor will send a group email to all the students in the
class. For 75 additional points the student will add all the class members and
the instructor to their address book, setup a group mail in the address book,
and send a group email to everyone in the class and Taylor’s four email
addresses. During the course the students will send biweekly group emails to
all class members and the instructor for 25 points each.
Hardware Activities:
· format a disk in DOS and Windows
· make a directory on you hard drive in
DOS and Windows
· copy a program from hard drive to
floppy disk
· burn a CD and duplicate a CD or make
a copy of a floppy disk
Internet Research Assignments:
During
the course the student will conduct major searches on the Internet. At the end
of each chapter and also located on the Learn It Online web Site is a category:
Scavenger Hunt. Students will at least be assigned an Internet Research
exercise for each chapter either from this web page or sometimes the instructor
will allow the student to select the Topic of his/her choice and/or sometimes
assigned by the instructor. The Internet
Exercise for the chapter will be posted on the Course Calendar page. These
topics will be changed from term to term.
For example:
Internet Search #1: the first search to complete Chapter 1 is one
word/one engine: what is a Neurophone and who is
Patrick Flannigan. The student should
use one Search engine using Netscape Communicator or Internet Explorer browser.
Internet Search #2: the second search to complete
Chapter 2 is two or more groups of words with Boolean Operator: "and"
The Second search is at least three words or more words in at least two groups
on at least one search engine not used in #1 using the Boolean operators: AND, OR, NOT, then you may compare your individual
results with the meta search engine: Goggle.
A sample for #2: "
gives you all web sites that has both phrases in the web page, but the phrase are not five words in a row.
Submission of Search Results
Each major search will be worth 50 points toward the final grade. It must be
submitted with up to a one page summary. If a hard copy is submitted attach lists
of the most important article(s) found plus one or two pages of the search
engine HIT List. Otherwise send the file as an attachment to an email with a
summary as follows:
a. The summary will include at least one paragraph answering the question,
b. The second paragraph will describe the techniques used such as search
engines, number of hits, the number of hits revieewed
to find the answer to the question, c. The third paragraph will describe what
you have learned or discovered in the process
Minor Searches from the Scavenger Hunt exercises from selected chapters will be worth 10-25 points.
Reference Chapter 2 (2.12-2.14)
plus Chapter 2”s special feature: “Guide
to World Wide Web Sites and Searching Techniques” pages 2.50-2.63. Students may
reference the CGS 1555 web site for additional information on conducting
on-line searching and links to search engines:
http://www.hccfl.edu/faculty/john_taylor/cgs1555/engine.html
On Line Activities:
(1) Free Time:
Students takes a lot of time to learn
about computing. Each student should
identify at least 8 hours or more per week of free time that he/she will commit
towards the completion of this course.
The following are suggested strategies for scheduling your study
times. Make an hour by hour, seven day
matrix 8 columns (hour and each day of the week) by 24 lines (representing each
hour). Upon request the instructor will provide the student with a sample hard
copy blank form or a sample will be posted on the Web Site.
Starting with wake-up and end
with sleeping:
1. Schedule fixed blocks of
time first. These include work, class time, eating, and sleeping.
2. Include time for travel
and errands
3. Schedule time for fun.
4. Set realistic goals.
5. Allow flexibility in your
schedule.
6. Study at least two hours
for every hour in class.
7. Avoid scheduling marathon
study sessions.
8. Set clear starting and
stopping times.
9. Plan for the Unplanned!
A simple time planner is available at the following Student Success Site:
http://college.hmco.com/collegesurvival/ellis/master_student/9e/students/ch02.html#ch02
Students will print out a hard copy of the free time chart for the portfolio.
(2) Discovery Wheel:
The Discovery Wheel is a giant first step
to tell the truth about yourself. It is not a test, it is a
self-assessment. The student should keep
the hard copy of the instrument by printing each page completed, and submit a
hard copy of the final wheel product for 30 points (Print one for
yourself). Students will complete their
discovery wheels using the Internet at the following URL:
http://college.hmco.com/collegesurvival/ellis/master_student/9e/students/ch01.html#ch01
Learning Styles Inventories:
(3) OnLine
MBTI:
The
instructor has an online activity which is an abbreviated version of the Myers
Briggs Inventory:
http://www.hccbrandon.net/learnstyle/bryanpsy.html
(4) OnLine
Beta LSI:
The
instructor has a Beta version of an online Learning style on the LSI page:
http://www.hccfl.edu/faculty/john_taylor/learnstyle/menu.html
Home Page Project:
Each student is expected by the end of the
course to author a three page web site to answer the question who is the student? Reference pages
2.34-2.36, 3.24,and 13.16-13.24. FTP is introduced on 2.29.
The home page will link to:
(1) The photo page will display Images collected including scanned photos ,
(2) The Favorites/Interests page will include 5 hyperlinks of favorite Internet sites and links to E-Mail should be included.
(3) The student will prepare a resume in Word and save it as a web page.
The student may post the final product at
HCC’s Student server, John
Taylor’s or Bob Harrell's servers, or the student's private ISP. The
student may use a WYSIWYG editor such as Front Page XP to develop the Web Site, otherwise the
student should download from the net the HomeSite text editor or Dreamweaver to create this project on their
personal computer. The text suggests using MS-Word to complete your pages and
use Word’s Save as Web Page feature. Front Page Express is available on the Internet
Explorer 5.0 browser as a free WYSIWYG editor. Composer is the WYSIWYG editor available on Netscape's
Communicator 4.7.
Students may also incorporate this project into the word processing,
presentation, or Microsoft Publisher’s software. HomeSite allows you a 30 day free use of the 4.5
version at: http://www.allaire.com . The student will submit
either the URL where the page is published or submit a disk in the grading
portfolio for evaluation.
Vector
and Raster Graphics Project:
Student will collect graphics from the web, scan a photo, take an electronic photo, and use a graphic package to draw several images. Paint Shop Pro 7 is available for a 30 day download and is also installed in the BTech 203 lab as well as Adobe PhotoShop 7. Microsoft also has a paint program which saves images in .bmp format, which are very large files. Formats for the photos or graphics must be in the .jpg or .gif formats for publication on the web. You have to use a graphic program to convert the file format.
Word Processing-Word XP:
Students will use Microsoft Office's Word XP to prepare several word processing documents including a Term Paper. Students must request and receive approval from the instructor if they use any other word processor. Word Perfect is a suitable substitute. Students may NOT use Microsoft Works for paper or spreadsheet activities.
For Chapter 1: Students will prepare a resume using Word.
Reference Optional Office XP text: Unit- Word 2002
CHAPTER 1: CREATING A DOCUMENT
1.1 Getting
Started with Word
1.2 Creating
Your First Document
1.3 Managing
Files
1.4
Customizing Your Work Area
CHAPTER 2: MODIFYING A
DOCUMENT
2.1 Editing a
Document
2.2 Finding
and Replacing Text
2.3 Copying
and Moving Information
2.4 Proofing a
Document
CHAPTER 3: ENHANCING A
DOCUMENT’S APPEARANCE
3.1 Formatting
Characters
3.2 Formatting
Paragraphs
3.3 Creating
Lists
3.4 Applying
Borders and Shading
CHAPTER 4: PRINTING AND WEB
PUBLISHING
4.1 Previewing
and Printing Documents
4.2
Customizing Print Options
4.3 Inserting
Headers and Footers
4.4 Using
Sections to Apply Varied Formatting
4.5 Publishing
to the Web
TERM PAPER:
Each term the instructor will
select a major topic from one of the chapters of the text to assign a term
paper. The paper will be completed in Word or another pre-approved word
processor.
For the Fall semester 2003, After
reading chapter 11, the student will submit a term paper researching the topic
on computer security for both your machine explaining: virsus, worms, Trojan
horse, spyware, and how community colleges are preparing to train students in
Cyber Security, using mainly the Internet to collect the information for the
paper.
At HCC and in the
State of
The paper will be at least three
pages, double spaced.
Web sites must be included in a reference bibliography section written in
APA style or the style displayed by the instructor. Reference the
following for the style. Go to: http://www.apastyle.org/elecref.html and select
electronic sources or: http://www.apastyle.org/elecsource.html . Please
note there are at least five different kind of Internet resources explained on
this web site.
What cyber security certificates may be earned at these colleges and what certification may be obtained from COMPTIA. Which national organizations focus on cyber security. What is the NSF scholarship for service program. Read the press release:
http://www.nsf.gov/od/lpa/news/02/pr0266.htm
The first major workshop that focused on cyber security for community colleges may be found at:
Also the agenda: http://www.aacc.nche.edu/Content/NavigationMenu/ResourceCenter/Projects_Partnerships/OtherInitiatives/Cybersecurity/Workshop_Agenda.htm
Two of the participants at the workshop published a paper on cyber security courses in community college. Please read and see if one year later their research should have been updated with newer information. As you find cyber programs at other community colleges beside the ones mentioned in the paper, you may want to use this information to contact the authors to satisfy the last objective of Search 4: http://216.239.37.100/search?q=cache:1V7YMznbip4C:www.aacc.nche.edu/Content/NavigationMenu/ResourceCenter/Projects_Partnerships/OtherInitiatives/Cybersecurity/Cybersec_Ed_in_CCs.pdf+%22Cybersecurity+Education+in+Community+Colleges+Across+America%22&hl=en&ie=UTF-8
Thirty-six universities have been designated as Centers of Academic Excellence in Information Assurance under the program. NSA granted the designations following a rigorous review of university applications against published criteria based on training standards established by the National Security Telecommunications and Information Systems Security Committee (NSTISSC).The list may be found at: http://www.nsa.gov/isso/programs/nietp/newspg1.htm#Universities On the list is Florida State University (http://www.cs.fsu.edu/infosec/). Recently they were one of 19 awarded a grant for the scholarship for service. This will be the first program in the state. Can you find FSU's abstract at the NSF. If so, include it as a direct quote for your paper.
Another question which you might address is:
What is the difference
between and hacker and a cracker. The hackers Hall of Fame may be found at: http://tlc.discovery.com/convergence/hackers/bio/bio.html
The major purpose of the paper is to use
a word processor to complete a paper for a class. The second purpose of this
paper is to learn how to site Internet reference in papers written for other
courses. This paper must be submitted in either: hard copy or with the
electronic file in Word format (xxxxxxxx.doc) . The paper will be submitted as
an attachment to an email. The student will also put a hard copy in his/her
portfolio. The student will earn 200 points
for this task.
Spreadsheets-Excel XP:
Students will use Microsoft Office's Excel XP (or Word Perfect's Quatro Pro, or Microsoft Works 4.5) to prepare several spreadsheet documents as described during the course. Review page 3.12-3.14,
Reference Optional Office XP Text:
Unit-Excel 2002
CHAPTER 1: CREATING A WORKSHEET
1.1 Getting
Started with Excel
1.2 Creating
Your First Worksheet
1.3 Editing
Your Work
1.4 Managing
Files
CHAPTER 2: MODIFYING A
WORKSHEET
2.1 Entering
and Reviewing Data
2.2 Copying
and Moving Data
2.3 Modifying
Rows and Columns
CHAPTER 3: FORMATTING AND
PRINTING
3.1 Enhancing
a Worksheet's Appearance
3.2 Applying
and Removing Formatting
3.3 Printing
and Web Publishing
3.4
Customizing Print Options
CHAPTER 4: ANALYZING YOUR
DATA
4.1 Working
with Named Ranges
4.2 Using
Built-In Functions
4.3 Creating
an Embedded Chart
Class
Presentation-Power Point XP:
Students will use Microsoft’s
PowerPoint XP to make a class presentation on a subject to be announced. The
Power point will be seven to 10 pages. It must include graphics and animation.
It should include multimedia applications such as path animation, playing an
audio file and/or video file. Review pages 3.16.
Optional Office XP Text: Unit-PowerPoint 2002
CHAPTER 1: CREATING PRESENTATIONS
1.1 Getting
Started with PowerPoint
1.2 Starting a
New Presentation
1.3 Creating a
Textual Presentation
1.4 Managing
Files
CHAPTER 2: MODIFYING AND
RUNNING PRESENTATIONS
2.1 Editing
Slides
2.2 Changing a
Presentation's Design
2.3 Running a
Slide Show
CHAPTER 3: ADDING
GRAPHICS
3.1Inserting
Clip Art, Pictures, and Graphs
3.2 Inserting
Draw Objects
3.3 Inserting
Text Labels
Data
Base Project-Access XP:
Students will use Microsoft’s Access XP
to complete data base assignment to be described during the course. The project
must include at least 25 records with at least five fields for each record in
one file. Review pages 3.15,
10.03, 10.05-10.13 plus the remaining portions of Chapter 10.
Reference Optional Office XP Text: Unit:
Access 2002
CHAPTER 1: WORKING WITH ACCESS
1.1 Getting
Started with Access
1.2 Viewing
and Printing Your Data
1.3
Manipulating Table Data
CHAPTER 2: CREATING A
DATABASE
2.1 Designing
Your First Database
2.2 Creating a
Simple Table
2.3 Using the
Table Design View
2.4 Modifying
a Table
CHAPTER 3: ORGANIZING AND
RETRIEVING DATA
3.1
Customizing Datasheet View
3.2 Sorting,
Finding, and Maintaining Data
3.3 Using
Filters
3.4 Creating a
Simple Query
CHAPTER 4: PRESENTING AND
MANAGING DATA
4.1 Creating a
Simple Form
4.2 Creating a
Simple Report
4.3 Generating
a Mailing Labels Report
4.4 Managing Database Objects
Desktop
Publishing Project:
Students will use Microsoft Publisher to create a brochure as assigned by the instructor.
Multimedia Project:
Students will Click2Learn’s Toolbook Assistant, ToolBook II Instructor, or HyperStudio to complete a multimedia Project. Students will also incorporate a Microsoft agent into either this project or the power point project. Specifics of each term’s assignment will be described in the course calendar.
On-Line
Tutorial Quizzes and Exams:
After
the first week, students will complete on-line exercises, quizzes and
exams.
The exercises are open book/notes, but must be completed
individually without assistance from peers at home. These quizzes (up
to 30 total) will be the exercises that should be completed prior to
attempting weekly online tests via WebCT. See the sections of Practice Quiz and Computer
Genius below. The onLine practice quiz is worth one point for each correct
answewr for the 15 chapters. The computer Genius Game is worth 2 points per
correct answer up to 15 correct for 30 points for each chapter. The links to
these exercises are found on: http://www.hcc.cc.fl.us/faculty/john_taylor/cgs1100/00testmenu.html
After completion of
the quiz, the student will attempt a timed on-line exam through WebCT. The WebCT
exams will be 25 randomly selected questions worth 2 points each. The student
will have only 40 minutes to complete the test. The student will be
allowed two retests to improve the grade, except the last retest will be
the score which counts toward the final grade. Students mustr wait 1-2 hours
between attempts.
OnLine practice Exams
The student will also complete the online 20 question
practice exam for each chapter prior to the test.
complete online Shelly Cashman Chapter 1
Practice Quiz:
http://www.scsite.com/dc2004/index.cfm?action=practice&isbn=0-7895-6704-0&chapter=1 (print out/email results)
Computer Genius Game:
The student will complete before
each WebCT exam, a 30 points activity by playing “Who wants to be a Computer Genius?” found
at:
http://www.scsite.com/dc2004/index.cfm?action=homeflash
Attempt
Chapter 1, which is the Internet Chapter. You have to the access Chapter 1. When
you need to do Chapter 2, click on Chapter 2 at the top of the page, then click
on "Learn It Online" from the top menu. Then select the Computer Genius under option #3.
Put you full name in the blank before you begin. Play the game. You have three
lifelines. If you complete the game successfully and become an “Computer (Internet) Genius”, print the page
as proof and note how many lifelines you used. You will receive 100% of the
points for completing the game successfully regardless of the lifelines used.
You have only 45/60 seconds to answer each question, unless you use the third
lifeline, which is consulting (Not a Friend) a particular section of the book
(Discovering Computers 2003), which stops the clock. Failing to answer a
question in 45 seconds or answering a question incorrectly burns a
lifeline.When all Lifelines are used, an incorrect answer ends the
game. You can also send the results to the instructor by
clicking: Control PrintScreen to copy the results to the clipboard
and paste it into an email. Send only to masterlinx email.You will receive
2 points for each correct answer. If you achieve Genius status and use the
lifelimes you receive 30 points-up to 18 questions...if you lose at 8 questions
then you get 16 of 30, You may play as many times as you wish until you are
satisfied with the score. Print of the results for your portfolio. If you have
trouble with screen capture then: Send a verifying email to the instructor with
your score Subject: 00e: computer Genius Chapter X
Verification.
Complete Chapter 1 "Who
Wants to be a Computer Genius" Game:
http://www.scsite.com/genius/genius_flash.cfm?ISBN=0-7895-6704-0&project=1 (print out /email results)
Muddy Water Issues:
Each day, students may use the e-mail to alert the instructor to the muddy water issue. What was confusing? What do you not understand? What problems overwhelm you? If you are absolutely on target, no problem then you will submit an email with an OK statement at least once every three weeks and a comment on which topic the instructor could have presented in a better fashion. There is also a place on the weekly Chapter quizzes developped by John Taylor for students to enter Muddy Water Issues. If left blank, then you have no problems.
Muddy Water Issues:
Each day, students may use the e-mail to alert the instructor to the muddy water issue. What was confusing? What do you not understand? What problems overwhelm you? If you are absolutely on target, no problem then you will submit an email with an OK statement at least once every three weeks and a comment on which topic the instructor could have presented in a better fashion. There is also a place on the weekly Chapter quizzes developped by John Taylor for students to enter Muddy Water Issues. If left blank, then you have no problems.
File Formats:
Windows
as well as other Microsoft Programs allow the user to save files in a ridiculous
fashion, which causes many problems on the web. What happens when a students
opens a word processor or other application and types the first letter, is that
Microsoft in their great wisdom creates a temporary name for the file which
includes the first words typed or the title at the top of the page. This
includes the NO! NO! spaces between words and super long
file names. When the student saves the file, the student is to overwrite the program’s attempt to create
these long file names with spaces and other non-letter/number symbols. It is best to keep
the file name to eight letters before the period and the extension. When working
with unsaved files, many programs such as homesite will make a back-up save, which includes a
tilde: ~hs_55sylS01.html . The tilde ~ will
truncate extra long files. The ~tilde in URL’s have a different meaning such as:
http://users.ju.edu/~mbessma/ . Please do not use more
than eight letters or numbers in a file name with no other symbols (except the
underscore if you just have to have a space in the name). The instructor will
forgive pushing it to 10 or 12 characters, but no more. Next: Do NOT use Capitol letters, except as noted
above to replace a space between two words. For every file the instructor has to
view, which violates the rule of the class, 50 points will be deducted
Academic
Software Purchases:
The student will use several software packages which are
available BTECH 203, BTECH 217 or BACA 216 labs.
The student may also wish to purchase:
Microsoft Office XP (Word, Excel, Access, Power Point,
Publisher)
Multimedia: HyperStudio or Click2Learn ToolBook II Assistant and Instructor
Web page development tools: Front Page XP, Dreamweaver MX, or HomeSite
Graphics (Paint Shop Pro or Adobe PhotoShop)
As students of HCC
you may purchase software, fully licensed, called Academic Versions for your
home use at reduced prices, which are generally lower then local stores and
online pricing deals. For example, HomeSite cost $99 when purchased from the Vendor:
Macromedia. There are often $25 or $30 rebate coupons for Office Depot, Comp
Grading
Scale
A = 90% or more of assignments completed successfully
B = 80-89 %
C = 70-79 %
Under 70% is not acceptable behavior and may result in a D or F final grade.
Instructor’s Right to Change or Modify Grading Procedures:
The
instructor reserves the right to modify or change the grading progress as the
course proceeds.
Additional course assignments may be added. Some may be
modified or deleted.
The instructor will NOT add additional major examinations as a
modification.
The course has to be flexible, each student’s circumstance will be
different according to their access to Computers and the Internet. The instructor is
requesting time commitment of at least five hours per week and up to six to ten
may be necessary some weeks of outside class time
The instructor reserves the right to reassign work to students if the instructor senses the work submitted is not the work of the student. (No questions asked-The instructor will just tell the student to resubmit the work to earn the weekly grade , quiz or assignment).
Grading Outline (tentative):
Chapter Quizzes
1300 pts
Internet Exercises 300
pts
Final Exam
200 pts
Term Paper
100 pts
Spreadsheet project
100 pts
Database project
100 pts
Power Point Project 200 pts
Desktop Publishing
100
pts
Multimedia Project 100
pts
Home Page Project 200 pts
Graphic Projects 100 pts
Homework/Lab Activites 200 pts
Total Projected ~3000 points
Instructor Requested Information:
During the first week of class, the student will a word
processor to demonstrate their current skills to immolate a 4x6 (or 3x5) file
card to provide the instructor with personal information to post on the web
under the student links.
The instructor has provided a sample below with his
personal data and his block scheduled time.
Data Card (4x6
file card): Front
Side (Personal Data)
-------------------------------------------------------------------------------------------------------------------------
Name:
John Taylor
CGS 1100
Address:
Telephone:
361-4379 (Jax 904-992-2052)
E-MAIL : jtaylor@masterlinx.net or jtaylor@hccfl.edu
Employment:
253-7936 (yes) Full time
chemistry faculty (first)
Program Manager: Computer Science-Brandon
Campus
Major: instructional
Technologies Minor:
Chemical education
Long Term Goal: Educational
Software Developer
Prerequisite: keyboarding no
Computer Skills: Win95/98 Win XP
MS-DOS yes;
Word Processor: Word 2000 or Word
Perfect 8 yes;
Spreadsheet: Excel 2000 yes
Data Base: Access 2000m yes
Languages: HTML yes,
Others: Pascal, Visual Basic, JavaScript, Open Script
HTML editor: HomeSite 4.5 yes, Front Page 2000 yes Dreamweaver yes
Multimedia: Click2Learn ToolBook II Instructor and Assistant;
Hyper Studio
-------------------------------------------------------------------------------------------------------------------------
Sample Data Card from Fall 2002 Term:
Data Card (4x6 file card): Back
Side (Scheduled Time Blocks)
|
Schedule |
Monday |
Tuesday |
Wednesday |
Thursday |
|
|
Office |
Office |
Office |
Office |
|
|
COP 1000 |
CGS 1555 |
COP 1000 |
CGS 1555 |
|
|
|
|
|
|
|
|
COP 1820 |
CGS 2820 |
COP 1820 |
CGS 2820 |
|
|
|
|
|
|
|
|
Office |
Office |
Office |
Office |
|
|
|
|
|
|
|
|
CGS 1555 |
|
CGS 1555 |
|
|
|
|
|
|
|
|
|
|
CGS 1871 |
|
CGS 1871 |
|
|
Office |
Office |
Office |
|
|
|
CGS 2820 |
COP 2822 |
|
|