emerging pc software cins116 wc1faculty.ccbcmd.edu/~vfarmer/syllabi.pdf · office 2007 office 2007...

8/18/2010 Syllabus – CINS116WC1 of 5

Emerging PC Software – CINS116 WC1

Final Version

Basic Course Information Campus Catonsville

Semester/Term Fall 2010

Pre‐requisites ENGL051 and RDNG051

Instructor Valerie Farmer Assistant Professor IT

Office H218 G

Contact Information Phone: 443.840.4754 E‐mail: [email protected]

Important Websites CCBC’s: www.ccbcmd.edu Instructor’s: http://student.ccbcmd.edu/~vfarmer

Do Course Orientation Assignment by midnight 11:59 pm September 1, 2010 Assignment is located on the Main Page of the Course

Course Goals Course Objectives: Upon completion of this course the student will be able to:

Objective Modules

1. utilize application software to improve time management, and the planning and organization of personal, professional and academic activities;

All Modules

2. evaluate the appropriate software and technical skills to solve every day problems; All Modules

3. research and learn new technology skills independently; All Modules

4. utilize operating system and file management basics as they relate to application software;

All Modules

5. utilize Internet technologies as they relate to application software; 1,2,3,4, 6

6. assess computer security risks as they relate to application software; 2

7. transition into the latest version of Productivity Suite software; 5

8. create desktop publishing documents; 9,10

9. investigate and utilize the latest Web Technologies; 1,2,3,4, 6

10. extract, evaluate and ethically use information from a variety of online sources using emerging search techniques;

1,3,4,6

11. analyze the latest Operating System; utilizing the new features effectively; 2

12. use multimedia software for personal enrichment; 6

13. create, organize and share personal, academic, and professional notes and information from a variety of sources;

1,3,11,12,13

14. create a blog and/or personal website; 4,7

15. create and maintain a Mind Map to plan and diagram a process or project; 11

16. create, manipulate, view, comment, and navigate a Portable Document File (PDF); 1, 12,13

17. utilize global or multi‐language features of application software taught in the course; 5

18. utilize various software features to relay ideas and information visually; and, 7,8,10,11,12

19. create an E‐Portfolio that includes course projects and other employment documents. 12, 13

8/

M

V

V

V

C ToapviInIncoinedte

C

/18/2010

Major Topi

I. Emergin

II. Producti

III. Desktop

IV. Diagram

V. Using M

VI. Creating

VII. Using Ad

III. Utilizing

IX. Utilizing

X. Mobile D

XI. Creating

Course Rat

oday's graduapplication sofisual and desinformation Mnternet technollaborate witndividuals to iducation, emechnologies im

Course Pe

All Graded

Learning • Video C• Software• Researc• Discuss• Tegrity • Learning• SAM: T(TAP)

ics:

g PC and Int

ivity Software

Publishing so

ming, plannin

ultimedia sof

g a blog and/o

dobe Reader a

templates, w

the multi‐lan

Devices

g an E‐Portfoli

tionale:

ates would beftware as a prigned to prom

Managers allowologies like Wth others to pincrease prodployment andmmediately, t

edagogy:

d Assessment

Resources:CDe ExplorationchsionVideo Tutorialsg LabsTraining, Assessme

Syl

ternet Techno

