語數課程表

⑴ 大家都知道課程表吧，那麼英語課程表怎麼寫啊比如：數學——math

地理 geogrphy
生物 biology
體育 PE
化學 chemistry
歷史 history
數學 maths
物理 Physics
政治 Politics

⑵ 五個老師四個班級,語數英三門功課怎麼排課程表

因為要求語文來、英語不自相鄰，則用插空法；先排數學、政治和化學3個科目，有A33=6種排法，排好後有4個空位，再將語文、英語插入到4個空位中，有C42=6種情況，由分步計數原理，可得共有6×6=36種情況；故答案為36．

⑶ SQL語句的一道題 三個基本表：學生表(Student)、課程表（Course）、學生選課表（SC）

1. select * from SC
2. select Sname，Sage from Student where Sdept = '計算機'
3. select Sno,Cno,Grade from SC where Grade >= 70 and Grade <= 80
4. select Sname,Sage from Student where Sage between 18 and 20 and Ssex = '男'
5. select top 1 Grade from SC where Cno = 'C01'
6. select max(Sage),min(Sage) from Student
7. select Sdept,sum(Sno) from Student group by Sdept
8. select course.Cname,sum(sc.Sno),max(Grade) from SC
join studet on Student.Sno = SC.Sno
join Course on Course.Cno = SC.Cno
group by course.cname,max(grade)

9. select sum(Cno),avg(Grade) from SC
join Course on Course.Cno = SC.Cno
join Student on Student.Sno= SC.Sno
order by SC.Sno

10. select Stuent.Sno，Stuent.Sname，sum(Grade) A from SC
join Student on Student.Sno = SC.Sno
group by sc.Sno,student.Sname
having A > 200

11. select Student.Sname,Student.Sdept from Student
join Course on Course.Cno = SC.Cno
join SC on SC.Sno = Student.Sno
where SC.Cno = 'C02'

12. select Student.sname,course.cno,sc.grade from sc
join student on student.sno = sc.sno
join course on course.cno = sc.cno
where sc.grade >= 80
order by sc.grade desc

13. select cno,cname from
(
select course.cno,course.cname,sun(sno) from student
join course on course.cno = sc.cno
join sc on sc.sno = student.sno
group by cno,cname
having sun(sno) > 0
)

14. ① select student.sname,student.sdept from
(
select student.sname,student.sdept,course.cname from student
join sc on sc.sno = student.sno
join course on course.cno = sc.cno
where course.cname = 'C01'
)

② select student.sno,student.sname from
(
select student.sno,student.sname,student.sdept,sc.grade from sc
join student on student.sno = sc,sno
where student.sdept = '信息' and sc.grade >= 80
)

③ select top 1 student.sname from
(
select student.sname,student.sdept,sum(sc.grade) from sc
join student on student.sno = sc.sno
where student.sdept = '計算機'
group by student.sname,student.sdept
order by
)

15. delete from sc where grade < 50
16. update sc set grade += 5 from sc
join course on course.cno = sc.cn
join student on student.sno = sc.sno
where student.sno =
(
select student.sno from sc
join course on course.cno = sc.cno
where course.cname = 'c01'
)

17. update sc set grade += 10 from sc
join student on student.sno = sc.sno
where student.sno =
(
select student.sno from student
join sc on sc.sno = student.sno
join course on course.cno = sc.cno
where student.sdept = '計算機' and course.cname = '計算機文化基礎'
)

18. create view [A] as
select student.sno,student.sname,student.sdept,course.cno,course.cname,sc.grade from sc
join student on student.sno = sc.sno
join course on course.cno = sc.cno

19. create view [A] as
select student.sno,avg(sc.grade) from sc
join student on student.sno = sc.sno
group by student.sno

20. create view [A] as
select student.sno,sum(sc.grade) from sc
join student on student.sno = sc.sno
group by student.sno

21. create index A on student(sname)
22. 不會

⑷ 初一，課程表上語數外都是連堂課，這樣合理嗎學校說教師安排不過來，可是每天下午又安排補課。

這樣的按排是既不科學，也不合理的。學生得不到勞逸結合，也影響學生的健康成長。

⑸ 小學課程表，就是填寫周一到周五授課的課程， 周一上午語文，數學，弟子規，下午英語語文數學，繼續寫，

網上那麼多，隨便去找幾個參考下。

⑹ 設計一下課程表(語數英理化政史)，上午四節課，下午四節課。別人看不懂的那種

自己可以約束一個代碼，用代碼標示(語數英理化政史)，這樣別人就看不懂了。

⑺ 一張只有語文數學英語的課程表

最後那一段幫你小改了下，直接執行 if OBJECT_ID('up_init','p')is not nulldrop proc up_initgocreate proc up_initasbegin--*********************************--遍歷每一個學生 my_c cursor scrollfor select stuid from student--2.open my_c--3.declare @n int,@stuid int,@score floatset @n=1select @score=score from Grade--beginwhile (@n<=@@CURSOR_ROWS)beginfetch next from my_c into @stuidinsert into Grade values('語文',RAND()*100,@stuid)insert into Grade values('數學',RAND()*100,@stuid)insert into Grade values('英語',RAND()*100,@stuid)set @n=@n+1end--4.close my_c--5.deallocate my_cend-----------------------------------goexec up_initselect * from Grade

⑻ 新建資料庫，三張表 學生表 ,成績表，課程表(有以下課程:語文，數學，英語)，目前有100個學生

最後那一段幫你小改了下，直接執行

ifOBJECT_ID('up_init','p')isnotnull
dropprocup_init
go
createprocup_init
as
begin
--*********************************
--遍歷每一個學生
declaremy_ccursorscroll
forselectstuidfromstudent
--2.
openmy_c
--3.
declare@nint,@stuidint,@scorefloat
set@n=1
select@score=scorefromGrade
--begin
while(@n<=@@CURSOR_ROWS)
begin
fetchnextfrommy_cinto@stuid
insertintoGradevalues('語文',RAND()*100,@stuid)
insertintoGradevalues('數學',RAND()*100,@stuid)
insertintoGradevalues('英語',RAND()*100,@stuid)
set@n=@n+1
end
--4.
closemy_c
--5.
deallocatemy_c
end
-----------------------------------
go
execup_init
select*fromGrade

⑼ 華東師范大學（研究生及本科生）學科教育語文及學科教育數學的課程表

初試專業課的來科目基本上是333教育綜自合和語文綜合。 21，如河南大學的333教育綜合只考教育學，【注意】部分學校的333教育綜合的指定書目和大綱規定的范圍不一致，因為是學校命題，復習應以學校提供的參考書為准，所以選定學校後即可去官網查看考研信息，一般都是師范大學招收、考研學科教育語文屬於專碩的教育碩士、心理學（查看該校碩士專業目錄的參考書目）

⑽ 關於小學課程表上一般在早上 一二節課都設置為語數英的課程，這是為什麼呢

早上第一二節課學生們剛吃完早飯，比較精神，所以一般安排比較重要的課程。

參加教師培訓的時候聽老師說的