CA-TextBook

NO Text Book* OR Software is required for Computer Applications

* This is an onLine class, we use onLine materials.

IF you have limited Internet Access - give me a call and we will adapt this course so you can use files for reading and doing the exercises.

You will need to download materials onto the computer you will be using.

We will be using FREE Office 365 tools (e.g. Word, Excel, PowerPoint), can be accessed your email through the Portal or at http://mail.o365.vsc.edu using your CCV user id and password.

and Google products (you only need a free Gmail account)

For Instruction we will be using (Please select the version of the product that you are using):

Microsoft Web Site https://support.office.com/en-us/article/Office-training-and-tutorials-b8f02f81-ec85-4493-a39b-4c48e6bc4bfb and

GCF (Goodwill Community Foundation) Learn Free

Students who want to purchase software - at discount Student/Teacher prices https://ccvermont.onthehub.com/WebStore/ProductsByMajorVersionList.aspx (Must do this from within CCV Portal)

Each CCV student has access to Office 365 - Login to the CCV Portal > In the right column open your Mail > In the BLACK bar you see Office 365 and Outlook, Click OFFICE 365 - 365 does not have a year date like 2013 or 2016 it is always kept current and has almost everything 2013 & 2016 has but is accessible from the web. https://support.office.com/en-us/article/What-is-Office-365-847caf12-2589-452c-8aca-1c009797678b?ui=en-US&rs=en-US&ad=US

This Link https://www.microsoft.com/en-us/education/students lets you use your CCV email ex. jam08260@ccv.vsc.edu <-- notice I used ccv.vsc.edu and NOT just ccv.edu Tell me how it goes. Or you can give me a call and we can do it together. JilMac 802-254-8628

Computer_Apps_Assign01-14.doc on Page 5 has images of the Menu Bars of the Software for Word Processing.

As with Cars - they all have steering wheels, directional's, windshield wipers, safety flashers, etc. but some makes & models will put them in different places - If you are used to a Toyota, and have to drive a friends Dodge ... things will be in different spots. The same is true for Computer Software - it takes a minute to get your bearings.

If you go to a CCV Computer room - the software is Microsoft Office2016

If you want to install Office 2016 on your personal computer page 4 has instruction how to download it.

If you want to use Office 365 (which you can access from a Phone, Tablet or Computer) you must be logged into the CCV Portal: http://ccv.edu > Click Portal from the top menu > and Login using your CCV login & password.

IF you have problems with ANYTHING ... please call me .... I can troubleshoot anything, we can work together to solve the issue and get you productive. JilMac 802-254-8628

We will be using the Microsoft Web Site https://support.office.com/en-us/article/Office-training-and-tutorials-b8f02f81-ec85-4493-a39b-4c48e6bc4bfb

- NOTE: 2016 tutorials are slowly getting more robust, there may be times when you need to watch a 2013 video - because they are very good
- However, you should use the VERSION of the software that you have access to. For homework assignments, I don't care what version of Office products you use. Many companies will be on older versions - be aware there are different versions and different tutorials.
- Word 2013 https://support.office.com/en-us/article/Word-2013-training-courses-videos-and-tutorials-14807f76-d2b5-44d6-af11-9c880c44e551?ui=en-US&rs=en-US&ad=US
  - Step by Step from GCF (Goodwill Community Foundation) Learn Free instructions https://www.gcflearnfree.org/word2016/

Excel 2013 https://support.office.com/en-us/article/Excel-2013-training-courses-videos-and-tutorials-aaae974d-3f47-41d9-895e-97a71c2e8a4a?ui=en-US&rs=en-US&ad=US
- - Step by Step from GCF (Goodwill Community Foundation) Learn Free instructions http://www.gcflearnfree.org/office2013/excel2013

- PowerPoint 2013 https://support.office.com/en-us/article/PowerPoint-2013-training-courses-videos-and-tutorials-bd93efc0-3582-49d1-b952-3871cde07d8a?ui=en-US&rs=en-US&ad=US
- Step by Step from GCF (Goodwill Community Foundation) Learn Free instructions http://www.gcflearnfree.org/office2013/powerpoint2013
- Access 2013 https://support.office.com/en-us/article/Access-2013-training-courses-videos-and-tutorials-a4bd10ea-d5f4-40c5-8b37-d254561f8bce?ui=en-US&rs=en-US&ad=US
- Step by Step from GCF (Goodwill Community Foundation) Learn Free instructions http://www.gcflearnfree.org/office2013/access2013

Which video training a student will use will be dependent on what version of Microsoft the student wants to learn from, and what operating system the student has, and most importantly ... what students learning style is:

If you have questions - please call JilMac 802-254-8628

The Hartness Library now has:

Computer science databases – Hartness now subscribes to the ACM Digital Library and the IEEE Computer Society Digital Library, providing full-text access to scholarly journals, technical magazines, eBooks and conference proceedings from these significant professional computer science organizations.

=============================================================================================

Word 2013 https://support.office.com/en-us/article/Word-2013-training-courses-videos-and-tutorials-14807f76-d2b5-44d6-af11-9c880c44e551?ui=en-US&rs=en-US&ad=US

