Office Online Projects

Autograded projects for Office Online Apps.

What are 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.

How do I assign an autograded project for Office Online Apps?

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.

Access

There is no Office Online version of Microsoft Access.

Word

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

Skills Book Series Office Online Projects

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.

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

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

Challenge Yourself 3.4

This project was not developed due to lack of features on the Office Online App

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

Challenge Yourself 5.3

None

Steps 7, 9, 10, 11, 12, 13, 14, 15, 16, 17, 19, & 20

In Practice Book Series Office Online Projects

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.

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

Independent Project 2-6

Modified start file

All steps related to setting tabs, tab leaders, setting up custom bullets for multilevel lists.

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

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

Excel

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

Skills Book Series Office Online Projects

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.

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

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

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

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

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

In Practice Book Series Office Online Projects

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.

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

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

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

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

PowerPoint

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

Skills Book Series Office Online Projects

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.4

Step 15 - Step added to change textbox width after changing font size.

Steps 10 & 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

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

Challenge Yourself 4.4

Step 12f - Omitted part of the instruction as the feature is not available.

Steps 9, 11, 12e, 13, & 14

In Practice Book Series Office Online Projects

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

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

Improve It Project 3-7

Step 7a - Modified SmartArt option to Diverging Arrows.

Steps 3, 5d, 10, 11, & 12

PreviousProject Materials NextGetting Support

Last updated 3 years ago