Database Tutorial by tje33733

VIEWS: 25 PAGES: 6

More Info
									Dr. Shusette                                                       Deliverables T/Th 8:00am                                    CSUN/Comp100 S2005



California State University, Northridge
Computer Science 100 Spring 2005 Deliverables
#11659 Tues/Thurs 8:00am to 9:15am                                                               Dr. Shusette
Week     Date                  Activities                    Assignments                     Learning Outcomes
  1 2/1/2005      INTRO TO COMP SCIENCE               CSUN A/C, e-mail           Overview of course content
     Windows XP Resources                             SAM 2003 setup             Knowledge of lab resources
                  Desktop functions                   Read DC chp 1              Describe Desktop functions
                  Intro to MS Word                                               Create a document using a wizard
  1 2/3/2005      WHAT IS A COMPUTER?                 Windows XP                 Learn new computer terms
                  Effective Use of textbook           Weekly PwrP chp 1          Proper use of textbook with course
                  Intro to PowerPoint                 Prepare Wkly PP slide show Create a PwrP document using a wizard
                  Understanding Computing                                        Goal to become fluent computer user
                  Computer applications                                          Identify importance of computer literacy
  2 2/8/2005      *Pre-Test                           *Article Abstract Due      Understand concepts of word processing
  2 2/10/2005     THE INTERNET and WWW                Read DC chp 2              Knowing access and content to the Internet
     Word2003     Discuss Web content, Servers        Word Tutorial #1           Understanding uses of word processing
                  E-mail, FTP, Web Sites              Weekly PwrP chp 1          Set up and use of E-mail, FTP, Web Sites
                  Navigating Web Pages                                           Develop critical skills of web searches
  3 2/15/2005     Discuss Netiquette and the Internet Word Tutorial #2           Understand and apply Internet Netiquette
                  Use of Browser features             Weekly PwrP chp 2          Assess prior knowledge of computing
                  Other Internet Services             Review Research Paper      Knowledge of newsgroups, chat rooms
  3 2/17/2005     APPLICATION SOFTWARE                Read DC chp 3              Identify categories of application software
                  Interacting Application software    Weekly PwrP chp 3          Review lesson knowledge
                  Business and Database Software                                 Identify key features of business programs
                  Home and Personal Software                                     Identify use of Personal & Home software
  4 2/22/2005     Graphics and Multimedia Software Read DC chp 4                 Examine types and how applied
                  Computer-Aided Design               Word Tutorial #3           Understand computer aided software
                  Learning Aids and Support Tools Weekly PwrP chp 3              Review lesson knowledge
                  Research Term Paper                 Review Research Paper      Understand requirements of term paper
  4 2/24/2005 COMPONENTS of the SYSTEM UNIT           *E-mail Project Due        Differentiate among various styles of SU
                  The Processor                       Word Tutorial #4           Understand the components of the system
                  Memory and Expansion Slots          Weekly PwrP chp 4          Examine bits and bytes how they are used
                  Ports, Bays and Power Supplies                                 Examine how buses contribute to speed MHz
  5 3/1/2005      OUTPUT DEVICES                      Read DC chp 5              Identify output characteristics
                  Display Devices                     Weekly PwrP chp 5          Output media format devices
                  Other Output Devices                Word Tutorial #5           Describe four categories of output
                  Printers                            Quiz#1 Study Guide         Know various types of Printers and Uses
  5 3/3/2005      *Quiz#1 DC Ch1,2,3,4                Read DC chp 6              Assess knowledge of lessons




                                                                Deliverables S2005 T/Th 8:00am                                             Page 1
Dr. Shusette                                                    Deliverables T/Th 8:00am                                  CSUN/Comp100 S2005


