S U M M E R 2012 2012 0 C IS 125 EE XL WORKBOOKS Credits: 4 Prerequisites: CS101 and/or CIS120 or equivalent. Meets: TR 8::20 Campus 06-200 (CRN 12584) Online (CRN 13629) Instructor James A. Finholt, MBA, MCT, MCSE, MCTS, MCSA, MOS Office: Building 37-124 Phone: 503.589.7813 Instructor Website Course Description: This is a course in the use of electronic workbooks in a multi-spreadsheet environment using Microsoft Excel. Includes concepts associated with data type (labels and values) and how to build effective workbooks for use in projection and analysis of typical business situations. Workbook applications include the use of arithmetic formulas, internal functions, proper formatting, macros, graphics, database, and other analysis tools available in Excel. The course is written in context to the Office 2010 suite and NOT the Office 2007 suite. Course materials will NOT be modified or adjusted for Office 2007. It is your responsibility to make any necessary adjustments to accommodate the differences between the two versions of MSOffice. Students Retaking this Course!….. Any student retaking this course MUST see the instructor prior to beginning work on any assignment. Students that fit this category will be given assignments that are similar in content but are different than the ones they attempted the first time they took this course. Any assignments resubmitted from the first time they took the course will not be graded!! ADA Accommodations: If you are in need of academic adjustments to course materials or classrooms please contact our Disability Services Office at 503.. Diversity Statement: We are a college community enriched by the diversity of our students and staff. Each individual and group has the potential to contribute in our learning environment. Each has dignity. To diminish the dignity of one is to diminish the dignity of us all. Chemeketa Community College 4000 Lancaster Drive Salem 97309 Technical and Support It is your responsibility to have and maintain the software, equipment and internet connections required to complete all homework, labs, and exams for this course. All technical issues, REGARDLESS of the circumstances, are not valid reasons for missed assignments, labs, and/or exam deadlines. This means your assignments will be graded on the amount of work completed at the time of the “catastrophic†technical issue failure. The only exceptions would be verifiable unplanned errors of the sites that this course requires access to. I do not provide any technical support for accessing either my Class Web Page, eLearn, or Chemeketa e-mail. If you have issues logging onto eLearn or with your Chemeketa e-mail call the help desk at Chemeketa (. Required Text(s): Microsoft Excel 2010 Comprehensive Parsons | Oja | Ageloff | Carey Course Technology ISBN: Publisher Resources Hybrid Course Specifications A hybrid course is a blend of face-to-face instruction with online learning. In a hybrid course, a significant part of the course learning is online and as a result, the amount of classroom seat- time is reduced. If this course is listed as a hybrid course then I have followed this definition by reducing the actual class time by between 1 and 2 hours per week. To "make-up" for this loss of contact time I have integrated numerous exercises into the course content that will help you reinforce and extend the textbook and classroom discussions. If directed by the instructor, you are responsible for posting your thoughts on each Hybrid assignment in the discussion board on eLearn. You may be graded on your interactions in the discussion board. Performance Based learner Outcomes: On completion of the course, the successful student will be able to: ï‚· Develop and prepare workbooks using Excel software package. ï‚· Utilize Excel workbooks to solve typical business related problems. ï‚· Use spread sheets to solve “what if†types of problems. ï‚· Create charts to represent numerical data. ï‚· Develop macros for automating repetitive tasks. ï‚· Use scenario management to track multiple worksheet versions. ï‚· Use Solver to solve complex problems ï‚· Query Excel lists to retrieve selective information. Minimum Expectations: ï‚· Campus Policies mandate ALL emails to and from faculty and students be processed through Chemeketa Email. ï‚· You are expected to follow this by having regular access to Chemeketa email, the worldwide web, and at least MSOffice 2010. Open office will not work for this course! ï‚· You should expect to put in at least 4 hours outside of class for every hour in class. ï‚· I expect consistent class participation as defined in the assessment section of this syllabus. ï‚· I expect regular and punctual class attendance & notification when you can’t make a session. Assignments: All of the homework you turn in MUST be submitted through my SFTP student storage site. You can find information on how to submit your work on the SFTP Transfer link on the left side of my web page. You will name your electronic file using your last name followed by a comma, a space, your first name followed by a space, a dash, a space, and the name of the assignment followed by the proper file extension which of course is preceded by a dot. ...as in this example Flintstone, Fred – Altac.xlsx In addition, all assignments turned in electronically will also have your name and class information in a left justified footer in the document. ALL work is self-directed meaning you are to complete all work on your own. If you share this class with a friend, spouse, or roommate you cannot turn the same assignment in for the two of you. EACH PERSON MUST COMPLETE AND SUBMIT THIER OWN WORK. No credit will be given for work submitted in a “team-like†fashion. In other words…DO YOUR OWN WORK! Plagiarism is against College policy and all work submitted is first reviewed for uniqueness before actual grading begins. Due Dates: All work is due on the date defined in the Tentative Class schedule. (See schedule below). ABSOLUTELY NO LATE WORK WILL BE ACCEPTED! I may have set all exam items included in the grading matrix to be time released. If you miss a time released exam and/or assignment in eLearn it will NOT be reopened! ABSOLUTELY no retakes will be allowed on any exam or quiz. Missed exams CANNOT be made-up! file:///J:/WEBSITES/WEBSITE%20BLUE%20Expression/Misc/Resources1.pdf Assessment: There will be several skills case studies (homework) totaling 50% of the final grade, a mid-term exam worth 25%, and a final exam worth 25% of the final grade for the course.. . Skills (Case Studies) 50% Mid-Term 25% Final Exam 25% Total 100% The WEIGHTED GRADE posted on the Learn course site is not your final grade! It is a calculated grade that represents your current course grade average based on the work you have turned it. It in no way represents the grade you may receive for the course. Your final course grade will be calculated at the end of term and will include all required graded work as well as penalties (zero(0) grades) for work that was not submitted. Grading Specifics: Each assignment will be graded on the ability of the student to follow instructions, quality of work turned in, completeness of the assignment, and accuracy of the information submitted. In every attempt to be fair and equitable to all I have found it is straight-forward and easiest to assess a 5 point deduction for every MAJOR error relating the items noted above. Each assignment will be graded and a generic summarization of the issues AS A GROUP may be posted to the CHAT area. If you need specific direction it is your responsibility to email me for further discussion regarding your performance on a specific assignment. Grading Standards Student Attendance Criteria (Campus classes only) The percentage (%) point deduction reflects a penalty for missing class lectures and/or labs. A Absences Points deducted from final grade B % points will be deducted from your final grade C % points will be deducted from your final grade D % points will be deducted from your final grade F 8 50% points will be deducted from your final grade (How to Read) The grading standards on the left of the chart above note the overall grading scale for the course. The Student Attendance Criteria matrix on the right side of the chart notes the percentage (%) points that will be deducted from your final earned weighted average for the class due to absences from the required class lectures and/or labs. example: If you are continually present in the course for all required class and/or lab sessions OR have one absence you will not be penalized on your earned weighted grade for the class. Let’s say your final earned weighted average calculates to a 92.8% but you missed 3 days of required meeting time. Using the Student Attendance Criteria matrix above your final earned grade for the course would be an 87.8% or “B†for the class. (92.8% - 5% = 87.8%) Grading Specifics: Term Grades: will be posted at: Any student desiring a status update as to their progress in the class should check this site. Due to the nature of the course grades may be posted between 7-10 days after each assignments due date. Final Grades: will be posted on the Chemeketa Website: Any student desiring a status update as to their progress in the class may reach me during office hours or email me at [email protected] Campus policies require you use your Chemeketa email account for this type of written discussion. Incompletes: will only be given for students with extenuating circumstances that prohibited them from completing the Final Exam. These circumstances may include extended family leave approved by the College, personal validated illness that requires an extended hospitalization stay, a death in the family, or military/industry leave. Each student’s case will be individually assessed and a written performance to succeed contract will be agreed to and documented by that student and myself prior to the incomplete being assigned. Incomplete Contract Link. Absences: It stands to reason that any excessive absences from this course will affect your success in the class. I will address each students documented absences on an individual basis so I can best assist each of you progress through the class. Missed Work: As noted above work is due when assigned and will not be accepted late. Exams must be taken and turned in on the assigned dates. To maintain the integrity of the exam as well as the course NO makeup exams will be given. Academic Honesty: Any of the following is considered an unethical action on a class quiz, exam, or required assignment, and will result in failure of the guilty party who shall receive a grade of 0 (zero) for each violation: ï‚· turning in plagiarized work rather than turning a unique paper you created. ï‚· using notes, or other materials not explicitly authorized. ï‚· improperly acquiring advance copies of exam material ï‚· any conduct yielding an exam result that is not the student's individual work ï‚· any deviation from the student’s code of conduct policy statement regarding academic standards as provided to each enrolled Chemeketa student. mailto: [email protected] ../../Misc/Incomplete%20Course%20Contract.pdf Tentative Class Schedule Subject to Change without Notice WEEK READINGS TASK PAGES DUE DATES Week 1 Introductions, Review Syllabus, Managing Your Files and Intro to Excel 2010 Tutorial 1 Getting Started with EXCEL Instructor defined File Management assignment Case 1 Altac Case 3 Global Site GPS EX050 EX053 July 3rd , 8:30 a.m. Week 2 Tutorial 2 Formatting a Workbook Case 1 Frosti Wear Case 3 Arcadia Wind Farm EX109 EX112 July 10th, 8:30a.m. Week 3 Tutorial 3 Working with Formulas Tutorial 4 Working with Charts and Graphs Case 1 Chemistry Case 3 Eason Loan Case 2 Midwest Tornado Case 3 Hardin Financial EX164 EX166 EX225 EX226 July 17th, 8:30 a.m. Week 4 Tutorial 5 Tables, PivotTables, Pivot Charts Mid-Term Exam (Chapters 1-4) Case 2 Ring Family Farm Case 3 High Desert Bank EX296 EX297 July 24th, 8:30 a.m. Week 5 Tutorial 6 Multiple Worksheets Case 2 UTE Auto Sales Case 3 Infusion-Blend EX355 EX357 July 31st, 8:30 a.m. Week 6 Tutorial 7 Advanced Functions Case 1 PC Modem Case 2 Baltic Leave Case 3 M-Fresh Water Instructor Handouts August 7th 8:30 a.m. Week 7 Tutorial 8 Excel Application Development Case 2 Seattle Popcorn Case 3 Cookin’ Good EX478 EX481 August 14th 8:30 a.m. Week 8 Tutorial 9 Financial Analysis Tutorial 10 What If Analysis Final Exam (Chapters 5-8) In class Demonstration In class Demonstration August 14th 8:30 a.m. All work is due on the date defined in the Tentative Class schedule. ABSOLUTELY NO LATE WORK WILL BE ACCEPTED! I may have set all EXAM items included in the grading matrix to be time released. ABSOLUTELY no retakes will be allowed on any exam or quiz. Missed exams or due date deadlines CANNOT be made-up!