PROGRAM CHANGES
WEBER STATE UNIVERSITY

Submission Date:                                           March 2010

Semester and Year Program Begins:          Fall 2010

College:                                                          Goddard School of Business & Economics

Department:                                                   Information Systems & Technologies

PROGRAM CHANGE DESCRIPTION: 

1. Change IST 2010 from 1 credit hour to 3 credit hours.
2. Change IST 2010 from a CR/NC to a graded course.

Check all that apply: 

____New course(s) required for major, minor, emphasis, or concentration.

   X  Modified course(s) required for major, minor, emphasis, or concentration.

   X  Credit hour change(s) required for major, minor, emphasis, or concentration.

   X  Credit hour change(s) for a course which is required for the major, minor, emphasis, or concentration.

____Attribute change(s) for any course.

____Program name change.

____Deletion of required course(s).

____Other changes (specify) _________________________________________________________________

If multiple changes are being proposed, please provide a summary.   Use strikeout (strikeout) when deleting items in the program and highlight (highlight) when adding items.

Submit the original to the Faculty Senate Office, MC 1033, and an electronic copy to kbrown4 @weber.edu

JUSTIFICATION:

1.      Every other college and university in the state of Utah requires a 3 credit hour business 2010 computer literacy course.  7 of the 11 colleges and universities use the 2010 course number.  We propose enhancing this course by adding more complex features of the software programs used to better prepare our business students in their academic coursework and maintain our articulation agreements.  See Appendix C for 2010 articulations.

2.      All except 2 of our IST courses (IST 2010 & IST 2015) are at least three-hour courses (Item 1 would also change IST 2010 to 3 credit hours).

3.      MS-Office 2010 will be released this year with added features that students can use in their educational process, and later in the workplace.

4.      A survey of Goddard School of Business & Economics was recently conducted with the following areas requested that students be familiar that are not presently covered in IST 2010 (some items suggested will be incorporated in IST 3110 instead):

a.       Identity Theft

b.      Cookies

c.       Blogs

d.      HTML

e.        Integration of Data Between Office Applications

f.       Intrusion Detection

g.      Suspicious File Attachments

h.      Creating PDF Files in Office

i.        Zip Files

j.        Expert Systems in Excel

k.      Pivot Tables

l.        Printscreen Save

m.    Embedded and Linked Spreadsheets & Graphs

n.      Track Changes

o.      Compare Documents

p.      Advanced Database Queries

q.      SmartArt Graphics

r.        Reveal Formatting

s.       Section Breaks

t.        Advanced Table Formatting & Sums, Avg, etc.

u.      Advanced Charting

v.      Inserting Shapes and Callouts

w.    Advanced Desktop Publishing Skills & Creating a Professional Newsletter

x.      Creating a Pull-Down Textbox

y.      Advanced Excel Functions

z.       Creating an Amortization Schedule

aa.   Protect & Hide Data in Excel

bb.  Vlookup to Determine Letter Grades

cc.   Import & Export Data from Access, Excel, Word

dd. Display Automatic Subtotals in a Table

ee.   Using Images in a Worksheet Chart

ff.    Using Advanced Macros

INFORMATION PAGE

Attach a copy of the present program from the current catalog and a revised version (exactly as you wish it to appear in the catalog).

See Appendix A.

Did this program change receive unanimous approval within the Department? YES   If not, what are the major concerns raised by the opponents?

Explain any effects this program change will have on program requirements or enrollments in other departments including the Bachelor of Integrated Studies Program.  In the case of similar offerings or affected programs, you should include letters from the departments in question stating their support or opposition to the proposed program.

At the request of Ed Harris from the IST Department, Al Talbot from the TBE Department sent an email which is attached as Appendix B.  TBE 1700 or equivalent knowledge will remain the prerequisite.  TBE 1700 uses the Course Technologies Introductory textbook, and the proposed IST 2010 will just continue on using the Advanced textbook from the same publisher, and the same authors.  The chapter numbers just continue on from the Introductory textbook to the Advanced textbook.  So for example the Introductory textbook covers Excel chapters 1-3, then in the Advanced textbook it continues on with chapters 4-6.

Greg Anderson from CS did not receive the email from the IST Department, with the attached proposal.  It was re-sent 3/1/2010, and his comments will be included.

