Digital Knowledge Analysis Curriculum
|Course Code||Title||Course Outlines||Goal Areas||Credits|
|CIS 1101||Business Computer Systems I or||View-CIS 1101||n/a||3|
|CSCI 1000||Computer Basics and||View-CSCI 1000||n/a||3|
|CIS 1240||Information Management: Access and||View-CIS 1240||n/a||3|
|CSCI 1040||Fundamentals of Structured Query Language (SQL) and||View-CSCI 1040||n/a||3|
|CIS 1220||Decision Making Excel||View-CIS 1220||n/a||3|
Course Title: Computer Basics Goal Areas: n/a Credits: 3
Course Description: The students will get hands-on experience with an operating environment (the current version of Microsoft Windows) and Windows-based applications which include spreadsheets, word processors and presentation packages. The course enables students to use computers to process information and communicate using e-mail and World Wide Web.
Course Title: Fundamentals of Structured Query Language (SQL) Goal Areas: n/a Credits: 3
Course Description: The goal of this course is to teach students how to design, build and use databases utilizing Microsoft SQL Server. The students will also learn to enter and retrieve information. They will learn SQL commands and query creation, including complex multi-table joins, and display and analyze query results. Students will design their own databases and deploy them on Microsoft SQL Server.Possessing skills in performing common Windows tasks working with applications, or taking CSci 1000, is highly recommended.
Course Title: Business Computer Systems I Goal Areas: n/a Credits: 3
Course Description: This course develops computer and digital literacy and emphasizes its importance in today's businesses and society. Through hands-on experience students will gain an understanding of computer concepts, capabilities and applications and be able to implement this knowledge in their professional and personal lives. Computer applications covered include word processing, spreadsheets, presentation graphics, databases, windows/operating system, e-mail use and management, folder and file organization and use of the Internet. Computer concepts covered include understanding computers and mobile devices, how a computer works, managing files, computer and mobile device hardware components, digital safety and security, application programs, input and output devices, digital storage options, ethical practices and Internet basics. Hands-on experience will be provided on computers in the Windows environment using the Microsoft Office Suite including Word, Excel, Access, and PowerPoint. Knowledge of the keyboard is recommended for this course. Check with your instructor for the software edition that will be used.
Course Title: Decision Making Excel Goal Areas: n/a Credits: 3
Course Description: This course uses Microsoft Excel as a problem solving tool in analyzing and designing solutions for common business and organizational problems and then using that information to guide decision-making. This course is for anyone who has to analyze, share, chart and manage information to make more informed decisions. Problems are taken from management, accounting and finance, manufacturing and production, sales and marketing and human resources. Beginning to advanced spreadsheet concepts covered include creating, editing, formatting, printing and saving worksheets, creating charts, filtering lists, creating pivot tables, inventing macros, importing data, creating data tables, evaluating and using functions, constructing formulas, integrating worksheet data with other programs and ethical Excel practices. After this course, the student would be prepared to take the Microsoft Office Specialist (MOS): Excel Exam. Knowledge of the keyboard is recommended for this course. Check with your instructor for the software edition that will be used.
Course Title: Information Management: Access Goal Areas: n/a Credits: 3
Course Description: In this course students will learn how to plan, design, create, query, create forms and reports, export to and import data from and maintain a database. This course is for anyone who has to make more informed decisions by effectively tracking, reporting, and sharing information. Applications will be taken from a variety of business and organizational scenarios. Students will integrate databases with Excel and Word. Students will learn how databases interact with other applications (including the Internet) and can become the foundation for an e-commerce web site. Students will develop an understanding of how an effective database supports the business decision-making process. After taking this course, the student would be prepared to take the Microsoft Office Specialist Exam for Access. Completion of CIS 1101 or prior database experience is recommended for this course.
|Total Credits Required||12|
- Create, format, analyze, and present documents such as Word documents, Excel documents, Access documents, and PowerPoint presentations to effectively communicate in business in accordance with professional standards.
- Analyze data presented in business cases requiring information management effectively using Access to create databases to show information in a variety of formats.
- Use SQL Server integrated information for query building by analyzing the results.
- Develop, analyze, and evaluate spreadsheets using advanced technical skills. Students will think critically, independently, creatively and resourcefully to apply knowledge to solve new problems and provide information to guide business decision making, complete real world business tasks, use ethical practices and communicate results.
Certificates may be earned for successful completion of courses in a specialized program of study with a minimum grade point average of 2.00 (C). A certificate shall include 9 to 30 semester credits. At least one third of the total credits required for each certificate must be completed at North Hennepin Community College.
Developmental Courses Some students may need preparatory course(s) in Math and/or English. Courses numbered below 1000 will not apply toward a degree.
Equal Opportunity Employer and Disability Access Information North Hennepin Community College is a member of Minnesota State Colleges and Universities system and an equal opportunity employer and educator. This document is available in alternative formats to individuals with disabilities by calling 7634930555 or through the Minnesota Relay Service at 18006273529.
North Hennepin Community College is accredited by the:
Higher Learning Commission of the North Central Association of Colleges and Schools
30 N. LaSalle Street, Suite 2400
Chicago, IL 60602-2504