Print or save this document if you would like a copy: ==>  Download Syllabus CPT 1324.docx

 

SYLLABUS

Microsoft Office 2013 – Illustrated Fundamentals

Instructor: Mrs. Betty Bolden

Office:  Bivins Hall, Room 104-F or 106

Phone:  601-856-9771

E-mail: Betty.Bolden@hindscc.edu

Website: http://www.hindscc.edu

 

Course Description:

As a student in this course, you will learn the most important topics of Microsoft Office 2013. No prior computer experience is assumed. You will first be presented with an overview of Microsoft Office 2013 and Windows 8, followed by an introduction to Microsoft Excel, Access, Word, and PowerPoint.   You will learn to use Office to work with formulas, charts and graphics, and to develop a professional worksheet.  You will then learn to work with Office lists, and multiple worksheets and workbooks.  You will learn to use Office’s editing and Web tools, and learn to develop Office applications.  You will work with logical functions and finally, how to integrate the various Office applications.

 

Text/Materials:

Text: Hunt/Clemens, Microsoft Office 2013 – Illustrated Fundamentals (978-1-285-42755-3)

Software: Instructor will provide information on how to use these packages.

Handouts: Additional handouts may be required. Instructor will provide information on obtaining this material.

 

Teaching Methods:

Lectures: Important material from the text and outside sources will be covered in class. Students should plan to take careful notes as not all material can be found in the texts or readings. Discussion is encouraged as is student-procured outside material relevant to topics being covered.

Assignments: End of chapter and online activities will be assigned weekly to reinforce material in the text. These assignments may require the application of various software packages.

Quizzes: Occasional unannounced quizzes will be given to help ensure students stay up with assigned material.

Exams: Four exams will be given. The exams will be closed book/notes and will test assigned readings and material discussed in class. Review sheets will be provided prior to the exam day. The final exam will not be comprehensive in nature. However, the instructor reserves the right to retest on material that was not appropriately comprehended. These items will be noted on exam review sheets.

Participation: Student participation will be graded by the level of class participation and attendance. 

 

Grading:

Total points will be computed as follows. The total points for quizzes, cases, and assignments may vary.

Exam #1: 100

Exam #2: 100

Exam #3: 100

Exam #4: 100

Assignments: 10 points each

Participation: 50

Total: 600 Points

 

Point System: 600 total assigned points

A             >= 500

B             >= 450

C             >= 400

D             >= 350

 

 

Course Policies:

Missed Classes: The student is responsible for obtaining material distributed on class days when he/she was absent. This can be done through contacting a classmate who was present or by contacting the instructor during his office hours or other times. Missed or late quizzes can not be made up under any circumstances but with good cause and adequate notice, an early quiz may be given. One quiz (lowest score) will be dropped at the end of the semester.

 

Assignments: All assignments are due at the beginning of class on the date due. Late submission of assignments will be assessed a penalty of 10% per day. No exceptions are made.

 

Academic Dishonesty: Plagiarism and cheating are serious offenses and may be punished by failure on exam, paper or project; failure in course; and or expulsion from the University. For more information refer to the "Academic Dishonesty" policy in the University Undergraduate Catalog.  For this class, it is permissible to assist classmates in general discussions of computing techniques. General advice and interaction are encouraged. Each person, however, must develop his or her own solutions to the assigned projects, assignments, and tasks. In other words, students may not "work together" on graded assignments.

 

Need for Assistance: If you have any condition, such as a physical or learning disability, which will make it difficult for you to carry out the work as I have outlined it, or which will require academic accommodations, please notify me as soon as possible.

 

Internet Support: Check the class Web page for additional information about Office 2003, or to post a question about this course.

 

Posting of Grades: Final grades will not be posted. If you wish to have your final grade sent to you, please bring a self-addressed, stamped envelope to the final exam.

 

Incomplete Policy: Students will not be given an incomplete grade in the course without sound reason and documented evidence as described in the Student Handbook. In any case, for a student to receive an incomplete, he or she must be passing and must have completed a significant portion of the course.

Course Outline

 

Week	Topic	Assignment
1	Introduction to Course	none
	Unit A: Getting Started with Windows 8	Concepts Review; 2 Independent Challenges
2	Unit B: Understanding File Management	Skills Review; Real Life Independent Challenge
	Unit C: Getting Started with Microsoft Office 2013 (1st half)
3	Unit C: Getting Started with Microsoft Office 2013 (2nd half)	Visual Workshop
	Unit D: Creating a Document (1st half)	Skills Review; Real Life Independent Challenge
4	Unit D: Creating a Document (2nd half)	Visual Workshop
	Exam #1	none
5	Unit E: Enhancing a Document	Concepts Review; 2 Independent Challenges
	Unit F: Adding Special Elements to a Document (1st half)	Skills Review; Real Life Independent Challenge
6	Unit F: Adding Special Elements to a Document (2nd half)	Visual Workshop
	Unit G: Creating and Enhancing a Worksheet (1st half)	Concepts Review; 2 Independent Challenges
7	Unit G: Creating and Enhancing a Worksheet (2nd half)	Skills Review; Real Life Independent Challenge
	Unit H: Using Complex Formulas, Functions, and Tables	Visual Workshop
8	Unit I: Working with Charts	Concepts Review; 2 Independent Challenges
	Exam #2	none
9	Unit J: Creating a Database (1st half)	Visual Workshop
	Unit J: Creating a Database (2nd half)	Concepts Review; 2 Independent Challenges
10	Unit K: Working with Data (1st half)	Skills Review; Real Life Independent Challenge
	Unit K: Working with Data (2nd half)	Visual Workshop
11	Unit L: Creating Database Reports	Concepts Review; 2 Independent Challenges
	Unit M: Creating a Presentation (1st half)	Skills Review; Real Life Independent Challenge
12	Unit M: Creating a Presentation (2nd half)	Visual Workshop
	Exam #3	none
13	Unit N: Polishing and Running a Presentation	Concepts Review; 2 Independent Challenges
	Unit O: Integrating Office Programs	Skills Review; Real Life Independent Challenge
14	Review	None
	Final Exam	none

 

Assignment Descriptions:

Concepts Review – Includes screen identification, multiple choice, and matching questions.

 

Skills Review – Provides additional hands-on exercises that mirrors the progressive style of the lesson material.

 

Independent Challenges 1, 2 and 3 – Case projects that require critical thinking and application of the unit skills. The Independent Challenges increase in difficulty, with the first being the easiest (with the most step-by-step detailed instructions). Independent Challenges 2 and 3 become increasingly more open-ended

 

Real Life Independent Challenge – Using a real world focus to apply the unit skills, students create documents that will benefit their everyday lives

 

Advanced Challenge Exercises – Optional steps that are set within 2 of the 4 Independent Challenges for each unit. They are designed to challenge more advanced students. 2 solution files are provided for easy grading.

 

Visual Workshop – a practical, self-graded capstone project that requires independent problem solving.