Course Syllabus

OneDrive and Intro to Cloud Computing

• Please start by reviewing the lectures for this module:Module 1 Lecture #1: Versions of Microsoft Office and ExcelandModule 1 Lecture #2: Edit a Shared Office 365 File
• Read and complete the five lessons inGCF Learn Free's tutorials on OneDriveLinks to an external site.which is the cloud-based file management system of Office 365. Goodwill Community Foundation (GCF) has excellent free resources online for learning the basics of many computer applications. They offer complimentary YouTube videos as well!
• Review the Canvas Guide:How do I upload a file from Microsoft Office 365 as an assignment submission?Links to an external site.

Create Folders in OneDrive, Microsoft 365 OneDrive Submission Practice, File Sharing in O365, Create a Google Account, Student Course Expectations, Update Canvas Profile Picture

Google Drive, Malware, Spyware, Phishing

• Please start by reviewing the lecture for this module:Module 2 Lecture: Getting Familiar with Google Drive
• CompleteGCFLearnFree’s Lessons 1-7Links to an external site.on Google Drive. (We also recommend that you complete lessons 8 and 9 and take the Google Drive Quiz so you feel fully comfortable with this content)
• Please watch this YouTube video:Understanding URLsLinks to an external site.
• Read MailFrontier'sField Guide to PhishingDownload Field Guide to PhishingOpen this document with ReadSpeaker docReader
• Read Wikipedia's entry forMalwareLinks to an external site.
• You are strongly encouraged to take this online "quiz" about website phishing from OpenDNS:https://www.opendns.com/phishing-quiz/Links to an external site.
• You are strongly encouraged to take this online "quiz" about email phishing from Google:https://phishingquiz.withgoogle.com/Links to an external site.

Cloud Computing Crash Course Part I and II Using Canvas and Google Drive, Anonymous vs. Specific Sharing

Introduction to Word Processing and Generative AI

For learning about Microsoft Word, we'll be using this textbook:Microsoft Word Step by Step (Office 2021 and Microsoft 365)Links to an external site., by Joan Lambert. You'll find this as part of the O'Reilly-Safari eBook collection available for free fromVSCS LibrariesLinks to an external site.*. You will be assigned reading and assignments based on the content of this and other eBooks in this course. Not all the reading will result in assignments, but all the reading will be used for the questions on the quiz for each application we learn so please do the reading!

Create a Word document from a template, create your 2034 resume, open a PDF in Word, Enter and Edit Text, Modify the structure and appearance of text, present information in tables and Add simple graphic elements

Copyright and Research Papers

• We'll continue using the textbookMicrosoft Word Step by StepLinks to an external site., by Joan Lambert in this module. You will be assigned reading and assignments based on the content of this and other eBooks in this course. Not all the reading will result in assignments, but all the reading will be used for the questions on the quiz for each application we learn so please do the reading! For Module 4, pleaseread and complete the following:
  • Chapter 9- Format document elements
  • Chapter 10- Organize and arrange content
  • Chapter 13- Reference content and content sources
  • You can access all of thepractice files for the text here!
• ReadCopyrightLinks to an external site.from Wikipedia
• ReadAbout the LicensesLinks to an external site.from Creative Commons
• Watch the Video:Plagiarism 2.0: Information Ethics in the Digital AgeLinks to an external site.- There will be a quiz at the end of the module based on this!
• Watch the Video: Research

Format the Page Background, Insert Headers, Footers, and Page Numbers, Cite Sources and Compile Bibliographies

Advanced Formatting, Drawing, and Long Documents

• We'll continue using the textbookMicrosoft Word Step by StepLinks to an external site., by Joan Lambert in this module.For Module 5, pleaseread and complete the following:
  • Chapter 7- Insert and modify diagrams and 3D models
  • Chapter 11- Collaborate on documents
  • You can access all of thepractice files for the text here!

Mark up documents and create picture diagrams OR insert and modify 3D models

MailMerge and Intro to Presentations

• We'll start using this textbook:Microsoft PowerPoint 2016 Step by StepLinks to an external site., by Joan Lambert in this module. For Module 6, pleaseread and complete the following:
  • Chapter 1 -PowerPoint BasicsLinks to an external site.
  • Chapter 2 -Create and Manage PresentationsLinks to an external site.
• You can access all of thepractice files for the above texts here

Add and remove slides, divide presentations into sections, rearrange slides and sections, apply themes, and change slide backgrounds

Create Presentations and Manage Slides

• We'll continue using this textbook:Microsoft PowerPoint 2016 Step by StepLinks to an external site., by Joan Lambert in this module. For Module 7, pleaseread and complete the following:
  • Chapter 3 -Create and manage slides
  • Chapter 4 -Enter and edit text on slides
  • Chapter 5 -Present text in tables
• You can access all of thepractice files for the above texts here

Add and remove slides, divide presentations into sections, apply themes, change backgrounds, enter text on slides, apply WordArt text effects, insert tables, format tables, modify table structure, embed and link to excel content

