LINC 63: CLOUD-BASED DATA ANALYSIS TOOLS
Foothill College Course Outline of Record
|Hours:||1 lecture per week (12 total per quarter)|
|Advisory:||Basic computer skills and knowledge of Macintosh or Windows operating systems and basic skills and knowledge of internet technologies, such as using web browsers, email, bookmarking, searching and downloading; not open to students with credit in LINC 269.|
|Degree & Credit Status:||Degree-Applicable Credit Course|
|Grade Type:||Letter Grade (Request for Pass/No Pass)|
Student Learning Outcomes
- A successful student will be able to build, edit, format worksheets.
- A successful student will be able to create and format charts.
- A successful student will be able to write formulas and use functions.
The student will be able to:
A. perform typical administrative tasks appropriate to a spreadsheet application.
B. apply new knowledge to real or simulated tasks involved in management and leadership.
C. use tools to produce graphical representations of the data contained in a spreadsheet.
A. Introduction to cloud-based data analysis tools and the common functionality of these tools, for example:
1. Microsoft Excel (Office 365)
2. Google Sheets
3. Apple Numbers
B. Using a spreadsheet tool for financial management and planning
1. Developing a spreadsheet structure
2. Entering financial data
3. Formatting cells
4. Using the subtotals
5. Entering simple functions
C. Using a spreadsheet as a simple database
1. Basic database concepts (e.g., field, record)
2. Constructing a simple database
3. Sorting and filtering data
4. Summarizing data
5. Creating a simple chart or graph
6. Importing data from another source
Special Facilities and/or Equipment
B. When taught via Foothill Global Access on the Internet: Students must have currently existing email accounts/email address and ongoing access to computers with email software, GUI web browsing capability, FTP program, and access to the World Wide Web.
Method(s) of Evaluation
The student will demonstrate proficiency by:
A. Creating a spreadsheet project using characteristics of quality defined by the class.
B. Writing an evaluation critique and reflection for their own and classmates' final projects, with emphasis on use of constructive comments and suggested improvements with respect to established characteristics of good multimedia design.
C. Instructor's evaluation of final project, including at minimum, a worksheet with formulas, tables, conditional cell formatting.
Method(s) of Instruction
During periods of instruction the student will be:
A. Listening actively to lecture presentations delivered in student-centered learning style by taking notes, following demonstrations, or completing an activity
B. Participating in facilitated discussions of live presentations, readings or video presentations
C. Presenting in small group and whole class situations
Representative Text(s) and Other Materials
Instructor-assigned notes and materials.
When course is taught online: Additional information, notes, handouts, syllabus, assignments, tests, and other relevant course material will be delivered by email and on the World Wide Web, and discussion may be handled with internet communication tools.
Types and/or Examples of Required Reading, Writing, and Outside of Class Assignments
A. Writing assignments include a project plan, peer evaluations, and critical analysis of technology tools, systems, or processes used.
B. Outside assignments include conducting project development, writing the project development plan, reading, and participating in online peer collaboration activities.
C. When taught online these methods may take the form of video, audio, animation and web page presentations. Assignments will be submitted online as well.