Artifact 2- Course Syllabus

BUS 6612 COMPUTER INFORMATION SYSTEMS

BUS 6613 ADVANCED COMPUTER INFORMATION SYSTEMS

COURSE Syllabus

Instructor:          Melissa Shubert Hines                   

Office:                 Lee County Career & Technical Center-Room 635

Email:                 missy.hines@leecountyschools.net

Phone:                276-346-1960

Fax:                    276-346-2831

Office Hours:   Monday-Friday Room 635 (4^th period: 11:25-12:00)

Textbooks and Supplies:   Microsoft Office 2007 Windows Vista Edition, Beskeen, Cram, Duffy, Friedrichsen, Reding; Thomson Course Technology 2008; ISBN-13:   978-1-4239-0559-2; ISBN-10:   1-4239-0559-8;

Microsoft Office 2007 Introductory Concepts and Techniques, Shelly Cashman Series: Thomson Course Technology 2208; ISBN-13:-1-4188-4327-X

Various class handouts and packets

2 Gb USB Flash Drive

Grading System:   

A = 100-95

B = 94-85

C = 84-75

D = 74-70

F = 69 below

Makeup Tests: Make-up tests will be given during exam period as indicated on the Course Calendar. Students may take no more than two make-up tests. A student missing more than two tests will be assigned zeroes for those missed tests.

Attendance:   Regular class attendance is required. Students who fail to submit three consecutive assignments by the due date and do not contact the instructor may be administratively withdrawn from the class. However, students who wish to withdraw from the class should not assume they will be administratively withdrawn for non-attendance. The ultimate responsibility for withdrawing from the class rests with the student.

Academic Integrity:   Academic work is evaluated on the assumption that the work presented is the student's own, unless designated otherwise. Anything less is unacceptable and is considered academically dishonest. Please refer to the Student Handbook for the definition of specific terms related to academic dishonesty.

Students with Disabilities:   Students may request academic accommodations for disabilities through the school guidance office. The school guidance office will evaluate the request and make recommendations for appropriate and reasonable accommodations, which the student will provide to the instructor. 

 All correspondence will be kept confidential.

Course syllabus subject to change at the discretion of the instructor.

Artifact 3- Goals and Objectives

BUS 6612- Computer Information Systems

BUS 6613- Computer Information Systems

Goals and Objectives

BROAD GOALS OF THE COURSE

• To help students understand how the computer can and does affect their daily lives
• To give students a broad-based understanding of information processing to help prepare them for further Information System courses or for jobs in which computer skills are needed
• To give students " hands-on" experience with major application and system software packages 

Understanding Essential Computer Concepts Objectives

• Investigate types of computers
• Examine computer systems
• Examine input devices and output devices
• Investigate data processing
• Understand memory and storage media
• Explore data communications
• Learn about networks
• Learn about security threats
• Understand system and application software

 WINDOWS 7 Objectives

Getting Started with Windows Vista

• Start Window Vista
• Use a pointing device
• Start a program
• Move and resize windows
• Use menus, toolbars, and keyboard shortcuts
• Use dialog boxes and scroll bars
• Use Windows Help and Support
• End a Windows Vista session

 Understanding File Management

• Manage folders and files
• Open the computer window
• Create and save documents
• Open the Documents folder
• Copy files
• Open, edit, and print files
• Move and rename files
• Search for files
• Delete and restore files

INTERNET Objectives

 Getting Started with Internet Explorer

• Understand Web browsers
• Explore the browser
• View and navigate Web pages
• Use tabbed browsing
• Save favorite Web pages
• Print a Web page
• Search for information
• Get Help and exit Internet Explorer

 Microsoft Office 2007Objectives

 Getting started with Microsoft Office 2007

• Understand the Office 2007 Suite
• Start and exit an Office program
• View the Office 2007 user interface
• Create and save a file
• Open a file and save it with a new name
• View and print your work
• Get Help and close a file

  Word 2007 Objectives

• Understand word processing software
• Explore the Word program window
• Start a document
• Save a document
• Select text
• Format text using the Mini toolbar
• Create a document using a template
• View and navigate a document

 Editing Documents

