"Sheet1"
"信息技术(八年级上册)第三课"
"Sheet2"
"1,右图标志表示哪种图表类型"
,,,,,,," "
"2,在右边图表中填入相应部分名称"
,," "
"3,像B3,B8这样的单元格地址叫做"相对地址",像$A$2,$E$8则称为" ""
"科技活动月统计表"
"年级","小发明(件)","小制作(件)","小论文(篇)","软件作品(件)","总计"
"初一年级",11,"16 ","33 ","3 ",63
"初二年级",14,"20 ","40 ","6 ",80
"初三年级",5,"10 ","25 ","2 ",42
"高一年级",12,"17 ","38 ","4 ",71
"高二年级",15,"19 ","45 ","8 ",87
"高三年级",6,"10 ","27 ","3 ",46
" 总计",63,"92 ","208 ","26 ",389
" "
" 练习一,根据课本内容,完成以下填空题.(每空5分,共40分) "
"问题与任务: 学校科技小组的学生对科技月活动中同学们上交的作品进行了分类,整理,统计和计算.学校希望他们用图表表示各年级上交各类作品情况,并打印出来,张贴在学校科技月活动栏里,鼓励学生积极参加各类学科活动."
" 练习二:完成下列两个操作题.(10分) 利用"图表向导"将下面的"科技月活动统计表"制作成柱形图,子图表类型为"簇状柱形图",图表标题为"科技月活动统计表".制作好的图表放入sheet1工作表的绿色框中.图表完成图如课本17面图3-9. 要求: 1,图表标题为红色. 2,X轴文字为蓝色. 3,Y轴文字为黑色. "
"第三课 图表制作——制作科技月活动统计柱形图表 "
"请认真阅读课本,完成下面的题目. 完成后将本文件另存为自己的班级姓名座号,提交到ftp://10.105.129.9"
"厦门集美中学宋红"
"班级"
"姓名"
"座号"
"成绩单"