Ebtm250Syllabus(1) - Notes PDF

Preview

Summary

Notes...

Description

EBTM 250: Problem Solving in Business I Instructor: Alice Zhang / Email: [email protected] / Tel: 410-704-4121 / Office: SA113 Office hours: M 2:00-3:15 pm in SA113 / W 3:15-3:30 pm in ST208 Classroom 2019 Spring Class Time EBTM 250-455 EBTM 250-462 EBTM 250-463

W 2:00-3:15 M 3:30-4:45 W 3:30-4:45

ST208 ST208 ST208

Learning Objectives EBTM 250 is a hybrid course designed to help you build skills and prepare for the 2016 Excel Microsoft Office Specialist (MOS) exam to earn Microsoft Office Specialist certification. Topics include: Creating, managing workbooks and worksheets; creating cells, ranges, tables, charts and objects; creating advanced formulas and advanced chart elements; applying formulas and functions, managing and sharing workbooks, custom formats and layouts.

Learning Objectives After completing this course, students will be able to:  Manage workbook changes and multiple workbooks.  Apply custom data formats.  Apply custom styles and templates.  Apply advanced conditional formatting and filtering.  Look up data with functions.  Apply functions in formulas.  Create scenarios.  Create advanced chart elements.  Create and manage PivotTables.  Successfully complete the Microsoft Office Specialist (MOS) Excel 2016 exam. Course Materials a. Textbook: Your Office: Microsoft Excel 2016, Comprehensive, by Jacobson / Kinser / Moriarity ISBN-10: 0134487257 / ISBN-13: 9780134487250. Publisher: Pearson, Copyright: 2017

b. Access to Pearson’s MyITLab for online training, including e-text, videos, simulations and grader projects assignments c. Voucher for taking the MOS Certification Exam. Assignment: Simulation Training / Grader Projects / Lynda/com Prep  All simulation trainings and grader projects must be completed by the deadlines as delineated in the MyITLab assignment calendar. There is a penalty of 5% for each week beyond the deadline.  Cert Prep: Excel 2016 Microsoft Office Specialist (77-727) offer by Lynda.com is a handy and very helpful package that offers step by step trainings with challenge questions and a practice exam to prepare you for the exam.

1

You must obtain a 70% score in EACH simulation training and EACH grader project plus 100% completion of CertPrep to qualify yourself to take the MOS exam. Tentative Course Outline

Class 1

Topics

Skills

Chapter 1: Navigate, Manipulate, and Print Worksheets



Chapter 2: Formats, Functions and Formulas



     



  

2

Chapter 3: Cell References, Named Ranges, and Functions Chapter 4: Effective Charts

     

3

Chapter 6: Analyze Data Using Tables

  

CertPrep by Lynda.com 4

5 6

Navigate within and among worksheets and workbooks Document your work Enter and Edit Data Manipulate Cells and Cell ranges Manipulate Columns and Rows Manipulate Worksheets and Workbooks Preview, Export and Print Worksheets Worksheet Formatting – format cells, cell ranges, and worksheets. Creating Information for Decision Making – Using SUM, COUNT, AVERAGE, MIN and MAX Functions Using Conditional Formatting to Assist Decision Making Hide Information in a Worksheet Document Functions and Formulas Referencing Cells and Named Ranges Understanding Functions Designing a Chart Creating different types of charts – pie, line, column, bar, scatter, area, combination charts Exploring Chart Layouts Effectively Using Charts Organizing Data with Tables Using the SUBTOTAL Function and Filters in Data Tables Organizing and Analyzing with PivotTables and PivotCharts



CertPrep online training completion



Prepare for the Exam

MOS Exam Registration

MOS Certification Exam: 1st attempt MOS Certification Exam: 2nd attempt

TU is a registered CertiPort Authorized Testing Center (CATC) that can execute MOS Microsoft Office Excel certification exam. All EBTM 250 students will take the exam in-house at Towson University.

2

