PORTAL  | COMP1000  | COMP1003  | COMP1@@0 Test  | IT MINOR  | K12 OUTREACH 
Document Header

Notice: MyItLab

For COMP1000 & 1003, MyItLab assignments are worth 10% of your grade.

Excerpt from the syllabus.

Man with head on desk in shame
Bookmark and Share
Class Syllabus - Summer 2017

Personal Computer Applications Syllabus

Course Overview

This course is designed to provide the students with the knowledge, skills and experience required to utilize personal computers and Internet effectively. It is for future end-users of computers who will use computer technology to solve problems and to make decisions. Whereas the processing power and storage capacity of personal computers (PCs) have increased tremendously since their introduction in the mid-70s the PCs price has consistently decreased make them accessible to large and small companies or organizations as well as individual users. Currently, PCs are being used at all levels in progressive organizations, ranging from clerical workers to top-level executives. In addition, the use of computers is not restricted to any particular field; their use is beneficial to any area where decisions need to be made and problems need to be solved. There are international efforts made toward eliminating the so-called global digital divide, which is a term used to describe the great discrepancies in opportunity to access the Internet between developed and developing countries or even between different regions of developed countries. Four decades since the inception of the Internet and three decades since the inception of the World Wide Web, while the global digital divide is still a reality, slowly but surely the Internet and World Wide Web are becoming part of our daily life. Hence, it is crucial that learners gain knowledge of and experience with computer technology as it becomes an integral part of the work place and daily life.

Course Description

COMP 1000 is a two-credit course composed of 2 hours of instruction per week. In this course, students will learn how to use an IBM PC, its operating system, andseveral application packages. Each student will be required to complete a series of assignments on Windows 8, Internet and World Wide Web (WWW), Microsoft Word 2013 (word processor), Microsoft Excel 2013 (spreadsheet), and Microsoft Access 2013 (database management), Microsoft PowerPoint 2013 (developing PowerPoint professional presentations) and Microsoft SharePoint (developing and maintaining web pages and web sites). The application software will be made available to the learners by the Auburn University bookstore or the Distance Learning department. The COMP 1000 custom package is formed by: Exploring MS Office 2013 and Windows 8 by Robert Grauer et al., Exploring Microsoft SharePoint for Office 2013 by Daniela Marghitu plus the MyITLab, Prentice Hall Publishing Co. ISBN 1269862715.

Course Topics

The topics in this course provide a thorough knowledge of the skills on the following topics:

1. Microsoft Windows 8/8.1 and OneDrive- Explains the principles of the Windows 8 interface and its components; how to use the Start screen and how to configure it, Using Windows 8 Apps, Charms bar, the Desktop; how to use the Help and Support Center; the difference between Files and Folders; how to use File Explorer; and how to use OneDrive.

2. Introduction to Office 2013 - Get you acquainted with the Office 2013 fundamentals and common interface components among the different Microsoft Office 2013 software applications, as well as getting familiar with the universal tasks performed in Office 2013.

3. Microsoft Word 2013 - How to change font attributes through the font dialog box; copying formats using the format painter; formatting a paragraph such as: paragraph tabs, borders, lists and columns; inserting, formatting or editing tables; converting text to table; sorting and applying formulas to tables; an introduction to research paper basics such as using a writing style, creating a source, creating a bibliography, working with footnotes, creating a table of contents and an index; tracking changes to a document, inserting comments into a document; accepting and rejecting changes made to a document; online document collaboration.

4. Microsoft Excel 2013 - An introduction to spreadsheets; how to modify and format a worksheet; applying mathematics and formulas in Excel spreadsheets; using cell references and order of precedence; using semi-selection in formulas; applying a formula using Auto Fill; relative, absolute, and mixed cell references; using Excel’s built-in functions in a spreadsheet; how to create graphs and charts; formatting charts in Excel; converting Excel data into tables and enhancing Excel table appearance; applying sorting and filtering to tables in Excel; subtotaling data; grouping and ungrouping data; one- and two-variable data tables; financial functions in Excel; descriptive statistical functions.

5. Microsoft Access 2013 – An introduction to Microsoft Access 2013 and understanding database fundamentals; organizing information in a database and recognizing Access objects; exploring Access views; working with records; using save as, compact and repair, and backing up a database; sorting and filtering data in tables; importing data from Excel and Access into an Access database; establishing table relationships and testing referential integrity; multitable queries; creating and modifying forms and reports in Access 2013.

