CSC 105 Study Guide - Midterm Guide: Multi-Core Processor, Dynamic Random-Access Memory, Character Encoding

• School: University of Victoria
• Department: Computer Science
• Course: CSC 105
• Professor: Rich Little

Document Summary

Computer science chapter 2, 3 notes and definitions. The benefits of an integrated circuit are: reliability, size, speed, efficiency, and cost. Moore"s law (1965) predicted that the power of a silicon chip of the same price would double every two years. Desktop, laptop, workstation, embedded, handheld, servers (supply resources over networks), mainframes (big shared computers, banks etc. An excel file is called a workbook. Each cell has a unique address (ex. Formulas (which always begin with an equal sign. Sum(a1:a5)) (the : means a range of cells) Can have two values: 1 or 0. Can represent numbers, text, codes, or instruction. Represents each character as a unique 8-bit code. A 16-bit character encoding scheme allowing characters from all major world languages. #n can be a number, range, or a function. Mode= the number that appears most often. V stands for vertical, so your data must be stored vertically in the spreadsheet. Syntax: vlookup(source cell, range of table, column of table)