INTRODUCTION

Create your first Word 2013 document
Custom Margins in Word 2013
Introduction to Tables of Contents (TOC)
Line Spacing
Spell-Check Basics
Top tips for working in Word Online
Track Changes
Things to raise your game to a college level
Work with word counts in your document

INTERMEDIATE

Create Labels
Creating an MLA paper with citations and a bibliography
Footnotes in Word 2013
Make the switch to Word 2013
Mirror margins in Word 2013
Resumes in Word
Take Tables of Contents (TOC) to the next level
Use Landscape and Portrait orientation
Using Styles in Word
Creating Forms in Word
Tips for College Papers
Why use Styles in Word
Working with Watermarks

ADVANCED

Mail Merge
Advanced Table of Contents (TOC)
Collapsible Headings
Mail Merge
Next Level Mail Merge

Step by Step from GCF (Goodwill Community Foundation) Learn Free instructions

Word 2016 https://www.gcflearnfree.org/word2016/

Word 2013 https://www.gcflearnfree.org/word2013/

Office Basics

1 Buying Office 2013

2 Working with Your Microsoft Account and OneDrive

3 Understanding Office 365

Word Basics (Lessons and Videos)

4 Getting to Know Word http://www.gcflearnfree.org/office2013/word2013/4 4min

5 Creating and Opening Documents

6 Saving and Sharing Documents

7 Text Basics

8 Formatting Text

9 Page Layout

10 Printing Documents

Working with Text

11 Indents and Tabs

12 Line and Paragraph Spacing

13 Lists

14 Hyperlinks ------------------------------

15 Breaks

16 Columns

17 Headers, Footers, and Page Numbers

Working with Objects

18 Pictures and Text Wrapping ----------

19 Formatting Pictures --------------------

20 Shapes -----------------------------------

21 Text Boxes and WordArt -------------

22 Arranging Objects ----------------------

23 Tables -----------------------------------

24 Charts -----------------------------------

Reviewing Documents and Collaboration

25 Checking Spelling and Grammar

26 Track Changes and Comments

27 Finalizing and Protecting Documents

Doing More with Word

28 SmartArt Graphics

29 Styles

30 Themes

31 Mail Merge

Extras

Customizing the Ribbon

Enabling Touch Mode

Embedding an Excel Chart

Editing PDF Files

SPREADSHEETS - http://Support.Office.com

Beginner

Add numbers in Excel 2013 =sum
Basic math in Excel
Create a chart
Create your first Excel 2013 workbook
Freeze or lock panes
Top tips for working in Excel Online
Understand and use cell references
Use AutoFill and Flash Fill
Watch online

Intermediate

Add or subtract time
Average a group of numbers
Insert headers and footers
Make the switch to Excel 2013
Sort and filter data
Take conditional formatting to the next level
Use conditional formatting
VLOOKUP: When and how to use it
Webinar: Simplifying Your Excel Data

Advanced

Advanced IF functions =sumIF
Array formulas
Create and manage drop-down lists
Create a PivotTable and analyze your data
Password protect workbooks and worksheets
Print worksheets and workbooks
Webinar: Understanding Power Pivot
Webinar: Understanding the Excel Data Model
Work with macros

EXCEL TRAINING FROM GCF Learn Free Org http://www.gcflearnfree.org/office2013/excel2013

Office Basics

1 Buying Office 2013

2 Working with Your Microsoft Account and OneDrive

3 Understanding Office 365

Excel Basics

4 Getting Started with Excel

5 Creating and Opening Workbooks

6 Saving and Sharing Workbooks

7 Cell Basics

8 Modifying Columns, Rows, and Cells

9 Formatting Cells

10 Worksheet Basics

11 Page Layout

12 Printing Workbooks

Formulas and Functions

13 Simple Formulas

14 Complex Formulas

15 Relative and Absolute Cell References

16 Functions

Working with Data

17 Freezing Panes and View Options

18 Sorting Data

19 Filtering Data

20 Groups and Subtotals

21 Tables

22 Charts

23 Sparklines

Doing More with Excel

24 Track Changes and Comments

25 Finalizing and Protecting Workbooks

26 Conditional Formatting

27 PivotTables

28 What-If Analysis

Extras

Excel 2013: Customizing the Ribbon

Excel 2013: Enabling Touch Mode

What are Reference Styles?

4 Free Alternatives to Microsoft Office

More Resources

Quiz

Free Alternatives to Microsoft Office

You can learn LOTS of things on GCF Learn Free Org

Google Drive http://www.gcflearnfree.org/googledriveanddocs

Google Docs http://www.gcflearnfree.org/googledocuments

Google Sheets http://www.gcflearnfree.org/googlespreadsheets

LinkedIN http://www.gcflearnfree.org/linkedin

Resume Writing http://www.gcflearnfree.org/resumewriting

Job Search & Networking http://www.gcflearnfree.org/jobsearchandnetworking

Interviewing Skills http://www.gcflearnfree.org/interviewingskills

Job Success http://www.gcflearnfree.org/jobsuccess

Other

Excel Formulas http://www.gcflearnfree.org/excelformulas

Photoshop http://www.gcflearnfree.org/photoshopbasics

