Syllabus
CPTG 2201 – Advanced Computer Applications
Spring 2010
Instructor:
E-Mail/Website/Phone:
Sandra
Jones sandrajones@clayton.edu
http://cims.clayton.edu/sjones
(678) 466-4428
Office/office hours:
Class Hours/Location:
UC 306 T/R 9:50 am –
11:05 am(UC 312)
M/W/F
12:00pm – 12:50 pm
T/T
11:15 am – 12:15 pm
PREREQUISITE: A
grade of C or better in MATH 1101 or 1111 or 1112A or 1113 or 1241 or 1501.
COURSE DESCRIPTION: This course
provides detailed coverage of common computer software applications used in
business and industry. It assumes that the student is knowledgeable of basic
computer skills and builds on that basis. Emphasis is on the application of
advanced features of electronic spreadsheets and the fundamentals of database
systems. (3 lecture
– 0 lab – 3 semester credit hours)
Course
OUTCOMES: Students
are expected to obtain a developing level of mastery of spreadsheet and
database computer applications. Students will demonstrate an emerging
level of knowledge of spreadsheet and database software
applications. Students should show potential to perform
independently. Students should be aware of the skills required to
be successful using spreadsheet and database software.
·
Create
and format a professional looking worksheet and/or report
·
Use
formulas and functions
·
Create
charts and graphs
·
Apply
“what-if” analysis to explore multiple solutions
·
Use
pivot tables and lists
·
Sort
and filter data, and use database functions
·
Work
with data across multiple worksheets and workbooks
·
Define
table structures, fields and attributes
·
Effectively
apply basic relational database concepts
·
Create,
maintain, and query a database
·
Create
forms and reports for database
·
Define
relationships between database tables
·
Import
and export data into and out of a database
MATERIALS:
·
COMPUTER:
A computer is required and each student needs access to a notebook
computer. Students will use their
notebook computers during class sessions and tests.
·
MyITLab: Your textbook is bundled with an activation ID card
and password for access to this site, which is created to help you succeed in
your course. This bundle is only
available through the CSU Bookstore.
Please do not lose this code. The MyITLab site
does contain electronic versions of the textbooks. Your Course ID is CRSABHM-212521 and the course title is CPTG2201-SJSP10
·
TEXT:
·
GO! with
PowerPoint 2007 Volume 1,
and GO! with Access 2007 Volume 1, Shelley Gaskin, Robert L. Ferrett, Alicia
Vargas, Suzanne Ma Marks.
·
It is highly recommended you choose an Excel
reference book to use with the assignments.
·
SOFTWARE: This course uses MS
Office 2007 Professional. If you do not have the software installed on your
computer you MUST IMMEDIATELY contact the Hub’s Student Software Support
Services. Student Software Support Services is located on the lower level of
the Library. This is the location where the HUB performs software installations
on student's laptops. Only students receive services in this location. To have
MS Office 2007 installed on your laptop, will need to be in-person, with a
photo-ID, and bring your laptop with its power cord. An appointment is
necessary for the first two weeks of every semester. To schedule an appointment
for services during the first two weeks of the semester, please go to the HUB's
Calendar. http://thehub.clayton.edu/index.php?nav=calendar
Important Technical Information: If you have already paid your fees, you can take advantage of our walk-up software installation service available at the HUB. The Hub will move to an appointment only schedule for software installations after the first weeks of class. It is your responsibility to operate and maintain your laptop. This is an intensive hands-on course and faculty WILL NOT assist with technical issues. If you experience problems work with the HUB to resolve these issues IMMEDIATELY.
YOU
MUST have MS OFFICE 2007 installed immediately. This course has assignments due
beginning on the first day of class! You should bring your computer and Ethernet
cable to each class meeting.
UNIVERSITY POLICIES:
See the current online Academic Catalog at, http://publications.clayton.edu/catalog/ for details on the following policies.
·
Any
student who has failed to attend a class by the final payment deadline for the
term will be identified as a “no show.”
Each “no show” student is administratively withdrawn from the class, a
grade of W will be posted, and the student is NOT be reinstated. Any appeals on the decision are made to the
Dean.
·
A
student who has withdrawn or earned less than a satisfactory grade (F, U, D, WF, W) a total of three times in a credited course at CSU
will not be allowed to take the course again.
Any appeals on the decision are made to the Dean.
·
The
mid-term grade in this course, which will be issued by March 5th,
reflects approximately 30% of the entire course grade. Based on this
grade, students may choose to withdraw from the course and receive a grade of
"W." Students pursuing this option must fill out an official
withdrawal form, available in the Office of the Registrar, by mid-term, which
occurs on March 5th.
·
For
students in CPTG 2201 a grade of C or better is a prerequisite for subsequent
CPTG courses at CSU.
·
Students are expected to abide by the
Student Code of Conduct in the
Clayton
State University Student Handbook, and the Basic
Undergraduate Student Responsibilities. Academic integrity is of paramount
importance at
·
Students
are expected to attend and participate in every class meeting. The university
reserves the right to determine that excessive absences, whether justified or
not, are sufficient cause for institutional withdrawals or failing grades.
TECHNOLOGY etiquette:
The computer is used extensively in this course. When you come into class you should
immediately set up your computer, unless otherwise informed by your instructor. You are not
allowed to connect to the Internet.
During class do not
play computer games, play music on the computer, surf the net, pass e-mail
“notes”, use computer headphones, or use the computer in any way that is
distracting to the instructor or any other student. Set the volume on your computer to a low
setting. Outside of class, any e-mail
sent to the instructor should state your name and identify the class you are
taking. Remember to act professionally
when sending e-mail to your instructor. Any unprofessional e-mail sent to an
instructor will not be tolerated. Do not
use class list emails for personal correspondence.
RESOURCES: Your
instructor holds regular office hours and is willing to help. The Center for Academic Assistance
(CAA) is located on
the lower level of the Library, and the CAA home page is http://adminservices.clayton.edu/caa/
. The CAA sponsors a Peer Tutoring
Program. Please see the CAA website for
more information and to schedule an appointment with a Peer Tutor. Additional group instruction is available
from the members of the CAA staff who have advanced mathematics training. There are materials and computer software
which may be of help. There are numerous
books on computer science and engineering in the CSU library for further reference
and study.
EVALUATION:
· Your grade in this course will be
determined by the points that you earn on 23 MyITLab Online
Skill-Based Exams which comprises 80% of your overall course grade. The exams are separated into 3 parts:
PowerPoint has 6 of said exams for 20%, Access has 6 of said exams for 20%, and
Excel has 11 of said exams for 40%.
·
Three
online exams represent the remaining 20% of your final grade. PowerPoint, which is 5%, Access, which is 5%,
and Excel, which is 10%. Due dates for
Midterm exams will be communicated via w-mail.
No late work is accepted.
Homework: All homework is due on the assigned date. No late assignments can be accepted.
Homework may always be turned in early. In order to succeed in this
course, a student must do each homework assignment. On average, homework will require three
hours, per semester credit hour, of work outside of class each week.
TECHNOLOGY PREREQUISITE: The
computer is used extensively in this course.
You should bring your computer and your textbook to each class
meeting and immediately set up your computer, unless otherwise informed
by your instructor. Basic computer
skills such as windows file management and using email are
necessary to succeed in CSCI 1371. If
you do not have the skills covered in both of these workshops, then it is
strongly recommended that you seek additional assistance as soon as possible. These skills will not be taught in
CSCI 1371. Individual assistance and
workshops are offered through the HUB when there is enough demand. Students should make an appointment with the
HUB to have software loaded on their computers.
Please see the DUCK for
information about activating email accounts.
· Use the
WindowsTM operating system.
· Access
and navigate web sites
· Send
and receive e-mail using your campus email account via OutlookTM
or Outlook ExpressTM program
·
Attach and retrieve files via email.
·
Install and run a CD Rom.
IMPORTANT DATES FOR THE SEMESTER:
|
January 11 |
Classes Begin |
|
March 5 |
Last day to withdraw
without academic accountability |
|
January 14 |
Schedule Adjustment Ends |
March 6 -14 |
Spring Break – No class |
|
|
January 18 |
MLK – No class |
|
May 3 |
Last day of classes |
|
January 21 |
Last date for No Show
students |
May 4-10 |
Final Exams, See CSU
Schedule |
|
|
Feb 23 & 25 |
Mid-Term Exam Power Point / Access |
|||
Students with disabilities who
require reasonable accommodations need to register with Disability Services
(DS) in order to obtain their accommodations. You can contact them at
678-466-5445 or disabilityservices@clayton.edu.
If you are already registered with DS and are seeking accommodations for this
course, please make an appointment with your instructor to discuss your
specific accommodation needs for this course and give the instructor your
accommodations letter.
Professional
Standards: The
content of this course syllabus correlates to education standards established by
national and state education governing agencies, accrediting agencies and
learned society/ professional education associations (found at www.nctm.org and www.georgiastandards.org) course
correlation matrices located at the following web site: http://a-s.clayton.edu/teachered/Standards%20and%20Outcomes.htm
ELECTRONIC MESSAGES:
·
The instructor may send e-mails with
information vital to your success in the course. Check your e-mail often,
at least once a day.
·
Any voice-mail or e-mail messages are
returned during the regular workweek.
·
ABSOLUTELY NO GRADED ASSIGNMENTS WILL BE
ACCEPTED VIA E-MAIL. Assignments must be
turned in as the instructor directs.
·
The instructor will NOT email or
telephone to tell you everything you missed in class if you did not attend that
day.
·
Because of the number of students we
typically have, there may be some delay in the instructor's response to an
individual's e-mail.
·
Do not send time-sensitive information
via e-mail, speak to the instructor in person. A
delivered e-mail does not relieve you of the responsibility of informing the
instructor about some concern.
·
Do not send a personal email
correspondence to the instructor via the email class list.
ATTENDANCE:
Students are expected to attend
each class session. Students are
responsible for knowing about announcements/assignments made in class, whether
or not the student is present. Attendance is required for examination periods.
EXCUSED ABSCENCES: The student is responsible for
providing satisfactory evidence to the instructor to substantiate the reason
for absence. Among the reasons absences are considered excused by the
university are the following:
· Participation in an activity
appearing on the university authorized activity list.
·
Death
or major illness in a student’s immediate family. Immediate family may include: mother, father, sister, brother,
grandparents, spouse, child, spouse’s child, spouse’s parents, spouse’s
grandparents, stepmother, step-father, step-sister, step-brother,
step-grandparents, grandchild, step-grandchild, legal guardian, and others as
deemed appropriate by faculty member or student’s academic dean.
· Illness of a dependent family
member.
· Participation in legal
proceedings or administrative procedures that require a student’s presence.
· Injury or Illness that is too
severe or contagious for the student to attend class. The student should obtain a medical
confirmation note from his or her medical provider. The medical confirmation
note must contain the date and time of the illness and medical professional’s
confirmation of needed absence. An
absence for a non acute medical service does not constitute an excused absence.
· Required participation in
military duties.
Distractions: The use of pagers,
radios, and cellular phones in class is PROHIBITED. Out of courtesy and respect
for everyone's learning environment, TURN THEM OFF!!!
Visitors: It is against CSU policy to allow any person not registered
for a course to attend a class meeting. In particular, it is not
reasonable to expect children to be able to sit quietly throughout a class
meeting or testing period; please make alternate arrangements sufficiently
ahead of time to avoid being "stuck" in a childcare dilemma.
Disruptive Classroom Behavior
Disruptive
behavior in the classroom can negatively affect the classroom environment as
well as the educational experience for students enrolled in the course. Disruptive behavior is defined as any
behaviors that hamper the ability of instructors to teach or students to
learn. Common examples of disruptive
behaviors include, but are not limited to:
Students
exhibiting these types of behaviors can expect a warning from the instructor or
dismissal for the lesson in which the behavior occurs. Failure to correct such behaviors can result
in dismissal from the course.
More
extreme examples of disruptive behavior include, but are not limited to:
Students
exhibiting these more extreme examples of disruptive behavior may be dismissed
from the lesson or the entire course.
Students dismissed
from a lesson will leave the classroom immediately or may be subject to
additional penalties. Dismissed students
are responsible for any course material or assignments missed.
Students
dismissed from a course have the right to appeal the dismissal to the
department head responsible for the course.
Appeals beyond the department head may also be pursued. If no appeal is made or the appeal is
unsuccessful, the student will receive a grade o WF (withdrawal – failing)
regardless of the current grade in the course.
Conditions
attributed to physical or psychological disabilities are not considered as a
legitimate excuse for disruptive behavior.