{"text_format":"3","workbook":"xls","n_sheets":3,"sheets":["Sheet1","Sheet2","Sheet3"],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Sheet1","index":0,"n_rows":100,"n_cols":10,"rows_kept":100,"merged":[[0,0,0,9],[1,0,1,1],[1,2,1,4],[1,5,1,9],[2,2,2,4],[2,5,2,9],[5,0,15,0],[5,9,15,9],[16,0,16,9],[17,0,28,0],[17,9,28,9],[29,0,29,9],[30,0,36,0],[30,9,36,9],[37,0,37,9],[38,0,47,0],[38,9,47,9],[48,0,48,9],[49,0,56,0],[49,9,56,9],[57,0,57,9],[58,0,72,0],[58,9,72,9],[73,0,73,9],[74,0,83,0],[74,9,83,9],[84,0,84,9],[85,0,94,0],[85,9,94,9],[95,0,95,9],[96,0,99,0],[96,9,99,9],[100,0,100,9]],"flags":["formulas_cached_only"]}
["MOOC课程设计表（编制日期：2016.8.22  ）"]
["课程名称：《会计电算化》",null,"课程负责人：牛永芹",null,null,"课程所在系部：安徽商贸职业技术学院会计系"]
["一级结构","二级结构","视频内容",null,null,"非视频内容"]
["（模块）","（小节）","内容","时长","特殊要求","教学资料","随堂测验","课后测验","课堂讨论","作业"]
["欢迎模块",null,"介绍课程内容，学习目标，授课教师个人履历，测验及作业，课程考核等内容","5'"]
["模块1\n(发布时间：2016-9-01 10:00)","1.1 企业背景资料","视频1.1企业背景介绍","5'",{"$nulls":5},"增加用户\n建立账套\n分配权限\n输出账套"]
[{"$nulls":5},"本单元PPT教案"]
[null,"1.2 增加用户","视频1.2增加用户","5'",{"$nulls":3},"增加三个用户","删除用户"]
[{"$nulls":5},"本单元PPT教案"]
[null,"1.3建立账套","视频1.3建立账套","8'",{"$nulls":3},"建立账套"]
[{"$nulls":5},"本单元PPT教案"]
[null,"1.4设置用户权限","视频1.4设置用户权限","8'",{"$nulls":3},"设置三个用户权限","数据权限控制"]
[{"$nulls":5},"本单元PPT教案"]
[null,"1.5账套管理","视频1.5账套输出与引入","7'",{"$nulls":3},"输出账套","删除账套"]
[{"$nulls":5},"本单元PPT教案"]
[]
[]
["模块2\n(发布时间：2016-9-01 10:00)","2.1设置机构人员档案","视频2.1设置机构人员档案","6'",{"$nulls":3},"设置部门档案\n   人员类别\n   人员档案",null,"设置机构人员档案\n设置客商信息\n设置存货信息\n设置财务信息\n设置收付结算\n设置单据"]
[{"$nulls":5},"本单元PPT教案"]
[null,"2.2设置客商信息","视频2.2设置客商信息","6'",{"$nulls":3},"设置客户档案\n         供应商档案"]
[{"$nulls":5},"本单元PPT教案"]
[null,"2.3设置存货信息","视频2.3设置存货信息","8'",{"$nulls":3},"设置存货分类\n        计量单位\n        存货档案","存货属性"]
[{"$nulls":5},"本单元PPT教案"]
[null,"2.4设置财务信息","视频2.4设置财务信息","8'",{"$nulls":3},"设置凭证类别\n        会计科目\n        项目","受控科目"]
[{"$nulls":5},"本单元PPT教案"]
[null,"2.5设置收付结算","视频2.5设置收付结算","6'",{"$nulls":3},"设置结算方式\n        开户银行\n        付款条件"]
[{"$nulls":5},"本单元PPT教案"]
[null,"2.6设置单据","视频2.6设置单据","6'",{"$nulls":3},"设置单据格式\n         单据编号"]
[{"$nulls":5},"本单元PPT教案"]
[]
["模块3\n(发布时间：2016-9-01 10:00)","3.1总账系统初始设置","视频3.1.1总账系统初始设置-控制参数","5'",{"$nulls":3},"设置总账控制参数","总账控制参数","设置总账控制参数\n录入总账期初余额\n填制凭证\n审核凭证\n记账\n录入银行对账期初数据\n录入本期银行对账单\n对账\n查询银行存款余额调节表"]
[null,null,"视频3.1.2总账系统初始设置-期初余额","7'",{"$nulls":3},"录入总账期初余额","总账期初余额"]
[{"$nulls":5},"本单元PPT教案"]
[null,"3.2凭证处理","视频3.2凭证处理","10'",null,"其他业务录屏",null,"填制凭证\n审核凭证\n记账","凭证修改"]
[{"$nulls":5},"本单元PPT教案"]
[null,"3.3银行对账","视频3.3银行对账","10'",{"$nulls":3},"录入银行对账期初数据\n录入本期银行对账单\n对账\n查询银行存款余额调节表"]
[{"$nulls":5},"本单元PPT教案"]
[]
["模块4\n(发布时间：2016-9-01 10:00)","4.1 初始化设置","视频4.1.1初始化设置-参数设置","5'",{"$nulls":3},"设置应收系统控制参数       ","应收系统控制参数","设置应收系统控制参数\n录入应收系统期初余额\n录入销售专用发票\n录入其他应收单\n录入收款单\n坏账发生\n坏账收回\n计提坏账准备"]
[null,null,"视频4.1.2初始化设置-初始设置","6'",{"$nulls":3},"初始设置"]
[null,null,"视频4.1.3初始化设置-期初余额","7'",{"$nulls":3},"录入应收系统期初余额"]
[{"$nulls":5},"本单元PPT教案"]
[null,"4.2 应收单据处理","视频4.2应收单据处理","5'",null,"其他业务录屏",null,"录入销售专用发票"]
[{"$nulls":5},"本单元PPT教案"]
[null,"4.3 收款单据处理","视频4.3收款单据处理","5'",null,"其他业务录屏",null,"录入转账支票","折扣核销"]
[{"$nulls":5},"本单元PPT教案"]
[null,"4.4 坏账处理","视频4.4坏账处理","8'",{"$nulls":3},"坏账发生\n坏账收回\n计提坏账准备"]
[{"$nulls":5},"本单元PPT教案"]
[]
["模块5\n(发布时间：2016-9-01 10:00)","5.1 初始化设置","视频5.1.1初始化设置-参数设置","5'",{"$nulls":3},"设置应付系统控制参数       ",null,"设置应付系统控制参数 \n录入应付系统期初余额  \n录入采购专用发票\n录入其他应付单\n录入付款单\n "]
[null,null,"视频5.1.2初始化设置-初始设置","6'",{"$nulls":3},"初始设置"]
[null,null,"视频5.1.3初始化设置-期初余额","7'",{"$nulls":3},"录入应付系统期初余额"]
[{"$nulls":5},"本单元PPT教案"]
[null,"5.2 应付单据处理","视频5.2应付单据处理","5'",null,"其他业务录屏",null,"录入采购专用发票"]
[{"$nulls":5},"本单元PPT教案"]
[null,"5.3 付款单据处理","视频5.3付款单据处理","5'",null,"其他业务录屏",null,"录入转账支票"]
[{"$nulls":5},"本单元PPT教案"]
[]
["模块6\n(发布时间：2016-9-01 10:00)","6.1初始化设置","视频6.1初始化设置-参数设置","5'",{"$nulls":3},"设置固定资产系统参数",null,"设置固定资产系统参数\n设置部门对应折旧科目\n设置固定资产类别\n设置增减方式对应入账科目\n录入固定资产原始卡片\n固定资产期初对账\n增加固定资产\n固定资产变动\n计提折旧\n固定资产报废"]
[null,null,"视频6.1初始化设置-部门对应折旧科目","5'",{"$nulls":3},"设置部门对应折旧科目"]
[null,null,"视频6.1初始化设置-资产类别设置","5'",{"$nulls":3},"设置固定资产类别"]
[null,null,"视频6.1初始化设置-增减方式对应入账科目","5'",{"$nulls":3},"设置增减方式对应入账科目"]
[{"$nulls":5},"本单元PPT教案"]
[null,"6.2录入固定资产原始卡片","视频6.2录入固定资产原始卡片","5'",null,"其他业务录屏",null,"录入固定资产原始卡片\n固定资产期初对账"]
[{"$nulls":5},"本单元PPT教案"]
[null,"6.3固定资产增加业务处理","视频6.3固定资产增加业务处理","8'",null,"其他业务录屏",null,"增加固定资产"]
[{"$nulls":5},"本单元PPT教案"]
[null,"6.4固定资产变动业务处理","视频6.4固定资产变动业务处理","6'",{"$nulls":3},"固定资产变动"]
[{"$nulls":5},"本单元PPT教案"]
[null,"6.5计提固定资产折旧","视频6.5计提固定资产折旧","5'",{"$nulls":3},"计提折旧"]
[{"$nulls":5},"本单元PPT教案"]
[null,"6.6固定资产报废","视频6.6固定资产报废","8'",{"$nulls":3},"固定资产报废"]
[{"$nulls":5},"本单元PPT教案"]
[]
["模块7\n(发布时间：2016-9-01 10:00)","7.1 薪资管理系统初始设置","视频7.1.1薪资管理系统初始设置","7'",{"$nulls":3},"参数设置\n银行档案设置 \n",null,"薪资管理系统初始设置         公式设置                  工资分摊设置               计提工资费用设置               发放工资及上交社保"]
[null,null,"视频7.1.2薪资管理系统初始设置","6'",{"$nulls":3},"\n人员档案设置\n   "]
[null,null,"视频7.1.3薪资管理系统初始设置","6'",{"$nulls":3},"工资项目设置                               扣税依据设置          "]
[{"$nulls":5},"本单元PPT教案"]
[null,"7.2公式设置","视频7.2公式设置","10'",{"$nulls":3},"设置九个工资公式","iff()函数的应用"]
[{"$nulls":5},"本单元PPT教案"]
[null,"7.3工资分摊设置","视频7.3工资分摊设置","8'",{"$nulls":3},"增加七个工资分摊设置"]
[{"$nulls":5},"本单元PPT教案"]
[null,"7.4计提工资费用","视频7.4计提工资费用","7'",{"$nulls":3},"生成七张工资费用分配凭证"]
[{"$nulls":5},"本单元PPT教案"]
[]
["模块8\n(发布时间：2016-9-01 10:00)","8.1结转制造费用","视频8.1结转制造费用","6'",{"$nulls":3},"查询制造费用余额表\n编制结转制造费用会计凭证",null,"结转制造费用                  结转完工产品成本             结转销售成本                  结转损益                  期末对账及结账"]
[{"$nulls":5},"本单元PPT教案",null,null,"结转制造费用的方法"]
[null,"8.2结转完工产品成本","视频8.2结转完工产品成本","9'",{"$nulls":3},"自定义结转完工产品成本转账凭证\n生成结转完工产品成本凭证          "]
[{"$nulls":5},"本单元PPT教案"]
[null,"8.3结转销售成本","视频8.3结转销售成本","8'",{"$nulls":3},"设置结转销售成本转账凭证                   生成结转销售成本转账凭证","设置结转销售成本转账凭证要求"]
[{"$nulls":5},"本单元PPT教案"]
[null,"8.4结转损益","视频8.4结转损益","8'",{"$nulls":3},"设置结转损益凭证             生成结转收入类凭证             生成结转支出类凭证"]
[{"$nulls":5},"本单元PPT教案"]
[null,"8.5期末对账及结账","视频8.5期末对账及结账","10'",{"$nulls":3},"各子系统与总账对账             各子系统及总账结账                     "]
[{"$nulls":5},"本单元PPT教案"]
[]
["模块9\n(发布时间：2016-9-01 10:00)","9.1报表编制","9.1报表编制-报表模版应用","8'",{"$nulls":3},"利用报表模版生成资产负债表                     利用报表模版生成利润表",null,"利用报表模版生成资产负债表                     利用报表模版生成利润表\n自定义财务指标分析表"]
[{"$nulls":5},"本单元PPT教案"]
[null,"9.2报表编制","9.2报表编制-自定义报表","8'",{"$nulls":3},"自定义财务指标分析表"]
[{"$nulls":5},"本单元PPT教案"]

{"sheet":"Sheet2","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}

{"sheet":"Sheet3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"flags":["formulas_cached_only"]}