Business Information Management I

In Business Information Management I, students implement personal and interpersonal skills to strengthen individual performance in the workplace and in society and make a successful transition to the workforce and postsecondary education. Students apply technical skills to address business applications of emerging technologies, create word-processing documents, develop a spreadsheet, formulate a database, and make an electronic presentation using appropriate software. 

Software: Microsoft Office 2016 Word, Excel, Access, Powerpoint

Certifications:  Microsoft Office Specialist, Microsoft Office Expert

Weekly Lesson Plans: 


Monday, March 16

Chapter 8 Advanced Spreadsheet Techniques

  • Practice: Timeline pages 308 - 309 Using dates and times in formulas
  • Practice: Art Studio Students pages 312 - 315 Using tables and data validation
  • Practice: Corporate Sales pages 317 - 318 PivotTables and PivotTable Reports


    Tuesday, March 17

    Chapter 8 Advanced Spreadsheet Techniques

    • Handout 8.1.1 Date Calculations
    • Handout 8.1.2 PivotChart
    • Quiz 8.1


      Wednesday, March 18

      Chapter 8 Advanced Spreadsheet Techniques

      • Practice: Employee Discounts page 320 Choose function
      • Practice: Payroll Part 2 pages 323 - 325 Freeze cells, VLookup functions
      • Practice: Payroll Part 3 pages 327 - 328 Hyperlink, create a linked object

        Thursday, March 19

        Chapter 8 Advanced Spreadsheet Techniques

        • Practice: Company Name pages 329 - 331 Macros
        • Quiz 8.2
        • Exercise 1 Florida Flights page 334 Choose function

            Friday, March 20

            Chapter 8 Advanced Spreadsheet Techniques

            • Exercise 5 Music Sale page 337 Choose and VLookup Function
            • Exercise 4 Target Zone page 336 VLookup function
            • Exercise 3 Aquarium page 335 VLookup function