Business Information Management II

In Business Information Management II, 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 postsecondary 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.

Software:  Microsoft Office 365 Office 2016 OneNote, Sway, Office Mix, Word, Excel, Access, Powerpoint

Certifications:  Microsoft Office Specialist, Microsoft Office Expert

gc

Weekly Lesson Plans:


Monday, March 1


Tuesday, March 2

Advanced Excel
Working with Trendlines, PivotTables, PivotCharts, and Slicers

  • Create a PivotChart report
  • Format a PivotChart report
  • Apply filters to a PivotChart report
  • Analyze worksheet data using a PivotTable and PivotChart reports
  • Create calculated fields
  • Create slicers to filter PivotTable and PivotChart reports
  • Format slicers
  • Analyze PivotTable and PivotChart reports using slicers
    • Pages 465 - 484

Wednesday, March 3


      Thursday, March 4

      Advanced Excel
      Working with Trendlines, PivotTables, PivotCharts, and Slicers

      • Create a PivotTable -- Apply It
        • Pages 486 - 487


          Friday, March 5