CSCI 194

Spreadsheet I - CIST 1503 (CSCI 150)

MAIN

Download/View SYLLABUS(PDF)
Download/View SYLLABUS (DOC)
How to create / execute a c++ file

Computer Science Degree/Certificate Checklists

BRCC (Baton Rouge Community College)
       AS Degree
    AAS Degree (Cloud Computing)
    AAS Degree (Computer Information Systems)
     AAS Degree (Cybersecurity)
     Network Certificate

LSU (Louisiana State University)
LSU Transfer Degree (AS)

SELU (Southeastern Louisiana University)
       Information Technology (AS)
       Pre MBA (AS)
       Scientific (AS)

SU (Southern University)
SU Transfer Degree (AS)

ULL (University of Louisiana Lafayette)
AS Computer Science
AS Informatics

* * * * * * * * * * * * * * * * * * * * *

CS Course Descriptions (CNET, CSCI, INTE)

Academic Calendar

Accommodated Testing

Tentative Course Outline

A. Using an Electronic Spreadsheet to Manage Financial Data
1. Introducing Electronic Spreadsheets
2. Navigating in a Workbook
3. Working with Ranges
4. Entering Information Into a Worksheet
5. Working With Rows and Columns
6. Printing Worksheets

B. Formulas and Functions
1. Working With Functions
2. Copying and Pasting Formulas
3. Relative and Absolute References
4. Logical Functions

C. Formatting a Worksheet
1. Formatting Data
2. Working With Headers and Footers Chapter
3. Working With the Print Area and Page Break

D. Charts
1. Creating a Chart
2. Working With a Chart
3. Printing a Chart

E. Lists
1. Creating a List
2. Sorting Data
3. Modifying a List
4. Inserting Subtotals Into a List

F. Working With Multiple Worksheets and Workbooks
1. Working With Multiple Worksheets
2. Using Templates
3. Working With Multiple Workbooks

G. Working With Editing and Web Tools
1. Using Auditing Tools to Trace Errors
2. Creating a Shared Workbook
3. Tracking Changes
4. Merging Workbooks
5. Publishing a Spreadsheet for a Web Site

H. Developing an Application
1. Planning an Application
2. Validating Data Entry
3. Protecting a Worksheet and Workbook
4. Working With Range Names
5. Creating and Using Macros

Finals

Book Title: Excel Complete/Comput Essentials SIMNET
Written by: Nordell
Publisher : McGraw Hill

ISBN-13: 9781264906215

COURSE DESCRIPTION: Introduces techniques for creating and maintaining spreadsheets. Uses current software applications such as Microsoft Excel.

Prerequisite: Eligibility for ENGL 1013 and MATH 1213.

INSTRUCTOR: David L. Sylvester, Sr., Professor
                                 Computer Science / Engineering / Mathematics Department
                                 Rm. 247, Cypress Bldg.
                                 (225) 216-8152

OFFICE HOURS:

EMAIL ADDRESS: sylvesterd@mybrcc.edu

                            Class Website: https://www.syl9.com
                            CANVAS's URL: https://mybrcc.instructure.com
                            LOLA's URL: https://my.lctcs.edu/cp/home/displaylogin
                            BRCC's URL: https://www.mybrcc.edu

- You are to click on the link below "Register / Sign Class Roll" then click on the "Register" button and proceed to register. For assistance you can click on the "How to Videos" link. Make sure you enter the correct Semester, Year and Section. This should be "Spring", "2023" and "2", respectively. * Class ID, when registering to sign the roll, would be the last four digits in your B# or L#. * Your first and last name should be the names that are registered with BRCC. * Once you have successfully registered, your logon ID will be in the format of first initial, last initial, last four numbers of your L#, dash (-), section number. EX: John Doe with the L#: L00281931 enrolled in section E01 will have a login ID: JD1913-1.

How to Videos