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.

Select an option 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	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

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

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

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

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

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