INF 103 syl f12 by i1zIK7


									                                COURSE MAP/SYLLABUS

COURSE TITLE & NUMBER:                   INF 103: Computer Literacy

DATE: Fall, 2012                This course uses


INSTRUCTOR: Diane Cornilsen

OFFICE & PHONE NUMBER: Office, C5540                     Phone: 242-4023, Ext. 7749

OFFICE HOURS:           As posted on office door


Ashford University Mission:

The mission of Ashford University is to provide accessible, affordable, innovative,
high-quality learning opportunities and degree programs that meet the diverse
needs of individuals pursuing integrity in their lives, professions, and communities.

Course Description:

Required Course Materials:
   Text: New Perspectives on MS Office 2010, First Course, Cengage Publishing
   SAM 2010
   Data files—download from website or instructor workstation
   Software: Microsoft Office 2010, Google Account, Wikispaces account, SAM account
   USB Flash, storage device

Course Design:
Class time will be used for demonstration, discussions, questions, student presentations, quizzes,
tests and review. Lab time will be used to gain competency in the use of computers and for
testing through casework to verify that competency. Completion of tests scheduled in the lab is
required. Tests may cover several chapters or only one chapter

Classroom Courtesy
     Turn off computer monitor and fingers off the keyboard when instructor
       presents or others present

    No cell phone usage in class – turn it off
    No email, instant messaging, etc. – turn it off
    Extend courtesy (be polite) to faculty and to classmates at all times

Course Outcomes/Objectives:
   A. Understand essential computer concepts, hardware, software ,and Internet basics
      --Explore the basics of MS Windows 7
      --Organize files and folders
      --Define essential computer concepts and components of computer systems
   Assessment: Written Vocabulary Test, PC Project Poster, Creative Writing Exercise

   B. Use a Computer to Create Text Documents
      --Identify Purpose, Audience, Use appropriate Layout, Language and Content
      --Edit and format a document
      --Format Tables/Columns
      --Execute Grammar Check, Spell Check, Thesaurus
      --Integrate Object Linking and Embedding
   Assessment: Written Vocabulary Test, Chapter Tutorials, Performance Cases

   C. Use a Computer to Create Spreadsheets
      --Identify Purpose, Choose Layout, Identify Desired Results (Output)
      --Create Formulas or Functions to solve problems
      --Use what-if analysis via relative and absolute cell addressing (what-if analysis)
      --Apply Cell, and Page Formatting
      --Create Charts to depict content of worksheets
   Assessment: Written Vocabulary Test, Chapter Tutorials, Performance Cases

   D. Use a Computer to Create Visual Presentations
      --Identify purpose and audience
      --Use appropriate language and content
      --Organize content so that slides are presented logically
      --Integrate object linking and embedding
      --Critically review the presentation to ensure visual and oral presentation is in sync
   Assessment: Chapter Tutorials, Slide Show Presentations

These objectives are in concurrence with the National Business Education guidelines
and the Ashford University catalog course description.

     Chapter Tutorials                                                   5 pts. Each
     Written Tests                                                      25 pts. Each
     Performance Tests at PC                   Points vary (range is 10-25 pts each)
     Technology Creative Writing Exercise                               10 Points
     Computer Literacy Project Poster and Presentation                   25 Points
     PowerPoint Presentations (3)               10-30 Points each; Rubric Provided

General Education Outcomes:
   Graduates of Ashford University –
1. Discuss computer hardware, software, and essential computer concepts
2. Research ethical implications of computer use and technology’s impact on society

3. Use operating software to maintain files and maximize computer processing ability via
   system tools
4. Use productivity software to create documents, spreadsheets, and visual presentations
5. Use the library and computer resources to research current computer topics

Institutional Outcomes:

   Graduates of Ashford University –

   1. Demonstrate the ability to read and think critically and creatively
   2. Demonstrate the ability to communicate effectively in speech and in writing
   3. Demonstrate the ability to communicate effectively through the use of
   4. Demonstrate an understanding of the various forms of diversity
   5. Demonstrate an understanding of the interdependence among living beings,
      the environment and humanly-created system
   6. Demonstrate competence in their major fields of study
   7. Demonstrate an understanding of service directed at meeting the needs of
   8. Demonstrate the ability to draw information from different fields of study to
      make informed decisions
   9. Develop skills and abilities that provide for lifelong learning.

