Autograded projects for Office Online Apps.
Microsoft offers free online versions of Word, Excel, and PowerPoint. While these web apps are easily accessible to students, there is not one-to-one feature parity between the installed version and the Office Online version. SIMnet’s autograded projects are written to assess a student’s knowledge of the installed version of the Microsoft Office apps. However, some students have access to the Office Online version of the apps only. Unfortunately, due to the difference in features, students using the Online Office version cannot be assessed using the auto-graded projects from the textbooks.
For students who have access to the Office Online apps only, existing auto-graded projects from the In Practice and Skills Approach series have been modified by rewriting and removing steps that reference features not currently available in the Office Online version of the apps. Below you will find lists of each Office app and the features that are available in the installed version of the app, but not the Office Online version. In addition, a breakdown of each Office Online project is provided, including all modified and deleted steps.
The steps to assign an Office Online Project to a student or class are the same as any other project. In the Projects section in the Course Manager, new Office Online options are available from the Series drop-down list.
There is no Office Online version of Microsoft Access.
The following features do not exist in the Word Office Online app:
Shading option in the Paragraph group
Design tab; Themes and Style sets
Built-in Headers & Footers
Link to a place or section in the document
Columns in Page Setup group
Cover Pages
Watermarks
WordArt
Charts
Sort
Markup
Word Options dialog; Autocorrect
Advanced Find and Replace
Thesaurus
Tabs dialog
Inserting a Table of Contents
Mark Entry
Font dialog options
Document Properties
Update or Modify Styles
Convert Text to Table
Table AutoFit and Re-size
Picture Effects, absolute positioning and picture captions
In this table you will find steps from the original project that have been modified to work with the Office Online version of Word as well as steps that have been deleted and number of points possible.
In this table you will find steps from the original project that have been modified to work with the Office Online version of Word as well as steps that have been deleted and number points possible.
The following features do not exist in the Excel Office Online app:
Quick Analysis Tool
Create a named range
Error Checking
Themes
Headers & Footers
Print Titles
Custom Margins
Backstage View
Copy/Paste Without Formatting
Define Names
Goal Seek
Data Tables
Recommended PivotTables
Sparklines
Slicers
In this table you will find steps from the original project that have been modified to work with the Office Online version of Excel as well as steps that have been deleted and number points possible.
In this table you will find steps from the original project that have been modified to work with the Office Online version of Excel as well as steps that have been deleted and number points possible.
The following features do not exist in the PowerPoint Office Online app:
Slides from Outline
Charts
Ruler
Outline View
Animation Painter
Background Styles
Font Themes
Convert to SmartArt
Custom Theme Colors
Presenter View
Setting up a Kiosk Presentation
Replace
Adding Dates to a Footer
Rehearse Timings
Handout Master View
In this table you will find steps from the original project that have been modified to work with the Office Online version of PowerPoint as well as steps that have been deleted and number points possible.
In this table you will find steps from the original project that have been modified to work with the Office Online version of PowerPoint as well as steps that have been deleted and number points possible.
Project Name
Modified Steps
Deleted Steps
Original # of Points
New # of Points
Challenge Yourself 1.3
Step 16: a-c (reordered)
Step 16d added -Ignore other suggestions in the Refinements section
None
9
9
Challenge Yourself 2.3
Steps 19, 20 - steps were altered to specify setting a left indent of .5 and .75 for the lists.
Step 10
20
19
Challenge Yourself 3.4
This project was not developed due to lack of features on the Office Online App
n/a
n/a
n/a
Challenge Yourself 4.4
Step 10 - Modified to use Grid Table 4 - Accent 1 because this is the closest option available.
Step 15 - Use Square Right Text wrap option for the picture.
Steps 2, 4, 5, 6, & 11
21
13
Challenge Yourself 5.3
None
Steps 7, 9, 10, 11, 12, 13, 14, 15, 16, 17, 19, & 20
18
8
Project Name
Modified Steps
Deleted Steps
Original # of Points
New # of Points
Independent Project 1-4
Step 5 - Removed Ctrl+Home
Step 8.a, 8.c - Removed small caps
Step 11
20
15
Independent Project 2-6
Modified start file
All steps related to setting tabs, tab leaders, setting up custom bullets for multilevel lists.
22
10
Independent Project 3-6
Step 4 - Removed changing Display for Review
Step 8 - Update a TOC already inserted into the start file
Step 9 - Remove insertion of header - modify footer steps to type in document title and company name and apply boldface formatting
Steps 3 & 11
24
15
Independent Project 4-4
Step 4 - Only apply List Table 1 Light Accent 1 style because Accent 2 was not available.
Step 5 – Only merge the cells and inserting rows and columns and formatting text.
Step 7 - Removed Small Caps
Steps 3, 4.d, 4.e, 4.g, 5.e, 5.f, 5.g, 8, 9.d, 9.e, 9.f, 9.g, 9.h, 9.i, & 9.j
32
18
Project Name
Modified Steps
Deleted Steps
Original # of Points
New # of Points
Challenge Yourself 1.3
Step 8 - Use AutoSum rather than Quick Analysis Tool. Step 15 - Only print preview the sheet. Even when the chart is selected, the print preview does not show only the chart.
None
12
12
Challenge Yourself 2.4
Modifed start file so that the column width for column A so that the text appears cut off per step 13.
Step 6 - Original color is not available, changed to: Grey, Accent 3, Lighter 80% as they are essentially the same color.
None
15
15
Challenge Yourself 3.3
Modified the start file to include named ranges.
Step 6 - Use the named range that already exists in the file.
Step 14.c - Modified to: Review your formulas for any possible errors.
Step 15 - Use the named ranges that already exist in the start file.
Steps 3, 4, 5.c, 10.c, & 10.d
35
34
Challenge Yourself 4.3
Step 5 - Changed to Orange, Accent 2 - it is the same color
Step 13 - You cannot group worksheets. Modified this step to have students apply the changes to both sheets separately.
Steps 4, 6, 16, 17, & 18
19
13
Challenge Yourself 5.3
Step 8 - Modified so students build the Sum of Price Per Pair by Region Pivot table
Step 9 - Modified so students create a clustered column chart from the pivot table. There is no Pivot Chart button.
Step 11.a - There are no data callout data labels. Replaced with Outside End.
Steps 6, 7, 12, &13
17
12
Project Name
Modified Steps
Deleted Steps
Original # of Points
New # of Points
Independent Project 1-6
Modified start file to include Header and centered worksheet horizontally on page
Steps 15h and 15i - Altered to use Accent 6, Lighter 40%
Step 17a - Altered to Light Green (tab color).
Steps 2 & 18
26
22
Independent Project 2-5
Step 5b, 6e, and 7d – Removed copy without formatting (unable to successfully copy/ paste formula without formatting to preserve borders due to copy/paste limitations).
Step 10b – Modified from “More Functions button in the Function Library group” to “Insert Function button.”
Step 12c –Modified to Merge & Center (center across selection not available).
Step 12g
21
21
Independent Project 3-4
Modified start file to include a new sheet for adding pie chart.
Step 4 - Modified title to: CGL Major Sales Revenue: Second and Third Quarters due to grading. Function does not recognize Chart Title on second line.
Step 8 - Modified to use Select Data dialog box to change chart data range. Cannot select range using resize pointer to select data series.
Step 9 - Modified to use Pie chart because 3-D Pie charts are not available in Office Online. A new sheet with said range was added to the start file. Users cannot create a chart from non-contiguous cell ranges.
Step 11 - Step added for additional grading because users cannot create a chart from non-contiguous cell ranges.
Step 13b - Modified to apply data labels to outside end and bold formatting only for aesthetic purposes.
Steps 5, 7, 12, & 13a
13
10
Independent Project 4-5
Step 6 - Modified step to “Duplicate the Stats sheet and move it to the end. Name the copy PM Flights.” due to Office Online wording.
Step 10 - Modified to insert PivotTable on New worksheet. Users do not have access to the Quick Analysis tool on Office Online.
Step 10 - New step added to display the Capacity and Origin fields in the PivotTable
Steps 12 & 13 -Modified so that users can set number formats using the ribbon and edit the custom name using PivotTable field settings.
Step 14 - Modified to remove White, Pivot Style Light 8 (no styles for PivotTable available) kept banded rows and columns
Step 15 - Modified from 3-D Pie chart to Pie Chart (3-D Pie chart not available)
None
14
14
Project Name
Modified Steps
Deleted Steps
Original # of Points
New # of Points
Challenge Yourself 1.4
Step 15 - Step added to change textbox width after changing font size.
Steps 10 & 12
15
12
Challenge Yourself 2.4
Step 3 - Text is now being changed in Normal view. Step 5 - Pictures are arranged on the right side of the slide as there is no ruler.
Step 17 - The layout of slide 4 has been changed in start file.
Steps 2 & 20
14
12
Challenge Yourself 3.4
Modified start file so that slides 4, 5, 6, 7, 10, and 11 have the Wipe From Left Animation on text placeholders.
Step 18 - Weight option changed to 2.25.
Step 10
17
16
Challenge Yourself 4.4
Step 12f - Omitted part of the instruction as the feature is not available.
Steps 9, 11, 12e, 13, & 14
13
10
Project Name
Modified Steps
Deleted Steps
Original # of Points
New # of Points
Independent Project 1-5
Modified resource file so it is styled the same as the start file.
Modified start file to use Style 4 Background Style and Georgia Theme fonts.
Step 2 - Removed “Press F12 to open the Save As dialog box and save this file.” Shortcut is not available in Office Online.
Step 6 - Notes added to upload and save resource file to OneDrive.
Step 6b - Note added for clarity.
Step 3
13
11
Independent Project 2-6
Removed resource file as was no longer needed due to deleting step 12.
Steps 4b & 5a - Width size added to instruction. Step 6e - Shape Outline Weight adjusted to 2¼ pt. Step 7e - Changed instruction to “Move your insertion point on slide 3 and press Ctrl+V.”
Steps 11c & 11e - Width size added to instruction
Steps 3a, 3b, 4c, 8c, 9, & 12
29
19
Improve It Project 3-7
Step 7a - Modified SmartArt option to Diverging Arrows.
Steps 3, 5d, 10, 11, & 12
16
12