80 likes | 263 Views
IS 465 Midterm Prep. A Review. Midterm Format. 10 Multiple Choice Questions …covers week 1 to week 6 4 short answer questions covering items that we discussed during class 2 medium essay questions covering items that we discussed during class
E N D
IS 465 Midterm Prep A Review
Midterm Format • 10 Multiple Choice Questions …covers week 1 to week 6 • 4 short answer questions covering items that we discussed during class • 2 medium essay questions covering items that we discussed during class • 1 long essay questions covering items that we discussed during class
Some Specifics • Multiple Choice (3 points each total of 30 points or 30% of the midterm) • Short question (5 points each total of 20 points or 20%) • Essay questions (10 points each total of 20 points or 20%) • Long Essay Questions (20 points or 20% of the mid term)
Some Specifics: Week1 • Information System/Computer Science/Information Technology • Definition of IS • Historical change of IS
Some Specifics: week 2 Human information processing • Human Information Processing System • Various different categories of human info processing system • overlearning, “chunking” • Definition of Problem • Human Problem-solving • Problem solving and information system design
Week 3 • Read: HBP-6 • Web: Web 2.0, RSS • Web: RDF and Semantic Web • Excel: Import Data From Text Files and Other Sources • Excel: Using Database Functions • Excel: Usage of PivotTables and PivotCharts
Week 4 • HBP-8 • Relational Design • Schema • Web-based IS design – architecture • JDBC
Week 5 • Decision Support and OLAP • OLAP vs. OLTP • Properties of Data warehouse • Data marts, cube • Architecture of DW • DW schema • Operations of DW