Attendance Policy:
The attendance policy at Ashford University is based on the commitment of the faculty
and administration to helping students develop the work habits and skills that are
essential for achieving academic success. Students are required to attend the classes and
labs for courses in which they are enrolled.

All students are expected to arrive on time for each class and to remain for the entire
class unless prior arrangements have been made with the instructor. If a student is
excused from class due to a University-sponsored activity, that student is expected to
arrange with the instructor for all class work and assignments to be made up before the
event. Students on academic and financial aid warning or probation must receive prior
approval for missing class for a University sponsored event from the course instructor
and the Dean of the College. If a student must miss a class due to an emergency over
which he or she has no control, the student must contact the instructor to determine what
preparation is needed before returning to the next class.

Faculty members are required to report absences from their classes, on a weekly basis, to
the Registrar’s Office. Federal regulations require that the University establish a last date
of attendance for any student who ceases attending the University and return financial aid
funds according to federal guidelines and University policy. Students who do not attend
any classes for two consecutive weeks will be administratively withdrawn from the
program by the Registrar’s Office. The student’s grades for the semester will be
determined according to the Course Drop policy guidelines outlined in the General
Academic Information and Policies section of this Catalog.

Late or Missing Assignments
    There will be NO makeup of in class written quizzes, pop quizzes, or
     performance activities unless there is a medical emergency

    If you cannot attend class, that does not excuse the submission of chapter
     assignments which must be submitted to the classroom Web CRC drop box

    A student's absence from the final examination without a serious reason AND
     permission of the instructor is recorded as a F in the course

Components of Course Evaluation:
   Written Tests (Concepts/Internet, Word, Excel), Chapter Tutorials, Performance Tests
      Technology Creative Writing Exercise, Computer Literacy Project Poster
      PowerPoint slide shows

Academic Integrity:
The academic community of the University believes that one of the goals of an institution
of higher learning is to strengthen academic integrity and responsibility among its
members. To this end the University throughout its history has emphasized the importance
of sound judgment and a personal sense of responsibility in each student. All members of
the academic community are expected to abide by the highest standards of academic

Academic dishonesty is a serious offense at the University because it undermines the
bonds of trust and personal responsibility between and among students and faculty,
weakens the credibility of the academic enterprise, and defrauds those who believe in the
value and integrity of the degree. Academic dishonesty may take several forms:

Cheating: Intentionally using or attempting to use unauthorized materials, information,
or study aids in any academic exercise (test, essay, etc.).
Fabrication: Intentional and unauthorized falsification or invention of any information or
citation in an academic exercise.
Facilitating academic dishonesty: Intentionally or knowingly helping or attempting to
help another student commit a breach of academic integrity.
Plagiarism: Representing the words or ideas of another as one’s own in any academic
A student who commits an act of academic dishonesty may face disciplinary action
ranging from failure to receive credit on an academic exercise to dismissal from the
University. Procedures for implementing this policy are listed in the student and faculty

Flavian Center
Make-up Testing Procedure/Policy. In the event make-up tests are allowed in this course,
the instructor may elect to send a missed quiz/test to the Flavian Center. It is the student’s
responsibility to make an appointment with a Flavian staff member to take the exam prior
to the deadline imposed by the instructor. All make-up tests will be scheduled, minimally
one business day in advance. A time-slot may be obtained by contacting the Flavian

Center, or by personally scheduling in the Flavian Center .
Scheduling is mandatory. Early scheduling can help to reserve a desirable time slot. The
Flavian closes for lunch each day from noon to 1:00 p.m. Overlapping with this time slot
will not be accommodated.

Disability Accommodation Requests
Students seeking accommodation should contact the Office of Student Access and
Wellness at or visit room L1134. Dedicated to fostering
equal opportunities to student success through accessible educational programs, disability
related advocacy, faculty and staff education, and an enhanced awareness of individual
abilities and contributions, this office supports students who have disclosed a disability
and requested accommodation in accordance with University requirements.

                                Tentative Schedule of Classes

