|
楼主 |
发表于 2008-3-24 00:35
|
显示全部楼层
<p><strong>三、班级管理办法(附件一)</strong><br/> <br/> 1、入学:本系只招收3段以下会员;<br/> 2、学费:为鼓励学员多发帖,各班应向学员收取学费,收费标准为2金币/(学员*周),在上课当日签到时收取(开学典礼、特殊节日等可以不收)。收取的学费一部份可以赠给当天上课的讲师以表示感谢,另一部份作为班级优秀会员的奖学金发放,学费不用上交到系<br/> 3、考勤:学员每周上课前必须到自己班级签到,签到同时以赠送金币的形式缴纳学费。连续两次或累计三次无故未签到学员作开除学籍处理;<br/> 4、作业:每堂课后(当天或第二天)由班主任(班长及学委均可协助)出练习题,学员必须在规定的时间内按时上交,连续两次或累计三次不上交作业学员作开除学籍处理;<br/> 5、奖励:各班可以设立自己的标准对优秀学员进行奖励,奖励的方式仍然包含“物质上”的(金币)及“精神上”的(发帖通报表扬)。“优秀”的范围很广(在论坛表现活跃、热心帮助同学、作业上交得快而好、学习好、通过段位考试等,都可以);<br/> 6、处罚:视情节轻重,可采用罚交金币、发帖通报批评、开除等,对于极个别情况非常恶劣的,可上报论坛封期ID;<br/> 7、旁听:各班不允许旁听学员的存在,愿意来听课者即为本班学员,必须服从班级管理的规定;<br/> 8、未尽事宜请各班详细之。</p><p><strong>四、课程表(附件二)</strong><br/> (注:在此基础上,各班可作适当调整)</p><p><table cellspacing="0" cellpadding="0" width="877" border="0" xstr="" style="WIDTH: 658pt; BORDER-COLLAPSE: collapse;"><colgroup><col width="69" style="WIDTH: 52pt; mso-width-source: userset; mso-width-alt: 2523;"></col><col width="51" style="WIDTH: 38pt; mso-width-source: userset; mso-width-alt: 1865;"></col><col width="195" style="WIDTH: 146pt; mso-width-source: userset; mso-width-alt: 7131;"></col><col width="562" style="WIDTH: 422pt; mso-width-source: userset; mso-width-alt: 20553;"></col></colgroup><tbody><tr height="16" style="HEIGHT: 12pt;"><td class="xl25" width="69" height="16" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2"><strong>课程</strong></font></td><td class="xl25" width="51" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; WIDTH: 38pt; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2"><strong>类别</strong></font></td><td class="xl25" width="195" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; WIDTH: 146pt; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2"><strong>项目</strong></font></td><td class="xl25" width="562" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; WIDTH: 422pt; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><strong><font size="2">详细内容</font></strong></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="1" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第01课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">技巧</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">Excel入门</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">认识EXCEL,操作窗口介绍,工作表、单元格的选取、单元格格式(边框、填充),窗口冻结</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="2" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第02课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">技巧</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">数据格式设置</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">合并与拆分单元格,数据对齐方式,单元格内换行,数据分列,单元格格式(数字格式)</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="3" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第03课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">技巧</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">查找与替换、定位、超级链接</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">查找与替换、定位对话框使用,超级链接设置,条件格式</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="4" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第04课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">函数</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">函数入门</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">函数说明、引用方式、选择(查找)公式、公式调试,SUM(),RANK()</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="5" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第05课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">函数</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">计算类函数</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">AVERAGE(),MAX(),MIN(),LARGE(),SMALL()</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="6" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第06课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">函数</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">逻辑函数</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">IF(),AND(),OR(),TRUE,FALSE</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="7" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第07课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">技巧</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">排序与筛选</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">排序,自动筛选、高级筛选</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="8" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第08课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">技巧</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">图表基础</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">普通柱形图、折线图及饼图的制作</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="9" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第09课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">技巧</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">数据透视表</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">透视表基础运用(数据列表)</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="10" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第10课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">函数</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">条件函数</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">SUMIF(),COUNTIF(),SUMPRODUCT()</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="11" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第11课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">函数</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">日期函数</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">TODAY(),YEAR(),MONTH(),DAY(),WEEKDAY(),DATE(),DATEDIF()</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="12" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第12课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">函数</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">文本函数</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">LEFT(),RIGHT(),MID(),&运算符</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="13" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第13课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">函数</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">查找与替换、定位、超级链接</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffcc; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">VLOOKUP(),LOOKUP(),MATCH(),OFFSET(),FIND(),SUBSTITUTE(),REPLACE()</font></td></tr><tr height="16" style="HEIGHT: 12pt;"><td class="xl24" height="16" xfmla="=ROW()-2" xnum="14" style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; HEIGHT: 12pt; mso-ignore: style; mso-pattern: auto none;"><font size="2">第14课</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">技巧</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">统计分析</font></td><td style="BORDER-RIGHT: #d4d0c8; BORDER-TOP: #d4d0c8; BACKGROUND: #ccffff; BORDER-LEFT: #d4d0c8; BORDER-BOTTOM: #d4d0c8; mso-ignore: style; mso-pattern: auto none;"><font size="2">分类汇总、合并计算</font></td></tr></tbody></table></p> |
|