1105 CPSC Technological Solutions Fall 2006 CRN CCT 122
Instructor(s): Office: CCT453 Office phone: (706) 568Department phone: [phone] Department FAX: [phone] Office Hours:; via e-mail, net-meetings and by appointment e-mail address: @colstate.edu homepage:http://csc.colstate.edu/ / Computer Science 1105 - Technological Solutions: A problems solving course using the newest technologies to develop an understanding of and skills in spreadsheet and data analysis, Web applications, word processing (intermediate level) and presentation software (advanced level). One component of this course is learning how to locate, evaluate and use information including Internet sources. Emphasis will be placed on using technology to solve practical problems. University Requirement: This course satisfies the University requirement regarding computer literacy. Student Learning Objectives: 1. Students successfully completing this course will gain knowledge of Technological Solutions and the Microsoft Office 2003 programs. 2. Students will reinforce their knowledge of how to use Windows, Word, and Power Point. 3. Students will learn how to use Excel, Access, and Front Page. 4. Students will be able to use these programs at a beginning and intermediate level to solve problems. 5. Students will be able to locate, evaluate and use information using multiple sources including the Internet. 6. Students will develop critical thinking and technical skills through study of texts and exams. Required Materials: Shelly, Cashman, Vermatt, Excel 03 Intro Course Card Ed , Course Technology, ISBN 141884358X. (Study the "Preface" in your book so you will learn the approach of the authors, Shelly and Cashman. Instead of chapters, the authors present "projects" for you to complete) Shelly, Cashman, Vermatt, Access 03 Intro Course Card Ed , Course Technology, ISBN 141884361X. Evans, Illustrated FrontPage 2003 Course Card Ed. Introductory, Course Technology, ISBN 1423904907. Front Page 2003 30 day trial s.ware, ISBN 0619255226
SAM 2003 Student Assessment and Tutorial/CD - 3.0, ISBN 619172347 SAM 03 Training V3.0-Offline T CD ISBN 061917173 Access Code-Pilot SAM 03 Prograder, ISBN 1423912500 A computer with internet access WebCT Vista account CougarNet Email account
How to buy the SAM/TOM access code & student tutorial A) You MAY ORDER your SAM 2003 Assessment and Tutorial/CD online from the publisher, Course Technology * *This online transaction requires a credit card. B) Purchase the item as part of the bundled package from the bookstore (be sure to double check the ISBN so you will order the correct item) Important: you will be dropped from this class if you are not listed on our SAM roster by the end of the second week of the semester (Read the information at the bottom of this page regarding "joining" a SAM section) Communication: o WebCT Vista is the course management tool used in this course o Check the "discussion area" at least every other day so you will not miss important information when it is posted o Start your browser (click on Firefox, Netscape Navigator or Internet Explorer), then type this URL in the Address line: http://WebCT.colstate.edu and select the WebCT Vista link (or http://vista.usg.edu) and select the Columbus State University link. o Click on the corresponding CRN for which you are enrolled; this gives you access to the discussion area, e-mail, your course grades, etc. Testing: You must take the mid-term and final exams (information is posted on the syllabus or on your WebCT Vista calendar; check both for details) Topics to be covered: o Windows XP o e-mail (see the information at http://cins.colstate.edu/cougarnet_email.asp) o Information Fluency Library Skills Internet and Intranet Skills o Microsoft Word 2003 o Microsoft Excel 2003 o Microsoft PowerPoint 2003 o Microsoft Access 2003 o FrontPage 2003
Workload: The Board of Regents suggests two hours of outside preparation for each credit hour course. [for a 50% online course, students should add three hours to compensate for the seated class time and therefore expect to study a minimum of eighteen hours each week.] Since students' ability to read for content varies this is only an estimate of required reading and study time. Students will be expected to read, study, and work all projects assigned before the posted exam date. A tentative schedule of topics is provided below. Any deviation from this schedule will be announced by a posted message to WebCT Vista. All students are responsible for announcements posted to WebCT Vista whether you log on to WebCT Vista or not. Assessment of Learning Outcomes: Testing and Grading: Grades are assigned on a ten-point scale as follows: A - 90-100%; B - 80-89%; C - 70-79%; D - 60-69%; F - 59 and below The Final grade will be computed as follows: o Word Test - 100 points o Power Point Test - 100 points o Information Fluency Test 100 points o Excel Test - 100 points o Access Test - 100 points Graded Assignments points possible: o Word Project: 25 points o Excel Project: 25 points o PowerPoint Project: 25 points o Integration Project PPT/Access: 25 points o Front Page: 50 points Grading Assignment Rubric: A (90-100): The student fulfills or exceeds all of the assigned content requirements. The students knowledge of the subject is accurate throughout. The student exhibits convincing range and quality of knowledge, having done appropriate research, if applicable. B (80-89): The student fulfills all of the important assigned content requirements. The students knowledge of the subject is accurate throughout except in minor details. The student seems informed on the subject, having done appropriate research, if applicable C (70-79): The student fulfills most of the important assigned content requirements. The students knowledge of the subject is generally accurate, though flawed. The student exhibits limited range or quality of knowledge, having done limited appropriate research, if applicable.
D (60-69): The student fulfills some of the important assigned content requirements. The students knowledge of the subject is generally accurate, though flawed. The student exhibits limited range or quality of knowledge, having done minimal appropriate research, if applicable. F (0-59): The student fails to address the important requirements of the course. The students knowledge of the subject is generally inaccurate. The students knowledge of the subject lacks range or quality NOTE: Points will be deducted for misspellings and grammar errors. Course Requirements 1. Completion of each course topic by the published date. (Refer to the course calendar found in WebCT Vista for details such as completion dates.) 2. Completion of all projects/graded assignments and exams. (Important: assignments submitted for grading MUST be created using the most current version of Microsoft Office which includes Word 2003, Excel 2003, PowerPoint 2003, Access 2003, and FrontPage 2003. No points will be given for assignments submitted in versions other than 2003. There will be no opportunity to make up this work.) 3. Post to Roll Call. 4. Communicate via WebCT Vista: o WebCT Vista is the tool we will use to communicate (e-mail, discussion, and chat) o Post to the discussion area each week o Engaging in chat is optional and available to respond to your questions in a timely manner o Check your WebCT Vista e-mail and utilize it to send private communications (remember, discussion and chat are public; therefore, everyone in your class can read your postings) IMPORTANT: No one is exempt from these requirements; therefore, if your offcampus computer prevents you from fulfilling these requirements, you are expected to use one of the computers on campus. How to Get Started: Post a message to Roll Call for the first week on WebCT Vista. From any computer that has internet access, type the url address: http://WebCT.colstate.edu/ and logon to WebCT Vista. Your WebCT Vista username is lastname_firstname and your password is DDMMYY. Your usernameis in lowercase letters. Open the course Technological Solutions Click on the Discussion link and post a Roll Call message to the first weeks Roll Call Topic.
your
Buy SAM/TOM CD Set up your SAM profile (instructions will be listed on WebCT Vista)
SAM Key Code: The first time you access SAM 2003, you will be asked to enter your Key Code Your Key Code is on a card which contains your SAM CD Have this card/Key Code with you the first day of class/Orientation IMPORTANT: Your Key Code can be used only once so PLEASE FOLLOW DIRECTIONS IN CLASS WHEN WE LOG ON FOR THE FIRST TIME I will create our SAM course and we will all logon at that time As you logon for the first time, you will build your User Profile and set your user id and password Your user id will be your last name, the underscore character, then your first name Your password will be sid and the last 4 digits of your student id number (sid is all lower case) DO NOT CHANGE YOUR USER ID AND PASSWORD NOR DEVIATE FROM THESE GUIDELINES PLEASE Students are added to SAM according to their CPSC 1105 CRN so once you have built your User Profile, you should select the SAM course that corresponds to your CRN, then click "Join" to be admitted to that particular section in SAM FrontPage If you are using a hard copy of this material (textbook), there is a page in the beginning of the book titled "Read This Before You Begin." This page contains information regarding the downloading of files before you begin work on this material. You will be asked for the textbook ISBN; this number is located on the back of your textbook. These files are compressed (or zipped) so once these files are downloaded, you must "unzip" them. If your computer does not have the necessary software to unzip your files, follow the steps below. Software to Unzip files: go to the WinZip Web site (www.winzip.com) then download the software. (As you begin this download, you may get a message saying that "Some files can harm your computer..." but you can trust this Web site. I do not believe there is any malicious code on this WinZip site.) General Policies: You are responsible for all class work missed, regardless of the reason for the absence(s). Late assignments will not be accepted. No makeup exams or quizzes will be given, so please make sure you are present for all exams/quizzes. Refer to the CSU Catalog
(http://aa.colstate.edu/advising/a.htm#Attendance%20Policy) for more information on class attendance and withdrawal. Makeups: No make-ups will be given for exams or assignments turned in late. Please mark your calendar now for exam dates, change doctors appointments and make backup arrangements for transportation and childcare. Exam dates appear below and will not be rescheduled. In the case of documented extreme medical emergency the instructor must be contacted BEFORE the exam is proctored. Withdrawal: It is the STUDENTS responsibility to indicate a drop from the course. Failure to withdraw from the course by the indicated date will result in a grade of WF or F. Please refer to the CSU Online Catalogue for "W" grade procedures and the CSU Schedule of Courses Booklet for the exact deadline date. Tutoring and out of Class Assistance: The instructor is available during office hours and by appointment. Students should contact the instructor with questions and concerns during office hours or by email. Attendance: Class attendance is measured by posting to roll call each week on WebCT Vista. Regular attendance is required. There is no need to provide an excuse for an absence (except for exams) since all absences will be regarded as absences. CSU Paper Allocation: It is your responsibility to keep track of this so that you have enough pages to print your CPSC 1105 assignments when necessary. Having exhausted your allotment will not be accepted as an excuse for not turning in your required printouts. Refer to the Student Handbook or CINS for information about requesting additional pages.
Academic dishonesty
Academic dishonesty includes, but is not limited to, activities such as cheating and plagiarism (http://aa.colstate.edu/advising/a.htm#Academic%20Dishonesty/Academic %20Misconduct). It is a basis for disciplinary action. Any work turned in for individual credit must be entirely the work of the student submitting the work. All work must be your own. [For group projects, the work must be done only by members of the group.] You may share ideas but submitting identical assignments (for example) will be considered cheating. You may discuss the material in the course and help one another with debugging; however, any work you hand in for a grade must be your own. A simple way to avoid inadvertent plagiarism is to talk about the assignments, but don't read each other's work or write solutions together unless otherwise directed by your instructor. For your own protection, keep scratch paper and old versions of assignments to establish ownership, until after the assignment has been graded and returned to you. If you have any questions about this, please see your instructor immediately. For assignments, access to notes,
the course textbooks, books and other publications is allowed. All work that is not your own, MUST be properly cited. This includes any material found on the Internet. Stealing or giving or receiving any code, diagrams, drawings, text or designs from another person (CSU or non-CSU, including the Internet) is not allowed. Having access to another persons work on the computer system or giving access to your work to another person is not allowed. It is your responsibility to prevent others from having unauthorized access to your work. No cheating in any form will be tolerated. Penalties for academic dishonesty may include a zero grade on the assignment or exam/quiz, a failing grade for the course, suspension from the Computer Science program, and dismissal from the program. All instances of cheating will be documented in writing with a copy placed in the Departments files. Students will be expected to discuss the academic misconduct with the faculty member and the chairperson. For more details see the Faculty Handbook: http://aa.colstate.edu/faculty/FacHandbook0203/sec100.htm#109.14 and the Student Handbook: http://sa.colstate.edu/handbook/handbook2003.pdf The Departments policy and links to other sites is at http://cs.colstate.edu/html_hi/programs/ academic_dishonesty.aspx Getting help: You can always contact me during my posted office hours, by email, or by appointment. There are also tutors available in CCT 450. Check the schedule for their times. CSU ADA statement: If you have a documented disability as described by the Rehabilitation Act of 1973 (P.L. 933-112 Section 504) and Americans with Disabilities Act (ADA) and would like to request academic and/or physical accommodations please contact Joy Norman at the Office of Disability Services in the Center for Academic Support and Student Retention, Tucker Hall [phone], as soon as possible. Course requirements will not be waived but reasonable accommodations may be provided as appropriate.
Tentative Weekly Schedule
****This schedule is subject to change. Week Topic 1 ORIENTATION: Roll call, Set up SAM, Windows XP
2 3 4 5 6 7 8 9 10 11 12 13 14 15 16
Word: Utilizing Word collaboration tools (possibly report writing) Word cont.d PowerPoint: Working with visuals/sound objects, advanced text features, integration, and workgroup features PowerPoint: cont.d SAM Path check/complete post-test (Word and PowerPoint) Information Fluency Information Fluency Information Fluency Information Fluency Information Fluency Exam Excel 1: Worksheets and embedded charts Excel 2: Formulas, Functions, and Web queries Excel 3: What-If Analysis, charting, and large worksheets Excel 3: What-If Analysis, charting, and large worksheets Interactive Web pages in Excel Interactive Web pages in Excel Review for Excel Exam Excel Exam Access 1: Introduction (creating and using databases) Access 2: Querying a database using the SQ Window Access 3 Maintaining a database and data sharing OLE, Integration projects, and data-compression utility OLE, Integration projects, and data-compression utility Review for Access Exam Access Exam Web design with FrontPage Web cont.d Web cont.d Web cont.d Web cont.d Web cont.d