Week Date         Activities                        Assignments             Learning Outcomes
                  Intro Excel Spreadsheets          Weekly PwrP chp 6       Identify input characteristics
  6   3/8/2005    INPUT DEVICES                     Excel Tutorial #1       Identify input characteristics
      EXCEL2003 Keyboards and pointing Devices Weekly PwrP chp 6            Input media format devices
                  Other Input Devices                                       Describe categories of output devices
                  Review Term Paper Assignment                              Review Term Paper Info and Setup
  6   3/10/2005   STORAGE                           Weekly PwrP chp 6       Describe media storage
                  Hard Disk, Floppy Disk                                    Discuss various media storage
                  Zip Drives, PC Cards              Excel Tutorial #2       Distinguish between memory and storage
                  CD's and DVD's, PC Cards                                  Describe characteristics of storage
  7   3/15/2005   MEMORY and EXPANSION SLOTS        Read DC chp 7           Discuss various media storage
                  Miniature Mobile Storage          Weekly PwrP chp 7       Know and describe mobile storage uses
                  Expansion Cards                                           Describe characteristics of Expansion Cards
  7   3/17/2005   OPERATING SYSTEMS                                         Understand impact of technology
                  Types of Operating Systems                                Understand operating system functions
                  Operating Utility Programs        Weekly PwrP chp 7       Understand operating system utilities
                  Network types of Operating Sys                            Understand Term Paper Assignment
                  Spring Recess                     Legal Holiday
  8   3/22/2005   Spring Recess                     Legal Holiday
  8   3/24/2005   COMMUNICATIONS                    Read DC chp 8           Know various types of communication media
                  Analog and Digital Communications Review Research Paper   Know difference between Analog & Digital
                  Use of Computer Communications Excel Tutorial #3          Know types of Internet communications
                  Communications software           Weekly PwrP chp 8       Know types of communications software
                  Internet Telephony                                        Know telephony relates to communications
  9   3/29/2005   NETWORKS                          *Web Search Due         Know various types of networks
                  Home Networks                                             Understand architecture of networks
                  Communication Channels            Weekly PwrP chp 8       Explain use of utility programs
                  Physical Transmission Media                               Know types of physical media
                  Wireless Transmission Media                               Know types of Wireless media
  9     3/31/2005 Ceaser Chevez Day                 Legal Holiday
 10   4/5/2005    DATABASE MANAGEMENT               Read DC chp 9           Recognize potential use of a database
                  Maintaining Data                  Excel Tutorial #4       Describe Organizational management
                  File Processing versus Databases Weekly PwrP chp 9        Review lesson knowledge
                  The Hierarchy of Data                                     Identify different language paradigms
                  Multidimensional Databases        Weekly PwrP chp 9       Learn types of Management software
                  Database Administration                                   Knowledge of Organizational charts
                  Web Databases                                             Database Guidelines
 10   4/7/2005    COMPUTERS and SOCIETY             Read DC chp 10          Explain importance of protocol
                  Computer Virus                    Excel Tutorial #5       Describe safeguards against Viruses
                  Computer Security, Software Theft Midterm Study Guide     Discuss issues surrounding info privacy
                   Review Term Paper Assignment Weekly PwrP chp 10          Safeguards against software theft



                                                             Deliverables S2005 T/Th 8:00am                                           Page 2
Dr. Shusette                                                     Deliverables T/Th 8:00am                                   CSUN/Comp100 S2005