Manage Graphics, Sound, Animation, Notes

• We'll continue using this textbook:Microsoft PowerPoint 2016 Step by StepLinks to an external site., by Joan Lambert in this module. For Module 8, pleaseread and complete the following:
  • Chapter 6 -Insert and manage simple graphics
  • Chapter 7 -Create and manage business graphics
  • Chapter 8 -Add sound and movement to slides
• You can access all of thepractice files for the above texts here

Insert, move and resize pictures, edit and format pictures, draw and modify shapes, capture and insert screen clippings, create diagrams, modify diagrams, format diagrams, create charts, animate text and picture on slides, customize animation effects, add audio content to slides, add video content to slides, add and manage slide transitions

Prepare Presentations for Presentation, Multimedia, Presenter View

• Review Chapter 12 Key Points inMicrosoft Office Step by Step (Office 2021 and Microsoft 365) for PowerPoint.Links to an external site.
• Read the article,Make your PowerPoint presentations accessible to people with disabilitiesLinks to an external site., Microsoft.
• Read the article,Improve accessibility with the Accessibility CheckerLinks to an external site., Microsoft.
• Watch the YouTube Video:Life after Death by PowerPoint - Don McMillan(4.24 minutes)This is a comedian who uses humor to understand common ways people ruin presentations. Basically a video on what NOT to do when creating a presentation.
• Watch the TedTalk Video:How to Avoid Death by PowerPoint – David JP Phillips. David JP Phillips is a professional trainer of communication skills. In this 2014 TED talk, he covers 6 key ways we can improve our PowerPoint presentations to be more understandable and memorable for our audiences.

Death by powerpoint and create a professional presentation project

Introto Spreadsheets – Setup a Workbook, Work with Data and Tables

• Please start by reviewing the lecture for this module:Module 10 Lecture: Spreadsheet Tools
• We'll start using this textbook:Microsoft Excel Step by StepLinks to an external site., by Curtis/Frye/Lambert in this module. For Module 10, pleaseread and complete the following:
  • Chapter 1-Set up a workbookLinks to an external site.
  • Chapter 2-Work with data and Excel tablesLinks to an external site.
  • You can access all of thepractice files for the text here!
• Listen toPlanet Money: Episode 606: Spreadsheets!Links to an external site.

Create basic formulas, enter and revise data, manage data by using flash fill, define excel tables, planet money “spreadsheets!” reaction essay

Perform Calculations, Change Workbook Appearance, Manage Data

• We'll continue using this textbook:Microsoft Excel Step by StepLinks to an external site., by Lewis/Frye/Lambert in this module. For Module 11, pleaseread and complete the following:
  • Chapter 3-Perform calculations on dataLinks to an external site.
  • Chapter 7-Combine data from multiple sourcesLinks to an external site.
  • Chapter 14-Collaborate with colleaguesLinks to an external site.(only sections:Save workbooks for electronic distribution,Manage comments, andProtect workbooks and worksheets)
• You can access all of thepractice files for the text here!

Summarize data that meets specific conditions, use array formulas, use a template, add protection to workbooks and worksheets

Reorder and Summarize Data, Multiple Sources, Printing Spreadsheets

• We'll continue using this textbook:Microsoft Excel Step by StepLinks to an external site., by Lewis/Frye/Lambert in this module. For Module 12, pleaseread and complete the following:
  • Chapter 3-Perform calculations on dataLinks to an external site.(review)
  • Chapter 4-Change workbook appearanceLinks to an external site.
  • Chapter 6-Reorder and summarize dataLinks to an external site.
  • You can access all of thepractice files for the text here!

Find and correct errors in calculations, name data ranges, conditional formatting, using multiple spreadsheet features and functions for an order form

Formatting & Charts

• Please start by reviewing the lectures for this module:Module 13 Lecture #1: Articles about ChartsandModule 13 Lecture #2: Misleading Chart Preparation
• We'll continue using this textbook:Microsoft Excel Step by StepLinks to an external site., by Lewis/Frye/Lambert in this module. For Module 13, pleaseread and complete the following:
  • Chapter 9-Create Charts and GraphicsLinks to an external site.
  • You can access all of thepractice files for the text here!

Create charts, create specialized charts, customize chart appearance, find trends in your data, summarize your data by using sparklines, create and manage shapes, Project: Information About Us

Manage Worksheet Data

• Please start by reviewing the lectures for this module:Module 14 Lecture: Sorting and Filtering Data
• We'll continue using this textbook:Microsoft Step by StepLinks to an external site., by Lewis/Frye/Lambert in this module. For Module 14, pleaseread and complete the following:
  • Chapter 5-Manage worksheet dataLinks to an external site.
  • You can access all of thepractice files for the text here!

Filter data ranges and tables, manipulate worksheet data, define valid set of values for ranges of cells

Computing Ethics Presentations

None

Synthesis and Application – Demonstrate your readiness and professionalism, demonstrate your learning: synthesis and application at work, Wrapping it up: Final reflection activity