Course Proposals Course Name: Business Computer Skills  Course Prefix: IST Course Number: 2010              Submitted by (Name & E-Mail):  Ed Harris, edharris@weber.edu Current Date:  3/2/2010 College: Business & Economics Department:   Info Systems & Tech                               From Term: Fall  2010  Substantive change  Current Course Subject IST Current Course Number 2010   IST TE2010. Business Computer Skills (1) Su, F, S This is a one-credit course where all students in business and economics 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 cover computer competencies students will use in their business functional and cross-functional core courses. 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 LIBS TD2704, or LIBS TD1704, or TBE TD1504) 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. New/Revised Course Information: Subject:  IST             Course Number: 2010 Check all that apply:     This is for courses already approved for gen ed.     Use a different form for proposing a new gen ed designation. DV  SI  CA  HU  LS  PS  SS  EN  AI  QL  TA  TB  TC  TD  TE Course Title: IST TE2010. Business Computer Skills Abbreviated Course Title: Business Computer Skills Course Type:  LEC Credit Hours:  3  or if variable hours:    to Contact Hours: Lecture 42  Lab    Other Repeat Information:  Limit 0   Max Hrs 0  Grading Mode:  standard This course is/will be: a required course in a major program a required course in a minor program a required course in a 1- or 2- year program elective Prerequisites/Co-requisites: 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 description (exactly as it will appear in the catalog, including prerequisites): IST TE2010. Business Computer Skills (3) Su, F, S 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 LIBS TD2704, or LIBS TD1704, or TBE TD1504) 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. 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 faculty 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 for substantive proposals only 1. Did this course receive unanimous approval within the Department? true If not, what are the major concerns raised by the opponents? 2. If this is a new course proposal, could you achieve the desired results by revising an existing course within your department or by requiring an existing course in another department? This is a revision of an existing course. 3. How will the proposed course differ from similar offerings by other departments? Comment on any subject overlap between this course and topics generally taught by other departments, even if no similar courses are currently offered by the other departments. Explain any effects that this proposal will have on program requirements or enrollments in other department. Please forward letters (email communication is sufficient) from all departments that you have identified above stating their support or opposition to the proposed course. Telecommunications & Business Education (TBE) Department offers an Introductory MS-Office course (TBE TE1700. Introduction to Microcomputer Applications) which is a prerequisite for IST 2010. TBE also offers: Introductory DataBase Course (TBE 2080 - 1 Cr.); Advanced Word (TBE 3000 - 1 Cr.); Advanced Excel (TBE 3730 - 1 Cr.); Advanced PowerPoint (TBE 3090 - 2 Cr.). We do not believe the revision of this course will effect other departments. 4. Is this course required for certification/accreditation of a program? no If so, a statement to that effect should appear in the justification and supporting documents should accompany this form. 5. For course proposals, e-mail a syllabus to Faculty Senate which should be sufficiently detailed that the committees can determine that the course is at the appropriate level and matches the description. There should be an indication of the amount and type of outside activity required in the course (projects, research papers, homework, etc.).

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

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