San Jacinto College Distance Education

Integrated Software Applications 1

ITSC 1309

 

This is an Internet class. It is assumed that students participating in an online course have a general understanding of Internet use, basic file handling (opening and saving files, creating folders, sending and receiving emails, and sending and opening attachments), and mouse functions. If you do not feel you have enough experience in these areas, you may wish to enroll in the on-campus version of this course.

 

Do NOT take this class if:

·        You need a classroom environment and an instructor’s assistance in the lab

·        You are a beginner with computers

·        You cannot send or receive email

·        You cannot send or receive attachments

·        You cannot purchase a textbook

·        You do not have an email account or access to one

 

 

You are responsible for checking announcements posted on Blackboard for any new information.

 

You are now reading the Orientation Information for this class. You do not need to attend any other sessions. You need only continue reading and following instructions.

 

AFTER you have read and followed this ENTIRE document, you will be enrolled in the class. (Read on.)

 

Course Outline

Course Name:

Integrated Software Applications 1

Course Number:

ITSC 1309 

Website

www.sanjacinto.blackboard.com 

Required Text:

Microsoft Office XP Professional, New Perspectives Series Published by Course Technology (CTI)

www.coursedirect.com (See also www.course.com )

Required Software:

Microsoft Office XP (Word 2002, Excel 2002, & Access 2002)

Instructor:

Edna Meeks

Office:

South Campus – Room 2126

Phone:

(281) 484-1900, ext. 3244

Email:

Campus:  edna.meeks@sjcd.edu

Email Subject Line:

1309 – your name (use in subject line for all email to instructor)

Office Hours:

Announced at a later date

Course Description:

ITSC 1309 is an introduction to the microcomputer and microcomputer software packages. The course will cover the general use of computers and the specific applications of operating systems, word processors, electronic spreadsheet programs, and database management software. This course is designed to achieve a "working knowledge" of microcomputer hardware, software, and disk operating system software.

 

IMPORTANT--It is the responsibility of the student to insure a stable and reliable Internet connection. This is extremely important during testing, since you will not be allowed to re-enter the testing area once you exit. Whether you exit by logging off or your ISP severs your connection is irrelevant, the system will not allow you back in the testing area. If you are unsure about your connection, you may use the computer lab on campus for testing. Once you have been issued your password for a test, any computer with an Internet connection may be used for testing.

 

Semester Credit Hours: 3 credits

 

There is NO orientation session for this class. Read this entire document to obtain the information needed for this class.

 

Student Learning Outcomes:

After successfully completing this course, you should be able to:

1.       Describe the components of a computer system and their functionality

2.       Analyze hardware and software specifications to determine compatibility.

3.       Understand computer, Internet, and application terminology.

4.       Describe the operating system’s functions.

5.       Boot a microcomputer and load an operating system.

6.       Perform the following operations within each software package:

A.Operating system  (Windows 2000 or Windows XP)

1.                    Prepare diskettes for storage.

2.                    Create and manage files and folders.

3.                    Manage a computer’s disk space.

B.Word processing software  (Word 2002)

1.                    Describe common functions of word processing software.

2.                    Create, open, save, and maintain document files.

3.                    Edit and format document contents.

4.                    Control document printing.

C.Spreadsheet software  (Excel 2002)

1.                    Describe common functions of spreadsheet software.

2.                    Create, open, save, and maintain worksheet files

3.                    Enter labels, values, and formulas into worksheet cells and ranges

4.                    Incorporate function calls is spreadsheet formulas.

5.                    Manipulate a range of cells (Copy, Move etc.)

6.                    Control worksheet printing.

D.Database software  (Access 2002)

1.                    Describe common functions of database management software.

2.                    Create, open, save, and maintain database files and tables.

3.                    Sort a database table.

4.                    Maintain a database by adding, updating, and deleting records

5.                    Control printing of tables, queries, forms, and formatted reports.

6.                    Use written or on-line documentation or help files to expand knowledge of software and hardware.

7.                    The San Jacinto College District does not guarantee these outcomes.

 

Grade determination:  You must have a passing average in both assignments and exams to pass the course.

         Four Tests, all of equal value, will count for 70% of the final grade

         Lab projects and quizzes will count for 30% of the final grade.

 

Participation and Withdrawals:

