Demme, John

English

University of Montana

University of MontanaScholarWorks at University of MontanaSyllabi Course Syllabi9-2002CS 172.02: Introduction to Computer ModelingJohn DemmeUniversity of Montana - MissoulaLet us know how access to this document benefits you.Follow this and additional works at: https://scholarworks.umt.edu/syllabiThis Syllabus is brought to you for free and open access by the Course Syllabi at ScholarWorks at University of Montana. It has been accepted forinclusion in Syllabi by an authorized administrator of ScholarWorks at University of Montana. For more information, please contactscholarworks@mso.umt.edu.Recommended CitationDemme, John, "CS 172.02: Introduction to Computer Modeling" (2002). Syllabi. 2705.https://scholarworks.umt.edu/syllabi/2705CS 172Instructor: John Demme Office: Social Science 404Office Hours: TR 2 :3 0 -3 :3 0  PM and by appointment E-mail: csl 72@photo-comm comPhone: 243-5605 Call ONLY during office hours ONLY if it is extremely important. DO NOT LEAVE MESSAGES.TA:Office:Hours:Lab:Je ff  M ueller, iam655@hotmail.com.SS 405M: 2-3, T: 2-3:30, W: 2-4, F: 2-3 W: 4-5 FA 210Class Website: www.cs.umt.edu/CS/COURSES/CS172-Q2 Class: Social Science 344 TR 3:40 -  5:00 PM Lab Fine Arts 210 W 4 :1 0 -5 :0 0  PMText/Materials:1. Adamski/Finnegan/Hommel, New Perspectives on Access 2000 Comprehensive, Course Technology, Inc., 1999. ISBN-076007089X2. Parsons/Oja/Carey, New Perspectives on Microsoft Excel 2000 Comprehensive, Course Technology, 1999. ISBN-0760070865At least 2 floppy disks and a floppy carrying case may be needed. Students using the campus computer labs should save their data to the floppy not the computer you are working on. Someone using the same computer may remove it or copy it (see cheating). A second floppy should be used as a backup.Topics:Major time: Excel and Access Minor time: Word and PowerPointPrerequisite:Previous computer experience and MATH 100 or equivalent score on math placement test, or consent of instructor is expected. It is expected that the student will have a basic knowledge of the use of a microcomputer. A basic understanding of the windows interface is also expected. In particular the student should know how to save, copy, delete, move, etc. files and should be familiar with a browser (this will be reviewed in class). No prior knowledge or experience in the use of a database or spreadsheet is required. Be advised, if  the student doesllle:///I|/CS%20172-02%20Fall%202002,htm[8/6/2013 2:25:11 PM]CS 172not have the prerequisites then the instructor is not responsible for helping the student acquire this material.Course Purpose/Objectives for Word:A basic overview of some of the most used operations of Word will be covered with a review of file management, editing and formatting. This is intended to be a review so everyone has a similar understanding of Word.Course Purpose/Objectives for Excel:In this course, students will learn the most important topics of Microsoft Excel 2000 and many advanced topics. They will include the purpose of the spreadsheet, the ability to create, edit, and format spreadsheets, create formulas, use certain functions, create charts, do business related analysis, work with data lists, create and edit macros, create pivot tables and charts, and display your worksheets on the Web.Course Purpose/Objectives for Access:1. Demonstrate the value of using a Database Management System to store and retrieve information.2. Understand the basic design and implementation strategies for the development of online databases.3. Develop a working knowledge of a particular Database Management System (in this case, Access 200).4. Develop sophisticated queries and reports based on the database.5. Learn how queries and reports can support the business decision-making processes.6. Develop Data Access Pages providing Internet access to databases.7. Learn how to export data from the database to an HTML file accessible over the Internet (WWW) or Intranet(local).8. Use the database to integrate with other programs such as Word Processing and Spreadsheet.Course Purpose/Objectives for PowerPoint:Gain a basic understanding of the functions of PowerPoint to create a presentation. NOTE: This topic will becovered as an added benefit to the course, time permitting.Grades: Student evaluation percentages:Homework and test (worth 2 HW) 45%Midterms (2) 30%Final Project 22%*Performance assessment by instructor 03%Total 100%Grade percentage range:A - 9 0 -  100 B -  80 - 89 C - 1 0  - 79 D -  60 - 69 F -  59 or lessfile:///I|/CS%20172-02%20Fall%202002.htm[8/6/2013 2:25:11 PM]CS 172P/NP -  pass/no pass, 70 or greater is passing determined by Computer Science department policy, which is a C or better.*Note: Performance assessment by instructor will be an objective and subjective determination of a student’s work performance and diligence to perform to the best of their ability.Attendance Policy:You are expected to attend all classes on time. If you do not attend a lecture, you are responsible to learn what you missed. This includes any changes regarding assignments, exams or any other course related material. Information disseminated in class may not be in the texts books. The instructor is not responsible for helping the student acquire material missed due to cutting class. So, miss classes at your own risk. Exceptions that the instructor will deal with are illness (documented by a doctor), death in the family, unforeseen work conflict, or some other unforeseen reasonable disaster.Late assignment policy:Late assignments will not be accepted. The answers may be posted, or discussed in class. Assignments will be due at 2:00 PM before classes for electronic submissions, at the beginning of class (the first 5 minutes, cutting class won’t help) for hard copies or times as specified by instructions for the assignment. All assignments will state due date and time for clarity. This information will also be posted on the class website. Assignment due times are subject to change which will be set during class. If you miss class, it is your responsibility to get information about changes (read Attendance Policy). NOTE: If there is a conflict of due dates (e.g. due date on website differs from due date on assignment), check with the instructor for clarification and correction when assignments are assigned.Missing exams:If you miss an exam because of illness (documented by a doctor), death in the family, unforeseen work conflict, or some other unforeseen reasonable disaster, a make-up exam will be scheduled. It may or may not be of the same type. Instead of a written test, it may be oral or a lab type. The instructor, time, and other circumstances will be the determining factor.Final project:Presentations of final projects will be the last week of classes and the final exam time slot. Final projects (hard copy and/or soft copy) are due by the beginning of the final test scheduled time slot for this class and section. It is mandatory that all students attend project presentations; attendance will be taken. Students will fill out an evaluation sheet for each presentation, which will be used in conjunction with the instructor’s evaluation for grading the projects (this is subject to change due to time constraints). The evaluations will not be the only grading factor. Each student will be allowed 3.5 minutes for his or her presentation. This class has a choice of Monday or Tuesday for the final. The choice will be made, with your input, by the second week of classes. No other changes can be made to the time or day of the final.Collaborating /Cheating:Students are encouraged (under most circumstances) to help each other, study together, and get assistance from TAs and instructors. This type of collaboration is acceptable in this class. However, any and all work handed in by a student must be the unique work of that student. The exception to this rule would be team projects (assigned by the instructor). Any assignments copied (plagiarized) from other students or published sources (including the internet) will receive a zero and be dealt with according to the Student Conduct booklet. Any further attempts at cheating may result in falling the course.Class Conduct:Profanity, obscenity, racial slurs and hate related remarks will not be tolerated in class or on assignments. You will befile:///I|/CS%20172-02%20Fall%202002.htm[8/6/2013 2:25:11 PM]CS 172expected and required to act as good, responsible, respecting adults by this society’s standards.Late drop from class policy:You should read “Academic Policies and Procedures” in the University of Montana 2002- 2003 Catalog for full details on dropping and adding courses. Note:Beginning the thirty-first (31) instructional day of the semester through the last day of instruction before scheduled final examinations, students must petition to drop, add, and make changes of section, grading option, credit or audit status. The petition form must be signed by the instructor of the course and the student’s advisor and in the case of drops only, by the dean of the student’s major.... There are no refunds or deductions in fees for courses dropped, and the instructor assigns a grade ofWP (withdrew/passing) if the student’s course work has been passing or a WF (withdrew/failing) if the course work has been failing.... Documented justification is required for dropping courses by petition....A “recommended” and “not recommended” check box is located on the Drop/Add from. Any drops requested by a student with a failing grade will have the not recommended check box checked if the instructor feels the drop is used as a means of protecting grade point average and the student did not perform adequately. Also note that there may be financial aid implications.Incompletes:Again, see the catalog for details. “Incomplete for the course is not an option to be exercised at the discretion of students. In all cases it is given at the discretion of the instructor....” Some guidelines for receiving an incomplete are listed in the catalog which include having a passing grade up to three weeks before the end of the semester and being in attendance. “Negligence and indifference are not acceptable reasons.” Also note that there may be financial aid implications.Disabilities:Students with disabilities should notify the instructor at the beginning of the course. Disabilities should be “certified” by DSS.Communication:Communication is vital to solve class-related problems or personal problems that affect your scholastic performance. Talk to me before problems become insurmountable or lead to failing the course. If I can’t help you, I may be able to direct you to someone who can, or to a University service.Advice:Don’t fall behind in your work. It is much more difficult to do a lot more later than a little now. Schedule your time wisely to do your work but allow time for fun and relaxation. Life is short, so enjoy it, but don’t waste it.General tentative course schedule:Week 1 -  syllabus, intro on computers, modeling, assign. 1Week 2 -  Word, assign. 2, final exam time decisionWeek 3 -  Excel, assign. 3Week 4 -  Excel, assign. 4Week 5 -  Excel, test (5,6), assign. 7 the test is worth 2 assignments Week 6 -  Excel assign. 8Week 7 -  Excel, midterm, project description due Week 8 -  Access, assign. 9Week 9 -  Access, assign. 10, project outline dueWeek 10 -  Access, assign 11Week 11 -  Access, assign. 12, project status report dueWeek 12 -  midterm, Excel, assign. 13 - or midterm, PowerPoint, assign. 13,file://4|/CS%20172-02%20Fall%202002.htm[8/6/2013 2:25:11 PM]CS 172project rough draft due -  if you don’t have much at this point you may be in deep do-doWeek 13 -  Excel, PowerPoint, assign. 14 - or PowerPoint, Excel, assign. 14Week 14 -  final project presentation Week 15 -  final project presentationFinal exam day and time: Monday, Dec. 16 or Tuesday, Dec. 17 at 3:20 pm to 5:20 pm.NOTE: the (1) worst assignment grade of assignments done before the first midterm will be dropped (the test is notconsidered an assignment). The (1) worst assignment grade of assignments done after the first midterm will be dropped. In other words, 2 assignments can be missed or dropped (as specified) and will not hurt your grade. Anyothers missed for any reason will result in a zero for that assignment. This includes any assignments missed for anyreason, illness (documented by a doctor), death in the family, unforeseen work conflict, or some other unforeseen reasonable disaster.Class Website:The class website will contain the class information, syllabus, assignments and assignment due dates, changes to class schedule, class notes, etc. You should visit the site on a regular basis (at least once a week). Grades will be posted on the site so you can keep track of your progress and see how you rate relative to others. Individuals will be anonymous and will receive a confidential random code to reference their grade.Important dates:Sept. 23 -  last day to add/drop to receive a full refundOct. 14 -  last day to add/drop no money backNov. 5 -  Election Day, no classesNov. 11 -  Veteran’s day, no classesNov. 27-29 -  thanksgiving vacationDec. 6 -  last day to withdrawDec 13 -  last day for drop/grade option pettionsDec 16-20 -  final examsCampus computer lab schedule: FA -  Fine Arts 210 LA -  Liberal Arts 206Mon -  Thu Friday Sat -  SunUniversity Center 225 Valid Griz card requiredMon -  Thu 8:00 am -  11:30 pmFriday 8:00 am -  5:00 pmSat -  Sun CLOSEDLiberal Arts 242 Liberal Arts 240Mon -  Thu 8:00 am -- 11:30 pmFriday 8:00 am -- 8:00 pmSat 9:00 am -- 8:00 pmSun 9:00 am -- 11:30 pmDavidson Honors College 1198:00 am -  8:00 pm8:00 am -  5:00 pm CLOSEDfile://4|/CS%20172-02%20Fall%202002.htm[8/6/2013 2:25:11 PM]CS 172Griz card requiredSchedule varies, call 243-2541Gallagher 209Mon -  Thu 7:30 a m -Fri 7:30 am -Sun 12:00 pm -10:00 pm 5:00 pm 10:00 pmfile://4|/CS%20172-02%20Fall%202002.htm[8/6/2013 2:25:11 PM]

CS 172.02: Introduction to Computer Modeling

https://scholarworks.umt.edu/cgi/viewcontent.cgi?article=3701&amp;context=syllabi

CS 172.02: Introduction to Computer Modeling

Abstract

Similar works

Full text

Available Versions

University of Montana