Indicate the number of credit hours for course work within the program.  (Do not include credit hours for General Education, SI, Diversity, or other courses unless those courses fulfill requirements within the proposed program.) *, **        

 ** Total hours may differ depending on specific classes taken when options are given, and if TBE 1700 is listed as required, or accurately listed a prerequisite for IST 2010.

Indicate the number of credit hours for course work within the current program. (Do not include credit hours for General Education, SI, Diversity, or other courses unless those courses fulfill requirements within the current program.) ____

 Appendix A: Proposed Catalog Changes

IST TE2010. Business Computer Skills (13) Su, F, S

This is a one-credit course prepares where all students in business and economics to demonstrate current competence in desktop software commonly used in the business environment. The course involves a series of self-paced lessons on the web that covers computer competencies students will use in their business functional and cross-functional core courses, using more complex features of desktop software. It is followed by a hands-on exam that tests these competencies. With a couple of exceptions, students may do the online review lessons and take the exam at their own pace during the semester (students should review the syllabus to note the exceptions). Completion of IST TE2010 and an Information Literacy course (BSAD TD2704 or TBE TD1504 or LIBS TD2201 or LIBS TD2704) meets the WSU computer and information literacy requirement. Prerequisite: TBE TE1700 or equivalent knowledge. To establish equivalent knowledge, take the Prerequisite Assessment accessed from the IST TE2010 link: http://www.weber.edu/SBE/IST_2010_Prerequisite.html.

Appendix B: Email from Alden Talbot

From:               Alden TALBOT

To:                    HARRIS, Ed

Date:                11/19/2009 4:18 PM

Subject:            Re: IST 2010

Thanks for going from CR/NC to a graded course.   

Thanks also for directing your students by having TBE 1700 or equivalent as a prerequisite for your IST 2010 course. 

Again, we would be glad to make some adjustments to our Introductory DataBase Course (TBE 2080 - 1 Cr.), our Advanced Word (TBE 3000 - 1 Cr.), our Advanced Excel (TBE 3730 - 1 Cr.), and our Advanced PowerPoint (TBE 3090 - 2 Cr.) to make any or all of those courses work for your students.

I realize that you are looking at an intermediate course as far as Word, Excel, and PowerPoint are concerned, even using the same book/books we use but going through only chapter 6 in each area where we go through chapter 9.

We would also be glad to custom design a course to meet the School of Business needs if that should be your desire.

Alden A. Talbot

TBE Department

Weber State University

Ogden, UT 84408-1408

(801) 626-6060

atalbot@weber.edu

Appendix C:  2010 Articulations

Appendix D:  Letters of support from 3 local organizations 

January 12, 2010

Dr. Harris,

Please add my voice to the vote to increase WSU’s Office 2010 course from 1 to 3 credits.

Microsoft Office is one of the primary business applications for most organizations like CR England.  Proficiency with spreadsheet, presentation and word processing software is expected and essential in today’s business environment. 

Additionally, I am enrolled in a Master’s program at Westminster College.  Students are expected to be highly proficient in all three software applications.  Having a basic to intermediate level of proficiency with Microsoft Office is crucial for IT and Business professionals and students. 

For these reasons, I’m requesting the IS&T Department at Weber State reassess their current Office course and expand the instruction and education to students, increasing the credit hours to three. 

Thank you for your consideration,

Paul Erickson

Director Information Technology

CR England

4701 west 2100 south

Salt Lake City, UT  84120

801-977-5736

paule@crengland.com

From:                     "Kevin Van Ausdal" <kvanausdal@utah.gov>

To:                           <edharris@weber.edu>

Date:                       1/11/2010 4:27 PM

Subject:                  Office 2010 Course Input

Ed,

Just tossing in my support for an increase in credit hours for the Office 2010 course.  I do this expressing my personal opinion since I can't speak officially for my organization.  The best way to express this view may be by sharing a recent experience.

Not long ago we re‑hired a developer who last worked with us over 10 years ago.  She had been doing other types of work in the interim but was quickly able to refresh her developer skills to handle the assignments sent her way.  Recently, however, she was asked to evaluate the potential for some commercial software to replace a custom developed system that would otherwise need a major overhaul.  As we sat through the presentation of her recommendations, many saw Powerpoint do things they did not know were possible.  Her use of this tool made the entire presentation more effective and several complimented her efforts at the end.  Since a key factor in the success of our IT staff involves effectively communicating with their customers, better knowledge of Office tools and their capabilities is helpful!  It certainly was in this situation.