=============================================================================================

If the computer you have is NOT connected to the Internet, a great alternative is this textbook which you can purchase used for a reasonable price.

OR you just like to have a good book - to get a used book from Amazon - JilMac recommends these:

Microsoft Office Professional 2016, 2013, 2010, 2007, or whatever software version you have, JilMac highly recommends using Microsoft's Step by Step series:

http://www.amazon.com/Microsoft-Office-Professional-2010-Step/dp/0735626960/ref=sr_1_1?ie=UTF8&qid=1337369127&sr=8-1

Title: Microsoft® Office Professional 2010 Step by StepBy: Joan Lambert, Joyce Cox, Curtis D. Frye

Publisher: Microsoft Press

Formats: Print, Ebook, Safari Books Online

Print: September 2010 Pages: 1072

Ebook: August 2010

print ISBN-10: 0735626960

print ISBN-13: 9780735626966 from Amazon $25 EdMap $45

978-0735626966

ebook ISBN: 9780735651258 Amazon $20 & Kindle $15 Used for under $5

Nook ISBN-13: 9780735649224 Nook $12.99

http://www.barnesandnoble.com/w/microsoft-project-2010-step-by-step-carl-chatfield/1100301180?ean=9780735649224

NOTE: If the student has 2007 or 2013 Windows Word

... OR ...

2008 or 2011 Macintosh Word - then they may get that corresponding book. The book you buy should be the book you are going to use. Assignments are flexible to accommodate the book a student chooses, in whatever format (print, kindle, etc) a student will feel comfortable using.

http://www.amazon.com/s/ref=nb_sb_noss?url=search-alias%3Dstripbooks&field-keywords=Microsoft%20Office%20step-by-step

Examples from the TEXT - http://go.microsoft.com/fwlink/?Linkid=192155 <-- page xxix in the Office 2010 text note: your page or link may be different if you are using a different version.

31 Chapters - we will be covering all except Part 5, & 6 - we will use the ideas in Publisher throughout the semester.

Part 1 - Files (1 assignment)

Part 2 - Word (chap 3-7) (4 assignments)

Part 3 - Excel (chap 8-12) (4 assignments)

Part 4 - PowerPoint (Chap 13-17) (2 assignments)

Part 5 - oneNote (chap 18-20) <-- we will not cover in class

Part 6 - Outlook (chap 21-24) <-- we will use gMail instead

Part 7 - Access/Database (chap 25-28) (3 assignments)

Part 8 - Publisher (chap 29-31) <-- we will make Cards & Postcards in Word, Calendars in Google Calendar,

Use Templates in Word & Excel, Use Graphics, Text Boxes, etc in Word & Excel.

Examples from this book http://examples.oreilly.com/9780735626966-files

Errata for this Book http://oreilly.com/catalog/errata.csp?isbn=9780735626966

NOTE: Fall 2014 the CCV colleges will be moving to MicroSoft Office 2013 and have Windows 7 for the Operating Systems

Fall 2014 Micro Apps instructors—

For the coming academic year, CCV will be licensing the Microsoft IT Academy (ITA) for all twelve academic centers. As you may know, ITA is a huge repository of self-paced tutorial courses, instructor materials, and complete e-textbooks on many Microsoft applications, including all components of the Office suite. Please see the attached two-page overview of ITA for more information.

With the change to Office 2013 for the fall 2014 semester, the CCV Technology Committee is glad to provide these extensive resources to our CIS faculty and their students. Many of you have already made the switch away from expensive print textbooks for Micro Apps, and the ITA resources present an opportunity for other instructors to make this welcome move or augment their existing resources. An additional ITA benefit: for those students who wish to expand their learning in your courses by using the ITA tutorial and reference materials, we will be offering the opportunity to sit for the exams leading to Microsoft Office Specialist certification, which will be available at our Rutland academic center.

With the May 6 textbook ordering deadline for the fall semester approaching rapidly, we want to provide information about ITA to help you decide if you want to use its resources in lieu of a textbook. To do so, we have developed a Moodle course that includes those materials most relevant to instructors and students in Micro Apps, including course activities, e-textbooks, and resources that address course objectives not related to word processing, spreadsheet, and presentation applications. The course is built around the course Essential Objectives, so you can integrate the materials into your section of Micro Apps as you see fit.

We hope that the demonstration Micro Apps Moodle course will help you plan for teaching with Office 2013 this fall and provide a way to avoid adoption of an expensive print textbook. The course is still in development, and we would welcome your suggestions for additions that will make it a rich resource for teaching Micro Apps.

Many of you have already been added to the course as Teachers. Just follow this link: https://learn.vsc.edu/course/view.php?id=15852. Log in with your regular portal login. You should be taken directly to the course but if not look in the Navigation block on the left for My courses and find the course, CCV-ITAcademy2013Faculty. If you don’t see the course name there, email me, and I’ll put you in.

We know you’ll have questions about ITA, the Moodle course, and using these resources with your Micro Apps course this fall. The use of ITA in conjunction with your course is entirely optional, but we hope you’ll consider the possibility and let us know if you have questions.

Page updated

Google Sites

Report abuse