Syllabus:
CGS 1100: Introduction to Computers
3 credits-e-Learning
Spring
2005 Section: 33877
SITE:
Brandon Campus
Orientation
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. . Keyboarding skill highly suggested, e-Learning students must have Internet access and email
skills.
This
course may be used for the general education
computer requirement for AA degrees
Course Objectives: (HCC Course Outline
Model-Old)
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
For the past three decades, the Shelly Cashman
Series® has effectively introduced computers to millions of students —
consistently providing the highest quality, most up-to-date, and innovative
materials in computer education. This new edition employs the proven Shelly Cashman approach to learning, presents fundamental computer
concepts in a clear writing style, and includes extensive end-of-chapter
exercises. The book’s visually appealing layout keeps students interested and
allows them to receive the most interactive learning experience on computer
concepts.
Student Downloads
Download
Student Files
Instructor Edition
For desk copy requests of this title, we offer an Instructor Edition. This
edition contains the entire student version of the textbook, plus additional
materials to help get you and your faculty up and running quickly!
Order
your desk copy of this Instructor Edition
Student
Online Companion
Discovering Computers 2005 Companion Web
Site
Table of Contents
1. Introduction to Computers
Special Feature: Timeline 2005
2. The Internet and the World Wide Web
Special Feature: Guide to World Wide Web Sites and Searching Techniques
3. Application Software
4. The Components of the System Unit
5. Input
Special Feature: PDA Application Software
6. Output
Special Feature: Digital Imaging and Video Technology
7. Storage
8. Operating Systems and Utility Programs
Special Feature: Buyer’s Guide 2005
9. Communications and Networks
Special Feature: A World Without Wires
10. Database Management
Special Feature: E-Commerce 2005
11. Computers and Society, Security, Privacy, and Ethics
12. Information System Development
13. Programming Languages and Program Development
14.
15. Computer
Careers and Certification
Special Feature: Trends 2005
Appendices
A: Making Use of the Web
B: Coding Schemes and Number Systems
C: Computer Acronyms
Features
- Contains fifteen chapters and eight special
features that cover basic through advanced computer concepts with an
emphasis on both the personal computer and enterprise computing. Topics
include hardware, application and system software, the Internet and World
Wide Web, communications, e-commerce, societal issues, database
management, systems analysis and design, programming, information systems,
career opportunities, certifications in the computer field, and computer
trends.
- Latest technology shown through updated
photos, art, and all new screen shots including Microsoft Office System
2003.
- Increased emphasis on wireless communications,
video technologies, and mobile computers and devices.
- Updated content in chapter text, boxes, and
Company on the Cutting Edge and Technology Trailblazer write-ups.
- Updated end-of-chapter material includes 35
percent new content within Cases and Places and fourteen new At the Movies
exercises.
Link to:
http://www.course.com/catalog/product.cfm?category=Computer%20Concepts&subcategory=Computer%20Concepts&isbn=0-619-25525-0
for more information and downloads.
Web Sites:
Discovering Computers
2005:
http://www.scsite.com/dc2005/index.cfm?action=homeflash
Discovering Computers
2004:
http://www.scsite.com/dc2005/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/dc2005/index.cfm?action=TOC
to play Computer Genius
Game and other on-line chapter exercises.
CGS 1000students complete this
game for each chapter each week for credit.
CGS 1000students 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: none on Campus
Office/Cell Phone: 813-361-4379
after
Home
Phone:
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". “No Show” rolls will be submitted Saturday
Students should
consult the weekly group emails or the the course calendar at:
http://www.hccfl.edu/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: F04 for Spring 2005 then the extention: .html
Synchronous Attendance:
The instructor may
hold monthly sessions on the Internet via WebCT
whiteboard, the Interwise teaching platform, or other
synchronous 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 Thursday nights after
Phone/Email Network:
http://www.hcc.cc.fl.us/faculty/john_taylor/cgs1100/spring05/00atdS05.html
links to John Taylor’s e-Learning students Spring
2005. (not posted until after orientation)
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 :
Each
student must have an E-mail address to communicate in the course. Chapter
2 pages 91-94 of the text covers email basics. Free Emails may be obtained
from. 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@hccfl.edu 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. Email for Spring 2005 course:
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:
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
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 Chapter 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 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. The email should be addressed to:
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
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 and/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 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 is
two or more groups of words with Boolean Operators: "and”
“or” “not"
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:
"
Submission of Search Results
Each major search will 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 reviewed 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 may be assigned.
Reference Chapter 2 (p78-82) plus Chapter 2”s
special feature: “Guide to World Wide Web Sites and Searching Techniques” pages
116-129. 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/10e/students/
or
http://college.hmco.com/collegesurvival/ellis/master_student/10e/students/exercise_index.html
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:
The same site as above will be used to access the
discovery wheel:
http://college.hmco.com/collegesurvival/ellis/master_student/10e/students/
or
http://college.hmco.com/collegesurvival/ellis/master_student/10e/students/exercise_index.html
Learning Styles Inventories:
(3) OnLine
MBTI:
Short Version of Myers Briggs Personality Type Inventory (MBPTI):
The student will complete an inventory similar to the Myers Briggs Personality Type Inventory.
The
electronic version of the MBPTI developed by the JavaScript students may be
found at: MBPTI
Printout the results window with the MBPTI style preference. Submit the hard
copy to the instructor via your portfolio.
The
instructor has an online activity which is an abbreviated version of the Myers
Briggs Inventory:
URL: 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
Learning Styles Inventory Beta testing (LSI):
The student will complete the learning styles inventory included in the Master Student text by accessing the file on the Internet which is in Beta testing for Dave Ellis, author. The student will print out three completed electronic pages: Questionaire, Cycle of Learning, and Learning Grid. On the last two, the student will fill-in the kite and grid point. Completion of the inventory is worth 25 points.
URL:
http://www.hccbrandon.net/learnstyle/lsi.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 100-102,and 13.16-13.24. FTP is
introduced on page 95, 154, 683,.
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 5.5 version at: Download HTML Text Editor HomeSite
5.5 for 30 days:
http://www.macromedia.com/software/homesite/trial/
. 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. Reference pages 137-141.
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 Spring semester 2005, 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. Also include a section on
how to protect yourself from Spam mail.
At HCC and in the State of
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.
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, NOT Microsoft Works) to prepare several spreadsheet documents as described during the course calendar. Review page 142-144,
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 146-7. The file will be submitted as a .ppt file.
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 145, Chapter 10 p519-521 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 Spring 2005 term, but may be done to substitute for other projects not completed.
Optional 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. The ToolBook/Hyperstudio project will not be a requirement during Spring 2005 term, the the Microsoft agents project will.
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 on-Line Practice
Quiz is worth one point for each correct answer 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. 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
Exercise Main Page is:
http://www.scsite.com/dc2005/index.cfm?action=TOC (print out the pages with the score for
portfolio and email just the score results to the instructor for his grade book)
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/dc2005/index.cfm?action=homeflash
You must select a chaopter for the menu for the all activities for that
chapter, then select the computer genius option
Attempt
Chapter 1, which is the Introduction 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 "Computer Genius" from the left 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 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 2005),
which stops the clock during the question. Failing to answer a question in 60
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 hccbrandon.net
email address. You will receive 2 points for each correct answer. If you
achieve Genius status and use the lifelines 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)
Final Exam:
The
instructor will administer a Final Exam on May 7over the assigned chapters from the text. The student may
complete the exam off campus under supervision or in the Brandon Campus testing
center. The test will be 100 questions via WebCT on
May 7. This exam may be open book and open notes, but must be completed
individually on-line in 150 minutes or in the testing center with a two hour (120 minute)
time limit. This exam will be worth 200
points with two point(s) earned for each correct answer.
By
April 15, the instructor will notify the students about the final exam on
campus requirement. If the instructor is pleased with the overall work of most
of the students, the instructor will remove the campus requirement requiring
photo id. The final class meeting will only be a “Show and Tell” of the students power point and graphic projects.
Final Exam Challenge
The
student may test out of the course during the first month of the course. Using
photo ID and a test center admit, the student can report to
Muddy Water Issues:
Each day, students may use the e-mail to alert the instructor to the muddy water issue or phone him during online office hours. 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.
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 (Some are avalaible for a 30 day free trial):
Microsoft Office XP (Word, Excel, Access,
Power Point, Publisher)
Multimedia Click2Learn ToolBook
II Assistant and Instructor (may be checked out from the 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 Professional (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
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 1500
pts
Internet
Exercises 200 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 Activities 200 pts
Total Projected ~3300 points
During the Spring 2005, only 3000 point total will be used, students
have the option to drop 300 points of assignment or do the extra points for
bonus credit, but not the 15 chapter quizzes. Some activities may be deleted,
if so then the bonus work will be reduced to maintain the 3000 total.
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 1000
Address:
Telephone: 361-4379 (cell) (Jax 904-992-2052)
E-MAIL : j?taylor00e@hccbrandon.net or jtaylor@hccfl.edu
Employment:
813-361-4379 Full time chemistry faculty (first)
Former Program Manager: Computer
Science-Brandon Campus
Major: instructional Technologies Minor: Chemical education
Long Term Goal: Educational Software
Developer
Prerequisite: keyboarding no
Computer Skills: Win XP MS-DOS yes;
Word Processor: Word 2002 or Word
Perfect 11 yes;
Spreadsheet: Excel 2002 yes
Data Base: Access 2002 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
-------------------------------------------------------------------------------------------------------------------------
The instructor is available for additional office hours by appointment. Appointments must be made at least two days in advance, except for extreme emergencies. Office hours are subject to change. The official office hour schedule will be posted in BTECH 217.
Virtual Office Hours
|
|||
|
Time |
Tuesday* ** |
Thursday* ** |
Saturday/Sunday*** |
|
|
Office On-Line |
Office On-Line |
Office On-Line Or Scheduled help sessions at Brandon Campus |
|
Except * Tuesday or Thursday when notified
by Group Email |
|||
Data Card (4x6 file
card): Back Side (Personal
Time chart)
-------------------------------------------------------------------------------------------------------------------------
Taylor
|
Time |
Monday |
Tuesday |
Wednesday |
Thursday |
Friday |
Saturday |
|
|
office |
Drive Time |
office |
Drive Time |
|
HCC |
|
|
office |
office |
|
|||
|
|
CHEM 1211 |
CHEM 1211 |
office by |
|||
|
|
CHEM 1211 |
CHEM 1211 |
||||
|
|
office |
office |
||||
|
|
office |
office |
|
|||
|
|
|
CHEM 1211 |
|
CHEM 1211 |
|
|
|
|
|
CHEM 1211 |
|
CHEM 1211 |
|
|
|
|
|
office |
|
office |
|
|
|
|
|
CHEM 1212 |
|
CHEM 1212 |
|
|
|
|
|
CHEM 1212 |
|
CHEM 1212 |
|
|
|
|
|
office |
|
office |
|
|
|
|
|
Drive Time |
|
Drive Time |
|
|
New Course Description and Objectives:
Course description: (proposed
revision which may have been approved Fall Term 2004)
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 (May have been approved Fall 2004 term)
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
Special Dates:
|
Drop and Add:
Regular Classes |
January 10-14 |
|
Drop and Add
Weekend/DL classes |
January 22,
Jan 24-28 |
|
Martin Luther
King Holiday |
January 16 |
|
Mandatory
Orientation |
January 22 |
|
Makeup
Orientation 7:30am-9:30am |
January 29
(by appointment only) |
|
Spring
Break, |
March 14-18 |
|
Spring |
March 25 |
|
Possible Help
Sessions-see email |
2/12, 2/26,
3/12, 4/9 |
|
CLAST Exam
Registration |
January 21 |
|
CLAST |
February 19 |
|
Withdrawal
Date |
March 28 |
|
Credit By
Exam (2) |
Feb 8, Mar 9 |
|
Final Exam
Week |
May 7 May
5-10 |
|
Last Day to
Remove “I” |
|