e Suites (inclu

oftware

ng and brains

ftware for per

or personal w

and creating

wizards, add‐i

nguage featur

io

enefit from a roductivity anmote active aw students toWeb 2.0 allowproduce syneductivity, prodd personal enthey prefer to

:

ts need to be

ent & Projects

labus – CINS1

Topic

ologies

uding Open So

storming usin

rsonal enrich

website using W

Portable Doc

ns and integr

re of applicat

course that tnd informationd independeo visually comw individuals trgistic contenduce professinrichment. Evo have recent

successfully c

Reviews:• Skills: Prac• Concepts:

16WC1

ource softwa

ng Diagrammi

ment

Web Authori

cument Files (

ration feature

ion software

teaches themon managemeent student le

mpile course nto become acnt. This coursonal documeven though emgraduates th

completed to

ctice Labs and SAE-Crossword Puzz

re)

ng/Mapping

ng software

(PDF)

es of software

m how to utilizent / sharing tearning. Newnotes as well active participae explores ements, and manmployers mayhat have know

insure succes

AM TAPzles

Page

software

e

ze the latest ptool. Today’s w software likas informatioants in the Intmerging softwnage and shary not always mwledge of the

ssful complet

Graded As• Case Pro• Midterm E• E-Portfoli• Final Exa

2 of 5

M1, 2

1

5, 8

1

personal comemerging sof

ke Mind Mappon from the wternet as wellware that allore informatiomove to the le latest techno

tion of this co

ssessments:ojects (4)Examoam

Modules 2, 3, 4, 5

5, 8

9,10

11

6

4,7

,12,13

, 9,11, 12

5

3

12, 13

mputer ftware is ping and web. New l as ows n for latest ologies.

urse

2


Evaluation

Requirements:

You are expected to have the proper course materials.

Obtain your WebCT account and use WebCT for this course.

You should check the WebCT course at least once a week for announcements or reminders.

Successfully complete the following graded assignments

All Assessments need to be successfully completed to insure successful completion of this course

Projects and Exams Percent of Grade Case Projects (average of 4) 25% Midterm Exam 15% Final Project 30% Final Exam 30%

Total 100%

Grading Policy:

The maximum grade on Graded Projects (Case Projects and Final Project) turned in LATE will be 60% and corrections will NOT be allowed. Exams taken LATE will be penalized a minimum of 10 points. The one exception to these rules is for excused* absences, in which case you will receive a one day grace period.

An exam may be taken ahead of schedule if a work related conflict occurs.

You are expected to do your own work. Cheating will be considered grounds for immediate dismissal from the course.

You may be asked to explain the processes used to complete a project.

Final Average Letter Grade

90 ‐ 100% A

80 ‐ 89% B

70‐79% C

60‐69 D

0‐59% F

Attendance Policy:

Please log into the course at least once a week (daily for the summer or winter semesters) to check E‐mail and the Discussion Board for announcements.

An exam may be taken ahead of schedule if a work related conflict occurs. Missed Exams may be made up if I am contacted within 24 hours and a valid verified excuse* is given.

The Final Exam must be taken at a CCBC Testing Center – Please make your appointment early!!!

*An excused absence is an emergency such as a death in the family, religious holidays or participation in official college functions


Course Procedures Materials:

It is recommended that you purchased the textbook bundle from CCBC bookstore The textbook bundle contains items difficult to locate elsewhere!!!

Note: There are two bundles, one with a 180 Day Subscription to MS Office 2007 Professional and one without.

This course requires the use of MS Office 2007 Professional and Projects will require the use of the new features.

Special Materials included in Textbook Bundle purchased from CCBC Bookstore

Course Note Cards Videos Key Codes

MS Office 2007 180 Day Trial

(If bundle with the trial software purchased)

SEE IMPORTANT NOTE BELOW

o MS Office 2007 Professional ‐ (180 day trial can be purchased with text from CCBC bookstore) IMPORTANT: If you have previously installed any MS Office trial you cannot install this trial on the same PC!!! o Acrobat Reader 9 (students can download free copy of version 9 from www.adobe.com )

o MS OneNote 2007 (student must download 60 day trial at the time it is needed or use the Open Lab)

o Adobe Acrobat Professional 9.0 (student must download 30 day trial at the time it is needed or use the Open Lab)

o Mind View 3 (student must download 20 day trial at the time it is needed or use the Open Lab)

o Additional software will be used as needed, trial copies can be downloaded


Special Procedures: Learning Labs and Practice Assignments are designed to give you hands‐on experience. They are considered practice and are not graded. You are not required to turn them in. However if you want me to review them for accuracy they must be turned in by the due date.

Graded work will be indicated as Graded Project

An Open Lab (Catonsville ‐ H108 or Essex – N315) is available if needed to complete Learning Labs and Projects.

If you experience difficulty completing course work at home, you should use the Open Lab.

The Final Exam must be taken at a CCBC Testing Center – Please make your appointment early!!! WebCT is our means of communication and project submittal. Do NOT send email or projects elsewhere.

Services for Student with Disabilities:

CCBC is committed to providing equal access to educational opportunities for all students by arranging support services and reasonable accommodations for students with disabilities. A student with a disability may contact the appropriate campus office for an appointment to discuss reasonable accommodations. An appointment must be scheduled within a time period which allows staff adequate time to respond to the special needs of the student. The student must provide the appropriate office with proper documentation supporting the need for reasonable accommodations. For more information, contact:

CCBC Catonsville K Building, room 200 443-840-5617 (V/TTY)

CCBC Dundalk A Building, room 100 443-840-3774

443-840-3529 (TTY)

CCBC Essex A Building, room 210 443-840-1741

443-840-1601 (TTY)

CINS116 WC1 – Fall 2010 Page 1 of 2 8/18/2010

School of Applied an Information Technology Catonsville Campus

Emerging PC Software – CINS116 WC1 Final Version

This is an Overview of Class Activities. You should refer to the Learning Modules for specifics Schedule

Date/ Module

Activities Due Date

8/30/10

1

Do Orientation Assignment located on the Main Page of the Course Midnight 11:59 pm 9/1/10

1. 116 Self Assessment 2. Technology Concepts Review 3. Notes Manager Software 4. Emerging Web Technologies*

Midnight 11:59 pm 9/7/10

Labor Day Holiday: September 6 – College Closed

9/7/10

2

Software Updates & Betas | Browsers | Browser Plug Ins | Web Design | Search Engines | Microsoft & Google Web Sites as Technology Resources 1. Software Updates, Betas and New Releases: Windows 7 | Internet Explorer 8 2. New Browsers: Google Chrome | New Web Design Tools: Yola.com 3. New Search Engines: Bing.com 4. Sites for College Students 5. New Security Suites: Microsoft Security Essentials 6. Browser Plug-Ins: Adobe Reader


9/13/10

3

Mobile Devices | Information Retrieval and Sharing


9/20/10

4

Web 2.0 Applications 1. What’s New in Web 2.0 tools 2. Cloud Computing 3. What’s new in Google Tools 4. Blogging


9/27/10

5

Office 2007 Office 2007 Self Assessment and Training

Office 2007 Add-Ins and Translation Features

Midterm Exam Extra Credit due by 11:59 pm 10/4/10


10/4/10

6

Multimedia | Emerging Technology Resources | Midterm Exam Review 1. Multimedia Software 2. What’s New in Hot Web Sites 3. What’s New in Social Networking 4. Emerging Technology Resources 5. Review for Midterm Exam – WebCT:

a. Office 2007 including OneNote 2007, Windows Vista b. Web 2.0, Mobile Devices, Multimedia

Midterm Exam Available Starting Today it’s due by 11:59 pm 10/11/10

Midnight 11:59 pm 10/11/10


Date/ Module

Activities Due Date

10/11/10

7

Midterm Exam: Office 2007, OneNote 2007, Vista, IE 7, Web 2.0, Mobile Devices

WebCT: 116 Midterm Exam Open Textbooks / Notes / CourseNotes

Midnight TONIGHT 11:59 pm 10/11/10

GRADED PROJECT

Case Project 1: Web 2.0 – See Learning Module 7 of WebCT

Midnight 11:59 pm 10/18/10

10/18/10

8

GRADED PROJECT

Case Project 2: Office 2007 See Learning Module 8 of WebCT

Midnight 11:59 pm 10/25/10

10/25/10

9

Publisher 2007 1. Creating Desktop Publishing Documents


GRADED PROJECT

Case Project 3: Publisher 2007 – See Learning Module 9 of WebCT


11/1/10

10

Mind Mapping Software 1. Diagramming and Planning with Mind Mapping Software


GRADED PROJECT

Do Case Project 4: Diagramming Software – See Learning Module 10 of WebCT

Midnight 11:59 pm

11/15/10

11/15/10

11

Adobe Acrobat Professional 9.0 1. Creating Adobe Acrobat Documents 2. Creating an E- Portfolio using Adobe Acrobat Professional

Final Exam Extra Credit due by 11:59 pm 11/29/10

Midnight 11:59 pm

11/22/10

11/22/10

12

Final Project – GRADED PROJECT See Learning Module 12 under WebCT


Thanksgiving Holiday: November 24 through 28 2010 – College Closed

11/29/10

13

Continue Working on Final Project – GRADED PROJECT See Learning Module 12 under WebCT


12/6/10

14

1. Review for Concepts Final Exam: Web 2.0, Mobile Devices, Productivity, Notes Manager, Desktop Publishing, Mind Mapping, Adobe Software

Final Project due by 11:59 pm TONIGHT 12/6/10

--

Corrections to Final Project due by MIDNIGHT 11:59 pm 12/13/10 Final Exam can be taken starting 12/6/10 - WebCT: 116 Final Exam

Must be taken by midnight 11:59 pm 12/13/10 - Open Textbooks / Notes / CourseNotes

8/18/2010 CINS130 WC1 Syllabus Page 1 of 5

CINS130: Syllabus last revised: 8/18/2010

Final Version

CCBC: Catonsville

Academic Division: School of Applied and Information Technology

Course Number and Title: CINS130 – Comprehensive Word Processing

Section: WC1

BASIC COURSE INFORMATION:

Semester: Fall 2010 E-mail: [email protected]

Instructor: Valerie J. Farmer, Assistant Professor Phone: 443.840.4754

Office: Catonsville Campus H218G Fax: 443.840.4744

Office Hours: See WebCT Discussion Board Do Course Orientation Assignment

by midnight 11:59 pm September 1, 2010 Assignment is located on the Main Page of the Course

COURSE DESCRIPTION:

Semester Credit Hours: 3 Course Description: This course is designed to provide a comprehensive study of word processing and

written communications skills for professional and personal applications. Students will review basic word processing skills and learn intermediate and advanced word processing skills such as tables, mail merge, sorting, macros, sharing data between applications, Internet documents, charts, and desktop publishing features for designing brochures and newsletters. Techniques for writing letters, resumes, newsletters, advertising, and research papers are included.

Course Prerequisites/Co-requisites: Eligibility to enroll in CINS 130 is based on successful completion of CINS 101 or by permission of program coordinator.

COURSE GOALS:

The overall course goals are:

design enhanced and customized documents by utilizing available application and desktop publishing features.

prepare and enhance multiple page documents. create and format tables, fill-forms, templates and mail merge documents. integrate Word with other application software and the Web. develop and deploy macros. use critical thinking, problem solving, word processing and written communication skills to solve case

problems. illustrate proper written communication techniques for writing letters, resumes, newsletters, advertising and

research papers, as well as utilize proofreading and writing analysis tools.


The topics covered in this course include:

Correspondence Customizing Word (Toolbars, Menus...) Reports and Long Documents Sales and Marketing Documents Automating Work and Increasing Productivity (Templates, Macros...) Integration with other Office Software and the Web

Rationale for the course: Communicating with others and disseminating information are key activities in our daily lives. This course will enhance your ability to use word processing software to create printed or electronic letters, memos, reports, newsletters, and web pages that can be shared with others. The ability to create meaningful information by integrating data between software and the Internet is also an important requisite in today's society. This course will provide practical examples of data integration that will increase productivity, reduce errors and save time and effort.

COURSE PEDAGOGY:

EVALUATION:

Projects and Tests Percent of Grade

Midterm Project 20%

Midterm Exam 10%

Global Project 10%

Final Project 30%

Final Exam 30%

Total 100%


90 - 100% A

80 - 89% B

70 - 79% C

60 - 69% D

0 - 59% F


Additional Requirements:

You are responsible for making sure your home computer meets the technical (hardware and software) requirements for this course.

You are expected to have the required course materials. The Final Exam must be taken at a CCBC Testing Center – Please make your appointment early!!! Learning Assignments are designed to give you hands-on experience. Learning Assignments are considered

practice and are not recorded. You are not required to turn them in. However if you are having difficulty with a lesson or a Learning Assignment, you should e-mail it to me no later than one week after they were assigned.

Open Labs on each campus are available to assist you in completing your Learning Assignments and Projects.

If you experience problems using the software needed for this course on your home computer, you should plan to use the Open Lab. Check the Discussion Board for Open Lab Hours and Locations!!!

Grading Policy:

The maximum grade on Graded Projects (Midterm Project, Global Project and Final Project) turned in

LATE will be 60% and corrections will NOT be allowed. Exams taken LATE will be penalized a minimum of

10 points. The one exception to these rules is for excused* absences, in which case you will receive a one

day grace period.


You may be asked to explain the processes used to complete any Graded Projects.

Attendance Policy:

Please log into the course at least once a week (daily for the summer semester) to check E-mail and the Discussion Board for announcements.

Missed Midterm and Final Examinations may be made up if I am contacted within 24 hours and a valid verified excuse* is given.


*An excused absence is an emergency such as a death in the family, religious holidays or participation in official college functions.

COURSE PROCEDURES:

Special Procedures:

WebCT is our means of communication and project submittal. Do NOT send e‐mail or projects elsewhere.


Tentative list of dated assignments:

See Course Schedule





CCBC Dundalk A Building, room 100 443-840-3774 | 443-840-3529 (TTY)

CCBC Essex A Building, room 210 443-840-1741 | 443-840-1601 (TTY)

Course Materials:

o Microsoft Office Word 2007 Complete, by Duffy and Cram

It is recommended that you purchased the textbook bundle from the CCBC bookstore The bundle contains items difficult to locate elsewhere!!!

Note: There are two bundles, one with a 180 Day Subscription to MS Office 2007 Professional and one without.



Textbook SAM Key Code Trail Software


(if bundle with trial software purchased)

SEE IMPORTANT NOTE BELOW!!!

IMPORTANT: If you have previously installed any MS Office trial you cannot install this trial on the same PC!!!

Software:

o MS Office 2007 Professional – 180 day trial can be purchased with text from CCBC Bookstore o Internet Explorer 7.0 or higher o Acrobat Reader 9.0 (free can be downloaded from www.adobe.com)


HINTS FOR SUCCESS:

Here are some tips you should follow which will help you to succeed in this course:

Set aside a specific time each week to work on this course. The estimated amount of time you should spend is 5 hours per week.

Keep in touch with me and your classmates by frequently checking your course E-mail, the Discussion Board, and Calendar. This will help build a sense of community among us. Using the various communications tools provided in this course effectively is the same as "raising your hand" and participating in class discussions.

Be aware of the time lag that is inherent in most on-line courses. Although the communications tools make it appear that the transfer of information such as assignments is "instantaneous", it does not mean that the reply will be instantaneous. One of the hardest things about an on-line course is becoming comfortable with its asynchronous nature. In general, expect assignments to be returned within 3 days after the due date.

Familiarize yourself with published deadlines. Be sure you check the course syllabus and other course material for instructions on how to submit

assignments. Ask for help when you need it. Remember that there are traditional ways for keeping in touch. Use the telephone, a fax, or meet with me on

campus during my office hours. Work off-line and save your assignments on your computer before submitting them electronically. You can

then attach your saved work to an E-mail or a Discussion Board messages as needed. This will prevent a lot of frustration should your Internet connection or your system "fail".

Be sure to install anti-virus software on your local system. Make Backup copies of your coursework (especially projects) to floppy disks, Flash Drive or CD-RW.

CINS130 WC1 Schedule Fall 2010 Page 1 of 2

CINS130: Schedule last revised 8/18/2010

Final Version This is an Overview of Class Activities. You should refer to the Learning Modules for specifics

ORIENTATION ASSIGNMENT: Due by midnight 11:59 pm Wednesday September 1, 2010

It is important that you complete this assignment by the deadline. This assignment prepares you to successfully complete this course and determines the compatibility of your pc's hardware and software to course materials.

Read and Do the Orientation Assignment that is located on the Main Page of the WebCT Course

EXAM SESSIONS:

The Midterm and Final exams should be taken from your home computer, by the deadline using the WebCT software.

You will be allowed to use the textbooks for the exams

WEEKLY SCHEDULE:

Week of Module Activities Due Date

9/1/10 1

1. Reminder: Do Orientation Assignment ‐ See above for details

Midnight 11:59pm TONIGHT 9/1/10

1. Unit: A - Creating Documents with Word 2007 2. Unit: B - Editing Documents 3. Unit: C - Formatting Text and Paragraphs 4. Unit: D - Formatting Documents

Midnight 11:59pm 9/8/10

Labor Day Holiday: College Closed September 6, 2010

9/8/10 2 1. Unit: E- Creating and Formatting Tables 2. Unit: I - Working with Styles and Templates


9/15/10 3 1. Unit: F - Illustrating Documents with Graphics 2. Unit: M - Exploring Advanced Graphics


9/22/10 4 1. Unit: G - Working with Themes and Building Blocks Midnight

11:59pm 9/29/10

9/29/10 5 1. Unit: H - Merging Word Documents Midnight

11:59pm 10/6/10

Extra Learning for Extra Credit, worth 10 points towards the Midterm Exam DUE Midnight 11:59pm 10/6/10

Select three of the Weekly Trivia Questions and demonstrate the feature. Use any data files or create data files as needed.

CINS130 WC1 Schedule Fall 2010 Page 2 of 2

Week of Module Activities Due Date

10/6/10 6

Review for Midterm Exam: 130 Word Concepts Midterm Exam Review (130 Word Concepts Midterm Exam will be available to take starting today)


Midterm Project: See Projects Page of WebCT Midnight 11:59pm 10/20/10

10/13/10 7

Midterm Exam

Midnight 11:59pm

TONIGHT 10/13/10

Continue Working on Midterm Project Midnight 11:59pm

10/20/10

10/20/10 8 1. Unit: N - Building Forms Midnight

11:59pm 10/27/10

10/27/10 9 1. Unit: P - Customizing Word Midnight

11:59pm 11/3/10

11/3/10 10 1. Unit: J - Developing Multi-page Documents 2. Unit: O - Collaborating with Co-Workers


11/10/10 11 1. Unit: K - Working with References 2. Unit: L - Integrating Word with Other Programs


11/17/10 12

1. Global Project (See Learning Module 12 under WebCT) Midnight 11:59pm

12/1/10

2. Final Project (See Learning Module 12 under WebCT) Midnight

12/8/10

Extra Learning for Extra Credit, worth 10 points towards the Final Exam DUE 12/1/10 Complete the both the Word 2010 Training and Assessment under SAM with a score of 80% or better

Thanksgiving Holiday: College Closed November 24 – November 28, 2010

12/1/10 13 Continue to Work on Final Project - It's Due 12/8/10

12/8/10 14 2. Review for Final Exam-WebCT: 130 Word Concepts Final Exam Review

(130 Word Concepts Final Exam will be available to take starting today)

Final Exam

130 Word Concepts Final Exam must be taken by midnight 12/15/2010

Take the following exam under WebCT: 130 Word Concepts Final Exam - You may use the textbook

last revised: 8/18/2010 ACCT 132 / CINS 132 WCH Page 1 of 4

Community College of Baltimore County

Final Version

Syllabus Campus:

Catonsville Course Number and Title:

ACCT132/CINS132– Comprehensive Spreadsheets Section:

WCH

BASIC COURSE INFORMATION:

Semester: Fall 2010 E-mail: [email protected]

Instructor: Valerie J. Farmer, Assistant Professor Phone: 443.840.4754

Office: Catonsville Campus H218-G Fax: 443.840.4744

Office Hours: See WebCT Discussion Board Location: Blended Time: 5 campus visits see Schedule

COURSE DESCRIPTION:

Semester Credit Hours: 3

Course Description: This course is designed to provide an in-depth study of an integrated spreadsheet environment that is widely used on microcomputer and network systems. Spreadsheet, database, and graphic features are studied; additionally, advanced topics such as macro development, and the integration of this package with other microcomputer packages are introduced. Students will also learn data security and data integration techniques.

Course Prerequisites/Co-requisites: Eligibility to enroll in CINS 132 is based on successful completion of CINS 101 or CINS116 or by permission of program coordinator.

COURSE GOALS:


1. Develop a professional-looking worksheet that is well organized, easy to understand, and documented appropriately. 2. Insert correct functions and create accurate formulas to calculate data. 3. Troubleshoot and analyze problems in spreadsheets and provide appropriate solutions. 4. Format workbooks with custom number formats, conditional formatting, AutoFormats, and Styles. 5. Enhance the workbook’s appearance with fonts, borders, bold, underscore, shading, colors, textboxes, drawing,

AutoShapes, SmartArt, WordArt, and ClipArt. 6. Create charts that represent data most effectively. 7. Manipulate, extract, sort, and summarize data with Pivot Tables, Pivot charts and Filtering. 8. Integrate spreadsheets with other Windows programs and the World Wide Web. 9. Develop worksheets to complete applications, assign data validation rules, and streamline procedures by utilizing

macros. 10. Consolidate and link data from multiple worksheets and workbooks, use 3-D references, and utilize lookup functions. 11. Use What if analysis, data tables, goal seek, scenarios, and solver to provide data to assist in making relevant

business decisions. 12. Import data into a worksheet to reduce data redundancy and provide up-to-date data from the Web. 13. Customize workbook templates. 14. Use critical thinking, problem solving, and spreadsheet skills to solve case problems.



1. Spreadsheet Concepts and Terminology 2. Planning, Organizing, Testing, And Documenting Worksheets 3. Entering Data 4. Creating Mathematical Formulas 5. Using Appropriate Functions 6. Selecting/Defining/Naming Ranges 7. Formatting Worksheets 8. Creating Charts 9. Utilizing Enhancements--Drawing, WordArt, SmartArt, Clipart, Textboxes, Shading, and AutoShapes 10. Working With Lists 11. Object Linking and Embedding (OLE) 12. Integration With Other Applications and The World Wide Web 13. Importing/Exporting Data from Other Data Sources and the Web 14. Using What-If Analysis, Data Tables, Scenarios, and Solver 15. Automating Excel With Macros 16. Sharing Workbooks With Others 17. Creating and Customizing Templates, Toolbars, and Menus 18. Summarizing Data with Data Bars, Pivot Tables, and Pivot Charts

Rationale for the course: Storing, manipulating and summarizing data into information that can be used to make decisions are key activities in our daily lives. This course will enhance your ability to use spreadsheet software to create spreadsheets that store, manipulate, summarize, and analyze data that can be shared with others. The ability to create meaningful information by integrating data between software and the Internet is also an important requisite in today's society. This course will provide practical examples of data integration that will increase productivity, reduce errors and save time and effort.

COURSE PEDAGOGY:

EVALUATION:

Projects and Exams Percent of Grade

Midterm Project 30%

Midterm Exam 10%

Final Project 30%

Final Exam 30%

Total 100%


90 - 100% A

80 - 89% B

70 - 79% C

60 - 69% D

0 - 59% F


Additional Requirements:

You are expected to have the required course materials. You are expected to use the WebCT as assigned throughout the course Both the Midterm and Final Exam will assess Spreadsheet Concepts Learning Assignments are designed to give you hands-on experience. Learning Assignments are considered

practice and are not recorded. You are not required to turn them in. However if you are having difficulty with a unit or Learning Assignment, you should e-mail it to me no later than one week after it was assigned.

If you experience problems using the software needed for the course on your home computer, you should plan to use the Open Lab. Check the Discussion Board for Open Lab Hours and Locations.

Grading Policy:

The maximum grade on Graded Projects (Midterm Project and Final Project) turned in LATE will be 60% and corrections will NOT be allowed. Exams taken LATE will be penalized a minimum of 10 points. The one exception to these rules is for excused* absences, in which case you will receive a one day grace period.



Attendance Policy:


Please log into WebCT at least once a week (daily for the summer semester) to complete Learning Modules, Concept Reviews, find solutions to Learning Assignments check E-mail and check the Discussion Board for Announcements.



COURSE PROCEDURES:

Special procedures:

WebCT is our means of communication and project submittal. Do NOT send e‐mail or projects elsewhere.






443-840-3529 (TTY)


443-840-1601 (TTY)


Course Materials:

It is recommended that you purchase the textbook at CCBC’s Bookstore – other materials come with textbook Note: There are two bundles, one with a 180 Day Subscription to MS Office 2007 Professional and one without.


MS Office Excel 2007 Illustrated Complete, by Reding | Wermers Portable storage media: Flash Drive (1) at least 256MB


Textbook CaseGrader Excel 2007 Key Code Trial Software




IMPORTANT: MS Office Trial software can only be installed ONCE on the SAME PC!!!

Additional Software:

-Internet Explorer 5.0 or higher -Adobe Reader 8.0 or higher (free can be downloaded from www.adobe.com)


See Course Schedule





Familiarize yourself with published deadlines. Be sure you check the course syllabus and other course material for instructions on how to submit assignments. Ask for help when you need it. Remember that there are traditional ways for keeping in touch. Use the telephone, a fax, or meet with me on

campus during my office hours. Work off-line and save your assignments on your computer before submitting them electronically. You can then

attach your saved work to an E-mail or a Discussion Board messages as needed. This will prevent a lot of frustration should your Internet connection or your system "fail".

Be sure to install anti-virus software on your local system. Make Backup copies of your coursework (especially projects) to a Flash Drive or CD-RW.

revised 8/18/2010 ACCT132/ CINS132 WCH Schedule - Fall 2010 Page 1 of 2

Final Version This is an overview of Class Activities. You should refer to the Learning Modules for specifics

Date Module Activities Due Date

8/10/10

1

Complete Course Orientation Assignment 9/1/10 11:59 pm

9/1/10

Unit A – Getting Started with Excel 2007 Unit B – Working with Formulas and Functions

Unit C – Formatting a Worksheet

9/7/10 11:59 pm

9/8/10 2 Unit D – Working with Charts

Unit J – Enhancing Charts 9/14/10 11:59 pm

9/15/10

Attend the Catonsville Campus room H215 from 5:45pm – 8:40pm Bring your textbook

Scheduled Activities: Unit E – Analyzing Data using Formulas Unit F – Managing Workbook Data Unit O – Customizing Excel Unit O – Advanced Worksheet Management

9/15/10 3 Unit E – Analyzing Data using Formulas 9/21/10 11:59 pm

9/22/10 4 Unit F – Managing Workbook Data

Unit O – Customizing Excel & Advanced Worksheet

Management

9/28/10 11:59 pm

Extra Learning for Extra Credit (10 points) towards the Midterm Exam: Go to www.microsoft.com/office | Search on Excel Add Ins or Excel Multi‐Language features | Write a one page report

Due 9/28/10

9/29/10


Scheduled Activities: Midterm Exam Review: Units A through F, J and O Midterm Project Review: Units A through F, J and O

9/29/10 5 Midterm Review 10/5/10

10/6/10 6

Midterm Exam

10/6/10

TONIGHT11:59 pm

Midterm Project 10/12/10 11:59 pm

revised 8/18/2010 ACCT132/ CINS132 WCH Schedule - Fall 2010 Page 2 of 2

Date Module Activities Due Date

10/13/10 7 Unit G – Using Tables Unit H – Analyzing Table Data

10/19/10 11:59 pm

10/20/10


Scheduled Activities: Unit G – Using Tables (Sample Case) Unit H – Analyzing Table Data (Sample Case) Unit L – Analyzing Data with Pivot Tables

10/20/10 8 Unit L – Analyzing Data with Pivot Tables 10/26/10 11:59 pm

10/27/10


Scheduled Activities: Unit K – Using What-If Analysis Unit I – Automating Worksheet Tasks

10/27/10 9 Unit K – Using What‐If Analysis 11/2/10 11:59 pm

11/3/10 10 Unit I – Automating Worksheet Tasks 11/9/10 11:59 pm

11/10/10 11 Unit M – Exchanging Data with Other Programs 11/16/10 11:59 pm

11/17/10 12

Unit N – Sharing Excel Files and Incorporating Web Information 11/23/10 11:59 pm

Final Project 12/7/1011:59 pm

12/1/10


Scheduled Activities: Unit M – Exchanging Data with Other Programs (Sample Case) Unit N – Sharing Excel Files and Incorporating Web Information (Sample Case) Accounting Applications using Excel

12/1/10 13 Continue Working on Final Project 12/7/1011:59 pm

12/8/10 14 Final Exam Review ‐‐

Extra Learning for Extra Credit (10 points) towards the Final Exam: Do Case 12 under CaseGrader ‐ Due by 11:59 pm 12/7/10

Final Project Corrections (optional) due by 11:59 pm Monday 12/13/10

Final Exam due by 11:59 pm 12/14/10

last

CIN

C C

C C

BAS

COU

COU

revised: 8/

NS134:

CCBC: Catonsville

Course NumbCINS134 – Co

SIC COURSE

Semeste

Instructo

Office: C

Office HoSee Web

URSE DESCR

Semester Course D

systems (microcomfundamen

Course P101 or by

URSE PEDAG

All Grad

18/2010

: Syllab

ber and Titleomprehensiv

E INFORMAT

er: Fall 2010

or: Valerie J.

Catonsville C

ours: bCT Discussi

RIPTION:

r Credit HouDescription: T(DBMS). Stud

mputer DBMS ntals. Student

Prerequisitespermission o

GOGY:

ded Assessm

Learning Reso

• Textbook• Tegrity Vide• Flash Demo• Lecture Note• SAM

CIN

bus

: ve Databases

TION:

Farmer, Ass

ampus H218

ion Board

rs: 3 This course is

dents will havepackage. Stu

ts will also lea

s/Co-requisiteof program co

ents need to

ources:

os Videoses

NS134 WC

FINA

s

sistant Profe

8-G

s designed toe the opportuudents will bearn to retrieve

es: Eligibility oordinator.

be successful

Reviews:

• Skills • Concept• *Possibi

1

AL VERSIO

A S

S W

ssor

byA

o provide an innity to design introduced to

e information b

to enroll in C

lly completed

- Textbookts - Electronic*ility to earned exam e

ON

Academic DiSchool of Ap

Section(s): WC1

E-mail: v

Phone: 4

Fax: 443

Do Coursy midnightAssignment loc

ntroduction ton, create, ando Access Struby creating qu

INS134 is ba

d to insure suc

extra credit

Grad

• Mid• Mid• Exa• Fin• Fin

Page 1 of

vision: pplied and In

vfarmer@ccb

443.840.4754

3.840.4744

se Orientatt 11:59 pm cated on the M

o databases ad modify a datuctured Queryueries, report

sed on succe

ccessful comp

ded Assessments:

dterm Projectdterm Examam 2al Case Projectal Exam

f 5

formation Te

bcmd.edu

4

ion AssignSeptembe

Main Page of th

and database tabase using y Language (Sts and forms.

essful comple

pletion of this

echnology

nment er 1, 2010he Course

managemena popular SQL)

etion of CINS

s course

t

last revised: 8/18/2010 CINS134 WC1 Page 2 of 5

COURSE GOALS:


Goals Learning ModuleDistinguish between a database and a traditional file 1

Identify the major components of a DBMS 1

Design a database 3, 4

Create Keys and Relationships 1, 3, 4

Implement Integrity Constraints 3

Create a Database and related Tables 1

Manage a Database 9

Query a database using QBE and SQL 1, 3, 4, 13

Create Forms 2, 5, 9

Create Reports 2, 5, 7

Create Macros 10

Create a Switchboard 9


Topics Learning ModuleComparison of file processing and data processing 1

Components of a Database Management System (DBMS) 1

Functions of a DBMS 1

Relational Database Structures and Terminology 1,3

Database design, creation and modification 3,4,9

Database Objects (tables, queries, forms, reports, data access pages, and macros) 1, 2, 3, 4, 5, 7, 9, 10

Access Structured Query Language (SQL) fundamentals 13

Integration with other Office Software and the Web 6

Rationale for the course: Storing, manipulating and summarizing data into information that can be used to make decisions are key activities in our daily lives. This course will enhance your ability to use database management software to create databases that store, manipulate, summarize, and analyze data that can be shared with others. The ability to create meaningful information by integrating data between software and the Internet is also an important requisite in today's society. This course will provide practical examples of data integration that will increase productivity, reduce errors and save time and effort.

EVALUATION:


90 - 100% A

80 - 89% B

70 - 79% C

60 - 69% D

0 - 59% F

All Graded Assessments need to be successfully completed to insure successful completion of this course

Projects and Exams Percent of Grade

Midterm Project 20%

Test and Midterm Exam (averaged together) 20%

Case Project 30%

Final Exam 30%

Total 100%

last revised: 8/18/2010 CINS134 WC1 Page 3 of 5 Additional Requirements:

You are responsible for making sure your home computer meets the technical (hardware and software) requirements for this course. If not, you should plan to use one of the Open Labs, located at each campus.

You are expected to have the required course materials. You are expected to use WebCT. Both the Midterm and Final Exam will assess Database Concepts and will be given using WebCT The Final Exam must be taken at a CCBC Testing Center – Please make your appointment early!!! Learning Assignments are designed to give you hands-on experience. Learning Assignments are considered

practice and are not recorded. You are not required to turn them in. However if you are having difficulty with a unit or Learning Assignment, you should e-mail it to me no later than one week after it was assigned.

Open Labs on each campus are available to assist you in completing your Learning Assignments and Graded Projects.

If you experience problems using the software needed for the course on your home computer, you should plan to use the Open Lab. Check the Discussion Board for Open Lab Hours and Locations.

Grading Policy:

The maximum grade on Graded Projects (Midterm Project and Final Case Project) turned in LATE will be 60% and corrections will NOT be allowed. Exams taken LATE will be penalized a minimum of 10 points. The one exception to these rules is for excused* absences, in which case you will receive a one day grace period.



Attendance Policy:


Please log into the course at least once a week (daily for the summer semester) to check E-mail and the Discussion Board for announcements.



COURSE PROCEDURES:





443-840-3529 (TTY)


443-840-1601 (TTY)


Course Materials:

IT is recommended that you purchase the textbook at CCBC’s Bookstore – other materials come with textbook

Note: There are two bundles, one with a 180 Day Subscription to MS Office 2007 Professional and one without. This course requires the use of MS Office 2007 Professional and Projects will require the use of the new features.


Textbook SAM 2007 Key Code Trial Software

MS Office Access 2007 Complete by Friedrichsen

SAM 2007 Training,

Assessments and Projects



IMPORTANT: MS Office Trial software can only be installed ONCE on the SAME PC!!!

Additional Software: -Internet Explorer 5.0 or higher -Adobe Reader 8.0 or higher (free can be downloaded from www.adobe.com)

Special procedures:

WebCT is our means of communication and project submittal. Do NOT send e-mail or projects elsewhere.


See Course Schedule


HINTS FOR SUCCESS:





Familiarize yourself with published deadlines. Be sure you check the course syllabus and other course material for instructions on how to submit assignments. Ask for help when you need it. Remember that there are traditional ways for keeping in touch. Use the telephone, a fax, or meet with me on

campus during my office hours. Work off-line and save your assignments on your computer before submitting them electronically. You can then

attach your saved work to an E-mail or a Discussion Board messages as needed. This will prevent a lot of frustration should your Internet connection or your system "fail".

Be sure to install anti-virus software on your local system. Make Backup copies of your coursework (especially projects) to a Flash Drive or CD-RW.

last revised 8/18/2010 CINS134 WC1 Schedule Fall 2010 Page 1 of 3

CINS134

Final Version This is an Overview of Class Activities. You should refer to the Learning Modules for specifics

COURSE ORIENTATION ASSIGNMENT: Due by Midnight (11:59 pm) September 1, 2010


Read and Do the Course Orientation Assignment located on the Main Page of the Course.

EXAM SESSIONS:

All exams should be taken from your home computer, by the deadline using the WebCT software. You will be allowed to use the textbook and handouts for the exams.

WEEKLY SCHEDULE:

Day Module Activities Due Date

8/30/10 Orientation Reminder: Do Course Orientation Assignment Midnight

(11:59 pm)

9/1/10

9/1/10 1 Units A and B Midnight

(11:59 pm)

9/8/10

Labor Day Holiday - College Closed: September 6, 2010

9/8/10 2 Units C and D Midnight

(11:59 pm)

9/15/10

9/15/10 3 Units E and F Midnight

(11:59 pm)

9/22/10

9/22/10 4 Units K and J Midnight

(11:59 pm)

9/29/10

9/29/10 5 Units G and H Midnight

(11:59 pm)

10/6/10

10/6/10 6 Midterm Project - GRADED PROJECT

Midnight (11:59 pm)

10/13/10



Extra Learning for Extra Credit: 10 points towards the Midterm Exam DUE Midnight (11:59 pm) 10/13/10

Complete any Independent Challenge not assigned from Units A – H, J or K

10/13/10 7

Unit I and Unit L

Review for Midterm Exam ( 134 Access Midterm Exam will be available to take starting today)

Midnight (11:59 pm)

10/20/10

Midterm Project due by midnight 11:59 pm TONIGHT 10/13/10

10/20/10 8

Midterm Exam

The exam will be taken from home You may use your textbooks and notes during the exam.

Midnight (11:59 pm) 10/27/10

10/27/10 9 Units M and P Midnight

(11:59 pm)

11/3/10

11/3/10 10 Unit N

Midnight

(11:59 pm)

11/10/10

11/10/10 11

Review for Exam 2 ( 134 Access Exam 2 will be available to take starting today)

Midnight (11:59 pm)

11/17/10

Case Project -- GRADED PROJECT

Midnight (11:59 pm)

12/1/10

11/17/10 12

Exam 2

The exam will be taken from home You may use your textbooks and notes during the exam.

Midnight (11:59 pm) TUESDAY 11/23/10

Continue to Work on Case Project - GRADED PROJECT

Midnight (11:59 pm)

12/1/10

Thanksgiving Holiday - College Closed: November 24 – November 28, 2010



12/1/10 13 SQL (Structured Query Language)

Midnight

(11:59 pm)

12/8/10

Case Project due by midnight (11:59 pm) TONIGHT 12/1/10

Extra Learning for Extra Credit: 10 points towards the Final Exam

DUE midnight (11:59 pm) 12/8/10

Complete the SQL Project that is part of the SQL Handout

12/8/10

14

Corrections to the Case Project (optional)

Midnight

(11:59 pm)

12/13/10

Review for the Final Exam (Posted on the Discussion Board) (134 Access Final Exam will be available to take starting today)

-- Final Exam Extra credit due

midnight (11:59 pm) tonight 12/8/10

Final Exam must be taken by midnight (11:59 pm) 12/15/10

The exam will be taken from home and you may use the textbook and handouts

CHAT SESSIONS: (optional)

To be announced or by invitation

THE WEBCT CALENDAR:

This schedule is also included under WebCT.

8/18/2010 Page 1 of 4

Catonsville Campus

Info Management for Decision Making–CINS233 WC1

Final Version Basic Course Information

Semester / Term Fall 2010 Pre-requisites CINS132 or OFAD246, CINS134 or OFAD243, CINS146 or Credit by Examination Instructor Valerie Farmer Assistant Professor CIS Office H218 G See the WebCT Discussion Board for my Office Hours Contact Information Phone: 443-840-4754 E-mail: [email protected]

Important Websites CCBC’s: www.ccbcmd.edu Instructor’s: http://student.ccbcmd.edu/~vfarmer

Do Course Orientation Assignment by midnight 11:59 pm September 1, 2010 Assignment is located on the Main Page of the Course

Course Goals

Course Objectives Upon completion of this course the student will be able to: Objective Module 1. define Information Management and Business Intelligence and their roles within organizations; 1 2. analyze information needs to determine appropriate information retrieval tools or techniques; 2‐13 3. setup Open Database Connectivity (ODBC); 3‐5, 8‐10 4. generate Business Intelligence by using multidimensional data analysis techniques (Pivot Tables etc.); 3‐11 5. create and manipulate Adobe Portable Document Files (PDF); 10, 11 6. create data visualizations using MS Office, MS Office Add-ins and Adobe Acrobat; 2‐13 7. retrieve information using Query by Example (QBE) and Structured Query Language (SQL); 6‐11 8. identify the information need and presentation format; 2‐13 9. determine the data sources for the required information need; 2‐13 10. choose the appropriate processing required to retrieve the required information; 2‐13 11. retrieve information typically required from various industries; 5‐13 12. integrate external information (currency exchange rates, prime rate, etc.) from electronic sources; 3, 4 13. design Business Intelligence Models for various types of industries; 5‐13 14. implement Business Intelligence Models for various types of industries; and 5‐13 15. create a web information portal. 12, 13

Major Topics: 1. Defining Information Management and Business Intelligence 2. Identifying the information need 3. Determining data sources and their formats 4. Cleansing and validating data sources 5. Choosing the appropriate presentation format for information 6. Choosing the appropriate processing required to retrieve and present information 7. Determining when to link to data as opposed to Importing or Exporting data 8. Using a Report Writer to write various types of reports (Summary, Detail, Sub-Reports...) 9. Using Multidimensional Data Analysis techniques (Cross Tabs, Pivot Tables and Pivot Charts) 10. Creating and manipulating Adobe Portable Document Format (PDF) documents 11. Creating Data Visualizations using MS Office, MS Office Add-ins and Adobe Acrobat 12. Identifying and integrating appropriate external information (prime rate, currency rates…) 13. Designing a Business Intelligence Model

8/18/2010 Page 2 of 4 14. Implementing a Business Intelligence Model 15. Retrieving and presenting information for various types of industries 16. Creating a Web Information Portal Course Rationale: Increasingly workers are becoming information workers who must retrieve and present information from vast

amounts of data from a variety of data sources. Companies are providing non‐technical employees with the software tools they need to analyze and manipulate data into information for problem solving and decision making. This course introduces you to the various types of multidimensional data analysis techniques used in Business Intelligence that allow professionals to retrieve and present information from data sources. You will gain practical experience in information retrieval and presentation by completing case projects that are industry based. You will gain experience in the information and presentation needs of various industries to prepare you for employment as an Information Analyst or an information worker in various industries. This course is for non‐technical individuals who need technical skills that can prepare them to retrieve and present information for decision making, problem solving and gaining a competitive edge.

Course Pedagogy

Evaluation

Requirements: You are expected to have the proper course materials. Obtain your WebCT Account and use WebCT for this course. You should check the WebCT course at least once a week for announcements or reminders. Successfully complete the following graded assignments

Projects and Exams Percent of Grade Case Projects (average of 5) 30% Web Information Portal 30% Midterm Exam 10% Final Exam 30% Total 100%

Grading Policy:

The maximum grade on Graded Projects (Case Projects and Web Information Portal) turned in LATE will be 60% and corrections will NOT be allowed. Exams taken LATE will be penalized a minimum of 10 points. The one exception to these rules is for excused* absences, in which case you will receive a one day grace period.

An exam may be taken ahead of schedule if a work related conflict occurs. You are expected to do your own work. Cheating will be considered grounds for immediate

dismissal from the course. You may be asked to explain the processes used to complete a project.


90 - 100% A

80 - 89% B

70-79% C

60-69 D

0-59% F

8/18/2010 Page 3 of 4

Attendance Policy:

Please log into the course at least once a week (daily for the summer semester) to Check E-mail and the Discussion Board for announcements.

An exam may be taken ahead of schedule if a work related conflict occurs. The Final Exam must be taken at a CCBC Testing Center – Please make your appointment early!!! Missed Exams may be made up if I am contacted within 24 hours and a valid verified excuse* is given.

*An excused absence is an emergency such as a death in the family, religious holidays or participation in official college functions

Course Procedures

Special Procedures: Learning Labs are designed to give you hands-on experience. They are considered practice and are not graded. You are not required to turn them in. However if you want me to review them for accuracy they must be turned in by the due date. Graded work will be indicated as Graded Project An Open Lab (Catonsville - H108 or Essex – N315) is available so you can complete your Learning

Labs and Graded Projects. WebCT is our means of communication and project submittal. Do NOT send email or projects elsewhere. If you experience difficulty completing assignments at home, you should use the Open Lab. Open

Lab Schedule is posted on the Discussion Board. The Final Exam must be taken at a CCBC Testing Center – Please make your appointment early!!!

Services for Students with Disabilities: CCBC is committed to providing equal access to educational opportunities for all students by arranging support services and reasonable accommodations for students with disabilities. A student with a disability may contact the appropriate campus office for an appointment to discuss reasonable accommodations. An appointment must be scheduled within a time period which allows staff adequate time to respond to the special needs of the student. The student must provide the appropriate office with proper documentation supporting the need for reasonable accommodations. For more information, contact:



443-840-3529 (TTY)


443-840-1601 (TTY)

8/18/2010 Page 4 of 4

Materials:

I strongly recommend that you purchase your textbook bundle from CCBC’S Bookstore!!! (Although there is not a textbook there are other materials included in the bundle)

Note: There are two bundles, one with a 180 Day Subscription to MS Office 2007 Professional and one without. This course requires the use of MS Office 2007 Professional and Projects will require the use of the new features.


CourseNote Cards Video CD Trial Software



SEE IMPORTANT NOTE BELOW

Flash Drive

1 GB Flash Drive

Hardware: o 256 MB Flash Drive (1GB Flash Drive included with textbook if purchased new from CCBC Bookstore) Software: o MS Office 2007 Professional - 180 day subscription can be purchased with the text from the CCBC Bookstore

IMPORTANT: Any MS Office 2007 trial subscription can only be installed once on the SAME PC!!!

o Target Reports (student must download 90 day trial or use the Open Lab) o Adobe Acrobat Professional 9.0 or later (student must download 30 day trial or use the Open Lab) o Mind View 3 (student must download 20 day trial) or use the Open Lab) o Additional Microsoft Add-In software may be used as needed, trial copies can be downloaded



Info Management for Decision Making – CINS233 WC1 Final Version

This is an Overview of Class Activities. You should refer to the Learning Modules for specifics

Schedule Date/

Module Activities Due Date

8/30/10

1

Do Course Orientation Assignment located on the Main Page of the Course Note: This assignment prepares you to successfully complete this course and

determines the compatibility of your home pc's hardware and software to course materials.

Midnight 11:59 pm

9/1/10

1. Information Management 2. Transition into Microsoft Office 2007 (if necessary)

Midnight 11:59 pm

9/7/10

Labor Day Holiday ‐ College Closed: September 6, 2010

9/7/10

2

1. Data Visualization

2. Data Visualization with Office 2007 and SmartDraw


GRADED PROJECT - Case Project 1

Data Visualization using PowerPoint– See Learning Module 2


9/13/10

3

1. Getting Started with Pivot Table Reports in Excel 2007

2. Filter Pivot Table Report Data in Excel 2007

3. Calculate Data In Pivot Table Reports in Excel 2007

4. Client Server Computing

5. Client Server Computing – Using MS Office as a Client*


Extra Learning for Extra Credit: Worth 10 points towards the Midterm Exam Use SmartDraw to Redo Case Project 1 – due 11:59 pm 9/20/10

9/20/10

4

1. Data Warehouse and Data Mining

2. Using a Cube as an Excel Pivot Table Source

3. Review for Midterm Exam: Information Management (IM) Business Intelligence (BI) Excel Pivot Tables and Pivot Charts Data Visualization Data Warehouse and Data Mining

Midterm Exam Available Starting Today



Date/ Module Activities

Due Date

9/27/10

5

Midterm Exam: IM, BI, Excel Pivot Tables/Charts, Data Warehouse and Data Mining

WebCT: 233 Midterm Exam Open Textbooks / Notes

Midnight TONIGHT 9/27/10


Analyzing Data using Excel Pivot Tables / MS Query– See Module 5


10/4/10

6

1. Interpreting E-R (Entity Relationship) Diagrams

2. Querying Data using Access QBE (Query by Example)

3. Querying Data using Access SQL (Structured Query Language)

4. Creating Pivot Tables based on Queries

Midnight 11:59 pm 10/11/10

10/11/10

7


Data Analysis and Presentation using Access – See Learning Module 7

Midnight 11:59 pm 10/18/10

10/18/10

8

1. Using Report Writers (Target Reports)

Midnight 11:59 pm 10/25/10

10/25/10

9


Data Analysis and Presentation Using Report Writers See Module 9


11/1/10

10

1. Creating Adobe Acrobat Professional Documents Midnight 11:59 pm 11/8/10


Data Analysis | Presentation and Recommendations See Module 10


11/8/10

11 Using Cloud Business Intelligence Applications (BIRST)

Midnight 11:59 pm 11/15/10

Extra Learning for Extra Credit: Worth 10 points towards the Final Exam Complete the BIRST Practice Exercise - See Module 11 11:59 pm 11/29/10


Date/ Module Activities

Due Date

11/15/10

12

1. Web Information Portals

2. Using Diagramming Software (Mind View) to Diagram a Web Portal

Midnight 11:59 pm 11/22/10

GRADED PROJECT – Final Project

Web Information Portal Project See Learning Module 13


Thanksgiving Holiday ‐ College Closed: November 24 – November 28, 2010

11/29/10

13

Continue working on GRADED PROJECT – Final Project

Web Information Portal Project See Learning Module 13


12/6/10

14

Final Project due 11:59 pm TONIGHT 12/6/10 1. Exploring MS Office Add Ins (optional)

2. Review for Final Exam: Information Management (IM) Business Intelligence (BI) Data Visualization Data Analysis and Presentation using Excel Pivot Tables and Charts Data Warehouse and Data Mining Data Analysis and Presentation using Access Data Analysis and Presentation using Report Writers Information Presentation using Web Information Portals

Final Exam will be available to take starting today

--

Corrections to Web Information Portal Project due by MIDNIGHT 11:59 pm 12/12/10

Final Exam can be taken starting 12/6/10 Must be taken by midnight 11:59 pm 12/13/10 - Open Textbooks and Notes

Must be taken at a CCBC Testing Center; book your appointment early!!!

See Testing Center Link under the CCBC Bookmarks on the Main Page of WebCT

of 4

School of Applied and Information Technology Catonsville Campus

Database Concepts – CINS234 WCH Syllabus

Final Version August 18, 2010

Basic Course Information Semester / Term Fall 2010 Pre-requisites CINS101 Instructor Valerie Farmer Assistant Professor CISOffice Catonsville Campus - H218 GContact Information Phone: 443-840-4754 E-mail: [email protected] Office Hours Check my website Important Websites CCBC’s: www.ccbcmd.edu Instructor’s: http://student.ccbcmd.edu/~vfarmer

Do Course Orientation Assignment by midnight Wednesday September 1, 2010 Assignment is on the Main Page of the WebCT course

Course Goals

Course Objectives: Upon completion of this course the student will be able to:

Objective Module 1. Identify the major components of a database and a Database Management System (DBMS) 1

2. Distinguish between the primary database models: hierarchical, network, relational, and object‐oriented 13

3. Design and Normalize a database 7, 8, 9, 10, 11

4. Create a multi‐table relational database 7, 8, 9, 10, 11, 12

5. Create Keys and Indexes 5,7, 8, 10, 11, 12

6. Implement Integrity Constraints 5

7. Code queries using Structured Query Language (SQL) 3, 4, 5, 6

8. Describe the role of a Database Administrator (DBA) in a business organization 1,

9. Create a database application for a business 7, 8, 9, 10, 11, 12

Major Topics:

Topic Module 1. Components of a Database and a Database Management System (DBMS) 1

2. Comparison of file processing and database processing 1

3. Functions of the Data Dictionary 5,13

4. Role of the Database Administrator (DBA) 1

5. Database Models, Physical Data Structures and Logical Data Structures 1

6. Database Design, Normalization, and Entity-Relationship Diagram 7, 8, 9, 10, 11

7. Keys, Indexes and Integrity Constraints 5,7, 8, 10, 11, 12

8. Database Maintenance, Security, Journaling/Backing-up and Compacting 13

9. Multi-User Database Processing 13

10. Structured Query Language (SQL) 3, 4, 5, 6

CoModecdes

Co

Gr

ourse Ratiodeling) techcision makinsign and adm

