Course Syllabus

BIM II Course Syllabus-2.doc

COURSE SYLLABUS

BUSINESS INFORMATION MANAGEMENT II

(BIM II)

DANIELLE WHITE, INSTRUCTOR

Danielle.white@redoakisd.org

The Microsoft Office Specialist program is the only comprehensive, performance-based certification program approved by Microsoft to validate business computer skills using Microsoft Office 2019.

Earning a MOS certification acknowledges you have the expertise to work with Microsoft Office Programs.  MOS certification puts you at an advantage in today’s competitive job market.  There will be greater earning potential and career advancement with being a MOS certified individual.

Microsoft Word Core 2019

Microsoft Excel Core 2019

Microsoft Access 2019

Microsoft PowerPoint 2019

Microsoft Word Expert 2019

Microsoft Excel Expert 2019

Microsoft Outlook 2019

Microsoft OneNote 2019

The student will be required to receive at least four certifications during the year.  To become a Microsoft Office Specialist Master, the student will have to receive certification in five of the programs.  This can be done! I am challenging each student to become a Microsoft Office Specialist Master.

The student does not have to pay for the exam.  The school will provide them. If these tests were taken elsewhere, they would cost at least $100 each.

Grading System

  • Daily assignments 25%
  • Homework assignments 15%
  • Tests and Certifications 60%

**Please note that any student caught cheating on an assignment (including plagiarism) will receive a zero for that assignment and their parent will be notified**

Software

  • Windows 10
  • Microsoft Office Professional 2019

Students implement personal and interpersonal skills to strengthen individual performance in the workplace and in society and make a successful transition to the workforce or post-secondary education.  Students apply technical skills to address business applications of emerging technologies, create complex word-processing documents, develop sophisticated spreadsheets using charts and graphs, and make an electronic presentation using appropriate multimedia software.

Microsoft Office Certification Word 2019 Core and Expert

  1. Know how to create and customize documents
  2. Learn to format content and control pagination
  3. Become skilled in formatting illustrations, graphics, text, and text boxes
  4. Understand how to use Quick Parts to organize content, modify tables, and merge documents
  5. Know how to insert, modify, and delete comments
  6. Learn to share and secure documents
  7. Apply, create, remove and modify Styles on text, shapes, and pictures

Microsoft Office Certification Excel 2019 Core and Expert

  1. Be able to enter, copy, paste, and fill data and formulas
  2. Link worksheets, consolidate data, and calculate revenue from several worksheets
  3. Understand how to use the PivotTable and PivotCharts to automatically format and analyze data
  4. Know how to filter and outline data
  5. Be able to use the VLookup and HLookup function
  6. Save, send, and share workbooks
  7. Insert and modify Charts, Sparklines, pictures, SmartArt, and shapes.
  8. Apply QuickStyles to Charts, pictures, SmartArt, and Tables
  9. Create and modify a Table

Microsoft Office Certification PowerPoint 2019

  1. Know how to create and customize presentations
  2. Learn to format content
  3. Become skilled in formatting illustrations, graphics, text, and text boxes
  4. Apply Animation and Transitions
  5. Know how to insert and modify multimedia
  6. Learn to share and secure presentations
  7. Apply, create, remove and modify Styles on text, shapes, and pictures

Microsoft Office Certification Outlook 2019

  1. Know how to create and customize messages
  2. Learn to create, track and respond to messages automatically
  3. Organize the Inbox with Rules and Quick Steps
  4. Record and schedule appointments in the calendar
  5. Learn to create, track and respond to meeting requests
  6. Document Contacts, and Tasks Journal Entries
  7. Manage Outlook E-mail accounts, data files and backup

Microsoft Office Access 2019

  1. Create and Manage databases
  2. Create Tables, add Fields and specify the Data Type
  3. Create Forms with a Wizard, Quick Parts and in Design View
  4. Create Forms for data entry as well as list view
  5. Use Queries to combine Fields, Group, Sort and Total
  6. Create Reports and format the content, Header, Footer and layout
  7. Manage and maintain an Access database
  8. Create a strategy for archiving data with Action Queries

Required Supplies

Positive attitude, folder with brads and pockets, paper and a writing utensil.

Please note the ROISD policy below:

Academic Integrity
Students found to have engaged in academic dishonesty shall be subject to grade penalties on
assignments or tests and disciplinary penalties in accordance with the Student Code of Conduct.
Academic dishonesty includes cheating or copying the work of another student, unapproved use of
technology including cell phones, plagiarism, and unauthorized communication between students during an examination. The determination that a student has engaged in academic dishonesty shall be based on the judgment of the classroom teacher or another supervising professional employee, taking into consideration written materials, observation, or information from students.