MICROCOMPUTER APPLICATIONS III CIT 4603

COURSE SYLLABUS

COURSE DESCRIPTION

Course three of the study of the role of a software suite as a tool used in business. The applications covered will include: Word Processing, Spreadsheet, Database, and electronic presentations. Prerequisite: CIT 3503 and CIT 3533, or demonstrated proficiency.

REQUIRED TEXT

Microsoft ® Office 2010 Post Advanced by Shelly and Vermaat [ISBN : 978-143-907-8990]. Student data is online – see inside back cover for instructions on how to download.

OTHER MATERIALS

It is recommended to have a USB key drive (Jump Drive). Also, you have web access to your “My Documents” folder within your student roaming profile. Browse to http://mydocs.astate.edu to access this resource. Your regular student ID and password is to be used on this web site. (The same as your Astate email)

INSTRUCTOR: Dr. Ralph Ruby, Jr.

EMAIL:

OFFICE HOURS: At your convenience, Room 419C

870.680.8022 [Office]

870.819.1770 [Mobile]

OBJECTIVES

The major objectives of this course are:

·  To offer a comprehensive presentation of Microsoft Office Word 2010, Microsoft Office Excel 2010, Microsoft Office Access 2010, Microsoft Office PowerPoint 2010.

·  To expose students to practical examples of the computer as a useful tool.

·  To acquaint students with the proper procedures to create and enhance documents, worksheets, databases, and presentations suitable for coursework, professional purposes, and personal use.

·  To help students discover the underlying functionality of Office 2010 so they can become more productive.

·  To develop an exercise-oriented approach that allows learning by doing.

PREREQUISITE(S)

Ability to keyboard.

TEACHING METHOD

Description of method of delivery:

For this course I will use eight major teaching and learning strategies. These strategies will include presentation, demonstration, lecture, discussion, question and answer, projects, directed discovery and observation [See handouts describing directed discovery and observation methods].

COURSE COMPLETION REQUIREMENTS

·  Attend each class session.

·  Read the assigned chapters before coming to class.

·  Complete and hand in assignments. When an assignment is complete, proofread it carefully before turning it in. Assignments should be clearly marked with your name, the lesson number and exercise name. Assignments are due the day of the chapter’s written evaluation.

·  Complete all document development projects as required.

COMPUTER TIME

Approximately six to eight hours per week of computer time outside of class is recommended to complete assignments.

DOCUMENTATION DEVELOPMENT PROJECTS

Class participants, wishing to earn a grade of A [optional for all other letter grades], will be required to report [in written format] on two topics of their choice dealing with the present status and requirements of office computer facilities, innovations and/or word processing software. Each report should be no longer than 10 pages and no shorter than 5 pages.

DUE DATE

To be handed in at least one week prior to official mid-term week.

STUDENT EVALUATIONS

Minimum score required for an A grade = 90

Minimum score required for an B grade = 80

Minimum score required for an C grade = 70

Minimum score required for an D grade = 60

Component / Percentage
Class Participation / 10
Student Portfolio [Class Assignments] / -, 0, +
Document Development Project(s) / 10
Advancement Opportunities [Tests]
[Word 2010, Excel 2010, Access 2010,
PowerPoint 2010 and FINAL opportunity] / 75
Ethical Behavior / 5

You may receive a maximum of minus 1-point, no points, or add 1-point to your final average for each one of three student portfolios turned into the professor. The point(s) are determined by the professor and are based on handouts provided and the professional presentation of the student portfolio.

ETHICAL BEHAVIOR

Ethical behavior means communicating honestly and politely with fellow students and with the professor; it means planning and writing your own projects, and it means relying solely on your own memory to answer test questions. Ethical behavior means obeying the law. Students who engage in unethical behavior connected with this class will receive an F grade for the course and may be referred to other appropriate authorities.

DISABILITY STUDENTS

If you have a learning disability or physical disability that may affect your performance in the classroom, see the Disabilities Center on campus and bring the appropriate paper work to me for appropriate assistance.

STUDENT PORTFOLIO

Your student portfolio will consist of hard copies for the following projects:

Word 2010 Chapter 8 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1and 2
Cases and Places – 1
Word 2010 Chapter 9 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
Word 2003 Chapter 10 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
Word 2003 Chapter 11 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
ADVANCEMENT OPPORTUNITY - I
Excel 2010 Chapter 8 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
Excel 2010 Chapter 9 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1 and 2
Excel 2010 Chapter 10 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
Excel 2010 Chapter 11 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
ADVANCEMENT OPPORTUNITY - II
Access 2010 Chapter 8 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
Access 2010 Chapter 9 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
Access 2010 Chapter 10 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
Access 2010 Chapter 11 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
ADVANCEMENT OPPORTUNITY -- III
PowerPoint 2010 Chapter 8 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
PowerPoint 2010 Chapter 9 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
PowerPoint 2010 Chapter 10 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
PowerPoint 2010 Chapter 11 / Learn It Online – Flash Cards and Crossword Puzzle Challenge
In the Lab – 1 and 2
Cases and Places – 1
ADVANCEMENT OPPORTUNITY -- IV

FINAL EXAMINATION

Check schedule online [as determined by the University]

ASSOCIATION OF INFORMATION TECHNOLOGY PROFESSIONALS

A.I.T.P. is the professional association comprised of career minded individuals who seek to expand their potential - employers, employees, managers, programmers, and many others. The organization seeks to provide avenues for all their members in the IS field, all in an effort to become more marketable in rapidly changing, technological careers. It is the mission of A.I.T.P. to provide superior leadership and education in Information Technology. A.I.T.P. is dedicated to using the synergy of Information Technology partnerships to provide education and benefits to our members and to working with the industry to assist in the overall promotion and direction of Information Technology. For Membership Information, please contact Dr. Paula Ruby, Office 414, OR Dr. Ralph Ruby, Jr., Office 419C,