Loading...
HomeMy WebLinkAboutINF-228Bergen Community College Information Technology Course Syllabus Course Title: INF-228 Excel For Problem Solving Credits/Hours: 1 credit/2 hours lab Course Description: This course focuses on the practical applications of Excel across multiple professions. Applications will be analyzed and developed. Topics may include linking among worksheets and between files, importing and exporting, databases, graphics, advanced functions, and other advanced spreadsheet topics as needed to develop applications. Pre-req: INF-101 or INF-114 or INF-124. Textbooks and Supplies: See course outline Student Learning Objectives Assessment Measures 1. Design and develop an Excel worksheet that addresses a given problem statement. Exam Lab activity 2. Determine how Excel can be applied as a tool to solve practical examples of real-world problems and then execute the solution. Exam Lab activity 3. Solve problems that may employ some special features of Excel such as the database capabilities, file import/export, chart, and advanced functions. Exam Lab activity Course Content: See course outline Assessment: An average of 60% from combined assessment measures is required to demonstrate a basic proficiency in course material. Exams 50% Lab assignments 50% Testing: Students are required to take examinations on the day and time they are scheduled. If special circumstances require a test schedule adjustment, this must be worked out in advance with the instructor. If a student misses an exam (except for prearranged circumstances with the instructor) a zero grade will be assigned. The instructor can be reached by telephone (see course outline for appropriate phone number), e- mail, or written note left in the Divisional Office (during the day) B-302 or the Office of Adjunct Administration C-107. If there are extreme circumstances (documentation may be required) that prevent a student from taking a test according to the published schedule, use one of the above options to contact the instructor before the next class. An arrangement for a special testing schedule is solely at the discretion of the instructor. A student who waits for the next class session to speak with the instructor will not be accommodated with a special test schedule. The use of electronic devices during exams is prohibited. Any student using an electronic device during an exam (unless directed to do so by the instructor) will receive a 0 for the exam. Problem Solving Assignments: Assignments involving problem solving are required to demonstrate that the student can competently solve real world problems with the specified software. It is important that the student complete all the assignments. The student should read the scheduled lessons in the text books prior to coming to class. Assignments are required for grading. They must be completed and submitted on the assignment due date using the method designated by the instructor. Assignments cannot be submitted any time other than when they are scheduled. The student will not be permitted to submit assignments other than when they are due. Homework: In addition to any homework assignment given during class, it is a standing assignment that the student read each chapter of the book prior to its discussion. Following the class discussion, the student should reread the material and work with the exercises throughout the text. It is anticipated that students will spend at least 4 -hours per week beyond class time reading the text and working with the exercises and supplemental resources. Policies: • Attendance: You are expected to attend all classes. Frequent or numerous absences will have an adverse effect on your learning, and will have an adverse effect upon your grade. If you are absent, you should communicate with the instructor as soon as possible by telephone, by leaving a voice mail message, or by e-mail. The instructors’ telephone number, with voice mail, and the instructors’ e-mail address are provided on the course outline. • Lateness: The roll will be taken at the beginning of class. If the student is not in attendance at that time, he/she will be carried in the roll book as being absent unless the instructor is notified immediately after class. Attendance sheets cannot be adjusted at following class meetings. • Participation: All students are expected to participate in class discussions. The content expressed in a students’ participation will not be graded, so all students are expected to be involved class discussions or question and answer periods. The degree of a students’ participation is an aspect that will be considered in the overall grading. • The student must adhere to all college polices. Due to the nature of this course, it is recommended that the student review the policy titled “Acceptable Information Technology Use at Bergen Community College”. • The use of portable electronic devices such as cell phones is not permitted while class is in session. Please be sure to silence electronic devices before entering class. Cell phones are to be off during class. • Unless otherwise directed by your instructor, the use of audio features of any electronic device to play music during class is prohibited. The use of headphones during class is prohibited • Students are expected to demonstrate listening, reading, note taking, and writing skills. The student will need to take notes during class discussions and understand and follow verbal and written directions. All assignments and correspondence with the instructor (including e-mail) must be well written in full sentence format. Proper paragraph format must be used for all postings to the student bulletin board (if applicable). • The subject line of all e-mail correspondence to the instructor must contain the course number and section and student’s name. Any e-mail received without this information will not be opened. • Plagiarism in any form will be treated as a failure to complete an assignment. All work submitted should reflect individual effort by the student. • In borderline cases that arise in almost every class each semester a student’s attendance, class participation, attitude, and observed effort will be considered in helping to determine the student’s final grade. If the instructor does not appear after 20 minutes following the scheduled starting time, students should prepare an attendance list. One volunteer member needs to deliver the list, containing the course title, date, and instructor’s name, to the Divisional Office (B-302 ) for classes scheduled during the day or the Office of Adjunct Administration, located in room C-107 Individual instructors may distribute additional policy and assessment information.