Week    Date     Activities                        Assignments               Learning Outcomes
 11 4/12/2005    *Midterm DC Ch 5,6,7,8            PowerPoint Tutorial #1    Assess knowledge from lessons
                 Information Privacy               Weekly PwrP chp 10        Discuss issues surrounding info ethics
                 COMPUTER ETHICS                                             Information Accuracy and Intellectual rights
                 Ethics and Society                PowerPoint Tutorial #1    Discuss issues surrounding info ethics
                 Health Concerns of Computer Use                             Knowledge of computer health risks
 11   4/14/2005  INFORMATIONAL SYSTEMS             Read DC chp 11            Identify characteristics of valuable info
                 The System Development Cycle      Weekly PwrP chp 11        Describe sequence of System Development
                 Programming Languages                                       Describe types of programming languages
                 Web Page Development              PowerPoint Tutorial #2    Understand development of web pages
 12   4/19/2005  PROGRAMMING LANGUAGES                                       Describe sequence of development
                 Program Development Cycle         PowerPoint Tutorial #3    Describe various custom software
                 Control Structures                                          Initiate the Program Development Cycle
                 Multimedia Program Development                              Understand control structures
 12   4/21/2005  ENTERPRISE COMPUTING              Read DC chp 12            Organizational Structure of Enterprising
      Access2003 What is Enterprise Computing      Access Tutorial #1        Create simple database table and reports
                 Organizational Structures         Weekly PwrP chp 12        Know levels of users and management
                 Information Systems                                         Understand Enterprise information systems
 13   4/26/2005  Enterprise-Wide Technologies      Access Tutorial #2        Understand portals, EDI, Workflows
                                                   Weekly PwrP chp 12
 13   4/28/2005   Enterprise Hardware              *Term Paper Due        Discover the types of security Plans
                  Review Term Paper Presentation   Access Tutorial #3     Preparation for Quiz#2
 14   5/3/2005    Backup and Security              Weekly PwrP chp 12     Assess knowledge from lessons
                  Developing a Security System                            Basic skills of Access
 14   5/5/2005    Review Term Paper Assignment
                  Review Term Paper Presentation Quiz#2 Study Guide       Review lesson knowledge
 15   5/12/2005   Quiz#2 DC Ch9,10,11,12
                  Term Paper Presentation
 16   5/17/2005   Term Paper Presentation        Final Exam Study Guide   Preparation for comprehensive exam
 16   5/19/2005   Term Paper Presentation        *SAM 2003 Lab Tutorials Due
 17   5/24/2006   Final Exam-Comprehensive and Post Test                  Tuesday




                                                              Deliverables S2005 T/Th 8:00am                                            Page 3
Dr. Shusette                                                        Deliverables T/Th 9:30am                                   CSUN/Comp100 S2005



California State University, Northridge
Computer Science 100 Spring 2005 Deliverables
#18815 Tues/Thurs 9:30am to 10:45am                                                              Dr. Shusette
Week     Date                  Activities                    Assignments                     Learning Outcomes
  1 2/1/2005      INTRO TO COMP SCIENCE               CSUN A/C, e-mail           Overview of course content
     Windows XP Resources                             SAM 2003 setup             Knowledge of lab resources
                  Desktop functions                   Read DC chp 1              Describe Desktop functions
                  Intro to MS Word                                               Create a document using a wizard
  1 2/3/2005      WHAT IS A COMPUTER?                 Windows XP                 Learn new computer terms
                  Effective Use of textbook           Weekly PwrP chp 1          Proper use of textbook with course
                  Intro to PowerPoint                 Prepare Wkly PP slide show Create a PwrP document using a wizard
                  Understanding Computing                                        Goal to become fluent computer user
                  Computer applications                                          Identify importance of computer literacy
  2 2/8/2005      *Pre-Test                           *Article Abstract Due      Understand concepts of word processing
  2 2/10/2005     THE INTERNET and WWW                Read DC chp 2              Knowing access and content to the Internet
     Word2003     Discuss Web content, Servers        Word Tutorial #1           Understanding uses of word processing
                  E-mail, FTP, Web Sites              Weekly PwrP chp 1          Set up and use of E-mail, FTP, Web Sites
                  Navigating Web Pages                                           Develop critical skills of web searches
  3 2/15/2005     Discuss Netiquette and the Internet Word Tutorial #2           Understand and apply Internet Netiquette
                  Use of Browser features             Weekly PwrP chp 2          Assess prior knowledge of computing
                  Other Internet Services             Review Research Paper      Knowledge of newsgroups, chat rooms
  3 2/17/2005     APPLICATION SOFTWARE                Read DC chp 3              Identify categories of application software
                  Interacting Application software    Weekly PwrP chp 3          Review lesson knowledge
                  Business and Database Software                                 Identify key features of business programs
                  Home and Personal Software                                     Identify use of Personal & Home software
  4 2/22/2005     Graphics and Multimedia Software Read DC chp 4                 Examine types and how applied
                  Computer-Aided Design               Word Tutorial #3           Understand computer aided software
                  Learning Aids and Support Tools Weekly PwrP chp 3              Review lesson knowledge
                  Research Term Paper                 Review Research Paper      Understand requirements of term paper
  4 2/24/2005 COMPONENTS of the SYSTEM UNIT           *E-mail Project Due        Differentiate among various styles of SU
                  The Processor                       Word Tutorial #4           Understand the components of the system
                  Memory and Expansion Slots          Weekly PwrP chp 4          Examine bits and bytes how they are used
                  Ports, Bays and Power Supplies                                 Examine how buses contribute to speed MHz
  5 3/1/2005      OUTPUT DEVICES                      Read DC chp 5              Identify output characteristics
                  Display Devices                     Weekly PwrP chp 5          Output media format devices
                  Other Output Devices                Word Tutorial #5           Describe four categories of output
                  Printers                            Quiz#1 Study Guide         Know various types of Printers and Uses
  5 3/3/2005      *Quiz#1 DC Ch1,2,3,4                Read DC chp 6              Assess knowledge of lessons




                                                                Deliverables S2005 T/Th 9:30 am                                            Page 4