ourse Peda

All Graded A

rading Poli

The maxand corone excperiod.

An exam

The Fin

You aredismiss

You ma All Grad

onale: This hniques to bng. Informatminister a DB

agogy:

Assessments

icy:

ximum graderections will ception to the

m may be ta

nal Exam m

e expected tal from the

ay be asked ded Assessme

ProjeCase PMidterFinal PFinal ETotal

Learning Res

• Textbook• Tegrity Vide• Flash Demo• Lecture Not• My SQL D• MS Visio

course will uild effectivion TechnolBMS system.

need to be su

e on Graded NOT be allowese rules is fo

aken ahead o

ust be taken

to do your o course.

to explain tents need to b

ects and ExaProjects (averrm Exam Project Exam

Fin9

sources:

eoso VideostesDBMS

challenge yve databasesogy professi.

uccessfully co

Ev

Projects (Midwed. Exams or excused*

of schedule

n at a CCBC

wn work. Ch

the processebe successfull

ams rage of 3)

nal Average90 - 100%80 - 89%70-79%60-690-59%

Reviews:

• Skills -• Concepts • *Possibilitycredit

you to use crs. Well desigionals will b

ompleted to in

valuation

dterm Projec taken LATE w absences, in

if a work re

C Testing Ce

heating will

es used to coly completed

Lette

Textbook- Electronic*y to earned exam ext

ritical thinkign database

benefit from

nsure successf

ct and Final Pwill be penali which case y

elated confli

enter – Plea

l be conside

omplete a prto insure suc

Perc

er GradeABCDF

tra

Graded As

• Case Pro• Midterm • Final Cas• Final Exa

ing, analysises facilitate learning ho

sful completio

Project) turneized a minim you will recei