• Cut and paste text
• Copy and paste text
• Use the Office Clipboard
• Find and replace text
• Check spelling and grammar
• Research information
• Add hyperlinks
• Prepare a document for distribution

 Formatting Text and Paragraphs

• Format with fonts
• Copy formats using the Format Painter
• Change line and paragraph spacing
• Align paragraphs
• Work with tabs
• Work with indents
• Add bullets and numbering
• Add borders and shading
• Add footnotes and endnotes

Formatting Documents

• Set document margins
• Divide a document into sections
• Insert page breaks
• Format columns
• Insert page numbers
• Add headers and footers
• Edit headers and footers
• Insert a table
• Insert clip art

 EXCEL 2007 Objectives

 Getting Started with Excel 2007

• Understand spreadsheet software
• Tour the Excel 2007 window
• Understand formulas
• Enter labels and values and use AutoSum
• Edit cell entries
• Enter and edit a simple formula
• Switch worksheet views
• Choose print options

 Working with Formulas and Functions

• Create a complex formula
• Insert a function
• Type a function
• Copy and move cell entries
• Understand relative and absolute cell references
• Copy formulas with relative cell references
• Copy formulas with absolute cell references
• Round a value with a function

 Formatting a Worksheet

• Format values
• Change font and font size
• Change attributes and alignment
• Adjust column width
• Insert and delete rows and columns
• Apply colors, patterns, and borders
• Apply conditional formatting
• Name and move a sheet
• Check spelling

 Working with Charts

• Plan a chart
• Create a chart
• Move and resize a chart
• Change the chart design
• Change the chart layout
• Format a chart
• Annotate and draw on a chart
• Create a pie chart

 INTEGRATION Objectives

 Integrating Word and Excel

• Integrate data between Word and Excel
• Copy data and Excel to Word
• Copy a chart from Excel to Word
• Create linked objects
• Embed a Word file in Excel

 ACCESS 2007

Getting Started with Access 2007 Objectives

• Understand relational databases
• Open a database
• Enter data
• Edit data
• Create a database
• Create a table
• Create primary keys
• Relate two tables
• Print a datasheet

 Building and Using Queries

• Create a query
• Use Query Design View
• Modify queries
• Sort and find data
• Filter data
• Apply AND criteria
• Apply OR criteria
• Format a datasheet

 Using Forms

• Create a form
• Use Form Layout View
• Use Form Design View
• Add fields to a form
• Modify form controls
• Create calculations
• Modify tab order
• Insert an image

 Using Reports

• Preview a report
• Use the Report Wizard
• Use Report Design View
• Use report sections
• Add subtotals and counts
• Resize and align controls
• Format a report
• Change page layout

Integrating Word, Excel, and Access Objectives

• Integrate data among Word, Excel, and Access
• Import Excel worksheet into Access
• Copy a Word table to Access
• Link an Access table to Excel and Word
• Link and Access table to Word

 POWERPOINT 2007 Objectives

 Creating a Presentation in PowerPoint 2007

• Define presentation software
• Plan an effective presentation
• Examine the PowerPoint window
• Enter slide text
• Add new slide
• Apply a design theme
• Compare presentation views
• Print a PowerPoint presentation

 Modifying a Presentation

• Enter text in the Outline tab
• Format text
• Convert text to SmartArt
• Insert and modify shapes
• Edit and duplicate shapes
• Align and group objects
• Add slide headers and footers
• Check the spelling in a presentation

 Inserting Objects into a Presentation

• Insert text from Microsoft Word
• Insert clip art
• Insert and style a picture
• Insert a text box
• Insert a chart
• Enter and edit chart data
• Insert a table
• Insert and format WordArt

 Finishing a Presentation

• Understand masters
• Customize background style
• Use slide show commands
• Set slide show transitions and timings
• Set slide animation effects
• Inspect a presentation
• Evaluate a presentation
• Create a design template

OUTLOOK 2007 Objectives

Getting Started with E-Mail

• Communicate with e-mail
• Compile an e-mail address book
• Create and send a message
• Manage e-mail folders
• Receive and reply to a message
• Forward a message
• Send a message with an attachment
• Employ good e-mail practices

 Managing Information Using Outlook

• Start Outlook
• Organize e-mail
• Organize contacts
• Manage appointments
• Manage tasks
• Create notes
• Use the Journal