If it should become necessary to drop this class, it is the responsibility of the student to submit the necessary paperwork to the registrar’s office. Drop slips are available in the registrar’s office and should be submitted by the drop date below for a guaranteed grade of W. Failure to drop a class could result in a grade of F for the semester. The last date to drop is published in the course selection guide.

 

Supplies needed to complete course:

   Computer with Internet connection and running Internet Explorer (version 5.0 or higher recommended) or equivalent

   Windows XP or Windows 2000 operating system software

   Microsoft Office 2002 software

   Student data files, which may be obtained from the Course Technology website. Data files are also included in the assignments section.

 

 

Course Policies

 

Contacting Your Instructor:

You may contact me via email at edna.meeks@sjcd.edu. All your email will be returned to the same email address that you use to contact me. The following information should be supplied in ALL correspondence with me; failure to supply this information may result in a substantial delay in my responding to your email.

1.        Your First and Last Name

2.        The email address you want the reply sent to (if not the one you used to send to me)

3.        1309 in the subject line, followed by your name

4.        The date

It is better to email me, yet you may also call and leave a message at (281) 484-1900, ext. 3244. Leave your name, state that you are in the Distance Learning class, give an explanation for the call, and a number or email address where you can be contacted. Be aware that calling may delay my response, since I do not check phone messages daily, whereas I may check my email several times a day.

 

If it becomes necessary, you can call or email me to make an appointment to meet me in my office on campus. My office is on the South Campus, room 2140 in the Administration building. Please note: meetings on South campus should be by appointment only!

 

Exams:

      Four exams should be taken during the semester.

 

      Once you begin the test, you must complete it; the system will not let you exit and return to a test. It is your responsibility to prepare for the exam. Set aside the necessary time and insure a reliable Internet connection. Tests will consist primarily of multiple-choice questions and will cover specific units in your textbook.

 

1.        Test 1—Essential Computer Concepts, Windows, & Browser Basics

2.        Test 2—Microsoft Word

3.        Test 3—Microsoft Excel

4.        Test 4—Microsoft Access

 

Assignments:

Distance learning students are expected to maintain a pace that allows for the completion of this course within the time frame allotted for on-campus classes. See “Instructions for Submitting Assignments”, located in Course Documents.

The Windows Unit (First Unit) has NO labs. There are 4 quizzes to take and then the Test.

For the Word, Excel, and Access Units, you will submit your lab assignments to me via email attachments. You need only email me the final version of your document at the end of each tutorial. (The exception to this is Access. In Access you need only email me the one file at the end of all the Access tutorials.)

 

Class structure:

1.      Unit 1 – Windows (Select only ONE of the 2 paths below.)

            Windows 2000          OR              Windows XP

a)      Quiz 1                                      a)  Quiz 1

b)      Quiz 2                                      b)  Quiz 2

c)      Quiz 3                                      c)  Quiz 3

d)      Quiz 4                                      d)  Quiz 4

Windows 2000 Exam                     Windows XP Exam

2.      Unit 2 – Word

a)      Tutorial 1

b)      Tutorial 2

c)      Tutorial 3

d)      Tutorial 4

e)      Word Exam

3.      Unit 3 – Excel

a)      Tutorial 1

b)      Tutorial 2

c)      Tutorial 3

d)      Tutorial 4

e)      Excel Exam

4.      Unit 4 – Access

a)      Tutorial 1

b)      Tutorial 2

c)      Tutorial 3

d)      Access Exam (Final Exam)

 

 

Computer Lab Usage:

Distance Learning students may work in the general open labs on campus; however, you must obtain a student identification card before you will be allowed access to the lab.  Student ID cards may be obtained from the library, at no charge to student, upon presentation of a paid tuition slip. No children, food, or drinks are allowed in the computer labs.

 

 

Startup Instructions

·             Register and pay for this class.

·             Books are available in a campus bookstore. Books are needed. (Information about books is in THIS document.)

·             Before enrolling in Blackboard program (below), email me at  edna.meeks@sjcd.edu  for confirmation and the enrollment password, with CODE 1309 in the subject line.

·             THEN:

 

Goto:  http://sanjacinto.blackboard.com/

1.      Create a Login (If you already have a Blackboard account, use that one. Sign on and go to Step 4.)

2.      Answer prompts and Press Submit.

3.      Your account is now created.

4.      Press the courses tab at the top next to My San Jac tab.

5.      Select Distance Learning and then Computer Science

6.      Select the correct course name and number and press the Enroll Button.

7.      Enter Password obtained from above

8.      You are enrolled.

*