# January 16th, 2015 – Release Notes

## January 16th, 2015 – Release Notes

## New SIMnet Content & Features

### New Projects

* Access 2013 In Practice – Guided Project 5-2 (Upload .accdb)
* Access 2013 In Practice – Independent Project 5-5 (Upload .accdb)
* Access 2013 In Practice – Guided Project 9-1 (Upload .accdb)
* Access 2013 In Practice – Independent Project 9-5 (Upload .accdb)
* Access 2013 Skills Approach – Skill Review 9.2 (Upload .accdb)
* Access 2013 Skills Approach – Challenge Yourself 9.4 (Upload .accdb)

### Projects Updated for Macintosh Users

* Excel 2013 In Practice – Independent Project 5-4
* Excel 2013 Skills Approach – Skill Review 6.1
* PowerPoint 2013 Capstone – Level 1 Creating a Sales Presentation
* PowerPoint 2013 Capstone – Level 2 Creating a Sales Presentation
* PowerPoint 2013 Capstone – Level 3 Creating a Sales Presentation

## New/Improved Grading Features

### Access

* Validation Rules now allow alternate expressions.
  * Access 2013 Skills Approach – Challenge Yourself 5.4 (Upload .accdb)
* New grading for navigation categories, navigation groups, objects within navigation groups, and navigation shortcuts.
* New grading to check if a table is linked to a back-end database.
* New grading to check if concatenated key field values violate unique constraint.
* New grading to check record values in a junction table.
* New grading to check if a table has been deleted.

### Excel

* Improved Clustered Column/Clustered Bar Chart grading to compare cell references of Categories and Values Per series.
  * Excel 2013 In Practice – Independent Project 3-6
  * Excel 2013 In Practice – Independent Project 3-4 (Mac Supported)
  * Excel 2013 Skills Approach – Skill Review 7.1
  * O’Leary Excel 2013 – Lab 1-2 Animal Rescue Foundation Housing Cost Analysis
  * O’Leary Excel 2013 – Lab 1-3 Work Mileage Analysis
  * O’Leary Excel 2013 – Lab 2-1 U.S. Patents by Technology
  * O’Leary Excel 2013 – Lab 2-2 Airline Baggage Fees
* New grading to determine whether or not the top row is frozen, the first column is frozen or a specific pane is frozen in the worksheet.
  * Excel 2013 In Practice – Independent Project 1-5 (Mac Supported)
  * Excel 2013 In Practice – Independent Project 1-6.
  * Excel 2013 Project Learn – Work It Out 4A-E1
  * Excel 2013 GA State Standards – Work It Out 4A-E1
  * Excel 2013 Skills Approach – Skill Review 4.1

### PowerPoint

* Improved slide transition name grading.

## Bug Fixes

### Access

* Access 2013 Skills Approach – Fix It 3.6 (Upload .accdb) – Improved grading functionality on Form control locations

### Excel

* The following projects have been updated to use standard Microsoft Office themes and fonts
  * Excel 2013 In Practice – Independent Project 1-6
  * Excel 2013 Skills Approach – Challenge Yourself 4.3 (Mac Supported)
  * Excel 2013 Skills Approach – Skill Review 4.1
  * O’Leary Excel 2013 – Lab 2-1 U.S. Patents by Technology
  * O’Leary Excel 2013 – Lab 2-2 Airline Baggage
* Improved grading functionality of Excel Number Format style on the following projects:
  * O’Leary Excel 2013 – Lab 1-2 Animal Rescue Foundation Housing Cost Analysis
  * O’Leary Excel 2013 – Lab 1-3 Work Mileage Analysis
  * O’Leary Excel 2013 – Lab 3-1 Globalcomm Income Forecast
  * O’Leary Excel 2013 – Lab 3-3 Spring Break Tour Cost Analysis

### PowerPoint

* PowerPoint 2013 In Practice – Independent Project 2-5 (Mac Supported) – instruction text updated and changed to match between versions

### Word

* Word 2013 Skills Approach – Fix It 1.6 – replaced grading that searched for document elements based on paragraph numbers to search for elements based on surrounding text. Corrected letter format to match Business letter format.
* Word 2013 Skills Approach – Skill Review 3.1 – updated to use standard Microsoft Office themes and fonts.
* Word 2013 In Practice – Independent Project 1-6 (Mac Supported) – replaced grading that searched for document elements based on paragraph numbers to search for elements based on surrounding text.
* O’Leary Word 2013 – Lab 3-2 Creating a Table – Updated to use standard Microsoft Office themes and fonts.