Syllabus:
CGS 1100: Introduction to Computers
3 credits-e-Learning
Summer 2004
Section:
23616
SITE: Brandon
Campus Orientation 2:00-4:45 Sat 5/22BTech 217
DAY/TIME: live chat/email/threaded discussions
online-to be determined
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
computer requirement for AA degrees. Keyboarding skill highly suggested, e-Learning
students must have Internet access and email skills.
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
ISBN: 0-7895-6704-0 © 2003
Publish date: February 12, 2003
848 pages
|
|
|
|
|
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: Enterprise
Computing
- 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:
Office XP Vol I
 Visit the Book Site!
Authors:
Sarah Hutchinson-Clifford
Glen Coulthard |
|
|
|
ISBN: 0-07-247262-6
Description: ©2002 / Spiral Bound/Comb / 912 pages
Publication Date: August
2001
Overview
The
Advantage Series presents the Feature-Method-Practice approach to computer
software applications to today's technology and business students. This
series implements an efficient and effective learning model, which
enhances critical thinking skills and provides students and faculty with
complete application coverage.
Table of Contents
|
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
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
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
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
Integrating and Extending Microsoft®
XP
CHAPTER 1:
INTEGRATING WORD AND EXCEL
1.1 Using the Office Clipboard
1.2 Pasting, Linking, and Embedding
1.3 Manipulating Shared Objects
1.4 Inserting New Worksheets and Charts in Word
CHAPTER 2:
PERFORMING MORE INTEGRATION TASKS
2.1 Creating a Presentation from a Word
Document
2.3 Integrating Access with Word and Excel
CHAPTER 3:
EXTENDING MICROSOFT OFFICE TO THE WEB
3.1 Using Hyperlinks
3.2 Saving Existing Documents to HTML
3.3 Preparing Web Pages Using Office |
|
Instructor: John T. Taylor
Office:
Brandon BACA
210e
Office Phone: 253-7824; Message
253-7808
Cell
Phone:
361-4379 after 9pm or
anytime on weekends. (Emergency weekend # Jacksonville 904-992-2052)
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 should
consult the weekly group emails or the the course calendar at:
http://www.hcc.cc.fl.us/faculty/john_taylor/cgs1100/00calendarF04.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: Sum04 for Summer 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 Tuesday or Wednesday
nights after 9:30
pm
or Saturday/Sunday daytime after 10:30
am.
These session are optional.
Phone/Email Network:
http://www.hcc.cc.fl.us/faculty/john_taylor/cgs1100/spring04/00atdS04.html
links to John Taylor’s e-Learning students Spring 2004.
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 July 7,
1977, your password would be 070777
E-MAIL :
jtaylor00e@hccbrandon.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 may set this email as POP3 account with Outlook Express. Also Students
may access this account from any computer as web based mail: http://mail.hccbrandon.net/ (webbased access).
This web site also 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 jtaylor00e@hccbrandon.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. Since April 15, your
instructor has not had an ISP and has been using whatever system he is abled to
access, but when in Jacksonville her uses his wife's ISP using a Wireless access
within the home.
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 have dial up 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 $24/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
jtaylor00e@hccbrandon.net with cc to jtaylor@hccfl.edu 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 half 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.
Basic
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: " Hillsborough
Community College
" and "John Taylor"
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 Summer semester 2004, 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 Florida two new courses have been added:
CIS 1354 Introduction to Network Security and CIS 2355 Advanced Network
Security. Specifically use the above course prefix and number to see what
results you obtain using a search engine. Add a section to the term paper which
describes what courses and programs are being added in community college
curricula to teach cyber security of servers and how technicians obtain
certification in Cyber Security. Visit Seminole
Community and Valencia Community College web sites to add the additional courses
they have introduced into the state computer science curriculum. Check
Pasco-Hernando, Mantee, St Pete, Polk, and HCC to see if any of these courses
are available in the bay area.
The paper will be at least two
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:
http://www.aacc.nche.edu/Content/NavigationMenu/ResourceCenter/Projects_Partnerships/OtherInitiatives/Cybersecurity/Cybersecurity.htm
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
Optional
Desktop Publishing Project:
Students will use Microsoft Publisher to
create a brochure as assigned by the instructor. This will not be a requirement during Summer 2004
term.
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. This will not be a requirement
during Summer 2004 term.
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 must wait 1-2 hours
between attempts. During the Summer 2004 Term Chapters 12
and 15 are optional for the exams, but may be completed for bonus credit.
The final exam will have questions from these chapters
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.
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. However, you can order from an Academic Vendor such as:
Software One at 1-800-444-9890. Our HCC rep is Brian
Reagle. I must tell him or verify
to him you are a student or co-employee of HCC. Academic Dreamweaver also includes Homesite for $99 (and with Macromedia
Graphic Package Fireworks $149. You can have the entire Macromedia Suite for
$189 which also include Flash. Other good academic deals: Office XP
Profession-full version $189 (not upgrade)($129 Special Student-no database
Access), Adobe PhotoShop 8.0 $259, and Word Perfect Office Profession (including
Paradox) $93. Our Bookstore also sells Academic versions such as Dreamweaver 4.0 $99 (which includes
Homesite)—Brian’s price $94 but
you have to pay shipping.
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 (skip chapter 12,15)
Internet Exercises
300 pts
Final Exam
200 pts
Term Paper/resume 200 pts
Spreadsheet project
200 pts
Database project
200 pts
Power Point Project 200 pts
Home Page Project
200 pts
Graphic Projects 200
pts
Homework/Lab Activites 200 pts
Total Projected ~3200 points
During the Summer 2004,
only 3000 point total will be used, students have the option to drop 200 point
assignment, but not the 13 chapter quizzes.
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: 4417 Port Arthur Road
Jacksonville, Florida 32224
Telephone:
361-4379 (cell) (Jax 904-992-2052)
E-MAIL : jtaylor00e@hccbrandon.net or jtaylor@hccfl.edu
Employment: Hillsborough Community College (1969)
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 |
|
09:00-9:30 |
Office |
Office |
Office |
Office |
|
09:30-10:45 |
COP 1000 |
CGS 1555 |
COP 1000 |
CGS 1555 |
|
|
|
|
|
|
|
11:00-12:15 |
COP 1820 |
CGS 2820 |
COP 1820 |
CGS 2820 |
|
|
|
|
|
|
|
12:15-01:00 |
Office |
Office |
Office |
Office |
|
12:30-01:45 |
|
|
|
|
|
01:00-02:15 |
CGS 1555 |
|
CGS 1555 |
|
|
03:30-04:45 |
|
|
|
|
|
05:30-06:45 |
|
CGS 1871 |
|
CGS 1871 |
|
06:00-07:00 |
Office |
Office |
Office
|
|
|
07:00-09:45 |
CGS 2820 |
COP 2822 |
|
|
New Course Description and
Objectives:
Course
description: proposed
revision
Provides students with an
introductory overview of the Internet, World Wide Web, impact of computer on
society and business, historic development of data processing, basic functions
and use of computer hardware, software applications, system software, basic
skills in the use of word processing, spreadsheet, database, and presentation
system and desktop publishing software applications, basic skills using a Web
browser and search engine, and careers in the field of computer
science.
proposed
revisions
Upon successful completion of the
course, the student will be able to:
- recognize the value of computer literacy within an
individual’s personal and career environments
- identify the components of a computer
- discuss
the role the Internet and WWW serve in today’s society
- describe the categories of computers
- discuss
various computer applications in society
- recognize the difference between installing and running a
computer program
- determine how the elements of an information system
interact
- define
the roles information systems play in today’s business models
- discuss
the history of the Internet and WWW
- compare
and contrast the Internet and WWW
- describe how to access and connect to the Internet
- analyze
the components of a Web address – URL
- explain
the purpose of a Web browser
- define
the purpose of a Web server
- describe how to identify and define the purpose of a Web
page hyperlink
- define
the purpose of a search engine, search text and Web subject directories
- effectively use a search engine to locate information on
the WWW
- define
the term multimedia
- explain
the purpose of a Web portal, Web community, and Web newsgroup
- define
the term graphic and the types of graphic formats used on the Web
- define
the purpose of a plug-in as related to a Web browser
- define
the term ecommerce and the role each of the following play in an ecommerce
business model: electronic storefront, shopping cart, online auction, B2B, C2C
and C2C
- define
the purpose of the following most popular Internet services: e-mail, FTP,
newsgroups, message boards, mailing lists, chat rooms, and instant
messaging
- define
the following terms as they relate to e-mail: username, password, email
address, address book
- describe the difference between uploading and downloading
files from the Internet
- define
the term netiquette as well as identifying appropriate communication behaviors
as a user of
Internet services
- explain
how to publish a Web site
- compare
and contrast the following categories of software: packaged, custom,
shareware, freeware and public-domain
- define
the purpose of application software and system software
- define
the purpose of the following terms related to using an software application:
- desktop, icon, button, click, double-click, pointer,
menu. Command, window, title bar, clip art, format, edit, font, and font
size
- define
the general purpose of each of the following types of software applications:
word processing, spreadsheet, database, presentation, and desktop
publishing
- demonstrate the basic skills to use the following types
of software applications: word processing, spreadsheet, database, presentation
and desktop publishing
- compare
and contrast application suite, integrated software application and
application service providers
- effective use software application online help
- define
the function of the following terms related to computing: system unit,
motherboard, processor, control unit, arithmetic logic unit, machine cycle,
registers, system clock, clock speed, heat sink, heat pipe, parallel
processing, analog, digital, bit, byte, memory, memory slot, memory module,
RAM, Cache, memory cache, kilobyte, megabyte, gigabyte, ROM, firmware, Flash
memory, CMOS, access time, expansion slot, adapter card, peripheral, video
card, sound card, modem card, network card, plug and play, PC card slot, PC
card, port, serial port, parallel port, USB port, USB hub, firewire port, midi
port, IrDA port, bus, bay, power supply
- compare
and contrast the terms input and output
- define
the purpose of input and output devices
- identify various types of input and output computing
devices
- define
the terms display device, CRT, LCD
- discuss
the parameters to measure the quality of CRT and LCD display devices
- discuss
the parameters for printer quality
- differentiate between storage media and storage
device
- describe the characteristics of CD and DVD
storage media
- define
the terms reading and writing as related to storage media
- describe the characteristics of a floppy disk, zip disk,
and hard disk
- discuss
the purpose of the following as each relates to operating system functions:
booting, cold boot, warm boot, POST, recovery disk (boot disk), user
interface, command line interface, menu-driven interface, graphical user
interface (GUI), memory management, virtual memory, spooling, and
driver
- define
the general purpose of a system software utility programs: file manager, image
viewer, uninstaller, disk scanner, disk defragmenter, diagnostic utility,
backup utility, antivirus program, personal firewall, file compression,
- define
the term computer network
- describe the role of the following basic components of a
communications network: sending device, receiving device, and communications
channel
- define
the following acronyms related to networks: LAN, WAN, MAN, client/server,
bandwidth, transmission media,
- define
the term network topology
- describe the characteristics of the following types of
telephone network connections: dial-up, dedicated lines, ISDN, DSL
- describe the characteristics of the following
communication devices as related to a network: dial-up modem, wireless modem,
cable modem and wireless access point
- define
the following terms related to databases: character, field, field name, data
type, record, primary key, data file, file maintenance, query, report
generator, and database administrator
- discuss
the following terms related to computer security risks: computer crime,
cybercrime, virus, work, Trojan horse, trusted source, virus definition,
quarantine, cracker, hacker, unauthorized access, firewall, online security
service, password, username, biometric device, encryption, decryption, surge
protector, power surge, uninterruptible power supply (UPS), denial of service
attack (Dos attach), digital certificate, secure socket layer (SSL), and
digital signature
- discuss
the following areas of computer ethics: unauthorized use of computers and
networks, software piracy, information accuracy, intellectual property rights,
codes of conduct and information privacy
- discuss
the issues related to electronic profiling, cookies, spyware, spam, and
e-mail; filtering
- discuss
specific laws related to computers and privacy: 1986 Electronic Communications
Privacy Act (ECPA), 1984 and 1994 Computer Fraud and Abuse Acts, 1970 Fair
Credit Reporting Acts
- discuss
various health concerns related to the use of computers
- discuss
various careers available for individuals interested in the field of computer
science
- discuss
the purpose of computer certifications and the benefits certifications bring
to the individual holding the certification and to the potential
employer