EXCEL课程设计报告

武汉科技大学城市学院课程设计报告课程名称EXCEL在管理中的应用题目公司人事管理系统学部经济与管理学部专业人力资源管理班级10级1班姓名李露覃雪丹唐丹邢莉指导教师张莉2012年12月13日学号201010172129201010172131201010172130201010172132武汉科技大学城市学院课程设计报告EXCEL在管理中的应用课程设计安排设计时间2012年12月10日至2012年12月15日课程设计题目武汉华兴公司人事管理系统设计任务总述运用EXCEL相关知识设计一个华兴公司人事管理系统，然后撰写出整个的设计报告。课程设计要求根据老师已给定的人事管理系统这一题目进行操作，根据已知的背景资料，设计出一个完善的人事管理系统。按照既定的设计要求，小组成员在完成分组讨论之后，确定本组的设计方案，完成本组系统设计，最后撰写出设计报告。工作计划及安排日期设计内容12月10日了解企业背景和相关的任务和要求初步规划华兴公司人事管理系统的方案。12月11日优化方案，制定出相应的计划流程，开始分工。12月12日根据各模块需要的表格和资料，着手整理和制作表格。12月13日完成考勤管理和绩效管理两个子系统12月14日完成薪资管理，人事管理两个子系统12月15日将各自的模块整合，调试优化系统，打印课程设计报告。指导教师意见签字：__________年月日武汉科技大学城市学院课程设计报告1需求分析······································································································11.1课程的题目························································································11.2课程设计目的·····················································································11.3课程设计安排·····················································································11.4课程设计的思想··················································································22概要设计····································································································32.1课程设计的总体内容············································································32.2各模块设计与实施···············································································32.3参数设置及数据导入············································································32.4数据加工处理描述···············································································43详细设计···································································································43.1华兴公司人事管理系统首页设计·····························································43.1.1华兴公司组织结构······································································53.2员工满意度调查··················································································63.2.1员工满意度调查问卷···································································63.2.1员工满意度统计调查结果·····························································73.2.2员工满意度结果分析数据透视表····················································83.3员工工资管理·····················································································93.3.1工资明细表···············································································93.3.2加班与考勤表···········································································113.3.3出差统计表··············································································123.3.4绩效与考核表···········································································123.4组织机构设置·····················································································123.4.1员工信息查询表········································································133.4.2员工工资查询表········································································133.4.3员工工资条··············································································143.5员工档案管理····················································································143.5.1新进员工登记表········································································143.5.2新进员工登记汇总表··································································153.5.3新进员工培训成绩表··································································153.5.4新进员工培训成绩分析透视图······················································163.5.5员工基本信息统计表································································163.6参数设置及说明·················································································17总结与体会·····································································································20致谢···········································································································21参考文献········································································································21武汉科技大学城市学院课程设计报告1EXCEL在华兴公司人事管理系统中的应用摘要武汉华兴科技股份有限公司，成立于1997年7月1日，系一家高科技的制造型企业，公司的管理机构采用多层次管理机构，设有董事长，下设总经理，总经理下设有人事总监、研发部总监、生产部经理、销售部总监、市场推广部总监、财务部总监。1需求分析1.1课程的题目EXCEL在华兴公司人事管理系统中的应用1.2课程设计目的《EXCEL在管理的应用》课程设计是管理类专业集中实践训练的一个环节，是在完成《EXCEL在管理中的应用》课程学习后进行的一次全面综合的练习。其目的在于加深对EXCEL在管理中基础理论和基本知识的理解和应用，能运用EXCEL技术及信息系统分析的基本方法，解决实际管理问题、开发信息管理的实践能力。本次课程设计以学生认知为主体，充分调动学生的积极性和能动性，重点培养学生自我分析问题和解决问题的能力。1.3课程设计安排根据上表的课程设计安排，我们以宿舍为单位，采取分工合作来完成此次的设计。我们首先讨论了这次设计的任务要求，然后拟出了设计大纲，把它分成了五大模块。界面设计，工作表合成最终系统和员工满意度调查问卷，考勤管理，绩效管理，武汉科技大学城市学院课程设计报告2薪资管理，人事管理等模块。我们根据各自的长处，分配好任务。1.4课程设计的思想EXCEL是微软公司开发的一个功能强大，技术先进，使用方便的表格式数据系统，是办公人员公认的数据管理分析工具。利用EXCEL工作表可以进行各种统计，报表分析及图形分析等操作，同时EXCEL凭借其自身丰富的计算工具，分析工具以及灵活多样的表达形式，轻松地帮助用户建立管理模型与分析模型，并且通过自身功能对数据进行高效准确的管理分析。EXCEL在人事管理中应用也相当广泛，它强大的数据处理与分析能力，为人事管理中人员信息数据进行分析，使人尽其才，人岗匹配。武汉科技大学城市学院课程设计报告32概要设计2.1课程设计的总体内容图2.1课程设计的总体内容2.2各模块设计与实施各模块设计主要是对工作表与工作表之间的逻辑关系加以界定，对单个工作表的信息内容加以定义和要求，特别是要设计好系统运行所需的列标识信息及其之间的勾稽关系。2.3参数设置及数据导入为了让人事管理系统的员工更好的操作和理解整个系统的运行，参数设置主华兴公司人事管理系统员工满意度调查问卷员工工资管理组织机构设置员工档案管理参数设置及说明员工满意度调查问卷员工满意度统计调查结果工资明细表加班与考勤表绩效与考核表出差统计表组织结构图员工信息查询表员工工资查询表员工工资条新进员工登记表新进员工汇总表新进员工培训成绩表新进员工培训成绩分析透视图员工基本信息统计表武汉