6. Microsoft PowerPoint 2013 - Gain proficiency in creating ; opening, and modifying an existing presentation in PowerPoint 2013; working with the Outline view; modifying a theme and the slide master; enhancing a presentation with shapes, SmartArt, WordArt; using pictures, video, and audio in a PowerPoint presentation; applying transitions and advanced animations; working with hyperlinks and action buttons in PowerPoint; Master basics including the Slide Master and Handout Master; creating and manipulating custom slide shows and hidden slides.

7. Microsoft SharePoint 2013 - An overview of creating and designing Web pages and Web sites using Microsoft SharePoint Online and Office 356; viewing and editing SharePoint Online settings; identifying SharePoint site categories; customizing a site by changing the title, logo, site navigation, theme, and regional settings; working with SharePoint Online Apps; uploading, organizing, and editing documents in SharePoint; customizing web pages with hyperlinks, lists, tables, and web parts; integrating SharePoint with Microsoft Office documents including Word, Excel, PowerPoint and Access.

Course Objectives

The objectives of this course are to:

1. Learn how to use the Windows 8 interface including the Start screen, Windows Apps, Charms bar, and App bars. Identify the objects and components of the Windows desktop and learn how to customize both the Start screen and the Desktop.
2. Learn how to use the File Explorer; explain how folders are used to organize the files on a disk; learn how to use OneDrive and save files to it.
3. Identify common interface components in Microsoft Office 2013 applications and how to use Office 2013 help.
4. Applying font attributes through the font dialog box; copying formats using the format painter; formatting a paragraph such as: paragraph tabs, borders, lists and columns;
5. Enhance a Word 2013 document with tables; insert, format, and edit tables; convert text to a table; sort and apply formulas to tables.
6. Apply research paper basics including writing styles, create a source, create a bibliography, work with footnotes, create a table of contents and an index.
7. Use document collaboration techniques; insert comments into a document; track changes to a document, insert comments into a document; accept and reject changes made to a document.
 
8. Describe the difference between a spreadsheet and a worksheet in Excel; identify Excel window components; enter and edit data in cells; display cell formulas; insert and delete rows and columns; manage and format worksheets; practice the use of copy, paste, paste special, and Auto Fill.
9. Apply mathematics and formulas in Excel spreadsheets; understand the order of precedence in formulas; use semi-selection in formulas; use relative, absolute, and mixed cell references; use Excel’s built-in functions.
10. Create and format charts in Excel; convert Excel data into tables; apply sorting and filtering to tables in Excel
11. Learn how to use one- and two-variable data tables; use financial functions in Excel as well as descriptive statistical functions.
12. Understand database fundamentals and recognize the different Access objects such as tables, queries, forms, and reports.
13. Organize information in an Access database and explore the different Access views; sort and filter data in tables; import data from Excel and Access into an Access database; establish table relationships and test referential integrity.
14. Create multitable queries; create and modify forms and reports in Access 2013.
15. Open and modify an existing PowerPoint presentation; enhance a presentation with shapes, SmartArt, WordArt; pictures, video, and audio.
16. Apply transitions and advanced animations to a PowerPoint presentation; work with hyperlinks and action buttons in PowerPoint; create and manipulate custom slide shows and hidden slides.
17. Use SharePoint online to create, modify and enhance Web pages and Web site integrated with Microsoft Office applications.
18. View and edit SharePoint Online settings; identify SharePoint site categories.
19. Customize a SharePoint site by changing the title, logo, site navigation, theme, and regional settings; upload, organize, and edit documents in SharePoint;
20. Integrate SharePoint with Microsoft Office documents including Word, Excel, PowerPoint and Access.

Course Requirements

1. Mandatory Training
The training is available at Prentice Hall MyITLab website. You are strongly advised to work on these training sessions in order to receive your grade. The website address is http://myitlab.com. A student access code is necessary to register for MyITLab online which will be provided in the textbook package.

