Course Syllabus

Syllabus

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 2016.

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 2016

Microsoft Excel Core 2016

Microsoft Access 2016

Microsoft PowerPoint 2016

Microsoft Word Expert 2016

Microsoft Excel Expert 2016

Microsoft Outlook 2016

Microsoft OneNote 2016

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 and 50%
  • Tests and Certifications 50%

**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 2016

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 2016 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 2016 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 2016

  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 2016

  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 2016

  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.