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 - Fall 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 the 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 the 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. Each student will be required to complete a series of assignments on Windows 10, Microsoft Word 2016 (word processor), Microsoft Excel 2016 (spreadsheet), and Microsoft Access 2016 (database management), Microsoft PowerPoint 2016 (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 2016 by Robert Grauer et al., Exploring Microsoft SharePoint for Office 2016 by Daniela Marghitu plus the MyITLab, Prentice Hall Publishing Co. ISBN 132377145X / 9781323771457.

Course Topics

This course provides a thorough knowledge on the following topics:

1. Microsoft Windows 10- Explains the principles of the Windows 10 interface and its components; Using Windows 10 Apps, the Desktop; how to use the Help and Support Center; the difference between Files and Folders; how to use File Explorer etc.

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

3. Microsoft Word 2016 - 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 2016 - 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 and inferential statistics; use macros, edit macros in VB editor, and create custom functions using Visual Basics for Applications (VBA)

5. Microsoft Access 2016 - An introduction to Microsoft Access 2016 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; multi-table queries; creating and modifying forms and reports; perform data validation in tables; and perform data analysis using advanced select queries in Access 2016

6. Microsoft PowerPoint 2016 - Gain proficiency in creating ; opening, and modifying an existing presentation in PowerPoint 2016; 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 2016 - 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, 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, Windows Apps, 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.
  3. Identify common interface components in Microsoft Office 2016 applications and how to use Office 2016 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. Enhance a Word 2016 document with tables; insert, format, and edit tables; convert text to a table; sort and apply formulas to tables.
  5. Apply research paper basics including writing styles, create a source, create a bibliography, work with footnotes, create a table of contents and an index.
  6. 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.
  7. Publish documents from the desktop; use decorative text and drawing tools.
  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. Learn to use and run basic macros; edit macros using Visual Basic Editor, use sub procedures and create custom functions.
  13. Understand database fundamentals and recognize the different Access objects such as tables, queries, forms, and reports.
  14. 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.
  15. Create multi-table queries; create and modify forms and reports in Access 2016.
  16. Open and modify an existing PowerPoint presentation; enhance a presentation with shapes, SmartArt, WordArt; pictures, video, and audio.
  17. 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.
  18. Use SharePoint online to create, modify and enhance Web pages and Web site integrated with Microsoft Office applications.
  19. View and edit SharePoint Online settings; identify SharePoint site categories.
  20. Customize a SharePoint site by changing the title, logo, site navigation, theme, and regional settings; upload, organize and edit documents in SharePoint.
  21. Integrate SharePoint with Microsoft Office documents including Word, Excel, PowerPoint and Access.

Course Requirements

1. 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 as they are assigned in class.

1.1 Canvas Assignments (Hands-on and Practice Exercises)

Canvas Assignments are due the same day till 11 PM CDT, however, they are just marked late after the ‘Due Date' and can be still turned in by the ‘Available Until Date' i.e. Friday, 11 PM CDT of the week they are assigned, without any late penalty.

Note: After the ‘Available Until date' (Friday, 11 PM CDT of the week they are assigned), Unexcused Canvas assignments CANNOT be turned in on Canvas. The instructor will accept excused assignments (if the student provides a valid University approved excuse for missing the deadline) until two weeks from the date mentioned on the excuse document, however, he/she may or may not accept Unexcused late assignments. This decision entirely depends on the instructor's discretion.

1.2 MyITLab Assignments

The training is available at the Pearson 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/.

Note: A student access code is necessary to register for MyITLab online which will be provided in the course textbook package.

The first few chapters covered on MyITLab will test students using quizzes in multiple choice format. Thereafter, all MyITLab chapters 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 100% 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 100% 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 do not receive the required score on the pre-test will need to re-take the training module until they have earned 100%. Afterward, the student will be allowed to take the post-test. The MyITLab assignments are due Sunday until 11 PM of the week they are assigned.

POINTS TO NOTE:

  1. Taking the Pre-test is mandatory. The grade in the pre-test will count towards your final MyITLab grade. Taking the Post-Test is optional, however, recommended because it is the best way to prepare for the exams. That's why the Pre-Test once taken, cannot be taken again. However, the Post-Test once taken, can be taken an unlimited number of times to prepare for the exam.
  2. MyITLab assignments may be submitted after the due date until the last day of class. However, if some assignment is not submitted by the due date, then it becomes late work and you have to contact your instructor to accept your late work. You cannot see your grades until the instructor accepts your late work and It is at the discretion of the instructor to accept or reject your late work. So, it is highly recommended that you finish your assignments every week and do not keep them pending for the last day of class. Please note that after the last class day, MyITLab assignments will not be accepted at all.
  3. MyITLab is compatible only with the Windows PC machines and most web browsers except Safari or Opera.
  4. All COMP 1000 lab computers have been configured to run MyITLab, however, if a student wishes to access MyITLab on his or her personal windows laptop, he or she must use the most recent versions of the required software (Browser and Windows). It is the student's responsibility and not the instructor's or the COMP 1000 team's responsibility to ensure that the student's personal machine allows him to work on the MyITLab assignments, to be submitted by the due date. If not, the student will be required to use the COMP 1000 lab to complete MyITLab assignments. A student's failure to get their personal computer working properly with MyITLab will not be considered a valid reason for submitting work late.

2. Case Study 1 & 2

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

3. Examination 1

There will be a proctored Examination 1 available on MyITLab. The examination will cover the material from topics 1 - 3. This is designed to give an opportunity to review all that the students have learned until this point in time and is skill-based. Again, completing your MyITLab assignments especially the Post-Tests will greatly help you in the exam. Once taken, they can be taken any number of times to prepare for the exam.

4. Examination 2

There will be a proctored Examination 2 available on MyITLab. The examination will cover the material from topics 4 - 5. 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 especially the Post-Tests will greatly help you in the exam. Once taken, they can be taken any number of times to prepare for the exam.

5. Examination 3

There will be a proctored Examination 3 available on MyITLab. The examination will cover the material from topic 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 especially the Post-Tests will greatly help you in the exam. Once taken, they can be taken any number of times to prepare for the exam.

6. 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 - 7. 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 especially the Post-Tests will greatly help you in the exam. Once taken, they can be taken any number of times to prepare for 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 of 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 (60% Rule): to earn a passing grade in this course, a student must earn a passing grade for the Canvas assignment average (Canvas 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

POINTS TO NOTE:

  1. Students are not allowed to redo Canvas Assignments and examinations. Therefore, they should check their work carefully with criteria statements before turning in assignments or examinations. Exams are open book, closed computer.
  2. 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

Canvas assignments are due on the day they are assigned in class (Due Date). However, if the student is unable to complete the full assignment in class, he or she will have time until Friday 11 PM CST (Available Until Date) 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/her work on Canvas.

POINTS TO NOTE:

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

2.     IT IS YOUR RESPONSIBILITY TO MAKE SURE THAT 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.

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

4. The last week of school is not the time to be asking for accepting Unexcused Late assignments or makeup 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 penalty. 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 makeup document to present this document to the instructor and make plans for submitting makeup 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 email 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 on Canvas 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. 

NOTE: The instructor is not required to send emails or remind students of assignment due dates beyond the initial 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-2096 PH, 334-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.

NOTE: 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, submitting someone else's work as your own work 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.