ict occurs.

se make you

red grounds

roject. ccessful comp

cent of Grad30103030

100

ssessments:

ojects (3)Examse Projectam

s and CASE (data analysi

ow to effecti

on of this cour

ed in LATE wium of 10 poinve a one day

ur appointme

for immedi

letion of this

de0%0%0%0%0%

Page 2 of 4

Data is for ively

rse

ill be 60% nts. The y grace

ent early!!!

ate

course

of 4

Requirements:

You are expected to have the proper course materials. Obtain your WebCT Account and use the WebCT. You should check WebCT at least once a week for e-mails, announcements or reminders. Successfully complete the following graded assignments

Attendance Policy:

There are five required campus attendance dates for this course – see the Schedule Please log into the course at least once a week (daily for the summer semester) to check

E-mail and the Discussion Board for announcements. An exam may be taken ahead of schedule if a work related conflict occurs. Missed Exams may be made up if I am contacted within 24 hours and a valid verified excuse* is

given. The Final Exam must be taken at a CCBC Testing Center –Make your appointment early!!!


Course Procedures

Materials: It is recommended that you purchased the textbook bundle from CCBC bookstore

The textbook bundle contains items difficult to locate elsewhere!!! Note: There are two bundles, one with a 180 Day Subscription to MS Office 2007 Professional and one without.


o Concepts of Database Management – Sixth Edition, by Pratt and Adamski o Flash Drive 256 MB (1) – 1 GB included with text if purchased new from CCBC's Bookstore.

o Access 2007 CourseNotes Card (included with textbook if purchased new from CCBC’s Bookstore)

Special Materials included in Textbook Bundle purchased from CCBC Bookstore Textbook CourseNote Card Flash Drive Trial Software

1 GB Flash Drive

MS Visio 2007 60 Day Trial

AND




of 4

Software:

MS Office 2007 Professional - 180 day subscription can be purchased with the text from the CCBC Bookstore IMPORTANT: MS Office Trial software can only be installed once on the SAME PC!!!

Internet Explorer 5.0 or higher

Adobe Acrobat Reader 8.0 or higher (free can be downloaded from www.adobe.com)

MS Visio Professional 2007 - 60 day trial cd included with text if purchased new from CCBC Bookstore

MySQL 5.0 - (open source software - Instructor will provide CD)

Special Procedures:

This is a hybrid course, which means that most of your work will be done online. Attendance is required 5 times during the semester at the Catonsville campus Room H215

See the Course Schedule for the exact dates.


Chapter Activities are designed to give you hands-on experience. They are considered practice and are not graded. You are not required to turn them in. However if you want me to review them for accuracy they must be turned in by the due date.

Graded work will be indicated as Graded Project

If necessary, Open/Homework Labs (Catonsville - H108 and Essex – N315) are available so you can complete your Learning Assignments and Graded Projects.

If you experience software difficulties completing assignments at home, you should use the Open/Homework Lab. The Hours for Open/Homework Labs are posted on the Discussion Board.

WebCT is our means of communication and project submittal. Please do NOT send e-mail and projects elsewhere.

Services for Student with Disabilities: CCBC is committed to providing equal access to educational opportunities for all students by arranging support services and reasonable accommodations for students with disabilities. A student with a disability may contact the appropriate campus office for an appointment to discuss reasonable accommodations. An appointment must be scheduled within a time period which allows staff adequate time to respond to the special needs of the student. The student must provide the appropriate office with proper documentation supporting the need for reasonable accommodations. For more information, contact:



443-840-3529 (TTY)


443-840-1601 (TTY)

Fall 2010 Page 1 of 4


SCHEDULE: Database Concepts – CINS234 WCH August 18, 2010 FINAL VERSION

This is an Overview of Course Activities see the Learning Modules for specifics!!!

Date / Module Activities

Due Date

Course Orientation Assignment: Due by midnight Wednesday September 1, 2010


Read and Do the Course Orientation Assignment

9/1/10 1

1. Chapter: 1- Introduction to Database Management Midnight 11:59pm 9/7/10

IMPORTANT: Make sure you have made 6 copies of the CINS234Data folder and

renamed each folder copy to correspond with the following chapters: Chapter2CINS234Data Chapter3CINS234Data Chapter4CINS234Data

CreateDBMSCINS234Data MySQLCINS234Data

Chapter7-9CINS234Data

Refer to Step 9b of the Course Orientation Assignment for further details

Labor Day Holiday: College Closed - September 6, 2010

9/8/10


Scheduled Activities: Download Data Files and Create 6 Folders (if students have not completed) Learn to Backup and Restore an Access Database Learn to interpret an Entity Relationship (ER) Diagram Analyze the Relational Database Model by determining Tables to use in Queries Write Queries using QBE (Query by Example) View of Access Write Queries using the SQL (Structured Query Language) View of Access

9/8/10 2

1. Lab Handout: Backing Up and Restoring a Database

2. Chapter: 2-The Relational Model 1: Introduction and QBE

3. Demo: Interpreting ER Diagrams 4. Demo: Querying with Access the Basics 5. Demo: Querying with Access SQL



Date / Module

Activities Due Date

9/15/10 3

1. Chapter: 3 - The Relational Model 2 – SQL


9/22/10 4

GRADED PROJECT – Database Query Project Midnight 11:59pm 9/28/10

9/29/10 5

1. Chapter: 4 - The Relational Model 3 – Advanced Topics


Extra Learning for Extra Credit: Worth 10 points towards the Midterm Exam Do items 1, 3, 5, 7, 10 and 11 of the Chapter 4 Henry Books Case – due 10/5/10

10/6/10

Attend the Catonsville Campus room H215 from 5:45pm – 8:40pm

Scheduled Activities: Changing MS Access 2007’s ANSI-89 SQL to ANSI-92 SQL (industry standard) Distribution of MySQL Database software Distribution of Instructions for Installing MYSQL Create Database and Tables using Script Files (*.sql) Write Queries in MySQL | Save As a Script (*.sql) file Create and Manage a Database using MySQL

10/6/10 6

1. Lab Handout: Installing MySQL (optional) 2. Lab Handout: Creating/Managing a DBMS using MySQL (optional) 3. Review for Midterm Exam


Midterm Exam: Chapters 1 – 4 Take WebCT: 234 Midterm Exam Open Textbooks / Notes


10/13/10


Scheduled Activities: - Please return the MySQL cds Lecture Chapter 5 Work with Normalization Database Design Overview

10/13/10 7

1. Chapter: 5 - Normalization



Date / Module

Activities Due Date

10/20/10 8

1. View Video: Database Design Overview 2. Lab Handout: Database Design Overview


10/27/10 9

GRADED PROJECT – Normalization


11/3/10


Scheduled Activities: Lecture on Chapter 6 Database Modeling Demonstrate creating a Database Model using Visio Complete a Tutorial: Creating a Database Model using MS Visio

11/3/10

10

1. Chapter: 6 - Design Methodology

2. Lab Handout: MS Visio 2007 Professional Example

3. Lab Handout: MS Visio 2007 Professional Tutorial


11/10/10

11

GRADED PROJECT – Logical Design

IMPORTANT: This project will not be accepted late and corrections will not be allowed


11/17/10

12

GRADED PROJECT - FINAL PROJECT Use the Official E-R Diagram that will be available on Learning Module

12 or the Handouts page on 11/17/10


Thanksgiving Holiday: College Closed November 24 - November 28, 2010

12/1/10

13

1. Chapter: 7 - DBMS Functions

2. Chapter 9: Database Management Approaches these topics: a. Client/Server Systems pages 283 – 287

b. Web Access to Databases pages 287 – 293

c. Data Warehouse and Data Mining pages 293 – 299

3. Lab Handout: Data Warehouse and Data Mining 4. Lab Handout: Creating an Excel Pivot Table Using a Cube Lab Handout

**If you must missed 12/8: Visual Studio 2008 is installed in Catonsville and Essex Open Labs



Date / Module

Activities Due Date

Extra Learning for Extra Credit: Worth 10 points towards the Final Exam Complete Reverse Engineering Lab Handout

Under the Handouts Page (Module 14) – due 12/7/10

12/8/10


Scheduled Activities: Client Server Computing Lab Handout Web Database Applications Handout

12/8/10

14

1. Review for Final Exam: Chapters 1 – 7 and 9

2. Lab Handouts: a. Client Server Computing (use Open Lab if you missed 12/8 class)

b. Web Database Applications (use Open Lab if you missed 12/8 class)

c. MySQL: Managing | Securing a Database (OPTIONAL)

3. Final Exam Available Starting Today

--

12/13/2010 Final Project Corrections (optional) Due by midnight 11:59pm

12/14/10 Final Exam Due by midnight 11:59pm Take WebCT: 234 Final Exam Open Book and Open Notes

8/17/2010 Page 1 of 3

Catonsville Campus Help Desk Management – CINS253 AC1

Final Version Basic Course Information

Semester / Term Fall 2010 Pre-requisites Completion of all required:

Technology Support or Office Specialist program courses Instructor Valerie Farmer Assistant Professor CIS Office H218 G Contact Information Phone: 443.840.4754 E-mail: [email protected] Office Hours See Discussion Board Class Hours/Location

Independent Study

Report to the Open Lab or Assigned Location The day and time you will be assigned to the labs will depend upon your schedule and the Open Lab

or Course schedule for the course you select to function as a Help Desk Professional.

Important Websites CCBC’s: www.ccbcmd.edu

Instructor’s: http://student.ccbcmd.edu/~vfarmer

Course Goals

Course Objectives: Upon completion of this course the student will be able to: 1. define Help Desk Management and Help Desk Management tools, 2. demonstrate customer service skills in role-play, 3. determine needed resources for end users, 4. analyze end user problems (hardware versus software), 5. summarize the types of services Support Centers provide, 6. define how companies develop and implement computer product standards, 7. recommend computer products based on User Needs Analysis, 8. assess end user training needs, prepare training materials, and provide training, 9. compose technical writing samples and end user documentation, and; 10. develop computer maintenance solutions for end users. Major Topics: 1. Evaluating hardware and software. 2. Performing needs assessment. 3. Providing purchase assistance 4. Providing installation assistance 5. Providing training of systems and software and evaluation of same. 6. Assessing end user skill level. 7. Providing end user documentation. 8. Providing help desk assistance and troubleshooting. 9. Providing hardware maintenance and repair. 10. Providing computer facilities management for handling (Power failures, Network troubles, Ergonomic problems, Crime and misuse Course Rationale: Technical Support professionals need technical, problem solving, communication and teamwork skills. This course will help you to develop these skills so that you can effectively help others use technology as a tool.

8/17/2010 Page 2 of 3 Course Pedagogy:

Evaluation

Requirements:

You are expected to have the proper course materials.

Obtain your WebCT Account and use the WebCT Supplement for this course.

You should check the WebCT Supplement for this course at least once a week (daily – during the summer semester) for announcements or reminders.

You are expected to use MS Office Help and other software/hardware reference resources, like www.microsoft.com to assist you in completing your assignments. Assignments should be completed independently and submitted via WebCT e‐mail.

You will be working in the Open Lab or an assigned Location for 3 hours per week (Fall and Spring semesters for 15 weeks) or 9 hours per week (Summer semester for 5 weeks) for a total of 45 hours per semester; functioning as a Help Desk professional.

You are expected to use MS Office Help and other software/hardware reference resources to assist you in helping students in the Open Lab or your assigned Classroom Lab. Currently the college is using Office 2007, Windows XP or 7 and Internet Explorer 8.

In addition if you are assigned to the Open Lab you will be expected to support myITLab 2007 (Training and Assessment software) that simulates Office 2007, Windows XP or 7 and Internet Explorer 7 or 8). I or your assigned classroom practicum instructor will provide further information about myITLab 2007 if you are completing the software practicum in the Open Lab or a CINS101 classroom.

Grading Policy:

The maximum grade on Graded Projects (Help Desk Project and Log) turned in LATE will be 60% and

corrections will NOT be allowed. Exams taken LATE will be penalized a minimum of 10 points. The one

exception to these rules is for excused* absences, in which case you will receive a one day grace period. Projects and Exams Percent of Grade Help Desk Log / Practicum 30% Midterm Exam 10% Help Desk Projects (average of 4) 30% Final Exam 30% Total 100%

You are expected to do your own work. Cheating will be considered grounds for immediate

dismissal from the course. Final Average Letter Grade

90 ‐ 100% A

80 ‐ 89% B

70 ‐ 79% C

60 – 69% D

0 ‐ 59% F

8/17/2010 Page 3 of 3 Attendance Policy:

Missed Exams may be made up if I am contacted within 24 hours and a valid verified excuse* is given.

You must contact me and your assigned instructor, prior to your appointed time in the Open Lab or assigned Location, if you will be absent. Poor attendance will negatively impact your Final Grade.

The Final Exam must be taken at a CCBC Testing Center – Please make your appointment early!!! *An excused absence is an emergency such as a death in the family, religious holidays or participation in official college functions.

Course Procedures Materials: A Guide to Computer User Support for Help Desk and Support Specialist 4rd Edition, by Beisse

If necessary purchase MS Office 2007 or 2010 Professional or download the 60 day trail: www.microsoft.com IMPORTANT: MS Office 2007 or 2010 will be needed the entire semester (120 days) for the Software Practicum Special Procedures:

You are expected to maintain an electronic Help Desk Log using Excel or Access that will track your activities while you are in the Lab performing as a Help Desk Professional.

Submit the Help Desk Log at the end of the course by the deadline.





CCBC Dundalk A Building, room 100 443-840-3774 | 443-840-3529 (TTY)

CCBC Essex A Building, room 210 443-840-1741 | 443-840-1601 (TTY)

Help Desk Log Requirements:

o Date: o Day: o Time: o Course/Section: for example - CINS101XXX, ENGL101XXX … (If assigned to the Open Lab) o Problem Type: Software or Hardware: o Software: for example - Word, Excel, Internet Explorer… o Hardware: o Problem: o Solution:

*1 Hour per week should be spent performing Small Group Tutoring if requested **Graded Projects should be e-mailed to me using the WebCT Course Supplement

Catonsville Campus

Help Desk Management – CINS253 AC1

Schedule Fall 2010 - August 17, 2010 Final Version

Week (15 weeks)/ Day (5 weeks)

Activities Due Date

8/30/10 1

1. Do Course Orientation Assignment located on Main Page of the Course under WebCT

Midnight 11:59 pm

9/1/10 2. Pick Lab Schedule (students assigned to the Open Lab) 3. Tour of the Open or Classroom Lab (Coordinate with the Instructor)

4. Read Chapters 1 and 2 5. Do Activities: 1-6a or 1-8 and 2-10not graded – no need to submit

a(You may also interview a tech support person)

Midnight 11:59 pm

9/7/10

9/7/10 2

1. Prepare a Help Desk Log: Requirements (See Last Page of Syllabus) 2. Read End User Guide Handout 3. Do Transitioning to Office 2007 and Internet Explorer 7 or 8

Handout (optional) 4. Read Chapters 3 and 4 5. Do Activities: not graded – no need to submit

3-3 or 3-8 and 4-8 or 4-9 6. Assist in the Open Lab or assigned Location as scheduled*


9/13/10 3

1. Help Desk Project 1** Graded Project (Select two) a. Chapter 1 – Case Project 3 b. Chapter 2 – Case Project 4 c. Chapter 3 – Case Project 3– download is optional d. Chapter 4 –Case Project 1 – research at least 5

If this project is submitted LATE the maximum grade is 60% and corrections will not be allowed.

2. Assist in the Open Lab or assigned Location (3 hours)*


9/20/10 4

1. Read Chapters 10 and 11 2. Do Activities: 10-6a and 11-1b not graded – no need to submit

Assist in the Open Lab or assigned Location as scheduled*

aYou might try evaluating the Demos under Office 2007 Help bSee http://cus4e.com/default.aspx | Check List and Documents Link




Activities Due Date

9/27/10 5

1. Read Chapter 5

2. Do Activities: 5-9 and 5-11 not graded – no need to submit 3. Assist in the Open Lab or assigned Location as scheduled*


10/4/10 6

1. Help Desk Project 2** Graded Project (Select two) a. Chapter 5 – Case Project 1 omit the comparison b. Chapter 11 – Case Project 2 c. Chapter 10 – Case Project 4 and 5 combined (Visio 2007 is installed in the Open Lab)


2. Assist in the Open Lab or assigned Location as scheduled*

3. Review for Midterm Exam - See the Reviews Page of WebCT

Midterm Exam Available to Start Taking Today – See Exams Page

Midnight 11:59 pm 10/11/10

10/11/10 7

Midterm Exam – See the Exams Page of WebCT Midterm Exam is Open Book and Open Notes

Work as Help Desk Professional (1.5 hours)

Midnight 11:59 pm TONIGHT 10/11/10

1. Read Chapter 6 2. Do Activities: 6-7, 6-8 or 6-9 not graded – no need to submit 3. Assist in the Open Lab or assigned Location as scheduled*

Midnight 11:59 pm 10/18/10

10/18/10 8

1. Read Chapters 7 and 8 2. Do Activities: not graded – no need to submit

7-1 or 7-9a and 8-5b

or 8-6 or 8-7 aUse this URL for 7-9 http://ccbchelpdesksupport.ccbcmd.edu/ics/support/default.asp?deptID=8106 b Use Word SmartArt: IPO use Process Shape | Flowchart use Visio or SmartDraw


Midnight 11:59 pm 10/25/10



Activities Due Date

10/25/10 9

1. Help Desk Project 3** Graded Project (Select two) a. Chapter 6 – Case Project 1 OR 2 – See Note b. Chapter 7 – Case Project 2 c. Chapter 8 – Case Project 3 OR 4

Note: Case 2 indicates that you have to go to www.erlang.com and use the Call Center Erlang Calculator. When you get to the site, you should click the Tab on the top left that reads: FREE CALCULATORS | then select CALL CENTRE CALCULATOR. You just need to fill in the values in the appropriate boxes. Under the category TRUNK BLOCKING TARGET that is where you enter the 1% for no more than 1% of the calls should be lost. You will have to enter it as a decimal.




11/1/10

10

1. Read Chapter 9 2. Do TWO of these Activities: not graded – no need to submit

9-1a, 9-3 (omit comparison), 9-4, 9-5 or 9-9 a See http://cus4e.com/default.aspx | Check List and Documents Link 3. Assist in the Open Lab or assigned Location as scheduled*


11/8/10

11

1. Read Chapter 12

2. Do Projects 12-1 and 12-3 not graded – no need to submit 3. Assist in the Open Lab or assigned Location as scheduled*

Midnight 11:59 pm 11/15/10

11/15/10

12

1. Help Desk Project 4** Graded Project (Select two) a. Chapter 9 – Case Project 4 b. Chapter 12 – Case Project 1 OR 3 OR 4 (For 12-4 indicate one-to-one or large group)



Midnight 11:59 pm 11/22/10



Activities Due Date

11/22/10 13


2. Explore Help Desk Management Software as follows a. Go to www.helpstar.com b. Click Feature Demos hyperlink c. Watch videos about the features of the software d. Select Home for the top menu e. Click the Test Drive hyperlink (to explore without downloading)

11/29/10

3. Finalize and Submit your Help Desk Log

If this Log is submitted LATE the maximum grade is 60%


Thanksgiving Holiday - College Closed: November 23 – November 28, 2010

12/6/10 14

1. Review for Final Exam – See the Reviews Page of WebCT 2. The Final Exam will be available to take starting today. 12/13/10

Final Exam

See Exam Page of WebCT – Due by Midnight 11:59 pm 12/13/10

Must be taken at CCBC’s Testing Center; book your Appointment EARLY!!!

See Testing Center Link under the CCBC Bookmarks on the Main Page of WebCT

You may use the Textbook ONLY!!!