Scott Johnson
Senior Lecturer
Department of Computer Science
Golisano College of Computing and Information Sciences
585-475-4931
Office Location
Scott Johnson
Senior Lecturer
Department of Computer Science
Golisano College of Computing and Information Sciences
Education
BS, MS, Rochester Institute of Technology
585-475-4931
Currently Teaching
CSCI-243
The Mechanics of Programming
3 Credits
Students will be introduced to the details of program structure and the mechanics of execution as well as supportive operating system features. Security and performance issues in program design will be discussed. The program translation process will be examined. Programming assignments will be required.
CSCI-320
Principles of Data Management
3 Credits
This course provides a broad introduction to the principles and practice of modern data management, with an emphasis on the relational database model. Topics in relational database systems include data modeling; the relational model; relational algebra; Structured Query Language (SQL); and data quality, transactions, integrity and security. Students will also learn approaches to building relational database application programs. Additional topics include object-oriented and object-relational databases; semi-structured databases (such as XML); and information retrieval. A database project is required.
CSCI-344
Programming Language Concepts
3 Credits
This course is a study of the syntax and semantics of a diverse set of high-level programming languages. The languages chosen are compared and contrasted in order to demonstrate general principles of programming language design and implementation. The course emphasizes the concepts underpinning modern languages rather than the mastery of particular language details. Programming projects will be required.
CSCI-421
Principles of Database System Implementation
3 Credits
This course provides a broad introduction to database management systems including data modeling, the relational model, and SQL. Database system implementation issues are covered next, where the focus is on data structures and algorithms used to implement database management systems. Topics include physical data organization, indexing and hashing, query processing and optimization, database recovery techniques, transaction management, concurrency control, and database performance evaluation. A programming project will be required.
CSCI-471
Professional Communications
3 Credits
This course focuses on developing and improving verbal and written communication skills specific to the discipline of computer science. Topics include the different forms of writing in computer science (books, theses, journal articles, technical reports, manuscripts, etc.), writing styles of computer scientists, document readability and usability, documents for career readiness, effective presentations, teamwork and peer review, research methods, experimentation, documenting mathematics and algorithms, proper formatting of graphs, figures, and tables, and ethical, social, and professional issues facing Computer Scientists. This course is approved as Writing Intensive.
CSCI-521
Principles of Data Cleaning and Preparation
3 Credits
This course provides an introduction to the concepts and techniques used in preparing data for subsequent data mining. Topics include the knowledge discovery process; data exploration and its role; data extraction, cleaning, integration and transformation; handling numeric, unstructured, text, web, and other forms of data; and ethical issues underlying data preparation and mining. Data cleaning projects and a paper are required.
In the News
-
October 11, 2022
RIT faculty prepare to teach large classes in SHED using scaled-up classroom
A room in Slaughter Hall seats 150 students and is meant to simulate the learning spaces in the Student Hall for Exploration and Development (SHED) that will hold classes next fall. The Slaughter classroom, dubbed the “betaSHED,” combines three rooms to give professors and students a preview of the large-scale learning environment.