Dr. Shusette                                                    Deliverables T/Th 9:30am                                  CSUN/Comp100 S2005


Week Date         Activities                        Assignments             Learning Outcomes
                  Intro Excel Spreadsheets          Weekly PwrP chp 6       Identify input characteristics
  6   3/8/2005    INPUT DEVICES                     Excel Tutorial #1       Identify input characteristics
      EXCEL2003 Keyboards and pointing Devices Weekly PwrP chp 6            Input media format devices
                  Other Input Devices                                       Describe categories of output devices
                  Review Term Paper Assignment                              Review Term Paper Info and Setup
  6   3/10/2005   STORAGE                           Weekly PwrP chp 6       Describe media storage
                  Hard Disk, Floppy Disk                                    Discuss various media storage
                  Zip Drives, PC Cards              Excel Tutorial #2       Distinguish between memory and storage
                  CD's and DVD's, PC Cards                                  Describe characteristics of storage
  7   3/15/2005   MEMORY and EXPANSION SLOTS        Read DC chp 7           Discuss various media storage
                  Miniature Mobile Storage          Weekly PwrP chp 7       Know and describe mobile storage uses
                  Expansion Cards                                           Describe characteristics of Expansion Cards
  7   3/17/2005   OPERATING SYSTEMS                                         Understand impact of technology
                  Types of Operating Systems                                Understand operating system functions
                  Operating Utility Programs        Weekly PwrP chp 7       Understand operating system utilities
                  Network types of Operating Sys                            Understand Term Paper Assignment
                  Spring Recess                     Legal Holiday
  8   3/22/2005   Spring Recess                     Legal Holiday
  8   3/24/2005   COMMUNICATIONS                    Read DC chp 8           Know various types of communication media
                  Analog and Digital Communications Review Research Paper   Know difference between Analog & Digital
                  Use of Computer Communications Excel Tutorial #3          Know types of Internet communications
                  Communications software           Weekly PwrP chp 8       Know types of communications software
                  Internet Telephony                                        Know telephony relates to communications
  9   3/29/2005   NETWORKS                          *Web Search Due         Know various types of networks
                  Home Networks                                             Understand architecture of networks
                  Communication Channels            Weekly PwrP chp 8       Explain use of utility programs
                  Physical Transmission Media                               Know types of physical media
                  Wireless Transmission Media                               Know types of Wireless media
  9     3/31/2005 Ceaser Chevez Day                 Legal Holiday
 10   4/5/2005    DATABASE MANAGEMENT               Read DC chp 9           Recognize potential use of a database
                  Maintaining Data                  Excel Tutorial #4       Describe Organizational management
                  File Processing versus Databases Weekly PwrP chp 9        Review lesson knowledge
                  The Hierarchy of Data                                     Identify different language paradigms
                  Multidimensional Databases        Weekly PwrP chp 9       Learn types of Management software
                  Database Administration                                   Knowledge of Organizational charts
                  Web Databases                                             Database Guidelines
 10   4/7/2005    COMPUTERS and SOCIETY             Read DC chp 10          Explain importance of protocol
                  Computer Virus                    Excel Tutorial #5       Describe safeguards against Viruses
                  Computer Security, Software Theft Midterm Study Guide     Discuss issues surrounding info privacy
                   Review Term Paper Assignment Weekly PwrP chp 10          Safeguards against software theft



                                                             Deliverables S2005 T/Th 9:30 am                                          Page 5