I might add that I often wish my developers were more familiar with Microsoft Excel.  There are often times when the best answer to a customer's request is a data extract loaded into Excel the customer can then manipulate.  Perhaps the developer could even use Excel themselves to directly access the data and use it to evaluate the integrity of the data.  I notice that staff who have been exposed to these tools are usually more effective and produce better products because of that background.

I hope this is helpful and would encourage support for an increase in credit hours.

Kevin Van Ausdal

IT Director, Utah State Tax Commission

kvanausdal@utah.gov

MANAGEMENT & TRAINING CORPORATION

500 N. Marketplace Drive * P.O. Box 10 * Centerville, UT 84014

801/693-2600 * Fax 801/693-2900

Ed,

I am writing you this letter in support the need for the increasing the credit hours from 1 to 3 for the Office 2010 course.

Staff in most companies do not have the required skills with Office products and do not spend time nearly as productively as they would if they were more proficient with Word, Excel, PowerPoint and other common software.  If someone only has basic knowledge of these products, they still get the job done, however they do it in a more complicated and time consuming way than if they knew the relevant features.  GSBE graduates should be even more proficient than other staff.

Even with the prerequisites, it is hard to believe that 1 credit hour would give enough time to much more than scratch the surface of the software.

Have a happy new year!

Rick Widner

Director, Network Administration

Management & Training Corporation

Phone: (801) 693-2632 Fax: (801) 693-2900

E-mail: Rick.Widner@mtctrains.com

Appendix E:  Syllabus

IST TE2010. Business Computer Skills (3) Su, F, S

Instructor:

Office:

Phone:

E-mail:

Website:

Course Description:

This course prepares all students in business and economics to demonstrate current competence in desktop software commonly used in the business environment. The course covers computer competencies students will use in their business functional and cross-functional core courses, using more complex features of desktop software. It is followed by a hands-on exam that tests these competencies. Completion of IST TE2010 and an Information Literacy course (BSAD TD2704 or TBE TD1504 or LIBS TD2201 or LIBS TD2704) meets the WSU computer and information literacy requirement. Prerequisite: TBE TE1700 or equivalent knowledge. To establish equivalent knowledge, take the Prerequisite Assessment accessed from the IST TE2010 link: http://www.weber.edu/SBE/IST_2010_Prerequisite.html.

Course Objectives:

• To go beyond the fundamentals and offer an in-depth presentation to Microsoft Office Word 2010, Microsoft Office Excel 2010, Microsoft Office Access 2010, Microsoft Office PowerPoint 2010, Microsoft Office Outlook 2010, and Microsoft Office 2010 Integration.

• To expose students to practical examples of the computer as a useful tool

• To acquaint students with the proper procedures to create and enhance documents, worksheets, databases, and presentations suitable for coursework, professional purposes, and personal use

• To help students discover the underlying functionality of Office 2010 so they can become more productive

• To develop an exercise-oriented approach that allows learning by doing

Text/Materials:

Text: Microsoft Office 2010: Advanced Concepts and Techniques

Microsoft® Office 2010: Advanced Concepts and Techniques, 1st Edition

Gary B. Shelly   |  Thomas J. Cashman   |  Misty E. Vermaat

ISBN-10:1418843326  |  ISBN-13:9781418843328  |  1120 Pages  |  Paperbound  |  © 2010  | Published

Teaching Methods:

1. IST 2010 is proposed to be offered as (1) online courses, (2) hybrid courses, (3) face-to-face courses
2. Lectures: Important material from the text and outside sources will be covered in class. Students should plan to take careful notes as not all material can be found in the texts or readings. Discussion is encouraged as is student-procured outside material relevant to topics being covered.
3. Assignments: End of chapter activities and online activities will be assigned weekly to reinforce material in the text. These assignments may require the application of various software packages.
4. Quizzes: Occasional unannounced quizzes will be given to help ensure students stay up with assigned material.
5. Exams: Three exams will be given. The exams will be closed book/notes and will test assigned readings and material discussed in class. Review sheets will be provided prior to the exam day. The final exam will not be comprehensive in nature. However, the instructor reserves the right to retest on material that was not appropriately comprehended. These items will be noted on exam review sheets.
6. Participation: Student participation will be graded by the level of class participation and attendance. 