2. Assignments
There are three types of homework assignments, MyITLab, Hands-on, and Practice Exercises. Hands-on, and Practice Exercises are available in the text book and submitted using Canvas. It is required that students read the assignment and take the required MyITLab skills based assignments before class. Unexcused Canvas late work from a week can be turned in by that week's Friday. Thereafter, the assignment will not be accepted and CAN NOT be turned in for a late penalty deduction.
  • The first few chapters covered on MyITLab will test students using exams in multiple choice format. Thereafter, all MyITLab exams will be in skill-based format. The skill-based training will include a pre-test, training, and post-test. Students will begin by taking the pre-test. If a student scores 60% or above on the pre-test, the student will be allowed to advance to the post-test without taking the training module. If a student scores below 60% that student will be required to take the training module, and will be required to earn 100% on the training module before advancing to the post-test. Therefore, students who receive below 60% on the pre-test will need to re-take the training module until they have earned 100%. Afterwards, the student will be allowed to take the post-test. The post-test grade is the final portion of the skill-based training, and the grade earned on the post-test will be the grade that is considered in the student's final MyITLab average.
  • MyITLab assignments may be submitted after the due date with a 10% late penalty applied. Students who wish to submit MyITLab assignments after the due date may do so until the last day of class with late penalty. After the last day of class, MyITLab assignments will no longer be accepted.
  • MyITLab is compatible only with Windows PC machines and Internet Explorer. MyITLab is compatible with MAC computers following the proper instructions which can be found on the myITlab tab, but NOT compatible with FireFox, Safari, Chrome, or Opera.
  • All COMP 1000 lab computers have been configured to run MyITLab, however if a student wishes to install MyITLab on his or her personal laptop, he or she must install the needed software in class on the first day of class. If not, the student will be required to use the COMP 1000 lab to complete MyITLab assignments. If a student wishes to use his or her personal laptop computer, it is the student's responsibility to ensure that the machine is in working condition and will allow assignments to be submitted by the due date. A students failure to get their personal computer working properly with myITlab will not be considered a valid reason for submitting work late.

3. Case Study 1 & 2
There are two case studies available and submitted in course website on Canvas. An Integrated Case Study with Microsoft Office 2013 and the other is a SharePoint Case Study. Each case study is worth 50 points. More information about the studies is available in the course website on Canvas.

4. Examination 1
There will be a proctored Examination 1 available on myITlab. The examination will cover the material from topics 1 - 4. This is designed to give an opportunity to review all that the students have learned until this point in time, and is skill-based. Completing your myITlab assignments will greatly help you in the exam.

5. Examination 2
There will be a proctored Examination 2 available on myITlab . The examination will cover the material from topics 5 - 6. This is designed to give an opportunity to review all that the students have learned until this point in time, and is skill-based. Completing your myITlab assignments will greatly help you in the exam.

6. Examination 3
There will be a proctored Examination 3 available on myITlab . The examination will cover the material from topics 7 - 9. This is designed to give an opportunity to review all that the students have learned until this point in time, and is skill-based. Completing your myITlab assignments will greatly help you in the exam.

7. Final Examination

There will be a proctored final examination at the end of the semester that will be available on myITlab . This final examination will cover the material from topics 1 - 9. The examination is designed to give an opportunity to review all that the students have learned from the beginning to this point in time. It is comprehensive and will last for 2 ½ hours. Completing your myITlab assignments will greatly help you in the exam.

Performance Evaluation

The students work in this course will be evaluated on the basis of the assignments, MyITLab skill modules and Examinations. Exams will be given as an open computer test composed by multiple choice questions requiring you to have a basic understanding of the software and hardware that you will be using. Exams will include material from the assigned readings in the text, the assigned exercises, and class lectures. You should expect to do well on the exams only if you read, study, understand the assigned reading in the text, and complete the assigned exercises. Detailed information about exams can be found on the Exams web page. The MyITLab skill modules will be made available online at the end of each course topic. You should expect to do well on these modules if you carefully study and understand the associated course topic. The final course average will be computed as follows.
Class Point Distribution
Topic Percentage Points
Text Book Assignments and Case Studies 30% 300
MyITLab Assignments 10% 100
Exam 1 10% 100
Exam 2 10% 100
Exam 3 10% 100
Final Exam 30% 300
Total Points 100% 1000
The final course grade will be determined by the final class average using the scale below, with the following constraint: to earn a passing grade in this course, a student must earn a passing grade for the assignment average (assignment includes all Lab assignments and the two Case Studies but NOT the MyITLab assignments). An assignment average below 60% will result in an F in the course.
Grade Scale
Percentage Minimal Score Grade
90% or above 895 A
80% - 89% 795 B
70% - 79% 695 C
60% - 69% 595 D
Less than 60% 0 F
Students are not allowed to redo quizzes and examinations. Therefore, they should check their work carefully with criteria statements before turning in assignments or examinations.
Exams are open book, closed computer.
60% Rule
Out of the 300 possible points for 'Textbook Assignments and Case Studies' a minimum of 180 points must be obtained or the student will automatically fail the course without consideration of the other grades. Students that do not complete 60% of their assigned course work will not be able to pass. MyITLab assignments DO NOT count toward the 180/300 points needed to satisfy the 60% rule.

Grading

