课程教学大纲
课程:BUS 2010
部门:业务 and Applied Tech部门:业务
Title:业务 Computer Proficiency
学期批准: 2022年春季
Five-Year Review Semester: 2026年秋季
学期结束: 2027年秋季
目录描述: This course is designed for business majors and those wanting a thorough knowledge of spreadsheets and databases. Students will use the current version of Microsoft Excel and Access. The course will cover introductory to intermediate database and spreadsheet concepts. Students will complete an integrated project using both applications to summarize data that can be analyzed to make decisions. To be successful in the class, students should have a basic understanding of computer applications and file management. BUS 1020 is recommended as a prerequisite. Successful mastery of BUS 2010 and CS 1520 will qualify you for the 雪的大学 'Foundations of Data Analysis' internal certificate. (Additional fee required)
学期提供:稍后通知
Credit/Time Requirement: Credit: 3; 讲座: 3; Lab: 0
先决条件: N/A
并修课程: N/A
的理由: This course is required for the ASB and prepares students for job readiness and/or transfer to a university. The course meets the requirements as agreed upon by the UBAAN state committee (articulation committee for the ASB) and is accepted at many state institutions.
Student Learning Outcomes:
Students will use a variety of spreadsheet and database features to effectively organize and manage data. Students will be assessed through hands-on training, assignments, exams, and/or projects. Feedback is provided through an online skills assessment manager and/or rubrics and instructor comments.
Students will use formulas and functions in database and spreadsheet software for efficiency and accuracy in summarizing data. Students will be assessed through hands-on training, assignments, exams, and/or projects. Feedback is provided through an online skills assessment manager and/or rubrics and instructor comments.
Students will perform appropriate analyses of quantitative and qualitative data using spreadsheet and database software. Students will be assessed through hands-on training, assignments, exams, and/or projects. Feedback is provided through an online skills assessment manager and/or rubrics and instructor comments.
Students will use spreadsheet and database features to complete an integrated project and deliver quality documents using professional standards. Students will be assessed through projects and/or a signature project and reflection. Feedback is provided through rubrics and instructor comments.
内容:
Course objectives will be accomplished with learning experiences in the following areas:
Excel -电子表格
General applications: e.g., 插入, 名字, and reference worksheets; apply the order of operations; use absolute, 相对, and mixed cell references; apply numeric formats, 细胞排列, 风格, 边界, 阴影
专业技能:.g., create and modify a variety of charts; use advanced filters and sort multiple fields; nest functions (If, 和, Or, VLookup, HLookup, 小计, 等.); use 条件格式, 切片机, 微线图, databars; apply table features; use what-if and data analysis tools; create PivotTables, and PivotCharts; use 名字d ranges, connect to external data
访问-数据库
General applications: e.g., 创建表, 查询, 形式, and reports using Wizards; apply themes, 条件格式, and alignment; sort, 找到, 并过滤记录;
专业技能:.g., 自定义表, 查询, 形式, and reports; edit field types and properties; create primary keys and relationships; create action 查询; import and export data
不同的问题
Teaching resources will be representative of real-world applications. Students will 找到 relevance in their learning by using current technology to organize, 分享, and analyze a variety of case-related information.
Key Performance Indicators:
Student performance is assessed in the following areas:
Participation 0 to 10%
Assignments - Training and Projects 30 to 40%
Capstone Projects and Exams 30 to 50%
Final Project- Signature and Reflection Assignments 10 to 20%
Representative Text and/or Supplies:
Cengage Microsoft Office, New Perspective Series for Excel and Access, current edition or equivalent text(s); Cengage SAM (Skills Assessment Manager) - an online training resource. SAM provides instant feedback and simulates the MS Office environment. (current version or equivalent)
教育学声明:
The course will be delivered through in-class demonstration and/or video, hands-on simulated training and practice using software applications, 性能项目, and reflection assignments.
包容性
Accessibility features, 包容的访问, and low-cost options will be considered in the selection of course materials to increase access and reduce barriers.
Students will work on a variety of formative low-stakes assignments to gain confidence in their skills before performing summative high-stakes assessments. Students may have the opportunity to form study groups and/or use discussion boards to ask questions and post content to build a sense of community.
教学手段:
讲座
在线
混合动力
最大班级人数: 24
最佳班级规模: 20