Dr. Shusette                                                     Deliverables T/Th 9:30am                                   CSUN/Comp100 S2005


Week    Date     Activities                        Assignments               Learning Outcomes
 11 4/12/2005    *Midterm DC Ch 5,6,7,8            PowerPoint Tutorial #1    Assess knowledge from lessons
                 Information Privacy               Weekly PwrP chp 10        Discuss issues surrounding info ethics
                 COMPUTER ETHICS                                             Information Accuracy and Intellectual rights
                 Ethics and Society                PowerPoint Tutorial #1    Discuss issues surrounding info ethics
                 Health Concerns of Computer Use                             Knowledge of computer health risks
 11   4/14/2005  INFORMATIONAL SYSTEMS             Read DC chp 11            Identify characteristics of valuable info
                 The System Development Cycle      Weekly PwrP chp 11        Describe sequence of System Development
                 Programming Languages                                       Describe types of programming languages
                 Web Page Development              PowerPoint Tutorial #2    Understand development of web pages
 12   4/19/2005  PROGRAMMING LANGUAGES                                       Describe sequence of development
                 Program Development Cycle         PowerPoint Tutorial #3    Describe various custom software
                 Control Structures                                          Initiate the Program Development Cycle
                 Multimedia Program Development                              Understand control structures
 12   4/21/2005  ENTERPRISE COMPUTING              Read DC chp 12            Organizational Structure of Enterprising
      Access2003 What is Enterprise Computing      Access Tutorial #1        Create simple database table and reports
                 Organizational Structures         Weekly PwrP chp 12        Know levels of users and management
                 Information Systems                                         Understand Enterprise information systems
 13   4/26/2005  Enterprise-Wide Technologies      Access Tutorial #2        Understand portals, EDI, Workflows
                                                   Weekly PwrP chp 12
 13   4/28/2005   Enterprise Hardware              *Term Paper Due        Discover the types of security Plans
                  Review Term Paper Presentation   Access Tutorial #3     Preparation for Quiz#2
 14   5/3/2005    Backup and Security              Weekly PwrP chp 12     Assess knowledge from lessons
                  Developing a Security System                            Basic skills of Access
 14   5/5/2005    Review Term Paper Assignment
                  Review Term Paper Presentation Quiz#2 Study Guide       Review lesson knowledge
 15   5/12/2005   Quiz#2 DC Ch9,10,11,12
                  Term Paper Presentation
 16   5/17/2005   Term Paper Presentation        Final Exam Study Guide   Preparation for comprehensive exam
 16   5/19/2005   Term Paper Presentation        *SAM 2003 Lab Tutorials Due
 17   5/24/2006   Final Exam-Comprehensive and Post Test                  Tuesday




                                                             Deliverables S2005 T/Th 9:30 am                                            Page 6

								
To top