ACM_IEEE_CS2013 Curriculum Map Indiana State University.xlsx
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Notes on Using the Spreadsheet
2
There are 7 worksheets in this spreadsheet.
3
UsageNotes contains this description.
4
CurriculumDetail contains the knowledge areas (KA), knowledge units (KU), learning outcomes, and course details.
5
CurriculumSummary contains the core coverage by KU for the program.
6
CoreCoverage provides a color-coded display of core coverage for the program.
7
KUMap provides the same display as CoreCoverage, but includes elective courses.
8
LearningOutcomes is a list of all learning outcomes in the CS2013 Body of Knowledge
9
ModificationNotes is a change history of this file.
10
11
Your curriculum data should be entered only into the CurriculumDetail worksheet. On this worksheet. Columns A and B contain the knowledge areas and knowledge units from the guidelines. Column C contains the tier for the outcome (Tier 1, Tier 2, or Elective, which is represented by the number 3). Column D contains the level (Familiarity, Usage, Assessment) for the outcome. Column E contains the KU Outcome numbers, which align with the outcomes listed in the LearningOutcomes page. Each outcome is also contained in the comment box for that row. (Hover the cursor over the red triangle in the upper right of the cell.)
12
To use this spreadsheet, enter the program content information on the CurriculumDetail worksheet. Enter the program's course names in Row 3, columns G through AJ.
13
For each course, mark the rows corresponding to the outcomes met in that course. Any character entered into the cell indicates the outcome is met in the course.
14
The first row of each KU block shows the number of Core Tier 1 and Core Tier 2 hours in the CS2013 BOK in columns C and D, respectively. To populate the CoreCoverage table and the KUMap table, enter the number of CS2013 core hours covered by each course on this line. (For example, if the first course, listed in column G, covers 3 of the 4 core hours for Basic Analysis KU, enter 3 in cell G6.)
15
16
Cell C2 controls highlighting. "ON" turns highlighting on. "OFF" turns highlighting off. "REV" does reverse highlighting.
17
For ON, the yellow highlight marks the Tier1 outcomes that have no course listed in which the outcome is met. The red highlight marks unmet Tier2 outcomes. When a Tier1 or Tier2 outcome is met by a course in the curriculum, the highlighting is removed.
18
For REV, the yellow and red highlights are the same as for ON. For KUs where some course contributes to the KU and the Tier1 and Tier2 requirements are met, the KU is highlighted in green. This lets the user quickly see what KUs are covered in the curriculum.
19
The Curriculum Summary, CoreCoverage, and KUMap worksheets are updated automatically from the Curriculum Detail sheet.
20
The CurriculumSummary sheet lists the Knowledge Areas and Knowledge Units along with the courses in the curriculum that contribute to the knowledge unit. Highlighting indicates knowledge units with unmet Tier1 and Tier2 outcomes.
21
CoreCoverage shows a color-coded, course-by-course contribution to the coverage of the core. Cells D1, D2, E1, and E2 specify the 5 levels of shading for the coverage map. Cells covering the value in D1 or more are shaded in the color of the cell D1. These values may be changed. An uncolored cell indicates less coverage than specified in cell E2.
22
23
Notes on ISU's use of the spreadsheet:
24
Goal is to have all Level 1 core items included within CS 151, 201, 202, 303. For each of these, mark learning outcome as 1 for level 1 in the course that is most responsible for it.
25
Then go through and mark 2 for Level 2 items for the one course that is most responsible for it.
26
Then go through and mark 3 for additional, elective items.
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
 
 
 
UsageNotes
CurriculumDetail
CurriculumSummary
CoreCoverage
KUMap
LearningOutcomes
ModificationNotes
Course Outcomes