Announcements / Instructors

New Content Released in March 2014

It has been a busy spring here at Triad! Here’s what we’ve added to SIMnet during the month of March:

New SIMbook chapters

  • A Skills Approach, Access Complete
    • Chapter 8 – Exploring Advanced Queries and Macros
      (The Skills Access Complete chapters will be released out of order.)
  • In Practice (Nordell), Access Complete
    • Chapter 7 – Creating Advanced Forms
    • Chapter 8 – Designing and Managing Databases
    • Chapter 9 – Integrating Applications

SIMnet Tasks and Questions

Updated SIMnet lesson, exam, and SIMpath content for the following In Practice (Nordell) Access chapters:

  • Chapter 3 – Creating and Using Queries
    • Totals
  • Chapter 5 – Templates, Advanced Relationships, and Macros
  • Chapter 6 – Creating Advanced Queries and Reports and Using SQL

Projects

New Projects

  • Skills Approach Word – Ch 7 Skill Review 7-2
  • Skills Approach Word – Ch 7 Challenge Yourself 7-3
  • Skills Approach Word – Ch 8 Skill Review 8.1
  • Skills Approach Word – Ch 8 Challenge Yourself 8.4
  • In Practice Access – Ch 7 Independent Project 7-4
  • In Practice Access – Ch 7 Independent Project 7-3a and 7-3b

New/Improved Grading Features

Word

Pagination

  • Determine if pagination settings have been applied to a paragraph such as widow and orphan control and keeping paragraphs together.

Cross-references

  • Check for the existence of cross-references.

Table of Contents

  • Determine if the table of contents uses a built-in formatting style.

Charts

  • Check if the chart has specific chart elements such as a title, legend, or data labels.
  • Check if a quick layout has been applied to a chart.

Pictures

  • Determine if picture has been adjusted with a color.
  • Determine if pictures have been grouped.
  • Check the alignment of pictures or picture groups.

Smart Art

  • Added checks for additional styles and color sets.

Shapes

  • Revised grading for shape formatting to work regardless of the shape type.

Tables

  • Determine if the repeat header row feature has been applied to a table header.
  • Revised grading for several table features to work when there are multiple tables in a document.

Excel

Formulas

  • Revised grading to ignore unnecessary outside parenthesis surrounding formulas.

Bug Fixes

  • In Practice Excel Ch 3 Independent Project 3-6 – Added feedback to identify when multiple trendlines exist for a data series.
  • In Practice Excel Ch 4 Independent Project 4-4 – PivotTables will not be graded correctly if the source data reference a table name or a cell range.
  • In Practice Excel Ch 6 Independent Project 6-5 – Corrected project instructions and revised grading related to nesting Index and Match functions and corresponding values for instructions #6 – 8.