Spring 2008
21181
Course SyllabusCPSC 1105 Technological SolutionsTR 6:00 PM - 7:15 PMCCT 122
Instructor / Dr. Cheryl SwanierE-mail:Office: CCT 441
Office Hours: TR 5:00 - 6:00 pm
Contacting Me: If you need to discuss something outside of the classroom, please e-mail me within CougarView.
Department Phone: (706) 568-2410
Office phone: (706) 568-5375
Department Fax: (706) 565-3529
Web Site:
Required Textbook / / Title:GO! with Microsoft Office 2007
Authors: Gaskin, Ferrett, Vargas, Marks
Publisher: Prentice Hall
ISBN: 0131679996
Year: 2008
Course Description / Prerequisites – none.
This is 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.
Course Outcomes / The following are this course's outcomes:
- Students will demonstrate knowledge of the use of Windows XP.
- Strategies and actions used to produce the outcome:
- Study of how to start Windows XP and work with windows, folders and files.
- Study of how to resize, move and scroll windows.
- Study of how to maximize, restore, minimize and close windows.
- Study of how to create new folders.
- Study of how to copy, move rename and delete files.
- Study of how to find files and folders.
- Study of how to compress files.
- ABET criteria covered: A, B, D and I.
- Program objectives covered: 6.
- Assessment methods: project based assignments and assessments.
- Students will demonstrate knowledge of the use of Internet Explorer 7.0.
- Strategies and actions used to produce the outcome:
- Study of how to start Internet Explorer 7.0 and the ability to identify screen elements.
- Study of how to navigate the Internet.
- Study of how to create and manage favorites.
- Study of how to search the Internet.
- Study of how to save and print Web pages.
- ABET criteria covered: A, B, D and I.
- Program objectives covered: 6.
- Assessment methods: project based assignments and assessments.
- Students will demonstrate knowledge of basic computer concepts.
- Strategies and actions used to produce the outcome:
- Study of what a computer is and the four basic computing functions.
- Study of the different types of computers.
- Study of the different hardware devices and their uses.
- Study of the different types of software and their uses.
- Study of basic networks and network terms.
- Study of safe computing practices.
- ABET criteria covered: A, B, D and I.
- Program objectives covered: 6.
- Assessment methods: project based assignments and assessments.
- Students will demonstrate knowledge of how to use Microsoft Word 2007.
- Strategies and actions used to produce the outcome:
- Study of how to create, edit, save and print documents.
- Study of how to format and organize text.
- Study of how to use graphics and tables.
- Study of how to implement special document formats, columns and mail merge.
- ABET criteria covered: A, B, D and I.
- Program objectives covered: 6.
- Assessment methods: project based assignments and assessments.
- Students will demonstrate knowledge of how to use Microsoft Excel 2007.
- Strategies and actions used to produce the outcome:
- Study of how to create a worksheet and charting data.
- Study of how to manage workbooks and analyze data.
- Study of how to use functions and tables.
- ABET criteria covered: A, B, D and I.
- Program objectives covered: 6.
- Assessment methods: project based assignments and assessments.
- Students will demonstrate knowledge of how to use Microsoft Access 2007.
- Strategies and actions used to produce the outcome:
- Study of how to create Access databases and tables.
- Study of how to add, edit and delete records.
- Study of how to print tables.
- Study of how to create and use various types of queries.
- Study of how to create and use table relationships.
- Study of how to create and use forms, filters and reports.
- ABET criteria covered: A, B, D and I.
- Program objectives covered: 6 and 7.
- Assessment methods: project based assignments and assessments.
- Students will demonstrate knowledge of how to use Microsoft PowerPoint 2007.
- Strategies and actions used to produce the outcome:
- Study of how create, open, edit, save and print a presentation.
- Study of how to design a presentation.
- Study of how to enhance a presentation with animation, tables and charts.
- ABET criteria covered: A, B, D and I.
- Program objectives covered: 6
- Assessment methods: project based assignments and assessments.
Assessment Methods / Grades in this course will be based on your overall percentage in completing projects and assessments according to the following:
Percentage / Grade
90 – 100 / A
80 – 89 / B
70 – 79 / C
60 – 69 / D
<60 / F
Student Responsibilities / As a student in this course, you are responsible to:
- manage your time and maintain the discipline required to meet the course requirements;
- complete reading assignments prior to the the beginning of each class;
- attend class regularly and actively participate in classroom discussions;
- complete assignments by their due dates;
- abide by documented lab rules;
- respect the value of the other students' time while in the classroom, this means no surfing the Web or playing games;
- work with your team to decide on and develop a final project, and
- read any e-mail sent by the instructor and respond accordingly.
While in the classroom, students should turn off cell phones or place them on vibrate. In addition, to be respectful of other students' time and money, if the classroom is equipped with computers, playing games and/or surfing the Web is not allowed since these activities can be distracting to other students.
Instructor Responsibilities / As your instructor in this course, I am responsible to:
- prepare weekly lessons that demonstrate and help students understand the course material,
- prepare exams that allow students to demonstrate their knowledge of the course material,
- actively solicit and participate in classroom discussions,
- grade exams, programming assignments, and the final project deliverables and post scores within one week of the end of the week in which they are submitted; and
- read any e-mail sent by students and respond accordingly within 48 hours.
Attendance Policy / Attending class regularly is important to your success in this course. If you misstwo or moreclasses in a row, you may receive a WF. If you miss a class, be prepared to obtain all lecture notes, slides, assignments, and other information from other students. If an emergency prevents you from turning in an assignment or taking an exam as scheduled, please contact me to make alternative arrangements.
Tentative Schedule / The following is the tentative schedule for the course. It is subject to change.
DATES / UNIT / READINGS/TOPICS / HOMEWORK
Jan 6-12 / 1 / Orientation Meeting on 1/11. Roll Call, Myitlab setup, CougarView Setup, and Online Class expectations for Students and Instructors.
Chapter 1 Getting Started with Windows XP
Chapter 2 Getting Started with Outlook 2007 / Course Textbook (Chapters 1 & 2)
- Complete Projects 1A, 2A & 2B
- Review Matching (Both Chapters)
- Review Fill in the blank (Both Chapters)
- Review Chapter 1 PowerPoint Presentation
- Review Project 1A: Audio/Video Expert Demonstration Document
- Take the Chapter 1 End-of-Chapter Quiz
- Review Chapter 2 PowerPoint presentation.
- Review Project 2A and 2B: Audio/Video Expert Demonstration Documents
- Take the Chapter 2 End-of-Chapter Quiz
Jan 13-19 / 2 / Chapter 3 Getting Started with Internet Explorer 7.0 / Course Textbook
- Complete Project 3A
- Review Matching
- Review Fill in the blank
- Review Chapter 3 PowerPoint Presentation
- Review Project 3A: Audio/Video Expert Demonstration Document
Chapter 4 Basic Computer Concepts / Course Textbook
- Review Chapter 4
- Review Matching
- Review Fill in the blank
- Review Multiple choice
- Review Chapter 4 PowerPoint Presentation
- Take Chapter 4 End of Chapter Quiz
Jan 20-26
Jan 21 / 3 / Chapter 5 Creating Documents with Microsoft Word 2007
Today is Martin Luther King Day. No Class today.
/ Course Textbook
- Complete Project 5A
- Complete Project 5B
- Review Matching
- Review Fill in the blank
- Review Chapter 5 PowerPoint Presentation
- Review Project 5A: Audio/Video Expert Demonstration Document
- Review Project 5B: Audio/Video Expert Demonstration Document
- Take Word Chapter 5 Pre-Text
- Complete Chapter 5 Training
- Take Word Chapter 5 Post-Test
Chapter 6 Formatting and Organizing Text in Word 2007. / Course Textbook
- Complete Project 6A
- Complete Project 6B
- Review Matching
- Review Fill in the blank
- Review Chapter 6 PowerPoint Presentation
- Review Project 6A: Audio/Video Expert Demonstration Document
- Review Project 6B: Audio/Video Expert Demonstration Document
- Take Word Chapter 6 Pre-Test
- Complete Chapter 6 Training
- Take Word Chapter 6 Post-Test
Jan 27- Feb 2
Feb 1 / 4 / Chapter 7 Using Graphics and Tables in Word 2007.
Today is the last day to withdraw from class without incurring a penalty.
/ Course Textbook
- Complete Project 7A
- Complete Project 7B
- Review Matching
- Review Fill in the blank
- Review Chapter 7 PowerPoint Presentation
- Review Project 7A: Audio/Video Expert Demonstration Document
- Review Project 7B: Audio/Video Expert Demonstration Document
- Take Word Chapter 7 Pre-Test
- Complete Chapter 7 Training
- Take Word Chapter 7 Post-Test
Chapter 8 Special Document Formats, Columns, and Mail Merge with Word 2007 / Course Textbook
- Complete Project 8A
- Complete Project 8B
- Review Matching
- Review Fill in the blank
- Review Chapter 8 PowerPoint Presentation
- Review Project 8A: Audio/Video Expert Demonstration Document
- Review Project 8B: Audio/Video Expert Demonstration Document
- Take Word Chapter 8 Pre-Test
- Complete Chapter 8 Training
- Take Word Chapter 8 Post-Test
Feb 3-9 / 5 / Chapter 9 Excel 2007 Creating a Worksheet and Charting data
/ Course Textbook
- Complete Project 9A
- Complete Project 9B
- Review Matching
- Review Fill in the blank
- Review Chapter 9 PowerPoint Presentation
- Review Project 9A: Audio/Video Expert Demonstration Document
- Review Project 9B: Audio/Video Expert Demonstration Document
- Take Excel Chapter 9 Pre-Test
- Complete Chapter 9 Training
- Take Excel Chapter 9 Post-Test
Feb 10-16 / 6 / Chapter 10 Excel 2007 Managing Workbooks and Analyzing Data / Course Textbook
- Complete Project 10A
- Complete Project 10B
- Review Matching
- Review Fill in the blank
- Review Chapter 10 PowerPoint Presentation
- Review Project 10A: Audio/Video Expert Demonstration Document
- Review Project 10B: Audio/Video Expert Demonstration Document
- Take Excel Chapter 10 Pre-Test
- Complete Chapter 10 Training
- Take Excel Chapter 10 Post-Test
Feb 17-23 / 7 / Chapter 11 Excel 2007 Using Functions and Tables
/ Course Textbook
- Complete Project 11A
- Complete Project 11B
- Review Matching
- Review Fill in the blank
- Review Chapter 11 PowerPoint Presentation
- Review Project 11A: Audio/Video Expert Demonstration Document
- Review Project 11B: Audio/Video Expert Demonstration Document
- Take Excel Chapter 11 Pre-Test
- Complete Chapter 11 Training
- Take Excel Chapter 11 Post-Test
Feb 24-Mar 1
Feb 28 / 8 / Information Literacy. The study material for this segment is provided by the CSU library. For seated classes it may be through a lecture by library personnel. For Online students a set of three PowerPoint presentations and on online quiz is provided in myitlab. Actual dates may be coordinated with Library personnel.
Today is the mid-point of the semester. /
- Study the PowerPoint presentations as provided in myitlab. Complete the Information Literacy test per your instructor’s assignment.
March 2 – 8 / This is Spring Break Week and no assignments are given.
Mar 9-15 / 9 / Chapter 12 Getting Started with Access 2007 Databases and Tables / Course Textbook
- Complete Project 12A
- Complete Project 12B
- Review Matching
- Review Fill in the blank
- Review Chapter 12 PowerPoint Presentation
- Review Project 12A: Audio/Video Expert Demonstration Document
- Review Project 12B: Audio/Video Expert Demonstration Document
- Take Access Chapter 12 Pre-Test
- Complete Chapter 12 Training
- Take Access Chapter 12 Post-Test
Mar 16-22 / 10 / Chapter 13 Access 2007 Sort and Query a Database / Course Textbook
- Complete Project 13A
- Complete Project 13B
- Review Matching
- Review Fill in the blank
- Review Chapter 13 PowerPoint Presentation
- Review Project 13A: Audio/Video Expert Demonstration Document
- Review Project 13B: Audio/Video Expert Demonstration Document
- Take Access Chapter 13 Pre-Text
- Complete Chapter 13 Training
- Take Access Chapter 13 Post-Test
Mar 23-29 / 11 / Chapter 14 Access 2007 Forms, Filters and Reports / Course Textbook
- Complete Project 14A
- Complete Project 14B
- Review Matching
- Review Fill in the blank
- Review Chapter 14 PowerPoint Presentation
- Review Project 14A: Audio/Video Expert Demonstration Document
- Review Project 14B: Audio/Video Expert Demonstration Document
- Take Access Chapter 14 Pre-Test
- Complete Chapter 14 Training
- Take Access Chapter 14 Post-Test
Mar 30- Apr 5 / 12 / Chapter 15 Getting Started with Microsoft PowerPoint 2007 / Course Textbook
- Complete Project 15A
- Complete Project 15B
- Review Matching
- Review Fill in the blank
- Review Chapter 15 PowerPoint Presentation
- Review Project 15A: Audio/Video Expert Demonstration Document
- Review Project 15B: Audio/Video Expert Demonstration Document
- Take PowerPoint Chapter 15 Pre-Test
- Complete Chapter 15 Training
- Take PowerPoint Chapter 15 Post-Test
Apr 6-12 / 13 / Chapter 16 Designing a PowerPoint 2007 Presentation
/ Course Textbook
- Complete Project 16A
- Complete Project 16B
- Review Matching
- Review Fill in the blank
- Review Chapter 16 PowerPoint Presentation
- Review Project 16A: Audio/Video Expert Demonstration Document
- Review Project 16B: Audio/Video Expert Demonstration Document
- Take PowerPoint Chapter 16 Pre-Test
- Complete Chapter 16 Training
- Take PowerPoint Chapter 16 Post-Test
Apr 13-19 / 14 / Chapter 17 Enhancing a PowerPoint 2007 Presentation with Animation, Tables, and Charts / Course Textbook
- Complete Project 17A
- Complete Project 17B
- Review Matching
- Review Fill in the blank
- Review Chapter 17 PowerPoint Presentation
- Review Project 17A: Audio/Video Expert Demonstration Document
- Review Project 17B: Audio/Video Expert Demonstration Document
- Take PowerPoint Chapter 17 Pre-Test
- Complete Chapter 17 Training
- Take PowerPoint Chapter 17 Post-Test
Apr 20-26 / 15 / Integrated Projects, Chapters 18, 19, and 22. / Course Textbook
Complete Projects 18A, 19A, and 22A in the textbook.
MyITLab
Complete the quiz provided.
Apr 27-28 / 16 / Review for final. Wrap up any unfinished loose ends. / Complete the Final Exam Practice test up to 6 times as needed. It will be similar to the actual Final Exam.
Apr 30- May 5 / Exam / Dates for the Final Exam will be established between Apr 30 and May 5. It will be announced
Supplemental Course Materials / Supplemental course instructions and material will be available through MyITLab. You can access MyITLab at:
For this course, use the course ID:
CRSWXXXXXXX To be announced
Additional information concerning MyITLab will be provided on the first day of class.
Assignment Due Dates / All assignments are due on the day given in the assignment and no later than 11:59 PM (23:59) (Eastern Time).Assignments submitted or modified after the assignment due date will assessed a late penalty as described below.
Late Assignments / If circumstances prevent the timely posting of assignments, please notify me by e-mail within MyITLab. Unless you make prior arrangements with me, any assignment submitted after its assigned due date will be considered late. Late assignments may be submitted up to three days beyond their assigned due date. However, late assignments submitted within the three days following their assigned due date are subject to a 10% reduction in points for each day they are submitted beyond the assigned due date. Assignments not submitted by the assigned due date or within the three days following the assigned due due will be assessed a grade of zero (0).
Because of course grade reporting requirements, the final project must be submitted by the assigned due date -- no exceptions! Any final project not submitted by the assigned due date will be assessed a grade of zero (0).
Extra Credit / Extra credit, if available, will be described in the particular assignment in which it can be earned.
Incompletes / If unusual circumstances preclude you from completing the course and you have satisfactorily completed all the other course requirements up until that point, I will award you a grade of "Incomplete" provided you contact me regarding the unusual circumstances and you agree to certain conditions for removal of the "Incomplete." You must, however, contact me and arrange for the Incomplete as soon as you are aware that you will be unable to complete the course and before the last day of class.
Getting Help / Student assistants in the Computer Center and in the open lab can help you with basic computer-related problems (such as logging onto the network, saving your work, etc.), but they are not obligated and may not possess the necessary skills to help you with your assignments. Tutors in the Department of Computer Science tutoring lab (CCT 450) can help you with the assignments. Their schedule is typically posted in the Computer Science departmental office. Do not ask the tutors to write HTML,java-script, or other code required for this course for you. They are instructed to assist you in understanding concepts only.
Academic Honesty/
Plagiarism Policy / Academic dishonesty includes, but is not limited to, activities such as cheating and plagiarism ( Dishonesty/Academic Misconduct). 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 me. 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 contact me 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 person’s 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.