Grading:

Total points will be computed as follows. The total points for quizzes, cases, and assignments may vary.

Exam #1: 100

Exam #2: 100

Exam #3: 100

Assignments: 150

Participation: 20

Total: 520 Points

Point System: 520 total assigned points

A             >= 468

B             >= 416

C             >= 364

D             >= 312

Course Policies:

Missed Classes: The student is responsible for obtaining material distributed on class days when he/she was absent. This can be done through contacting a classmate who was present or by contacting the instructor during his office hours or other times. Missed or late quizzes can not be made up under any circumstances but with good cause and adequate notice, an early quiz may be given. One quiz (lowest score) will be dropped at the end of the semester.

Assignments: All assignments are due at the beginning of class on the date due. Late submission of assignments will be assessed a penalty of 10% per day. No exceptions are made.

Academic Dishonesty: Plagiarism and cheating are serious offenses and may be punished by failure on exam, paper or project; failure in course; and or expulsion from the University. For more information refer to the "Academic Dishonesty" policy in the University Undergraduate Catalog.  For this class, it is permissible to assist classmates in general discussions of computing techniques. General advice and interaction are encouraged. Each person, however, must develop his or her own solutions to the assigned projects, assignments, and tasks. In other words, students may not "work together" on graded assignments.

Need for Assistance: If you have any condition, such as a physical or learning disability, which will make it difficult for you to carry out the work as I have outlined it, or which will require academic accommodations, please notify me as soon as possible.

Internet Support: Check the class Web page for additional information about Office 2003, or to post a question about this course.

Posting of Grades: Final grades will not be posted. If you wish to have your final grade sent to you, please bring a self-addressed, stamped envelope to the final exam.

Incomplete Policy: Students will not be given an incomplete grade in the course without sound reason and documented evidence as described in the Student Handbook. In any case, for a student to receive an incomplete, he or she must be passing and must have completed a significant portion of the course.

Course Outline

Assignment Descriptions:

Learn it Online (LIO): Learn It Online is a series of online student exercises that test your knowledge of chapter content and key terms.

Apply Your Knowledge (AYK): Apply Your Knowledge is a student assignment that helps you to reinforce the skills and apply the concepts you learned in this chapter.

Extend Your Knowledge (EYK): Extend Your Knowledge is a student assignment that challenges you to extend the skills you learned in this chapter and to experiment with new skills. You may need to use Help to complete the assignment.

Make It Right (MIR): Make It Right is a student assignment that requires you to analyze a presentation and correct all errors and/or improve the design.

Cases and Places (CP): Cases and Places is a series of student assignments where you apply your creative thinking and problem solving skills to design and implement a solution In the Lab (Lab): In the Lab is a series of student assignments that ask you to design and/or create a presentation using the guidelines, concepts, and skills presented in this chapter. The assignments are listed in order of increasing difficulty.

Learning Outcomes:

Microsoft Word 2010
4. Creating a Document with a Title Page, Table, Chart, and Watermark
5. Generating Form Letters, Mailing Labels, and Directories
6. Creating a Professional Newsletter
Integration Feature: Linking an Excel Worksheet and Chart to a Word Document

Microsoft Excel 2010
4. Macros, Financial Functions, Pivot Tables, Data Tables, and Amortization Schedules
5. Creating, Sorting, and Querying a Table
6. Creating Templates and Working with Multiple Worksheets and Workbooks
Graphics Feature: SmartArt and Images

Microsoft Access 2010
Access 2010.
1. Creating and Using a Database.
2. Querying a Database.

 

Microsoft PowerPoint 2010
3. Creating a Presentation with Custom Backgrounds and SmartArt Diagrams
4. Working with Information Graphics
Collaboration Feature: Collaborating on and Delivering Presentations

Microsoft Outlook 2010
2. Managing Calendars and Instant Messaging

Microsoft Integration 2010
Microsoft Office 2010 Integration Case Studies

Appendices
A: Project Planning Guidelines
B: Introduction to Microsoft Office 2010
C: Microsoft Office 2010 Help
D: Publishing Office 2010 Web Pages to a Web Server
E: Customizing Microsoft Office 2010
F: Steps for the Windows XP User
G: Microsoft Business Certification Program