The following is a TENTATIVE course schedule. The instructor reserves the right
to change the schedule as needed.
     Week    Topic                           Material
     1 &2    Understanding Essential          Define computers
             Computer Concepts                Investigate types of computers
                                              Examine input devices
             Windows 7,                       Examine output devices
             Getting started and              Investigate Data Processing
             Understanding File               Understand memory
                                              Understand magnetic storage devices and
             Management                         media
                                              Understand optical and flash storage
                                                devices and media
                                              Explore data communications
                                              Learn about networks
                                              Know system software
                                              Know productivity software
             Getting Started with Internet    Know Web Browsers
             Explorer, Firefox                Viewing and Navigating Web pages
                                              Searching for Information
     3       Word 2010                        Create a document
             Tutorial 1 and 2                 Edit, format a document
                                              Print a Document
                                              Use Help System
                                              Close a Document and Exit Word
     4       Tutorial 2: Editing Documents    Open a Document
                                              Select/cut/copy/paste Text
                                              Find and Replace Text
                                              Check Spelling and Grammar
                                              Use the Thesaurus
                                              Use Wizards and Templates
             Tutorial 3: Multi-page           Format with Fonts
             documents                        Change Font Styles and Effects

                                        Change Line and Paragraph Spacing
                                        Align Paragraphs
                                        Work with Indents
                                        Add bullets and Numbering
                                        Add Borders and Shading
5   Tutorial 4: Desktop                 Set Document Margins
    publishing, mail merge,             Divide a Document into Sections
    newsletter, blog, cover letter      Insert Page Breaks, page numbers
                                        Add and Edit Headers and Footers
                                        Formatting Columns
                                        Insert a Table, WordArt, ClipArt, Photos
    Excel 2010                          Define Spreadsheet Software
    Tutorial 1                          View and open Excel Window
                                        Save a Workbook
                                        Enter Labels and Values
                                        Name and Move a Sheet
                                        Preview and Print a Worksheet
                                        Use Help
6   Tutorial 2: Formatting a            Plan and Design a Worksheet
    workbook                            Edit Cell Entries
                                        Create Complex Formulas
                                        Introduce Excel Functions
                                        Use Excel Functions
                                        Copy and Move Cell Entries
                                        Understand Relative and Absolute Cell
                                        Copy Formulas with Relative Cell
                                        Copy Formulas with Absolute Cell
    Tutorial 3: Working with            Format Values
    formulas and functions              Use Fonts and Font Sizes
                                        Change Attributes and Alignment
                                        Adjust Column Widths
                                        Insert and Delete Rows and Columns
                                        Apply Colors, Patterns, and Borders
                                        Use Conditional Formatting
                                        Check Spelling
7   Tutorial 4: Working with            Plan and Design a Chart
    Charts and graphics                 Create, edit, move and resize chart
                                        Format and enhance a Chart
                                        Annotate and Draw on a Chart
                                        Preview and Print a Chart
8   Integration                         Understand Integration
    Integrating Word and Excel          Project 1: Survey Report for Caribou Guest
                                        Create the Charts in Excel
                                        Create the Reports in Word
                                        Link the Charts with the Report
                                        Project 2: Online Price List for Le Bonbon

                                    Create the Price List in Excel
                                    Insert the Price List into Word
12   PowerPoint 2010                Define Presentation Software
     Tutorial 1                     View PowerPoint Window
                                    Use the AutoContent Wizard
                                    View and save a Presentation
                                    Get Help and Research Information
                                     1. Print and Close, exit PowerPoint
     Tutorial 2: Create a           Plan an Effective Presentation
     Presentation                   Enter Slide Text
                                    Create a New Slide
                                    Enter Text in the Outline Tab
                                    Add Slide Headers and Footers
                                    Choose a Look for a Presentation
                                    Check Spelling in a Presentation
                                    Evaluate Presentation
13   Appendix B
     Presentation 2
14   Work on Presentation 3
15   Final Slide Show and Peer   Final


To top