Gallagher, Thomas

English

University of Montana

University of MontanaScholarWorks at University of MontanaSyllabi Course Syllabi9-2013CSCI 172.50C: Introduction to ComputerModelingThomas GallagherUniversity of Montana - Missoula, thomas.gallagher@umontana.eduLet 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 CitationGallagher, Thomas, "CSCI 172.50C: Introduction to Computer Modeling" (2013). Syllabi. 226.https://scholarworks.umt.edu/syllabi/226The University Of Montana Missoula College Department o f Applied Computing and Electronics Course SyllabusCSCI172 Introduction to Computer ModelingSections 50C & 51C Credits: 3Prerequisites: M 90 Introductory Algebra Syllabus Last Revised: August 2013Faculty ContactTom Gallagher, Associate Professor Thomas.Gallagher(5)umontana.edu Office Hours: MTWR 10-11Course DescriptionProblem solving and data modeling using computer productivity software. Emphasis using spreadsheets and databases for data analysis. Formal presentation o f results.Course OverviewThis class focuses on using the computer as a modeling tool fo r analysis o f data sets. The software applications we will be using for data modeling are spreadsheets and databases. We'll utilize the M icrosoft spreadsheet Excel and the M icrosoft database Access to implement data modeling. These are the most common spreadsheet and desktop database applications in use today. The 2013 version o f MS Excel and MS Access are needed to complete activities for this course (available on computers in student classrooms and labs).The course uses a textbook authored by Robert Grauer and published by Pearson Prentice-Hall. It is bundled w ith  the online simulation software package MylTLab. This application provides electronic exercises using a simulation o f the MS Office productivity suite. All students are welcome to utilize the computing labs and classrooms available on campus.Both an electronic copy and printed copy o f the textbook bundle are available for the course. MylTLab is an im portant component o f the printed textbook bundle. There are lots o f versions o f this particular textbook. Be sure to purchase the version w ith  the MylTLab bundle. The ISBN listed w ill accurately identify this bundle.Learner Outcomes•  Create, manipulate, and form at data in a spreadsheet.•  Create and use formulas, including conditional formulas.•  Use a spreadsheet to do basic descriptive statistics.•  Design models fo r visualizing data including charts.•  W ork w ith  large tables.•  Design a spreadsheet to implement a computer model.•  W ork w ith  database tables and queries.•  Understand how table relationships are used.Phone: 406.243.7814Office Location: Missoula College Campus - Griz House 8TextbookThere are tw o options to obtain the required textbook for this course (please choose only one):Option 1: Electronic Textbook Only and MylTLabAvailable fo r purchase directly from Pearson using a credit card or PayPal account. Seehttp://m vitlab.com /support/support-2013/student-get-started.htm lCourse ID is found in the Moodle Shell. (Approx. cost $85)orOption 2: Printed Textbook, Electronic Textbook, MS Office 2013 (180 day license) and MylTLabAvailable fo r purchase through the UM Bookstore http://www.m ontanabookstore.com Custom Edition Office 2013; Robert Grauer; Pearson Publishing 2013; ISBN 978-1-2692-7412-8 (Approx. cost $134) Important Note: Custom Textbook Bundle includes MylTLab Simulation required subscription. PLEASE PURCHASE FROM THE UM BOOKSTORE and not Amazon!Other Required MaterialsA computer w ith  the Microsoft Excel/Access 2013 will be required.General System requirement specifications fo r MylTLab are available at http://m vitlab.com /support/support-2013/svstem -reauirem ents.htm lThe MS Office software suite is available to students at a substantial discount through the UM Bookstore.M icrosoft offers a 60 day evaluation copy o f Office 2013.See: http://technet.m icrosoft.com /en-us/evalcenter/iil92782.aspxUM campus computer labs are another option for using MS Access/Excel 2013 for local students.AssessmentGrades will be weighted and graded as follows:Assessment Area Weighting: Grading Scale:End o f Chapter Homework 25% 90-100% AEnd o f Chapter Assessments 30% 80-89% BUnit Projects 25% 70-79% CFinal Exam 20% 60-69% DAcademic ConductAll students must practice academic honesty. Academic misconduct is subject to an academic penalty by the course instructor and /o r  a disciplinary sanction by The University. All students need to be fam iliar w ith  the Student Conduct Code. The Code is available fo r review online at: h ttp ://life .um t.edu/vpsa/student conduct.phpUsing the Web to research materials and concepts is an integral part o f learning in the tw enty-first century. Studying w ith  other students is a productive method o f learning. A certain amount o f collaborating on concepts w ith other students and using resources found on the Internet in an assignment is recommended. Copy and paste is not acceptable. It is expected that each student w ill input his/her assignment into the computer, and each student must be able to explain any assignment turned in.Collaboration on End o f Chapter Assessments (Grader Activities) is strictly forbidden. Collaboration on the Final Exam is strictly forbidden.Dropping and Adding Courses or Changing Sections, Grading or Credit StatusUniversity Policy fo r dropping courses or requesting grading/credit status changes can be found in the catalog: h ttp://www.um t.edu/cata log/acad/acadpolicv/default.h tm l Students should become fam iliar w ith  all academic policies found in the catalog.Disability Accommodations:Eligible students w ith  disabilities w ill receive appropriate accommodations in this course when requested in a tim ely way. Please contact me if you w ill be requesting an accommodation. Please be prepared to provide a le tter from your DSS Coordinator. For more information, visit the Disability Services website at h ttp ://w w w .um t.edu/dss or call/text 406.243.2243.Notes for Online StudentsWe will utilize tw o Learning Management System (LMS) software packages for the course: Moodle (UMOnline) and MylTLab (Pearson-textbook publisher). Moodle is the official LMS for the course content, grades, schedules, lessons, etc. The MylTLab LMS software platform  is used for homework exercises, chapter assessments, and the final exam.All homework, assessments, and unit projects have a due date. You are expected to  have submitted your assignment on-time. Submission o f assignments or projects w ill not be accepted unless there are extenuating circumstances. Acceptance of late submissions is at the discretion of the instructor. Please have a very good reason for your request.The final exam will be comprehensive. It w ill assess knowledge and concepts rather than skills. Final exam date w ill be determ ined later in the semester.How to Succeed in This Class"W ow a section on how to succeed in the class? W hat a great idea. I'll be sure to pay close attention" states the non­assuming, enthusiastic student ©Here's a short list o f tips from your instructor:1. COMPLETE THE INTERACTIVE VIDEO TUTORIAL FOUND IN MYITLAB: These provide a great introduction to the material and demonstrate the skills and knowledge required to  complete homework exercises.2. READ THE BOOK. We have a great textbook which clearly explains topics involving spreadsheets and databases. It is available in a hard copy form  from the UM bookstore and in an electronic form at through MylTLab. Book readings are assigned to assist you in developing vocabulary and understanding concepts. Students w ill be assessed on this knowledge through a comprehensive final exam given at the end o f the semester.3. COMPLETE ALL THE HOMEWORK, ASSESSMENTS, and UNIT PROJECTS. These homework exercises and assessments are found in MylTLab. Unit Projects are found in Moodle. CSCI172 is a project-based course. Completion o f these activities account fo r 80% o f your final grade! There are 27 graded activities. Complete all o f them !4. CHOP WOOD. This is a computer class. W hat does this mean? Well, chop wood is simply a metaphor fo r doing the work. Due dates fo r activities are posted in the syllabus. These w ill be reinforced in the Moodle LMS.Follow the schedule. Don't put it o ff to  the weekend. Chop the wood and get your work done as prescribed and you'll have a great experience!Good luck this semester and I hope you enjoy the course!Proposed Topic Outline (subject to revision)1. Introduction to Course and Office Fundamentals2. Introduction to Spreadsheets: Basics and Formulas3. Functions: Aggregate Functions; Logic Lookup, & Financial Functions; and Range Names4. Data Visualization: Introduction to Charting, Chart Design, Chart Layout, & Sparklines5. Managing Large Volumes o f Data: Large Datasets and Data Tables; Table Manipulation and Aggregation; and Conditional Formatting6. Data Analysis I: Outlines and Subtotals; PivotTables and PivotCharts7. Data Analysis II: W hat-lf Analysis; Qualitative Data Sets; and Quantitative Data Sets8. Introduction to Databases: Filters and Sorts; Multip le Table Databases; and Relationships9. Queries and the Relational Model10. Calculations; Expression Building; and Aggregate Functions11. Forms and ReportsAssignment Due Dates - Autumn Term 2013(August 23, 2013 -  subject to revision)Week Activity Monday Wednesday Friday26-Aug 1 Introduction Introduction to Course -  A s n l. l Discussion Forum2-Sep 2 Excel - Ch. 1 Labor Day: Holiday Office HW Office Assess9-Sep 3 Excel - Ch.2 Excel Ch. 1 HW Excel Ch. 1 Assess16-Sep 4 Excel - Ch.3 Excel Ch. 2 HW Excel Ch. 2 Assess23-Sep 5 Unit Project 1 Excel Ch. 3 HW30-Sep 6 Excel - Ch.4 Excel Ch. 3 Assess Excel Ch. 4 HW7-Oct 7 Excel - Ch.5 Excel Ch. 4 Assess Unit Project 214-Oct 8 Excel - Ch.6 Excel Ch. 5 HW Excel Ch. 5 Assess21-Oct 9 Excel Ch. 6 HW Excel Ch. 6 HW28-Oct 10 Access - Ch. 1 Unit Project 3 Access Ch. 1 HW4-Nov 11 Access - Ch. 2 Access Ch. 1 Assess11-Nov 12Veteran's Day Holiday Access Ch. 2 HW Access Ch. 2 Assess18-Nov 13 Access - Ch. 3 Unit Project 4 Access Ch. 3 HW25-Nov 14 Access Ch. 3 Assess Thanksgiving Holiday - No Class2-Dec 15 Access - Ch.4 Access Ch. 4 HW Access Ch. 4 Assess9-Dec 16 Final Exam Week

CSCI 172.50C: Introduction to Computer Modeling

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

CSCI 172.50C: Introduction to Computer Modeling

Abstract

Similar works

Full text

Available Versions

University of Montana