CITPT 213 Office 2013 Intermediate
COURSE SYLLABUS – begin January13, 2015
CITPT 213Office 2013 Intermediate
Instructor, Dr. R. Bruce Moore
CATALOG COURSE DESCRIPTION:
Business Division, Computer Information Technology: Professional Technical
CITPT-213OFFICE 2013 Intermediate (3 hr.) This is a non-accredited, Professional-Technical course offering practical job skills for which you will receive a Certificate of Completion, but not transcripted credit. This intermediate course deepens a student’s understanding of Windows 2013, Word, Excel, and PowerPoint using practical business and personal applications. This course does not address MS-Access, Outlook, or Publisher.
Activities, expectations, and schedules are subject to change without notice.
INSTRUCTOR:
Name:R. Bruce Moore, Ph.D.
Office:106 E. Park Ste. 227, Academic Center
Office Hours:Monday and Tuesday 11:00 to 1:30, or by appointment, in Academic Center
Phone:208-880-4799
E-Mail:
OFFICE HOURS:
My office hours are Monday and Tuesday, 11:00 to 1:00. The ONLY way to be sure of contacting me is by appointment. Feel free to call, if I don’t pick up, be sure to leave a name and phone number, I will try to return calls within 24 businesshours.
COURSE SCHEDULE:
Tuesday and Thursday evenings from 6:30 to 8:00 PM, beginning January13 and running through Thursday, March3, 2015.
COURSE PREREQUISITES:
Typing/Keyboarding skills are recommended.
Bring your own laptop to maximize the usefulness of your learning.
REQUIRED TEXT BOOKS:
Manning, C., Swinson, C., (2013). Microsoft ® Office: A Skills Approach 2013. New York, McGraw-Hill. ISBN: 978-0-07-351645-5NewRetail: $126.00 or go to Amazon.com or Barnes&Nobles.com to find used books.
Note: this textbook will serve students in both CITPT 113 Office 2013 Basic as well as CITPT 213Office 2013 Intermediate.
INTERNET RESOURCES:
- Microsoft Online has many helps, they are mostly text – not video.
- YouTube has several video training segments for Excel, try them out.
PROJECT PAPERS:
- Word: Flyer or Your Choice
- Excel: To be determined
- Powerpoint: To be determined
CLASS SESSION SCHEDULE:
Class #1 January13, 2015 (Tuesday)Manning: Chap WD 3:1-3.10file: Crayola Colors
Overview and Syllabus, Review Word skills 1.1 through 2.19 (Manning).
Using the WEB for Research: EBSCO Host at lili.com
Living with your Computer: BackUps, Virus Protection, Peripheral devices
Getting acquainted with Moodle
Intro to the WEB / WEB Browser InterfacesTaxTips EOY[CompatibilityMode]
WD 3.1, 2, and 3 Document Themes, Style Sets, and Colors
WD 3.4 Using Font Themes, Adding Borders
WD 3.5Watermarks
WD 3.6, 7, & 8Headers and Footers, Adding automatic Date & Time stamp, Inserting Page Numbers[1of8 Num & Page]
WD 3.10 Inserting Building Blocks
Assignment to turn in before next class: Email Crayola Colors with Header: filename and date/time and page # to
Class #2 January15 (Th):Manning: Chap WD3:11-4.11
WD 3.11Inserting Property ControlsConvert to 2013 Sample Sales Letter MMrg
WD 3.12 HyperlinksInsert Tab
WD 3.13, 14Adjusting Margins, Page Breaks and Section Breaks in PageLayout Use CrayolaColor for 2 column ContinPage
WD 3.15 Adding Page BordersDesign Tab
WD 3.16 Adding a Cover Page Insert Tab
WD 3.17-19 Previewing and Printing a Document, # of Copies, and Page Ranges
WD 4.1 Inserting Online Pictures (rbm:and Wrapping Text: 2010 4.13)
WD 4.5, 6 Inserting Pictures, clip art, and Positioning Pictures
WD 4.2, 3, 4Resizing Pictures, Changing Picture Layout Moving Pictures
WD 4.7 Applying Quick Styles to PicturesSelect Pix- Picture Tools Format Tab
WD 4.8 Inserting Smart ArtInsert
WD 4.9 Inserting a Shape
WD 4.10 Adding WordArt to Documents
WD 4.11 Adding an Online Video
Class #3 January20 (Tu): Manning: Chap WD 4.12-4.21
WD 4.12, 13Creating and working with TablesTables PamMangumChocCookies
WD 4.14-15 Inserting Rows and Columns and CellsAutoFit
WD 4.16 Sizing Tables, Columns and Rows
WD 4.17 Merging and Splitting Cells
WD 4.18 Sorting Data in Tables
WD 4.19 Applying Table Quick Styles
WD 4.20 Adding Borders to a Table
WD 4.21 Creating and Modifying Charts
Assignment to turn in before next class: Email Pam’s Chocolate Chip Cookies in table form to
Class #4 January 22 (Th): Manning: Chap WD 5.1-5.16 file: ConnorHowAdultLearn
WD 5.1 Using AutoCorrect (c) (e) (r) … :( :) <-- --> <== ==> <=>
WD 5.2-3 Checking Grammar & Using the Thesaurus
WD 5.4-5 Using Tabs Dialog and LeadersSample Sales Letter for Leadertabs Decimaltabs
WD 5.6 Inserting a Table of ContentsWd Conner How Adults Learn
WD 5.7 Inserting Footnotes and Endnotes
WD 5.8 Adding a CaptionYouTube: Brain Rule #1
WD 5.9 Selecting a Reference Style
WD 5.10 Adding Citations to Documents
WD 5.11 Creating a Bibliography Add Bob Thomas Walt Disney: An American Original, 1976, New York, Pocket Books
WD 5.12 Marking Entries for an Index
WD 5.13 Creating an Index
WD 5.14-15 Using Views, Read Mode
WD 5.16 Creating documents using Templates
Assignment to turn in before next class:Email “Conner, How Adults Learn”, with Table of contents and Bibliography to
Class #5 January27 (Tu): Manning: Chap WD 5.17-5.23
WD 5.17-18 Starting a Mail Merge, Selecting RecipientsExl SampleListLabelMailmerge
WD 5.19 Adding an Address BlockWd MailmergeRecipientsWord
WD 5.20 Adding a Greeting lineWd Sample Sales Letter
WD 5.21 Previewing and Finishing the Merge
WD 5.22-3 Creating Envelopes and LabelsTo/From address printing dilogbox
Assignment to be turned in before next class: Word Project: Flyer or Your Choice
Class #6 January 29 (Th): Manning: Chap EX2.4-2.21+Absolute
EX 2.4 Wrapping TextCampRunAmuk
EX 2.5 Inserting and Deleting Cells
EX 2.13 Using Format Painter
EX 2.14 Applying Conditional Formatting / Quick Analysis Tool
EX 2.15 Conditional Formatting / Data Bars, Color Scales, Icon Sets,
EX 2.16 Conditional Formatting / Highlighting Cells
EX 2.17 Conditional Formatting / Top and Bottom rules
EX 2.18 Removing Conditional Formatting
EX 2.19 Clearing Cell Content
EX 2.20 Using Find and Replace
EX 2.21 Setting and Clearing Print Area
EX 3. ½ Using an Absolute and Relative References (F4=Absolute)
Class #7 February3 (Tu): Manning: Chap EX 3.1-3.19 – Review and Mid-term Exam
EX 3.1 Using Function Arguments Dialog to enter functionsChartsWidgetsGizmos
EX 3.2 Using Formula AutoComplete to Enter Functions
EX 3.3-5 Calculating Averages, Counting, Minim and Maxim,
EX 3.6 Using Date and Time functions
EX 3.7 Formatting Text using Functions
EX 3.8 Using CONCATENATE to combine text
EX 3.9 Naming Ranges of Cells
EX 3.10 Working with Named Ranges
EX 3.11 Updating Names Ranges with Name Manager
EX 3.12 Editing and Deleting Names in Name Manager
EX 3.13 Using logical function IFWkBk RunAmock Wksht: FoodInventory
EX 3.14 Calculating loan payments using PMT>= or <=
EX 3.15 Creating formulas referencing Data from Other Worksheets
EX 3.16 Finding Data using VLOOKUP
EX 3.17 Checking Formulas for Errors
EX 3.18 Using Trace Precedents and Dependents
EX 3.19 Displaying and Printing FormulasControl + “tilde”
Assignment to turn in before next class: What is the $$ difference in interest cost if you mortgage a house for $150,000 at 5% interest for 30 years (360 months) versus 20 years (240 months). Email to Bruce.
Class #8 February5 (Th): Manning: Chap EX 4.1-4.12
EX 4.1-2 Inserting and Naming Worksheets
EX 4.3 Changing color of worksheet tabs
EX 4.4 Moving and Copying Worksheets
EX 4.5Deleting Worksheets
EX 4.6Grouping Worksheets
EX 4.7Applying Themes
EX 4.8Modifying Column Widths and Row Heights
EX 4.9Inserting and Deleting Rows and Columns
EX 4.10Freezing and Unfreezing Rows and Columns
EX 4.11Hiding and Unhiding Rows and Columns
EX 4.12Splitting Workbooks
Class #9 February10Manning: Chap EX 4.13-4.21
Reading: Manning, EX 4.15- 4.17 before class
EX 4.13 Changing the Worksheet View
EX 4.14 Adding Headers and Footers
EX 4.15 Inserting Page Breaks
EX 4.16 Show/Hiding Worksheet Elements
EX 4.17 Change Orientation
EX 4.18 Setting Margins for Printing
EX 4.19 Scaling Worksheets for Printing
EX 4.20 Printing Titles
EX 4.21 Printing Selections, Worksheets, and Workbooks
Assignment to turn in before next class: Use ‘Sample Household Budget rbm.xlsx to add Sum, AVG, Minimum, Maximum and email to
Class #10 February 12Manning: Chap EX 5.1 -5.12
EX 5.1-2 Exploring Charts and Recommended ChartsChartsWidgetsGizmos
EX 5.3 Inserting a Column or Bar ChartPlaced into EOYTaxTips
EX 5.4 Inserting a Pie Chart
EX 5.5 Inserting a Line Chart
EX 5.6 Moving a Chart
EX 5.7 Showing and Hiding Chart Elements
EX 5.8 Applying Quick Styles and Colors to Charts
EX 5.9 Changing the Chart Type
EX 5.10Filtering Chart Data
EX 5.11Converting Data into Tables
EX 5.12Adding Total Rows to Tables
Class #11 February 17 (Tuesday)Manning: Chap EX5.13-5.23
EX 5.13Applying Quick Styles
EX 5.14Removing Duplicate Rows from Tables
EX 5.15Converting Tables to Ranges
EX 5.16Sorting Data
EX 5.17Filtering Data
EX 5.18Filtering Table Data with Slicers
EX 5.19Inserting Sparklines
EX 5.20 Analyzing Data with Goal Seek
EX 5.21 Analyzing Data with Data TablesCorrelation, t-Test
EX 5.22 Creating PivotTables using Recommended PivotTables
EX 5.23 Creating a PivotChart from a PivotTable
Assignment to turn in before next class: Build new PPT, 5 slides minimum – 10 slides max. Choose a new theme, use multiple fonts, font sizes, text boxes. Your choice of content – your dog, kids, cars, trees, flowers, etc.
Class #12 February 24 (Tuesday): Manning: Chap PP 3.1-3.21
PP 2.5Using Office Clipboard
Pp 2.14Adding Pictures, Aligning, Grouping, and Rotating Images
PP 3.1-2Changing the Presentation Theme, Color Theme, Theme Effects, Variants
PP 3.3Applying Slide Transitions
PP 3.4 Changing the Size of Slides
PP 3.5Changing the Slide Background
PP 3.6 ApplyingQuick Styles to Drawing Objects
PP 3.7 Fill colors to Drawing Objects
PP 3.8 Outlines to Drawing Objects
PP 3.9 Quick Styles to Tables
PP 3.10 Using the Picture Styles Gallery
PP 3.11 Applying pre-set Picture Effects
PP 3.12 Aligning Objects using Smart Guides
PP 3.13 Changing Size of Images
PP 3.14 Moving Objects using Smart Guides
PP 3.15 Using Gridlines and Ruler
PP 3.16 Adding Footers
PP 3.17 Adding Date to Footer
PP 3.18 Inserting Slide Numbers
PP 3.19 Applying Animation Effects
PP 3.20 Modifying Animations
PP 3.21 Using Animation Painter
Assignment: Build a new PPT with minimum 8 slides – 10 max. Included single placeholders, double placeholders, photos, clip art, bulletpoints, animation of transitions and sound. Email . To be presented live, in class, as your PPT project the final night of class.
Class #13 February26(Th) Manning: Chap PP 4.1-3.16
Reading: Manning, PP 2.9-2.15 before class
PP 4.1Deleting Slides from Presentations
PP 4.2Changing the Order of Slides
PP 4.3Hiding Slides
PP 4.4Copying and Pasting Slides
PP 4.5Adding Sections
PP 4.6Adding Hyperlinks to slides
PP 4.7Adding Notes
PP 4.9Rehearsing Timings
PP 4.10, 11,12Starting, Navigating, and Presenter Tools
PP 4.15, 16Customizing and Printing Handout Masters
Class #14 March 3 (Th):
PowerPoint Project to be presented tonight.
ASSESSMENT AND EXAMINATIONS:
Participation In-Class will be assessed for quality of preparation and application of course content to subject discussion.
Exam will consist of True/False, Multiple Choice, Essay, Proficiency Demonstration questions or may consist of proficiency demonstrations. They will be closed notes and closed book. Makeup exams will not be given for reasons other than illness (confirmed in writing by a physician).
Surveys, Evaluations, and Assessments are a student requirement as part of this class.
EVALUATION AND GRADES:Instructor retains the right to adjust the grading schedule
Attendance/Participation30%Assignments25%
Keeping pace with class25%Exams20%
Pass80% or betterStudent must achieve 80% or better to receive Certificate of Completion
Fail79.9%
NBStudent did not attain minimum benchmark
Emergency Information:
In case of medical emergency, or natural or other disaster, McCall College faculty are required to maintain their cell phones in an ‘on’ status. The City of McCall maintains a ‘911’ system for all FIRE – POLICE – AMBULANCE services and should be contacted in case of emergency. If outside of McCall’s city limits, emergency calls may be made to Valley County Sheriff’s Department (208) 382-7150. All building ingress and egress doorways shall remain unlocked during class hours.
College Outcomes:
You may notice that many of the various courses have similar sounding Goals (G): McCall College’s intention is to build whole persons through the wide range of courses it offers. Therefore, you will find these courses do not stand in a vacuum of their own learning, but strongly relate to all other courses in your series of classes, and to the world in which we live. It is our intended outcome that students will grow toward high levels of maturity: demonstrating ethical behavior, loving and respecting others, offering grace and compassion as they have received it, and building up the community that we all share. Rubric 4 of McCall College goals shall be achieved through CITPT 110.
Academic Excellence:
McCall College students will demonstrate a broad understanding and appreciation of the liberal arts, and develop expertise in a chosen field of study and profession. It is the college’s hope that students will develop a continual curiosity and hunger for knowledge in greater breadth and depth, achieving their greatest potential throughout lifelong learning.
Social Responsiveness:
McCall College students will be faithful stewards of their knowledge, skills, and resources, and be agents of social justice to all their community of practice. They will show compassion for people of all races, creeds, and cultures, and identify with and advocate for those in need—locally and globally.
Missed Classes.
You are allowed by departmental policy to miss a maximum of three hours (two class sessions) of this course. For this course there will be no penalty or makeup assignment for up to four hours missed. Students missing more than three hours will need to arrange a makeup assignment with the course instructor (note: this is the student’s responsibility). Failure to arrange and submit the additional assignment may result in partial or complete loss of funding if from an agency outside of McCall College (Dept of Labor, US Forest Service, etc).
Late Papers:
Punctuality is a virtue McCall College intends to support. Instructors may choose not to accept late assignments at all. Instructors, at their discretion may elect to accept papers, but subject grading to a 10% or 1 grade reduction. Papers more than 10 days late will not be accepted without prior arrangements from the instructor.
Reading Assignments:
Assigned reading for each week is posted on the Course Schedule
Reading should be completed before class so that you may participate fully in the discussion
Required: Required reading assignments are essential for full participation in classroomand are listed in the class session pages.
Initiative: you are encouraged to discover and share additional sources of pertinent input. Articles you may find in peer reviewed journals in the library databases may provide the most current thinking on many of the topics we will be discussing. These are meant to provide enrichment and may contain useful resources for your research papers. Optional articles are not listed on the Course Schedule.
Persistence: you are expected to find a way to work around seeming roadblocks to learning.
Resourcefulness: you are expected to creatively search for sources of information to support the learning and share with others. For academic honesty, remember to provide credit through full citation data.
Late Papers AND PROJECTS:
Punctuality is a virtue McCall College intends to support. Instructors may choose not to accept late assignments at all. Instructors may choose not to accept late assignments at all. Instructors, at their discretion may elect to accept late assignments, but subject grading to a 10% or 1 grade reduction. Papers more than 10 days late will not be accepted without prior arrangements from the instructor.
Class Attendance:
Attendance is required for this class. If an absence is unavoidable, phone notification or voice message is preferred, e-mail is acceptable but not preferred.
Participation: will be evaluated on your contribution to class discussions. We will frequently begin class with a discussion. Sometimes I will ask for volunteers and other times I will call on people randomly, you must be prepared for every class. Student participation will be expected to be of a proper business attitude. Let’s be gracious to one another. Instructor reserves the right to adjust grade for improper attitudes.
Copyright Statement:
McCall College, a non-profit educational institution, is entitled by law to use materials protected by the US Copyright Act for classroom education. Any use of those materials outside of the class may violate the law.
Statement on Academic Honesty from the Student Handbook:
Course submissions are assumed to be the student’s own work and newly developed for this course. Plagiarism is defined as representing the words or ideas of another as one’s own in any academic exercise. One who facilitates this activity is equally responsible with the primary violator. Penalties for plagiarism will be enforced according to the guidelines found in the Student Handbook at Collaboration assignments must reflect individual contribution.
Disability Services Information:
If you have specific physical, psychiatric, or learning disabilities and require accommodations, please contact the Student Services personnel as early as possible so that your learning needs may be appropriately met. You will need to provide current documentation of your disability to the Student Services Office. For more information, contact Dr. Moore at (208) 880-4799.
The Writing Center:
This section regarding the Writing Center is reserved for future use.
Page 1