NO Text Book OR Software is required for Computer Applications

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

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

For Instruction we will be using :

Microsoft Web Site and

GCF (Goodwill Community Foundation) Learn Free   

Students who want to purchase software - at discount Student/Teacher prices (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.

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

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

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

Customizing the Ribbon
Enabling Touch Mode
Embedding an Excel Chart
Editing PDF Files



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

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

Excel 2013: Customizing the Ribbon
Excel 2013: Enabling Touch Mode
What are Reference Styles?
4 Free Alternatives to Microsoft Office
More Resources

Free Alternatives to Microsoft Office

You can learn LOTS of things on GCF Learn Free Org
 Google Drive
 Google Docs
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:

Title:  Microsoft® Office Professional 2010 Step by Step
By:   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
ebook ISBN:      9780735651258  Amazon $20 & Kindle $15  Used for under $5
Nook    ISBN-13:    9780735649224      Nook $12.99
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. 

Examples from the TEXT -   <-- 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.

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