IT IS YOUR RESPONSIBILITY TO MAKE SURE THAT YOUR HOMEWORK IS CORRECTLY UPLOADED TO CANVAS. If you fail to upload an assignment correctly it is up to each instructor to determine if they will allow you to correct this mistake.

It is also your responsibility to make sure you have submitted the correct assignment and in the correct format. After you submit an assignment please check and make sure it appears on Canvas and that the correct file has been submitted for that assignment. Additionally you have 7 days after your grade is posted to discuss that grade. After 7 days the grade is no longer up for discussion and will be final.
  • Canvas assignments are due on the date assigned in class. However if, the student is unable to complete the full assignment in class, he or she will have time till Friday 11 Pm of that week to submit the assignment on Canvas without a late penalty. After 11:00 p.m. on the date assigned the student will see "Late" next to the assignment, however this is only a reminder that the assignment still needs to be submitted soon No late penalty will be applied. After Friday 11 PM of that week, the assignment will close and the student will not be able to submit his or her work.
  • Please note that the last week of school is not the time to be asking if you can submit assignments or make up missed assignments. Unless you can provide the required valid University approved excuses you will not be allowed to make up any missed work. The quicker you take action the more of a chance you may have. It is at the discretion of the instructor as to whether or not they will allow you to submit assignments after their due date without a penatly. Just because you were able to submit one assignment late does not mean that you will be allowed to submit the next.
Assignment Makeup
When you miss class and have a valid university excuse you will have a two week grace period to make up late assignments without penalty when you return to class. After the two week grace period late assignments will not be accepted for points.
  • Students will have 7 days from the date listed on the make-up document to present this document to the instructor and make plans for submitting make-up work. After this time, the excuse will not be accepted.
Communication Channels
The ONLY official method of communication between Instructor and students is Tigermail. Any use of Canvas's or myITlab's build in mail system are not considered official lines of communication and anything sent using them will not be considered valid work/communication and is not subject to the rules and conditions set forth in this syllabus. Both mail systems are not actively monitored and messages that are found will be removed without consideration for their content since they are not binding communications between instructor and student.
Any email between Instructor and student using Tigermail will be considered official communication and will be subject to follow all guidelines set forth in this syllabus.
The Announcement section that displays after entering your section of myITlab is also considered an official form of communication and any information that is located there will be considered binding to the syllabus.
Attendance
Attendance is essential if a student is to understand and assimilate the material in this course. If a student must miss a class, he/she should make arrangements ahead of time to complete the assignment and turn it in on time. Since class time is so limited, assistance or lecture information for completing an assignment that was done/due in a previous class will not be provided during a subsequent class. Instructors post their slides for each day of class, students are responsible for keeping up with their work. The instructor is not required to send emails or remind students of assignment due dates beyond the inital introduction of the assignment/test itself.
Make-up Exams
Make-ups will only be given with a valid university excuse. This means a Doctors statement (not an In-Out slip) or other documentation must be provided. All make-ups will be given on one of the two designated Makeup Days. The student is responsible for informing the instructor prior to missing an exam no later than one week after the exam official date. Please remember that in order to take an exam after missing a make-up day, you will need to present 2 excuses (one for the day of the exam, and one for the make-up day).
Friday Help
In order to provide assistance with make-up assignments and in general for helping students in accomplishing as much as possible, we offer Friday Help sessions, on Fridays from 10:00 am to 3:00 pm. One of the COMP1000 instructors will be in COMP1000 lab to help the COMP1000 students. Please make use of this opportunity as it will be a great help to your understanding of the topics covered as well as provide more time for you to ask questions if you need it.
Students with Disabilities
Auburn University is committed to providing accommodations and services to students with documented disabilities. Any student with a qualified disability which requires accommodations should contact The Program for Students with Disabilities, 1244 Haley Center, Auburn University, AL 36849, 334-844-2096334-844-2096 PH, 334-844-2099334-844-2099 FAX. More information is available on their website at www.auburn.edu/disability. The office will fax or mail the required forms to students to apply for services. Students who have questions to participate in this course should contact the above office in advance to ensure proper accommodations.

Plagiarism and Academic Dishonesty
Plagiarism is the act of presenting directly or indirectly someone else’s work as your own. Plagiarism is a major type of academic dishonesty and will not be tolerated. Similarly cheating on tests in any way, falsifying bibliographies, fraudulent quotes, and similar practices are intolerable forms of academic dishonesty. The University’s policy for academic misconduct in the Student Code of Conduct will be followed for this course (Tiger Club, pp. 83 and 92). If any questions regarding its contents, please contact the instructor.