TENTATIVE
CIS 301 Problem-Solving with Computers Spring 2007 Campus Course
Instructor: Phone: E-mail: Website: Dr. Lisa Rich (256)233-8156 Lisa.Rich@Athens.edu blackboard.athens.edu Office: Waters Hall, Room 109 Office Hours: Monday 12:00 – 2:30 Tuesday 12:00 – 2:30 Wednesday 12:00 - 2:30 Thursday 12:00 – 2:30 Friday by Appointment
COURSE DESCRIPTION This course is designed to strengthen students’ grounding in common computer terminology and applications. Students with minimal skills will learn to enhance their personal productivity and problem solving skills by applying information technologies to problem situations and by designing and using small information systems for individuals and groups. The course will be conducted through lecture, in-class computing laboratories, and out-of-class assigned problems and projects. CIS301 may only be taken by CIS majors as a substitution for the Microcomputer Applications course required. COURSE PREREQUISITES Any Athens State student may take this course to fulfill the requirement for Microcomputer Applications. Students who are computer science, computer information systems, and computer networking majors may not take this course as an upper level elective. TEXTBOOK AND SUPPLIES Computer Literacy Basics: A Comprehensive Guide to IC3, by Ambrose, Bergerund, Busche, Morrison, and Wells-Pusins. Thomson Publishing, 2005, ISBN 0-619-24383-8. Each student must own or have access to a computer with Microsoft Windows and Office 2003 software including Word, Excel, Access, and Powerpoint. The computer with this software must also have internet access and email capability. Computers that meet these specifications are available at Athens State University in the library or computer labs for student use. Jump Drive for saving homework
1
TENTATIVE
COURSE OBJECTIVES/REQUIREMENTS/OUTCOMES ASSESSMENT The general objectives of this course are to: 1) Gain information on computer basics, including computer hardware and components, applications and operating systems software, and social issues related to computing and technology as tested on exams. 2) Learn personal productivity concepts using functions and features in computer software such as word processors, spreadsheets, databases, presentation graphics, and fundamentals of Office 2003 by successfully completing laboratory and term project assignments 3) Get acquainted with the proper procedures to create documents, worksheets, databases, and presentations suitable for coursework, professional purposes, and personal use by hands-on laboratory exercises and term project application 4) to discover the underlying functionality and become more productive using Office 2003 by selecting and creating a unique term project using Office 2003 applications 5) to encourage use of internet resources as required to complete a research paper assignment. For a complete list of objectives, refer to the final page attached to this document. GRADING CRITERIA Exam: Module 1 Exam: Module 2 Exam: Module 3 Assignments Term Project 20% 20% 20% 20% 20%
Course Grading is based on a 0 – 100 scale with 90-100 = A, 80 – 89 = B, 70 – 79 = C, 60 – 69 = D, and Below 60 = F. Do not expect grades to be scaled or curved at the end of the semester. “What you earn is what you’ll get.” COURSE POLICIES Examination Policy Examinations will be given at the end of each module of study for a total of three (3) during the semester. The dates of all exams are posted on the course outline for the entire term, therefore, no make-up exams will be allowed. A grade of 0 will be given for students who miss an examination. To prepare for examinations, read the chapters, review lecture notes (PowerPoint presentations and/or Tegrity recordings where applicable), and complete assignments. At least 90 % of the questions are taken directly from the reading material. Review the 2
TENTATIVE lesson summaries, become familiar with the vocabulary, and answer review questions at the back of each lesson for which you are being tested. Most exams are multiple choice with a few true/false and fill-in blank type questions. Assignment/Attendance Policy All of the course materials have been made available for you on the internet in the Blackboard course container. You are responsible for reading assigned chapters, reviewing the course notes, handouts, completing assignments, and taking tests as listed on the course outline and posted in the Assignment Manger in blackboard by the due date. No extensions will be given nor will late assignments will be accepted. A grade of 0 will be earned for all missed or late assignments. Disabilities Policy In compliance with the Americans with Disabilities Act (ADA), all qualified students enrolled in this course are entitled to "reasonable accommodations." Please notify the instructor during the first week of class of any accommodations needed for the course. Academic Misconduct Policy Students are expected to uphold the school's standard of conduct relating to academic honesty. Students assume full responsibility for the content and integrity of the academic work they submit. The guiding principle of academic integrity shall be that a student's submitted work, examinations, reports, and projects must be that of the student's own work. Students shall be guilty of violating the honor code if they: 1. Represent the work of others as their own. 2. Use or obtain unauthorized assistance in any academic work. 3. Give unauthorized assistance to other students. 4. Modify, without instructor approval, an examination, paper, record, or report for the purpose of obtaining additional credit. 5. Misrepresent the content of submitted work. The penalty for violating the honor code is severe. Any student violating the honor code is subject to receive a failing grade for the course and will be reported to the Office of Student Affairs. If a student is unclear about whether a particular situation may constitute an honor code violation, the student should meet with the instructor to discuss the situation. For this class, it is permissible to assist classmates in general discussions of computing techniques. General advice and interaction are encouraged. Each person, however, must develop his or her own solutions to the assigned projects, assignments, and tasks. In other words, students may not "work together" on graded assignments, unless it is assigned as 3
TENTATIVE group project. Such collaboration constitutes cheating. A student may not use or copy (by any means) another's work (or portions of it) and represent it as his/her own. If you need help with an assignment, contact your instructor or computer lab assistant. Laboratory Policy The “lab fee” charged for this courses is a fee that provides funding to support and enhance educational opportunities available to students. The educational support equipment and services provided include the computer-equipped classrooms in Waters Hall Room 5 on the ASU campus and the computer-equipped classrooms located in Waters 10 and 107. Industry standard software is available on the over 75 personal computers located in these laboratories. Several laser printers are available as well as a variety of instructional aids including TVs and VCRs, overhead projectors, and computer projection pads. The fee also supports e-mail and FAX services for student correspondence with faculty members. It is the student’s responsibility to come to campus and use the computer equipment as needed to complete laboratory assignments, if they do not own the required hardware and software. LIBRARY RESOURCES: The University Library provides a number of books, periodicals, and online periodical databases for student research use. All these resources can be accessed directly from any networked computer on campus, or from off-campus by using the user Ids and passwords which are distributed to students by the Library at the beginning of each term.
Course Methods and Outline
Each week, you are expected to read the assigned chapters and complete the assignments prior to attending class. The lectures assume that you have spent time reading on your own and working on your homework and project assignments. Make sure your name, student ID, and exercise number appear in the upper-left corner of your homework assignments. Disorganized assignments (pages out of order, mislabeled, unreadable, etc.) will receive zero points. If your assignment is multiple sheets, sequence it according to the order of the exercise. Assignments are posted in the Assignments column of the course outline along with the due date. Your assignments are typically due weekly on the due date listed and must be submitted through the assignment manager links in Blackboard to receive credit. EMAIL assignments will not be accepted unless there is unannounced downtime in Blackboard.
4
TENTATIVE
CIS 301: Problem-solving with Computers
Learning Unit
1 2
Course Objective
to introduce systems and information technology definitions and concepts to novice users to develop skill to effectively use standard knowledge work software packages (operating system and user interface, word processing, spreadsheet, database, statistics, and data management, presentation graphics, and communications) to introduce the concepts of problem solving within the context of information systems of limited complexity using standard knowledge work software packages to introduce the relevance and application of information technology in society to describe the concept of knowledge work and the need for personal information technology to support it to define concepts, principles, and practical approaches to management of individual software and data to explain organizational database concepts, components, structures, access, security, and management considerations to define the content, availability, and strategies to access information external to the organization to introduce and explore the use of general purpose and application software to introduce the purpose and develop ability to use a relational database software package to introduce and develop ability to design and implement a graphical user interface facility to present foundation technologies and define importance in future information technology capabilities to identify, investigate, analyze, design, and develop with packages (and/or high level languages) a single personal level information system applications to enhance individual productivity to define concepts of an individual information management infrastructure, and to apply strategies and tools for implementing, accessing, and using information resources *Proficiency Levels:
Proficiency Assessment Level * Method **
1 3 Exam Assignment, Project, Exam Exam
3
1
4 13.1 13.5 13.6 13.7 13.9 13.12 13.13 13.15 13.16
1 1 2 2 2 2 2 2 2 3
Exam Exam Assignment, Exam Assignment, Exam Assignment, Exam Assignment, Exam Assignment, Project Assignment, Project Assignment, Exam Assignment, Project, Exam Assignment, Project, Exam
15.17
3
0 = No Knowledge, **Assessment 1 = Awareness, Methods: Assignment, 2 = Literacy, Project, 3 = Concept & Use, Exam 4 = Detailed Understanding/Application, 5 = Advanced
5