Please ensure that you have NO conflicts with exam dates/times as There will be NO rescheduling and no make-up exams. Course Evaluation Students must successfully pass all the assignments and exams to pass the course. The exam is 50 minutes in length and we will need around 30 additional minutes to setup the exam. Most Microsoft Certification exams contain 30-60 questions and the number may vary. Microsoft has an extensive section on their exam policies and a FAQ available here: https://www.microsoft.com/learning/en-us/certification-exam-policies.aspx#exam_basics.

Grading Schema      

70% or higher on each simulation training and grader project AND 100% completion of CertPrep AND Pass the designated MOS certification exam Less than 70% score on any of the simulation training or grader projects OR Incompletion of CertPrep OR Failing or not taking the designated MOS Certification Exam

Grade

S(atisfactory)

U(nsatisfactory)

Course Policies and Procedures Writing Standards Effective managers, leaders, and teachers are also effective communicators. Written communication is an important element of the total communication process. The College of Business & Economics recognizes and expects exemplary writing to be the norm for course work. To this end, all papers, individual and group, must demonstrate undergraduate level writing and comply with the format requirements of the Publication Manual of the American Psychological Association (6th Edition 2009). Careful attention should be given to spelling, punctuation, source citations, references, and the presentation of tables and figures. Timeliness It is expected that all course work will be presented on time and error free. Work submitted online should follow standard procedures for formatting and citations. Academic Integrity and Plagiarism Academic integrity is central to the learning and teaching process. Students are expected to conduct themselves in a manner that will contribute to the maintenance of academic integrity by making all reasonable efforts to prevent the occurrence of academic dishonesty. Academic dishonesty includes, but is not limited to, obtaining or giving aid on an examination, having unauthorized prior knowledge of an examination, doing work for another student, and plagiarism of all types. 3

Plagiarism is the intentional or unintentional presentation of another person’s idea or product as one’s own. Plagiarism includes, but is not limited to, the following: copying verbatim all or part of another’s written work; using phrases, charts, figures, illustrations, or mathematical or scientific solutions without citing the source; paraphrasing ideas, conclusions, or research without citing the source; and using all or part of a literary plot, poem, film, musical score, or other artistic product without attributing the work to its creator. Students can avoid unintentional plagiarism by following carefully accepted scholarly practices. Notes taken for papers and research projects should accurately record sources to material to be cited, quoted, paraphrased, or summarized, and papers should acknowledge these sources. The penalties for plagiarism include a zero or a grade of F on the work in question, a grade of F in the course, suspension with a file letter, suspension with a transcript notation, or expulsion. Students may learn more about Towson University’s formal policies at: https://inside.towson.edu/generalcampus/tupolicies/index.cfm Simulation Training Exercises and Grader Projects are individual exercises so you MUST work on your own files. Please DO NOT PROVIDE to or COPY from anyone any portions of individual files. Pearson has a way to find out if you do. While discussion amongst classmates is not frowned upon, providing your files or copying or submitting someone else’s file, or even a portion, will result in a FAILING grade for the course. Disability and Equal Access Policy In accordance with Towson University, State of Maryland and federal government policies, students will not be denied access to this course on the basis of race, color, religion, age, national origin, sex, disability and sexual orientation. Students with documented disabilities and who require accommodations should contact the instructor within the first week of the class to arrange for accommodation. Students with disabilities must verify their eligibility for accommodations through the Office of Disability Support Services [AD 232, (410) 704-2638 (Voice or TDD), www.towson.edu/dss]. See also the Office of Diversity and Equal Opportunity, 410-7042360, www.towson.edu/aa. However, since the MOS exam is created by Certiport and administered under their guidelines, the process for requesting accommodations for the MOS exam is determined and approved by Certiport. More information can be found in http://www.certiport.com/PORTAL/desktopdefault.aspx? page=common/pagelibrary/Disabilities.htm. Since the process can take at least 10 business days, you must begin the process of seeking accommodations in the very first week of class. Please contact the Office of Disability Support Services to help you fill out the information needed by Certiport.

4...